Sr. Data Engineer

American Transmission Co.; City of Pewaukee (WI); On-site; USD 128,000 - 150,000; Full time

Job summary

American Transmission Company (ATC) is seeking a Data Engineer to design and build scalable data solutions for powering the electric grid. You will develop reliable data pipelines, create data models, and support analytics and reporting for business users.

This role requires relocation to Wisconsin or the Upper Peninsula of Michigan, and it is not 100% remote. You will collaborate with IT, analytics, and operations to advance cloud and on-premise data platforms while ensuring data quality and

Qualifications

• Bachelor's degree in Computer Science, Information Technology, MIS, Data Science, Software Engineering
• 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 DevOps, or similar source control and DevOps platforms.
• Experience supporting data governance, data quality, and enterprise data management practices.

Responsibilities

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

Skills

Python

PySpark

Data governance

Communication with stakeholders

Education

Bachelor's degree in Computer Science, Information Technology, MIS, Data Science, Software Engineering

Tools

Microsoft SQL Server (SSMS/SSIS/SSRS/SSAS)

Azure Data Factory

Git

Azure DevOps

Power BI

Microsoft Fabric

Job description

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.

What You’ll Do

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

Drive Data Quality and Reliability

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

Partner Across the Organization

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

Advance Innovation

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

What You’ll Bring Required Qualifications

• 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 DevOps, or similar source control and DevOps platforms.
• Experience supporting data governance, data quality, and enterprise data management practices.

Preferred Qualifications

• Experience with data warehouses, data marts, lakehouses, 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.

Why ATC Purpose‑Driven Work

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

People‑Centric Culture

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

Flexibility & Balance

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

Growth & Development

Curiosity, coaching, and engagement fuel careers. We invest in our people through cross‑functional opportunities, skill‑building, and assignments that stretch potential and build careers.

Comprehensive Rewards

Compensation, benefits, and well‑being offerings are thoughtfully and competitively designed to support employees’ unique needs. Reliable Innovation: Grounded in the communities we serve, we play a critical role in powering the grid, with the agility to innovate, lead, and drive progress in a time of transformational change in the industry.

A Shared Future

We commit to creating an environment where people can do their best work, thrive, and drive success for our customers and stakeholders, delivering a lasting impact for all.

Join our Great Place to Work

Where we build and operate the power grid that enables modern life, and where every role contributes to something bigger than any one of us.

The targeted base pay for this position is $128,400 to $149,800 annually.* Base pay is one component of our comprehensive total rewards package which includes an annual incentive bonus, employer-sponsored pension plan, 401(k) match, HSA contribution, life & disability insurance, health care benefits, generous time off plans, flexible work arrangements, and much more. *The pay range is a general guideline. Employment offers are evaluated individually and consider qualifications, experience, academic achievements, internal equity, and business needs. Pay exceeding the posted range is considered for uniquely qualified candidates. Interested internal candidates, with questions, please consult your Human Resources Business Partner.

Full time

Equal Opportunity Employer: Applicants have rights under employment laws.

ATC is an equal opportunity employer that seeks to foster diverse teams of talented people working safely together. We respect and embrace diversity of all aspects and hire, train and promote employees without regard to race, color, religion, sex, age, national origin, sexual orientation, disability, genetics, protected veteran status, or any other characteristic protected by law. We encourage women, minorities, veterans and individuals with a disability to apply. All qualified applicants will receive consideration for employment without regard to any characteristic protected by law.

Family and Medical Leave Act (FMLA) Poster | U.S. Department of Labor Family and Medical Leave Act Poster Employee Polygraph Protection Act (EPPA) Poster | U.S. Department of Labor ERD-10861 Poster Honesty Testing poster WISCONSIN FAIR EMPLOYMENT LAW

ATC is a transmission‑only electric utility that helps keep the lights on, businesses running and communities strong in Wisconsin, Michigan, Minnesota and Illinois. As owner and operator of more than 9,530 miles of transmission lines and 530 substations, we help meet the electric needs of more than 5 million people in our service area.