Policy Expert – Data Warehouse Architect We’re on a mission to make: The most successful insurance disruptor people want to stay with for life Are you ready to transform the insurance industry with innovative technology? At Policy Expert, we are on a mission to revolutionize Home, Pet, and Motor insurance, making it clear, fair, and great value for customers. Since our inception in 2011, our breakthrough thinking and proprietary tech, have won us over 1.5 million customers and the title of the UK’s No.1-rated home insurance provider for 9 years. 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. Strong familiarity with insurance industry data and analytics, covering domains such as pricing, underwriting, fraud, claims, policy management etc. 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