Sr. Data Engineer

Summary of Responsibilities:

At American Transmission Company (ATC), data is more than information. It is a strategic asset that helps us operate the electric grid safely, reliably, and efficiently. We're looking for a Data Engineer who is passionate about building scalable data solutions that transform complex information into actionable insights. If you enjoy designing modern data platforms, developing reliable data pipelines, solving technical challenges, and enabling business users through trusted data, this may be the perfect opportunity for you.

Essential Responsibilities:

ATC embraces flexibility in our work and our workplace. We trust our employees to get work done where and when it makes sense, depending on the schedule for the day and the needs of the business. However, this role is not available for 100% remote work and would require relocation to either Wisconsin or the Upper Peninsula of Michigan.

• Design and Build Modern Data Solutions
• Develop and maintain scalable data pipelines and integration solutions.
• Design and support enterprise data platforms that enable analytics, reporting, and operational decision-making.
• Create reliable and efficient ETL/ELT processes using modern cloud and on-premises technologies.
• Develop data models and architectures that support business intelligence and enterprise reporting.

• Ensure the accuracy, performance, security, and maintainability of enterprise data solutions.
• Support data governance, metadata management, and data quality initiatives.
• Implement monitoring, automation, and continuous improvement practices that increase trust in enterprise data assets.

• Collaborate with business stakeholders, analysts, architects, developers, and IT teams.
• Translate business needs into technical solutions and actionable data capabilities.
• Communicate complex technical concepts in ways that support business outcomes and informed decision-making.

• Evaluate new technologies, tools, and development approaches.
• Help modernize data platforms and improve operational efficiency through automation and innovation.
• Contribute to ATC’s evolving cloud and analytics strategy.

• Bachelor's degree in Computer Science, Information Technology, Management Information Systems, Data Science, Software Engineering, or a related discipline.
• Five or more years of experience designing, developing, and supporting production data pipelines.
• Experience building data solutions that support reporting, analytics, and business intelligence.
• Hands‑on experience with Python Notebook, Microsoft Fabric and Azure Data Factory.
• Strong Python and PySpark development experience.
• Experience integrating systems through REST and SOAP APIs.
• Experience with Microsoft SQL Server technologies including SSMS, SSIS, SSRS, and SSAS.
• Experience using Git, Azure Dev Ops, or similar source control and Dev Ops platforms.
• Experience supporting data governance, data quality, and enterprise data management practices.

• Experience with data warehouses, data marts, lake houses, or modern cloud‑based data platforms.
• Experience developing CI/CD pipelines and deployment automation.
• Experience with data observability, monitoring, and performance tuning.
• Knowledge of enterprise data architecture and master data management.
• Experience with Microsoft Power BI or comparable analytics platforms.
• Experience working in utility, energy, infrastructure, manufacturing, or other regulated industries.

We’re energized by meaningful and challenging work that contributes to the greater good, from powering everyday life to grid modernization.

We are difference makers. We lead with trust, value collaboration, and foster a supportive environment where people grow, contribute openly, and make a difference.

Our work environment encourages autonomy, connection, and choice with accountability.

Curiosity, coaching, and engagement fuel careers. We invest in our people through cross‑functional opportunities, skill‑building, and…