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 dimensionalenterprise 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 integrate data from

📌 Associate Principal Engineer (Bengaluru)
🏢 Wesco
📍 Bengaluru