Senior Data Engineer

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.