Description

You will lead the design and implementation of scalable Snowflake data warehouse solutions to support enterprise-level applications.

Responsibilities

• Lead the design of data models, virtual warehouse sizing, and schema optimization.
• Develop and optimize complex SQL queries, Snowflake built-in functions, and User-Defined Functions (UDFs).
• Build, monitor, and optimize ETL/ELT processes and data models.
• Manage data security, roles, and privileges within Snowflake to ensure compliance.
• Migrate legacy on-premises solutions to cloud-based platforms.
• Collaborate with product owners and cross-functional teams to document and meet business requirements.
• Mentor junior developers and maintain documentation for architecture and maintenance processes.

Required Skills

• 8+ years of experience designing data solutions using Snowflake Database.
• Expertise in SQL and PL/SQL.
• Strong background in Dimensional modeling, Star Schema, and Data Vault.
• Hands-on experience with ETL/ELT processes and data migration strategies.
• Proficiency with profiling tools like Alteryx.
• Experience with Business Intelligence and troubleshooting complex data systems.
• Ability to identify upstream and downstream data impacts and propose remediation options.
• Bachelor's degree in Computer Science or related field.

Key Skills

Education

Any Graduate