Data Engineer - Golden Valley, MN (Hybrid)

Pentair•Golden Valley, MN

5d•$95,500 - $177,300•Hybrid

About The Position

Data Engineer – Golden Valley, MN 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 Data Engineer to join our Enterprise IT Data & Analytics team in Golden Valley, MN. In this role, you will be instrumental in developing and maintaining our data & analytics platforms, which is crucial for driving insights and strategic decisions across the company. 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.)

Requirements

Bachelor's degree in Computer Science, Information Systems, Data Science, Finance, or a related field. Equivalent work experience may be considered.
3+ years of experience in data warehouse development.
Experience with Azure Data Factory for orchestrating and automating data movement and transformation.
Proficiency in SQL programming, including complex query optimization, stored procedures, and functions.
Solid understanding of data modeling concepts and experience in designing and implementing database schemas.
Familiarity with data profiling and quality assurance techniques.
Familiarity with cloud-based data warehousing services and integration with Azure cloud services.
Strong problem-solving and analytical skills with the ability to identify data-related issues and propose effective solutions.
Experience with performance tuning and optimization of SQL queries, ELT/ETL processes, and database systems.
Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
Ability to work on multiple projects simultaneously and meet deadlines.
Adaptability to changing business requirements and technology landscapes.

Nice To Haves

Experience using data in a business/finance role for modeling or advanced analytics preferred.
Certifications in Microsoft SQL Server and Azure Data Factory are a plus.

Responsibilities

Design, develop, and maintain Azure Data Factory pipelines to facilitate efficient data extraction, loading, and Transformation (ELT/ETL) processes as well as maintain SQL Server Integration Services (SSIS) packages.
Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications for data integration and data platform solutions.
Implement and manage ETL & ELT processes, ensuring data accuracy and integrity.
Create and optimize complex SQL queries, stored procedures, and functions to extract, load and transform data from various data input sources and output tools (TM1, PowerBI, etc.).
Perform data profiling and analysis to identify data quality issues and propose appropriate solutions.
Implement data cleansing, transformation, and validation rules to ensure the accuracy and consistency of data.
Collaborate with business analysts and ensure seamless data flow and integration across various platforms.
Monitor and optimize the performance of SQL queries, ELT/ETL processes, and database systems to ensure efficient data processing and system reliability.
Troubleshoot and resolve data-related issues, including data integration failures, data quality problems, and performance bottlenecks.
Stay up to date with industry trends and best practices in data engineering, data integration, analytics and AI technologies.

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume