Job Description:
• Support the creation of Estimates at Complete (EACs) on a quarterly basis including costs, risks, and opportunities at the Program / Mission Area level.
• Broad responsibility which includes analysis requirements for contractual Earned Value (EV) contracts.
• Perform detailed financial analysis for both total program and mission area cost elements to help define and understand the monthly variances to budget baseline and EAC positions.
• Prepare program financial forecasts, monitor actual costs, and explain variances to plans and forecasts.
• Support the preparation of cost estimates for new business proposals and assist Estimating and Program Analysts in developing rationale for basis of estimates.
• Assist in developing a new RMD Material EAC Model tool suite, to assist other Financial Analysts in developing EAC positions in a consistent/efficient manner.
• Development and maintenance of Work Breakdown Structures (WBS) in APEX/SAP, Budget preparation.
Requirements:
• A University Degree or equivalent experience and minimum 5 years prior relevant experience, or an Advanced Degree in a related field and minimum 3 years experience
• Experienced with desktop computer skills, particularly in the use of the MS Office suite with an emphasis in Excel
• Experience with finance tools
• Experience comparing actuals vs budget and explaining variances
• Strong experience with Excel (pivot tables, advanced formulas)
• Experience using other Microsoft Office tools (including Word and PowerPoint)
• Experience using financial software systems
• Analytical, problem solving and decision-making skills
• Able to meet critical deadlines and develop and apply solutions and process improvements in a fast paced changing business environment.
• Advanced Excel skills (Power Query, Power Pivot, VBA, SQL).
• Experience in using SAP Business Systems (APEX, PRISM, Business Warehouse)
Benefits:
• medical, dental, vision, life insurance
• short-term disability
• long-term disability
• 401(k) match
• flexible spending accounts
• flexible work schedules
• employee assistance program
• Employee Scholar Program
• parental leave
• paid time off
• holidays