Senior Data Engineer

Elkay; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

Zurn Elkay Water Solutions Corporation is looking for a Senior Data Engineer to design and maintain data pipelines and support business intelligence initiatives. Ideal candidates will have hands-on experience in Informatica IICS, Snowflake, and strong SQL skills. Join a values-driven company focused on integrity and quality while enjoying competitive compensation and benefits.

Benefits

Competitive Salary

Medical, Dental, Vision Insurance

Matching 401(k) Contribution

Health Savings Account

Up to 3 Weeks Vacation

12 Paid Holidays

Annual Bonus Eligibility

Educational Reimbursement

Matching Gift Program

Qualifications

• 5-7 years of hands-on experience as a Data Engineer.
• Proven expertise in ETL/ELT pipelines with Informatica IICS and Microsoft Fabric.
• Strong experience with Snowflake for data warehousing and modeling.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Informatica and Microsoft Fabric.
• Collaborate with business teams to understand and support data needs related to Microsoft Dynamics.
• Implement best practices in data governance and quality.

Skills

Informatica IICS

SQL

Python

Snowflake

Microsoft Fabric

Oracle Analytics Cloud

Power BI

Education

Bachelor’s degree in Computer Science, Engineering, Data Science, or related field

Master’s degree preferred

Tools

Microsoft Dynamics 365

Job description

Senior Data Engineer The Company

Zurn Elkay Water Solutions Corporation is a thriving, values-driven company focused on doing the right things. We’re a fast growing, publicly traded company (NYSE: ZWS), with an enduring reputation for integrity, giving back, and providing an engaging, inclusive environment where careers flourish and grow.

Named by Newsweek as One of America’s Most Responsible Companies and an Energage USA Top Workplace, at Zurn Elkay Water Solutions Corporation, we never forget that our people are at the center of what makes us successful. They are the driving force behind our superior quality, product ingenuity, and exceptional customer experience. Our commitment to our people and their professional development is a recipe for success that has fueled our growth for over 100 years, as one of today’s leading international suppliers of plumbing and water delivery solutions.

Headquartered in Milwaukee, WI, Zurn Elkay Water Solutions Corporation employs over 2800 employees worldwide, working from 24 locations across the U.S., China, Canada, Dubai, and Mexico, with sales offices available around the globe. We hope you’ll visit our website and learn more about Zurn Elkay at zurnelkay.com.

If you’re ready to join a company where what you do makes a difference and you have pride in the work you are doing, talk to us about joining the Zurn Elkay Water Solutions Corporation family!

If you are a current employee, please navigate here to apply internally.

Job Summary
We are seeking a highly skilled Senior Data Engineer with hands-on expertise in Informatica IICS, Snowflake, Microsoft Fabric, Oracle Analytics Cloud (OAC) and Tableau, along with functional experience in Microsoft Dynamics 365 Finance and Operations and Dynamics CRM. The ideal candidate will have strong SQL and Python programming skills, take ownership of data projects, collaborate effectively with business teams, and excel as both a team player and an individual contributor to build and maintain scalable data pipelines that drive business success.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Informatica Intelligent Cloud Services (IICS) and Microsoft Fabric Data factory for efficient ETL/ELT processes.

• Build and optimize data models in Snowflake to support analytics, reporting, and business intelligence initiatives.

• Leverage Microsoft Fabric to unify data integration, analytics, and reporting workflows, ensuring seamless data processing and insights delivery.

• Utilize Oracle Analytics Cloud (OAC) to create advanced analytics solutions, including data visualizations and dashboards

• Develop semantic models and data visualizations in Power BI for business insights.

• Implement best practices in data governance, quality, and performance tuning within the Fabric environment.

• Write complex SQL queries to extract, transform, and analyze data, ensuring high performance and accuracy.

• Develop and automate data workflows using Python for data processing, scripting, and integration tasks.

• Create and maintain interactive dashboards and reports using Tableau and OAC to deliver actionable insights to business stakeholders.

• Collaborate with business teams to understand and support data needs related to Microsoft Dynamics 365 Finance and Operations processes.

• Ensure data quality, integrity, and security across all data systems, adhering to best practices and compliance standards.

• Proactively identify opportunities to optimize data workflows, improve performance, and enhance data accessibility for business users.

• Take ownership of data engineering projects, driving them from requirements gathering to deployment while meeting deadlines and quality standards.

• Document data processes, architectures, and workflows to ensure maintainability and scalability.

Qualifications/Requirements

• Bachelor’s degree in computer science, Engineering, Data Science, or a related field (Master’s degree preferred but not required).

• 5 - 7 years of hands-on experience as a Data Engineer

• Proven expertise in Informatica IICS and Microsoft Fabric for building and managing ETL/ELT pipelines.

• Strong experience with Snowflake for data warehousing, data modeling, and performance optimization.

• Proficiency in Oracle Analytics Cloud (OAC) for creating analytics solutions, dashboards, and reports.

• Hands-on experience with Microsoft Fabric for unified data integration, analytics, and reporting.

• Proficiency in Microsoft technologies (e.g., Azure Data Factory, Azure Synapse, SQL Server, or other Azure data services).

• Proficiency in SQL, Python or Spark, Data Warehousing and data modeling.

• Solid understanding of data governance, security, and compliance in cloud environments.

• Experience with CI/CD, version control (Git), and DevOps for data pipelines is a plus.

• Functional experience with Microsoft Dynamics 365 Finance and Operations, including knowledge of its data structures and integration requirements.

• Excellent problem-solving skills and ability to communicate complex technical concepts clearly.

• Strong communication skills to collaborate with business teams, gather requirements, and translate them into technical solutions.

• Ability to work effectively as both a team player and an independent contributor, with a track record of taking ownership of projects.

Capabilities and Success Factors

• Decision Quality – Making good and timely decisions that keep the organization moving forward.

• Manages Complexity – Making sense of complex, high quantity and sometimes contradictory information to effectively solve problems.

• Plans & Aligns – Planning and prioritizing work to meet commitments aligned with organizational goals.

• Drives Results – Consistently achieving results, even under tough circumstances.

• Collaborates – Building partnerships and working collaboratively with others to meet shared objectives.

Total Rewards and Benefits

• Competitive Salary
• Medical, Dental, Vision, STD, LTD, AD&D, and Life Insurance
• Matching 401(k) Contribution
• Health Savings Account
• Up to 3 Weeks Vacation
• 12 Paid Holidays
• Annual Bonus Eligibility
• Educational Reimbursement
• Matching Gift Program

**THIRD PARTY AGENCY: Any unsolicited submissions received from recruitment agencies will be considered property of Zurn Elkay, and we will not be liable for any fees or obligations related to those submissions.**

Equal Opportunity Employer – Minority/Female/Disability/Veteran