SSIS Data Engineer

My client is recruiting a SQL Data Engineer, 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 in 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, SSIS 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.