Senior Data Engineer - Hybrid & Data Warehouse

Royal Society of Chemistry; Cambridge; Hybrid; GBP 46,000 - 52,000; Full time

Benefits offered by this job

Benefits package

Job summary

The Royal Society of Chemistry is seeking an experienced Data Engineer to join our Data team in Cambridge. This hands-on role focuses on developing and maintaining a data warehouse, building robust pipelines, and standardising data from multiple sources to enable better decision-making across the organisation.

You will own the data engineering lifecycle, from ingestion to modelling, quality assurance and delivery, using Python, SQL, Airflow and modern data warehousing practices.

Qualifications

• Extensive experience in end-to-end data engineering, including AWS (Redshift).
• Strong programming skills; proven data pipeline design with Python, SQL, Airflow.
• Experience in data standardisation and QA techniques.
• Experience with data observability tools.
• Experience integrating data with BI tools (Power BI) for a single customer view.
• Experience with Git version control.

Responsibilities

• Develop relationships with stakeholders to identify requirements and deploy analytics solutions.
• Analyse data sources, design, test and implement ETL processes.
• Build and maintain data pipelines; orchestrate ETL to central data repository.
• Transform data, monitor quality, apply standards, and join data into unified datasets.
• Create joined-up view of customers, products, markets; enable BI tools and CRM/CDP data.
• Ensure data stored securely in cloud infrastructure; comply with policies.
• Support monitoring and improvements to data quality and documentation.
• Document data assets with catalog, lineage and provenance.
• Provide guidance and training to business users.
• Collaborate with Data team and 3rd parties; deliver data projects.
• Lead Data Engineering aspects of projects.

Skills

Python

SQL

Data modelling

Data QA

Data observability

Git

Tools

AWS Redshift

Airflow

Power BI

Job description

The Royal Society of Chemistry is seeking an experienced Data Engineer to join our Data team in Cambridge. This hands-on role focuses on developing and maintaining a data warehouse, building robust pipelines, and standardising data from multiple sources to enable better decision-making across the organisation.

You will own the data engineering lifecycle, from ingestion to modelling, quality assurance and delivery, using Python, SQL, Airflow and modern data warehousing practices.