Summary
Overview
Work History
Education
Skills
Timeline
Generic

Tushar Sharma

Bareilly

Summary

Data Engineer with three years of experience in building scalable data pipelines, transforming raw data into high-quality, analytics-ready datasets using Snowflake, BigQuery, and dbt (models, macros, tests, Jinja). Experienced in orchestration and automation with Apache Airflow, programming and querying with SQL and Python, and managing metadata and governance using Atlan. Proven track record in optimizing queries, reducing data disparities, and migrating data models efficiently. Detail-oriented and collaborative, with strong communication skills to work effectively across analytics and engineering teams.

Overview

8
8
years of professional experience

Work History

Data Engineer

Diacto Technologies
Remote
02.2023 - Current
  • Deployed in Colgate Palmolive as Data Engineer and Analytical Engineer

GDO – Analytics (CRM Aligners & Claravine)

  • Designed and built scalable dbt models to process raw CRM and marketing data into analytics-ready datasets.
  • Collaborated closely with Data Engineering teams to align ingestion, transformations, and data contracts.
  • Implemented data validation and quality checks, ensuring trusted datasets for campaign performance tracking and reporting.
  • Enabled downstream analytics by delivering clean, well-modeled consumption layers for BI and reporting teams.

GDO – Web Analytics

  • Built and optimized dbt models across multiple web analytics programs, ensuring consistency and reusability.
  • Led migration of SQL workloads from BigQuery to Snowflake, minimizing data discrepancies to .
  • Optimized Snowflake queries and transformations, improving query performance by ~8%.
  • Strengthened data quality through systematic validations and reconciliation checks.

LATAM Downstream Analytics

  • Migrated complex data models from BigQuery to Snowflake, ensuring seamless continuity across environments.
  • Developed custom dbt macros to reduce code duplication and improve maintainability.
  • Optimized transformation logic, achieving ~60% reduction in runtime.
  • Reduced data variance to 0.5–2% in development and through robust reconciliation frameworks.

Data Excellence

  • Partnered with the Data Excellence team to monitor, govern, and operationalize metadata across the data platform.
  • Worked extensively with Atlan to manage metadata, lineage, and data discovery.
  • Automated credential rotation workflows using Airflow as the orchestration tool.
  • Built end-to-end pipelines from GCS to Snowflake, followed by DBT Models to create analytics-ready consumption layers for visualization engineers.

Tutor

Self Employed
Bareilly
01.2018 - 01.2023
  • Designed individualized lesson plans for diverse learning styles and needs.
  • Facilitated engaging tutoring sessions in subjects like math and science.
  • Along with preparing for govt examinations

Education

Data Science And AI - Python, SQL, Statistics, Machine Learning

LearnBay
01-2023

Business Analytics -

UpGrad
08-2022

B.Tech - Electrical Engineering

Shri Siddhi Vinayak Institute of Technology
Bareilly, UP, India
06-2017

Skills

  • Data warehousing: Snowflake, Google BigQuery
  • Data transformation: dbt (models, macros, tests, Jinja)
  • Orchestration and automation: Apache Airflow
  • Programming and querying: SQL, Python
  • Metadata and governance: Atlan
  • Soft Skills: Detail-oriented, analytical problem-solving, effective cross-functional communication, ownership-driven mindset

Timeline

Data Engineer

Diacto Technologies
02.2023 - Current

Tutor

Self Employed
01.2018 - 01.2023

Data Science And AI - Python, SQL, Statistics, Machine Learning

LearnBay

Business Analytics -

UpGrad

B.Tech - Electrical Engineering

Shri Siddhi Vinayak Institute of Technology
Tushar Sharma