Data Engineer - Cambridge
Circa:
Salary - Salary Plan, 51,400.00 GBP Annual
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 pipeline, effectively working with a range of stakeholders and have a strong data warehousing experience please apply!
Key responsibilities
Data Engineering
* 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
At the Royal Society of Chemistry, we promote a healthy work/life balance and flexible working options across the organisation. We offer a comprehensive benefits package to all employees including:
* 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)
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 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 or on +44 (0) and we will do our best to put any reasonable adjustments in place.
If you have any questions, please contact us at