Senior GCP Data Engineer
Role details
Job location
Tech stack
Job description
This is a unique opportunity to join HomeProtect at the start of building a brand new GCP Data Analytics Platform. We are looking for an enthusiastic, experienced senior engineer who can help architect and deliver a best-in-class platform from the ground up, with a strong focus on production-grade GCP engineering, dbt, and dimensional modelling.
You will report to the Head of Data Engineering and work closely with the data engineering and platform teams to deliver reliable ingestion patterns, maintainable dbt transformations, and well-designed dimensional marts that enable business insight., Delivery across the data lifecycle
-
Deliver end-to-end data products on GCP, from onboarding new sources through to curated datasets, marts, and business-facing outputs.
-
Build and operate ingestion pipelines using appropriate patterns (CDC, APIs, SFTP, streaming), ensuring reliability, scalability, and operational simplicity.
-
Build and improve transformation workflows in the warehouse using dbt, with a strong focus on correctness, performance, and cost control.
-
Design and implement dimensional models that are fit for analytics at scale, including facts, dimensions, explicit grain definition, and star schema design.
-
Translate business requirements into clear dimensional designs and dbt models, validating outputs with stakeholders and iterating quickly.
-
Work in an Agile way: contribute to planning, estimation, delivery cadence, and continuous improvement.
-
Maintain a strong focus on delivering measurable value to stakeholders, prioritising work that improves decision making and accelerates insights aligned with business needs.
Operational excellence and quality
-
Design pipelines and jobs to be production-grade: idempotent, observable, resilient to failure, and easy to support.
-
Champion automated testing and release practices so changes can be safely promoted through environments with minimal manual effort.
-
Contribute to operational tooling (logging, alerting, runbooks, dashboards) so the team can rapidly detect issues and restore service., We're proud to be an equal opportunity employer and actively encourage applications from all backgrounds. We believe in celebrating difference - everything that makes both our customers and our people unique. We consider visa sponsorship on a case by case basis for the right candidate, so please don't let that stop you from applying.
We encourage you to let us know if you need any extra help with your application or have any requirements at any stage of the recruitment journey, we want the process to work for you.
Your data will be maintained in line with our recruitment data privacy policy.
Regulatory Responsibilities
As an FCA regulated insurer, doing the right thing isn't a compliance requirement - it's simply how we work. All colleagues are expected to uphold the FCA Individual Conduct Rules (1-6) and act with integrity, due skill and care, openness with regulators and a genuine commitment to delivering good outcomes for our customers.
You'll work within approved processes and authority limits, keep accurate and auditable records, protect data under UK GDPR and our information security policies, escalate risks and exceptions promptly, report incidents, breaches and any financial crime or sanctions concerns (including via whistleblowing), support vulnerable customers with reasonable adjustments, and complete all mandatory training to maintain competence.
If the role falls within SM&CR, a supplementary document outlining the key regulatory responsibilities will be provided.
Requirements
Do you have experience in Terraform?, * 5+ years' experience as a Data Engineer, including building and operating production-grade data pipelines and data products.
-
3+ years building on GCP in a production environment.
-
Deep, hands-on dbt expertise in production, including designing layered projects (staging, intermediate, marts), implementing robust testing and documentation, and operating patterns such as incremental models, handling schema changes safely and managing late-arriving data and backfills without breaking downstream marts
-
Strong dimensional modelling expertise, including declaring and enforcing grain as a design contract, delivering fact and dimension tables with conformed dimensions, and handling real-world complexity such as slowly changing dimensions (Type 1 and Type 2), late-arriving facts, and maintaining consistent business definitions across marts over time.
-
Strong ability to design and implement reliable data pipelines and make good engineering trade-offs.
-
Strong hands-on experience with; BigQuery, Cloud Storage (GCS), Cloud Run/Functions, Cloud Composer (Airflow) or equivalent orchestration tooling
-
Experience designing and operating pipelines across multiple ingestion patterns, including CDC, APIs, SFTP, streaming etc.
-
Strong understanding of medallion architecture (Bronze, Silver, Gold) and how to implement it in a modern analytics platform.
-
Strong experience working within Agile methodologies (Scrum) and contributing positively to team rituals and delivery cadence.
-
Strong communication: you can explain technical decisions clearly to engineers and non-engineers, and you document just enough to scale delivery.
Nice to have
-
GCP certification (Professional Data Engineer or similar).
-
Hands-on experience with Terraform, Kafka, Dataflow, Pub/Sub.
-
Experience in regulated domains (insurance, finance, etc).
Benefits & conditions
Pulled from the full job description
- Referral programme
- Annual leave
- Employee discount
- Life insurance
- Employee assistance programme
- Company pension
- Private medical insurance, We want you to feel rewarded, supported and set up to thrive throughout your career with us.
Learning and Growth: We invest in your development through structured learning, mentoring, buddying, on-the-job experience and cross-functional projects. We support role-relevant professional qualifications where they'll make the biggest difference, and our Lunch and Learn sessions to help you stay connected to what's going on right across the business.
Health and Wellbeing: Your wellbeing matters here. We offer private healthcare through BUPA, an Employee Assistance Programme covering legal, financial and counselling support for you, a Wellbeing Centre with online tools and resources, regular wellbeing seminars and workshops, annual flu jabs and an annual eye care voucher.
Financial Security and Reward: We offer an annual discretionary bonus scheme upto 30% of your base pay, life insurance at four times your salary, and a pension with Aegon. You'll also receive a significant discount on Homeprotect home insurance - with a friends and family discount too, and a staff referral bonus when someone you recommend joins the team.
Time Off: 25 days' annual leave plus bank holidays, with the option to buy or sell up to five additional days each year.
Genuine Flexible Working We trust our people to work in a way that best suits them - with flexible working to balance the needs of your role with the rhythm of your life. We ask that everyone comes into the office at least once a week, as we believe in-person connection is important for collaboration, culture and building great relationships. You'll receive a homeworking starter kit from day one and can claim towards additional home office equipment within your first six months.
Purpose and Community: We care about more than just the work. Through our charity partnership with Refuge, the UK's largest specialist domestic abuse charity and regular social, wellbeing and charitable events throughout the year, there are plenty of ways to connect, give back and feel part of something bigger.