Snowflake DBT Consultant

About the job

Company Description

Talan is an international consulting and technology expertise group that supports and accelerates the digital transformation of its clients through technology, data, and innovation levers.

For over 20 years, Talan has been advising and supporting companies and public institutions in defining and implementing 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 7,000 employees.

Equipped with a Research and Innovation Centre, Talan places innovation at the heart of its development and operates in areas of technological change such as Artificial Intelligence, Data Intelligence, and Blockchain, to support the growth of large groups and mid-sized companies in a committed and responsible approach.

By placing "Positive Innovation" at the core of its strategy, Talan is convinced that technology amplifies its impact on society as a whole by serving humanity.

#TalanSwitzerland

Job Description

• Design, develop and deploy data models in the Snowflake environment.
• Apply Data Vault 2.0 modelling practices (Hubs, Links, Satellites).
• Develop, optimise and document dbt models (tests, automated documentation, dbt CI/CD, macros).
• Optimise queries, clustering key management, cost monitoring (credits consumption) and performance on Snowflake.

Qualifications

• At least 4 years of experience in a production environment (architecture, query optimisation, security and role 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 command of advanced SQL, Python, Git and DevOps / CI-CD practices.
• Fluent in French & English

Advantages:

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

Additional Information

.