Consultant Snowflake DBT — Talan

Full description

• Design, develop and deploy data models in the Snowflake environment.
• Apply Data Vault 2.0 modelling practices (Hubs, Links, Satellites)
• Develop, optimize and document dbt models (tests, automated documentation, CI/CD dbt, macros).
• Optimize requests, closing keys management, cost tracking (credits consumption) and performance on Snowflake.
• At least 4 years of practice in the production environment (architecture, query optimization, security and role management).
• Ability to structure dbt projects, write Jinja macros, manage environments and continuous integration.
• Mastering the principles of the Data Vault methodology (design of Hubs, Links, Satellites) applied to cloud data warehouses.
• Excellent mastery of advanced SQL, Python, Git and DevOps / CI-CD practices.
• Current English & French

The plus

• Snowflake Certification (SnowPro Core or Advanced Architect/Data Engineer).
• Certification dbt Fundamentals / Developer.
• Experience on an orchestration tool (Airflow, Dagster, Prefect).