Jhanvi Punjabi

About Jhanvi Punjabi

I’m an analytics engineer with 4+ years of experience building scalable data models and pipelines using SQL, Snowflake, and dbt.In my current role, I work closely with business stakeholders to define key metrics, analyze performance, and translate complex data into actionable insights that support revenue and operational decisions. I’ve built end-to-end data models and reporting layers, developed dashboards used by leadership, and helped standardize core business metrics across teams.I’m particularly interested in roles focused on product, growth, and business analytics, where I can apply data to understand performance drivers, measure impact, and support data-informed decision making.

Experience

1. Analytics Engineer

   Integrity Express Logistics

   Feb 2022 — Present · Cincinnati, OH, US

   Designed and owned scalable analytics data models (fact and dimension tables) in dbt, defining grain, business logic, and standardized metrics for consistent reporting-Built and optimized end-to-end ELT pipelines (Snowflake + dbt) to transform raw operational data into production-ready datasets for analytics and executive reporting -Implemented modular dbt transformation layers (staging → intermediate → marts) improving data quality, reusability, and development efficiency-Optimized SQL queries and data models to improve dashboard performance, reduce query execution time, and enhance overall data pipeline efficiency-Built and maintained SQL-driven dashboards used by 25+ sales managers and executive leadership to monitor revenue, margins, and operational performance-Automated monthly, YTD, and TTM revenue reporting for customer accounts, improving data accuracy and eliminating manual reporting effort-Produced executive analytics summaries consolidating 20+ BI reports, delivering actionable insights for 40+ stakeholders including C-suite leadership-Defined and standardized core business metrics (revenue, margin, load performance), ensuring alignment across reporting, forecasting, and executive decision-making-Partnered cross-functionally with sales, operations, and risk teams to translate ambiguous business questions into scalable analytics solutions-Developed a predictive risk model in R to identify high-risk freight loads, enabling proactive mitigation and supporting operational decision-making

Education

• University of Cincinnati

  Business Analytics (BS); Insurance & Risk Management (BBA); Marketing (Minor)

  2017 — 2021

• The Indian High School Dubai

  High School Graduate, Business/Commerce, General

  2015 — 2017