Data Analyst II

Overview

Perform complex analytical and statistical modeling on large data sets to support various business operations and organizational objectives. Define data requirements, perform data collection, processing, cleaning, analysis, modeling and visualization. Identify data patterns and trends to answer business questions and improve decision making. Identify opportunities to increase efficiency and automation of data analysis processes and procedures. Participate on complex, essential projects working under minimal supervision and with latitude for independent judgment. Accountable for completion of assigned projects and deliverables. Highly skilled and proficient in discipline with demonstrated achievement of results.

Responsibilities

• Develop, maintain, and manage advanced reporting, dashboards, data models and analytical results
• Evaluate and define functional requirements for analytics and business intelligence (BI) solutions
• Retrieve, analyze and validate data and test accuracy of reported results
• Work directly with project leads to understand requirements and propose key analytics solutions to drive effective decision-making and influence business objectives
• Produce actionable reports that demonstrate key performance indicators, identify areas of improvement for current operations, and show root cause analysis of problems
• Analyze and summarize business operations, customer and/or economic data in order to improve business intelligence, optimize operating effectiveness and predict business outcomes
• Identify trends and patterns in business data; create data visualizations to support business decision making
• Build new and/or modify existing database/data warehouse/data mart and business intelligence solutions to meet business and system requirements
• Collaborate with business units and senior management to conduct needs assessment to support business unit objectives
• Support complex Data Science and Big Data projects
• Effectively communicate data outcomes to business stakeholders and leadership
• Mentor and guide less experienced staff Metadata Analyst Specific Responsibilities
• Work with business units to collect, review, and publish Metadata
• Maintain and enhance Data Catalog (e.g., Purview) and PowerBI Reports
• Evaluate and enhance the Data Governance & Metadata Collection Framework
• Perform other duties as assigned
  
  
  

Qualifications

• Significant experience in the application of statistical methods, mathematical techniques, forecasting, cost-benefit analysis, related analytical tools and programming languages
• Significant experience in problem resolution including determining root cause, scope and scale of issues
• Significant experience that demonstrates the ability to research, compile, and document data, business processes, and workflow
• Working knowledge of standard ETL tools and techniques
• Working knowledge of the process in sourcing raw data and cleansing techniques
• Working knowledge of data warehousing, data cleaning, and other analytical techniques required for data usage
• Advanced knowledge of and the ability to perform basic statistical analysis such as measures of central tendency, normal distribution, variance, standard deviation, basic tests, correlation, and regression techniques
• Working knowledge of data models, design tools, business/technical requirements, statistical programming languages, data queries
• Demonstrates a key understanding of multiple database concepts and data flows
• Working knowledge of various data structures and ability to extract data sources (e.g., PySpark, PowerBI)
• Working knowledge of mapping techniques and data pipelines
• Advanced skill interpreting, extrapolating and interpolating data for statistical research and modeling
• Advanced skill analyzing statistics and reports to determine business performance and trends
• Advanced skill identifying and analyzing business requirements and recommending solutions
• Effective skill presenting findings, conclusions, alternatives and information clearly and concisely
• Advanced skill in understanding and communicating data presented in models, charts, and tables and transforming it into a format that is useful to the business and aids effective decision making
• Advanced skill in the use of measurement and statistical practices to analyze current and historical data to make predictions, identify risks, and opportunities enabling better decisions on planned/future events
• Advanced skill in understanding and analyzing models that predict the probability of an outcome
• Advanced skill in collecting and manipulating data used in effective decision making
• Advanced SQL skills
• Advanced Microsoft Excel skills
• Bachelor's degree in Information Systems, Computer Science, Engineering, or a related field, or the equivalent combination of training, education and experience
  
  
  

Desired Qualification(s)

• Working knowledge of Navy Federal Human Resources policies, procedures, and programs
• Working knowledge of Operational Transaction Processing (OLAP/OLTP) applications and systems
• PMP Certification (or commensurate experience managing corporate-wide projects)
• Advanced degree in Information Systems, Computer Science, Engineering, or related field
• Experience with SQL Server and Teradata relationship database design, extract/transform/load scripting, and data quality monitoring
• Experience with Python coding and Github action automation
  
  
  

Hours: Monday - Friday, 8:30AM - 5:00PM

Locations: 820 Follin Lane, Vienna, VA 22180 | 5510 Heritage Oaks Drive, Pensacola, FL 32526 | 141 Security Drive, Winchester, VA 22602

About Us

You have goals, dreams, hobbies, and things you're passionate about—what's important to you is important to us. We're looking for people who not only want to do meaningful, challenging work, keep their skills sharp and move ahead, but who also take time for the things that matter to them—friends, family, and passions. And we're looking for team members who are passionate about our mission—making a difference in military members' and their families' lives. Together, we can make it happen. Don't take our word for it:

• Military Times 2022 Best for Vets Employers
• WayUp Top 100 Internship Programs
• Forbes® 2022 The Best Employers for New Grads
• Fortune Best Workplaces for Women
• Fortune 100 Best Companies to Work For®
• Computerworld® Best Places to Work in IT
• Ripplematch Campus Forward Award - Excellence in Early Career Hiring
• Fortune Best Place to Work for Financial and Insurance Services
  
  
  

Equal Employment Opportunity: Navy Federal values, celebrates, and enacts diversity in the workplace. Navy Federal takes affirmative action to employ and advance in employment qualified individuals with disabilities, disabled veterans, Armed Forces service medal veterans, recently separated veterans, and other protected veterans. EOE/AA/M/F/Veteran/Disability EOE/AA/M/F/Veteran/Disability

Disclaimers: Navy Federal reserves the right to fill this role at a higher/lower grade level based on business need. An assessment may be required to compete for this position. 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. 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

Bank Secrecy Act: Remains cognizant of and adheres to Navy Federal policies and procedures, and regulations pertaining to the Bank Secrecy Act.