Load Forecasting Analyst - BSC (Hybrid)

Pepco; Philadelphia, Chicago, Baltimore, Newark (Philadelphia County, IL, MD, DE); On-site; USD 74,000 - 101,000; Full time

Benefits offered by this job

Annual salary $73,600–$101,200

Annual bonus 10%

401(k) match

Medical/dental/vision insurance

Paid time off

Employee assistance program

Job summary

Exelon is seeking a forecasting analyst to assist in monthly electrical usage forecasting for the five-year long-range plan. You will help develop load forecast models, maintain econometric tools, and prepare reports for revenue accounting and procurement purposes.

You will collaborate with Revenue Accounting and Energy Acquisition, deliver quarterly presentations, and support external load projections and IPA-related procurement efforts.

Qualifications

• BS or BA required.
• 2–4 years of experience in utility economics, finance, or engineering functions.
• Strong Excel and database skills (Microsoft Office).
• Ability to manage multiple tasks and deliver accurate, timely results under pressure.
• Familiarity with electric utility industry.

Responsibilities

• Develop, maintain, and document load forecast models used to generate monthly usage forecasts by customer class.
• Perform monthly estimating and reporting functions for monthly close and forecast performance.
• Prepare presentations and IPA procurement-related reports with supporting analysis.
• Support ad-hoc analyses and requests.

Skills

Excel

Data analysis

Econometrics

Education

BS/BA in related field

Tools

Database software

Job description

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, 20,000 colleagues strong serving more than 10.7 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). We're committed to creating an environment where every person can thrive. Our employee experience is grounded in four tenets that guide how we support our people: purposeful careers, growth opportunities, community impact, and support to thrive. 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 OF POSITION

Primary role is to assist in forecasting monthly electrical usage to support five-year long range plan.

Primary Duties

PRIMARY DUTIES AND ACCOUNTABILITIES

• Assist in the development, maintenance, and documentation of load forecast models used to generate monthly usage forecasts by customer class. Models are also used in the monthly close process in support of Revenue Accounting. (40%)
• Perform monthly estimating and reporting functions. Monthly information is prepared for use in closing the books. Additionally, various internal reports are created for use in measuring forecast performance and reporting of actual weather-adjusted usage. (25%)
• Prepare numerous presentations throughout the year (with supporting documentation and analysis). Presentations are prepared as needed related to load forecasts updates and quarterly in support of the QMM. A report to the Illinois Power Agency is prepared each July documenting the usage needed for procurement purposes by the IPA. (20%)
• Supporting analysis and ad-hoc requests. (15%)

JOB SCOPE

• This position is involved in preparing load forecasts that are used in LRP revenue projections, external load projections and the procurement of approximately $1.0 billion/year of energy. In addition, this position has a direct impact on the company's ability to recover its revenue requirement (e.g., providing weather-adjusted billing units).
• This position has an array of both internal and external contact relationships: Internal relationships include Revenue Accounting and Energy Acquisition. External relationships include entities such as economic vendor (e.g., IHS Economics) or governmental agencies for the purpose of gathering economic data.
• Works jointly with other Exelon utility's load forecasting groups in coordinating Quarterly presentations. Documentation and verification of all deliverables (e.g., forecasts) and associated processes are important.

MINIMUM QUALIFICATIONS

• Education: BS or BA required.
• Experience: 2-4 years of experience related to the utility industry or other employment involving economics, finance or engineering functions.
• Skills: Strong analytical skills ability to analyze complex problems using various tools. Strong skills in the use of Excel and database software. (Microsoft Office)
• Ability to manage multiple tasks and activities in ambiguous or pressure situations that produce accurate and timely results. Maintain existing suite of econometric models.
• Familiarity with electric utility industry.
• Strong interpersonal skills along with ability to effectively communicate (verbal and written).
• General understanding of factors related to customer usage of electricity.
• In lieu of degree, 3-6 years of relevant experience

PREFERRED QUALIFICATIONS

• Education: Course work in economics, statistics or econometrics.
• Experience: Load forecasting experience or forecasting experience in general.
• Skills: A working knowledge of the Company's financial and business practices.

Benefits

• Annual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $73,600.00/Yr. – $101,200.00/Yr.
• Annual Bonus for eligible positions: 10%
• 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.