Data Architect

We are seeking an experienced and pragmatic Data Architect to shape and evolve the firm’s data ecosystem across system integration, operational data flows, and our enterprise data warehouse. This is a pivotal role within the data and architecture team, whose mission is to transform how the firm manages, integrates, and leverages data.

You will be a hands-on architect, able to design integration patterns, define conceptual and logical data models, and guide how data moves from source systems into trusted analytical layers. You will work closely with Boomi developers, the data engineer, Power BI developers, and external system integrators to ensure solutions are robust, scalable, and aligned with business processes.

As we implement Boomi Master Data Hub, you will play a key role in shaping our master data domains, data quality rules, and stewardship processes, ensuring master data becomes a trusted asset across the firm. You will also serve as a core contributor to the Data Governance Committee, helping to define data standards, business definitions, ownership models, and end-to-end lineage to support firm-wide data quality and compliance objectives.

The ideal candidate combines strong architectural thinking with the ability to inspect real data, map processes, and translate business needs into coherent data flows and models.

Key Responsibilities

• Define and maintain conceptual, logical, and high-level physical data models across operational systems, MDM domains, and the data warehouse.
• Lead the architectural design for our Boomi Master Data Hub implementation.
• Design integration patterns and data flows between key systems (Finance, HR, CRM, PMS, DMS, etc.), ensuring alignment with business processes.
• Own the firm’s data architecture blueprint, ensuring consistency across ingestion, transformation, modelling, and consumption layers.
• Evaluate and define when to use Boomi Integration, Boomi MDM, Azure Data Factory/Fabric pipelines, direct APIs, OData feeds, or event-driven approaches.
• Guide the extension of the data warehouse by identifying new subject areas, conformed dimensions, SCD strategies, and data structures.
• Provide architectural oversight for modelling within Power BI semantic models (star schemas, SCD patterns).
• Engage with business stakeholders to understand processes, data requirements, and information flows, translating them into architectural artefacts.
• Partner with Boomi developers on integration and MDM design while maintaining an architecture-led approach.
• Work with system integrators delivering Boomi MDM, CRM or PMS components, ensuring alignment with firm architectural standards.
• Support the data engineer and SIs in implementing warehouse pipelines and semantic layers consistent with architectural designs.
• Ensure alignment between operational data, MDM structures, and analytical requirements Master Data Management.
• Establish and maintain master data ownership and stewardship models for Boomi MDM.
• Define and oversee data quality rules, validation logic, and remediation processes.
• Govern the lifecycle of master data entities such as clients, matters, employees, HR records, financial dimensions, etc.
• Ensure mastered data is delivered consistently to operational and analytical systems.

Data Governance Committee Participation

• Act as a pivotal member of the Data Governance Committee, providing architectural leadership across data standards business term definitions and data quality management.
• Translate committee outputs into actionable architectural and technical artefacts.
• Ensure governance decisions are embedded into the design of integrations, pipelines, and data models.
• Promote a culture of data stewardship and accountable data ownership across the firm.

Documentation & Governance

• Maintain architectural documentation including integration diagrams, models, lineage maps, interface definitions, and MDM artefacts.
• Contribute to and enforce data governance, modelling, and naming standards.
• Ensure solutions align with GDPR, InfoSec requirements, and broader regulatory obligations.
• Support data security by defining classification rules, access patterns, and schema-level controls.

You will have a professional manner, excellent communication and interpersonal skills, and have previous experience working within an office. You’ll have a flexible nature and will enjoy working within a fast-paced team, and will be highly organised. You’ll also possess strong numeracy and attention to detail skills, which will be key within this role. We are looking for someone who is passionate about being a team player, who is keen to support others.

Our ideal candidate will be able to demonstrate:

• Ideally five+ years’ experience in data architecture, integration architecture, or senior data engineering roles.
• A strong understanding of data warehousing, dimensional modelling, SCD strategies, semantic layer design.
• Experience with iPaaS platforms, preferably Boomi.
• Experience or strong familiarity with enterprise MDM design and implementation.
• Exposure to Azure Data Factory, Azure SQL, Fabric/Synapse or similar cloud analytics stacks.
• Familiarity with professional services data domains (Finance, HR, CRM, PMS, etc.).
• Experience working with SIs and multi-disciplinary internal teams.
• Understanding of GDPR, metadata management practices, and governance frameworks.
• Agile delivery experience; familiarity with Azure DevOps.
• Strong systems thinker with the ability to simplify complexity.
• Pragmatic, delivery-focused, and capable of validating real data flows to support decision-making.
• Engaging communicator able to influence stakeholders and lead governance conversations.
• Detail-oriented, structured, and self-driven.
• Collaborative and capable of uplifting capability in data engineering, integration, and BI teams.

At Lewis Silkin our ethos is simple. We strive to do the best for our clients, our people and the communities in which we operate. We recognise that an inclusive workplace allows for all kinds of ideas and thoughts, a variety of points of view that can trigger discussions or deliver innovative results, and a wide range of versatile skills and expertise. We are proud of the diversity within Lewis Silkin and of our culture that allows people to be themselves at work, ensuring we provide the best possible service to our clients. We are committed to supporting candidates throughout the recruitment process by supporting anyone who requires adjustments, in order to ensure they have the opportunity to perform at their best. All applicants will be considered equally and fairly. If you’d like to request any adjustments throughout the recruitment process, or would like to discuss flexible working patterns, please email the recruitment team in confidence.