Data Engineer

We’re growing, we’re integrating, and we’re modernising. You’ll join a collaborative data warehousing team at a pivotal moment, working across both ongoing business initiatives and a major company‑wide integration programme. Your expertise in SSIS
, T‑SQL
, and modern data engineering practices will directly shape how we ingest, transform, and deliver data across the organisation.

• 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.

• 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 (Power Shell, 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.

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

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.

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.