Open role
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