SEM Data Analyst

At CLEAResult, we lead the transition to a sustainable, equitable, and carbon-neutral energy-efficient future for our communities and our planet. We do that by creating a people-first culture built on trust, accountability, and transparency; where every employee – regardless of position, role, or identity is treated with respect and given an equal chance to thrive.

Additionally, you will enjoy:

- Medical, Dental, and Vision Insurance; we also offer a company-paid health care concierge service to help navigate our health plan to make the best decisions for you and yours

- 401(k) with company match

- Paid vacation, sick, personal and parental leave time

- Paid Volunteer Time: giving back to our communities is important to us

- Employee Recognition Program – convert your recognition points into gift cards

- Employee Assistance Program – offers benefits to help you manage daily responsibilities

- Access to on-demand training courses to advance further in your career

Job Description

We are looking for a detail-oriented and collaborative professional to join our team as an SEM Data Analyst. In this role, you will support energy modeling and data processing efforts across SEM teams throughout North America. This position is primarily internally focused, with occasional client interaction to gather data and provide clarification. You’ll play a key role in supporting statistical analysis and standardizing processes across international SEM programs.

For this opportunity, you’re a great fit if you can…

- Format and manipulate production data for energy modeling.

- Analyze large datasets for consistency, accuracy, and errors.

- Integrate data into statistical software templates and support modeling workflows.

- Collaborate with internal and external teams to maintain and organize database files.

- Help create and maintain standardized templates for energy modeling and program data.

- Draft work instructions for newly developed templates and processes.

- Track, edit, and quality-check final models and reports.

- Automate data processing tasks and troubleshoot Excel formulas and Visual Basic scripts.

In this exciting career opportunity, you will have…

- Strong analytical skills and attention to detail.

- Experience working with large datasets and statistical software.

- Proficiency in Excel, including advanced formulas and Visual Basic.

- Familiarity with Power BI, Tableau, SQL, and Python is a plus.

- Ability to collaborate across teams and communicate technical concepts clearly.

- Experience creating documentation and process instructions.

- Familiarity with energy modeling or SEM programs is a plus.

Target Compensation:

$65,000-70,000.

Compensation Range

$50,755.00 - $74,400.00

Currency

USD

Type

Salary

Any offered salary is determined based on internal equity, internal salary ranges, market data/ranges, applicant’s skills and prior relevant experience, certain degrees and certifications (e.g. JD/technology), for example.

Sponsorship is not available for this position at this time. Successful hires must pass pre-employment checks.

Equal Opportunity Employer

As an Equal Opportunity Employer, we are committed to ensuring equal employment opportunities for all job applicants and employees. Employment decisions are based upon job-related reasons regardless of an applicant’s race, color, religion, national origin, marital status, age, sex, gender identity, sexual orientation, status as a qualified individual with a disability or protected veteran, or any other protected status.

The above job description and job requirements are not intended to be all inclusive. CLEAResult retains the right to make changes or adjustments to job descriptions and/or requirements at any time without notice.