Saurabh Jain
Senior Business Intelligence Engineer
Redmond,WA
Summary
Senior Business Intelligence Engineer with over 17 years of experience in crafting scalable analytics solutions, robust data architectures, and machine learning-powered insights platforms. Proven ability to transform complex business challenges into actionable intelligence through advanced BI tools, statistical modeling, and data-driven experimentation. Highly proficient in Tableau, QuickSight, and Redshift, consistently delivering self-service analytics that drive measurable business impact. Recognized for building resilient data pipelines, spearheading cross-functional analytics initiatives, and mentoring BI teams to achieve excellence.
Overview
17
17
years of professional experience
2
2
Certificates
Work History
Senior Business Intelligence Engineer | Rufus Analytics
Amazon
07.2024 - Current
- Built end-to-end analytics infrastructure combining traditional BI with ML-driven insights to optimize Rufus customer experience and experimentation.
- Designed and implemented customer analytics dataset integrating query behavior, performance metrics, and engagement patterns across 200M+ monthly queries.
- Created recurring 'annoyance queries' metric using NLP analysis, serving as a critical guardrail for 13+ product experiments.
- Developed Tableau dashboards and QuickSight reports enabling product teams to track query-level performance and customer satisfaction trends.
- Applied BERTopic-based topic modeling with BERT embeddings to extract 10,000+ recurring topics, identifying emerging customer themes and pain points.
- Built token-based similarity models (Jaccard and cosine similarity) to score 'When to Show Rufus' opportunities, achieving 34% performance lift.
- Currently integrating customer-driven metrics with APT platform for automated experiment-level performance tracking.
- Established repeatable analytics framework that positioned Rufus Analytics as the intelligence backbone for product decisions.
- Enabled systematic understanding of customer query diversity through interactive BI tools and ML insights.
Senior Business Intelligence Engineer | Subscribe & Save (SnS)
Amazon
03.2024 - 07.2024
- Architected enterprise-scale, self-service reporting platform serving 300,000 sellers and 11,000 vendors with unified analytics.
- Designed multi-layer reporting architecture: Redshift (data warehouse) → Datamarts (semantic layer) → S3 (pre-calculated metrics) → QuickSight (key-value visualization).
- Built dimensional data models for subscription analytics enabling consistent metric definitions across all reporting surfaces.
- Created Tableau cross-reporting platform visualizing customer segments by Subscriptions/User, Revenue/User, Units/User, and ASP and many others.
- Developed QuickSight dashboards with on-demand drill-down capabilities for vendor and seller performance analysis.
- Built custom segmentation framework integrated directly into Weblabs, enabling segment-level experiment analysis.
- Reduced report latency by 20% through optimized data modeling and pre-aggregation strategies.
- Analyzed 100+ experiments using segment-based reporting, driving targeted product improvements.
Data & Analytics Manager | Product Replenishment
Amazon
03.2022 - 03.2024
- Led BI team transformation, standardizing analytics practices and building scalable reporting infrastructure across Product Replenishment.
- Managed team of 5 Business Intelligence Engineers and Data Engineers, establishing design-first, execute-fast culture.
- Created standardized ETL SOPs (Datanet, Cradle) and reusable Tableau templates, reducing development time by 30%.
- Mentored BIEs on advanced Tableau techniques, data modeling best practices, and stakeholder engagement.
- Architected 5-layer unified data architecture consolidating fragmented reporting systems across the organization.
- Built foundational components: Subscription Data Models, semantic Data Marts, and standardized metric definitions.
- Developed action-oriented tools including Revenue Coverage Tracker, Metrics Heartbeat Monitor, and Data Quality Notifiers.
- Improved reporting delivery efficiency by 30% and reduced redundant work by 20% through standardization.
- Increased stakeholder satisfaction by 20 basis points through improved data quality and delivery speed.
- Established data modeling practices recognized across Amazon BI community as organizational benchmark.
Senior BIE / BIE | Product Replenishment
Amazon
07.2019 - 03.2022
- Partnered with SDE and ML teams to model operational data into ANDES, creating dimensional models for Amazon-wide systems.
- Built ETL pipelines and ingestion architecture for external seller/vendor reporting, improving data availability by 40%.
- Developed rule-based segmentation models in Tableau enabling targeted customer analysis.
- Mentored junior BIEs on SQL optimization, Tableau best practices, and dimensional modeling techniques.
Senior Analytics and BI Consultant
Thorogood Associates
01.2016 - 07.2019
- Delivered Power BI framework analyzing natural resource management, generating $100M annual savings through optimized supply chain and resource allocation dashboards.
- Built OLAP cubes and Tableau reporting architecture for pharmaceutical product performance tracking.
- BI & Analytics Consultant | Bengaluru, India
Senior Data Architect
Prowareness India
07.2013 - 01.2016
- Architected enterprise data warehouse for Netherlands' Pension Fund Organization using star schema and slowly changing dimensions.
- Built automated reporting pipelines reducing metric onboarding time from weeks to days.
- Created QlikView dashboards for fund performance, member analytics, and regulatory reporting.
- Data Architect | Bengaluru, India
Senior Data Advisor
Dell International Services
07.2010 - 07.2013
- Built and managed Dell.com data warehouse supporting product analytics, sales reporting, and customer behavior analysis.
- Developed SQL-based ETL processes and Tableau dashboards for executive reporting.
- Business Advisor | Bengaluru, India
Database Engineer
Verizon Inc
07.2008 - 07.2010
- Developed OLTP database systems and stored procedures supporting Verizon.com order fulfillment operations.
- Database Developer | Bengaluru, India
Education
Bachelor of Technology - Electrical Engineering
Indian Institute of Technology (BHU)
Varanasi, India05-2008
Skills
Tableau proficiency
QuickSight analytics expertise
Power BI proficiency
Interactive reporting skills
Data analysis and visualization
Data-driven metrics creation
Redshift
S3
ETL/ELT Pipelines
Data Modeling
Semantic Layers
Data Quality Frameworks
ML Integration
NLP
Statistical Analysis
A/B Testing
Customer Segmentation
Predictive Modeling
SQL
Python
BERTopic
BERT implementation skills
Accomplishments
- Built 3 enterprise-scale BI platforms at Amazon serving 300K+ users
- Designed 5-layer unified data architecture adopted as Amazon BI best practice
- Improved reporting efficiency by 30% through standardization and automation
- Delivered $100M in annual savings through Unilever analytics framework
- Mentored 10+ Business Intelligence Engineers to senior roles
- Analyzed 100+ A/B experiments driving product optimization decisions
Certification
Machine Learning University ML Certifications - Basic ML Models
Timeline
Senior Business Intelligence Engineer | Rufus Analytics
Amazon
07.2024 - Current
Senior Business Intelligence Engineer | Subscribe & Save (SnS)
Amazon
03.2024 - 07.2024
Data & Analytics Manager | Product Replenishment
Amazon
03.2022 - 03.2024
Senior BIE / BIE | Product Replenishment
Amazon
07.2019 - 03.2022
Senior Analytics and BI Consultant
Thorogood Associates
01.2016 - 07.2019
Senior Data Architect
Prowareness India
07.2013 - 01.2016
Senior Data Advisor
Dell International Services
07.2010 - 07.2013
Database Engineer
Verizon Inc
07.2008 - 07.2010
Bachelor of Technology - Electrical Engineering
Indian Institute of Technology (BHU)