Job Description
Role Summary
We are seeking an
Enterprise Data Modeler / Data Architect
to design, govern, and evolve enterprise-wide data models, master data, and reference data across a complex transactional and analytical landscape.

You will be responsible for defining
canonical, transactional and dimensional
enterprise data models
,
master and reference data structures
, and for ensuring consistent, governed data consumption across operational and analytical use cases.

Key Responsibilities
Enterprise Data Modeling
- Design and maintain conceptual, logical, and physical data models using erwin Data Modeler, including subject area models and cross-domain canonical models.
- Define and enforce enterprise data standards (naming, normalization, domains, data types).
- Maintain data dictionaries, model documentation, and change control processes.

Master & Reference Data Management
- Architect and implement Master Data Management (MDM) solutions using Informatica MDM, covering Customer, Product, Supplier, Pricing, and Party domains.
- Design golden record,



match–merge rules, survivorship logic, and source system trust frameworks.
- Define and manage reference data models (code sets, hierarchies, value lists) using Informatica R360.
- Establish stewardship workflows, data governance alignment, and lifecycle management for master and reference data.
- Ensure consistent propagation of mastered and reference data to downstream platforms including Databricks, ERP, CRM, and OMS systems.

Data Architecture & Databricks Lakehouse
- Define data architecture patterns for Databricks Lakehouse using Delta Lake, Unity Catalog, and medallion (Bronze/Silver/Gold) architecture.
- Translate enterprise transactionaland MDM models into optimized analytical schemas and data marts.
- Partner with data engineering teams to implement ELT/ETL pipelines (Spark SQL / PySpark) with data validation and reconciliation.

Transactional, Master and Reference Data systems integration
- Model and in

📌 Associate Principal Engineer (Bengaluru)
🏢 Wesco
📍 Bengaluru