Data Engineer

Circa:Salary - Salary Plan 51400.00 GBP AnnualThe 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 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 andanalytics 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 applyKey responsibilitiesData EngineeringDevelop 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 governanceSupport 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 supportWork 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. desirableFamiliar 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 usThe 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. BenefitsAt 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 annum35-hour working week with flexible options to be agreed with your line managerEnhanced maternity and paternity leavePaid volunteering daysPension 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 Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full-Time Experience: years Vacancy: 1