Senior Associate, Business Intelligence Analyst
About The Position
The Business Intelligence Analyst (BIA) will report to the Program Quality Manager as part of the Quality Organization. This position will support a dynamic, fast-paced organization by providing financial analysis within a matrixed organization. Responsibilities include forecasting, managing Estimates at Completion (EACs), allocating budgets in alignment with program needs and bid assumptions, developing and maintaining metrics and dashboards, and analyzing and communicating forecast variances using advanced Excel skills. This role will partner with stakeholders across the organization to drive financial performance and collaborate with leadership to identify risks and opportunities, support the achievement of financial objectives, and evaluate budgets and program performance against bids. The position will be the focal point for all financial (direct and indirect budgets) related matters pertaining to the Quality organization.
Requirements
- Bachelor’s degree in Business, Analytics/Statistics, Finance, or related field and a minimum of 2 years of prior related experience.
- In lieu of a degree, a minimum of 6 years of prior related experience in Business Analytics.
- Demonstrated experience with Excel, Access, Microsoft Word applications.
- Demonstrated experience with Spreadsheets: Using Excel features like pivot tables and Vlookups for rapid, localized analysis.
Nice To Haves
- Graduate Degree or equivalent with 0 to 2 years of prior related experience.
- Familiarity with Quality roles and responsibilities within a Quality Management System (QMS).
- Experience with Data Warehousing: Understanding cloud platforms like Snowflake, Google BigQuery, or AWS Redshift and ETL data pipelines.
- Experience with SQL: Querying, cleaning, and shaping data straight from relational databases.
- Experience with Visualization Tools like Tableau or Microsoft Power BI for interactive dashboards.
- Advanced Excel skills (PivotTables, Power Query, VBA/Macros, etc.) and proficiency in Microsoft Office applications, including Word, PowerPoint, and Access.
- Experience with Power BI; knowledge of dashboard development and data visualization is a plus.
- Experience with budgeting, forecasting, EAC management, variance analysis, and financial reporting.
- Familiarity with earned value metrics, including CPI.
- Active DoW security clearance preferred.
Responsibilities
- Analyze financial and operational data, allocate costs, and prepare reports that identify detailed variance drivers.
- Ensure costs are allocated in accordance with established procedures, policies, and program requirements.
- Gather and analyze historical data related to material purchases, labor, repairs, assembly, and operating expenses to support forecasting and decision-making.
- Review and analyze bids for future efforts and update forecasts to reflect revisions in scope, pricing, or assumptions.
- Prepare reports comparing budgets, forecasts, and actual results, and support the development of existing and projected CPI metrics, as applicable.
- Compile, review, and maintain budgets using actual performance, prior budget data, estimates to complete, and other relevant inputs to manage EACs and support sound financial management.
- Prepare forecasts, monitor program performance, and measure actual results against plan.
- Develop and maintain earned value-based program metrics and performance reporting.
- Coordinate manpower planning discussions to support resource forecasting and deliverable execution.
- Position requires the ability to obtain and maintain a security clearance.
- Will collaborate with Quality leadership and representatives.
- Will manage competing priorities and ad hoc requests with short response windows.
- Other duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
