Business Data Analyst II, Home Energy Rebates

Position Location: 1000 Independence Ave SW, Washington D.C. 20585

Salary: $100,000 - $135,000

Work Environment : Remote

Travel Required: None

Position Summary:

The Business Data Analyst II will support the Department of Energy (DOE), Office of State and

Community Energy Programs (SCEP), Home Energy Rebates program. The Home Energy Rebates

program delivers formula funding to states and communities to lower household energy costs through

whole-home efficiency retrofits and electrification of appliances and equipment.

The Business Data Analyst II will provide data review, analysis, reporting, and tool development in

support of the SCEP portfolio. This role works across the SCEP office to support the office-wide build-

out of shared data tools and reporting infrastructure while delivering program-specific analytics for Home

Rebates. A core function of the position is building tools from scratch and turning complex program and

financial data into clear, visually compelling products that help federal staff make key decisions. This role

works directly with the DOE Home Rebates federal team and within a functional team of similar experts

to support the office more broadly.

Specific requirements and responsibilities include:

Excel, and Microsoft Access, integrating data from multiple DOE and program sources.

appealing formats that support federal decision-making.

collaborating across programs to standardize data and reporting processes.

including budget, spend plan, and performance reporting.

data reporting processes, and leading data quality efforts.

Procedures (SOPs) and business and functional requirements.

and the federal team.

ATS provider: Paylocity.

• Design, build, and maintain data tools, dashboards, and reports from scratch using Power BI,
• Translate complex programs, budget, and performance data into clear, digestible, and visually
• Support SCEP office-wide build-out of shared data tools and reporting infrastructure,
• Deliver program-specific analytics and reporting for the Home Energy Rebates program,
• Lead data efforts in system modernization projects, including data synchronization, establishing
• Identify and resolve data gaps, exceptions, and quality issues; develop Standard Operating
• Develop management-level reports, briefings, case studies, and presentations for SCEP leadership
• Perform ad hoc reporting and analysis in response to program and leadership needs.