Support the development of new SQL code in Snowflake to support business reporting requirements related principally to financial data.

Migration of code from Microsoft SQL Server to Snowflake, including adopting new data structure.

Produce high quality documentation and test evidence to support change management governance requirements.

Assist with the investigation of unexpected financial results through in-depth data analysis.

Support the development of financial based processes/insights through data analysis and query development.

Ensure proper operation of controls to safeguard the accuracy of financial outputs produced by the financial data team and compliance with relevant legislation, regulations and professional standards.

Other data related activities as required., Non-Contributory Pension - 10% (increasing with length of service up to 15%) with further pension matching.

28 days holiday entitlement plus bank holidays (based on full-time equivalent) with the option to buy up to an additional 5 days holiday

Capable in programming languages of SQL in particular. Other programming languages (e.g., Python, R etc.) may be beneficial.

Strong understanding of relational and non-relational databases, data warehousing concepts, and data modelling techniques.

Good computer skills including Excel and Power BI. Other relevant computing systems advantageous.

Approaches work positively with a can-do attitude and builds trust through efficient and reliable contact with others.

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.