Change text size:

Choose Style:

Financial Data SQL Developer

  • Financial Services
  • 23/05/2024
  • Fixed Term Contract

Job Overview

Job Type

Fixed Term Contract

Salary

Date Posted:

23/05/2024

Expiration date:

14/08/2024

Additional Detail

Job ID

7511

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: Cirencester Office

Workplace Type: Hybrid

Employment Type: 12 month Fixed-Term Contract 

Seniority: Associate

This person will support on a key externally focussed business project for SJP and will require a minimum of 12 months’ previous SQL experience to succeed in the role. They will be heavily involved in the development of code to support business project reporting requirements, the migration of SQL code from MS SQL Server to Snowflake, and the redesign of existing code to support data structure changes. They will also investigate erroneous results and interpret the impact back clearly to the business. This role requires a capable and self-motivated individual who is good at problem solving and confident about their ability to extract data from technical data sets.

What you’ll be doing:

  • 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.

Who we’re looking for:

  • 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.
  • Experience in documentation of code changes.
  • Good computer skills including Excel and Power BI. Other relevant computing systems advantageous.
  • Knowledge of finance concepts beneficial.
  • Understanding of the SJP product range and how they operate.
  • Understanding of the data systems used within the SJP business.
  • Able to manage multiple stakeholders with diverse range of expectations.
  • Strong data analysis skills, particularly in relation to very large datasets.
  • Approaches work positively with a can-do attitude and builds trust through efficient and reliable contact with others.

What's in it for you?

  • 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

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.

REPORT JOB

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.