Data Engineer

4 weeks ago

London, UK, United Kingdom Raymond James Investment Services Full time

Who we are?

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.


Who we are looking for?

We are seeking a skilled Data Engineer to join our data warehousing team to work on ongoing business initiatives as well as an ongoing company integration project. This role requires extensive experience with SQL Server Integration Services (SSIS) to build and optimise ETL processes, ensuring seamless data ingestion, analysis and integration from various source systems. The role also involves close collaboration with data analysts and participation in testing activities. This is a hybrid role, requiring the candidate to be based in the office 3 days a week.


Responsibilities


Principle Duties:


  • Analysis & Design: Assist the Data Analyst with tasks such as mapping source data to the existing data model and design of database schemas and SSIS packages.
  • ETL Uplift & Data Integration: Using the technical standards provided, uplift and redevelop existing ETL processes to ingest source data from different systems while ensuring seamless integration of data from these systems into the unified data warehouse.
  • T-SQL Programming: Write complex T-SQL scripts for data retrieval, manipulation, and analysis. Optimize existing queries and stored procedures to enhance performance and ensure efficient data processing.
  • Performance Optimisation: Ensure the stability, flexibility, and scalability of the data warehouse. Identify and resolve potential issues, ensuring the system can handle increasing data volumes and user demands.
  • Testing & Validation: Conduct preliminary testing to validate the accuracy and performance of ETL processes and the data warehouse. Assist in identifying and resolving any data quality, transformation or integration issues.
  • Documentation: Maintain comprehensive documentation of ETL processes, data mappings, and other technical aspects of the data warehousing initiative. Help develop and document functional, technical requirements and evidence of testing.
  • Collaboration & Communication: Work closely with the development team, data analysts, subject matter experts and business stakeholders to ensure the successful execution of the data warehousing initiative.


Requirements


Qualifications and Experience:


Required:

  • Minimum 3 years practical experience working in operational data teams.
  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  • Proven experience in designing, developing and implementing data warehousing solutions with a focus on data integration and ETL development.


Preferred:

  • A background in financial services is desirable.
  • Experience in uplifting and modernising data warehouses is a plus.
  • Experience in companies that have undergone mergers or acquisitions with an understanding of the challenges involved in data integration.


Knowledge and Skills:

