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
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.
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.
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.
- 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.
- 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 [email protected]
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.
