Support energy modeling and data processing efforts across SEM teams throughout North America
Format and manipulate production data for energy modeling
Analyze large datasets for consistency, accuracy, and errors
Integrate data into statistical software templates and support modeling workflows
Collaborate with internal and external teams to maintain and organize database files
Create and maintain standardized templates for energy modeling and program data
Draft work instructions for newly developed templates and processes
Track, edit, and quality-check final models and reports
Automate data processing tasks and troubleshoot Excel formulas and Visual Basic scripts
Occasionally interact with clients to gather data and provide clarification
Requirements
Strong analytical skills and attention to detail
Experience working with large datasets and statistical software
Proficiency in Excel, including advanced formulas and Visual Basic
Familiarity with Power BI, Tableau, SQL, and Python is a plus
Ability to collaborate across teams and communicate technical concepts clearly
Experience creating documentation and process instructions
Familiarity with energy modeling or SEM programs is a plus
Sponsorship is not available for this position at this time (must be authorized to work in the U.S.)
Successful hires must pass pre-employment checks
Benefits
Medical, Dental, and Vision Insurance; we also offer a company-paid health care concierge service to help navigate our health plan to make the best decisions for you and yours
401(k) with company match
Paid vacation, sick, personal and parental leave time
Paid Volunteer Time: giving back to our communities is important to us
Employee Recognition Program – convert your recognition points into gift cards
Employee Assistance Program – offers benefits to help you manage daily responsibilities
Access to on-demand training courses to advance further in your career
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data processingenergy modelingdata analysisExcelVisual Basicstatistical softwarePower BITableauSQLPython
Soft skills
analytical skillsattention to detailcollaborationcommunicationdocumentation creation