Columbia University

Shubhangi Joshi

Business Intelligence Analyst

Columbia University MS graduate turning complex, multi-source data into clear, decision-ready insights — through BI dashboards, analytics frameworks, and scalable data pipelines.

3+
Years in data
10+
Dashboards built
5+
Pipelines & Data Models
Shubhangi Joshi

Hi, I'm Shubhangi.

I'm a Columbia University graduate with an MS in Management Science and Engineering (Dec 2025), and a Business & Data Analytics professional with experience building BI dashboards and analytics frameworks for internal decision-making.

I focus on turning complex, multi-source data into clear, decision-ready insights, whether that's engineering scalable ETL pipelines, building normalized measurement frameworks, or designing interactive dashboards that reduce manual reporting.

I've worked across business operations, consulting, sustainability, and product analytics at companies including Qlik, EY-Parthenon, and the International Rescue Committee.

$1.2M+
Quarterly spend tracked through real-time Qlik dashboards
200+
Campaigns and assets analyzed using attribution and normalization models
60%
Reduction in reporting turnaround time through automated dashboards
45%
Improvement in KPI accuracy through structured data modeling

Experience

Jun 2025 – Dec 2025
Business Operations Analyst, Intern
Qlik — New York, US
  • Developed & deployed a Qlik Sense budget tracking app delivering real-time visibility into $1.2M+ quarterly spend, improving financial planning accuracy by 30%.
  • Built scalable ETL pipelines normalizing multi-source Salesforce and Snowflake data, enhancing KPI accuracy by 45%.
  • Engineered 365-day normalization and attribution logic to measure ROI across 200+ campaigns and assets.
  • Designed toggle-based dashboards that reduced manual reporting by 60% and improved executive visibility into marketing pipeline performance.
  • Automated data ingestion via Qlik Automations, cutting dashboard refresh effort by 80%.
Qlik SenseQlik ScriptSnowflakeSalesforceSQL
Sept 2024 – May 2025
Graduate Product Consultant
EY-Parthenon — New York, US
  • Developed interactive Power BI dashboards visualizing procurement spend and supplier KPIs, helping identify inefficiencies and reduce operational costs by 15%.
  • Built automated data models and DAX measures integrating SQL and Excel data, improving accuracy and visualization performance by 35%.
  • Designed a standardized KPI reporting framework for five strategic projects, improving governance across sourcing, pricing, and supply operations.
  • Accelerated stakeholder decision-making turnaround by 25% by translating analytical findings into process roadmaps.
Power BIDAXSQLExcel
Sept 2024 – May 2025
Data Management Analyst
International Rescue Committee (IRC) — New York, US
  • Integrated sustainability data from Azuga, Egencia, and AMS into Tableau dashboards, reducing manual consolidation by 50% and improving real-time emissions tracking.
  • Enhanced the Humanitarian Carbon Calculator (HCC) by updating emission factors, increasing GHG reporting accuracy by 22% globally.
  • Built automated ETL pipelines and SQL workflows unifying 200+ climate indicators, cutting reporting turnaround by 60%.
TableauSQLETLSustainability Analytics
Oct 2023 – Mar 2024
Product Analyst
India Infoline Finance Limited — Mumbai, IN
  • Resolved 20+ product bugs via API testing in Postman, improving user engagement by 13%.
  • Enhanced the mobile ticketing feature through BRDs and sprint collaboration, driving 18% higher customer satisfaction.
  • Implemented A/B testing and KPI analytics in Power BI and Excel, increasing product engagement from 60% to 70%.
  • Conducted user research and performance diagnostics, boosting retention by 12%.
Power BIA/B TestingPostmanExcel

Skills

Languages

SQLPythonRQlik ScriptingDAX

BI & Visualization — 3+ years

Qlik SensePower BITableauLookerGoogle Data StudioExcel

Data & Cloud Platforms

SnowflakeSalesforceAWSQlik Automations

Analytics & Methodology — 1.5+ years

ETL / ELT PipelinesA/B TestingKPI AnalysisPredictive ModelingData MiningForecasting

Tools & Other

PostmanFigmaPowerPointCanvaWordPress

Soft Skills

LeadershipCommunicationAttention to DetailProblem SolvingCritical ThinkingDecision MakingInitiativeTime Management

Projects

📊
Financial Analytics · Business Operations
Travel & Expense Budget Analytics

Built an internal analytics solution to replace fragmented spreadsheet reporting with a centralized, interactive Qlik Sense dashboard — enabling real-time budget monitoring across teams and leadership groups, tracking $1.2M+ in quarterly spend.

📈
Marketing Analytics · Attribution
Content Effectiveness Analytics

Engineered a normalized, attribution-aware analytics framework to measure marketing content ROI across 200+ campaigns. Built a 365-day normalization model enabling fair comparison regardless of campaign duration or timing — integrating data from Snowflake and Salesforce.

🎯
Go-To-Market Analytics · Buyer Journey
Buying Agenda Analytics

Analyzed buyer intent signals and buying agendas to understand alignment with content engagement, opportunity creation, and pipeline progression — enabling GTM teams to move beyond surface-level metrics toward interpretable buyer readiness insights.

✈️
Product Management · APM Case Study
Duolingo Travel Mode

End-to-end PM case study proposing a new Duolingo product surface for high-intent travel moments — including user research, persona definition, MVP scoping, RICE prioritization, and a metrics-driven A/B experimentation strategy.

Education

Dec 2025
Master of Science, Management Science & Engineering
Columbia University — New York, US
Teaching Assistant: Data Analysis & Visualization · MA Thesis

Courses: Service Operations Management · Optimization & Simulation · Optimization Models & Methods · Probability, Statistics & Simulation · Operations Consulting · Stochastic Modeling · Corporate Finance, Accounting & Investment Banking · Tools for Analytics · Performance, Objectives & Results Using Data Analytics · Pricing Strategies · Supply Chain Analytics · Managerial Negotiations · Product Management
May 2024
Bachelor of Electrical Engineering
Mumbai University — Mumbai, IN
Leadership · TEDxTCET — Licensee & Chief Organiser · Co-curator · Digital Marketing Manager  |  ISTE (TCET) — Vice-Chairperson · Public Relations Specialist

Courses: Problem Solving Programming, Database Management System, Advanced Database Management System, Project Management, Information Systems, Internet Programming

Publications

IRJET
2023
Data Visualization Advances Business by Promoting Easy Storytelling and Informed Decision-Making Using Microsoft Business Intelligence
International Research Journal of Engineering and Technology (IRJET) · Vol. 10, Issue 10 · Oct 2023

Demonstrates how data visualization using Microsoft Power BI enhances decision-making across sales, marketing, and finance. Through domain-specific dashboards, shows how organizations can transform raw, fragmented data into actionable insights using effective visual storytelling.

Read paper →

Blog

View all on Substack →

Let's connect.

I'm always open to discussing data and analytics opportunities, collaborative projects, or just connecting over shared interests in BI and product analytics.