Energy Analytics & Forecasting Specialist

City of Fremont, Nebraska; Energy (IL); On-site; USD 95,000 - 134,000; Full time

Job summary

The City of Fremont seeks an Energy Analyst to conduct advanced statistical analysis of utility data, forecasts, and risk. You will monitor performance, develop datasets, and report results to regulators and stakeholders.

Strong Excel and SQL skills are essential, plus familiarity with SCADA systems. The role requires on-site work at various utility locations, with the ability to translate complex data into actionable insights and long-range budgets.

Qualifications

• Bachelor's degree in Business, Economics, Engineering, Statistics, Mathematics, Computer Science or related field.
• Advanced Microsoft Excel and database proficiency.
• High aptitude in querying data from SQL sources.
• Demonstrated ability to work with complex models, data, and reports.
• Excellent verbal and written communication skills.
• Familiarity with Utility operations, including technology, market, resources, and regulations.
• Knowledge of statistical analysis concepts and modeling techniques.

Responsibilities

• Monitors the utility SCADA Information System and determines if the SCADA system is reporting within established guidelines.
• Identifies, obtains, and analyzes data to prepare reports and data sets regarding various aspects of utility operations including electric generation, energy sales and purchases, system demand, system efficiencies, fuel consumption and levels, output, energy costs, etc.
• Analyzes and compiles data for submittal to Southwest Power Pool (SPP) in the Day-Ahead (DA) and Real Time (RT) markets.
• Reconciles submitted information with real-time performance metrics.
• Monitors contract deliverables and compares with utility performance.
• Responsible for a variety of reporting to regulating entities including SPP, state, and federal agencies.
• May provide support and training for utility personnel.
• Serves as LSA and liaison for the City of Fremont in SPP.
• Identifies, generates and complies information for general accounting, outside auditors, and various governmental agencies for accounting and compliance reporting.
• Develops long-term forecasts to support portfolio planning and support evaluation of procurement opportunities.
• Support development of bi-annual budget through forecasting.
• Utilizes a variety of computer software programs to prepare reports, graphs, and other material related to energy resources, finance models, usage trends, and customer statistics.
• Serves as a resource for utility teams regarding current and past performance, forecasts, and provides advanced-level analysis and recommendations of root cause and corrective action.
• Identifies and utilizes value-added performance metrics for the utility, reporting as appropriate.
• Performs other work which is consistent with the essential functions of the job and other duties as assigned.

Skills

Statistical analysis

Forecasting

Data modeling

SQL querying

Excel advanced

Communication

Education

Bachelor's degree in relevant field

Tools

SCADA Information System

SQL Databases

Job description

The City of Fremont seeks an Energy Analyst to conduct advanced statistical analysis of utility data, forecasts, and risk. You will monitor performance, develop datasets, and report results to regulators and stakeholders.

Strong Excel and SQL skills are essential, plus familiarity with SCADA systems. The role requires on-site work at various utility locations, with the ability to translate complex data into actionable insights and long-range budgets.