Navy Federal Credit Union | Lead, Security Fraud Systems (ETL Developer) | Pensacola, FL | United States | BigDataKB.com | 13 Oct 2022

To lead, manage, and develop data sourcing strategies, designs, and implementation for Navy Federal’s Security Fraud Division’s Data Warehouse. Design, build, and integrate data from various sources in support of predictive and adaptive analytics. This role will work with IT personnel, product owners and multiple teams to build automated data sourcing pipelines needed to support data in alignment with Navy Federal standards and guidelines. May lead functional teams or projects and solve highly complex problems, taking a broad perspective to identify solutions and technologies.

Responsibilities:
Navy Federal’s Security Fraud Division team has undertaken an effort to migrate existing database warehouse from on premise to the Cloud. The Lead, Security Fraud Systems will lead efforts to

• Lead the consolidation of fraud data and the migration of fraud data warehousing to the Cloud for Security Fraud Division
• Lead efforts of identifying data sources and processes in support of highly visible technical initiatives for the Cloud migration
• Organize the collection, processing, and analysis of data to produce and continuously update the use case queues for Fraud Operations. This includes managing the data extraction process for the purpose of data warehousing.
• Partner with Security Fraud Analytics, IT, and relevant BU SMEs to help teams define and identify data sources, create repeatable data collection processes, and ensure consistent data quality and data ingestion for fraud detection.
• Analyze data to discern lessons learned and action items to improve security fraud detection performance and risk posture; partner with the appropriate teams to help them understand how the data can drive improvements
• Lead initiatives to fine tune an existing data warehousing, on a SQL Server until its full migration to the Cloud, of member and product information extracted from sources across IT and other departments, including executing data normalization steps
• Identify and determine acceptable risk tolerance levels to establish information classification standards
• Lead and cooperate with Fraud Analytics on the design and implement data frameworks and pipelines to process data from on-premises and cloud data sources to feed into the data warehouse, monitor data quality and implement related controls
• Lead the evaluation of existing designs, improve methods, and implement optimizations
• Lead efforts of ensuring the security and integrity of solutions including compliance with Navy Federal, industry engineering and Information Security principles and practices
• Lead the analysis and validation of data sharing requirements within and outside data partners
• Analyze and interpret collected data; identifying trends; writing reports and recommendations for internal or external clients
• Use statistical practices to analyze current and historical data to make predictions, identify risks, and opportunities enabling better decisions on planned/future events
• Work with business unit leadership to understand data requirements; propose and develop solutions that enable effective decision-making and drive business objectives
• Lead and drive best practices for data analysis, data engineering, and evangelize their usages
• Lead efforts to prepare project deliverables that are valued by the business and present them in such a manner that they are readily understood by project stakeholders
• Prepare advanced project implementation plans using Agile methodologies, which highlight milestones and deliverables, leveraging standards, practices, and work planning tools
• Recognize potential issues and risks during the analytics project implementation and recommend mitigation strategies
• Coach and mentor project team members in carrying out analytics project implementation activities
• Perform other duties as assigned

Qualifications and Education Requirements:

• Bachelor’s degree in Information Systems, Computer Science, Engineering, or related field, or the equivalent combination of education, training, and experience
• Significant SQL ETL development experience; ability to own and maintain SQL databases, connectors, feeds, and APIs from systems that provide metrics data.
• Develop and maintain dynamic ETL framework
• Strong experience using the MS Azure technology stack
• Strong Azure DevOps – Databricks, Data Factory, Synapse
• Expert experience in a variety of coding languages (SQL, Python, Notebook, PowerShell)
• Advanced knowledge in SSMS
• Ability to analyze data using Excel including use of complex Excel macros / scripts for reporting and data mining purposes from sources such as SQL databases, SharePoint and other enterprise data repositories is essential; some development experience with data extraction is preferable
• Ability to work individually, and as part of a team
• Experience in risk mitigation
• Experience with fraud detection and mitigation concepts, principles, technologies, and methods, and translating best practices in information security to operations in a risk management framework
• Advanced knowledge of information technology systems, processes, and application development
• Advanced organizational, planning and time management skills
• Advanced research, analytical, and problem-solving skills
• Advanced skill developing and implementing programs in a leadership role
• Advanced skill building effective relationships with all levels of staff, management, stakeholders, and vendors, through rapport, trust, diplomacy, and tact
• Significant experience working with internal audit and external examiners
• Significant experience collaborating across organizational boundaries and building partnerships across functions
• Effective skill to influence, negotiate and persuade to reach agreeable exchange and positive outcomes
• Advanced skill exercising initiative and using good judgment to make sound decisions
• Advanced verbal, written, interpersonal, and presentation skills to communicate clearly and concisely technical and non-technical information to all levels of management
• Strong presentation skills: ability to adjust message and filter details based on audience (e.g., technical, business, management)
• Advanced level PowerPoint and Excel skills

Desired Qualifications and Education Requirements:

• Professional certification in the Microsoft Azure (Azure Cosmos DB Developer, Azure Data Engineer, Azure Database Administrator)
• Ability to interpret complex mainframe copybooks, and XML data
• Experience using APIs and data gateways for synchronous/asynchronous data ingestion and distribution
• Experience with Power BI and data visualization concepts and tools.
• Experience with data mining, pattern matching, forecasting, sentiment analysis, cluster analysis or similar
• Experience with Splunk, Archer and ServiceNow is preferable
• Experience providing technical and data leadership to application development teams
• Prior experience in the Financial Industry

Hours: Monday – Friday, 8:00am – 4:30pm

Location: 820 Follin Lane, Vienna, VA 22180 | 5550 Heritage Oaks Dr Pensacola, FL 32526 | 141 Security Dr. Winchester, VA 22602

• Navy Federal is now hybrid! Our standard enterprise requirement for a hybrid schedule is to report onsite 4-16 days each month. The number of days reporting onsite will ultimately be determined by the employee’s leadership and business unit needs. You will learn more throughout the hiring and onboarding process.

Salary: Navy Federal Credit Union assesses market data to establish salary ranges that enable us to remain competitive. You are paid within the salary range, based on your experience, location and market position.

The salary range for this position is: $95,600 to $163,500 Annual

Posting End Date: 10/31/2022

Job postings are subject to close early or extend out longer than the anticipated closing date at the hiring team’s discretion based on qualified applicant volume.