Description

Design and implement data architectures within the Snowflake ecosystem. You will own the data lifecycle, from extraction to transformation and modeling.

Responsibilities

• Write complex SQL queries and scripts for data extraction, loading, and transformation.
• Develop ETL processes using DBT and Python scripting.
• Design data models including star schemas, third normal form, and entity relationship diagrams.
• Manage data lifecycle using Snowflake utilities like SnowPipe, Tasks, Streams, and Time Travel.
• Perform source-to-target mapping and maintain technical documentation.

Required Skills

• Proven experience as a Snowflake Architect.
• Advanced SQL coding skills and hands-on experience with SQL flavors.
• Deep familiarity with Snowflake utilities: SnowSQL, SnowPipe, Tasks, Streams, Time Travel, Optimizer, and Metadata Manager.
• Experience with ETL tools, specifically DBT.
• Proficiency in data modeling (conceptual, logical, and physical models).
• Experience working within Agile delivery processes.
• Ability to develop scripts in Unix and Python.

Preferred Skills

• Strong Python scripting capabilities for data engineering tasks.

Key Skills

Education

ANY GRADUATE