Data Engineer - Business Automation & Analytics
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
About the role
Xylem is seeking a Data Engineer - Business Automation & Analytics to join our global team. This role builds and supports data and analytics platforms that power Finance, Operations, and Customer tools across the organization. NOTE: This is a SQL‑first role focused on data transformation and analysis within relational databases, particularly ERP and finance systems. It is not a Spark‑ or cloud‑first data engineering position. The majority of day‑to‑day work is performed in SQL, designing and optimizing relational data models that serve analytics and reporting needs. The Data Engineer is responsible for critical design, support, and management of key internal data platform applications. You'll design, develop, and maintain scalable data pipelines, dashboards, and automations that enable smarter, data-driven decisions supporting Xylem's mission CORE RESPONSIBILITIES Design and build SQL‑centric, relational data pipelines that aggregate and clean data from multiple sources (DB2, Dynamics AX, Progress OpenEdge, Oracle, Salesforce, etc.) Develop, optimize and maintain and maintain complex SQL‑based relational models s in PostgreSQL Orchestrate and automate SQL‑driven transformations using Airflow and Python Deploy and maintain analytics infrastructure across Dev / Test / Prod Linux environments Design and publish Power BI datasets and dashboards using DAX and SQL Partner with process owners and business leads to define metrics and improve data quality Document data flows and automation logic to ensure maintainability and transparency Troubleshoot performance and data issues across systems and environments