Business Systems Analyst IV (Business Intelligence)

Location: VA Winchester - Operations Full/Part Time: Full-Time Regular/Temporary: Regular

Job Description


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 2021 Best for Vets Employers
• WayUp Top 100 Internship Programs
• Forbes® 2022 The Best Employers for New Grads
• Forbes® America's Best Employers
• Newsweek Top 100 Most Loved Workplaces
Fortune Best Workplaces for Women
Fortune 100 Best Companies to Work For®
• Computerworld® Best Places to Work in IT

Basic Purpose

To plan and develop actionable strategic costing business intelligence in consultation with management and business units to enable decision making. Establish and recommend industry best practices and standards to create optimum solutions that improve business performance. Work independently within assigned areas of responsibility.


• Develop the design and build of business intelligence solutions including requirements gathering, design, production implementation and maintenance for the Corporate Activity-Based Costing (ABC) system
• Develop and recommend development of dashboards, customized reports and scorecards based on business requirements
• Load data marts via common schemas (e.g. Star/Snowflake) using database normalization.  Denormalize and flatten structures for optimized reporting.
• Execute ad hoc analytic requests for online transactional processing (OLTP) and online analytical processing (OLAP) systems in an accurate and efficient manner.
• Review and optimize medium to complex SQL queries, review optimization work on simple complexity SQL queries, and investigate database performance issues
• Design and build medium to complex algorithms and stored procedures, review work completed on simple complexity algorithms and stored procedures supporting ABC data enrichment
• Conduct development and production support activities across multiple environments with a keen understanding of costing systems configuration and key ABC concepts
• Collaborate with business areas to understand business processes and organizational constructs in order to develop technical solutions; design, test, and implement new systems, enhancements and modifications
• Identify, diagnose, and correct problems that occur within databases and application interfaces to improve efficiency and ensure data integrity
• Guide the implementation of new and enhanced processes
• Review data dictionary, run sheets
• Support creating business insights and compelling narratives using data and leveraging new product features as applicable
• Conduct analytical studies to provide results/recommendations to senior management for department and enterprise-wide strategic initiatives
• Develop, construct, test, and maintain data architectures to meet business needs using programming language and tools
• Identify areas of improvement; recommend solutions; implement enhancements/changes to improve operations, standards, and results
• Experience leading, guiding, and mentoring less experienced staff
• Performs other duties as assigned
                                                                                                                                                                                                                                                                              Required Qualifications:

• Bachelor’s Degree in Computer Science, or the equivalent combination of training, education and experience
• Understanding of disciplined approach towards Data Visualization and Reporting.
• Extensive experience with SQL databases and data architecture.
• Significant research, problem solving, and data analysis skills
• Significant experience with at least one major BI/Reporting Application.
• Familiarity with databases, OLAP, and OLTP concepts
• Significant experience working and participating in cross-functional, multi-dimensional teams and projects
• Extensive experience in multidimensional data modeling; star schemas, snowflakes, denormalized models, managing slow-changing dimensions/attributes.
• Experience in setting up complex ETL processes, involving relational and non-relational data.
• Advanced skill communicating complex technical concepts to non-technical audiences
• Expert database and presentation software skills
• Significant knowledge of data structures and interaction between applications and data.
• Experience in organizational, planning and time management skills
• Significant experience in leading, guiding and mentoring others
• Familiarity with SQL Server, SSIS, Oracle Enterprise Performance Management, Oracle Profitability and Cost Management, Oracle Enterprise Data Management, Oracle Essbase, Hadoop, Informatica
• Exposure to complete lifecycle of at least one data warehouse/Business Intelligence program at Enterprise scale

Desired Qualifications:

• Master’s Degree in Computer Science, or the equivalent combination of training, education and experience
• Familiarity with Activity Based Costing or Cost Accounting Software
• Knowledge of accounting, cost accounting, or finance
 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 on-site 4-16 days each month. The number of days reporting on-site will ultimately be determined by the employee's leadership and business unit needs. You will learn more throughout the hiring and on boarding process.

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.

Salary Range: $85,500- $ 146,300

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.

Posting End Date: 03/28/2023

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.

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


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.

Bank Secrecy Act

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