Senior Data Engineer: Synapse to Databricks (Remote)

Consult

England

Hybrid

GBP 96,000 - 126,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Fully remote

Job summary

Consult is seeking a Senior Data Engineer for a fully remote, 2-month contract to migrate an Azure Synapse Dedicated SQL Pool codebase to Databricks, delivering parity or improved performance and ensuring data accuracy.

You will refactor ~72 T-SQL procedures, optimise Spark/PySpark queries and validate datasets for downstream consumption, addressing architecture differences between Synapse and Databricks.

Qualifications

  • Hands-on experience with Azure Synapse Dedicated SQL Pool migrations.
  • Advanced T-SQL skills including complex stored procedures and optimization.
  • Experience migrating large SQL workloads to Databricks.
  • Knowledge of Delta Lake and lakehouse architectures.

Responsibilities

  • Migrate ~72 T-SQL stored procedures from Synapse to Databricks.
  • Analyse code, dependencies and execution patterns for migration strategy.
  • Refactor T-SQL logic for Databricks SQL, Spark SQL and PySpark.
  • Ensure datasets and pipelines are available for downstream consumption.

Skills

Azure Synapse Analytics
Databricks & Spark SQL
T-SQL & SQL migration
PySpark
Delta Lake

Tools

Azure Databricks
Spark SQL

Job description

Consult is seeking a Senior Data Engineer for a fully remote, 2-month contract to migrate an Azure Synapse Dedicated SQL Pool codebase to Databricks, delivering parity or improved performance and ensuring data accuracy.

You will refactor ~72 T-SQL procedures, optimise Spark/PySpark queries and validate datasets for downstream consumption, addressing architecture differences between Synapse and Databricks.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Consult • England

Hybrid
GBP 96,000 - 126,000
Fully remote
Remote Senior Databricks Data Engineer (3‑Month Contract)
Remote Senior Databricks Data Engineer (3‑Month Contract)

Tenth Revolution Group • United Kingdom

Remote
GBP 90,000 - 130,000
Senior Data Engineer: Azure Databricks & PySpark (Remote UK)
Senior Data Engineer: Azure Databricks & PySpark (Remote UK)

Ceox Services Ltd • United Kingdom

Remote
GBP 92,000 - 129,000
Databricks Consultant & Lakehouse Data Engineer (Remote)
Databricks Consultant & Lakehouse Data Engineer (Remote)

Consult • Leeds

Hybrid
GBP 83,000 - 166,000
Senior Data Engineer — Azure, Databricks & Lakehouse
Senior Data Engineer — Azure, Databricks & Lakehouse

DCG (Poland) • United Kingdom

Remote
GBP 80,000 - 120,000
Private medical care
Co-financing for the sports card
Dedicated consultant support
Senior Databricks Data Engineer
Senior Databricks Data Engineer

Tenth Revolution Group • United Kingdom

Remote
GBP 90,000 - 130,000
Senior Data Engineer: Azure Databricks Platform Lead
Senior Data Engineer: Azure Databricks Platform Lead

Talensa Partners • Greater London

Hybrid
GBP 90,000 - 130,000
Competitive Salary
Annual Bonus and Growth Share Scheme
Pension
+3
Senior Data Engineer - Azure Databricks (Remote UK)
Senior Data Engineer - Azure Databricks (Remote UK)

EnerMech • United Kingdom

Remote
GBP 80,000 - 120,000
Remote Senior Data Engineer: Databricks, Data Vault & Synapse
Remote Senior Data Engineer: Databricks, Data Vault & Synapse

FalconSmartIT • Guildford

Hybrid
GBP 90,000 - 120,000
Senior Analytics Engineer - Databricks Lakehouse (Remote)
Senior Analytics Engineer - Databricks Lakehouse (Remote)

Synapri • Sheffield

Remote
GBP 70,000 - 110,000