Data Warehouse Architect, Policy Expert
More information about location
2+ days a week in office
Digital home & car insurance provider
Be an early applicant
Digital home & car insurance provider
201-500 employees
Be an early applicant
More information about location
2+ days a week in office
201-500 employees
Company mission
To be the most successful insurance provider that people want to stay with for life. This will be achieved by creating proprietary technology that allows us to offer honest, transparent and easy to understand products.
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 1 million 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. Having been built on a disruptive and ground-breaking platform, this established company is well positioned to continue building a customer base within the UK whilst keeping up with consumer trends.
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 benefits
- 🤒 Private medical cover with Aviva
- 🚅 Travel season ticket loan
- 🎉 Access to selected London O2 events and use of a Private Lounge
- 🏖️ 25 days holiday (excl. bank holidays)
- 🏠 50/50 hybrid working - we trust you to do your best work whether it's in the office or at home
- 💻 One off work from home equipment fund
- 💅🏻 Each year you are with us you can get an extra wellness day!
- 🥳 Social events through the year - monthly themed in office events celebrating festive holidays!
- 🦷 Private dental cover with Bupa
Company HQ
City of London, London, UK
Articles
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.
People progressing
Paul started with us as a Business Analyst back in 2019 and has been fundamental in our growth and now Policy Experts Head of Delivery.
Ezgi joined us 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.
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 13 more jobs at Policy Expert