Be at the heart of actionFly remote-controlled drones into enemy territory to gather vital information.

Apply Now

Data Warehouse Engineer

Policy Expert
City of London
3 weeks ago
Create job alert

Join to apply for the Data Warehouse Engineer role at Policy Expert.


Policy Expert – Data Warehouse Engineer

🚀 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 the Data Engineering team

The Data Engineering team builds and maintains 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 to cleaning, enriching and modelling it into a unified enterprise data warehouse model, supporting analytics, data science and AI use cases.


Your day to day

  • Contribute to the design, implementation and ongoing management of the unified enterprise data model within our BigQuery‑based data warehouse, covering the Bronze, Silver and Gold layers.
  • Work in cross‑functional squads, collaborating closely with the Data Warehouse Architect, Analytics Engineers and other Data Engineers.
  • Develop dimensional 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 provide performant, cost‑efficient queries.

Who are you?

  • A Data Warehouse engineer with proven experience in designing, building and maintaining performant, secure and cost‑efficient enterprise‑scale cloud data warehouses (strong preference for BigQuery and Google Cloud technologies).
  • Demonstrable knowledge of dimensional modelling (Kimball methodology) and star schema design.
  • Expert SQL knowledge, proficiency with ELT and lakehouse architectures.
  • Experience 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, translating business requirements into robust data models.
  • Proficient with data transformation frameworks (dbt), tools and processes such as SQL, CI/CD automation (GitHub Actions), Infrastructure as Code (Terraform) and data observability practices.

Skills and Experience
Must‑haves

  • Google Cloud Platform (GCP) hands‑on experience, especially BigQuery.
  • Dimensional modelling (Kimball) and star‑schema design, from source analysis through conformed dimensions and facts.
  • dbt for transformations (models, tests, exposures), with solid SQL and ELT best practices.
  • Proven experience building and operating cloud data warehouses at scale (reliability, performance, cost efficiency).
  • Working knowledge of data governance, quality, security and compliance in regulated environments (GDPR/Consumer Duty/PECR) and how this maps to schemas, policy tags and controls.
  • CI/CD for analytics (GitHub Actions) including code review, automated testing and deployment workflows.
  • Collaborative skills to translate business requirements into robust, performant data models and datasets.

Nice‑to‑haves

  • Wider GCP data stack: Dataplex (catalog / lineage / policy tags), Cloud Composer/Apache Airflow (orchestration), Analytics Hub (data sharing).
  • Infrastructure as Code (Terraform) for analytics and data‑platform components.
  • Observability for data pipelines (logging, alerting, lineage/metadata).
  • Experience with semantic layers and BI consumption patterns (e.g. metrics layers, aggregate tables, caching strategies).
  • Familiarity with advanced warehouse modelling concepts, such as Slowly Changing Dimensions (Type 2), snapshotting and surrogate keys.
  • Performance engineering in BigQuery (slot management, materialisations, incremental models).
  • Commercial awareness of cloud spend management and cost optimisation techniques.

Benefits

  • This role will be based in our London office in a 50/50 hybrid mode.
  • We match your pension contributions up to 7 %.
  • Private medical & dental cover.
  • Learning budget of £1 000 a year + study leave.
  • Enhanced maternity & paternity.
  • Travel season ticket loan.
  • Access to a wide selection of London O2 events and a private lounge.
  • Employee wellbeing programme.
  • Prayer room in office.

Equal Opportunity Statement

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.


#J-18808-Ljbffr

Related Jobs

View all jobs

Data Warehouse Engineer

Senior Data Warehouse Engineer

Data Warehouse Developer

Data Engineer (remote)

Data Engineer

Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Data Science Recruitment Trends 2025 (UK): What Job Seekers Need To Know About Today’s Hiring Process

Summary: UK data science hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise rigorous problem framing, high‑quality analytics & modelling, experiment/causality, production awareness (MLOps), governance/ethics, and measurable product or commercial impact. This guide explains what’s changed, what to expect in interviews & how to prepare—especially for product/data scientists, applied ML scientists, decision scientists, econometricians, growth/marketing analysts, and ML‑adjacent data scientists supporting LLM/AI products. Who this is for: Product/decision/data scientists, applied ML scientists, econometrics & causal inference specialists, experimentation leads, analytics engineers crossing into DS, ML generalists with strong statistics, and data scientists collaborating with platform/MLOps teams in the UK.

Why Data Science Careers in the UK Are Becoming More Multidisciplinary

Data science once meant advanced statistics, machine learning models and coding in Python or R. In the UK today, it has become one of the most in-demand professions across sectors — from healthcare to finance, retail to government. But as the field matures, employers now expect more than technical modelling skills. Modern data science is multidisciplinary. It requires not just coding and algorithms, but also legal knowledge, ethical reasoning, psychological insight, linguistic clarity and human-centred design. Data scientists are expected to interpret, communicate and apply data responsibly, with awareness of law, human behaviour and accessibility. In this article, we’ll explore why data science careers in the UK are becoming more multidisciplinary, how these five disciplines intersect with data science, and what job-seekers & employers need to know to succeed in this transformed field.

Data Science Team Structures Explained: Who Does What in a Modern Data Science Department

Data science is one of the most in-demand, dynamic, and multidisciplinary areas in the UK tech and business landscape. Organisations from finance, retail, health, government, and beyond are using data to drive decisions, automate processes, personalise services, predict trends, detect fraud, and more. To do that well, companies don’t just need good data scientists; they need teams with clearly defined roles, responsibilities, workflows, collaboration, and governance. If you're aiming for a role in data science or recruiting for one, understanding the structure of a data science department—and who does what—can make all the difference. This article breaks down the key roles, how they interact across the lifecycle of a data science project, what skills and qualifications are typical in the UK, expected salary ranges, challenges, trends, and how to build or grow an effective team.