Data Engineer

Cambridge Science Park; Cambridge; Hybrid; GBP 40,000 - 80,000; Full time

Job description

Overview

We're seeking a skilled Data Engineer to join our dynamic team. As a Data Engineer you will be responsible for developing and maintaining the Royal Society of Chemistry (RSC) data warehouse. The role is highly technical and hands-on and involves running projects to ensure that data is consolidated, standardised and accessible in a manner that is useful to the business. You will play a key role in data management, consolidation and analytics delivery across the RSC, ensuring a better use of data as an asset and a joined-up, shared view of customers, products and services.

You will collaborate with stakeholders across the business to identify requirements and implement effective data solutions. You will analyse data from various sources, build ETL processes, and ensure data quality and accessibility while maintaining security and compliance standards. Your expertise will help create a unified view of our customers, products, and markets that drives business intelligence and strategic initiatives.

Working in an Agile environment, you'll lead the data engineering aspects of cross-functional projects, provide best practices guidance to end users, and contribute to our data governance framework.

At the RSC, we embrace flexibility and offer hybrid working, which means our teams come together when they need to collaborate. Although this role is contractually based at our Cambridge office, you will be able to work from home within the UK, with the expectation that you will attend the office as needed for your role. In this role it is expected that you will attend the office approximately one day per quarter or when in-person is necessary. If you need flexible working arrangements, please outline this in your application.

What we are looking for:

• Educated to degree level or equivalent level of knowledge in a STEM subject area.
• Substantial data warehousing experience, including familiarity with data related AWS technologies (e.g. Redshift).
• Strong programming skills and substantial experience designing and building data pipelines (e.g. Python, SQL, Airflow).
• Experience in data standardisation and QA techniques.
• Experience working with data observability tools.
• Experience integrating data with visualisation and business intelligence tools (e.g. Power BI) and creating a single customer view (e.g. consolidating and surfacing CRM/CDP data).
• Experience with version control systems for managing code (e.g. Git).
• Experience working in cross-functional teams, with an Agile approach, taking ownership and leadership of Data Engineer capability.
• Familiar with AWS services, IAC (e.g. Terraform).
• Able to confidently work within a team and independently and clearly communicate technical concepts to both a technical and a non-technical audience.

A full job description is available here.

If you are interested in this role, please apply before the end of the closing date. When applying, you will need to provide an up-to-date CV and a cover letter (in no more than 500 words) telling us about your relevant knowledge, skills and competencies and why you are applying for this role.

About the RSC

The Royal Society of Chemistry (RSC) is working to create a future that is more open, more green, and more equal. Chemistry is at the heart of the changes that society needs, better healthcare, environmental protection, clean energy, and secure food and water for everyone.

We enable exciting progress that would otherwise be impossible; connecting people and ideas through partnerships, conferences, events, and networks that span the globe. We make sure chemical scientists are educated, trained, and recognised for their roles in building the future, and that scientific careers are welcoming and supportive to all. We publish scientists’ discoveries and insights so they can be used to improve our health, environment, and lifestyles. And we are transforming how we share that work: creating a future where everyone, everywhere has the same potential to access and share their latest advancements.

Visit our Work For Us website to learn more about us, our benefits, equal opportunities statement and inclusive culture pledge.

At the RSC, we recognise the benefits of a diverse workforce and welcome applicants from a range of backgrounds to apply. We particularly encourage applications from disabled and ethnic minority candidates.

As a part of the Disability Confident Scheme, we endeavour, where possible, to offer an interview to candidates meeting the essential criteria of the role, who have a substantial physical/mental impairment which impacts their ability to carry out day-to-day tasks.

We are committed to making our recruitment processes accessible to all and as part of this, we are flexible in the ways we give and receive information. If you would like to apply using a different format, please contact the Recruitment Team at [e-mail] or on [phone] and we will do our best to put any reasonable adjustments in place.