Project Financial Analyst

WHO WE AREAs the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose: accelerating the transition to a carbon-free future. We have been the leader in clean energy production for more than a decade, and we are cultivating a workplace where our employees can grow, thrive, and contribute. Our culture and employee experience make it clear: We are powered by passion and purpose. Together, we're creating healthier communities and a cleaner planet, and our people are the driving force behind our success. At Constellation, you can build a fulfilling career with opportunities to learn, grow and make an impact. By doing our best work and meeting new challenges, we can accomplish great things and help fight climate change. Join us to lead the clean energy future. TOTAL REWARDSConstellation offers a wide range of benefits and rewards to help our employees thrive professionally and personally. We provide competitive compensation and benefits that support both employees and their families, helping them prepare for the future. In addition to highly competitive salaries, we offer a bonus program, 401(k) with company match, employee stock purchase program comprehensive medical, dental and vision benefits, including a robust wellness program paid time off for vacation, holidays, and sick days and much more. Expected salary range of $92,700 to $103,000, varies based on experience, along with comprehensive benefits package that includes bonus and 401(k). PRIMARY PURPOSE OF POSITIONTo support Constellation organizations in the monitoring and controlling of project budget, forecasts and expenditures through the development of project checkbooks and analysis of current and future expenditures. PRIMARY DUTIES AND ACCOUNTABILITIESApplies financial management tools and skills to prepare project checkbooks with input from the project manager that accurately reflect monthly/yearly budgets, forecast of future spends, and actual monthly expenditures. Processes approved Project Change Requests (PCRs) to update budgets in the project checkbook tool. Checkbooks are updated monthly and used to support monthly project financial debriefs. Routinely reviews and analyzes assigned checkbooks to seek out missing or incomplete project data (authorization history, milestone dates, form 4's, contract and requisition numbers, risk and opportunities sheets, etc).Perform detailed analysis of real time monthly project expenditures to ensure costs are properly coded and identify project fiscal discrepancies. Assist project manager with resolution of discrepancies through communications with appropriate vendors or departments.Assists project managers in preparing, updating and analyzing project checkbooks including forecasts, actual costs, and budgets by taking into account previous month expenditures and accruals/CPAs. Identify any challenges to current year or project overall budget. As part of the forecast, develop project risks and opportunities to the project yearly budget.Perform Ad-hoc analysis and special projects relevant to financial controls: Focused area assessments (FASAs), benchmarking visits / studies, business plan initiatives, procedure revisions or new procedure creation, and training sessions.Assists the project manager in the development of PRC and NSAC financial presentations, monthly project reports, and CNO bi-monthly project reviews. Also provide project managers with financial guidance to keep within Constellation accounting practices.Post Implementation Appraisals (PIAs).  Works with project managers to coordinate the review of project post implementation appraisals or PIAs. Compiles and trends the results of PIAs to further the knowledge and understanding of project successes and failures. Communicates results of PIAs annually to the project management peer group. MINIMUM QUALIFICATIONSBachelor's degree (financial or engineering/construction management) with at least 5 years experience in financial budgeting, cost and/or project estimating experience.OrAt least 8 years experience in financial budgeting, cost and/or project estimating experience in related industry.Effective analytical skills combined with strong written and verbal skills.Thorough computer-based analytical skills (e.g. Access, Excel-based analysis) PREFERRED QUALIFICATIONSMBA and /or CPA or PMPExpertise in Microsoft Excel and Oracle financial systems