Data Engineer

Data Engineer

Temporary 30800 - 38400 £ / year (est.) Hybrid
R

At a Glance

  • Tasks: Develop and maintain data pipelines, ensuring data is accessible and useful for the business.
  • Company: Join the Royal Society of Chemistry, a not-for-profit advancing chemical sciences.
  • Benefits: Enjoy 26 days holiday, flexible working hours, and enhanced parental leave.
  • Other info: Hybrid working options available, fostering collaboration and flexibility.
  • Why this job: Make a real impact in data management while working with innovative technologies.
  • Qualifications: Strong programming skills and experience in data warehousing and pipeline design.

The predicted salary is between 30800 - 38400 £ per year.

The Royal Society of Chemistry (RSC) has a great opportunity for a Data Engineer on a 7‑month fixed‑term contract, maternity cover with the potential to be extended. In this role you will be responsible for developing and maintaining the 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. In this role 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. If you are passionate about building and maintaining data pipelines, effectively working with a range of stakeholders and have strong data‑warehousing experience please apply!

Key Responsibilities

  • Develop effective working relationships with a broad range of stakeholders to identify user requirements, evaluate and deploy data and analytics solutions.
  • Analyse and evaluate data from a variety of internal and external data sources, design, test and implement ETL processes.
  • Build and maintain data pipelines, orchestrate and schedule ETL from a variety of data sources to a central data repository.
  • Transform data, monitor and improve data quality, apply standards and join data to create unified data sets.
  • Develop and maintain a joined‑up, shared view of customers, products, services, markets and competitors, ensuring this is available to consumers including Business Intelligence tools, CRM/CDP platforms and members of the Data and Analytics function.
  • Ensure data is stored securely in a cloud data infrastructure and complies with relevant policies, regulations and legislation.

Data Management and Governance

  • Support monitoring and improvements to data quality and data documentation.
  • Ensure data assets are documented, data catalogue, lineage and provenance is maintained throughout data architecture.
  • Provide guidance, best practice and training to the wider business and end users.

Project Support

  • Work across the organisation, closely with the Data and Analytics team and 3rd parties, delivering data and analytics projects.
  • Lead Data Engineering aspects of projects.

We Are Looking For

  • 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.
  • Educated to degree level or equivalent level of knowledge in a STEM subject area – desirable.
  • 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.

About Us

The RSC is a not‑for‑profit organisation whose mission is to advance chemical sciences. As a not‑for‑profit publisher, the RSC reinvests surplus funds back into the global scientific community, supporting our purpose to help the chemical science community make the world a better place. The RSC strives to continuously innovate its product and services to adapt to market and customer needs, maintain relevancy and diversify revenues from journals. This requires a market‑led and pragmatic approach to product and service innovation. This role is contractually based at our Cambridge office. However, we embrace flexibility at the RSC and offer hybrid working, which means our teams come together when they need to collaborate and for Team meetings (once a month). Any hybrid working arrangements need to be agreed with your line manager.

Benefits

  • 26 days paid holiday per annum
  • 35‑hour working week with flexible options, to be agreed with your line manager
  • Enhanced maternity and paternity leave
  • Paid volunteering days
  • Pension plan with up to 12% employer contributions (depending upon your contribution)

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 has 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 jobs@rsc.org or on +44 (0) 1223 432229 and we will do our best to put any reasonable adjustments in place. If you have any questions, please contact us at jobs@rsc.org.

Data Engineer employer: ROYAL SOCIETY OF CHEMISTRY

As a Global Clinical Integration Lead, you will thrive in a dynamic and collaborative environment located in London, where innovation meets strategic excellence. The company fosters a culture of flexibility and growth, offering competitive pay and the opportunity to engage with leaders across various functions, ensuring your contributions directly impact high-level business objectives. With a commitment to employee development and a focus on meaningful work, this role provides a unique chance to lead critical integration initiatives while enjoying the benefits of a hybrid work model.

R

Contact Details:

ROYAL SOCIETY OF CHEMISTRY Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Data Engineer

✨Tap into Online Data Science Communities

Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like ROYAL SOCIETY OF CHEMISTRY before they're even advertised!

✨Show Off Your Skills With Projects

Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.

✨Check Out Specialist Job Boards

For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like ROYAL SOCIETY OF CHEMISTRY.

✨Leverage University Resources

If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like ROYAL SOCIETY OF CHEMISTRY.

We think you need these skills to ace Data Engineer

Data Warehousing
AWS Technologies (e.g. Redshift)
Python
SQL
Airflow
Data Standardisation
Quality Assurance Techniques

Some tips for your application 🫡

Highlight Your Data Projects:When applying for a temporary data science role at ROYAL SOCIETY OF CHEMISTRY, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.

Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!

Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to ROYAL SOCIETY OF CHEMISTRY, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.

Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab ROYAL SOCIETY OF CHEMISTRY’s attention and show the tangible impact of your work.

How to prepare for a job interview at ROYAL SOCIETY OF CHEMISTRY

✨Showcase Your Analytical Skills

For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at ROYAL SOCIETY OF CHEMISTRY.

✨Brush Up on Technical Skills

You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.

✨Highlight Your Adaptability

Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at ROYAL SOCIETY OF CHEMISTRY.

✨Prepare a Portfolio of Your Work

Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at ROYAL SOCIETY OF CHEMISTRY.