Contract Senior Data Engineer
London (Fleet Street) | Hybrid | 6 months

We’re Legal 500 a global leader in research and data on the legal services industry. Our platform powers decision-making for law firms and clients worldwide, combining 60,000+ annual data submissions with insights from 300,000+ client interviews.

We’re seeking a Contract Senior Data Engineer to join our London team and deliver scalable, high-impact data solutions. This is a hands-on role where you’ll need to hit the ground running with Snowflake and dbt.

What you’ll do

• Design and implement data pipelines across ingestion, transformation, and presentation.
• Work directly with Snowflake and dbt to deliver optimised, production-ready models
• Build and maintain ELT processes (SQL, Python, Azure Data Factory, APIs).
• Optimise performance within Snowflake (queries, compute, storage).
• Ensure governance, access control, and data quality across the platform.
• Collaborate closely with BI, engineering, and product teams.

What we’re looking for

• Proven track record as a Senior Data Engineer in a modern cloud environment.
• Expert in Snowflake (design, optimisation, advanced SQL).
• Strong experience with dbt for transformations and modelling.
• Skilled in SQL and Python (automation, scripting, integration).
• Familiar with Azure Data Factory / Functions and APIs for integration.
• Comfortable joining a team where systems and processes are still evolving.

Essential Criteria

• Proven, hands-on expertise with Snowflake (architecture, modelling, optimisation).
• Production experience with dbt for transformations and data modelling.
• Advanced SQL skills (complex queries, performance tuning, stored procedures).
• Strong Python for automation, scripting, and integration.
• Familiarity with Azure Data Factory / Functions for orchestration and integration.
• Track record of delivering end-to-end data engineering solutions in cloud environments.

Ideal start: ASAP