As a Data Engineer 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. 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 be involved in building and maintaining a secure, cloud data infrastructure to support the RSCs needs.
We are looking for someone who has an experience in setting up a data warehouse and who enjoys communicating with the stakeholders.
We are looking for someone with:
Substantial data warehousing experience. Including familiarity with data related AWS technologies (e.g. Redshift and documentDB), pipelining (e.g. AWS Lambda and AWS Glue) and associated core technologies (e.g. SNS/SQS).
Strong programming skills and substantial experience designing and building data pipelines (e.g. Python).
Experience in data standardisation and QA techniques.
Familiarity with developing data interrogation and visualisation tools such as a single customer view (e.g. consolidating data from multiple CRMs) and analytics (e.g. PowerBI)
Able to confidently work within a team and independently and clearly communicate technical concepts to both a technical and a non-technical audience.
The Royal Society of Chemistry is a not-for-profit organisation whose mission is to advance chemical sciences. We are a provider of knowledge, a professional body and a voice for chemical sciences, with a heritage that spans 179 years. We work with industry and academia to promote collaboration and innovation. We advise governments on policy, and we promote the talent, information and ideas that lead to great advances in science.
The Royal Society of Chemistry offers excellent benefits. The contractual base for this role is Cambridge, however we are currently embracing hybrid working, and therefore you will have the opportunity to work from a location other than this, as agreed with your line manager. Applicants should be aware that there is an expectation that employees will attend the offices as needed for their role.
Salary: 52,191 – 63,789
Position Type: Permanent, Full-Time
Ref: 133 915