Description

Job Title: Snowflake Engineer

Start date: ASAP

latest Start Date: 1.6.25

Planned duration: 6 months with option of extension

Workplace: Basel

Workload: 100%

Remote/Home Office: during onboarding only onsite, afterwards 1-2 days remote (depending on performance)

Background

Clinical trials generate a lot of data, we use this data to make clinical trials more efficient, and effective. Joining us, you will be at the forefront of innovation within drug discovery and clinical trials. Whether it is in developing open-source tools or developing tools that will be used by more than 1000 fellow data scientists, you will be working in a multifaceted international team that will be developing and testing software prototypes.

The tool that you will be working on automatically generates discrepancies based on the metadata ingested with minimum input from users. Those discrepancies can be optimized to speed up the data cleaning process and allow a fit for purpose data cleaning approach by sending the right query at the right time to the appropriate user reducing the query burden at the sites.

Joining a team of inspired professionals with your skills as snowflake engineer you will design and implement data architecture, writing functions and integrating various data models. Besides, you will also focus on optimizing performance, ensuring security, and maintaining the health of the data warehouse through monitoring and troubleshooting. Additionally, you will automate data workflows, collaborate with data stakeholders, and provide documentation and training to ensure effective use of the Snowflake platform for data analytics and business intelligence

The perfect candidate has minimum 1-2 years' experience working with Snowflake's cloud data platform and is proficient in programming languages such as Python. Additionally, we are looking for someone who is experienced with SQL for querying and managing databases. English must be fluent for this role.

Tasks & Responsibilities:

Design and implement scalable and efficient data storage and data processing solutions within Snowflake.

Write, optimize, and troubleshoot business owned and developed tables, views, functions and SQL queries within the Snowflake environment.

Ensure data security and compliance with industry standards.

Collaborate with cross-functional teams to meet data-driven business objectives.

Potentially integrate Snowflake with ServiceNow.

Must Haves:

Minimum 1-2 years' experience working with Snowflake's cloud data platform.

Proficiency in programming languages such as Python (and/or Java, C++, or Scala.)

Experience with SQL for querying and managing databases.

Understanding of data warehousing concepts and architecture.

Familiarity with concepts like ETL/ELT processes.

Performance tuning abilities

Knowledge of cloud platforms such as AWS

Experience using cloud-native tools and services.

English fluent

Employee Value Proposition

Working for one of the leading pharma companies in the world.

Job Title: Snowflake Engineer

Location: Basel, Switzerland

Job Type: Contract

TEKsystems, an Allegis Group company. Allegis Group AG, Aeschengraben 20, CH-4051 Basel, Switzerland. Registration No. CHE-101.865.121. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at our website.

To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go our website.

We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the "Contacting Us" section of our Online Privacy Notice on our website for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.