At a glance
Location: Cirencester Office
Workplace Type: Hybrid
Employment Type: Permanent
Seniority: Associate
The Data and Insights Division is comprised of four key areas: 1. Data Governance and Intelligence 2. Data Acquisition, Quality, Strategy and Literacy; 3. Data Insights; 4. Data Architecture, Platform and Engineering. This presents an opportunity to design a data strategy aligned with the organization’s goals and execute the delivery of data effectively. D&I enables SJP to leverage value from its data through actionable insights and data‑led decision making.
The Data Architecture, Platform and Engineering (DAPE) Division integrates architecture, platform and engineering to establish guidelines, principles and development standards aimed at building a secure, resilient data platform for the future. It plays a key role in supporting the SJP data ecosystem, driving towards the SJP data strategy and advancing the decommissioning roadmap.
The role holder will be responsible for assisting Senior Data Engineers in designing, implementing and maintaining scalable data pipelines and systems allowing large datasets to be managed, processed and analysed effectively. They will understand that data flows need to be optimised, data quality measured, and appropriate technologies utilised. Throughout the development lifecycle they will ensure best practice standards are followed, and all work aligns to the appropriate guidelines.
What you’ll be doing
* Helping design and implement scalable and efficient data pipelines as per requirements, ensuring robust ETL/ELT processes, enabling SJP to move from multiple sources to a centralised platform.
* Assisting in writing and optimising SQL queries and scripts to process data.
* Supporting the integration of data from different systems, ensuring that it is structured correctly for analysis.
* Maintaining data workflows and ensuring data is ingested and processed without errors and assisting in updating and maintaining existing data systems to help keep them current and efficient.
* Keeping up to date with the latest data engineering technologies and trends, including cloud‑based data platforms, data lakes, and real‑time data processing.
* Continuously improving technical skills by learning new data engineering tools and techniques.
* Help monitor data pipelines to ensure they are running smoothly and troubleshoot minor issues as they arise.
* Help with identifying and resolving data issues, including missing or inconsistent data.
Who we’re looking for
We are looking for a passionate data professional who is keen to learn and develop their skills and learn from those around them. The successful candidate will have experience working in data engineering and/or data integration roles and will have exposure working with data tools including Snowflake, SQL, AWS and/or Azure.
Essential Criteria
* Experience working in a data engineering and/or data integration role
* Some knowledge and skills with data tools and technologies including Snowflake, SQL, AWS and/or Azure
* Exposure working alongside PMS, BAs, Testers, Developers and to project lifecycle best practice.
* Some skills in root cause analysis, troubleshooting and resolving performance issues/defects.
Desirable Criteria
* Strong Snowflake development experience
* Some stakeholder management and relationship building skills
* Bachelor's degree or equivalent in Data Science, Computer Science, Mathematics or similar STEM subject.
Special Requirements
* Some business travel may be necessary
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:
* Competitive parental leave (26 weeks full pay)
* Private medical insurance (optional taxable benefit)
* 10% non‑contributory pension (increasing with length of service)
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 under‑represented 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.
#J-18808-Ljbffr