Data Engineer

Venturi; Greater London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

Venturi is looking for an Analytics Engineer in Greater London to join a focused data team for a 6-month contract. Your role will focus on rebuilding reporting infrastructure and migrating data from a legacy CRM to a cloud data stack.

You will own a defined workstream and closely collaborate with analysts to ensure successful data transformation and management of stakeholder relationships. The position requires production-level dbt experience and proficiency in BigQuery.

Qualifications

• Experience in production dbt projects.
• Proficiency in BigQuery and SQL for data handling.
• Experience with data migration and reconciliation.

Responsibilities

• Own a defined workstream for rebuilding reporting infrastructure.
• Migrate legacy CRM system data to a cloud data stack.
• Collaborate with analysts to manage stakeholder relationships.

Skills

Production dbt experience

BigQuery/SQL proficiency

Data migration/reconciliation experience

Dimensional modelling

Tools

dbt

BigQuery

Legacy CRM systems

Secoda

DataHub

OpenMetadata

Job description

Hybrid (3 days on site in Central London)

Role Overview

We’re looking for an Analytics Engineer to join a small, focused data team on a 6-month contract to rebuild reporting infrastructure and migrate from a legacy CRM system to a modern cloud data stack.

This is a hands-on, scoped delivery role where you’ll own a defined workstream, working closely with analysts who hold the domain context and manage stakeholder relationships. You’ll bring build velocity to the intermediate and fact-layer modelling while reconciling historical legacy data into new formats.

Technical Stack

• Core Transformation Tool: dbt
• Data Lineage / Catalog: Secoda, DataHub, or OpenMetadata (tool to be implemented)
• Migration Project Experience: Legacy CRM system onto BigQuery & dbt

Requirements

• Must have: Production dbt experience, BigQuery/SQL proficiency, data migration/reconciliation experience, dimensional modelling (facts/dimensions, star schemas)
• Nice to have: Legacy CRM familiarity (e.g., HubSpot), GCP platform experience, data lineage tool experience (Secoda, DataHub, OpenMetadata)

This role is 3 days on-site in Central London with a start date of 22nd June.