Business Analyst , II or III

BUSINESS ANALYST

The Business Analyst position lies within the AGL Services Company supporting the FP&A & Regulatory department exclusively supporting the retail natural gas business (“South Star”). This full-time position is accountable for managing the end-to-end reporting and advanced analytics for South Star Retail across all markets. The position requires integrating and harmonizing large, complex datasets from multiple sources into structured, actionable intelligence that drives strategic decision‑making.

Responsibilities include designing and maintaining data models, performing quantitative analysis, and generating insights that inform business recommendations and operational improvements.

The role involves cross‑functional collaboration with internal departments and external business partners to ensure data accuracy, consistency, and alignment with organizational objectives. Strong technical proficiency in SQL for data extraction and transformation, Power BI for interactive dashboards and visualization, and experience with relational database technologies is essential. Familiarity with ETL processes, data warehousing concepts, and advanced analytics tools (e.g., Python, R) is highly desirable.

A deep understanding of the company’s revenue streams, cost drivers, and financial architecture, combined with comprehensive knowledge of all functional domains, is critical for success in this position.

This position follows a hybrid work schedule. Employees are required to be in the office four (4) days per week – Monday through Thursday.

This position may be filled as Business Analyst I, Senior, or Staff. Individuals who demonstrate advanced skills in terms of work experience, education, and certifications may be eligible for the more advanced position.

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill(s), and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential responsibilities.

• Responsible for preparation of all South Star Retail reporting, including, but not limited to:
  Customer operations, Call Center data analysis, customer counts, revenue, cost of goods, gains & losses; credit and collections etc.
• Maintaining and management of pricing structures and rate codes for all products across the company’s expanded markets, ensuring accuracy for specific date ranges and alignment with business objectives.
• Communicating and collaboration of all pricing and rate code changes with local distribution companies (LDCs) and ensuring timely posting and compliance with regulatory and market requirements.
• Updating and validation of pricing and rate code information in to internal systems, guaranteeing data integrity and availability for operational, reporting, and customer‑facing processes.
• Performs analysis and reporting associated with the business unit metrics, such as revenue, cost of goods and gross margins. Analysis is composed generally of multiple parts of information.
• Take lead role in defining data standards and processes across all markets.
• Develop business modeling and ad‑hoc analysis as needed to support business objectives.
• Business Intelligence reporting using tools such as:
  Power BI, etc.
• Makes design modifications and enhancements to the Company’s revenue/cost models.
• Manages the receipt of customer data from the company’s multiple data sources.
• Analyzes data, creates summary reporting and performs sensitivity analysis to support the decision making of senior management and other departments in the company.
• Creates and implements visual and computer‑based analyses for the business to self‑service data and information.
• Provides subject matter expertise‑level development & support in Power BI analysis.
• Leverages data warehouses, transact systems to assist the business in understanding its data and how to best utilize data from various systems.

An Analyst is expected to work independently and collaboratively, handle complex…