Data Analyst I - Energy Efficiency Programs & Dashboards

ECLARO; Westwood (MA); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

401k Retirement Savings Plan

Commuter Check Pre-tax Benefits

Medical/Dental/Vision Insurance

Job summary

ECLARO's client, a premier energy company in the United States, seeks a data analyst to support Energy Efficiency programs across MA, CT, and NH. You will collect, validate, and analyze large application datasets, and build dashboards to summarize program performance.

Collaborating with database management, finance, and implementation teams, you will ensure compliance, accuracy, and clear executive reporting using Excel, Tracksys, PowerBI, and Tableau.

Qualifications

• Bachelor's Degree REQUIRED in Business, Data Management, Economics, Math, Finance, Accounting.
• 1 to 2 related experience in dataset management, Compliance oversight, Tracksys/system management, PowerBI/Tableau, Project Finance, Energy Efficiency, Economics/Mathematics and Regulatory, Budgeting or Planning experience preferred
• Strong Excel skills and ability to build dashboards.
• Knowledge of Salesforce and dashboard development is a plus.
• Proficiency in data modeling, validation, and large dataset management.

Responsibilities

• Review, validate, and approve large datasets of customer application data.
• Monitor, track, and analyze vendor performance data for accuracy and compliance.
• Track data errors and work with third-party vendors to develop solutions.
• Collaborate with cross-functional teams including internal and external stakeholders.
• Oversee program datasets to ensure accuracy and alignment with reported spending.
• Utilize Tracksys, Tableau, PowerBI and other vendor platforms for dashboards.
• Ensure datasets reflect program compliance standards and flag non-compliant projects.
• Build and monitor dashboards to track program performance.
• Support programmatic changes through updating data requirements.
• Collaborate with vendors on program changes and data improvement opportunities.
• Review Energy Efficiency accounting and budgeting information for accuracy and compliance.
• Support Monthly KPIs and Financial Reports for the EE organization.
• Maybe a meeting once a month.

Skills

Data management

PowerBI

Tableau

Excel

Tracksys

SQL queries

Data validation

Dashboarding

Education

Bachelor's Degree

Tools

Salesforce

MS Office

Job description

ECLARO's client, a premier energy company in the United States, seeks a data analyst to support Energy Efficiency programs across MA, CT, and NH. You will collect, validate, and analyze large application datasets, and build dashboards to summarize program performance.

Collaborating with database management, finance, and implementation teams, you will ensure compliance, accuracy, and clear executive reporting using Excel, Tracksys, PowerBI, and Tableau.