Be at the heart of actionFly remote-controlled drones into enemy territory to gather vital information.

Apply Now

Lead Data Engineer - 8 Month FTC (London)

AND Digital
City of London
3 weeks ago
Create job alert
Overview

Our client is currently progressing their Analytics Data platform migration. They have a team of Analytics Engineers and Data Engineers driving the migration of a large-scale on-prem Oracle data warehouse to Google Cloud Platform (GCP) BigQuery. The team is responsible for building and maintaining analytical data models and ETL workflows to enable a modern, scalable data platform supporting analytics and data science initiatives.

Key Responsibilities
  • Collaborate with Data Engineers to support the migration of data models from Oracle to BigQuery using DBT and ELT pipelines.
  • Develop, optimise, and maintain analytical data models following the Medallion architecture within BigQuery.
  • Translate complex Oracle table structures into scalable GCP data models to support analytical use cases.
  • Work with ingestion pipelines leveraging Kafka (in batches), Dataflow, to ensure reliable data availability in BigQuery.
  • Contribute to the build-out of the analytical data warehouse, ensuring data quality and governance standards are upheld.
  • Engage with prioritised migration plans to lift and shift tables and data models, targeting 60% migration completion within the year and full migration by mid-2025.
  • Participate in code freezes and deliverables aligned with project timelines, with onboarding into Rightmove targeted for late October/early November.
Required Skills and Experience
  • Strong proficiency in SQL and data modeling best practices.
  • Hands-on experience with GCP BigQuery and cloud-based ETL/ELT workflows.
  • Practical knowledge of DBT for data transformation and modeling.
  • Experience working with data ingestion from batch/streaming sources such as Kafka and Dataflow or similar tools.
  • Prior involvement in data platform migrations, particularly transitioning from Oracle data warehouses to cloud platforms, is highly desirable.
  • Ability to work effectively in a collaborative, agile team environment focused on delivering large-scale data migration projects.
Joining AND

From the work we deliver, to the way we serve and support our people, we work hard to ensure that there's nowhere quite like AND. But joining a company is a two-way street: the fit has to work on both sides. So before you apply, here's three key things to understand about us:

  • We're built for people - like, real humans. Not 'resources' or 'staff'. That means happiness and wellbeing really do matter to us, and we hate unnecessary hierarchy and bureaucracy.
  • There's no well-trodden path ahead: AND is growing fast and forging a new trail. That's exciting, and gives us all the autonomy and opportunity we love - but bear in mind it also demands focus, patience and resilience.
  • Diversity is a priority. After all, to build great products that a wide variety of different people love to use, we need a wide variety of people to help us build them. So diversity is more than a policy or a word: it's business critical for us.


#J-18808-Ljbffr

Related Jobs

View all jobs

Lead Data Engineer

Lead Data Engineer - Edinburgh

Lead Data Engineer - Edinburgh...

Lead Data Engineer - 8 Month FTC (London)

Lead Data Engineer

Lead Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Data Science Recruitment Trends 2025 (UK): What Job Seekers Need To Know About Today’s Hiring Process

Summary: UK data science hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise rigorous problem framing, high‑quality analytics & modelling, experiment/causality, production awareness (MLOps), governance/ethics, and measurable product or commercial impact. This guide explains what’s changed, what to expect in interviews & how to prepare—especially for product/data scientists, applied ML scientists, decision scientists, econometricians, growth/marketing analysts, and ML‑adjacent data scientists supporting LLM/AI products. Who this is for: Product/decision/data scientists, applied ML scientists, econometrics & causal inference specialists, experimentation leads, analytics engineers crossing into DS, ML generalists with strong statistics, and data scientists collaborating with platform/MLOps teams in the UK.

Why Data Science Careers in the UK Are Becoming More Multidisciplinary

Data science once meant advanced statistics, machine learning models and coding in Python or R. In the UK today, it has become one of the most in-demand professions across sectors — from healthcare to finance, retail to government. But as the field matures, employers now expect more than technical modelling skills. Modern data science is multidisciplinary. It requires not just coding and algorithms, but also legal knowledge, ethical reasoning, psychological insight, linguistic clarity and human-centred design. Data scientists are expected to interpret, communicate and apply data responsibly, with awareness of law, human behaviour and accessibility. In this article, we’ll explore why data science careers in the UK are becoming more multidisciplinary, how these five disciplines intersect with data science, and what job-seekers & employers need to know to succeed in this transformed field.

Data Science Team Structures Explained: Who Does What in a Modern Data Science Department

Data science is one of the most in-demand, dynamic, and multidisciplinary areas in the UK tech and business landscape. Organisations from finance, retail, health, government, and beyond are using data to drive decisions, automate processes, personalise services, predict trends, detect fraud, and more. To do that well, companies don’t just need good data scientists; they need teams with clearly defined roles, responsibilities, workflows, collaboration, and governance. If you're aiming for a role in data science or recruiting for one, understanding the structure of a data science department—and who does what—can make all the difference. This article breaks down the key roles, how they interact across the lifecycle of a data science project, what skills and qualifications are typical in the UK, expected salary ranges, challenges, trends, and how to build or grow an effective team.