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 integrate data from:
- Oracle Fusion (Financials,



Procurement, AR)
- Flintfox (pricing, rebates, claims, agreements)
- Microsoft Dynamics CRM (customers, sales, activities)
- IBM Order Management System (OMS) (orders, fulfillment, shipment lifecycle)
- HighRadius (cash application, credit, collections)
- Informatica MDM (Suppler, Customer, Product, Reference)

- Create source-to-target mappings, capture transformation logic, and manage schema evolution and metadata lineage.

Data Governance, Security & Quality

- Align enterprise models with data governance frameworks, glossaries, and ownership models.
- Define and implement data quality rules (completeness, validity, conformity, uniqueness) across master, reference, and transactional data.
- Enforce security, privacy, and compliance (PII, GDPR, SOX) using Unity Catalog, role-based access, and classification standards.
- Support auditability via traceable lineage from source → MDM → analytics.

Stakeholder & Team Leadership

- Lead data modeling and MDM design workshops with business and technical stakeholders.
- Act as a subject matter expert across data modeling, MDM, and Databricks architecture.
- Mentor data engineers and analysts on modeling standards and governance best practices.

Required Qualifications

- 10+ years experience in enterprise data modeling and data architecture roles.
- Strong hands-on experience with erwin Data Modeler in large-scale environments is preferred.
- Experience with Databricks (Delta Lake, Spark, Unity Catalog).
- Advanced SQL and solid understanding of normalized, dimensional, and canonical modeling approaches.
- Experience integrating major enterprise applications (ERP, CRM, OMS, MDM, AR systems).
- Strong understanding of data governance, data quality, metadata, and lineage.
- Excellent communication skills across business and technical audiences.

Core Technology Stack

- Modeling: erwin Data Modeler
- Analytics Platform: Databricks (Delta Lake, Unity Catalog), Microsoft PowerBI
- Languages: SQL, Spark SQL, Python / PySpark
- Governance/Data Quality: Unity Catalog/Informatica DG/DQ

#LM-P1

📌 Associate Principal Engineer (India Office) (Bengaluru)
🏢 Wesco
📍 Bengaluru