Data Engineer

McFall Recruitment Limited
Glasgow
5 days ago
Create job alert

My client is recruiting a SQL Data Engineer for a 18‑month fixed‑term contract, within their data engineering function at a pivotal time as they continue to evolve our platforms and reporting estate. This is an opportunity to step into a highly visible, delivery‑focused environment where the quality and reliability of data pipelines and reporting really matter. Reporting directly to the Hiring Manager, you'll work as part of a collaborative team of data engineers and partner closely with colleagues across the business to design, build, maintain, and improve backend data transformation and reporting solutions.


This role can be based Glasgow or Edinburgh with hybrid working 3‑days a week in the office.


You’ll primarily work with Microsoft SQL Server technologies—particularly SSIS and T‑SQL—supporting ETL/ELT processes, database objects, and operational reporting, with a strong focus on performance, integrity, and controlled change in a legacy‑heavy environment. The role is hybrid, with an expectation of 2–3 days per week in the office (Glasgow or Edinburgh), and offers the chance to make a real impact across a regulated organisation where accountability, communication, and a proactive, hands‑on approach are valued.


What you’ll be doing

  • Build, maintain, and optimise backend data pipelines and transformations (ETL/ELT), ensuring reliable delivery of data to reporting layers, clients, and downstream systems.
  • Design, create, and maintain SQL Server database objects, partnering with the DBA team to support indexing, performance tuning, data integrity, and consistency across large‑scale datasets.
  • Develop and support SSIS integration solutions (including troubleshooting and enhancements) as a core part of day‑to‑day delivery.
  • Produce and maintain reporting outputs using SSRS, and work with stakeholders to deliver ongoing reporting changes and improvements.
  • Collaborate within a squad‑based, agile environment—contributing to analysis, solution design, development, testing, and deployment—while working closely with teams across the business (e.g., treasury, settlements, trading/execution, finance, and client teams).

What we’re looking for

  • Strong hands‑on experience as a Data Engineer, with deep expertise in Microsoft SQL Server and Transact‑SQL (including writing efficient queries, maintaining database objects, and supporting performance and data integrity).
  • Proven experience building and supporting ETL/ELT pipelines—especially using SSIS—as part of a production data platform.
  • Working knowledge of SSRS and a track record of delivering reliable reporting outputs to business stakeholders and/or clients.
  • Confident working with legacy systems and regulated environments, with a careful, quality‑first approach to change and deployment.
  • Strong analytical and problem‑solving skills, with the mindset to get involved across analysis, design, development, testing, and release.
  • Clear communicator who collaborates well across teams and functions, while also being able to take initiative and manage their own workload effectively.
  • Hybrid working approach, with the ability to be in the office 2–3 days per week to support collaboration and delivery.

What you’ll need

  • 4+ years’ hands‑on experience as a Data Engineer, with deep expertise in Microsoft SQL Server in production environments.
  • Strong SSIS (SQL Server Integration Services) capability, including building, maintaining, and troubleshooting ETL/ELT pipelines.
  • Solid SSRS (SQL Server Reporting Services) experience, with the ability to support and evolve operational and client‑facing reporting.
  • Advanced T‑SQL skills, including writing performant queries, working with indexes, and maintaining data integrity and consistency across large databases.
  • Experience designing, creating, and maintaining database objects, and collaborating effectively with DBA teams on performance and reliability.
  • Confident working across the full delivery lifecycle—requirements analysis, solution design, development, testing, deployment, and post‑release support—especially in legacy environments where quality is critical.
  • Strong analytical/problem‑solving skills, ownership mindset, and the ability to manage your time independently while escalating risks early.
  • Clear, collaborative communicator with a client‑service focus and the confidence to work with stakeholders across the business.
  • Comfortable working in a hybrid model (typically 2–3 days per week in the Edinburgh or Glasgow office).
  • Desirable: data warehousing concepts; Visual Studio and C# (e.g., SSIS script tasks); exposure to Azure/cloud reporting (e.g., Power BI); Oracle SQL/PLSQL; experience in regulated, investment, or wealth management environments.


#J-18808-Ljbffr

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.

How Many Machine Learning Tools Do You Need to Know to Get a Machine Learning Job?

Machine learning is one of the most exciting and rapidly growing areas of tech. But for job seekers it can also feel like a maze of tools, frameworks and platforms. One job advert wants TensorFlow and Keras. Another mentions PyTorch, scikit-learn and Spark. A third lists Mlflow, Docker, Kubernetes and more. With so many names out there, it’s easy to fall into the trap of thinking you must learn everything just to be competitive. Here’s the honest truth most machine learning hiring managers won’t say out loud: 👉 They don’t hire you because you know every tool. They hire you because you can solve real problems with the tools you know. Tools are important — no doubt — but context, judgement and outcomes matter far more. So how many machine learning tools do you actually need to know to get a job? For most job seekers, the real number is far smaller than you think — and more logically grouped. This guide breaks down exactly what employers expect, which tools are core, which are role-specific, and how to structure your learning for real career results.

What Hiring Managers Look for First in Machine Learning Job Applications (UK Guide)

Whether you’re applying for machine learning engineer, applied scientist, research scientist, ML Ops or data scientist roles, hiring managers scan applications quickly — often making decisions before they’ve read beyond the top third of your CV. In the competitive UK market, it’s not enough to list skills. You must send clear signals of relevance, delivery, impact, reasoning and readiness for production — and do it within the first few lines of your CV or portfolio. This guide walks you through exactly what hiring managers look for first in machine learning applications, how they evaluate CVs and portfolios, and what you can do to improve your chances of getting shortlisted at every stage — from your CV and LinkedIn profile to your cover letter and project portfolio.

MLOps Jobs in the UK: The Complete Career Guide for Machine Learning Professionals

Machine learning has moved from experimentation to production at scale. As a result, MLOps jobs have become some of the most in-demand and best-paid roles in the UK tech market. For job seekers with experience in machine learning, data science, software engineering or cloud infrastructure, MLOps represents a powerful career pivot or progression. This guide is designed to help you understand what MLOps roles involve, which skills employers are hiring for, how to transition into MLOps, salary expectations in the UK, and how to land your next role using specialist platforms like MachineLearningJobs.co.uk.