Senior Associate, Business Intelligence Analyst

Job Title: Senior Associate Business Intelligence Analyst

Job Code: 42580

Job Location: Greenville TX

Job Schedule: 9/80 - Employees work 9 out of every 14 days totaling 80 hours worked and have every other Friday off.

Job Description:

The Senior Associate Business Analyst will support a dynamic fast-paced organization by providing financial analysis within a matrixed environment. 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.

Essential Functions:

• 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 which requires US citizenship.
• Must have good communication skills.
• Must be able to work independently for short durations.

Qualifications:

• Bachelors Degree Business Analytics/Statistics or related field and a minimum of 2 years of prior related experience.
• Graduate Degree or equivalent with 0 to 2 years of prior related experience.
• In lieu of a degree a minimum of 6 years of prior related experience in Business Analytics.
• Demonstrated operating knowledge of Excel Access Microsoft Word applications.
• Demonstrated experience with Spreadsheets: Using Excel features like pivot tables and Vlookups for rapid localized analysis.

Preferred Additional Skills:

• Demonstrated experience with Data Warehousing: Understanding cloud platforms like Snowflake Google BigQuery or AWS Redshift and ETL data pipelines.
• Demonstrated experience with SQL: Querying cleaning and shaping data straight from relational databases.
• Demonstrated 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.

#LI-AM2