Analyst I

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

Westwood, MA. ECLARO's client is one of the nation's premier energy companies, delivering essential electric, and natural gas while investing in innovation and clean energy. If you're seeking meaningful work with long‑term career growth, don't miss this exciting opportunity!

Position Overview:

• This position is responsible for the data collection, review, analysis, and reporting for the Energy Efficiency business operations for all three states, including but not limited to data set validation against program requirements, compliance verification of application data, dashboarding, and executive summaries of program performance.
• Responsibilities include providing data oversight support to leadership for the energy efficiency residential and commercial Channel programs MA, CT and NH.
• This includes collaborating closely with the database management, finance, and implementation teams as well as close collaborations with Energy Efficiency Consultants and 3rd party vendors/lenders.
• Applicants must be authorized to work in the United States on a full‑time basis without the need for current or future visa sponsorship

Responsibilities:

• Review, validate, and approve large datasets of customer application data, including technical review of metrics following a given set of parameters
• Monitor, track, and analyze vendor performance data to ensure accuracy and data 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 specific datasets to ensure accuracy and alignment with reported spending
• Utilize and validate data in Tracksys, Tableau, PowerBI, and other vendor platforms
• Ensure datasets reflect program compliance standards and flag projects outside of program requirements
• 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
• Support the review of Energy Efficiency accounting and budgeting information to ensure it is complete, accurate and maintained in accordance with the Company's' Accounting and Budgeting area requirements, as well as with regulatory decisions and orders.
• Supports the production of the Monthly Key Performance Indicators and Financial Reports for the EE organization.
• Maybe a meeting once a month

Required Qualifications:

• Bachelor's Degree REQUIRED in Business, Data Management, Economics, Math, Finance, Accounting,
• 1 to 2 related experience. Dataset management, Compliance oversight, Tracksys/system management, PowerBI/Tableau, Project Finance, Energy Efficiency, Economics/Mathematics and Regulatory, Budgeting or Planning experience preferred
• Strong excel
• Knowledge of salesforce/build out dashboards would be a plus
• Analylis/pivot data
• Be able to pull data in PowerPoint and present on it
• Understand how to take the rules of a program and apply it into their analysis
• Knowledge, experience and demonstrated abilities in data modeling, data validation, and large dataset management
• Knowledge, experience and, demonstrated utilizing Excel to make decisions
• Must possess an understanding of data management
• Must be customer driven, display initiative, accepts responsibility, holds others accountable, participates in and facilitates team effectiveness, thinks and acts analytically.
• Demonstrated ability to make sound decisions, to conduct subjective analysis, to support the mission, work independently and apply knowledge and skill to solve problems.
• Develop and maintain an excellent working relationship with management
• Demonstrated proficiency in Microsoft Excel, in addition to other Microsoft Office applications (MS Power point, MS Word) and other business system applications.
• Demonstrated technical proficiency in running queries in various systems and data gathering.
• Effective written and oral communication skills.

Benefits:

• 401k Retirement Savings Plan administered by Merrill Lynch
• Commuter Check Pretax Commuter Benefits
• Eligibility to purchase Medical, Dental & Vision Insurance through ECLARO

ECLARO values diversity and does not discriminate based on Race, Color, Religion, Sex, Sexual Orientation, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status, in compliance with all applicable laws.