Expert Snowflake Engineer

We are looking for an experienced Expert Snowflake Engineer to join a project for a client in the healthcare sector. This is an excellent opportunity to take ownership of the architecture and development of a Snowflake environment while working with a modern cloud data stack in an Agile environment.

The project is 100% remote, delivered in SCRUM (3-week sprints), using Snowflake, dbt, AWS, Azure DevOps/Jira, and Confluence.

Details:

• Contract type: B2B

• First engagement: 95 working days; duration: August – December 2026 (with the possibility of extension)

• Planned onboarding: no later than mid-August 2026

Your responsibilities

• Design and develop the Snowflake architecture for the project.

• Build and enhance the Snowflake environment.

• Design and implement ETL/ELT processes.

• Create and maintain technical documentation.

• Collaborate with the project team in an Agile/SCRUM environment.

Requirements

• Expert-level knowledge of Snowflake, including:

  • architecture,

  • schema design,

  • performance tuning,

  • clustering,

  • data sharing.

• Strong knowledge of dbt Cloud and experience migrating to dbt Core.

• Experience designing and building ETL/ELT processes.

• Advanced SQL skills, including complex transformations, window functions, and query optimisation.

• Experience with data modelling, including star schema and raw/staging/marts layers.

• Experience with security and data governance, including RBAC, Row-Level Security, and access management.

• Experience working in Agile/SCRUM environments.

• Ability to create technical documentation.

• Very good command of English.

Nice to have

• Apache Airflow.

• dbt Core.

• dbt on Snowflake (Dynamic Tables, Snowpark Python, incremental models).

• AWS.

• Python.

• Confluence.

• Experience in the healthcare or pharmaceutical industry.