SEM Data Analyst — Energy Modeling (Juneau Onsite)

CLEAResult Consulting Inc.; Juneau (AK); On-site; USD 52,000 - 74,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) with company match

Paid vacation

Paid sick time

Paid personal leave

Paid parental leave

Paid Volunteer Time

Employee Recognition Program

Employee Assistance Program

On-demand training courses

Job summary

CLEAResult Consulting Inc. in Juneau, AK is seeking an SEM Data Analyst to keep production data clean and ready for energy modeling and reporting. The role is onsite with occasional client interaction and a strong internal focus.

You will manipulate large data sets, implement standardized templates, and contribute to the digital infrastructure of CLEAResult. Strong VB and advanced Excel skills are essential, with energy industry experience preferred.

Qualifications

• Strong data manipulation and formatting skills with a focus on 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, able to work across internal teams and with external clients and customers.
• Energy industry experience is preferred but not required.

Responsibilities

• Perform pre- and post-modeling data review and manipulation to support Statistical Analysts.
• Manipulate and format production data with precision and consistency.
• Analyze large data sets to identify errors and protect accuracy before data moves downstream.
• Integrate data into statistical software templates.
• Collaborate with internal and external teams to build and maintain database files.
• Partner with program teams to create and maintain standardized templates for energy modeling and program data.
• Write clear work instructions for newly developed templates so others can use them with ease.
• Track, draft, edit, and conduct quality control on 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 CLEAResult's digital infrastructure.

Skills

Data manipulation

Large data sets

Statistical software

Visual Basic

Advanced Excel formulas

Smartsheet

SharePoint

Collaborative mindset

Tools

Smartsheet

SharePoint

Job description

CLEAResult Consulting Inc. in Juneau, AK is seeking an SEM Data Analyst to keep production data clean and ready for energy modeling and reporting. The role is onsite with occasional client interaction and a strong internal focus.

You will manipulate large data sets, implement standardized templates, and contribute to the digital infrastructure of CLEAResult. Strong VB and advanced Excel skills are essential, with energy industry experience preferred.