Data Engineer - Business Automation & Analytics

XylemCharlotte, NC
Hybrid

About The Position

Xylem is a Fortune 500 global water solutions company dedicated to advancing sustainable impact and empowering the people who make water work every day. As a leading water technology company with 23,000 employees operating in over 150 countries, Xylem is at the forefront of addressing the world's most critical water challenges. We invite passionate individuals to join our team, dedicated to exceeding customer expectations through innovative and sustainable solutions. The role is for a Data Engineer – Business Automation & Analytics to join Xylem's global team. This role builds and supports data and analytics platforms that power Finance, Operations, and Customer tools across the organization. This is a SQL-first role focused on data transformation and analysis within relational databases, particularly ERP and finance systems, and 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. The company's products impact public utilities, industrial sectors, residential areas, and commercial buildings, with a commitment to providing smart metering, network technologies, and advanced analytics for water, electric, and gas utilities. Xylem is dedicated to providing reasonable accommodations to enable all employees to perform their essential job functions and reserves the right to modify this job description and assign additional duties as needed.

Requirements

  • Heavy SQL/PostgreSQL
  • Airflow (pipelines/orchestration)
  • Python
  • Experience with ERP/CRM data in finance/operations
  • Linux (on-prem familiarity)
  • Bachelor’s degree in Data Engineering, Business Information Systems, or related field
  • 3+ years hands on experience building and maintaining data pipelines or ETL jobs
  • Experience with PostgreSQL (preferred) or other RDBMS
  • Advanced SQL proficiency with hands-on experience transforming data in relational databases (PostgreSQL strongly preferred)
  • Familiarity with Linux / Red Hat environments and version control (Git)
  • Understanding of ERP, CRM, and MRP data models (Dynamics, Salesforce, etc.)
  • Experience with Power BI or similar BI tools (DAX, data modeling)
  • Solid communication, documentation, and follow through

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 complex SQL-based relational models 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

Benefits

  • Paid Volunteer Program, Xylem Watermark
  • Inclusion and belonging
  • Employee Resource Groups (ERG)
  • Equal Employment Opportunity (including disability and veterans) and Affirmative Action workplace
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service