Confirm and document each domain's system of record as part of the Minimum Viable Governance Pack.
Working Group and Steward Support
Support Domain Working Groups with data analysis, reporting and documentation through the six-step delivery model (define scope, assess, agree minimum governance, pilot, operationalise, expand).
Support the Data Quality Analyst with the technical detail behind quality thresholds and dashboards.
Tooling and Technical Delivery
Write and maintain SQL queries and scripts to extract, profile and validate data across source systems, primarily in SQL Server.
Contribute to catalog and metadata tooling selection and configuration as the lakehouse platform is built out.
Skills and experience
Data Governance and Analysis Experience
3+ years in a data governance, data analyst, business intelligence, or data quality/profiling role.
Experience building or maintaining a data catalog, business glossary or metadata repository (tool-agnostic — Microsoft Purview, Collibra, Alation or similar).
Experience working with business stakeholders to translate technical findings — profiling results, data quality issues — into plain-language recommendations.
Prior experience supporting a data governance or data quality programme is strongly preferred; professional or legal services experience is a plus but not required.
Microsoft Data Platform (Primary Stack)
Hands-on experience with Microsoft SQL Server — writing and optimising T-SQL, profiling data at scale, working across multiple source systems.
Working knowledge of the wider Microsoft data stack: Azure Data Factory / Synapse, Power BI, Microsoft Purview (or equivalent metadata/catalog tooling).
Strong SQL skills (T-SQL) and comfort working directly in SQL Server Management Studio or equivalent.
Data Profiling, Cataloguing and Documentation
Data profiling technique — able to independently assess a dataset's quality, structure and fitness for purpose.
Clear, structured documentation skills — glossaries, catalog entries and lineage records need to be usable by non-technical business stewards.
Comfortable working in a lean, evolving structure — this role flexes across profiling, cataloguing and working-group support as domains stand up and dissolve.
Preferred Qualifications
Snowflake experience (SQL, data modelling or administration) — the primary stack is Microsoft/SQL Server, but Snowflake familiarity is an advantage given the platform evaluation currently underway.
Exposure to a lakehouse or modern cloud data platform migration.
Familiarity with data classification and access-tiering concepts (public / internal / confidential / privileged) and how they interact with a data catalog.
DAMA-DMBOK awareness or working knowledge of data governance frameworks.
Experience in a law firm or other professional/partnership services environment, including sensitivity to client confidentiality and conflicts requirements.
Reports to: Chief Data Officer
Position Type: Centre Services
Development Framework: Specialist
Baker McKenzie empowers clients to compete in the global economy. We provide comprehensive and practical legal advice that cuts through complexity with clear, actionable guidance. Our people represent diverse cultures and jurisdictions, combining local know-how with international expertise to ensure your business thrives across borders.
Baker McKenzie is an Equal Opportunity Employer. We are committed to promoting diversity and inclusion for all. Our unique international culture is reflected in the drawing together of a worldwide family of individuals from diverse cultures and backgrounds in all of our offices. We encourage the best people - regardless of race, religion or belief if any, gender, gender identity, disability, sexual orientation or age - to fulfill their professional aspirations with us. We are committed to ensuring an inclusive and accessible experience for all candidates.
