Master Data Reference Architect

Role Summary:

We are seeking a senior Master Data Reference Architect to define and govern enterprise-wide master data and reference data architecture. The role will own canonical data models, entity relationships, data governance, matching and merging strategies, and reference data standards using Profisee MDM, Microsoft Fabric, and OneLake.

Key Responsibilities:

• Define and maintain enterprise canonical data models for clients, organizations, employees, offices, cost centers, billing, and other core business entities.
• Design master data structures, attributes, identifiers, hierarchies, relationships, and authoritative sources across business domains.
• Configure and govern MDM models in Profisee, including matching, merging, survivorship, golden records, and data quality rules.
• Design cross-domain relationships, referential integrity, and master data lifecycle management.
• Establish reference data architecture for controlled vocabularies, classifications, code sets, currencies, locations, and organizational hierarchies.
• Define data mappings, crosswalks, effective dating, versioning, and change control for reference data.
• Determine master data integration and publishing patterns for source systems, Microsoft Fabric, OneLake, and reporting platforms.
• Collaborate with business stakeholders, data engineers, DBAs, and analytics teams to translate business requirements into technical data models and specifications.
• Define data security, access controls, stewardship workflows, and governance standards for sensitive data.
• Provide architectural leadership and resolve data modeling and governance decisions across teams.

Required Skills:

• 10+ years of experience in enterprise data architecture and data modeling.
• Strong experience owning enterprise or cross-domain information models.
• Hands-on experience with Profisee MDM or a comparable multidomain MDM platform.
• Expertise in master data management, golden records, entity resolution, matching, merging, survivorship, and hierarchy management.
• Strong knowledge of reference data architecture, code set governance, crosswalks, effective dating, and versioning.
• Advanced SQL and strong conceptual, logical, and physical data modeling skills.
• Working knowledge of Microsoft Fabric and OneLake.
• Excellent stakeholder management, architectural documentation, and technical leadership skills.

Preferred Experience:

• Experience with financial services, client/reference data, organizational hierarchies, or enterprise financial data.
• Experience integrating external data providers such as Bloomberg, S&P, and FactSet.
• Experience designing data publication contracts and analytics-ready data structures.