Description

You design and implement scalable, secure, and high-performance Snowflake architectures.

Responsibilities

• Develop and manage end-to-end data pipelines using Snowflake and dbt.
• Conduct architecture reviews, assessing system design for scalability, maintainability, and performance.
• Analyze and optimize the performance of Snowflake stored procedures, queries, and overall workload.
• Ensure adherence to Snowflake best practices for data modeling, storage, and transformation.

Required Skills

• 12+ years of experience in designing and implementing Snowflake architectures.
• Strong hands-on experience with dbt (Data Build Tool) for transformation and modeling.
• Deep understanding of Oracle PLSQL, including tuning stored procedures, packages, and triggers.
• Proficiency in Data Vault (ODS) Modelling and Dimensional Data Modelling.
• Experience with ANSI-SQL, ER Studio, and Toad Data Modeler.
• Familiarity with MS SQL Server and Erwin.
• Experience with Microsoft Fabric and GCP Big Query.

Preferred Skills

• Development experience with Apache Airflow.

Key Skills

Education

Any Graduate