Expert Snowflake Architect

We are looking for an experienced Snowflake expert to join an international project in the Healthcare Commercial AI area. The person will be responsible for designing the architecture, developing and optimizing the Snowflake environment, and collaborating with data, analytics and cloud teams.

• Designing and developing data architecture in Snowflake
• Designing data schemas and data models
• Building and developing ETL/ELT processes
• Optimizing Snowflake environment performance, including clustering and performance tuning
• Designing solutions using dbt
• Working with advanced SQL and query optimization
• Ensuring data security, access management and governance
• Creating technical and architectural documentation
• Working with the team in an Agile/Scrum environment

• Expert-level knowledge of Snowflake, including architecture, data modelling, performance tuning, clustering and data sharing
• Very good knowledge of dbt Cloud and experience migrating to dbt Core
• Experience designing and building ETL/ELT processes
• Very good knowledge of SQL, including complex transformations, window functions and query optimization
• Experience in data modelling, including star schema and raw, staging and marts layers
• Knowledge of security and governance mechanisms, particularly RBAC and Row-Level Security
• Experience working in an Agile/Scrum environment
• Ability to create technical documentation
• Very good command of English
• Knowledge of Apache Airflow (nice to have)
• Experience with dbt Core and dbt on Snowflake (nice to have)
• Knowledge of Dynamic Tables, Snowpark Python and incremental models (nice to have)
• Experience with AWS (nice to have)
• Knowledge of Python (nice to have)
• Knowledge of Confluence (nice to have)
• Experience in the healthcare or pharmaceutical sector (nice to have)

• Multisport card
• Private medical care