EEP IT Business Analyst I, II, III

Southern Company • Naperville, IL

1d • $58,388 - $121,406

About The Position

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.

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
• 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.
• 1–3 years’ experience in utilities or a related analytical/technical field (for Business Analyst I)
• Foundational experience in data analysis and supporting process improvement efforts (for Business Analyst I)
• Proficiency in Microsoft Office products, including Excel, Word, and PowerPoint (for Business Analyst I)
• Working knowledge of SQL, VBA, Python, R (for Business Analyst I)
• Ability to perform data extraction, validation, and basic analysis within established processes (for Business Analyst I)
• Developing understanding of systems, data structures, and business processes (for Business Analyst I)
• 3–5 years’ experience in utilities or a related analytical/technical field (for Business Analyst II)
• Proven experience independently analyzing data and leading process improvement initiatives (for Business Analyst II)
• Experience working within regulatory frameworks and understanding industry standards (for Business Analyst II)
• Ability to lead and manage moderately complex analytical or modeling efforts to drive business insights (for Business Analyst II)
• Advanced proficiency in Microsoft tools, including Excel, Power BI, and PowerPoint (for Business Analyst II)
• Strong technical experience (3–5 years) with tools such as SQL, T-SQL, Python, R, or similar platforms (for Business Analyst II)
• Ability to work across systems, troubleshoot issues, and implement solutions with minimal oversight (for Business Analyst II)
• 5+ years of experience in utilities or a related analytical/technical field (for Senior Analyst)
• Demonstrated expertise leading complex, cross-functional initiatives and system enhancements (for Senior Analyst)
• Deep experience designing and implementing data processes, standards, and best practices (for Senior Analyst)
• Provides oversight and guidance on high-impact decisions affecting data integrity, reporting, and compliance (for Senior Analyst)
• Strong experience influencing stakeholders across departments and managing vendor relationships (for Senior Analyst)
• Advanced technical expertise with data, systems, and analytical tools used to drive scalable solutions (for Senior Analyst)
• Proven ability to drive innovation, improve processes, and implement long-term system and data strategies (for Senior Analyst)
• Experience building and updating ETL processes using SSIS and/or other ETL-related software (for Senior Analyst)

Nice To Haves

• Experience in relational database systems including Oracle and/or SQL Server
• Experience with the Customer Care & Billing (CC&B) platform
• Programming experience using SQL, T-SQL, Python, R
• Experience with customer relationship management (CRMs) platforms such as Oracle and/or Salesforce
• Additional technical skills including Excel (intermediate proficiency), Visio, SSRS/SSIS

Responsibilities

• Oversee the 1099 reporting process, including data loading and reconciliation between energyENGINE and the 1099 STARS database to ensure accuracy and compliance.
• Perform detailed reconciliation of project data against implementation contractor invoices to ensure alignment between operational and financial records.
• Ensure tasks and deliverables are completed on time to minimize business impacts.
• Lead bi-weekly meetings with internal teams and external partners to review file status, monitor record integrity, and drive resolution of outstanding data issues.
• Coordinate with internal and external stakeholders to ensure data accuracy and timely delivery.
• Support vendor management activities, including reconciliation, feedback, and system coordination.
• Consistently engages with Energy Efficiency Department to strengthen communication and support business needs.
• Collaborate effectively across cross-functional teams.
• Oversee the elements of vendor management for the Energy Efficiency IT department and serve as the central point person between various operational functions and cross-functional teams to carry out various activities including, but not limited to reconciliation/auditing, feedback, system configuration, etc.
• Administer and maintain Salesforce, including user setup, configurations, and enhancements.
• Manage the PUP (Project UPload), ensuring invalid records are promptly identified and resolved through coordination with internal and stakeholders while upholding strict data quality standards.
• Manage SharePoint environments, including permissions and site development.
• Manage automated energy savings calculations and financial tracking for the energy efficiency programs.
• Develop and execute SQL queries to support reporting and data analysis.
• Design and implement data analytics and visualization solutions (e.g., Power BI).
• Support system development lifecycle activities (design, testing, deployment).
• Manage and support platforms such as STARS, Acoustic/IBM Watson/Silverpop, and Smartsheet.
• Provide technical solutions for complex data and reporting challenges.
• Deliver recommendations for system and process enhancements.
• Conduct periodic security and audit reviews.
• Support system implementations and technology initiatives.
• Develop reports and dashboards for KPIs and performance metrics.
• Lead or support special IT and data-related projects.
• Demonstrate proactive problem-solving and independent execution.
• Drive adoption and value realization. Define success metrics, oversee pilots, and guide scaling of technical solutions across operating companies.

Benefits

• Competitive base salary
• Annual incentive awards for eligible employees
• Health, welfare and retirement benefits designed to support physical, financial, and emotional/social well-being
• Additional compensation, such as an incentive program

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Associate degree