Data Engineer

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

We look for people to join SJP to make animpact and to contribute to our culture which is based around long termrelationships, 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 ( Snowflake) Building automated processes for data transfers from financial analytics systems ( FactSet) to databases( 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 indifferent ways, at different times and in different environments. We haveintroduced a hybrid working policy to provide greater flexibility for part-timework, job-sharing, remote working, and flexibility on hours. Our people areencouraged to work in a flexible way that suits their lifestyle, so please askthe question and start a conversation!

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

Reasonable Adjustments
We're anequal opportunities employer and want to ensure our recruitment process isaccessible and inclusive for all, if you require reasonable adjustment(s) atany stage please let us know by emailing us at