AVAILABLE FOR ANALYTICS & DATA ROLES

Hi, I'm Tanay Jujarao

Data Analyst building automated, production-grade data pipelines & executive dashboards.

Transitioning into Analytics Engineering. Specializing in transforming raw multi-source data into clean Medallion architecture models using Snowflake, dbt, Airflow, SQL, and Python, paired with high-impact Tableau & Power BI visual reporting.

Tanay Jujarao

Tanay Jujarao

Analytics Engineering Nanded, Maharashtra, India
CORE MISSION

"Transforming raw, multi-source enterprise data into automated ELT data pipelines, statistical inferences, and dollar-value business decisions."

Turning Messy Multi-Source Data into Quantified Outcomes

I am a Data Analyst transitioning into Analytics Engineering with a deep passion for modern data stack tooling. My work sits at the intersection of robust data transformation (dbt Core, Snowflake, Apache Airflow), statistical experimentation (A/B testing, hypothesis testing), and executive visualization (Tableau, Power BI).

Whether it's building Bronze/Silver/Gold layered architectures to automate retail analytics or conducting cohort analyses that recover $853K in annual churn revenue, I focus on building reliable, self-service data systems that drive real dollars.

500K+
User Sessions & Order Records Analyzed
3.16x
ROI Delivered on Customer Interventions
$853K
Annual Churn Revenue Recovery Modeled
$9.6M
Sales Tracked via Star-Schema Dashboards

Technical Expertise & Toolset

Grouped across data engineering, statistical inference, visualization, and cloud tooling.

Languages & Querying

SQL (CTEs, Window Functions, Joins) Python (Pandas, NumPy) MySQL

Data Engineering

Snowflake dbt (Models, Seeds, Macros, Tests) Apache Airflow AWS S3 Medallion ELT Architecture SCD Type 2 Snapshots

Analysis & Statistics

A/B Testing Two-Proportion Z-Test Chi-Square Tests Welch's t-test Cohort Analysis RFM Modeling Churn & ROI Analysis

BI & Visualization

Power BI (DAX, Power Query) Tableau (LOD Expressions) Star-Schema Data Modeling MS Excel (Pivot, Power Query)

Libraries & ML

Scikit-Learn SciPy & Statsmodels Matplotlib XGBoost Cross-Validation

Workflow & Tools

Git / GitHub Jupyter Notebook VS Code Automated Data Testing

Featured Projects

Highlighting end-to-end data pipelines, statistical experimental design, and quantified financial impact.

Other Selected Projects

Statistical experimentation, executive BI dashboards, and sports analytics.

A/B Testing Analysis Experiment

A/B Testing Analysis — Website Background

Statistical experiment on ~5,000 sessions using Two-Proportion Z-Tests and Welch's t-tests, validating a +160.5% conversion lift (p < 0.001).

Python Statsmodels SciPy
GitHub Repo
Classic Model Cars Sales Dashboard

Classic Model Cars — Sales Dashboard

Transformed 8 relational tables into a Power BI star-schema data model with DAX measures, surfacing $9.6M in sales and 39.8% profit margin.

Power BI DAX Power Query
GitHub Repo
IPL Crunch Cricket Analytics

IPL Crunch — Cricket Analytics

Interactive Python & Streamlit analytics application performing deep-dive exploratory analysis on IPL player statistics and match outcomes.

Python Pandas Streamlit
GitHub Repo

Technologies & Tools

Core platforms and frameworks powering my analytics engineering workflow.

Python
SQL / MySQL
Snowflake Logo
Snowflake
dbt Core Logo
dbt Core
Apache Airflow Logo
Apache Airflow
AWS S3 Logo
AWS S3
Power BI Logo
Power BI
Tableau Logo
Tableau
Pandas / NumPy
Git & GitHub
Jupyter Logo
Jupyter
Excel Logo
MS Excel

Methodologies & Approach

Principles that guide how I build reliable, production-grade analytics systems.

Medallion ELT Architecture

Structuring data transforms into Bronze (raw), Silver (cleansed & tested), and Gold (analytics marts) layers using dbt Core and Snowflake.

Statistical Rigor & Testing

Evaluating business experiments with hypothesis testing, Two-Proportion Z-Tests, Chi-Square randomization checks, and Welch's t-tests.

Dollar-Value ROI Modeling

Translating customer churn and order patterns into direct financial revenue outcomes, intervention payback, and ROI calculations.

Executive-Ready BI

Designing star-schema data models, custom DAX measures, and LOD expressions in Power BI & Tableau for instant stakeholder clarity.

Certifications

Data Analytics Job Simulation

Deloitte Australia

Industry analytics workflow, reporting automation, and stakeholder communication.

View Certificate ↗
Nov 2025

Python for Data Science

IBM

Python, Pandas, NumPy, data manipulation, cleaning, and visualization.

View Certificate ↗
Jan 2026

GenAI Powered Data Analytics Simulation

TATA

AI-assisted analysis, prompt engineering, and business problem-solving.

View Certificate ↗
Dec 2025

Intermediate Machine Learning

Kaggle

XGBoost, Scikit-Learn Pipelines, target encoding, and cross-validation.

View Certificate ↗
Apr 2026

Education

CURRENT DEGREE

Bachelor of Computer Application (BCA)

SSBES ITM — Institute of Technology and Management
1st Year Student • 2026 – 2029

Focusing on computer science fundamentals, data structures, relational database management systems (RDBMS), SQL query optimization, and software development methodologies.

LOCATION

Nanded, Maharashtra, India

Let's Build Data Systems Together

Open to Data Analyst, Junior Analytics Engineer, and Data Engineering roles. Let's connect to discuss how I can help build your data pipelines and dashboards.