> Markdown version of [/jobs/ext/4712868-lead-data-architect](https://www.wearedevelopers.com/jobs/ext/4712868-lead-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Data Architect - **Company:** Hippo - **Location:** Leeds, United Kingdom - **Experience:** Expert - **Salary:** £96,000 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Agile Methodology, Amazon Web Services, Microsoft Azure, Data Architecture, Data Dictionary, Data Governance, Extract Transform Load (ETL), Data Migration, Data Systems, Data Warehousing, Entity Relationship Models, Online Analytical Processing, Online Transaction Processing, Role-Based Access Control, Power BI, Cloud Services, Reverse Engineering, SQL Server Reporting Services, SQL Server Integration Services, Tableau (Software), Google Cloud, Postman, Snowflake, Data Lakes, Data Analytics, Tools for Reporting, SQL Server Management Studio (SSMS), Data Pipelines, Databricks - **Published:** November 14, 2026 - **Apply:** https://www.apply4u.co.uk/jobs/lead-data-architect/56438605 ## About the Role Proven experience in defining data architectures to satisfy multiple stakeholders with varying data proficiency Thorough understanding of data lake and data warehousing principles and full project involvement in one or more major technology platforms, e.g. Snowflake, Databricks, etc. Proven experience with one or more Cloud Services provider, e.g. AWS, Azure or Google Cloud Platform Good understanding of role-based access control, its importance in data privacy and methods of implementation Excellent data modelling skills in designing data warehouses and datamarts Experience of migrating data from legacy on-prem systems to cloud architectures Knowledge of OLTP and OLAP principles and evidence of building such solutions Evidence of building and managing the evolution of entity relationship models, data dictionaries and ELT/ETL models Ability to visualise outputs using leading reporting tools such as Power BI (with custom DAX) and/or Tableau High proficiency in SQL. Knowledge of SQL Server, SSMS, SSIS and SSRS a bonus Ability to evaluate APIs using tools such as Postman Consultancy experience is highly desirable Experience designing and implementing data pipelines is highly desirable ## Description Hippo is recruiting for a Lead Data Architect to join our Hippo Herd. Our Lead Data Architect will work in multi-disciplinary teams that build, support & maintain User-Centred data solutions that offer real value and work for everyone. As a Lead Data Architect, you will be responsible for contributing to and implementing data governance standards that ensure that our clients' data is high quality and fit for purpose. You will design and implement solutions on leading edge data cloud platforms that adhere to high standards of security, privacy and accessibility that unlock business insights and opportunities for data-driven business decisions. Please note, we are looking for candidates who are looking for growth at this level (Lead), therefore the advertised salary band is the lower end of our full banding for this level of position, allowing for progression in the role. Your Role In a Nutshell Define a data architecture that satisfies the data requirements of all stakeholders in an organisation and adheres to the enterprise wide data and technical strategy Build and maintain appropriate Enterprise Architecture artefacts including Entity Relationship Models, Data Dictionary, ETL/ELT definitions and Data Pipeline/Lineage Models Be accountable to the client for the rationale of the architecture and detailed solution and be able to evidence that a thorough change approval process has been followed Define the methods and standards of governance to ensure ongoing integrity of the architecture design artefacts Define standards for data modelling to ensure consistency within the solution and across the enterprise. Be a vocal and assertive advocate of data warehousing modelling techniques such as Kimball Be versatile in working within a delivery team to: Analyse candidate data sources for content, timeliness and integrity Evaluate APIs by analysing documentation and sample responses Reverse-engineer data models from a live system Create Agile stories for the implementation of the solution and support the engineering team throughout development Support third party suppliers in developing specifications that ensure compatibility between client and supplier systems Support integration and reconciliation testing Visualise insights using industry standard reporting tools