Janvi Pagariya
Pune
Summary
Analytics-focused Data Engineer with hands-on experience building analytics-ready data models using dbt, Snowflake, and Airflow. Strong in SQL-based transformations, metric definition, and dimensional modeling (facts & dimensions). Experienced in supporting BI and reporting use cases, migrating pipelines to multi-tenant architectures, and working closely with product teams to translate business requirements into scalable data models. Actively seeking dbt / Analytics Engineer roles.
Overview
2
2
years of professional experience
Work History
Software Engineer (Full-Time)
Graas
01.2024 - Current
- Worked on Unified Query Framework (UQF) to define reusable metrics and dimensions across multiple analytics use cases.
- Implemented complex SQL transformations to support business KPIs such as traffic, performance, and inventory metrics.
- Collaborated with backend and analytics teams to align data outputs with reporting and visualization requirements.
- Contributed to extract frameworks in Java, supporting reliable ingestion for downstream analytics pipelines.
- Optimized backend data logic to ensure consistency between source data and analytics layers.
Data Engineer Intern
Graas
08.2023 - 07.2024
- Built and maintained ELT pipelines using dbt, Snowflake, and Airflow to power analytics and reporting workflows.
- Designed fact and dimension tables to enable consistent and reusable analytics models.
- Implemented SQL-based transformations and dbt tests to ensure data accuracy and freshness.
- Contributed to migrating a single-tenant data architecture to a multi-tenant setup, improving scalability and maintainability.
Education
AI & Data Science
VISHWAKARMA UNIVERSITY
Pune01.2024
Skills
Analytics and data stack
- dbt (models, tests, incremental models, metrics)
- SQL (Snowflake)
- Airflow (orchestration and scheduling)
- ELT Pipelines & Data Transformations
Data engineering
- Dimensional modeling (fact and dimension tables)
- Metric & KPI Definitions
- Data Quality & Validation
- Multi-tenant Data Architecture
Programming
- Python (data processing, APIs)
- Java (backend integration, extract frameworks)
- GitHub / Version Control
- Visualization Library (FusionCharts, Highcharts)
Timeline
Software Engineer (Full-Time)
Graas
01.2024 - Current
Data Engineer Intern
Graas
08.2023 - 07.2024
AI & Data Science
VISHWAKARMA UNIVERSITY