- 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.