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: 12 month Fixed-Term Contract
Seniority: Mid-Senior Level
About the role: Reporting to a Data Platform Product Owner in the Data Architecture, Platform & Engineer division of the Data & Insights (D&I) team, the role holder will be responsible for designing, implementing scalable data pipelines and systems allowing large datasets to be managed, processed and analysed effectively. They will ensure that data flows are optimised, data quality measurement is enabled, and appropriate technologies utilised. Throughout development, they will ensure best practice standards are followed, and all work aligns to the appropriate guidelines. They will ensure testing is carried out appropriately and assist the Data Platform team with enabling the implementation of principles and maintenance/improvements. What you'll be doing: The role holder will mainly be supporting on the Data platform however other systems may also require support. Developing with the decommissioning roadmap in mind is crucial along with ensuring we are working to the over-arching data strategy. You will work hands-on with the modern data stack to design, build, and optimise scalable data solutions. Using your expertise in Python for data engineering and analysis, you will develop robust data pipelines, applying a range of techniques and patterns to ensure efficient and reliable data delivery. You will model and visualise data using a variety of tools to generate actionable insights, while leveraging systems of record such as Salesforce to integrate and maintain high-quality datasets. In addition, you will design, manage, and optimise databases across platforms such as Snowflake, SQL Server, and MySQL, supporting both OLTP and OLAP workloads. Through this, you will ensure data is structured, accessible, and performant, enabling effective analytics and informed decision-making across the business. About you: You will be an experienced data delivery engineer with a passion for data will a strong understanding of end-to-end data lifecycle management, including the complexities of using data effectively to enable meaningful analytics. You will grasp how data moves from ingestion through transformation, storage, and consumption, and recognise the challenges involved at each stage. You will have experience of how modern Data Teams operate, particularly how they design, build, and deliver Data Products using software engineering principles—ensuring scalability, reliability, and value delivery to end users. Essential Criteria: Proven experience in data engineering and integration roles. Desirable Criteria: Bachelor's or Master’s degree in Computer Science, Data Engineering, or a related field
Expert in SQL and data querying, alongside version control systems e.g. Git.
Experience with cloud platforms e.g. AWS, Azure.
Strong knowledge of data warehousing solutions e.g. Snowflake, Redshift.
Experience building ETL processes and knowledge of data modelling and warehousing patterns.
Experience with data integration tools: Talend, MuleSoft, Matillion, SSIS
Wealth Management experience
What's in it for you?
We reward you
for the work you do,
whether that’s through our discretionary annual bonus scheme that reflects both
personal and company performance, competitive annual leave allowance (28 days
plus bank holidays, with the option to purchase an additional 5 days), or
online rewards platform with a variety of discounts.
We also have
benefits to support whatever stage of life you are in, including:
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.
St. John is a full-service agency headquartered in Jacksonville since 1984. St. John has been home to a quality of work and a quality of life that has helped attract great people and build one of the region’s largest independent agencies. We inspire growth for brands by purposefully applying insights, technology and creativity to create opportunities to be more relevant, more visible and more competitive.
We lead with character, courage, kindness. Three ideals that have defined our company and our pursuit of growth on behalf of our clients from the beginning. We believe that success and great ideas come from hard work, honesty and the courage to try new things. We also believe that to inspire people to take action – be they customers, employees or our community, requires empathy and responsibility to all. It’s a credo that has served us well for 40 years and counting.
