Data Engineer

Data Engineer – Python / SQL / data integration / AWS S3 / English

Project: For our customer, a big pharmaceutical company in Basel, we are looking for a highly qualified Data Engineer (m/f/d).

Background: In Roche’s Pharmaceutical Research and Early Development organization (pRED), we make transformative medicines for patients in order to tackle some of the world’s toughest unmet healthcare needs. At pRED, we are united by our mission to transform science into medicines. Together, we create a culture defined by curiosity, responsibility, and humility, where our talented people are empowered and inspired to bring forward extraordinary life-changing innovation at speed. This position is located in Data Products & Platforms, a chapter within the Data & Analytics function, which pushes the boundaries of drug discovery and development, enabling pRED to achieve its goals. The mission of our team is to enable pRED & Roche scientists to access and work with research data generated during early lead identification and optimization campaigns. We are looking for a highly motivated Data Engineer focusing on developing and maintaining data workflows to join our team.

The perfect candidate: The perfect candidate has 4 years of experience in data and workflow engineering. Additionally, the person is experienced in data integration using warehouses, data lakes, and database modeling. Experience with Python and SQL is required. Lastly, the candidate communicates fluently in English.

Tasks & Responsibilities:
* Developing a robust lightweight framework for creating data products based on an existing prototype that extracts data from multiple sources and creates data visualizations as the output
* Creating automated extraction and loading processes from key databases
* Creating easy-to-maintain transformations using DBT
* Enabling a data storage solution and consumption by users via API or GUI
* Developing, maintaining, and documenting a solid codebase that we can turn into a self-service framework

Must Haves:
* Min. vocational training
* 3-6 years of experience in data and workflow engineering skills (ETL/ELT principles)
* Experience with data integration using warehouses, data lakes, and database modeling (Snowflake, Postgres, etc.)
* Experience with Python for data extraction scripts
* Experience with SQL for data extraction from internal databases
* Experience with PostgreSQL for persistence of final product data, AWS S3 as a staging layer, Gitlab for CI, task and code tracking
* A passion for working in an environment with high urgency, and you love to spend most of your time writing code
* Enjoying the operational side of things, like managing cloud-based infrastructure, workflow orchestration (e.g., GitLab CI/CD), and containerization (e.g., Docker)
* Interest in understanding biomedical or preclinical research data or have previously worked in a Pharma domain
* Excellent communication skills in English

Nice to have:
* DBT for data transformations

Reference Nr.: 923523TP
Role: Data Engineer (m/f/d)
Industrie: Pharma
Workplace: Basel
Pensum: 100%

Job Type: Contract

Work Location: On the road

#J-18808-Ljbffr