Apply on Employer Site

Pentair · 1 month ago

Data Engineer - Golden Valley, MN (Hybrid)

Golden Valley, MN

Full-time

Hybrid

Mid Level

$96K/yr - $177K/yr

3+ years exp

Pentair is a company committed to sustainable water solutions, serving customers globally. They are seeking a Data Engineer to develop and maintain data and analytics platforms that drive insights and strategic decisions across the organization.

ElectronicsIndustrial ManufacturingManufacturingWater

H1B Sponsor Likely

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

Qualification

Azure Data FactorySQL programmingData warehouse developmentData modelingETL/ELT processesData profilingCertifications in SQL ServerCertifications in Azure Data FactoryProblem-solving skillsCommunication skillsCollaboration skillsAdaptability

Required

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

Preferred

Experience using data in a business/finance role for modeling or advanced analytics

Certifications in Microsoft SQL Server and Azure Data Factory are a plus

Benefits

Health benefits

Generous 401(k)

Employee stock purchase program

Disability benefits

Life insurance

Critical illness insurance

Accident insurance

Parental leave

Caregiver leave

Tuition reimbursement

Paid time off

Wellness programs

Company

Pentair

Glassdoor3.9

Pentair produces water disposal pumps, filter housings, valves, tanks, and commercial pool equipment.

Founded in 1966

Twickenham, Richmond upon Thames, GBR

5001-10000 employees

http://www.pentair.com

H1B Sponsorship

Pentair has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (1)