EEP IT Business Analyst I, II, III

This position is responsible for the maintenance, configuration, and data integrity of the Nicor Gas Energy Efficiency Department’s energyENGINE data warehouse. The role operates within a high-performing, collaborative technical team and plays a critical part in ensuring accurate, timely, and reliable program performance, participation. and financial reporting. Key responsibilities include overseeing data upload processes, facilitating coordination with internal and external stakeholders to maintain data quality, supporting regulatory and financial reporting through data reconciliation and compliance activities, performing alignment checks between operational and financial records, and managing automated energy savings calculations. This position reports to the Manager, EEP IT Projects. JOB REQUIREMENTS: •A four-year college degree (computer science, accounting, or business degree preferred) or equivalent work experience is required •Experience in relational database systems including Oracle and/or SQL Server is preferred •Experience with the Customer Care & Billing (CC&B) platform is preferred •Programming experience using SQL, T-SQL, Python, R is desired •Experience with customer relationship management (CRMs) platforms such as Oracle and/or Salesforce is desired •General understanding of various technical principles, theories, and concepts •Broad understanding of a wide range of technical areas •Excellent problem-solving and analytical skills •Excellent communication skills; able to translate complex or technical ideas into non-technical language •Additional technical skills including Excel (intermediate proficiency), Visio, SSRS/SSIS is a plus INTERPERSONAL SKILLS: •Effectively organizes tasks and manages multiple priorities •Uses discretion concerning confidential and sensitive issues/information •Excellent root cause analysis skills & problem-solving skills •Effective communication and interpersonal skills •Ability to negotiate and influence others. Critical thinking, problem solving, analytical, and written and verbal communication. Level 3 (Business Analyst I) •1–3 years’ experience in utilities or a related analytical/technical field •Foundational experience in data analysis and supporting process improvement efforts •Proficiency in Microsoft Office products, including Excel, Word, and PowerPoint •Working knowledge of SQL, VBA, Python, R •Ability to perform data extraction, validation, and basic analysis within established processes •Developing understanding of systems, data structures, and business processes Level 4 (Business Analyst II) •3–5 years’ experience in utilities or a related analytical/technical field •Proven experience independently analyzing data and leading process improvement initiatives •Experience working within regulatory frameworks and understanding industry standards •Ability to lead and manage moderately complex analytical or modeling efforts to drive business insights •Advanced proficiency in Microsoft tools, including Excel, Power BI, and PowerPoint •Strong technical experience (3–5 years) with tools such as SQL, T-SQL, Python, R, or similar platforms •Ability to work across systems, troubleshoot issues, and implement solutions with minimal oversight Level 5 (Senior Analyst) •5+ years of experience in utilities or a related analytical/technical field •Demonstrated expertise leading complex, cross-functional initiatives and system enhancements •Deep experience designing and implementing data processes, standards, and best practices •Provides oversight and guidance on high-impact decisions affecting data integrity, reporting, and compliance •Strong experience influencing stakeholders across departments and managing vendor relationships •Advanced technical expertise with data, systems, and analytical tools used to drive scalable solutions •Proven ability to drive innovation, improve processes, and