Senior Databricks Data Engineer - Real Estate Platform

Marks Sattin (UK) Ltd; Greater London; Hybrid; GBP 90,000 - 130,000; Full time

Job summary

Marks Sattin (UK) Ltd is partnering with a global real estate investment and asset management organisation in London, undertaking a significant transformation of its data estate. The role focuses on migrating critical data capabilities from legacy SQL Server to a modern Databricks platform to enable scalable analytics and investment decision-making.

As part of the Real Estate Technology team, you will shape target architecture, establish governance and best-practice data engineering standards,

Qualifications

• Strong experience with SQL Server, T-SQL, Databricks and Spark SQL in enterprise environments.
• Proven track record delivering large-scale data migration or modernisation programmes.
• Expertise in relational, dimensional and analytical data modelling, including modern lakehouse and medallion architectures.
• Experience performing data profiling, lineage analysis, source-to-target mapping and data quality assessment.
• Strong understanding of production-grade data platforms, performance optimisation and operational support.
• Experience migrating SSIS, ETL pipelines, stored procedures and reporting solutions to cloud-based platforms.
• Exposure to Azure DevOps, Git and CI/CD practices.
• Experience with Python, PySpark, Power BI or real estate technology platforms would be advantageous.
• Previous exposure to commercial real estate, investment management or alternative asset management environments is highly desirable.

Responsibilities

• Lead the assessment and modernisation of legacy SQL Server, ETL and reporting workloads into a Databricks-based architecture.
• Design scalable data models, Delta Lake structures and transformation pipelines supporting real estate investment data.
• Analyse data lineage, dependencies, business logic and data quality to determine what should be migrated, redesigned or retired.
• Build robust reconciliation, monitoring and governance controls to ensure accuracy, auditability and operational resilience.
• Partner closely with investment, finance and technology teams to deliver a phased migration strategy aligned to business objectives.

Skills

SQL Server

T-SQL

Databricks

Spark SQL

Python

PySpark

Data modelling

Data governance

Tools

Azure DevOps

Git

CI/CD

Power BI

Job description

Marks Sattin (UK) Ltd is partnering with a global real estate investment and asset management organisation in London, undertaking a significant transformation of its data estate. The role focuses on migrating critical data capabilities from legacy SQL Server to a modern Databricks platform to enable scalable analytics and investment decision-making.

As part of the Real Estate Technology team, you will shape target architecture, establish governance and best-practice data engineering standards,