SEM Data Analyst

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.

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.

Requirements

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

Benefits

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

Pay

Compensation range: $52,000.00 – $74,400.00 USD (salary)