Associate Principal Engineer (India Office)

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 strong 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