Staff Data Engineer

Tempcover; Greater London; Hybrid; GBP 65,000 - 85,000; Full time

Benefits offered by this job

10% discretionary yearly bonus

Hybrid working with work from anywhere options

Employer matching pension contributions up to 7.5%

£300 Work from Home budget

Excellent parental leave policies

25 days holiday, increasing to 30

Private medical cover

Learning and training budget

Electric vehicle and cycle to work schemes

Job summary

A progressive insurance company in Greater London is seeking a Staff Data Engineer to design and maintain data pipelines. The ideal candidate will possess advanced SQL skills, experience with ETL tools, and a strong knowledge of cloud data infrastructure. Key responsibilities include building scalable data infrastructure and improving data quality. The role offers a hybrid working model and numerous benefits including a bonus, pension contributions, and generous leave policies.

Qualifications

• Experience in writing complex SQL queries and query optimization.
• Knowledge of ETL/ELT processes and dimensional modelling.
• Ability to mentor junior data engineers.

Responsibilities

• Design and maintain data pipelines and ETL processes.
• Create accurate data models for analytics.
• Support high availability of data for the business.
• Collaborate with business analysts to understand data requirements.

Skills

Advanced proficiency in SQL databases

Experience with ETL tools

Solid understanding of data warehousing techniques

In-depth knowledge of cloud-based data infrastructure

Excellent problem-solving skills

Proficiency with Git/DevOps

Tools

Google Cloud Dataflow

DBT

Azure Data Factory

FiveTran

Databricks

Job description

Staff Data Engineer

Hybrid: 2 days per week in London, 1 day per month in Fleet

Department: Data & Analytics

Location: London

Tempcover is at the forefront of the fast-growing world of short term insurance. Our mission is to make car insurance flexible, quick, and easy for drivers. We’ve sold millions of policies that have helped drivers get where they need to go, but we’re not finished there. We’re growing our team to help us continue in that mission. If you are extraordinary at what you do and want to be a part of a rapidly growing business at the cutting edge of the InsureTech industry, we would love to hear from you.

What You'll Be Doing

• Design, develop, and maintain robust data pipelines and ETL processes
• Create and manage accurate and performant data models to support Tempcover’s analytical capability
• Propose and implement internal improvement initiatives to the data platform
• Lead a proactive approach to performance monitoring/tuning
• Leverage cloud-based platforms to build a scalable data infrastructure
• Provide continued support to ensure high availability of data to the wider business
• Work closely with analysts across MI, Marketing, Product, Underwriting and Pricing to understand data requirements and translate them into effective solutions
• Work with rigor to ensure data quality/accuracy
• Mentor and guide junior data engineers, providing technical expertise and project oversight

What We're Looking For

• Advanced proficiency in SQL databases, including writing complex queries, indexing and query optimisation
• Experience of ETL tools such as Google Cloud Dataflow, DBT, Azure Data Factory, FiveTran and Databricks
• Solid understanding of data warehousing techniques; ETL/ELT processes and dimensional modelling
• In‑depth knowledge of cloud‑based data infrastructure (GCP, Azure, AWS)
• Excellent problem‑solving skills and the ability to work independently and collaboratively in a fast‑paced environment
• Proficiency with Git/DevOps for version control and collaboration

Beneficial

• API integration
• Knowledge of Python
• Ability to work within a SCRUM agile development environment
• Understanding of visualisation and dashboard products (Power BI, Tableau, Qlik)

Our Commitment To You

We are dedicated to developing valuable, inclusive, and user‑friendly products and services that deliver positive outcomes for all of our customers. To achieve this it’s essential that our teams reflect the diverse range of people in our community. We believe in being the change we wish to see in the world, by embracing our differences and holding ourselves accountable to being open and inclusive teammates and wider community members.

What We Offer

• 10% discretionary yearly bonus and yearly pay reviews
• A hybrid working approach with 2 in‑office days per week and up to 22 working days per year of ”work from anywhere”
• Employer matching pension contributions up to 7.5%
• A one‑off £300 “Work from Home” budget
• Excellent maternity, paternity, shared parental and adoption leave policy
• 25 days holiday (increasing to 30 days) + 2 days “My Time” per year
• Private medical cover, critical illness cover and employee assistance programme
• A learning and training budget
• Electric vehicle and cycle to work schemes
• Regular events – from team socials to company‑wide events with external speakers
• Use of Metaview during interview processes for note‑taking purposes; candidates can opt out at any time

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

Information Technology

Industries

Insurance

Referrals increase your chances of interviewing at Tempcover by 2x.