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

About the TeamAt Wesco, we build, connect, power and protect the world. As a leading provider of business-to-business distribution, logistics services and supply chain solutions, we create a world that you can depend on. ​ Our Company’s greatest asset is our people. Wesco is committed to fostering a workplace where every individual is respected, valued, and empowered to succeed. We promote a culture that is grounded in teamwork and respect. With a workforce of over 20,000 people worldwide, we embrace the unique perspectives each person brings. Through comprehensive benefits and active community engagement, we create an environment where every team member has the opportunity to thrive.  ​ Learn more about Working at Wesco here and apply online today!​ Founded in 1922 and headquartered in Pittsburgh, Wesco is a publicly traded (NYSE: WCC) FORTUNE 500® company.​ Wesco International, Inc., including its subsidiaries and affiliates (“Wesco”) provides equal employment opportunities to all employees and applicants for employment. Employment decisions are made without regard to race, religion, color, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, or other characteristics protected by law. US applicants only, we are an Equal Opportunity Employer.​Los Angeles Unincorporated County Candidates Only: Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.