Shankar Joshi

Analytics Engineer

Pluralsight

Feb 2025 - Current (1 year 5 months)

Snowflake Data Governance & Infrastructure as Code (Terraform) • Implemented a scalable RBAC framework in Snowflake using Terraform, managing 10+ role hierarchies, 12+ service accounts, and access policies for new tool integrations (e.g., Iterable). • Designed and deployed dynamic data masking and Pll-protection policies through laC(Terraform), improving compliance while maintaining analytical utility with 6+ cross-functional teams. Workday HR Data Platform & People Analytics Pipeline • Architected a unified HR data pipeline by consolidating fragmented Workday datasets (Stitch connectors, Google Sheets, Workday APIs) into Snowflake, resolving 50+ recurring data-quality issues and establishing a single source of truth for People, Finance, an

Analytics Engineer II

Greenlight Financial Technology

Dec 2023 - Aug 2024 (9 months)

Optimized Data Processing Models In Snowflake • Implemented incremental processing using SQL, DBT & Python reducing table update times from 40-49 minutes to 18-25 minutes. Reduced daily processed row volume from 2.9 billion to 10-20 million, improving efficiency and drastically reducing compute load and improving efficiency. Developed Billing Reconciliation Models • Saved $78,000-$80,000 by uncovering issues in billing, such as incorrect dates, promotion periods, and misapplied plans, through SQL, DBT & MonteCarlo Testing Tool. Resolved Analytics Engineering Model Issues • Fixed bugs related to complex joins and business logic using SQL, leading to a 2% increase in model accuracy and reliability. Built End-to-End User KYC Models • Developed

Senior Data Analyst

Headout

Aug 2022 - Dec 2023 (1 year 5 months)

Combo Cannibalization Model in BigQuery Data warehouse • Developed a sophisticated numerical logic using Excel and Python to track cannibalization rates between combo & non-combo experiences, identifying affected products for timely corrective action. • Optimized combo performance using product affinity and Geo-Location proximity. Content Localization Prioritization Framework Ο Engineered models using DBT, SQL & Python to prioritize products for localization based on traffic input and session share, enabling detailed comparisons between translated and non-translated content & increased visibility by 8-10%. Data-Driven Up-selling Model • Constructed analytical models utilizing Python & BigQuery, leveraging search volume and lead time data to

A

Data Analyst

Amazon India

May 2021 - Aug 2022 (1 year 4 months)

Business Logic Pipeline for Task Recommendation Center (TRC) for Sellers Ο Built a comprehensive data pipeline using Python & SQL for the TRC, incorporating all business logic and defining key metrics. • Analyzed the impact of TRC initiatives, providing insights that helped program owners address seller-level challenges. First Order Cancellation Analysis • Conducted a deep dive analysis on first-order cancellations among new sellers, leading to a 3% decrease in cancellation rates. Metrics Redefinition and Automation • Redefined metrics for the IN-New Seller Success Team, enhancing dashboard visibility and insights while automating 90% of manual program management tasks using python. Local-Shop-Web-Lab Cross-Function Collaboration Ο Deep-Div

W

Data Engineer, Wmall ( ShopDeck ) - Founding Member

Wmall ( ShopDeck )

Sep 2019 - May 2021 (1 year 9 months)

• Solely built an end-to-end data pipeline using SQL, Python, Airflow & Amazon Redshift As Data Warehouse addressing data availability issues for cataloging, operations, marketing, and customer care. Maintained roles and access levels for analysts in AWS-IAM for secure data management. • Implemented a monitoring and alerting system for AWS compute consumption using Python and SQL, ensuring optimal resource utilization & reducing costs by 15%. • Designed & Established an events pipeline from scratch with Airflow, Python, SQL, & hosted on AWS, enhancing data workflows and providing 100% visibility for product analysis on events data where there was previously no insight. • Set up end-to-end Apache Superset as a BI tool, improving data visuali

A

Associate Data Analyst

Alpha Nodus

Jan 2019 - Jul 2019 (7 months)

• Worked with US based medical oriented customers to understand needs and Proved and provided possible solutions to the hospitals that the Front Desk is the barrier for less efficiency of the medical assistance with responsibility of daily reports.

About

Detail

Timeline

Résumé