Business Analyst II

This position supports the design, development and execution of innovative analytic and research solutions to support the planning, program implementation, accounting and evaluation of energy efficiency programs. The role plays a versatile part that is highly analytical and will require the individual to blend the application of business, strategic, and design thinking with technology and quantitative / economic modeling methods to enable better data driven decision making.

This individual is involved with completing complex analytical projects requiring the use of data analysis, data visualization, and statistical modeling techniques. The position will work closely with internal and external stakeholders such as program managers, commission staff, independent evaluators, and implementation vendors to accurately evaluate and measure energy savings. The role requires extensive collaboration with both internal and external stakeholders who are responsible for our residential and business programs, as well as assuring IT systems are modified to collect and track data, accounting and controls are updated, and ultimately the design allows for the programs and portfolio to pass cost benefit tests required under Illinois law.

This position is located in Naperville, Illinois

Employees are required to be in the office (4) days per week.

JOB RESPONSIBILITIES

This role will be responsible for utilizing technical acumen, analytical capabilities, and collaborative skills to contribute to the Energy Efficiency portfolio and program success. This role will also ensure that delivered solutions are effective and align with the organization's strategic objectives and includes but is not limited to:

Planning, Operations and Evaluation Analysis

* Supports highly complex research, process improvement, feasibility studies, market analysis, segmentation analysis, economic impact studies, and data analytics studies to identify, design, and vet programs and policies through department leadership, other departments, and other stakeholders.

* Supports the multi-year and annual strategic planning and operations processes; oversee the preparation of efficiency program goals; establish targets; and program participation levels to assist in the Planning and implementation process.

* The position will assist in the design of existing and future energy efficiency programs and services, that relate to forecasting/reporting and analytical studies to improve existing energy efficiency programs and services.

* Understanding of the existing program designs and contracts to enhance existing programs by monitoring and tracking key performance indicators and developing program cost allocation methodologies.

* Support planning efforts for program implementation activities associated with existing and new energy efficiency programs, products and services that meet statutory objectives, and process improvements that allow us to serve our customers more comprehensively.

* Analyze, interpret and report on program performance and evaluation and measurement verification (EMV) results, and make related recommendations and manage implementation of recommendations and annual program trackers.

* Respond to cost effectiveness requests of energy efficiency measures and programs

* Identify, develop and validate assumptions, and product qualifying lists related to energy efficiency for the various analysis required for defining the department's strategic plan/implementation and to support the decision-making process.

* Work with program managers to understand program goals that inform and prioritize data analysis projects to support strategic decision making

* Facilitate the annual project upload (PUP) data collection process, ensuring implementation data is passed into the Data Warehouse, troubleshoot data invalids, confirm Technical Reference Manual (TRM) requirements are met for claiming savings and complete end of year reconciliation between PUP data, forecasting and accounting actuals

* Maintain knowledge of energy efficiency measures in TRM and have the ability to understand algorithms used and impacts of changes to the energy efficiency programs.

* Analyze, interpret and report on EMV and cost effectiveness study results, and make related recommendations and manage implementation of recommendations.

Data Analytics

* Supports development of a data analytics program that leverages Power BI data visualization, advanced analytics and big data to deliver on key business operational and strategic initiatives.

* Gathers, extracts, manipulates, analyzes and models data using analytical and statistical methods to assist with current and future planning decisions and programs.

* Researches and recommends new opportunities and appropriate market segments to target; analyzes data to measure the effectiveness of the energy efficiency program, measures and marketing campaigns.

* Perform econometric and statistical modeling and analysis in support of energy efficiency programs planning…