Snowflake Data Engineer with 8 years of experience designing and implementing enterprise-scale cloud data warehouse solutions using Snowflake. Expertise in building scalable ELT pipelines, data modeling, query optimization, cloud migration, and implementing secure, high-performance analytics platforms. Proficient in SQL, Python, Snowflake advanced features, AWS, Azure, dbt, and Apache Airflow. Experienced in delivering modern data solutions across Banking, Insurance, Retail, and Healthcare domains.
Expertise & skills
Selected projects
Enterprise Data Warehouse Modernization
Responsibilities
Achievement: Reduced reporting latency by 55% while lowering Snowflake compute costs by 30%.
- Designed and implemented a scalable enterprise data warehouse using Snowflake.
- Developed automated data ingestion pipelines using Snowpipe.
- Configured secure data sharing across multiple business units.
- Optimized virtual warehouse sizing and auto-suspend policies to reduce compute costs.
- Built reusable SQL transformation frameworks for enterprise reporting.
- Improved query performance using clustering keys and materialized views.
- Implemented role-based access control and data masking policies.
- Automated deployment processes using CI/CD pipelines.
Insurance Claims Analytics Platform
Responsibilities
Achievement: Reduced daily batch processing time from 7 hours to 2 hours.
- Developed ELT pipelines for policy and claims data.
- Designed dimensional data models for analytical reporting.
- Implemented Change Data Capture using Streams & Tasks.
- Built incremental transformation models using dbt.
- Optimized warehouse utilization for concurrent workloads.
- Automated data quality validation processes.
- Delivered semantic datasets for executive dashboards.
Retail Customer Analytics Platform
Responsibilities
Achievement: Improved dashboard refresh performance by 45%.
- Integrated CRM, POS, and e-commerce datasets into Snowflake.
- Designed star schema data models for analytics.
- Developed reusable SQL transformation logic.
- Automated workflow orchestration using Apache Airflow.
- Tuned long-running analytical queries.
- Created customer segmentation datasets.
- Improved warehouse resource utilization.
Banking Regulatory Reporting Solution
Responsibilities
Achievement: Achieved 99.9% reporting accuracy for regulatory submissions.
- Built secure regulatory reporting data marts.
- Implemented role-based security and access controls.
- Developed reconciliation reports for compliance.
- Created automated audit logging processes.
- Optimized storage and compute utilization.
- Managed Time Travel and Fail-safe configurations.
- Supported production deployments and release activities.
Customer 360 Data Platform
Responsibilities
Achievement: Reduced customer data processing time by 40%.
- Consolidated customer data from multiple enterprise systems.
- Developed reusable transformation models using dbt.
- Implemented secure data sharing for downstream applications.
- Designed metadata-driven ELT pipelines.
- Built monitoring dashboards for pipeline health.
- Automated data validation and reconciliation.
- Optimized virtual warehouse performance.
Certifications
- SnowPro Core Certification
- Microsoft Azure Data Engineer Associate
- AWS Certified Cloud Practitioner
Education
Bachelor of Technology (B.Tech) in Computer Science and Engineering
Gujarat Technological University
Similar engineers
Other Data Engineering engineers with comparable experience.
