Data Engineer – Master Data Management

Alcon MX; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Relocation assistance

Equal Opportunity Employer

Job summary

Alcon seeks a Data Engineer to own the design, build, and optimization of MDM data pipelines in an AWS data lake.

You will work closely with governance teams to ensure data quality, security, and cataloging across Customer Master and PIM domains, while contributing to agile analytics delivery.

Qualifications

• Bachelor’s level degree in CS/Data Science or related quantitative field or equivalent experience.
• 6–10 years of experience in Big Data / data lake solutions on AWS.
• 3+ years coding with Spark using Python/Scala/Java.
• Hands-on experience building and optimizing data pipelines for ingestion, transformation, and quality checks.
• Strong SQL skills and experience with RDBMS systems.
• Experience with agile teams using Jira/Confluence.
• Familiarity with MDM concepts (customer, product) and PIM data domains.

Responsibilities

• Design, build, and maintain scalable data pipelines for MDM data (Customer Master and PIM).
• Leverage AWS data lake services to implement end-to-end MDM solutions.
• Deliver analytics-ready data with security, governance, and data quality metrics.
• Collaborate with governance teams on data quality, survivorship, and lifecycle management.
• Automate, migrate, and optimize MDM data solutions and pipelines.
• Participate in backlog grooming, sprint planning, and agile DevOps practices.
• Work with MDM platforms like Reltio and PIM tools such as Stibo.

Skills

Python

PySpark

Spark SQL

SQL

AWS

Data Lake

Data Modeling

Agile

Jira

Confluence

MDM concepts

Customer Master data

PIM data

Education

B.Tech/B.E./M.Tech/MCA or related degree

Tools

Reltio

Stibo

EMR/Glue/S3

Job description

Summary of Position:

This role is responsible for the Data Engineering of Master Data Management (MDM) data within Alcon's AWS data lake environment. Working closely with business and data governance stakeholders, the Data Engineer will design, build, and optimize scalable data pipelines that ingest, cleanse, transform, and provision trusted master data - with a primary focus on Customer Master data and Product Information Management (PIM) data domains - in alignment with Alcon's Data and Analytics strategy, standards, and governance practices. Knowledge of Customer Master data and Product Information Management (PIM) data domains is highly preferred.

Key Responsibilities:

• Design, build, and maintain scalable data pipelines to ingest, cleanse, transform, and curate Master Data Management (MDM) data - especially Customer Master and Product Information Management (PIM) data - within the AWS data lake.
• Adopt AWS data lake and related data services to implement end-to-end MDM data solutions across ingestion, integration, curation, and consumption.
• Deliver business solutions on Alcon's analytics platform through end-to-end implementation that includes data security, governance, cataloging, preparation, automated testing, and data quality metrics.
• Build data pipelines using Python, PySpark, and Spark SQL, integrating master data from a variety of heterogeneous source systems.
• Collaborate with data governance teams and information stewards to support data quality, stewardship, matching/survivorship, and lifecycle management for Customer Master and PIM data.
• Automate, optimize, migrate, and enhance existing MDM data solutions and pipelines.
• Perform data modeling, data analysis, and provide insights that support trusted customer and product master data for downstream analytics use cases.
• Participate in backlog grooming, sprint planning, and effort estimation as part of an agile DevOps team.
• Analyze and manage master data within Master Data Management (MDM) platforms such as Reltio, including customer, product, supplier, and reference data domains.
• Configure, maintain, and analyze Product Information Management (PIM) solutions such as Stibo to ensure high-quality product content, digital assets, classifications, attributes, and product lifecycle data.
• Utilize data cataloging and metadata management tools to document, classify, govern, and improve discoverability of enterprise data assets, business glossaries, lineage, and data quality metrics.

Key Requirements/Minimum Qualifications:

• Education: B.Tech / B.E / M.Tech / MCA or bachelor's/master's degree in Computer Science, Data Science, or a related quantitative field (or equivalent applicable experience).
• 6 to 10 years of experience in Big Data / data lake solutions in an AWS cloud environment.
• 3+ years of experience writing code in the Spark engine using Python, Scala, or Java.
• Hands-on experience building and optimizing data pipelines for data ingestion, preparation, curation, provisioning, automated testing, and quality checks.
• Good working knowledge of AWS services such as Glue, EMR, S3, SNS, SQS, Athena, Redshift, Lambda, and Step Functions.
• Good experience in RDBMS - MS SQL, Oracle, Postgres, etc.; strong working knowledge of SQL is a must.
• Experience performing data modeling, data analysis, and deriving insights using various tools.
• Experience working as part of agile teams using collaboration tools such as Jira and Confluence.
• Ability to work with the business to capture, groom, prioritize, plan, and demo User Stories.
• Familiarity with visualization and reporting tools such as Tableau or AWS Quick.
• Highly Preferred Knowledge of and hands-on experience with Master Data Management (MDM) concepts, tooling, and processes.
• Working knowledge of Customer Master data domains (customer records, hierarchies, matching, de-duplication, and survivorship).
• Working knowledge of Product Information Management (PIM) data domains (product attributes, catalogs, taxonomies, and enrichment).
• Understanding of data governance, data quality, and stewardship practices as applied to master data.

Interpersonal Skills & Characteristics

• Strong collaboration skills for effective communication across multiple teams and stakeholders, both internal and external.
• Data-savvy individual with hands-on experience preparing, analyzing, and deriving insights from data.
• Confident, energetic self-starter with strong problem-solving ability and high learning agility.
• Demonstrated commitment to high standards of ethics, regulatory compliance, customer service, and business integrity.

Work hours: 1 PM to 10 PM IST

Relocation assistance: Yes

Alcon is an Equal Opportunity Employer and takes pride in maintaining a diverse environment. We do not discriminate in recruitment, hiring, training, promotion or other employment practices for reasons of race, color, religion, gender, national origin, age, sexual orientation, gender identity, marital status, disability, or any other reason.

At Alcon, we are committed to helping people see better. We believe patients should have access to quality eye care regardless of their economic circumstances; however, barriers to good eye health exist for patients in both developed and emerging markets. Alcon develops and manufactures innovative devices to serve the full life cycle of eye care needs. Its surgical group is one of the largest makers of equipment used for cataract removal and laser vision correction. Its consumer products include the well-known Opti-Free line of contact lens solutions and related products. Alcon, which was founded in 1945, sells its products in 180 countries worldwide.