Required:

  • Extensive experience with SQL Server Integrations Services (SSIS) and Microsoft SQL Server development.
  • Extensive knowledge of T-SQL and stored procedure programming on Microsoft SQL Server.
  • Experience in scripting tasks with SSIS (Powershell, C#, Python).
  • Solid understanding of data warehousing concepts, architectures, and best practices.
  • Strong understanding of database architecture, indexing, and query optimization.
  • Strong analytical and problem-solving skills, with the ability to identify and resolve data-related issues.
  • Excellent collaboration and communication skills, with the ability to work effectively with technical and non-technical stakeholders.
  • High attention to detail and a commitment to data accuracy and quality.



Benefits

  • 25-days of annual leave + bank holidays + holiday increases each year, to a max of 30
  • Established hybrid working policy and openness to flexible working
  • Generous pension contributions
  • Private medical healthcare
  • Discounted Gym Membership
  • Life, Dental & Travel insurance




Raymond James is an equal opportunities employer and welcomes applications from a diverse background


At Raymond James we honour, value and respect the uniqueness, experiences, and backgrounds of all our Associates. When associates bring their best authentic self to work, our organisation, clients, and communities thrive. This is a key part of our people-first culture. The Company is an equal opportunities employer and makes all employment decisions on the basis of merit and business needs.

  • Data Engineer

    3 weeks ago

    London,, UK, United Kingdom Higher - AI recruitment Full time

    OVO Group is a leading energy technology company determined to create a world with clean, affordable energy for everyone. Since launching in 2009, they have welcomed over a million members, planted a million trees, and set their sights on helping save the planet. They are on a mission to change energy for the better, including driving progress towards the...

  • Data Engineer

    4 weeks ago

    London,, UK, United Kingdom Higher - AI recruitment Full time

    OVO Group is a leading energy technology company determined to create a world with clean, affordable energy for everyone. Since launching in 2009, they have welcomed over a million members, planted a million trees, and set their sights on helping save the planet. They are on a mission to change energy for the better, including driving progress towards the...

  • Data Engineer

    4 weeks ago

    London,, UK, United Kingdom IWSR Full time

    Data Engineer – Price Data TeamRemuneration: Competitive salary plus bonusLocation: London, SE1, with an established hybrid working policyProducts: The world’s leading data source for the beverage alcohol industryThis is an exciting opportunity for a Data Engineer to work within our Price Data team and collaborate with the Research teams globally. IWSR...

  • Data Engineer

    5 months ago

    London,, UK, United Kingdom Hexegic Full time

    Data Engineers are responsible for aiding UK Health in developing a cleaned, validated, and discoverable data foundation to enable new analytical workflows and applications.They will need to work closely with UK Health subject matter experts to scope new data integrations, design a data model, and perform data cleansing and transformation within the data...

  • Data Engineer

    1 week ago

    London,, UK, United Kingdom DATAHEAD Full time

    Position: Power BI Developer/Data Visualisation expertIndustry: InsuranceLocation: Central LondonSalary: £72KWork Mode: Hybrid (3 days in-office)We are seeking an ambitious Power BI Developer with deep engineering expertise to join a team of engineers and become the go-to person for transforming complex data into insightful dashboards.What You'll...

  • Data Engineer

    1 month ago

    London,, UK, United Kingdom Cingulait Full time

    Robert Walters are exited to be exclusively supporting Cingulait, a business at the forefront of quantitative investing, in their search for Data Engineer to join their team in London. This role offers an exciting opportunity to work with cutting-edge technology designed to navigate through alternative datasets and uncover predictive real-time signals on...

  • Data Engineer

    1 month ago

    London,, UK, United Kingdom Collabera Digital Full time

    We are looking for a Senior Azure Data Engineer to join an existing team building a new strategic big data platform for our client.Minimum 5 years of experience with Azure Data Factory, Databricks, Data Mesh.The new platform will be an Azure based data lake with APIs and events to allow consumption of data by analytics teams and will replace the existing...

  • Data Engineer

    1 month ago

    London, UK, United Kingdom Deutsche Bank Full time

    Job Description: Job Title Data Engineer Location London Corporate Title Vice President Our Compliance Technology teams are responsible for delivering solutions which will automate business workflows, improve data quality, and enhance reporting for the Compliance function. You'll be an integral part of the bank's technology infrastructure,...

  • Data Engineer

    1 month ago

    London,, UK, United Kingdom The IN Group Full time

    Role: Senior Data EngineerLocation: London (2x per week onsite)Calling all data engineers with experience in Apache Spark, Scala and ideally commercial and enterprise applications!We are currently supporting a leading SaaS provider, based in London, who are on an exciting journey of transformational growth. As a business, they are a product focused company,...

  • Data Engineer

    3 weeks ago

    London,, UK, United Kingdom Arcus Search Full time

    Arcus Search are proud to support a global Insurance Broker, on searching for an experienced autonomous and proactive Data Engineer with extensive Azure Data Factory (ADF), Data Lakehouse and DataBricks experience.This is a pivotal role in developing and enhancing key data platforms, continually enhancing these. This will be achieved through collaborating...

  • Lead Data Engineer

    3 days ago

    London,, UK, United Kingdom Mastek Full time

    Lead Data EngineerPermanent OpportunityLocation: London, UK – 2 days travel to officeOverview: We are seeking a highly skilled Lead Data Engineer to join our team for a critical project with NHS England. The project involves migrating Privacy Enhancement Technology (PET) from the existing Privitar system to IQVIA across multiple data platforms. The ideal...

  • Data Engineer

    1 month ago

    London,, UK, United Kingdom Singular Recruitment Full time

    Data Engineer (one day a week in the central London office) Sports AnalyticsThis role is a unique opportunity to combine technical challenges with creativity in a collaborative, high-standard work environment. By joining this team, you’ll not only be part of a creative and open work culture focused on innovation and excellence but also have the chance to...

  • Azure Data Engineer

    4 weeks ago

    London,, UK, United Kingdom Formula Recruitment Full time

    Azure Data EngineerSalary: up to £65,000Technology: Azure Synapse, Spark, Microsoft Fabric, Azure Data Factory and PowerBILocation: Hybrid - 1 day a month in the London office.I am partnered with a leading Microsoft Consultancy who are seeking an Azure Data Engineer to join their expanding team. You will be key in the design and optimisation of their data...

  • Head of Data Engineering

    3 days ago

    London,, UK, United Kingdom Harnham Full time

    Head of Data EngineeringLocation: 3 days a week in Central LondonSalary: Up to £110,000Overview:Our client is seeking a Head of Data Engineering to lead their data engineering team and shape the organization’s data infrastructure. You will design and implement scalable data architecture, drive data governance, and ensure seamless data integration....

  • Senior Data Engineer

    4 weeks ago

    London,, UK, United Kingdom Found By Few Full time

    Senior Data Engineer – 6 months - £650-£850 per day (outside IR35) - London Contract Senior Data Engineer required to join a leading AI Research and Product Development Lab backed by highly successful Asset Management firm.This role will suit a Data Engineer who has exceptional ETL/Data Pipeline building experience and is motivated by working with...

  • Senior Data Engineer

    2 months ago

    London,, UK, United Kingdom numi Full time

    Join a Deep Tech AI company with FAANG Leaders - Senior Data Engineer - Up to £100,000 Welcome to a world where data drives enterprise transformation with precision and innovation.Are you ready to join a cutting-edge company that's revolutionizing decision-making with its advanced AI platform?With their AI-driven solutions, they empower businesses to...

  • Building Management Systems Engineer

    4 weeks ago

    London,, UK, United Kingdom BladeRoom Data Centres Full time

    BMS EngineerLocation: West London / M4 Corridor Region (with occasional travel to other sites)BladeRoom Data Centres is seeking an experienced BMS Engineer to join our team, providing expert planned preventative maintenance (PPM), call-out services, and exceptional customer support for our clients based in the West London and M4 Corridor region. This...

  • Senior Data Engineer

    2 months ago

    London,, UK, United Kingdom Peaple Talent Full time

    Senior Data Engineer | Fully Remote | up to £60,000Peaple Talent have partnered with a leading provider of land and property search information, who provide a range of services across digital mapping, environmental risk reports and sophisticated property management tools.Due to exciting growth plans in the Data team we are now seeking a selection of Senior...

  • Senior Data Engineer

    3 weeks ago

    London,, UK, United Kingdom In Technology Group Full time

    Role: Data Engineering Manager Salary: up to £90,000 DOELocation: London, Hybrid 3 days a week onsiteReady to utilize your engineering management experience? Are you passionate about building scalable data infrastructure?Join us as a Data Engineering Manager!They are a purpose-led transformation company, built on belief. We do not just help businesses to...

  • Lead Data Engineer

    3 days ago

    London,, UK, United Kingdom Understanding Recruitment Full time

    Data Engineer | West London (Hybrid Working)First 3 months Full Time then 2/3x per week there on in officeUp to £100,000 per annum doeI am looking for a Lead Data Engineer to join a cutting-edge tech team that are revolutionising the real estate industry through cloud tech!You will be joining an innovative and collaborative team based in Chiswick (West...