SEM Data Analyst

CLEAResult; Illinois; Hybrid; USD 52,000 - 74,000; Full time

Benefits offered by this job

Medical, Dental, Vision Insurance

401(k) with company match

Paid vacation and leave

Paid Volunteer Time

Employee Recognition Program

Employee Assistance Program

On-demand training courses

Job summary

CLEAResult is seeking a Data Analyst to support its SEM team across North America. You will power data-driven decisions by cleaning, standardizing, and preparing datasets, and by building templates and tools for the SEM program.

This role focuses on internal data analysis with some client interaction. You will collaborate across teams to improve data workflows, automate processes, and ensure model quality for energy modeling projects.

Qualifications

• Strong data manipulation and formatting skills with attention to detail.
• Experience analyzing large, complex data sets.
• Proficiency with Visual Basic and advanced Excel formulas.
• Experience with Smartsheet and SharePoint.

Responsibilities

• Perform pre- and post-modeling data review and manipulation.
• Manipulate and format production data with precision.
• Analyze large data sets to catch errors and ensure accuracy.
• Integrate data into statistical software templates.
• Collaborate with teams to build standardized templates for energy modeling.
• Write work instructions for new templates.
• Track and quality-control final models and reports.
• Help automate data processing to save time and reduce manual error.
• Troubleshoot and build tools using Visual Basic and Excel.
• Manage and manipulate data in Smartsheet.
• Support benchmarking reporting and digital infrastructure.

Skills

Data manipulation

Large data sets

Statistical software

Visual Basic

Excel formulas

Smartsheet

SharePoint

Collaboration

Energy industry experience

Tools

Smartsheet

Excel

Visual Basic

Job description

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 talented individual… To join our team! CLEAResult's Strategic Energy Management (SEM) team is expanding, and we have a new opportunity for a Data Analyst to help power the work of our SEM experts across the US and Canada. If you love digging into data, spotting patterns others miss, and building the tools and templates that make a whole program run smoother, this is a great place to make an impact. As a Data Analyst, you'll be the engine behind the scenes for our Statistical Analysts and SEM program teams across North America, supporting energy modeling, standardizing processes, and keeping our data clean, consistent, and ready to drive real decisions. This role is primarily internally facing and centered on data analysis, with occasional interaction with clients and end-use customers to gather data or answer questions. You'll play a central role in bringing consistency and efficiency to how our SEM teams work internationally, directly supporting the accuracy and quality of the models and reports our program depends on.

Here at CLEAResult, you will fit right in with our energetic team if you are resourceful, resilient, and kind.

In this role, you will…

• Perform pre- and post-modeling data review and manipulation to support our Statistical Analysts.
• Manipulate and format production data with precision and consistency.
• Analyze large data sets to catch errors and ensure accuracy before it moves downstream.
• Integrate data into statistical software templates.
• Collaborate with internal and external teams to build and maintain database files.
• Partner with program teams across the organization to create and maintain standardized templates for energy modeling and program data.
• Write clear work instructions for newly developed templates, so others can pick them up with ease.
• Track, draft, edit, and quality-control final models and reports.
• Help automate data processing to save time and reduce manual error.
• Troubleshoot, modify, and build tools using Visual Basic and Excel formulas.
• Manage and manipulate data in Smartsheet.
• Support benchmarking reporting and contribute to the development of our digital infrastructure.

For this exciting career opportunity, you're a great fit if you have…

• Strong data manipulation and formatting skills, with an eye for consistency and detail
• Experience analyzing large, complex data sets
• Comfort working with statistical software and templates
• Proficiency in Visual Basic and advanced Excel formulas
• Experience with Smartsheet
• SharePoint experience
• A collaborative mindset, comfortable working across internal teams and occasionally with external clients and customers
• Energy industry experience preferred, but not required

Please note: sponsorship is not available for this position at this time.

DOT Requirements If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations.

Compensation Range

$52,000.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. CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students. Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support. 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.

We change the way people use energy. CLEAResult started in Austin, Texas, in 2003 with a simple idea: a results-oriented company could have a positive impact by helping people make smart energy decisions. In the years since, we've grown to become the single largest provider of energy solutions in North America. Now, with offices in over 60 cities in the U.S. and Canada, we're able to tailor our efforts to fit our clients' specific needs, while positively impacting the energy landscape on a global scale.

Our Mission

We are driven to make a change. We offer a comprehensive set of energy programs and demand-side management strategies. Our energy experts design and maintain energy optimization services for utility companies as well as institutional, commercial and industrial organizations. We deliver solutions that lower load requirements for utilities, reduce energy bills for end users and minimize environmental burdens on communities. Every day, in every way possible, we change the way people use energy.