Senior Energy Analytics & Reporting Specialist – Remote

ICF; Los Angeles (CA); On-site; USD 81,000 - 138,000; Full time

Benefits offered by this job

Flexible schedule

Volunteer opportunities

Tuition reimbursement

401k matching

Employee stock purchase plan

Professional development

Job summary

ICF is seeking a Senior Technical Specialist to support demand-side management and energy efficiency programs in Southern California with remote alignment to the Los Angeles metro area. You’ll develop reporting templates, collect KPI data from multiple stakeholders, and present insights to senior management while ensuring CPuc reporting requirements are met.

You will leverage Power BI and Excel to build dashboards, manage data quality, and coordinate responses to data requests from evaluators.

Qualifications

• Bachelor’s Degree in Engineering, Physical Sciences, Computer Science, Statistics, Business Administration, Economics, Energy, Environmental Studies or related subjects (or substitute one year of related experience for one year of education)
• 5+ years experience with program tracking, reporting and presenting KPI data to senior management
• Experience developing and writing code with scripting languages such as Python, VBA, R, and/or SQL
• Experience creating Power BI dashboards and/or developing advanced MS Excel workbooks using macros and VBA

Responsibilities

• Develop common reporting templates that leverage varying data to create uniform results for regular and ad hoc reporting needs
• Collect energy efficiency / electrification reporting and KPI data from multiple stakeholders in varying formats
• Compile data into common reporting templates
• Present formal reports to internal and client facing senior management
• Track and support recurring energy measure calculation updates
• Help maintain program databases, incorporating fixes and enhancements and performing periodic reviews for data consistency and accuracy
• Review reports and presentations by third parties
• Assist with the interpretation and implementation of client and regulatory guidance related to reporting
• Contribute to and coordinate responses to data requests from third-party evaluators and support internal data requests
• Work with other stakeholders to support CPUC level reporting including compiling data, generating reports and submitting the reports

Skills

KPI reporting

KPI data presentation

Data storytelling

Data visualization

Cross-functional collaboration

Stakeholder coordination

Education

Bachelor’s Degree in Engineering

Master’s Degree in Engineering/Science

Tools

Power BI

Excel (VBA/macros)

SQL

Salesforce

Job description

ICF is seeking a Senior Technical Specialist to support demand-side management and energy efficiency programs in Southern California with remote alignment to the Los Angeles metro area. You’ll develop reporting templates, collect KPI data from multiple stakeholders, and present insights to senior management while ensuring CPuc reporting requirements are met.

You will leverage Power BI and Excel to build dashboards, manage data quality, and coordinate responses to data requests from evaluators.