Data Engineer

McFall Recruitment Limited
Glasgow
1 week 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 Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

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

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.