Senior Data & Process Automation Engineer

Job Description

Senior Data & Process Automation Engineer

Summary
The Senior Data & Process Automation Engineer leads the design and delivery of automated data pipelines, analytics solutions, and dashboards that provide clear visibility into operational metrics and key performance indicators (KPIs). This role partners closely with business and technical stakeholders to define measurement standards, automate data collection and transformation, and deliver executive-ready insights that drive informed decision-making and process improvement.

This position blends automation engineering, data analytics, and operational excellence to reduce manual effort, improve data reliability, and enable scalable, repeatable reporting across teams.

Key Responsibilities
Lead discovery with stakeholders to define business questions, KPI definitions, data requirements, and reporting standards
Design, build, and maintain automated workflows and pipelines to extract, transform, and compile data from multiple sources
Develop and maintain executive-ready dashboards and reporting solutions that support operational performance reviews and decision-making
Establish and maintain scalable data models and standardized metric definitions to ensure consistency across teams and reporting periods
Implement data quality checks and monitoring to improve accuracy, completeness, and reliability of reporting outputs
Translate complex data into clear insights, narratives, and recommendations for technical and non-technical audiences
Document data sources, transformations, automation logic, and reporting definitions to support maintainability and auditability
Identify opportunities to standardize and automate recurring processes, reducing manual reporting effort and cycle time
Influence stakeholders by recommending improvements to data capture, instrumentation, and measurement practices
Leverage AI-enabled capabilities within analytics and automation platforms to enhance insights, accelerate reporting, and improve the clarity and usability of dashboards and metrics

Required Technical Skills

Automation and Integration
Strong experience with automation and scripting in cloud and enterprise environments
Proficiency with Python and PowerShell
Experience building API-driven integrations using REST-based services
Hands-on experience with Microsoft Power Automate or similar workflow automation platforms

Data Platforms
Strong SQL skills (SQL Server / Azure SQL)
Experience using Azure Data Factory for data integration and orchestration
Working knowledge of Azure Synapse Analytics or comparable cloud data warehousing solutions

Reporting and Analytics
Experience leading the design and delivery of dashboards and reports using BI platforms (e.g., Power BI, Tableau), including developing scalable data models that support standardized metrics and KPIs across stakeholders

Communication and Professional Skills
Strong written and verbal communication skills, with the ability to present complex data clearly to non-technical audiences
Proven ability to lead cross-functional discussions, gather requirements, and drive deliverables to completion
Ability to translate ambiguous business needs into well-defined technical solutions
Comfortable influencing stakeholders and setting expectations in a matrixed environment

Preferred Technical Skills
Experience integrating data from SaaS platforms and enterprise systems
Familiarity with data governance concepts such as data definitions, lineage, and metric consistency
Experience with source control, CI/CD, or automation best practices for scripts and reporting artifacts
Exposure to additional Microsoft automation or data tools such as Logic Apps, Azure Functions, or Dataverse
Background in process improvement, operational reporting, or KPI program implementation

Experience and Education
5 plus; years of experience in data analytics, automation engineering, business intelligence, or a related role
Demonstrated experience partnering with stakeholders to define KPIs, establish reporting standards, and deliver solutions that are adopted in practice
Bachelor's degree in computer science, Information Systems, Engineering, or equivalent practical experience

About Us

About Southern Company

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 bonawards 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.

About the Team

Southern Company Services