To strengthen our AI / Data team, we are looking for a Data Engineer that will play a key role in supporting us with data modeling, quality, validation, analysis, governance, warehouse and ETL pipelines. The position of Data Engineer is a full-time and permanent position based in our office in the Basel, Switzerland. As part of our commitment to fostering a collaborative team environment, this role requires working fully on-site.
Tasks & Responsibilities
1. Data modelling: design and implement data models that support business requirements and optimise for performance and scalability on large datasets.
2. Data quality and validation: provide support and solutions to develop data quality checks within the pipelines to ensure data is always within its expectations.
3. Data integration: integrate data from all sources within the company and make it equally available for local and remote organisations.
4. Data analysis: develop and maintain insightful reports and dashboards to provide business metrics, trends and performances.
5. Data governance: support ensuring data compliance and harmonisation by developing strong and meaningful collaboration with data governance team policies and regulations.
6. Extract-Transform-Load (ETL) pipelines: create and maintain fast and efficient data pipelines from different relational and non-relational sources - MySQL, Apache Solr, MongoDB, APIs into a centralised data lake and data warehouse, using the Apache Airflow orchestrator.
7. Data Warehouse tuning and optimisation: contribute to the optimisation and performance of the orchestrator and data warehouse to ensure durable environment health and scalability.
8. Cross-functional collaboration: collaborate within an international environment to provide your expertise to data scientists, analysts and business stakeholders.
Requirements
9. Degree in computer science or data engineering certification.
10. Knowledge of Python programming language. Experience with Data frame libraries (Polars, Pandas, Arrow, ...), and database toolkits (SQL Alchemy, ...).
11. Hands-on experience with SQL.
12. Knowledge of data engineering concepts and open-source ecosystem (Airflow, DBT, DuckDB, ...).
13. Experience with relational databases. Knowledge of MySQL and PostgreSQL-specific features is a plus.
14. Knowledge of semantic or hybrid search engines is a plus.
15. Excellent problem-solving, communication, and organizational skills. Desire to learn, explore, discover new concepts and technologies.
16. Proven ability to work independently and within a team.
What we offer
17. The opportunity to contribute to the academic/scientific community;
18. Flexible working hours;
19. Team bond strengthening through team-building events;
20. Professional growth opportunities with our global training system;
21. Working in a collaborative, diverse, and socially responsible team;
22. Company retreat facility;
23. Full-coverage insurance for accidents/daily sickness;
24. Prime location near Basel train station and city center;
25. And more