Base Career helps you apply smarter for this job.
Key skills for this role
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.
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.
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.
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 .
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
Carrollton, USA
Bengaluru, IND
Bengaluru, IND
Windsor, CAN
Greenfield, USA
Roanoke, USA
Hampton, USA
Holly Hill, USA
Carrollton, USA
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.
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.
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)
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.
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.
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.
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
Global provider of business-to-business distribution and supply chain solutions.
Visit company websiteJobs and hiring trendsFull-time
Senior · 10+ years experience
Hybrid
Apply faster on company sites with our extension.