Data Warehouse Architect, Policy Expert
More information about location
2+ days a week in office
Digital home & car insurance provider
Job no longer available
Digital home & car insurance provider
201-500 employees
Job no longer available
More information about location
2+ days a week in office
201-500 employees
Company mission
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.
Role
Who you are
- 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
What the job involves
- 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
Application process
- 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
Salary benchmarks
Our take
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.
It is a part of QMetric Group, which set out to redesign what an insurer should be, even before 'InsurTech' was a word. It has streamlined how people buy insurance by building its own tech and owning the process end to end. With a strong belief that competition and transparency are key to the future of any market, QMetric launched Policy Expert to meet the changing consumer trends over the past decade.
Since its founding, it has recorded significant year-on-year growth to become one of the UK’s ten biggest home insurance providers while diversifying its proposition by entering the motor market in 2019. Now, with Cinven acquiring a majority shareholder, Policy Expert is in a great position to further accelerate its growth and expand even further in the years to come.
Freddie
Company Specialist at Welcome to the Jungle
Insights
Company
Employee endorsements
Intelligent people
"My colleagues have high attention to detail and explain their decisions and viewpoints very well. It's inspiring to work with teammates with high..."
Company values
- We act with Expertise
- We work as a Team
- We care about People
- We stick to our Principles
- We get things done
Company HQ
City of London, London, UK
Leadership
Adam Powell
(Co-Founder & COO)COO at Policy Expert since 2010, prior to which he was the Head of New Markets at Simply Business.
Steve Hardy
(CEO)Previously a Non Executive Director at Roojai, QMetric Group, C-Quence.
People progressing
Paul started as a Business Analyst back in 2019 and has been fundamental in our growth and now Policy Experts Head of Delivery.
Ezgi joined back in 2019 in the Business Analysis team. She has excelled in her work and really contributed to building out the function. In 2023 she was promoted to Head of Business Analysis and in 2025 further promoted to Senior Product Manager.
Diversity, Equity & Inclusion at Policy Expert
- We’re committed to creating a culture of inclusivity where every employee feels welcome, and different perspectives are valued and encouraged. We respect and value people's differences. In fact, we welcome it, as this brings a wider range of ideas, opinions and experience.
Share this job
View 12 more jobs at Policy Expert