Job description

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

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.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs
Encora Inc.
July 13, 2024

Data Engineer

Ford Motor Company
July 13, 2024

Data Engineer

Ignition Group
July 13, 2024

Senior Data Engineer