Business Intelligence Specialist

YSI Inc.; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Xylem is seeking a data analytics professional to support supply chain insights across manufacturing sites. You will translate business concepts into analytics requirements, build and maintain Databricks data pipelines, and develop interactive dashboards in Power BI for stakeholders worldwide.

The role combines analytics development, data quality management, and automation within a hybrid agile/traditional project framework.

Qualifications

• Bachelor’s degree in a related field.
• 3+ years of experience in a supply chain analytics or business intelligence role within manufacturing or industrial environment.
• Demonstrated understanding of S&OP/SIOP, MRP/ROP, demand/capacity planning, inventory management, or production scheduling.
• 2+ years with Databricks or comparable cloud data platform.
• Proficiency in Python and SQL for data manipulation and analytics.
• Experience building dashboards/reports in Power BI or Tableau or Looker.
• Familiarity with medallion architecture and data lakehouse concepts.
• Experience with ETL/ELT pipeline development and data quality management.
• Experience with workflow automation tools.
• Strong Excel skills for ad hoc analysis.

Responsibilities

• Act as a trusted resource for supply chain stakeholders, supporting discovery sessions across manufacturing sites to understand processes and data availability.
• Translate business concepts into analytics requirements and data models under guidance.
• Validate data outputs against operational reality and identify data quality issues.
• Develop and maintain dashboards and scorecards in Power BI.
• Develop and support ETL/ELT pipelines in Databricks using Python/SQL.
• Configure schemas and data models in Databricks with bronze/silver/gold layers.
• Write performant SQL and Python for transformations and orchestration.
• Support data quality checks and monitoring across pipelines.
• Assess when AI-based solutions add value and implement workflow automations.

Skills

SIOP/S&OP knowledge

MRP/ROP

Python

SQL

Power BI

Databricks

Data modeling

ETL/ELT

Data quality management

Excel

Agile/Sprint delivery

Communication

Education

Bachelor’s degree in Supply Chain Management, Operations Management, Industrial Engineering, Data Analytics, or a related field

Tools

Databricks

Snowflake

BigQuery

Synapse

Power BI

Tableau

Looker

Job description

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.

RESPONSIBILITIES

Supply Chain Knowledge & Business Acumen

• 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.

Business Analysis & Applied Statistics

• 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.

Analytics Development & Data Pipeline

• 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.

Automation & AI Enablement

• 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 more appropriate and reliable.
• 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.

Project Delivery & Team Operations

• 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.

QUALIFICATIONS

• 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.

PREFERRED QUALIFICATIONS

• 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.

Want to know what kind of Impact you can make? Our goal is to optimize water access and quality, and promote responsible consumption, so that communities across the globe can thrive.

Through Xylem Watermark, our Corporate Citizenship Program, we provide and protect safe water resources for communities around the world by engaging all stakeholders and educating about water issues.

Learn more by clicking here – Working at Xylem (https://www.xylem.com/en-us/careers/working-at-xylem/)

Inclusion and Belonging at Xylem Inclusion and Belonging are fundamental to how we enable our customers to tackle global water challenges. Learn more about our commitment to Inclusion and Belonging. (https://www.xylem.com/en-us/careers/inclusion-and-belonging/)