Data Engineer
On behalf of our Pharmaceutical client based in Basel we are looking for a highly motivated Data Engineer focusing on developing and maintaining data workflow.
The mission of team is to enablethe companies scientists to access and work with research data generated during early lead identification and optimization campaigns.
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.
General Information:
* Start date: 15.08.2024
* latest Start Date: 01.11.2024
* Planned duration: 6 months
* Extension: possible
* Workplace: Basel
* Workload: 100%
* Remote/Home Office: partially remote, partially in Basel
Tasks & 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
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 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
Kindly send us your CV today through the link in the advert. However, should you have any questions please contact Elaine Kanwar at +41 61 282 22 23