SEM Data Analyst

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

Join the CLEAResult Consulting Inc. Strategic Energy Management team as an SEM Data Analyst in Juneau, AK (onsite). In this role, you will help keep production data clean, consistent, and ready for energy modeling and reporting. The position is primarily internal-facing, with occasional client and end-use customer interaction to gather data or answer questions.

This salary ($52,000.00 - $74,400.00) role includes benefits designed to support your health, time away, and long-term planning, plus access to on-demand training courses to continue building your skills.

What you'll do

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

What you bring

• 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, comfortable working across internal teams and occasionally with external clients and customers.
• Energy industry experience is preferred but not required.

Tools you'll use

Visual Basic, Excel formulas, Smartsheet, SharePoint

Benefits

• Medical, Dental, and Vision Insurance
• Company-paid health care concierge service
• 401(k) with company match
• Paid vacation
• Paid sick time
• Paid personal leave time
• Paid parental leave time
• Paid Volunteer Time
• Employee Recognition Program - convert your recognition points into gift cards
• Employee Assistance Program
• Access to on-demand training courses to advance further in your career

Transportation requirements

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