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

Apply Now

Lead Data Engineer

Story Terrace Inc.
City of London
1 week ago
Create job alert

Legal 500 was founded by John Pritchard in 1987 as the original clients’ guide to law firms, the first of its kind. It is now a data-driven, AI-optimised research platform which benchmarks, informs and connects providers and users of legal services in over 100 countries worldwide. Our research and data are trusted and relied upon by corporate clients globally as an essential part of the process, both of instructing law firms with new mandates, and when reviewing existing mandates or panels. We exist to empower both buyers and sellers in the international legal marketplace to make better decisions and have improved outcomes for their organisations. This is achieved by leveraging a trusted, comprehensive research process with a unique, vast, proprietary and constantly updated set of client-supplied data, unrivalled in the market. On the supply side of the legal market, every year Legal 500’s team of over 150 researchers, technologists, data analysts, journalists and content specialists collate and review 60,000+ data‑submissions from law firms and conduct interviews with thousands of leading law firm partners. On the demand side, Legal 500 analyses confidential data from 300,000+ commercial law firm clients to benchmark law firms and lawyers by practice area; industry; jurisdiction; as well as by proprietary client satisfaction metrics, NPS®, and other qualitative and quantitative criteria. Legal 500 is the only source of this depth of global research and data on law firms, lawyers and their clients.


The Role

As our Lead Data Engineer, you’ll be the senior technical voice in the data team and a critical partner to the Head of Data. You’ll design, build, and improve our Snowflake and dbt-driven platform, establish engineering best practices, and support the growth of our data capabilities as the organisation scales.


You’ll work in a Microsoft-first environment, using Azure cloud services to orchestrate, automate, and deliver robust, production-ready data pipelines.


This is a hands‑on leadership role with real ownership and the opportunity to bring modern engineering discipline into a growing function.


What You’ll Be Doing
Platform Ownership & Architecture

  • Lead the architectural direction of our Snowflake-based data platform
  • Design scalable ELT pipelines and transformation layers using dbt
  • Build high-quality data models across staging, intermediate, and marts layers
  • Make architectural decisions around modelling approaches and data lifecycle design

Data Engineering & Delivery

  • Develop and optimise transformations in dbt and SQL
  • Use Azure services (e.g., Azure Data Factory, Azure Functions, Azure Storage) to orchestrate and deliver pipelines
  • Introduce CI/CD, testing, code quality, observability, and documentation best practices
  • Improve performance, cost efficiency, and reliability of the platform

Leadership & Continuous Improvement

  • Set engineering standards, patterns, and technical guidelines for the team
  • Mentor and guide engineers and analysts
  • Partner closely with product, software engineering, and research teams
  • Drive a culture of ownership, collaboration, and delivery excellence

What We’re Looking For
Technical Skills

  • Strong experience with Snowflake (performance tuning, warehouses, modelling, optimisation)
  • Deep experience with dbt (tests, macros, documentation, project structure)
  • Excellent SQL skills and strong data modelling foundations
  • Experience designing and building ELT pipelines
  • Experience using Azure cloud services for data workflows (e.g., Data Factory, Azure Functions, ADLS)
  • Solid understanding of version control, CI/CD, testing, and engineering best practice

Leadership & Ownership

  • Experience leading or steering data engineering initiatives
  • Ability to introduce structure, standards, and long-term thinking
  • Comfortable influencing cross-functional teams and mentoring others
  • Pragmatic, delivery-focused approach with strong communication skills


#J-18808-Ljbffr

Related Jobs

View all jobs

Lead Data Engineer

Lead Data Engineer

Lead Data Engineer

Lead Data Engineer

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.