Policy Expert – Data Warehouse Architect

Are you ready to transform the insurance industry?

Policy Expert is a forward-thinking business that loves to get things done. Leveraging proprietary technology and smart data, we offer reliable products and a wow customer experience.

Having achieved rapid growth since being founded in 2011, we've won over 1.5 million customers in Home, Motor and Pet insurance and have been ranked the UK's No.1-rated home insurer by Review Centre since 2013.

Hear from our team about what it's like working at Policy Expert ?

About Group Data:

At Policy Expert, data is at the heart of everything we do, and our ambition is clear: our data and analytics will enrich every customer experience, optimize every business decision, and empower every colleague. The Exec and Board have committed significant investment to establish and mature our data capabilities, underpinned by a transformative Data Strategy built around three core pillars: Operating Model, Data & Analytics Platform, and Data Culture. We have five disciplines – Data Management, Engineering, Science, Analytics, and Visualisation – that collaborate with the rest of the business to drive incremental value through data, operational excellence, and business agility.

About the Data Engineering team:

The Data Engineering team is responsible for building and maintaining our cloud-native secure, reliable, cost-efficient, and scalable Data & Analytics Platform. The team covers the end-to-end lifecycle of data, from ingestion, egress and integration of data to cleaning, enriching and modelling it into a unified enterprise data warehouse model, to supporting analytics, data science, and AI use cases.

Your day to day:

You will join the Data Warehousing sub-team, tasked with creating and maintaining our enterprise data model, structured across four layers: Bronze (raw data), Silver (cleaned and enriched data), Gold (dimensional/star schema models), and Semantic (domain-specific models). Our collaborative approach involves working closely with the Enterprise Data Architect, Data Governance Manager, and the wider Data Analytics team.

Lead the design, implementation, and ongoing management of the unified enterprise data model within our BigQuery-based data warehouse, covering the Bronze, Silver, Gold, and Semantic layers.
Develop dimensional and semantic data models aligned with business domains to enable easy consumption of insights across Policy Expert's insurance products (Home, Motor, Pet). The data models need to satisfy users' needs, and their querying needs to be performant and cost-efficient.
Collaborate closely with the Enterprise Data Architect and Data Governance Manager to ensure the data model adheres to governance policies, privacy regulations, and best practices in data management.
Drive the adoption of robust data governance, data quality standards, and promote self-service analytics capabilities within the data warehouse.
Engage with business stakeholders to ensure data models accurately support their analytical and operational use cases.
Act as the subject matter expert on data warehousing and modelling techniques, mentoring and guiding team members and the wider Group Data team.

Who are you:

A seasoned Data Warehouse Architect with proven experience in designing, building, and maintaining performant, secure and cost-efficient enterprise-scale cloud data warehouses (ideally on Google Cloud).
Expert knowledge in dimensional modelling (Kimball methodology), star schema design, semantic modelling, and implementing data mesh principles.
Expert SQL knowledge, and proficiency with ELT and lakehouse architectures.
Experienced in managing data quality, governance, security, and compliance frameworks in regulated industries (GDPR, Consumer Duty, PECR).
Skilled in collaborating across technical and non-technical teams to understand business requirements and translating them into robust data models.
Proficient with transformation frameworks (e.g. DBT, Dataform, SQLMesh), tools and processes such as SQL, CI/CD automation (e.g. GitHub Actions), Infrastructure as Code (Terraform), and data observability practices.
Adept at balancing strategic oversight with hands-on implementation, committed to delivering scalable, performant, and reliable data solutions.
An effective communicator with strong leadership skills, capable of mentoring and developing a high-performing data engineering team.

Benefits:

This role will be based in our London office in a 50/50 Hybrid mode.

Generous Pension contribution scheme

Private medical & Dental cover

Learning budget of £1,000 a year + Study leave (with encouragement to use it)

Enhanced maternity & paternity

Travel season ticket loan

? Access to a wide selection of London O2 events and use of a Private Lounge

Employee Wellbeing Programme

What We Stand for and Next Steps "We pride ourselves on being an equal opportunity employer. We treat all applications equally and recruit based solely on an individual's skills, knowledge, and experience. The quality and growing diversity of our team is a testament to this commitment"

At Policy Expert, we are committed to fostering an inclusive and supportive environment for all candidates. If you require any reasonable adjustments during the interview process to accommodate your needs, please do not hesitate to let us know. We are dedicated to ensuring every candidate has an equal opportunity to succeed and will work with you to provide the necessary support.

We aim to be in touch within 14 working days of your application – you will be notified if successful or unsuccessful. Please be encouraged to apply even if you do not meet all the requirements.

Useful links:

Glassdoor | Trust Pilot | Best Companies

Policy Expert

Latest Leads

Data Warehouse Architect