Senior Forecasting Analyst: Energy Revenue & Demand

Madison Gas and Electric

Madison (AL)

Hybrid

USD 110,000 - 150,000

Full time

8 days ago

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Madison Gas and Electric in Madison, WI seeks a Senior Forecasting Analyst to develop defensible forecasts for electric and natural gas sales, customers, and revenue, supporting budgeting, regulatory analysis, and long-range planning.

The role applies advanced statistical modeling, data analysis, and business insight to translate complex results into clear recommendations for senior leaders and cross-functional partners, while maintaining documentation and contributing to continuous improvement

Qualifications

5+ years of related forecasting, statistical analysis, financial analysis, or business analytics experience.
Experience developing, validating, and communicating forecasting models using large, multi-source datasets.
Experience with advanced spreadsheets and at least one statistical, programming, database, or business intelligence tool.
Utility or regulated industry experience preferred.

Responsibilities

Develop, maintain, and enhance short- and long-term forecasts of electric and natural gas sales, customer counts, and operating revenue by customer class, rate category, or other relevant business segments.
Apply statistical and analytical techniques such as regression, time-series analysis, weather normalization, trend analysis, segmentation, sensitivity analysis, and forecast error measurement to evaluate historical results and projected outcomes.
Analyze customer billing, usage, weather, economic, rate, and operational data to identify underlying trends, structural changes, risks, and key drivers of revenue and sales.
Integrate forecast outputs with budgets, long-range financial plans, regulatory analyses, resource planning assumptions, and other enterprise planning processes.
Perform actual-to-forecast variance analysis and clearly explain the effects of weather, customer growth, usage patterns, rates, economic conditions, and other business factors.
Design and maintain repeatable forecasting processes, analytical datasets, dashboards, and reporting tools that improve accuracy, efficiency, transparency, and control.
Develop scenarios and sensitivities to evaluate uncertainty and the financial implications of alternative weather, economic, customer, rate, and market assumptions.
Validate models and data through back-testing, reasonableness checks, reconciliation, peer review, and ongoing monitoring of forecast performance.
Partner with business and technical teams to define data requirements, resolve data-quality issues, and improve access to reliable, well-governed information.
Communicate assumptions, methodologies, results, limitations, and recommendations in a clear manner for technical and non-technical audiences, including senior management.
Maintain comprehensive documentation of data sources, model logic, assumptions, controls, changes, and forecast decisions to support continuity, review, and auditability.
Monitor relevant utility, customer, technology, and economic developments and assess their potential implications for electric and natural gas sales and revenue forecasts.
Provide analytical leadership, support continuous improvement, and serve as a subject matter resource for revenue and sales forecasting.