Business Intelligence Specialist

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.

• Act as a trusted, knowledgeable resource for supply chain stakeholders, supporting discovery sessions across manufacturing sites to understand processes, pain points, and data availability.
• Apply knowledge of SIOP/S&OP, MRP, demand planning, capacity planning, and inventory management to support the translation of business concepts into analytics requirements and data models under the direction of the Analytics Manager.
• Validate data outputs against operational reality; identify data quality issues rooted in business process gaps.
• Contribute to and help maintain business glossaries, KPI definitions, and domain context documentation for the ISC Analytics portfolio.

• Conduct exploratory data analysis to identify trends, anomalies, and opportunities across supply chain datasets.
• Apply basic statistical methods (descriptive statistics, correlation, regression, time-series decomposition) to support forecasting and root cause analysis.
• Design, build, and maintain interactive dashboards and scorecards in Power BI per stakeholder requirements.

• Develop and support ETL/ELT pipelines in Databricks using Python/SQL, in coordination with Central IT, to ingest, transform, and serve data from enterprise sources.
• Configure and maintain schemas, tables, and views within Databricks following medallion architecture (Bronze/Silver/Gold) standards, including curation of the Gold semantic layer that serves dashboards and AI systems.
• Write performant SQL and Python for data transformation, validation, and pipeline orchestration.
• Support data quality checks, logging, and monitoring across pipeline layers.

• Assess process and workflow needs to determine when an AI-based solution adds value versus when a deterministic automation (e.g., scripted pipeline, scheduled job, rule-based logic) is the more appropriate and reliable approach.
• Implement and maintain workflow automations using tools such as Power Automate, Databricks Workflows, or similar platforms to reduce manual effort in recurring data processes.
• Stay current on emerging AI and automation tooling and identify practical applications that align with team priorities.

• Operate within the team’s hybrid agile/traditional project management framework, including sprint-based delivery cycles, backlog management, and adherence to project timelines, dependencies, and milestone commitments.

• Bachelor’s degree in Supply Chain Management, Operations Management, Industrial Engineering, Data Analytics, or a related field.
• 3+ years of experience in a supply chain analytics or business intelligence role within a manufacturing or industrial environment.
• Demonstrated understanding of supply chain processes: S&OP/SIOP, MRP/ROP, demand/capacity planning, inventory management, or production scheduling.
• 2+ years of hands-on experience with Databricks or a comparable cloud data platform (Snowflake, BigQuery, Synapse).
• Proficiency in Python and SQL for data manipulation, pipeline development, and analytical scripting.
• Experience building dashboards and reports in Power BI or an equivalent tool (Tableau, Looker, etc).
• Familiarity with medallion architecture patterns and data lakehouse concepts.
• Working knowledge of ETL/ELT pipeline development and data quality management.
• Experience with workflow automation tools (Power Automate, Databricks Workflows, Apache Airflow, or similar).
• Strong proficiency in Microsoft Excel for ad hoc analysis, data validation, and stakeholder communication.
• Experience working in agile/sprint-based delivery environments as well as traditional project management frameworks.
• Excellent communication skills with the ability to translate technical concepts for non-technical audiences and work effectively with global, cross-functional teams.

• General familiarity with AI/ML concepts, tooling, and practical applications in a business context (e.g., Databricks MLflow, cloud AI services, context management, prompt engineering, or RAG architectures).
• APICS/ASCM certification (CPIM, CSCP, or CTSC) or actively pursuing.
• Exposure to SAP ERP systems (SAP ECC or S/4HANA) as a data source.
• Experience with version control (Git) and collaborative development workflows.
• Familiarity with data solution architecture patterns and documentation practices.
• Knowledge of cloud infrastructure (Azure, AWS, or GCP) in a data or analytics context.

Join the global Xylem team to be a part of innovative technology solutions transforming water usage, conservation, and re-use. Our 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. Partner with us in creating a world where water challenges are met with ingenuity and dedication; where we recognize the power of inclusion and belonging in driving innovation and allowing us to compete more effectively around the world.