Business Intelligence Expert for Chemistry Solutions (m/f/d)

LexisNexis Risk Solutions; Frankfurt; Hybrid; EUR 62,000 - 104,000; Full time

Benefits offered by this job

Corporate benefits program

Flexible working times

Job summary

RELX’s Reaxys team in Frankfurt is seeking a skilled Data Engineer/BI expert to manage large data structures, optimize databases, and ensure fast access for scientists and researchers across global projects.

You will contribute to an agile team, collaborating with developers, product owners, and stakeholders, and bring strong PostgreSQL/Oracle, scripting, and AWS experience to the role.

Qualifications

• 5 years of experience as a Data Engineer or BI Expert.
• Strong experience with relational databases, e.g. PostgreSQL or Oracle.
• Bachelor's degree in computer science or life sciences with IT background.

Responsibilities

• Understand, design and maintain different data structures and the corresponding data, and optimize data storages, data structures, schemas, views, procedures, etc.
• Transform the data structures for different representations and implementations.
• Optimize databases, indexes, views, and queries; implement extensions and stored procedures for fast retrieval.
• Be an active member of an agile team, contributing to ceremonies and team decisions.
• Work closely with developers, product owners, and stakeholders to ensure timely deliveries.

Skills

Data engineering

Business intelligence

Relational databases

Bash

Perl

Python

Git

English fluency

AI development

Education

Bachelor's degree in CS or life sciences with IT background

Tools

AWS

C/C++

Linux

Jenkins

JIRA

Confluence

Job description

About Reaxys

Reaxys is a comprehensive and powerful cloud hosted and deep-tech data searching tool that is used by thousands of chemists, researchers, and students throughout the world to retrieve chemistry patents, chemical reactions, substance data, and other related chemistry information using a highly performant, bespoke, search engine. Supported by continuous updates and robust taxonomies, Reaxys can be searched using natural language, drawn chemical structures, formula, physical property parameters and more. Trusted for over 30 years by large pharma, innovative startups, large tech, private and public sector research hubs and universities alike, Reaxys is a partner to the pharma, medicinal chemistry, and chemical industries.

About the Role

You are experienced in handling large amounts of data, managing underlying data structures and databases, and making this data accessible to various stake holders for high demand use cases? Do you desire to work in a practical domain? Do you want to support scientists, researchers, students and more by making relevant data accessible to them?

About the Team

The Reaxys team is searching for a self-driven and motivated data enthusiast with a passion for managing multiple constantly evolving data structures, performance optimization of underlying databases and data storages, and making the data accessible to various stake holders in a highly performant way. The focus is on taking a holistic perspective on our chemistry data to provide an (almost) real-time experience to our customers, even for complex use cases on continuously growing large datasets. You will be part of an agile development team supporting and continuously improving the storage, organization, management and access of our chemical data to fulfil our customer’s needs, from databases, data structures, schemas, and views to sophisticated technologies to make all of this accessible and utilizable. You will be able to contribute and expand your expertise and skills in a variety of career paths at Elsevier. Our diverse team stretches across China, India, Europe, the UK and the US and relying on a well-developed network of industry leaders, partners, and suppliers. The Reaxys team has flexible working opportunities since 2014 and this position is based in Frankfurt, Germany where you will be working with our teams in Bengaluru, India, and Amsterdam, Netherlands. In Germany, we offer trust-based working times, work from anywhere opportunities, above average number of holidays, a corporate benefits program, and more. Our teams consist of experienced professionals from diverse backgrounds. Our support for inclusion and diversity is part of our core company principles and our public company branding, and lived by our employees and various employee resource groups every day.

Your Responsibilities

• Understand, design and maintain different data structures and the corresponding data, and constantly optimize and adapt the data storages, data structures, schemas, views, procedures, etc. to fulfil customer use cases.
• Transform the data structures for different representations and implementations.
• Optimize our databases, e.g., indexes, the data structure, views, and queries, and implement extensions, stored procedures for fast result retrieval even for complex use cases.
• Be an active member of the agile team, contributing to ceremonies and team decision making.
• Work closely with developers, product owners, and other stakeholders to ensure timely deliveries.

You should bring

• Expert level experience in Data Engineering or Business Intelligence.
• Strong background in relational databases, preferably PostgreSQL and/or Oracle, and their optimization.
• Minimum medium level scripting experience in Bash, Perl, or Python.
• Experience in version control tools, like Git.
• Experience in AI supported development/working.Fluent English oral and written communication skills.
• The ability and passion to work in a diverse team.

Education & Experience

• Expert (5 years) as a Data Engineer or Business Intelligence Expert.
• Strong experience with relational databases, like PostgreSQL or Oracle.
• A bachelor's degree (master's preferred) in computer science, or life sciences with a strong background in IT.

The following skills will be a bonus

• Basic chemistry or life sciences knowledge.
• Experience or training in AWS.
• Experience or training in C/C++.
• Experience or training in Linux.
• Knowledge of Jenkins, JIRA, and Confluence.

We are an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law.

USA Job Seekers: EEO Know Your Rights.

Primary Location Base Pay Range: Germany - Frankfurt (Baseler Platz) €62,200 - €103,500.

We are committed to providing a fair and accessible hiring process.

We know your well-being and happiness are key to a long and successful career. We are delighted to offer country specific benefits.

RELX is a global provider of information-based analytics and decision tools for professional and business customers, enabling them to make better decisions, get better results and be more productive. Our purpose is to benefit society by developing products that help researchers advance scientific knowledge; doctors and nurses improve the lives of patients; lawyers promote the rule of law and achieve justice and fair results for their clients; businesses and governments prevent fraud; consumers access financial services and get fair prices on insurance; and customers learn about markets and complete transactions. Our purpose guides our actions beyond the products that we develop. It defines us as a company. Every day across RELX our employees are inspired to undertake initiatives that make unique contributions to society and the communities in which we operate.