Business Analyst I, II or III

Southern Company•Atlanta, GA

6h•Hybrid

About The Position

The Business Analyst position lies within the AGL Services Company supporting the FP&A & Regulatory department exclusively supporting the retail natural gas business (“SouthStar”). This full-time position is accountable for managing the end-to-end reporting and advanced analytics for SouthStar 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.

Requirements

An Analyst is expected to work independently and collaboratively, handle complex datasets, provide insights that influence strategic decisions and demonstrate adaptability across functional areas.
Critical thinking: Ability to analyze situations, evaluate evidence, and synthesize information to arrive at logical conclusions.
Problem-solving: Breaking down complex challenges and finding effective solutions.
Business process modeling: Understanding and improving workflows and processes.
Data visualization: Ability to create charts, graphs, and infographics.
Microsoft Office skills using Excel, Word, Teams, SharePoint, PowerPoint, Power-BI.
Data analysis tool experience with, for example, SQL, Python, and Tableau.
Technical proficiency: Familiarity with databases, systems analysis, and business intelligence tools.
Requirements gathering and documentation: Translating business needs into clear, actionable requirements.
Exhibit high level of personal responsibility and can independently set priorities of tasks amongst multiple assignments.
Ability to multitask and prioritize assignments along with excellent organization and time management skills.
Can clearly convey findings, requirements, and recommendations to stakeholders and the ability to translate complex technical concepts for non-technical stakeholders.
Ability to build and maintain strong relationships and ensure alignment with organizational goals.
Ability to create reports, dashboards, and presentations to communicate ideas and insights.
Experience and understanding of risk management, internal controls, and governance.
Experience in forecasting, financial planning and analysis.
Compliance and regulatory understanding.
Experience with business operations, market trends, and strategic objectives.
Ability to evaluate the financial viability of proposed ideas and solutions and draw conclusions.
Effective project management skills, including time management and work plan development.
Ability to adapt as conditions warrant.
Ability to move issues forward to resolution.
Shall demonstrate behaviors consistent with Southern Company core values: Safety First Intentional Inclusion Act with Integrity Superior Performance
Comfortable working in a team environment.
Possess good interpersonal skills that include a positive attitude and respect for others.
Exhibit initiative and take personal responsibility for assignments.
Flexible and comfortable with frequent change.
Customer service orientation.
Bachelor’s degree in business, finance, economics, statistics, engineering, computer science, information systems or related fields.
7+ years’ data analysis experience
Demonstrated research, data mining, and analytics experience
Proficiency with SQL, Python, AI, GenAI, Alteryx, Azure, Data Bricks, RPA tools.
Advanced proficiency with analytics software and technical tools (Excel, PowerPoint, Power-BI)
Statistical and forecasting experience utilizing statistical software
Advanced presentation skills
Demonstrated track record of business model creation and management
Leadership acumen and experience

Nice To Haves

Advanced degree is a plus
Preferred: Utility, natural gas or other energy industry experience

Responsibilities

Responsible for preparation of all SouthStar 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.