Change text size:

Choose Style:

Data Engineer

  • Financial Services
  • London
  • 14/05/2024
  • Permanent

Job Overview



Job Type



Date Posted:


Expiration date:


Additional Detail

Job ID


Work Location

Remote and/or Onsite

Job Description

If the link to apply for no longer works this may be because the job opportunity has closed early. We occasionally close vacancies early due to high volumes of applications. We would therefore recommend you complete your application prior to the closing date which is for guidance only.

St. James's Place (SJP) works in partnership to plan, grow and protect our clients’ financial futures. We deliver personalised, face-to-face financial advice to our clients, who trust us to manage their money to reach their goals. We provide this service via the Partnership, a network of qualified, expert advisors. We put financial wellbeing and responsible business choices at the heart of everything we do. We believe in the value of difference and know that diverse teams can help us problem solve and innovate for clients.

We look for people to join SJP to make an impact and to contribute to our culture which is based around long term relationships, doing the right thing, and being the best version of ourselves.

Location: London - Paddington

Workplace Type: Hybrid

Employment Type: Permanent 

Seniority: Mid-Senior Level

We are seeking an experienced Data Engineer to join the Investment Management Division at St James’s Place. Our approach to investment decision making and manager selection is differentiated from many of our peers. We place significant emphasis on evidenced based insights relating to manager and strategy behaviour, rather than historical performance or industry standard reporting metrics.

This is a key role within the SJP Equities team, with responsibility to ensure that we have the necessary data in place to support our approach. It will require the development of robust and structured processes as well as creative problem solving and innovation in the development of those capabilities.

If you are a data driven professional with a passion for investment management, we would love to hear from you.

What you’ll be doing?

  • Working as a part of the Equities data and Analytics team in creating Robust ETL processes for data collection from internal and third party sources with audit and config.
  • Building automated processes for data cleansing / manipulation
  • Data storage & mapping in databases (e.g. Snowflake)
  • Building automated processes for data transfers from financial analytics systems (e.g. FactSet) to databases(e.g Snowflake) and vice versa.
  • Systems infrastructure management and Access controls.


Who are we looking for?

  • Practical knowledge of SQL and Python, capable of using complex joins & functions to transform data to suit end user needs in Snowflake data platform.
  • Familiarity with Snowflake, Matillion, Azure DevOps, Microsoft Fabric, Visual Studio Code.
  • Exposure to Power BI and/or Tableau or equivalent reporting tool.
  • Development Experience using Excel VBA Macros and power query to manage and maintain existing tools built using Excel.
  • Ability to seek improvements & efficiencies above and beyond suggestions from the team, calling on previous experience and industry best practice.


What's in it for you?

  • Private Medical paid for by Company.
  • Meaningful protection benefits with real value, such as 10X life cover, PHI, and critical illness.*
  • Non-Contributory Pension – 10% (increasing with length of service up to 15%) with further pension matching.
  • Parental leave – 6 months full pay.
  • 28 days holiday entitlement plus bank holidays (based on full-time equivalent) with the option to buy up to an additional 5 days holiday.

*Not applicable to Fixed-Term Contracts (standard uplift applies in lieu of the protection benefits).

Flexible Working

We know that everyone works best in different ways, at different times and in different environments. We have introduced a hybrid working policy to provide greater flexibility for part-time work, job-sharing, remote working, and flexibility on hours. Our people are encouraged to work in a flexible way that suits their lifestyle, so please ask the question and start a conversation!

Research tells us that applicants (especially those from underrepresented groups) can be put off from applying for a role if they do not meet all the criteria or have been on an extended career-break. If you think you would be a good match for this role and can demonstrate some transferable experience please apply, regardless of whether you tick every box.

Reasonable Adjustments

We're an equal opportunities employer and want to ensure our recruitment process is accessible and inclusive for all, if you require reasonable adjustment(s) at any stage please let us know by emailing us at [email protected]

What's next?

Our team will be in touch. As a business regulated by the FCA we would advise you to familiarise yourself with the conduct regulations and in particular consumer duty obligations prior to an interview with SJP.



Our use of cookies

We use necessary cookies to help our site function. We’d also like to use analytics cookies that help us make improvements by measuring how you use our website.

For more detailed information about the cookies we use, see our Cookies page.

Necessary cookies

Necessary cookies enable core website functionality such as network management, security and accessibility. You may disable these by changing your browser settings, but this may impact how the website functions.

Analytics cookies


We’d like to collect website analytics cookies information using Google Analytics to help us improve our website. We collect this data by running Google Analytics JavaScript on your device, which collects data about how you interact with our site. The data is collected in a way that does not directly identify anyone. For more information please see our Cookies page.