Sr Project Cost Analyst (Hybrid)
Description Be a part of something powerful at America's leading energy provider!At Exelon, our people are the heart and soul of our business. Whether it's powering lives, supporting communities or collaborating with colleagues, an Exelon employee is talented, compassionate, forward-thinking and inspired. We are a Fortune 200 company united by our values and shared vision for a cleaner and brighter future. We encourage curiosity, value diverse perspectives and we never stop looking for ways to be, work and do better. We know the future is in our hands. That's why we're looking for people like you, who have the power to make a difference.As the nation's largest utility company, we serve more than 10 million customers through six fully regulated transmission and distribution utilitiesAtlantic 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). All 18,000 of us are committed to delivering safe, reliable and affordable energy to our customers, strengthening our communities, supporting a clean energy future and reducing our impact on the changing climate.Our people are empowered to evolve and advance their careers in an open and inclusive environment. We pride ourselves on being the kind of place where people want to come, stay and growwhether that's in the role and path they start in or in new and exciting career opportunities across our business. We know that investing in our employees' futures strengthens ours, which is why we offer competitive compensation, incentives, opportunities for career path changes, and health and retirement benefits.PRIMARY PURPOSE OF POSITIONProvide 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 AND ACCOUNTABILITIESManage 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. JOB SCOPEThis 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.Qualifications MINIMUM QUALIFICATIONSAcademic/Formal Training: Bachelor's degree in Business or Technical Field. Job Related/Experience: 5 - 8 years related experience, or in lieu of Bachelor's degree, a minimum of 9 - 12 years relevant business experience is required. Specialized Skills, Knowledge, License Requirements/Registrations, Etc.:Comprehensive understanding of applicable standards, methods, processes and practices, business fundamentals, and performance metrics in the specific functional area supported by this position (eg, 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. PREFERRED QUALIFICATIONSFinancial advanced degree. 5-8 years project cost tracking experience in electric / gas transmission, distribution, and substation industry Advanced proficiency in standard software applications (eg, Microsoft Word, Excel, Access, PowerPoint, Project), specialized business technologies and applications (eg, , 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.