Data Warehouse Architect, Policy Expert

• 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

• 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
• 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

• 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

Policy Expert is a trusted insurance provider, serving more than 1M home and car insurance customers across the UK since its launch in 2011. Policy Expert was the first insurer to be designed for aggregator sites, allowing it to capitalise on the growth of price comparison sites like Compare the Market and GoCompare.