Senior Data & Process Automation Engineer

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 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 www.southerncompany.com .

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 bonus/awards 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 https://seo.nlx.org/southernco/pdf/SOCO-Benefits.pdf . 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.

Job Identification: 17730

Job Category: Information Technology

Company: Southern Company Services