- Design and develop scalable cloud-based data warehouse solutions using Snowflake.
- Build and maintain dbt models, macros, tests, and documentation.
- Develop and optimize ELT/ETL pipelines for enterprise data platforms.
- Create dimensional models, fact tables, and business data marts.
- Implement data quality checks and automated testing frameworks.
- Optimize Snowflake performance, storage, and compute utilization.
- Collaborate with business and technical stakeholders to deliver data solutions.
- Support production deployments, troubleshooting, and performance tuning.
- Ensure adherence to data governance, security, and compliance standards.
Required Skills
- Solid hands-on experience with Snowflake
- Experience in dbt (Data Build Tool)
- Advanced SQL development and query optimization
- Strong Python programming skills
- Data Warehousing and Dimensional Modeling
- ETL/ELT development and optimization
- Experience with Snowflake features such as:
- Virtual Warehouses
- Streams & Tasks
- Time Travel
- Zero Copy Cloning
- Snowpipe
- Secure Data Sharing
- Exposure to cloud platforms such as AWS, Azure, or GCP
- Git/GitHub version control
Preferred Skills
- PySpark
- Databricks
- Airflow
- AWS Glue
- Kafka
- Terraform
- CI/CD Pipelines
- Data Governance and Data Quality frameworks
Desired Experience
- 6-12 years of overall IT experience
- Minimum 3+ years of hands-on Snowflake experience
- Minimum 2+ years of dbt implementation experience
- Experience in cloud migration and data warehouse modernization projects
- Experience working in Agile environments
Education
- BE / B.Tech / MCA / M.Tech or equivalent qualification