Energy Program Data Analyst: Forecasts & Insights

HEPCO Inc; New Brunswick (NJ); On-site; USD 50,000 - 59,000; Full time

Job summary

HEPCO Inc seeks a detail-oriented Data Analyst in New Jersey to compile, analyze, track program data, and report across multiple energy efficiency programs. The role reports to the Operations Manager and emphasizes data accuracy and cross-functional collaboration.

The position requires 2+ years in energy efficiency program design/implementation, a technical degree, and strong Excel/database skills. You will develop forecasts, evaluate programs, and support planning tools, with opportunities to

Qualifications

• Minimum of 2 years of experience in program design and/or implementation for utility or state-funded energy efficiency or renewable energy programs.
• Bachelor’s degree in a technical field such as Engineering, Data Analytics, Physics, or Mathematics.
• Advanced proficiency in Microsoft Office Suite with expert-level Excel skills.
• Experience with Visual Basic or similar programming languages.
• Experience with relational database systems.
• Experience working with state and federal energy codes and regulations.
• Familiarity with program evaluation processes and procedures.
• Strong research, analytical, and problem-solving skills.
• Demonstrated strategic thinking ability.
• Experience working with and analyzing large datasets.
• Ability to multitask, meet deadlines, and work proactively.

Responsibilities

• Develop and analyze reports for energy efficiency measures and program performance.
• Support program evaluation, update planning tools, and develop forecast and projection reports.
• Conduct policy research on energy efficiency codes and standards at state and federal levels.
• Perform analyses including program, portfolio, measure, project, and program-level impacts.
• Perform benefit-cost analysis for prospective energy efficiency measures and programs per NJ protocols.
• Justify and document technical decisions related to research planning and data analysis.
• Report findings and actionable recommendations to internal teams and the utility client.
• Collaborate with program management staff and clients to meet reporting and data requirements.
• Lead development and review of program documents, applications, and energy savings models.
• Monitor metrics for monthly client invoicing and funding variances.
• Develop data collection and tracking procedures as updates occur.
• Support program evaluation activities.
• Develop energy-based assumptions using regression or data modeling.

Skills

Excel

Visual Basic

Relational databases

Data analysis

Education

Bachelor’s degree in a technical discipline such as Engineering, Data Analytics, Physics, or Mathematics

Tools

SQL databases

Visio

Job description

HEPCO Inc seeks a detail-oriented Data Analyst in New Jersey to compile, analyze, track program data, and report across multiple energy efficiency programs. The role reports to the Operations Manager and emphasizes data accuracy and cross-functional collaboration.

The position requires 2+ years in energy efficiency program design/implementation, a technical degree, and strong Excel/database skills. You will develop forecasts, evaluate programs, and support planning tools, with opportunities to