Overview

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.

Responsibilities

• 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 process

• 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

• Perform other duties as assigned

Qualifications

• Working knowledge of disciplined approach towards Data Visualization and Reporting.

• Significant experience with SQL databases and data architecture

• 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

• Significant 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

• Advanced knowledge of data structures and interaction between applications and data

• 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

• Experience leading, guiding, and mentoring less experienced staff

• Effective skill at communicating complex technical concepts to non-technical audiences

• Advanced organizational, planning and time management skills

• Expert database and presentation software skills

• Advanced research, problem solving, and data analysis skills

• Bachelor’s Degree in Computer Science, or the equivalent combination of training, education and experience

Desired Qualifications

• Familiarity with Activity Based Costing or Cost Accounting Software

• Advanced knowledge of accounting, cost accounting, or finance

• Master’s Degree in Computer Science, or the equivalent combination of training, education and experience

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

Locations: 820 Follin Ln. Vienna, Virginia 22180 | 5550 Heritage Oaks Dr. Pensacola, FL 32526

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.

REQNUMBER: 17892-OTHLOC-300000025810540