Data Engineer

McFall Recruitment Limited
Glasgow
6 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 - AI Analytics and EdTech Developments

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 Engineering Tools Do You Need to Know to Get a Data Engineering Job?

If you’re aiming for a career in data engineering, it can feel like you’re staring at a never-ending list of tools and technologies — SQL, Python, Spark, Kafka, Airflow, dbt, Snowflake, Redshift, Terraform, Kubernetes, and the list goes on. Scroll job boards and LinkedIn, and it’s easy to conclude that unless you have experience with every modern tool in the data stack, you won’t even get a callback. Here’s the honest truth most data engineering hiring managers will quietly agree with: 👉 They don’t hire you because you know every tool — they hire you because you can solve real data problems with the tools you know. Tools matter. But only in service of outcomes. Jobs are won by candidates who know why a technology is used, when to use it, and how to explain their decisions. So how many data engineering tools do you actually need to know to get a job? For most job seekers, the answer is far fewer than you think — but you do need them in the right combination and order. This article breaks down what employers really expect, which tools are core, which are role-specific, and how to focus your learning so you look capable and employable rather than overwhelmed.

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

If you’re applying for data engineering jobs in the UK, the first thing to understand is this: Hiring managers don’t read every word of your CV. They scan it. They look for signals of relevance, credibility, delivery and collaboration — and if they don’t see the right signals quickly, your application may never get a second look. In data engineering, hiring managers are especially focused on whether you can build and operate reliable, scalable data systems, handle real-world data challenges and work effectively with analytics, BI, data science and engineering teams. This guide breaks down exactly what they look at first in your application — and how to shape your CV, portfolio and cover letter so you stand out.

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

Data engineering has quietly become one of the most critical roles in the modern technology stack. While data science and AI often receive the spotlight, data engineers are the professionals who design, build and maintain the systems that make data usable at scale. Across the UK, demand for data engineers continues to rise. Organisations in finance, retail, healthcare, government, media and technology all report difficulty hiring candidates with the right skills. Salaries remain strong, and experienced professionals are in short supply. Yet despite this demand, many graduates with degrees in computer science, data science or related disciplines struggle to secure data engineering roles. The reason is not academic ability. It is a persistent skills gap between university education and real-world data engineering work. This article explores that gap in depth: what universities teach well, what they consistently miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data engineering.