SEM Data Analyst — Energy Modeling & Insights

CLEAResult; North Carolina; On-site; USD 52,000 - 74,000; Full time

Benefits offered by this job

Health insurance

401(k) match

Paid time off

Volunteer time off

Gift cards program

Job summary

CLEAResult is seeking a Data Analyst to power the SEM team across the US and Canada. You’ll analyze large data sets, build templates, and ensure data integrity to support energy modeling and program data. The role centers on internal data analysis with occasional client interaction.

You will collaborate across teams, develop standardized templates, and help automate processing to boost efficiency. Prior energy industry experience is a plus but not required.

Qualifications

• 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

Responsibilities

• 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.

Skills

Data manipulation

Data formatting

Large data sets

Statistical software

Visual Basic

Excel formulas

Smartsheet

SharePoint

Team collaboration

Tools

Visual Basic

Excel

Smartsheet

SharePoint

Job description

CLEAResult is seeking a Data Analyst to power the SEM team across the US and Canada. You’ll analyze large data sets, build templates, and ensure data integrity to support energy modeling and program data. The role centers on internal data analysis with occasional client interaction.

You will collaborate across teams, develop standardized templates, and help automate processing to boost efficiency. Prior energy industry experience is a plus but not required.