Job Description

Are you ready to
chart your own career path? With our refreshed strategy, we’re building on our rich heritage and transforming our business to be more scalable and efficient, unlocking the capabilities needed for future success.
This includes significantly investing in technology, streamlining the way we work and creating an environment where colleagues feel engaged, empowered and accountable; where they can show up, speak up and perform - because we believe in the difference our work makes.

At a glance:

Location: Cirencester Office

Workplace Type: Hybrid

Employment Type: 9 month Fixed-Term Contract

Seniority: Mid-Senior Level

About the role:

We're looking for an experienced Data Engineer to join our growing Data team on a 9-month fixed term contract. This role offers an exciting opportunity to contribute to the evolution of our data platform while supporting key business initiatives across multiple value streams.

As part of a matrix-managed Data function, you'll work closely with technical and business stakeholders to deliver data solutions that support operational, analytical and strategic decision-making. A key focus of the role will be supporting our transition from Matillion to a modern Data Engineering framework built on Snowflake, dbt and Apache Airflow.

This is an ideal opportunity for a hands-on Data Engineer who enjoys solving complex data challenges, building scalable solutions and working within a modern cloud-based data environment.

What you'll be doing:

In the role of Senior Data Engineer, you will:

• Designing, developing and maintaining robust data pipelines and data transformation processes.
• Developing SQL-based solutions within our Snowflake data platform.
• Supporting the migration of existing Matillion workflows to dbt and Apache Airflow.
• Building and optimising ELT processes to improve efficiency, scalability and data quality.
• Working with stakeholders to gather requirements and translate business needs into technical solutions.
• Supporting reporting, analytics and data delivery requirements across the organisation.
• Troubleshooting data issues and identifying opportunities for process improvement.
• Contributing to the ongoing development of our future-state data architecture and engineering standards.

About you:

You will be an experienced Data Engineer with a strong track record of designing, building and optimising data solutions within complex enterprise environments. Bringing proven expertise across data engineering best practices, you'll be confident working with large-scale datasets, developing robust data pipelines and delivering high-quality data products that support business outcomes.

Essential Criteria:

• Proven experience in a Data Engineer, Data Engineering Analyst or similar role.
• Strong SQL development skills and experience working with relational databases.
• Experience with Snowflake, Oracle, SQL Server or similar enterprise database technologies.
• Experience designing, developing and supporting ETL/ELT data pipelines.
• Hands-on experience with dbt and/or Apache Airflow
• Strong understanding of data warehousing concepts and best practices.
• Experience working within cloud-based data environments.
• Excellent problem-solving skills and ability to work independently.
• Strong communication skills with the ability to engage technical and non-technical stakeholders.

Desirable Criteria:

• Experience migrating data solutions from legacy ETL tools into modern cloud platforms.
• Knowledge of Matillion
• Experience working with Amazon S3 and cloud-based data ecosystems.
• Financial Services, Wealth Management or Investment Management experience.
• Knowledge of investment products and financial data domains.
• Experience working within Agile delivery teams.
• Exposure to modern DataOps, CI/CD or data platform transformation initiatives.

What's in it for you?

Whatever stage of life you're in, our benefits are designed to provide the support, flexibility, and peace of mind you need to thrive both at work and beyond.

In addition to our discretionary annual bonus scheme, which reflects both individual and company performance, you'll benefit from a market-leading benefits package tailored to support your wellbeing, financial security, and family life.

Our benefits include:

• 28 days' annual leave plus bank holidays, with the option to purchase up to 5 additional days

• Private Medical Insurance – company-funded cover for you and your immediate family
• Generous Pension Scheme – a non-contributory employer contribution of 10%, increasing with length of service up to 15%, plus the opportunity to increase this through salary sacrifice
• Enhanced Parental Leave – up to 26 weeks' full pay to support growing families.
• Protection Benefits – company-funded critical illness cover, income protection, and life assurance
• EV salary sacrifice scheme through Tusker

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 careers@sjp.co.uk
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.

What's next?

If you're excited
about this role and believe you have the skills and experience we're looking
for, we'd love to hear from you! Please submit an application by clicking
‘apply’ below and 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.