Data Operations Analyst Intern at Instawork

Analytics Associate
Bangalore, Karnataka
July 20, 2026
Internship
Apply Now

Job Description

Key Responsibilities

  • Build and maintain Excel workbooks for FO route planning, territory coverage, and visit schedules.
  • Clean, validate, and organize location and operational data (addresses, zones, markets, visit frequency, priorities).
  • Create route maps and territory layouts using Excel (tables, pivots, conditional formatting) and/or mapping tools (e.g., Google Maps).
  • Support route optimization by grouping stops by geography, time windows, and FO capacity.
  • Produce weekly and daily planning sheets for FOs: who visits where, in what order, and with what targets.
  • Track coverage gaps and flag issues to the FO lead.
  • Maintain documentation of assumptions, data sources, and version history for planning files.
  • Incorporate feedback from FOs and managers to improve accuracy and usability of plans.

Required Skills

  • Microsoft Excel: Intermediate-advanced: VLOOKUP/XLOOKUP, INDEX-MATCH, pivot tables, conditional formatting, data validation, SUMIFS, COUNTIFS, IF, date logic.
  • Data hygiene: Sorting/filtering large datasets, deduplication, standardizing addresses/zones.
  • Spatial/route thinking: Grouping locations by proximity, zones, or drive time.
  • Attention to detail: Accurate data entry, cross-checking outputs, catching errors.
  • Communication: Clear notes in spreadsheets; ability to explain how a route or territory was built.
  • Reliability: Meet deadlines; follow templates and SOPs.

Nice-to-Have Skills

  • Experience with Google Sheets or Excel Power Query.
  • Familiarity with mapping tools (Google My Maps, QGIS, or route APIs).
  • Basic SQL or comfort exporting from dashboards/CSVs into Excel.
  • Prior work in logistics, field sales, delivery routing, or operations planning.

About Instawork

Founded in 2015, Instawork is the nation’s leading online labor marketplace for food services, hospitality, light industry, and logistics, connecting more than 7M skilled workers with local restaurants, hotels, warehouses, stadiums, and more. With hubs in San Francisco, Bangalore, and Chicago, Instawork has been featured by CBS News, The Wall Street Journal, The Washington Post, and the Associated Press.

Instawork is on a mission to create meaningful economic opportunities for skilled hourly professionals in communities around the globe. Our AI-powered labor marketplace helps local businesses scale, and enables global technology companies to push the frontiers of robotics and AI.

We are looking for detail-oriented Operations Data Analyst Interns to support Instawork’s Field Operations (FO) team. You will work with operational data—markets, territories, business locations, worker coverage, and visit schedules—to build and maintain route maps and planning spreadsheets that help FOs run efficiently in the field. This is a fully onsite internship with clear deliverables, performance incentives, and regular feedback.

 

Related Jobs