At a Glance
- Tasks: Join a dynamic team to shape data flow and deliver high-value solutions.
- Company: Raymond James, a forward-thinking company embracing diversity and innovation.
- Benefits: Competitive salary, inclusive culture, and opportunities for professional growth.
- Other info: Collaborative environment with exciting projects and career advancement potential.
- Why this job: Make a real impact on data strategy in a newly integrated organisation.
- Qualifications: 3+ years in data teams, strong SSIS and T-SQL skills required.
The predicted salary is between 50000 - 60000 £ per year.
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.
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.
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.
Data Engineer employer: Raymond James UK
At Raymond James, we pride ourselves on fostering a dynamic and inclusive work environment where innovation thrives. As a Data Engineer, you will not only contribute to exciting data integration projects but also benefit from our commitment to employee growth through continuous learning opportunities and collaborative teamwork. Located in a vibrant area, our culture encourages creativity and values diverse perspectives, making it an excellent place for professionals seeking meaningful and rewarding careers.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field and let them know you're on the lookout for opportunities. You never know who might have a lead or can refer you to someone hiring.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best work with SSIS, T-SQL, and any ETL projects you've tackled. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common data engineering questions and scenarios. Practice explaining your past projects and how you’ve optimised data processes – this is your chance to shine!
✨Tip Number 4
Don’t forget to apply through our website! We’re always looking for talented individuals like you to join our team. Keep an eye on our job postings and get your application in – we can’t wait to see what you’ve got!
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with SSIS, T-SQL, and data warehousing. We want to see how your skills align with what we’re looking for, so don’t be shy about showcasing relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to tell us why you’re the perfect fit for our team. Share your passion for data engineering and how you can contribute to our integration programme. Keep it engaging and personal!
Showcase Your Problem-Solving Skills:In your application, give examples of how you've tackled challenges in previous roles. We love seeing how you approach data quality issues or performance optimisation, so let us know your thought process!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Raymond James UK
✨Know Your Tech Inside Out
Make sure you brush up on your SSIS, T-SQL, and data engineering practices. Be ready to discuss specific projects where you've used these skills, as well as any challenges you faced and how you overcame them.
✨Showcase Your Collaboration Skills
Since this role involves working closely with analysts and stakeholders, prepare examples of how you've successfully collaborated in the past. Highlight your communication style and how you ensure everyone is on the same page during projects.
✨Prepare for Problem-Solving Questions
Expect questions that test your analytical and problem-solving abilities. Think of scenarios where you had to troubleshoot data quality issues or optimise ETL processes, and be ready to walk through your thought process.
✨Emphasise Your Attention to Detail
Data quality is crucial in this role, so be prepared to discuss how you ensure accuracy in your work. Share specific examples of how you've maintained high standards in documentation and testing in previous positions.
