This site uses cookies. To find out more, see our Cookies Policy

Data Analyst in Chicago, IL at CLEAResult

Date Posted: 9/11/2018

Job Snapshot

Job Description

Click the Apply link to create your Job Application

Job Description Summary

CLEAResult’s Strategic Energy Management (SEM) team is expanding, and has a new opportunity in our Calgary, AB office for the position of Data Analyst. As a Data Analyst, you will help support talented teams of SEM experts across the US and Canada. In addition to the satisfaction of helping program participants save energy, working at CLEAResult offers some great perks:
• Progressive workplace made up of efficiency-minded colleagues
• Nice benefits and compensation
• Generous vacation allowance
• Paid time off to volunteer
• Career progression opportunities

Job Description

The Data Analyst position is ideal for you if you have a strong Microsoft Excel background, like to be involved at multiple levels of a project, and enjoy performing a variety of duties in a dynamic work environment. Our proven SEM program curriculum and materials are well-established, but since we are in the business of continuous improvement we are always collaborating to make things better. No workday is the same, and many tasks are on strict deadlines. The pace is fast, the work is fun, and the position includes the following activities:

Energy model pre-processing:

  • Production data manipulation and formatting
  • Analyzing production and utility data to check for consistency and errors
  • Integration of data into statistical software interface
  • Creation of new templates to improve modeling processes

Energy model maintenance:

  • Update and maintain weather data files for multiple programs
  • Excel-based client model updates
  • Savings tracking spreadsheet updates
  • Transfer processed statistical data into Excel templates
  • Capital project checks

Reporting:

  • Final model and report tracking
  • Final report drafting, editing, and QC

Data Automation:

  • Assess modeling and reporting processes to streamline and automate
  • Work with program teams to eliminate unnecessary data processing
  • Visual Basic troubleshooting, modification, and creation



Requirements

  • Very experienced with Microsoft Excel including the use of integrated formulas and Visual Basic development environment
  • Experience troubleshooting and fixing Excel formulas and macros
  • Experience creating new and/or improving macros for productivity improvements
  • Experience writing, editing and proofing reports
  • Knowledge of the energy efficiency industry
  • Ability to professionally interface with clients and program participants in-person and by email and phone

Preferred background
•    Bachelor’s degree
•    Experience in a consulting environment
•    Knowledge of continuous improvement such as Lean/Six-Sigma

Additional Job Description

Equal Opportunity Employer                       

As an Equal Opportunity Employer, we are committed to ensuring equal employment opportunities for all job applicants and employees. Employment decisions are based upon job-related reasons regardless of an applicant’s race, color, religion, national origin, marital status, age, disability, protected veteran status, sexual orientation or any other protected status. 
 

The above job description and job requirements are not intended to be all inclusive. CLEAResult retains the right to make changes or adjustment to job descriptions and/or job requirements at any time without notice. 

© Copyright 2013 CLEAResult.   All rights reserved.   



As an Equal Opportunity Employer, we are committed to ensuring equal employment opportunities for all job applicants and employees. Employment decisions are based upon job-related reasons regardless of an applicant’s race, color, religion, national origin, marital status, age, disability, protected veteran status, sexual orientation or any other protected status.

The above job description and job requirements are not intended to be all inclusive. CLEAResult retains the right to make changes or adjustment to job descriptions and/or job requirements at any time without notice.