Key Responsibilities
Design, develop, and maintain data warehouse solutions using Snowflake.
Build and optimize ETL/ELT pipelines for loading and transforming large datasets.
Develop complex SQL queries, stored procedures, and database objects.
Implement data ingestion frameworks from multiple sources such as databases, APIs, files, and cloud storage.
Design dimensional data models including Star Schema and Snowflake Schema.
Optimize Snowflake performance using clustering keys, partitioning strategies, caching, and query tuning.
Manage Snowflake security, data governance, access controls, and role-based permissions.
Work with cloud storage solutions and data lakes for structured and semi-structured data processing.
Collaborate with business stakeholders, analysts, and data engineers to gather requirements.
Monitor and troubleshoot data pipelines and warehouse performance issues.
Develop and maintain documentation for data architecture and ETL processes.
Support CI/CD deployments and DevOps best practices.