Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform complex data into actionable insights that shape business strategy.
- Company: Join Lomond, the UK's leading lettings and estate agency network.
- Benefits: Enjoy health perks, funded qualifications, and up to 28 days holiday.
- Why this job: Make a real impact in the real estate industry with cutting-edge data solutions.
- Qualifications: Experience in Azure, Snowflake, and strong SQL skills required.
- Other info: Dynamic work environment with excellent career growth opportunities.
The predicted salary is between 36000 - 60000 £ per year.
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 available for a standard workweek of 37.5 hours, Monday to Friday, 9am to 5.30pm.
Responsibilities
- Own the build and reliability of our modern data platform across Azure/Microsoft Fabric and Snowflake.
- 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.
- Data Ingestion & 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.
Rewards & 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.
Data Engineer - Lomond in City of London employer: Jobster
Contact Detail:
Jobster Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer - Lomond in City of London
✨Tip Number 1
Network like a pro! Reach out to current employees at Lomond on LinkedIn or other platforms. Ask them about their experiences and any tips they might have for landing the Data Engineer role. Personal connections can give you an edge!
✨Tip Number 2
Prepare for the interview by brushing up on your technical skills. Make sure you can confidently discuss Azure, Snowflake, and dbt. We recommend doing some mock interviews with friends or using online resources to practice common questions.
✨Tip Number 3
Showcase your projects! If you've worked on relevant data engineering projects, be ready to discuss them in detail. Highlight how you’ve tackled challenges and what impact your work had. This will demonstrate your hands-on experience and problem-solving skills.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the Lomond team. Good luck!
We think you need these skills to ace Data Engineer - Lomond in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Engineer role at Lomond. Highlight your experience with Azure, Snowflake, and dbt, as well as any relevant projects that showcase your skills in data ingestion and transformation.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how your background aligns with Lomond's mission to transform the real estate landscape. Keep it concise but impactful!
Showcase Your Problem-Solving Skills: In your application, don’t forget to mention specific examples where you've tackled complex data challenges. We love seeing how you approach problem-solving, especially in a collaborative environment like ours.
Apply Through Our Website: We encourage you to apply directly through our website for the best chance of getting noticed. It’s super easy, and you’ll be one step closer to joining our amazing team at Lomond!
How to prepare for a job interview at Jobster
✨Know Your Data Inside Out
Make sure you’re well-versed in the data engineering concepts mentioned in the job description. Brush up on Azure Data Factory, Snowflake, and dbt. Be ready to discuss how you've used these tools in past projects and how they can be applied at Lomond.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data issues in the past. Lomond values strong problem-solving abilities, so think of specific challenges you've faced and how you resolved them, especially in relation to data ingestion and pipeline reliability.
✨Understand the Business Context
Research Lomond and its position in the real estate market. Understand how data insights can drive business strategy and market positioning. This will help you articulate how your role as a Data Engineer can contribute to their goals.
✨Prepare Questions for Them
Interviews are a two-way street! Prepare thoughtful questions about the team dynamics, the data platform they use, and their future projects. This shows your genuine interest in the role and helps you assess if Lomond is the right fit for you.
