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

Elsevier; Frankfurt; On-site; EUR 62,000 - 104,000; Full time

Job summary

Elsevier's Reaxys team in Frankfurt, Germany is seeking a Database Specialist to optimize databases hosting large datasets and support fast queries across a multinational team.

You will design and tune data structures, collaborate with developers and product owners, and contribute to agile ceremonies to meet customer needs. A strong background in PostgreSQL or Oracle and experience with large-scale data is essential.

Qualifications

• Expert PostgreSQL or Oracle database experience with focus on performance optimization.
• A bachelor's degree (master's preferred) in computer science, or life sciences with strong DB performance background.

Responsibilities

• Understand, design and maintain data structures and optimize schemas to fulfil customer use cases.
• Transform data structures for different representations and implementations.
• Optimize the database: indexes, data structures, queries; implement extensions and stored procedures.
• Be an active agile team member, contributing to ceremonies and decision making.
• Work closely with developers, product owners and stakeholders for timely deliveries.

Skills

PostgreSQL

Oracle

Database optimization

Bash

Perl

Python

Fluent English

AI development

AWS

Linux

C/C++

Jenkins

JIRA

Confluence

Education

Bachelor's degree in computer science or life sciences with a strong background in database performance optimization

Master's degree preferred

Tools

AWS

Jenkins

JIRA

Confluence

Linux

Job description

Database Specialist for Chemistry Solutions

Location: Frankfurt, Germany

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 an experienced database specialist? 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?

The Reaxys team is searching for a self-driven and enthusiastic relational database specialist with a passion for performance optimization of databases hosting large amounts of data. The focus is on the database, schema, data structure optimization to provide an (almost) real-time experience to our customers, even for complex queries on continuously growing large datasets. You will be part of an agile development team supporting and continuously improving our chemical full text retrieval search to fulfil our customer’s needs. 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.

Education & Experience:

• Expert (5 years) PostgreSQL or Oracle database experience with a strong focus on database, schema, data structure, and query optimization.
• A bachelor's degree (master's preferred) in computer science, or life sciences with a strong background in database performance optimization.

Your Responsibilities:

• Understand, design and maintain different data structures and the corresponding data, and constantly optimize and adapt the data structures and schemas to fulfil customer use cases.
• Transform the data structure for different representations and implementations.
• Optimize the database, e.g., indexes, the data structure, and queries, and implement extensions, stored procedures for fast result retrieval even for complex queries.
• 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 PostgreSQL or Oracle database. Experience in both technologies is a plus.
• Strong background in database optimization.
• Minimum medium level scripting experience in Bash, Perl, or Python.
• Fluent English oral and written communication skills.
• The ability and passion to work in a diverse team.
• Experience in AI supported development/working.

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.

Primary Location Base Pay Range:

Germany - Frankfurt (Baseler Platz) €62,200 - €103,500.

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.