SEM Data Analyst

CLEAResult Consulting

Madison, WI

Full Time

Mid Level

51k-74k

5 days ago

Job Description

About the Role

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. The SEM Data Analyst supports energy modeling and data processing efforts across SEM teams throughout North America, primarily focusing on internal collaboration with occasional client interaction to gather data and clarify requirements.

Key Responsibilities

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.

Requirements

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.

Nice to Have

Familiarity with energy modeling or SEM programs.

Qualifications

Experience with large datasets and statistical software
Proficiency in Excel and Visual Basic
Familiarity with Power BI, Tableau, SQL, and Python

Benefits & Perks

Medical, Dental, and Vision Insurance
Company-paid health care concierge service
401(k) with company match
Paid vacation, sick, personal and parental leave
Paid Volunteer Time
Employee Recognition Program
Employee Assistance Program
Access to on-demand training courses

Working at CLEAResult Consulting

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.

Apply Now