Data Engineer

Are you ready tochart 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.

• 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.

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.

• 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.
• Some stakeholder management and relationship building skills
• Bachelor's degree or equivalent in Data Science, Computer Science, Mathematics or similar STEM subject.

• Some business travel may be necessary

What's in it for you?

We reward youfor the work you do, whether that’s through our discretionary annual bonus scheme that reflects bothpersonal and company performance, competitive annual leave allowance (28 daysplus bank holidays, with the option to purchase an…