SEM Data Analyst
About The Position
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. 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.
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
Nice To Haves
- 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.
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
- Employee Assistance Program
- Access to on-demand training courses
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
