Consultant Snowflake DBT

Design, develop and deploy data models in the Snowflake environment. Apply Data Vault 2.0 modeling practices (Hubs, Links, Satellites) Develop, optimize and document dbt models (tests, automated documentation, dbt CI/CD, macros). Optimize queries, clustering keys management, cost tracking (credits consumption) and performance on Snowflake. At least 4 years of practice in a production environment (architecture, query optimization, security and roles management). Ability to structure dbt projects, write Jinja macros, manage environments and continuous integration. Mastery of Data Vault methodology principles (design of Hubs, Links, Satellites) applied to cloud data warehouses. Excellent mastery of advanced SQL, Python, Git and DevOps / CI-CD practices. Fluent French & English The +: Snowflake Certification (SnowPro Core or Advanced Architect/Data Engineer). dbt Fundamentals / Developer Certification. Experience with an orchestration tool (Airflow, Dagster, Prefect). . Talan is an international consulting and technological expertise group, which supports and accelerates the digital transformation of its clients through the levers of technology, data and innovation. For more than 20 years, Talan has advised and supported companies and public institutions in the definition and implementation of their transformation and innovation projects in Switzerland and internationally. Present on 5 continents in 21 countries, the Group, certified Great Place To Work, has more than 7000 employees. Equipped with a Research and Innovation Center, Talan places innovation at the heart of its development and operates in the fields of technological changes such as Artificial Intelligence, Data Intelligence, Blockchain, to serve the growth of large groups and mid-cap companies in a committed and responsible manner. By placing “Positive Innovation” at the heart of its strategy, Talan is convinced that it is by serving humanity that technology amplifies its impact on society as a whole. #TalanSuisse