Back to jobs

EXPERT SNOWFLAKE ENGINEER

Bpxsa
mid

Job description

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.