Data Engineer

Lomond
London
3 days 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.

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

Are you considering a career change into machine learning in your 30s, 40s or 50s? You’re not alone. In the UK, organisations across industries such as finance, healthcare, retail, government & technology are investing in machine learning to improve decisions, automate processes & unlock new insights. But with all the hype, it can be hard to tell which roles are real job opportunities and which are just buzzwords. This article gives you a practical, UK-focused reality check: which machine learning roles truly exist, what skills employers really hire for, how long retraining realistically takes, how to position your experience and whether age matters in your favour or not. Whether you come from analytics, engineering, operations, research, compliance or business strategy, there is a credible route into machine learning if you approach it strategically.

How to Write a Machine Learning Job Ad That Attracts the Right People

Machine learning now sits at the heart of many UK organisations, powering everything from recommendation engines and fraud detection to forecasting, automation and decision support. As adoption grows, so does demand for skilled machine learning professionals. Yet many employers struggle to attract the right candidates. Machine learning job adverts often generate high volumes of applications, but few applicants have the blend of modelling skill, engineering awareness and real-world experience the role actually requires. Meanwhile, strong machine learning engineers and scientists quietly avoid adverts that feel vague, inflated or confused. In most cases, the issue is not the talent market — it is the job advert itself. Machine learning professionals are analytical, technically rigorous and highly selective. A poorly written job ad signals unclear expectations and low ML maturity. A well-written one signals credibility, focus and a serious approach to applied machine learning. This guide explains how to write a machine learning job ad that attracts the right people, improves applicant quality and strengthens your employer brand.

Maths for Machine Learning Jobs: The Only Topics You Actually Need (& How to Learn Them)

Machine learning job adverts in the UK love vague phrases like “strong maths” or “solid fundamentals”. That can make the whole field feel gatekept especially if you are a career changer or a student who has not touched maths since A level. Here is the practical truth. For most roles on MachineLearningJobs.co.uk such as Machine Learning Engineer, Applied Scientist, Data Scientist, NLP Engineer, Computer Vision Engineer or MLOps Engineer with modelling responsibilities the maths you actually use is concentrated in four areas: Linear algebra essentials (vectors, matrices, projections, PCA intuition) Probability & statistics (uncertainty, metrics, sampling, base rates) Calculus essentials (derivatives, chain rule, gradients, backprop intuition) Basic optimisation (loss functions, gradient descent, regularisation, tuning) If you can do those four things well you can build models, debug training, evaluate properly, explain trade-offs & sound credible in interviews. This guide gives you a clear scope plus a six-week learning plan, portfolio projects & resources so you can learn with momentum rather than drowning in theory.