Job Search and Career Advice Platform

Enable job alerts via email!

Hybrid Analytics Engineer: BigQuery, dbt & Data Modeling

Ocado Technology Group

Hatfield

Hybrid

GBP 50,000 - 70,000

Full time

Today
Be an early applicant

Generate a tailored resume in minutes

Land an interview and earn more. Learn more

Job summary

A leading logistics technology provider in Hatfield is looking for an Analytics Engineer to enhance their data model capabilities. You will be responsible for designing, testing, and documenting production-grade data models and automating data pipelines to improve decision-making. Candidates must possess a strong background in SQL and experience with Google BigQuery. The company offers a collaborative culture, flexible working conditions, and comprehensive benefits to support employee well-being.

Benefits

30 days 'work from anywhere' policy
Dedicated wellbeing support apps
Generous leave increasing with years of service
Pension plan with up to 7% employer contribution
Comprehensive private medical cover
Family-friendly leave policies
Interest-free train tickets
Free shuttle services
Share schemes
15% discount on Ocado and other retailers
Income protection and life insurance

Qualifications

  • Highly proficient in SQL, with experience in window functions and performance tuning.
  • Hands-on experience with Google Cloud Platform.
  • Strong understanding of dimensional modelling and Star Schema.
  • Experienced in using dbt for data transformation.
  • Ability to communicate technical specifications from business requirements.

Responsibilities

  • Design and document production-grade data models using SQL and dbt.
  • Develop transformation layers for analytical needs.
  • Automate data pipelines for analysis and user-centric applications.
  • Optimize SQL queries for performance efficiency.
  • Champion software engineering best practices in analytics.

Skills

Proficiency in SQL
Experience with cloud data warehouses
Understanding of data modelling concepts
Experience with dbt or similar tools
Proactive communication skills

Education

Relevant degree or equivalent experience

Tools

Google BigQuery
Git
Job description
A leading logistics technology provider in Hatfield is looking for an Analytics Engineer to enhance their data model capabilities. You will be responsible for designing, testing, and documenting production-grade data models and automating data pipelines to improve decision-making. Candidates must possess a strong background in SQL and experience with Google BigQuery. The company offers a collaborative culture, flexible working conditions, and comprehensive benefits to support employee well-being.
Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.