Data Engineer
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.