Data Engineer

Raymond James UK; Greater London; On-site; GBP 60,000 - 90,000; Full time

Job summary

Raymond James UK is seeking a Data Engineer to join our data platform team. You will design, build, and optimize ETL pipelines using SSIS and T-SQL, contributing to a unified data warehouse across multiple systems. This role emphasizes data quality, performance, and scalable data ingestion.

You will collaborate with analysts, SMEs, and stakeholders to deliver robust data solutions, with a strong emphasis on documentation and best practices in data warehousing.

Qualifications

• 3+ years in operational data teams.
• Degree in Computer Science, IT, or equivalent experience.
• Hands-on data warehouse and ETL design and delivery.
• Strong SSIS and SQL Server development background.
• Deep knowledge of T-SQL, stored procedures, indexing, and query optimisation.
• Experience scripting within SSIS (PowerShell, C#, Python).
• Solid understanding of data warehousing concepts and best practices.
• Strong analytical, problem-solving, and communication skills.
• High attention to detail and commitment to data quality.

Responsibilities

• Map source systems, refine data models, and design SSIS packages and database schemas.
• Redevelop and uplift ETL pipelines into a unified warehouse.
• Write and optimise T-SQL scripts, procedures, and transformations.
• Ensure warehouse stability, scalability for growing data volumes.
• Validate ETL accuracy, troubleshoot data quality issues.
• Maintain clear, future-proof technical documentation.
• Collaborate with analysts, developers, SMEs and stakeholders.

Skills

T-SQL

SSIS

SQL Server

ETL development

Data warehousing

Data integration

Stored procedures

Indexing

Query optimisation

PowerShell

C# scripting

Python

Data quality

Analytical skills

Communication

Education

Degree in Computer Science or IT

Tools

SSIS

WhereScape Red

PowerShell

C#

Python

SQL Server

Job description

Join us at a pivotal stage in our data transformation journey as we bring multiple systems together into a unified enterprise data platform. Working with T-SQL, SSIS, and modern data engineering practices, you'll help solve complex integration challenges, build trusted data assets, and shape how data flows across the organisation.

What You’ll Be Doing:

• Analysis & Design - Partner with Data Analysts to map source systems, refine data models, and design SSIS packages and database schemas.
• ETL Development & Integration - Redevelop and uplift existing ETL pipelines to bring multiple systems together into a unified warehouse.
• T‑SQL Engineering - Write and optimise complex scripts, stored procedures, and transformations for high‑performance data processing.
• Performance Optimisation - Ensure our warehouse is stable, scalable, and ready for increasing data volumes.
• Testing & Validation - Validate ETL accuracy, troubleshoot data quality issues, and support end‑to‑end testing.
• Documentation - Keep our technical documentation clear, complete, and future‑proof.
• Collaboration - Work closely with analysts, developers, SMEs, and business stakeholders to deliver high‑value data solutions.

What You Bring:

Required

• 3+ years working in operational data teams.
• Degree in Computer Science, IT, or equivalent experience.
• Hands‑on experience designing and delivering data warehouse and ETL solutions.
• Strong SSIS and SQL Server development background.
• Deep knowledge of T‑SQL, stored procedures, indexing, and query optimisation.
• Experience scripting within SSIS (PowerShell, C#, Python).
• Solid understanding of data warehousing concepts and best practices.
• Strong analytical, problem‑solving, and communication skills.
• High attention to detail and commitment to data quality.

Preferred

• Exposure to data warehouse uplift or modernisation projects.
• Experience working in organisations undergoing mergers or acquisitions.
• Familiarity with WhereScape Red.
• Knowledge of data modelling, data architecture, governance, and data quality frameworks.

Why This Role Matters:

You won’t be maintaining someone else’s legacy system, you’ll be shaping the future of how data flows across a newly integrated organisation. Your work will influence reporting, analytics, decision‑making, and the long‑term data strategy.

About Us:

Raymond James is a wealth management firm focused on providing trusted advice and tailored, personalised investment services. We believe if we do what’s right for clients, we’ll help them achieve success while also realising our own. Our parent company, Raymond James Financial, has been doing the same in the US for over six decades. Raymond James is listed on the NYSE, is a Fortune 500 company, and is included in the S&P 500.

Raymond James is an equal opportunities employer. We treat all of our applicants the same and we have a diversity and inclusion strategy aimed at ensuring we hire the best person for the job regardless of age, gender, ethnicity, sexual orientation, disability or beliefs.