> Markdown version of [/jobs/ext/146017-senior-data-process-automation-engineer](https://www.wearedevelopers.com/jobs/ext/146017-senior-data-process-automation-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data & Process Automation Engineer - **Company:** Southern Company - **Location:** Birmingham, AL, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Adaptable Database Systems, Artificial Intelligence, Data Analysis, Software as a Service, Cloud Computing, Information Systems, Continuous Integration, Data Governance, Data Integration, Database Queries, Python (Programming Language), Microsoft SQL Server, SQL Azure, Windows PowerShell, Power BI, Systems Integration, Tableau (Software), Enterprise Software Applications, Microsoft Power Automate, Azure Data Factory, Information Technology, Data Analytics, Data Management, Api Design, Azure Synapse Analytics, Software Version Control, Serverless Computing - **Published:** May 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=c7526256002b961b ## About the Role 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, * 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 ## Description 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 ## Related Videos - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [API Design - Getting Started](https://www.wearedevelopers.com/videos/33-api-design-getting-started) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)