Energy Efficiency Forecasting and Data Analyst - OAK BROOK, ILLINOIS, UNITED STATES OF AMERICA

  • ICF
  • Oak Brook, Illinois, United States of America
  • Aug 14, 2020
Full time Professional Services

Job Description

Job Description:

To support our growth we are currently seeking an analyst for our Energy Efficiency division to coordinate activities related to the implementation of commercial and industrial energy efficiency programs for our Illinois client.  Our ICF team includes a cross-functional team organization of program management, outreach, technical services, program tracking, reporting and marketing.  The Forecasting and Data Analyst will serve as the data scientist for the public sector program and provide expertise as needed across the contracted program portfolio. Additionally, the Data analyst will work with sub-contractors in the development of budget accruals, program performance forecasts both short and long term. The analyst will monitor and provide quality control and quality assurance duties related to the program’s database that tracks all projects and their status for the program.  Management of this database will include tasks related to forecasting of future participation and budget expenditure for the program. 

Responsibilities include:

  • Manage the daily maintenance of program databases, utilized by the program implementation team, to ensure data integrity
  • Prepare reports to accurately describe activities in the field and to monitor progress towards program goals on customer participation and the completion of eligible projects
  • Utilize historic data and simulations to project annual program participation
  • Maintain business workflow documents
  • Work with IT to improve database systems and architecture
  • Ensure that the program is performing as expected, and explain forecasted variances to leadership
  • Collaborate with program managers to ensure all activities related to quality program delivery is executed
  • Maintain and update shared files, resources and program documents to ensure all program staff has access to latest versions of materials.
  • Perform reconciliation task between qualified leads stored in program CRM solution and Project Database
  • Identify opportunities to optimize forecasting models, program database and budget accruals 

Basic Qualifications:

  • BS/BA degree in Engineering, Economics, Mathematics, Computer Science, Business Administration/Management or similar with 2 + years related experience.
  • 2+ years of experience with at least one statistical or scripting software such as R, STATA, SPSS, or Python
  • 2+ years of experience using SQL for acquiring and transforming data
  • 2+ years of data visualization skills
  • 2 + years of MS Excel experience

Working at ICF

Working at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth. If you’re seeking to make a difference in the world, visit to find your next career. ICF—together for tomorrow.

ICF is an equal opportunity employer that values diversity at all levels. (EOE – Minorities/Females/ Protected Veterans Status/Disability Status/Sexual Orientation/Gender Identity). For more information, please read our EEO & AA policy.

Reasonable Accommodations are available for disabled veterans and applicants with disabilities in all phases of the application and employment process. To request an accommodation please email and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about non-discrimination:  EEO is the law and  Pay Transparency Statement.

Oak Brook, IL (IL13)