Senior Enterprise Data Modeler - INTL - India
Insight Global, Pittsburgh, PA, United States
We are seeking an Enterprise Data Modeler to design, govern, and evolve enterprisewide data models, master data, and reference data across a complex transactional and analytical landscape. This role is responsible for defining how data is structured, integrated, and consumed across the enterprise, ensuring consistency, governance, and scalability for both operational systems and analytics.
The ideal candidate brings deep experience in enterprise data modeling, MDM, and data architecture, and partners closely with engineering, governance, and business teams to translate complex requirements into trusted, wellgoverned data assets.
Key Responsibilities Include: • Own and maintain enterprise data models (conceptual, logical, and physical), including canonical, transactional, and dimensional models, and enforce data standards, documentation, and change control • Architect and manage Master and Reference Data using Informatica MDM and R360, including golden records, matchmerge logic, survivorship rules, stewardship workflows, and lifecycle management • Define how transactional, master, and reference data is integrated and propagated across core enterprise platforms (ERP, CRM, OMS, pricing, finance) and downstream analytics • Translate enterprise and MDM models into Databricks Lakehouse analytical schemas, partnering with data engineering teams on ELT/ETL pipelines, validation, reconciliation, and lineage • Ensure alignment with data governance, quality, security, and compliance requirements (PII, GDPR, SOX), including auditability from source systems through analytics • Lead data modeling and MDM design sessions and serve as a subject matter expert, mentoring engineers and analysts on best practices
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience • 7+ Years Experience in Enterprise Data Modeling and Data Architecture • Architect experience in Master and Reference Data (Informatica MDM & R360) • Hands-on experience with ErWin Data Modeler in enterprise environments and modeling approaches (relational, normalized, dimensional, and canonical (nice to have)) • Technical data analysis expertise (Databricks and PowerBI) Hands-on experience integrating major enterprise data platforms (ERP, CRM, OMS, MDM, AR, etc.)
Nice to Have Skills & Experience - Additional Data Tools and Subject Area Experience (Delta Lake, Unity Catalog, FiveTran, Mulesoft, Oracle Fusion, Flintfox, Microsoft Dynamics, IBM order Management, High Radius, Informatica MDM, Supply Chain, , ESG, etc.) Experience aligning data governance, security, and compliance requirements (PII, GDPR, SOX)
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.
Key Responsibilities Include: • Own and maintain enterprise data models (conceptual, logical, and physical), including canonical, transactional, and dimensional models, and enforce data standards, documentation, and change control • Architect and manage Master and Reference Data using Informatica MDM and R360, including golden records, matchmerge logic, survivorship rules, stewardship workflows, and lifecycle management • Define how transactional, master, and reference data is integrated and propagated across core enterprise platforms (ERP, CRM, OMS, pricing, finance) and downstream analytics • Translate enterprise and MDM models into Databricks Lakehouse analytical schemas, partnering with data engineering teams on ELT/ETL pipelines, validation, reconciliation, and lineage • Ensure alignment with data governance, quality, security, and compliance requirements (PII, GDPR, SOX), including auditability from source systems through analytics • Lead data modeling and MDM design sessions and serve as a subject matter expert, mentoring engineers and analysts on best practices
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience • 7+ Years Experience in Enterprise Data Modeling and Data Architecture • Architect experience in Master and Reference Data (Informatica MDM & R360) • Hands-on experience with ErWin Data Modeler in enterprise environments and modeling approaches (relational, normalized, dimensional, and canonical (nice to have)) • Technical data analysis expertise (Databricks and PowerBI) Hands-on experience integrating major enterprise data platforms (ERP, CRM, OMS, MDM, AR, etc.)
Nice to Have Skills & Experience - Additional Data Tools and Subject Area Experience (Delta Lake, Unity Catalog, FiveTran, Mulesoft, Oracle Fusion, Flintfox, Microsoft Dynamics, IBM order Management, High Radius, Informatica MDM, Supply Chain, , ESG, etc.) Experience aligning data governance, security, and compliance requirements (PII, GDPR, SOX)
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.