Senior Project Cost Analyst

ComEd•Oakbrook Terrace, IL

About The Position

We're powering a cleaner, brighter future. Exelon is leading the energy transformation, and we're calling all problem solvers, innovators, community builders and change makers. Work with us to deliver solutions that make our diverse cities and communities stronger, healthier and more resilient. We're powered by purpose-driven people like you who believe in being inclusive and creative, and value safety, innovation, integrity and community service. We are a Fortune 200 company, 19,000 colleagues strong serving more than 10 million customers at six energy companies -- Atlantic City Electric (ACE), Baltimore Gas and Electric (BGE), Commonwealth Edison (ComEd), Delmarva Power & Light (DPL), PECO Energy Company (PECO), and Potomac Electric Power Company (Pepco). In our relentless pursuit of excellence, we elevate diverse voices, fresh perspectives and bold thinking. And since we know transforming the future of energy is hard work, we provide competitive compensation, incentives, excellent benefits and the opportunity to build a rewarding career. Are you in? Primary Purpose Provide project controls cost engineering support to Directors, Manager of Projects, Project Managers, contractors and other key team members. Develop and monitor the annual budgets, actual and forecasted costs, and Long Range Plans for transmission, substation, distribution, and gas (PECO and BGE) projects and programs. Utilize multiple existing Exelon systems to support current and future work with respect to budgeting, financial forecasting, actual cost tracking, project authorization, work management, contracts, and material tracking. Provide broad analytical and operational support to the business unit. Prepare comprehensive reports to support business operations including reauthorization risk, forecast accuracy by Project Managers, program and department, CIAC forecast and analysis, contingency released and remaining, and others as requested. Utilize WPT to create PAR forms, ITN's, Project IDs, and update financial plan types. Coordinate project authorization process including updating decks for all centrally managed projects. Schedule and run monthly project status calls. Track and manage In-Service Dates and Project Aging PIs. Primary Duties Manage project forecasting, accrual, and status process. Attend required meetings and reach out to project stakeholders for detailed project information. Identify project/program budget, forecast, and authorization issues early and assist in developing resolutions to meet project metrics. Assist in the development and continued monitoring of the budgets and LRPs for transmission, sub-station, distribution, and gas (PECO and BGE) projects and programs. Monitor, track, and report project budgets, forecasts, accruals, and actuals Manage project and program financial risks and opportunities and provide detailed analysis of variances to budget, quarterly plan, and month over month variance analysis. Support project management at resulting financial challenge meetings. Develop, organize, and present project and program performance reports for both internal and external use. (10%) Schedule and facilitate monthly forecasting and accrual meetings and prepare monthly project accruals and journal entries for project manager review and submittal to Finance department before submittal to Finance group, reporting variances and issues to both the project management and project controls leadership. (10%) Analyze project actual and forecast data accuracy to ensure compliance with annual internal and external Sarbanes Oxley Audits. Manage the vendor forecasting process which is used as a source of input for both forecasting and accruals by Project Controls. Provide support to Project Managers for presentations and forms required for project authorization. Job Scope This is an individual contributor position that works independently with only general direction, relying on knowledge skills and judgment acquired through education and relevant experience to plan and accomplish assigned tasks and goals. The position regularly mentors less experienced colleagues. Position requires routine interaction with key internal and external stakeholders, executives, directors, managers and staff across the organization. May require working extended hours and/or shift work to support business operations.

Requirements

Bachelor's degree in Business, Financial or Technical Field.
4-7 years related experience, or in lieu of Bachelor's degree, 6-9 years relevant business experience is required.
Comprehensive understanding of applicable standards, methods, processes and practices, business fundamentals, and performance metrics in the specific functional area supported by this position (e.g., asset management, electric or gas operations, customer service, transmission and substation, distribution system operations, regulatory and external affairs, transmission operations and planning).
Ability to provide in-depth analysis and apply forecasting, analytical and statistical problem solving, financial, accounting, and budget analysis.
Demonstrated strong analytical skills for project financial evaluation and risk identification and mitigation.
Customer driven with strong oral and written communications skills and strong analytical, problem solving and project management skills.
Comprehensive knowledge of the financial / cost analyst practices, procedures and principles of performance analysis (trending, root cause and gap analysis) benchmarking and audit compliance.
Ability to analyze organizational data and complex problems, interpret and recommend alternative courses of action, and implement intervention strategies to attain performance targets.
Demonstrated strong analytical skills for project evaluation including analysis of complex projects with economic, financial, risk and decision analysis.

Nice To Haves

Financial advanced degree.
5-8 years project cost tracking experience in electric / gas transmission, distribution, and substation industry
Advanced proficiency in standard software applications (e.g., Microsoft Word, Excel, Access, PowerPoint, Project), specialized business technologies and applications (e.g., , project management, WPT, Asset Suite 8, CIS, EPS, forecasting,) to retrieve and analyze data in support of business needs
Proficient in business case development and ability to effectively present business cases to business unit leadership.

Responsibilities

Manage project forecasting, accrual, and status process.
Attend required meetings and reach out to project stakeholders for detailed project information.
Identify project/program budget, forecast, and authorization issues early and assist in developing resolutions to meet project metrics.
Assist in the development and continued monitoring of the budgets and LRPs for transmission, sub-station, distribution, and gas (PECO and BGE) projects and programs.
Monitor, track, and report project budgets, forecasts, accruals, and actuals
Manage project and program financial risks and opportunities and provide detailed analysis of variances to budget, quarterly plan, and month over month variance analysis.
Support project management at resulting financial challenge meetings.
Develop, organize, and present project and program performance reports for both internal and external use.
Schedule and facilitate monthly forecasting and accrual meetings and prepare monthly project accruals and journal entries for project manager review and submittal to Finance department before submittal to Finance group, reporting variances and issues to both the project management and project controls leadership.
Analyze project actual and forecast data accuracy to ensure compliance with annual internal and external Sarbanes Oxley Audits.
Manage the vendor forecasting process which is used as a source of input for both forecasting and accruals by Project Controls.
Provide support to Project Managers for presentations and forms required for project authorization.

Benefits

Annual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $85,600.00/Yr. – $117,700.00/Yr.
Annual Bonus for eligible positions: 15%
401(k) match and annual company contribution
Medical, dental and vision insurance
Life and disability insurance
Generous paid time off options, including vacation, sick time, floating and fixed holidays, maternity leave and bonding/primary caregiver leave or parental leave
Employee Assistance Program and resources for mental and emotional support
Wellbeing programs such as tuition reimbursement, adoption and surrogacy assistance and fitness reimbursement
Referral bonus program
And much more
Note: Exelon-sponsored compensation and benefit programs may vary or not apply based on length of service, job grade, job classification or represented status. Eligibility will be determined by the written plan or program documents.