Headline

Data Engineer | Analytics Engineer | BI Engineer (Business Intelligence) Building ETL pipelines on AWS (S3, Athena, Redshift) · Azure Synapse · Databricks · Spark · SQL · PySpark · QuickSight · Python | ex-Amazon/BCG

About

🎓I’m a master’s graduate in Information Management from the University of Illinois Urbana-Champaign, with a foundation in Electronics Engineering from Mumbai University. 💼I worked as a Business Intelligence Engineer at Whole Foods Market (Amazon), focusing on cross-banner analytics for Amazon Fresh and WFM. My work involved building ETL pipelines, transforming data using AWS tools and Spark SQL, and delivering insights through Redshift and QuickSight dashboards. 🧠 Earlier, I gained hands-on experience as a Data Engineer Intern at BCG, where I built scalable data pipelines using Azure Synapse and Data Lake, designed ER diagrams, and implemented data quality checks with PySpark. 🔧 I began my career at Capgemini as an Automation Engineer, where I worked on backend API automation with AWS and Node.js, implemented CI/CD pipelines, and built reusable testing frameworks while collaborating with cross-functional teams. 📊 Across all these roles, I’ve been driven by one constant: using data to solve problems, improve systems, and enable smarter business decisions through clean pipelines and impactful dashboards. I am now seeking full-time opportunities in Data Engineering and Analytics, where I can bring my technical skills and problem-solving mindset to help organizations scale their data capabilities. 📫 Let’s connect! GitHub: github.com/surbhi-bhor Email: work.surbhibhor@gmail.com Portfolio: surbhi-bhor.github.io/portfolio

Location

Bengaluru

AI stack

claude code

Guardrails AI

OpenAI Agents SDK

Replicate

Work experience

Data engineer at Calimontex technologies, Jan 2026 - Aug 2026 · 7 mo, Austin

Business Intelligence Engineer at Whole Foods Market, Dec 2024 - Aug 2025 · 9 mos, Austin, Texas, United States, Supplier Marketing Analytics: Led a data initiative to enable end-to-end visibility into supplier marketing performance across Amazon.com and Whole Foods Market. - Built efficient ETL pipelines using internal AWS tools (Andes, S3, Cradle, Redshift) and Spark SQL, reducing processing time by 35% and optimizing query performance - Developed interactive QuickSight dashboards to visualize KPIs like sales lift, YoY growth, and NTB, enabling data-driven supplier strategy decisions Returns Analytics—WFM Stores: https://www.wholefoodsmarket.com/amazon/in-store-pickup-and-returns - Created QuickSight dashboard for WFM Parcel Program (Pickup/Returns) to monitor key metrics: total returns, same-day basket conversion, return type, YoY trends, and store capacity

HP Tech Ventures Corporate Venture Capital & Business Analytics at Extern, Oct 2024 - Oct 2024 · 1 mo, - Analyzed startup metrics, business models, and industry benchmarks to drive data-backed investment recommendations - Conducted market research and mapping to evaluate product differentiation and competitive positioning, and identify high-potential startups aligned with HP Tech Ventures’ strategy

Course Assistant at The Grainger College of Engineering, Jan 2024 - May 2024 · 5 mos, MCS CS411: Database Systems 1. Evaluated & graded homework and quizzes on the coursework spanning a wide range of topics, including: - SQL queries and subqueries - Database design, SQL DDL, and ERD (Entity-Relationship Diagrams) - Stored procedures, constraints, and triggers - Functional dependencies and normalization - Transactions and serializability - NoSQL databases such as MongoDB and Neo4j 2. Assisted in managing in-class group discussion sessions, fostering engaging and productive learning environments, ensuring accuracy, and providing constructive feedback to students. 3. Collaborated closely with professor, course assistants, and teaching assistants to support a diverse student body with 500+ individuals enrolled in the MCS program.

Course Assistant at University of Illinois at Urbana-Champaign, School of Information Sciences, Aug 2023 - Dec 2023 · 5 mos, MCS CS598: Foundations of Data Curation 1. Worked collaboratively with professor, course assistants, and teaching assistants to optimize the Online MCS program on the Coursera platform. 2. Evaluated and graded assignments for over 50 students per assignment, covering diverse topics such as relational schema design, entity-relationship diagramming, XML Schema Design, Ontology Development, and Canonicalization. 3. Conducted in-depth ER diagram data analysis on 350+ assignment submissions, researching the various notations employed by students and identifying the most prevalent notation trends.

Data Engineer at Boston Consulting Group (BCG), Jun 2023 - Aug 2023 · 3 mos, New York City Metropolitan Area, • Designed and implemented Azure Synapse data pipelines to streamline ETL processes and ensure smooth transition across various layers. • Curated a substantial dataset into a staging Hive table using ADLS and data warehousing techniques, resulting in the creation of an SCD1 delta table and a significant reduction in data discrepancies. • Introduced data quality validation procedures with PySpark notebooks, for the early detection and resolution of critical issues, strengthening data integrity. • Evaluated and selected the most suitable ERD migration tool from a range of options, facilitating improved real-time collaboration and saving valuable time, and delivered client presentation for the same • Performed comprehensive data modeling for a complex domain spanning 15 diverse tables, translating intricate concepts into an intuitive ER diagram and enhancing understanding through the strategic creation of data flow diagrams for multiple pods.

Software Engineer in Test at Capgemini, Sep 2020 - Jun 2022 · 1 y 9 mo, Mumbai

Education

Master's degree, Information management, University of Illinois Urbana-Champaign

Bachelor of Engineering - BE, Electronics Engineering, University of Mumbai