Data Engineer

m/f/d, Basel-Stadt

For our client, a leading company in the Pharma industry, we are currently looking for a Data Engineer experienced in data integration using warehouses, data lakes and database modeling.

General Information:

Start Date: 15.08.2024 (latest start date: 01.11.2024)

End Date: 6 months - extension possible

Workplace: Basel (Remote/Home Office: partially remote, partially in Basel)

Workload: 100%

Tasks and Responsibilities:

Developing a robust light-weight 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

Your Profile:

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 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: