BigQuery Data Warehouse Engineer — Dimensional Modeling

Policy Expert; Greater London; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

A leading insurance technology company in the UK is seeking a Data Warehouse Engineer to design and maintain their enterprise data model. The role involves creating cloud data warehouses, ensuring high performance and cost efficiency, and working closely with analytics and engineering teams. The ideal candidate possesses strong SQL skills and has experience with dimensional modelling. This position offers a hybrid working model based in London, along with a comprehensive benefits package including pension matching and a learning budget.

Benefits

Pension contributions matched up to 7%

Learning budget of £1,000 a year

Enhanced maternity & paternity

Travel season ticket loan

Access to London O2 events

Qualifications

• 5+ years of experience in building and maintaining cloud-based data warehouses.
• Strong understanding of dimensional modelling and star schema design.
• Ability to collaborate across technical and non-technical teams.

Responsibilities

• Design and implement enterprise data models within a cloud warehouse.
• Work with cross-functional teams to ensure data models meet business needs.
• Manage data quality, governance, and compliance frameworks.

Skills

Cloud experience with AWS, GCP or Azure

Dimensional modelling (Kimball)

Expert SQL knowledge

Experience managing data quality and governance

Proficient with data transformation frameworks (dbt)

Collaborative skills to understand business requirements

Tools

BigQuery

GitHub Actions

Terraform

Job description

A leading insurance technology company in the UK is seeking a Data Warehouse Engineer to design and maintain their enterprise data model. The role involves creating cloud data warehouses, ensuring high performance and cost efficiency, and working closely with analytics and engineering teams. The ideal candidate possesses strong SQL skills and has experience with dimensional modelling. This position offers a hybrid working model based in London, along with a comprehensive benefits package including pension matching and a learning budget.