Senior Analytics Engineer - dbt Specialist | Fully Remote (UK) | 6-Month Contract

Morgan McKinley United Kingdom
Remote
Apply
AI Summary

Lead data migration and model rebuilding using dbt. Collaborate with a small, agile data team to transition from legacy architecture. Ensure data accuracy and integrity during a major transformation project.

Key Highlights
Shape a modern analytics platform during a major transformation
Get hands-on with data migration, reconciliation, and modeling using dbt
Work closely with analysts and stakeholders to understand legacy data structures
Key Responsibilities
Build and maintain analytics models using dbt
Reconcile and validate historical datasets during migration
Develop and optimize SQL transformations within BigQuery
Investigate and resolve data quality issues
Design robust testing and validation frameworks
Contribute to data governance, documentation, and lineage initiatives
Technical Skills Required
dbt SQL BigQuery Data modeling Data migration Data validation
Benefits & Perks
£450-500 per day
Fully Remote (UK)
6-Month Initial Contract
Nice to Have
HubSpot data or CRM migration experience
Data lineage/catalogue tooling (Secoda, DataHub, OpenMetadata, Atlan etc.)
GCP experience
Looker or modern BI tooling

Job Description


Analytics Engineer (DBT) | Outside IR35 Contract

Fully Remote (UK)

£450-500 per day

6 Months Initial Contract

Outside IR35


We're supporting a growing, technology-led organisation as they undertake a major transformation of their analytics platform and data estate.


This is a hands-on Analytics Engineering contract focused on data migration, reconciliation and rebuilding core analytics models. You'll play a key role in helping the business transition away from a legacy architecture while ensuring the accuracy, integrity and trustworthiness of critical business data.


Working closely with a small, highly collaborative data team, you'll be responsible for investigating legacy datasets, designing robust dbt models and supporting the build-out of a modern analytics environment.


Key Responsibilities

  • Build and maintain analytics models using dbt
  • Reconcile and validate historical datasets during a major migration programme
  • Develop and optimise SQL transformations within BigQuery
  • Investigate and resolve data quality issues
  • Design robust testing and validation frameworks
  • Work closely with analysts and business stakeholders to understand legacy data structures and business rules
  • Contribute to data governance, documentation and lineage initiatives


Essential Experience

  • Strong commercial experience with dbt
  • Advanced SQL skills
  • BigQuery or modern cloud data warehouse experience
  • Data modelling and analytics engineering best practices
  • Data migration and reconciliation projects
  • Strong understanding of data quality, validation and testing


Desirable Experience

  • HubSpot data or CRM migration experience
  • Data lineage/catalogue tooling (Secoda, DataHub, OpenMetadata, Atlan etc.)
  • GCP experience
  • Looker or modern BI tooling


The Opportunity

This is a chance to join a business at a pivotal stage of its data journey, helping to shape a modern analytics platform while solving complex migration and data quality challenges.


If you're an Analytics Engineer with strong dbt experience and enjoy getting hands-on with data transformation, migration and modelling, I'd be keen to speak with you.


Similar Jobs

Explore other opportunities that match your interests

Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

chrome technologies

United Kingdom

Head of Data

Programming
1h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

rvu

United Kingdom

Integration Solutions Consultant

Programming
1d ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

spotted zebra

United Kingdom

Subscribe our newsletter

New Things Will Always Update Regularly