Master Data Reference Architect

• Role : Master Data Reference Architect
• Location: Remote

Job Description:

We are seeking a senior architect to own master and reference data architecture for the Firm. This is a strategic, hands-on role that defines the canonical model for the Firm's core business entities - what each entity means, which system is authoritative for it, and how entities relate - and implements that model in the Firm’s MDM platform - Profisee, so that every function depending on those entities works from the same trusted data.

Required Qualifications:

• • More than 10 years in data architecture and data modeling on large-scale enterprise data platforms
• • Demonstrated ownership of an enterprise or cross-domain information model — defining core entities, attributes, relationships and authoritative sources, and driving organizational agreement on those definitions
• • Strong conceptual and logical modeling capability, including normalized and dimensional modeling, and the ability to translate complex domain hierarchies into clean, durable structures
• • Hands-on configuration experience with Profisee or a comparable multidomain MDM platform, including entity and attribute modeling, match and merge, survivorship and hierarchy management
• • Demonstrated design of reference data architecture as a discipline in its own right — code set governance, effective dating and versioning, alternate hierarchy rollups, external code set crosswalks and change control
• • Working knowledge of Microsoft Fabric and OneLake, sufficient to specify publication contracts and analytics-ready structures rather than to engineer the platform
• • Advanced SQL & Demonstrated ability to operate as a design authority across team boundaries — producing specifications engineering teams can build from, and reaching durable decisions with senior business stakeholders

Preferred Qualifications:

• • Experience in a law firm or professional services environment
• • Experience with Microsoft Purview or a comparable catalog and glossary platform, including glossary design and lineage curation
• • Experience designing conformed dimensions and hierarchies consumed by Power BI
• • Experience establishing data ownership in a partnership or federated organization