Open to opportunities

Shivashish Mishra

@shivashishmishra

Message

Data & Analytics Engineer building AWS data pipelines that cut query costs.

India

Message

What I'm looking for

I’m looking to build dependable AWS analytics infrastructure—data pipelines, dbt models, and Redshift performance improvements—so business teams get accurate, reporting-ready datasets. I want ownership, collaboration, and measurable impact on reliability and cost.

I’m a Data & Analytics Engineer with 2+ years of experience building and maintaining reliable data pipelines on AWS. I move data through Medallion Architecture (Bronze to Gold) using dbt and Redshift to deliver clean, reporting-ready datasets for business teams.

I automate manual reporting workflows with Python-based orchestration, eliminating 10+ hours of weekly manual exports, and I’m focused on reliability, quality, and cost control. Recently, I optimized Redshift performance and reduced average data scanned per query by ~60% using partitioning, bucketing, and materialized views—improving P75 query execution time for downstream BI tools.

Experience

Work history, roles, and key accomplishments

Current

Data & Analytics Engineer

Current

Showpo

Mar 2024 - Present (2 years 1 month)

Automated cross-departmental reporting by deploying Python-based Airflow DAGs that synchronized Amazon Redshift with Google Sheets, eliminating 10+ hours of weekly manual exports. Managed Redshift Medallion (Bronze→Silver→Gold) pipelines with dbt models and quality/freshness checks using incremental loading to keep datasets reporting-ready.

Amazon Redshift DBT Apache Airflow Python SQL Medallion Architecture Google Sheets Cost Optimization