Job Description
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. This role owns how data is structured, integrated, and consumed across the enterprise, ensuring consistency, governance, and scalability for both operational and analytical use cases.
The ideal candidate brings strong experience in enterprise data modeling, Master Data Management (MDM), and data architecture, and works closely with data engineering, governance, and business teams to translate complex requirements into trusted, well‑governed data assets.
Key Responsibilities Include:
• Own and maintain enterprise data models (conceptual, logical, and physical), including canonical, transactional, and dimensional models, while enforcing data standards, documentation, and change control
• Architect and manage Master and Reference Data using Informatica MDM and R360, including golden records, match‑merge logic, survivorship rules, stewardship workflows, and lifecycle management
• Define how transactional, master, and reference data is integrated and propagated across core enterprise systems (ERP, CRM, OMS, pricing, finance) and downstream analytics platforms
• Translate enterprise and MDM models into Databricks Lakehouse analytical schemas, partnering with data engineering teams on ELT/ETL pipelines, validation, reconciliation, and metadata lineage
• Ensure alignment with data governance, quality, security, and compliance requirements (PII, GDPR, SOX), supporting auditability from source systems through analytics
• Lead data modeling and MDM design workshops and serve as a subject matter expert, mentoring engineers and analysts on modeling and governance 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
• 10+ Years Experience in Enterprise Data Modeling and Data Architecture
• 2+ Years in a Management Level role, leading data modeling and data architecture initiatives
• 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.