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 efforts. Clean and analyze complex data sets, collect weather data, merge data from various sources. Creates data visualizations to distill information and provide meaningful conclusions and recommendations internally and to industry clients. Communicate analysis plans, methodology, and findings in reports and proposals. JOB REQUIREMENTS Business Analyst II (GSE03) Education, Certifications/Licenses Required Bachelor’s degree in business, engineering, economics, mathematics, computer science, or data analytics, a related field, or equivalent work experience. Work Experience Required Prefer combined experience with the utilities or other related experience. Experience analyzing data and process improvement. Demonstrated ability to work independently and make well-informed decisions. Strong organizational skills with attention to detail. Proven track record of meeting deadlines and delivering high-quality work. Knowledge of business practices and trends within the natural gas industry, with a willingness to expand expertise in this area. Proficiency in Microsoft Office products, including Excel, PowerPoint and Power BI, as well as other presentation software. Knowledge of business-related systems (i.e. SQL, VBA, Python, R, ArcGIS, etc.) Duties Discretion Employee receives clear instructions from supervisor regarding what to do and how to do it. Tasks follow set guidelines or procedures. Employee must consider alternative courses of action and then make a decision after considering the options. Employee has the authority to make significant choices and decisions, without specific guidance or direction from the supervisor. About Southern Company Gas Southern Company Gas is a wholly owned subsidiary of Atlanta-based Southern Company (NYSE:SO), America’s premier energy company. Southern Company Gas serves approximately 4.2 million natural gas utility customers through its regulated distribution companies in four states and approximately 600,000 retail customers through its companies that market natural gas. Other nonutility businesses include investments in interstate pipelines and ownership and operation of natural gas storage facilities. For more information, visit southerncompanygas.com. Southern Company (NYSE: SO ) is a leading energy provider serving 9 million customers across the Southeast and beyond through its family of companies. Providing clean, safe, reliable and affordable energy with excellent service is our mission. The company has electric operating companies in three states, natural gas distribution companies in four states, a competitive generation company, a leading distributed energy solutions provider with national capabilities, a fiber optics network and telecommunications services. Through an industry-leading commitment to innovation, resilience and sustainability, we are taking action to meet customers' and communities' needs while advancing our goal of net-zero greenhouse gas emissions by 2050. Our uncompromising values ensure we put the needs of those we serve at the center of everything we do and are the key to our sustained success. We are transforming energy into economic, environmental and social progress for tomorrow. Our corporate culture has been recognized by a variety of organizations, earning the company awards and recognitions that reflect Our Values and dedication to service. To learn more, visit Southern Company invests in the well-being of its employees and their families through a comprehensive total rewards strategy that includes competitive base salary, annual incentive awards for eligible employees and health, welfare and retirement benefits designed to support physical, financial, and emotional/social well-being. This position may also be eligible for additional compensation, such as an incentive program, with the amount of any bonus/awards subject to the terms and conditions of the applicable incentive plan(s). A summary of the benefits offered for this position can be found here Additional and specific details about total compensation and benefits will also be provided during the hiring process. Southern Company is an equal opportunity employer where an applicant's qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other basis prohibited by law. Job Identification: 19663 Job Category: Data Analytics Job Schedule: Full time Company: Nicor Gas Pay Range: 58,388.00 - 91,753.20 USD Annually: Base salary varies depending on a wide array of factors, which may include but are not limited to the specific office location, role, skill set, and level of experience. As required by local law, and at the time of this posting, this is the reasonable salary range for this role. #J-18808-Ljbffr