Hybrid Analytics Engineer: BigQuery, dbt & Data Modeling

Ocado Technology Group; Hatfield; Hybrid; GBP 50,000 - 70,000; Full time

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.