Headline

Snowflake Data Engineer | DBT | ELT Pipelines | SQL | SnowPipe | CI/CD | Cloud (AWS/GCP) | Data Modeling

About

Snowflake Data Engineer with 5+ years of experience designing scalable cloud-native data platforms using Snowflake, DBT, SQL, and CI/CD. Specialized in building production-grade ELT pipelines, dimensional models, and real-time ingestion systems using SnowPipe. Delivered measurable improvements including: - ~20% reduction in data latency - ~15% query performance improvement - ~25% reduction in deployment errors Experienced in leading a team of 6, managing sprint execution, and delivering end-to-end data solutions for enterprise analytics. Passionate about data engineering, performance optimization, and building AI-driven analytics solutions using Snowflake Cortex.

Location

Pune District

AI stack

claude

notebooklm

ollama

Bolt.new

Microsoft Copilot

OpenRouter

Work experience

Account Manager - BI at Dentsu Global Services, Aug 2026 - Present · 1 mo, Bengaluru

Associate - Reporting and Analytics at Omnicom Global Solutions, Apr 2025 - Aug 2026 · 1 y 4 mo, Pune District, Maharashtra, India, •Designed and engineered production-grade ELT pipelines using Snowflake and DBT to automate ingestion, transformation, and delivery of enterprise-scale healthcare data. •Implemented SnowPipe-based real-time ingestion architecture, enabling continuous data flow from AWS S3 into Snowflake and reducing data latency by ~20%. •Optimized Snowflake performance by tuning queries, improving warehouse utilization, and applying best practices such as clustering and efficient transformation logic, resulting in ~15% improvement in query execution and cost efficiency. •Built modular DBT models with automated testing and data quality checks, integrated into GitLab CI/CD pipelines to ensure reliable deployments across environments and reduce production errors by ~25%. •Developed standardized reporting views and dimensional models (Star Schema) to support KPIs like CTR, CPA, and CPM, improving reporting efficiency across teams. •Led and mentored a team of 6 analysts/engineers, managing sprint planning, task allocation, and code reviews to improve delivery consistency and reduce rework by ~20%.

Business Data Analyst at Yug TechnoSoft, Jun 2023 - Apr 2025 · 1 yr 11 mos, Indore, Madhya Pradesh, India, •Designed and implemented Snowflake-based Star Schema data models to support enterprise reporting, analytics, and forecasting across sales and user engagement domains. •Built SQL-based transformation pipelines processing millions of records, enabling scalable analytics and improving data accuracy and performance. •Developed Python and Tableau-based analytical workflows to analyze user behavior and engagement trends, generating insights that improved retention and decision-making. •Created interactive Power BI dashboards tracking KPIs such as order cycle time and capacity utilization, reducing manual reporting effort by ~30%. •Performed data validation, reconciliation, and quality checks across multiple data sources, improving reporting accuracy and reducing discrepancies by ~15%. •Collaborated with stakeholders to define KPIs, metrics, and reporting logic, improving alignment between business requirements and technical implementation. •Delivered data-driven recommendations using Google Analytics, contributing to a ~10% reduction in bounce rate and improved user experience.

Warehouse Associate at NAPA Canada, May 2022 - Oct 2022 · 6 mos, Cambridge, Ontario, Canada, - Optimized inventory using WMS to monitor stock, streamline fulfillment, and improve picking accuracy by 12%. - Led cycle counts and resolved discrepancies, reducing stock variances by 32% through data validation. - Analysed SKU-level data to enhance warehouse layout, cutting order processing time by 27%. - Compiled daily reports on throughput and delivery timeliness to support logistics decisions. - Validated inbound/outbound shipment data, ensuring integrity and minimizing fulfillment errors.

Crew Member at Sam's Grill, Nov 2021 - Apr 2022 · 6 mos, Cambridge, Ontario, Canada, - Utilized POS system data to conduct daily sales and customer trend analysis, optimizing menu configurations and staffing allocations, achieving a 23% increase in operational efficiency and reduced labor costs. - Managed inventory tracking and forecasting by analyzing supply chain datasets, identifying usage patterns, and minimizing waste by 14%, equivalent to fundamental supply chain analytics processes. - Performed performance evaluations for a six-member crew by compiling and analyzing key performance indicators (KPIs), such as shift productivity and customer satisfaction metrics, to drive targeted operational enhancements. - Executed data entry tasks, ensuring transactional data accuracy and generating weekly analytical reports to inform strategic management decisions.

SEO EXECUTIVE at SyStos Technology, Feb 2020 - Aug 2021 · 1 yr 7 mos, Indore, Madhya Pradesh, India, •Managed 15+ digital projects, analyzing website performance metrics and user behavior data to optimize SEO strategies and improve search rankings. •Conducted keyword, traffic, and engagement analysis to identify growth opportunities, increasing organic traffic by ~37%. •Delivered performance reports and actionable insights to stakeholders, improving campaign effectiveness and decision-making. •Executed on-page and off-page SEO optimization including keyword planning, link building, and content strategy development.

Education

Postgraduate Degree, Virtualization and Cloud Computing, Conestoga College

Graduate Certificate, Big Data Solution Architecture, Conestoga College