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:

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. tying connected 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 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.