Description

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

Responsibilities

• Design and implement data models using Dimensional modeling, Star Schema, and Data Vault architectures.
• Develop, optimize, and troubleshoot complex SQL and PL/SQL queries and User-Defined Functions (UDFs).
• Build and monitor ETL/ELT processes to integrate Snowflake with various data sources and third-party tools.
• Manage Snowflake security, including role-based access control, privileges, and data protection compliance.
• Perform performance tuning by managing workloads, optimizing schema design, and sizing virtual warehouses.
• Migrate legacy on-premises solutions to cloud-based platforms.
• Collaborate with product owners and cross-functional teams to translate business requirements into technical specifications.
• Mentor junior developers and maintain documentation for architecture and maintenance processes.

Required Skills

• 8+ years of experience designing data solutions specifically using Snowflake.
• Expertise in SQL and PL/SQL.
• Strong proficiency in ETL/ELT processes and techniques.
• Hands-on experience with Dimensional modeling, Star Schema, and Data Vault.
• Experience using profiling tools like Alteryx.
• Ability to identify upstream and downstream data impacts and propose remediation options.
• Proven track record of solving system performance and scalability issues.
• Experience using version control tools for managing code and models.
• Ability to explain technical concepts to non-technical stakeholders.

Key Skills

Education

Any Gradute