Sr Project Cost Analyst

Who We Are 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 PRIMARY PURPOSE OF POSITION 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 PRIMARY DUTIES AND ACCOUNTABILITIES 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. (25%) 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 (20%) 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. (15%) 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. (10%) Manage the vendor forecasting process which is used as a source of input for both forecasting and accruals by Project Controls. (5%) Provide support to Project Managers for presentations and forms required for project authorization. (5%) Job Scope 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. Minimum Qualifications MINIMUM QUALIFICATIONS Academic/Formal Training: Bachelor's degree in Business, Financial or Technical Field. Job Related/Experience: 4-7 years related experience, or in lieu of Bachelor's degree, 6-9 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 (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. Preferred Qualifications PREFERRED QUALIFICATIONS 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. Benefits Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors:USD $84,000.00/Yr. - USD $126,000.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 (based on position) Long Term Incentive Plan for eligible positions Wellbeing programs such as tuition reimbursement, adoption assistance and fitness reimbursement Referral bonus program And much more Exelon is proud to be an equal opportunity employer and employees or applicants will receive consideration for employment without regard to: age, color, disability, gender, national origin, race, religion, sexual orientation, gender identity, protected veteran status, or any other classification protected by federal, state, or local law. If you are an individual with a disability and need an accommodation to complete the application, please email us at DandI@exeloncorp.com.