St. James's Place
Senior Data Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills