Description
You will lead data warehousing projects and architect end-to-end data integration processes within a Snowflake environment.
Responsibilities
- Design and build manual or automated data ingestion pipelines using Snowpipe.
- Develop stored procedures and write complex queries to analyze and transform data.
- Implement cloud-based enterprise data warehouse solutions and data movement strategies.
- Manage Snowflake architecture including resource monitors, RBAC controls, virtual warehouses, and query performance tuning.
- Update modeling principles and processes to ensure alignment with business requirements.
Required Skills
- 10+ years of industry experience in Data Warehousing.
- Minimum 4 years of hands-on experience working with Snowflake.
- Expertise in Snowflake features including zero-copy clone, time travel, and SnowSQL.
- Strong knowledge of ETL/ELT processes and Snowpipe.
- Deep understanding of relational and NoSQL data stores.
- Proficiency in dimensional modeling, star, and snowflake schemas.
- Hands-on experience with SQL, Python, PL/SQL, and T-SQL.
- Experience managing structured, semi-structured, and unstructured data.
- Bachelor's degree in Computer Science, Engineering, or equivalent practical experience.