Lead Data Engineer and Architect

At Pentair, you will work alongside passionate problem-solvers who are committed to the future of our planet. We put our purpose into practice, helping people sustainably move, improve, and enjoy water, life's most essential resource. From our residential and commercial water solutions to industrial water management and everything in between, our 9,750 global employees serve customers in more than 150 countries, working to help improve lives and the environment around the world. 

We have an opportunity for a Lead Data Engineer and Architect to join our Golden Valley, MN team. You will lead the design, development, and governance of our enterprise data platforms. These platforms are both on-premises (SQL Server) and cloud-based (Azure, Microsoft Fabric) and source data from several ERP platforms and produce output to financial (TM1, OneStream, etc.) and analytics platforms (PowerBI, Cognos, etc.). You will play a key role in shaping the future of our data ecosystem, ensuring it is scalable, secure, and aligned with business goals.

This position requires a visionary and technically skilled leader with deep experience in data engineering and architecture. The ideal candidate will be adept at designing modern data platforms, driving data governance initiatives, and mentoring engineering teams to deliver high-quality, sustainable solutions.

You will:

• Architect and oversee the development of scalable, efficient Azure Data Factory pipelines and SSIS packages to support enterprise-wide ELT/ETL processes, ensuring alignment with data platform strategy and performance standards.
• Lead cross-functional collaboration to define and translate complex business requirements into robust, scalable data architecture and integration solutions.
• Establish and enforce best practices for ETL/ELT development, ensuring data accuracy, integrity, and consistency across systems and teams.
• Design and optimize advanced SQL solutions, including stored procedures and functions, to support high-volume data processing and analytics across diverse platforms (e.g., TM1, PowerBI).
• Drive data profiling and quality initiatives, identifying systemic issues and implementing proactive solutions to improve data reliability and usability.
• Define and implement enterprise data transformation and validation frameworks, ensuring consistent application of business rules and data standards.
• Partner with business analysts and data consumers to ensure seamless, governed data flows across operational and analytical systems.
• Monitor and tune data platform performance, proactively identifying and resolving bottlenecks in SQL, ELT/ETL, and infrastructure layers.
• Lead root cause analysis and resolution of complex data issues, coordinating across teams to ensure long-term stability and resilience.
• Champion innovation and continuous improvement, staying current with emerging trends in data engineering, Microsoft Fabric, analytics, and AI, and evaluating their applicability to enterprise needs.

Key Qualifications: 

• Bachelor’s or master’s degree in computer science, Information Systems, Data Science, or a related field. Equivalent work experience may be considered.
• 7+ years of experience in data engineering, with at least 3 years in data architecture or technical leadership role.
• Deep expertise in SQL, data modeling, and performance tuning.
• Strong understanding of data governance, data quality, and metadata management frameworks.
• Experience with modern data platforms, including Azure Synapse, Microsoft Fabric, and PowerBI.
• Excellent communication and leadership skills, with the ability to influence and collaborate across technical and business teams.
• Preferred: Familiarity with financial and business analytics platforms (e.g., TM1, OneStream).
• Preferred: Functional experience working with and/or implementing modern medallion architecture.
• Certifications in Microsoft Azure, Data Engineering, or related technologies are a plus.
• Excellent interpersonal and communication skills.

Compensation:

For this full-time position working at this location, the anticipated annualized base pay range will be from $110700 - $205600 / year. At Pentair, it is not typical for an individual to be hired near the bottom or top of the pay range. Pentair considers various factors in determining actual compensation for this position at the expected location. Actual compensation will be commensurate with a demonstrable level of experience and training, pertinent education including licensure and certifications, work location, and other relevant business or organizational needs. This position may be eligible for other forms of compensation such as, annual incentive bonus.

Benefits:

As a Pentair employee, you would enjoy a wide array of benefit options to help keep you and your family healthy and protected, health benefits, a generous 401(k), employee stock purchase program, disability benefits, life insurance, critical illness insurance, accident insurance, parental leave, caregiver leave, tuition reimbursement, plus paid time off and wellness programs to encourage a healthy work/life balance.

Pentair is an Equal Opportunity Employer. With our expanding global presence, cross-cultural insight and competence are essential for our ongoing success. We believe that a diverse workforce contributes different perspectives and creative ideas that enable us to continue to improve every day.