Data Engineer

Lomond
City of London
1 week ago
Create job alert

Welcome to Lomond, the UK's leading network of lettings and estate agencies. We are not just a successful acquisitions company; we have established ourselves as a prominent player in the real estate industry. Our extensive network consists of 12 leading lettings and estate agencies, and we have made over 80 strategic acquisitions to date. At Lomond, we are relentlessly committed to excellence and dedicated to transforming the real estate landscape. With our team's vast industry expertise and local knowledge, we are here to redefine expectations in our sector and lead the way for change.


We’re looking for a Data Engineer to join us here at Lomond. You’ll work closely with our Chief Commercial Officer to research and turn complex data into clear, actionable insights that shape business strategy and market positioning across the UK.

This is a full-time, permanent position located in our Liverpool Street, London office. You will be required to be You'll enjoy a standard workweek of 37.5 hours, Monday to Friday, 9am to 5.30pm.


Job Overview

Own the build and reliability of our modern data platform across Azure/Microsoft Fabric and Snowflake. You’ll design and operate ingestion and transformation pipelines (dbt), integrate external data via APIs, optimise warehouse performance/cost, and manage secure access (RBAC) so data remains trusted, governed, and ready for analytics and reporting.


Key Responsibilities

  • Data Engineering & Pipelines
  • Design, build, and operate data ingestion and transformation pipelines in Azure Data Factory / Fabric Data Factory.
  • Implement medallion architectures in Microsoft Fabric Lakehouse/Warehouse or Azure Synapse. Develop and maintain dbt projects including models, tests, and documentation.
  • API Integrations & Semistructured Data
  • Build connectors for REST/GraphQL APIs with proper authentication and schema handling. Ingest and normalise JSON/Parquet with schema evolution.
  • Reliability, Observability & Support
  • Implement monitoring, freshness checks, and incident response. Troubleshoot production issues and ensure reliable pipelines.


Skills & Experience (Required)

Cloud & Platforms:

  • Azure (Data Factory / Fabric Data Factory; Fabric Lakehouse/Warehouse or Synapse/SQL DW).
  • Snowflake (RBAC, warehouses, grants, tuning/cost control).

Data Engineering & Modelling:

  • dbt (models, tests, documentation, environments) and strong SQL.
  • Modern modelling (star/snowflake schemas; medallion architecture; staging→curated marts).
  • Handling large datasets and performance optimisation (file/partition strategy, caching, query design).

Integration:

  • API ingestion (OAuth2/API keys, pagination, error handling, schema evolution).
  • Working with JSON/Parquet and Delta/Parquet storage patterns.

Administration & Governance:

  • Foundational DBA skills (backup/retention, access control, resource monitoring, performance/cost optimisation).
  • Security best practice (masking, RLS/CLS), auditability, and change control (versioning, release management/CICD).

Ways of Working:

  • Clear documentation, strong problem-solving, and effective collaboration across technical and business teams.


Reward & Benefits

Health & Wellbeing – Access to our smart spending app with discounts at 900+ retailers, wellbeing resources, free counselling, and a Virtual GP service.

Learning & Development – We’ll support your professional growth with funded qualifications and over 90 in-house training programmes.

Holidays & Enhanced Leave – Up to 28 days’ holiday plus bank holidays, your birthday off, the option to buy extra days, and enhanced family friendly leave (Neonatal, maternity, paternity, adoption & IVF).

Lifestyle Perks – Cycle2Work scheme, Smart Tech scheme for the latest gadgets, and celebrations for long service.

Security & Support – Life assurance cover to protect your loved ones.

Related Jobs

View all jobs

Data Engineer

Data Engineer

Data Engineer

Data Engineer

Data Engineer

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.

The Skills Gap in Data Engineering Jobs: What Universities Aren’t Teaching

Data engineering has quietly become one of the most critical roles in the modern technology stack. While data science and AI often receive the spotlight, data engineers are the professionals who design, build and maintain the systems that make data usable at scale. Across the UK, demand for data engineers continues to rise. Organisations in finance, retail, healthcare, government, media and technology all report difficulty hiring candidates with the right skills. Salaries remain strong, and experienced professionals are in short supply. Yet despite this demand, many graduates with degrees in computer science, data science or related disciplines struggle to secure data engineering roles. The reason is not academic ability. It is a persistent skills gap between university education and real-world data engineering work. This article explores that gap in depth: what universities teach well, what they consistently miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data engineering.

Data Engineering Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data engineering in your 30s, 40s or 50s? You’re not alone. In the UK, companies of all sizes — from fintechs to government agencies, retailers to healthcare providers — are building data teams to turn vast amounts of information into insight and value. That means demand for data engineering talent remains strong, but there’s a gap between media hype and the real pathways available to mid-career professionals. This guide gives you the straight UK reality check: which data engineering roles are genuinely open to career switchers, what skills employers actually look for, how long retraining really takes and how to position your experience for success.

How to Write a Data Engineering Job Ad That Attracts the Right People

Data engineering is the backbone of modern data-driven organisations. From analytics and machine learning to business intelligence and real-time platforms, data engineers build the pipelines, platforms and infrastructure that make data usable at scale. Yet many employers struggle to attract the right data engineering candidates. Job adverts often generate high application volumes, but few applicants have the practical skills needed to build and maintain production-grade data systems. At the same time, experienced data engineers skip over adverts that feel vague, unrealistic or misaligned with real-world data engineering work. In most cases, the issue is not a shortage of talent — it is the quality and clarity of the job advert. Data engineers are pragmatic, technically rigorous and highly selective. A poorly written job ad signals immature data practices and unclear expectations. A well-written one signals strong engineering culture and serious intent. This guide explains how to write a data engineering job ad that attracts the right people, improves applicant quality and positions your organisation as a credible data employer.