Senior Associate, Business Intelligence Analyst

Job description

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: Bachelor’s 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