Analytics Engineer with 6 years of experience delivering enterprise data warehouse solutions using Snowflake. Strong expertise in cloud migration, ELT frameworks, data modeling, query optimization, automation, governance, and self-service analytics. Hands-on with SQL, Python, dbt, Airflow, Azure, AWS, and modern BI platforms.
Expertise & skills
Snowflake
SnowflakeSnowpipeStreamsTasksDynamic TablesSecure Data SharingCloning
Languages
SQLPythonJavaScript
ELT & Orchestration
dbtApache AirflowAzure Data Factory
Cloud
AWS S3Azure Data Lake Storage Gen2
Modeling
KimballStar SchemaData Vault
BI
Power BITableauLooker
DevOps
GitGitHub ActionsJenkins
Selected projects
Responsibilities
- Built scalable ELT pipelines in Snowflake using dbt.
- Designed dimensional models for customer analytics.
- Optimized SQL transformations and virtual warehouses.
- Automated workflow scheduling through Airflow.
- Implemented data quality validation processes.
Certifications
- SnowPro Core Certification
- Microsoft Certified: Azure Fundamentals (AZ-900)
Education
Bachelor of Technology (Computer Science and Engineering)
Charotar University of Science and Technology
Achievements
- Reduced analytics latency by 57%.
- Improved dashboard performance by 41%.
- Capital Markets Reporting Hub
- Responsibilities
- Migrated reporting data from Teradata to Snowflake.
- Developed reusable stored procedures and secure views.
- Implemented role-based security and masking policies.
- Reduced monthly processing time.
- Improved governance.
- Healthcare Operations Data Mart
- Integrated EMR and operational datasets.
- Created incremental ingestion pipelines.
- Developed curated reporting models.
- Enabled faster operational insights.
- Telecom Network Performance Warehouse
- Built KPI datasets.
- Optimized warehouse sizing.
- Implemented monitoring dashboards.
- Reduced compute costs by 23%.
- Manufacturing Quality Analytics
- Designed quality reporting models.
- Automated daily data refresh.
- Implemented CDC using Streams and Tasks.
- Improved reporting reliability and traceability.
Similar engineers
Other Data Engineering engineers with comparable experience.
