// hello world

Amita Sahoo

Senior Data Analyst · Analytics Engineer · GenAI-Driven Insights

7+ years turning messy data into decisions — $1.5M+ in measurable cost savings across 45M+ regulated records, with SQL, Python, Snowflake, dbt, and an increasing amount of GenAI (RAG, LangChain, OpenAI APIs) woven into the workflow.

View Projects Get in Touch
📍 San Jose, CA · Currently @ Uber

01 About

I'm a results-driven Senior Data Analyst and Analytics Engineer with experience across technology, financial services, and marketing. My work spans statistical analysis, data visualization, and self-service analytics — with deep expertise in SQL, Python, Tableau, Power BI, Snowflake, dbt, and Databricks.

I care about the full path from raw data to a decision someone actually makes: stakeholder management, executive reporting, A/B testing, cohort analysis, and dashboards that hold up under scrutiny. More recently, I've been integrating GenAI workflows — RAG, LangChain, and OpenAI APIs — into business intelligence to make analytics faster and more proactive, all inside Agile, cloud-native environments.

02 Skills

Analytics & Programming

Python (Pandas, NumPy, Scikit-learn, SciPy), SQL (Joins, CTEs, Window Functions), R, Scala, EDA, A/B Testing, Hypothesis Testing, Cohort & Funnel Analysis, Forecasting, CLV Modeling, Feature Engineering

Data Engineering & Pipelines

Apache Spark (PySpark), Airflow, Kafka, Databricks, dbt (Core & Cloud), Delta Lake, Apache Iceberg, ETL/ELT, Batch & Streaming, CDC, Azure Data Factory, Terraform

Databases & Warehousing

Snowflake, BigQuery, Redshift, PostgreSQL, SQL Server, Azure Synapse, Cosmos DB, Dimensional Modeling, Star Schema, SCD, Data Contracts

BI & Visualization

Tableau, Power BI, Looker, Looker Studio, Excel (Advanced), KPI Dashboards, Executive Reporting, Data Storytelling, ROI Analysis

Applied AI & GenAI

Retrieval-Augmented Generation (RAG), LangChain, LlamaIndex, Agentic Workflows, Prompt Engineering, OpenAI APIs, Azure OpenAI, Pinecone, ChromaDB

Cloud, DevOps & Governance

AWS, Azure, GCP, AWS Glue, CI/CD, Docker, FastAPI, AWS EKS, Great Expectations, Monte Carlo, Data Lineage, HIPAA Compliance, Data Mesh

03 Experience

Data Analyst / Data Engineer — Uber

May 2025 – Present · San Francisco, CA
  • Geospatial cohort analysis (Python/H3, AWS S3) to identify high-churn driver zones, contributing to reactivating 6,500 dormant drivers in a $680K reactivation initiative.
  • Automated executive reporting pipelines (SQL, Airflow, Snowflake, dbt), cutting a 5-day manual process to 2 hours.
  • A/B tested a GenAI support chatbot in R, refining LLM sentiment models that diverted 45,000 tickets and saved $180K/year.
  • Deployed an LLM agentic workflow (OpenAI APIs, LangChain) classifying 12,000+ monthly support requests, freeing 2 FTEs.

Data Analyst — Epsilon

Sep 2024 – Apr 2025 · Chicago, IL
  • Built PySpark/AWS Glue ETL pipelines, reducing processing latency by 4 hours and enabling same-day campaign reporting for 3 enterprise clients.
  • Executive Tableau dashboards surfacing $215K/month in optimization opportunities across a $3M+ annual budget.
  • Great Expectations data quality checks across 6 sources, cutting pipeline failures by 28/month.
  • K-Means customer segmentation across 8M+ records, reducing cost-per-acquisition by $18/lead.

Senior Data Analyst — Tata Consultancy Services

Jan 2021 – Aug 2022 · India
  • Optimized ETL pipelines (PySpark, Azure Data Factory) across 14 reporting suites, saving 60+ hours/month.
  • Built a centralized SQL Server warehouse (star schema, SCD Type-2) for 5 cross-functional teams.
  • 12 Power BI dashboards informing $500K in operational restructuring.
  • Predictive churn models (R, Scikit-learn) retaining 8,500 SMB clients worth ~$1.8M ARR.

Data Analyst, Financial Services & Tax Compliance — KPMG

Mar 2017 – Sep 2020 · India
  • Automated reporting via Alteryx/SQL, eliminating 140 hours/month and accelerating audit delivery by 18 business days.
  • Executive Tableau dashboards uncovering $1.2M in under-reported assets across 4 business units.
  • Anomaly detection scripts (SQL, VBA) surfacing $320K in reconciliation discrepancies pre-audit.
  • Established data governance, lineage, and PII frameworks in Azure.

04 Featured Projects

AirBnB CDC Ingestion Pipeline

Azure Data Factory · Cosmos DB · ADLS · Synapse · n8n · OpenAI · LangChain

Near-real-time CDC pipeline ingesting 5+ source entities at hourly refresh, with SCD Type-1 fact and 4+ dimension tables in Synapse. LLM automation via n8n and OpenAI auto-generates leadership-ready reports, saving 8 hours/week.

E-Commerce GenAI Product Assistant

LangChain · LlamaIndex · RAG · Pinecone · FastAPI · Docker · AWS EKS · CI/CD

Production-grade GenAI assistant using RAG for multi-turn product queries at sub-2-second latency, deployed via FastAPI/Docker/EKS with full CI/CD — cutting analyst resolution time by 4 hours/week.

BookMyShow Real-Time Streaming Pipeline

Azure Event Hubs · Stream Analytics · Synapse Analytics · JavaScript UDFs

Real-time booking/payment streaming pipeline generating CXO-ready insight emails from live Synapse metrics within 60-second latency windows.

More on GitHub

See all repositories on GitHub ↗

05 Education

Florida Institute of Technology

Master of Science (M.S.) in Computer Engineering · Aug 2022 – May 2024 · Melbourne, FL

Relevant coursework: Machine Learning, Data Mining, Cloud Computing, Statistical Analysis, Big Data Systems, AI & Deep Learning.

06 Contact

Open to conversations about data, analytics engineering, and GenAI-powered BI. Reach out any time.

✉ amita.sahoo173@gmail.com in linkedin.com/in/amitasahoo ⌥ github.com/sahooamita