About the JobWe are seeking a highly skilled and experienced Senior Program Control Analyst who will be reporting into our Vice President, Financial Planning & Analysis. The ideal candidate will have a strong background in project forecasting, variance reporting, and excel modeling. As a Senior Program Control Analyst, you will play a crucial role in financial planning, monitoring, and reporting, ensuring the success of our projects.
Duties & ResponsibilitiesProject Forecasting and Budgeting:
- Collaborate with project managers to develop accurate project forecasts and budgets, to include cost drivers, collections, unbilled and aging consideration.
- Analyze historical project data to inform future budgeting and forecasting decisions.
- Ensure alignment of financial plans with project goals and objectives.
- Develop quarterly Estimates at Complete (EAC). Analyze and assist in generating accurate Estimates to Complete (ETC).
Variance Reporting:
- Regularly monitor project financials and identify and analyze variances.
- Provide detailed explanations for budget variances and recommend corrective actions.
- Work closely with project teams to understand and address financial discrepancies.
Excel Modeling:
- Utilize intermediate to advanced Excel skills to create and maintain complex financial models.
- Develop and enhance financial reporting templates to improve accuracy and efficiency.
- Conduct in-depth analysis of financial data using functions such as VLOOKUPs, SUMIFS, and Pivot Tables.
ERP System Expertise:
- Demonstrate proficiency in Deltek Costpoint as an ERP system.
- Use Costpoint to input and extract financial data accurately.
- Collaborate with IT and finance teams to ensure seamless integration and data accuracy.
- Review and ensure project setups meet the requirements of the contract and internal tracking needs of the program team.
Financial Analysis:
- Partner with Program Managers to ensure they have a solid understanding of their program's financial status, commitments, and the impacts of changes in cost and schedule.
- Provide insightful financial analysis to support decision-making processes.
- Conduct regular reviews of financial performance and recommend adjustments as needed.
- Support the month-end close process, ensuring costs are appropriately recorded and revenue recognition is accurate.
- Assist in the preparation of financial presentations for leadership.
- Other duties as assigned.
Required Qualifications- Bachelor's degree in Finance, Accounting, Business, or related field.
- Minimum of 5 years of experience as a Program Control Analyst or in a similar role in a government contracting environment.
- Understanding of government contracting and various contract types (FFP, T&M, CPFF, etc.).
- Strong expertise in project forecasting, budgeting, and variance analysis.
- Intermediate to advanced proficiency in Microsoft Excel, including VLOOKUPs, SUMIFS, and Pivot Tables.
- Experience with Deltek Costpoint ERP system is a must.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills.
