Data Operations Analyst Intern
Instawork
Bengaluru, Karnataka, IndiaonsitePosted 2 months ago
Skill Required
RoboticsData AnalystbuildingExceldesignSparkAPIsSQLGoAIInternship
Key highlights
- Fully onsite Operations Data Analyst Intern role with performance incentives.
- Must have intermediate‑advanced Excel skills (VLOOKUP/XLOOKUP, pivot tables, etc.).
- Daily and weekly planning responsibilities include updating files and refreshing route maps.
- Intern will produce territory assignment sheets, weekly route plans, coverage dashboards, and master location files.
- Regular feedback and clear deliverables provided.
- Company emphasizes empathy, bias for action, continuous learning, and ownership.
Role overview
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.
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) as directed.
- 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 (uncovered businesses, overdue visits, imbalanced territories) 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.
- Daily: Update planning files from latest operational data; fix errors flagged by FOs.
- Weekly: Refresh route maps and territory balances; submit summary of changes and open gaps.
- Quality bar: Plans must be accurate, reproducible, and easy for a non-analyst FO to follow.
- Territory assignment sheet: businesses to FO to zone to visit cadence.
- Weekly route plan: ordered stop list per FO with estimated time/distance notes.
- Coverage dashboard: % of accounts visited, gaps by market, overdue visits.
- Master location file: validated addresses, geocodes (if available), market tags.
Requirements
- Microsoft Excel: Intermediate-advanced: VLOOKUP/XLOOKUP, INDEX-MATCH, pivot tables, conditional formatting, data validation, named ranges, SUMIFS, COUNTIFS, IF, date logic.
- Data hygiene: Sorting/filtering large datasets, deduplication, standardizing addresses/zones, spotting inconsistencies.
- Spatial / route thinking: Grouping locations by proximity, zones, or drive time; basic understanding of territories and visit sequencing.
- Attention to detail: Accurate data entry, cross-checking outputs, catching errors before plans go to the field.
- Communication: Clear notes in spreadsheets; ability to explain how a route or territory was built.
- Reliability: Meet deadlines; follow templates and SOPs; respond to revision requests quickly.
Nice to have
- Experience with Google Sheets or Excel Power Query for imports and refreshes.
- 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.
- Understanding of US/Canada metro markets or multi-city territory design.
Benefits
- Fully onsite internship with clear deliverables.
- Performance incentives.
- Regular feedback.
- In‑person collaboration (working together five days a week).
- Encouragement of diverse perspectives; applications from candidates of all backgrounds welcomed.
- Company values that promote empathy, bias for action, continuous learning, and ownership.
Additional details
- 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.
- Backed by world‑class investors like Benchmark, Spark Capital, Craft Ventures, Greylock, Y Combinator, and others.
- Our Values: Empathy, Trust & Candor; Bias for Action; Always Be Learning; Act Like an Owner.
- 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.
- Our AI‑powered platform serves thousands of businesses across more than 50 major markets in the United States and Canada.
- Instawork has been featured by CBS News, The Wall Street Journal, The Washington Post, and the Associated Press. Forbes included us on their Next Billion Dollar Startups list; RetailTech Breakthrough named us Workforce Hiring Solution of the Year for 2025; and Inc. 5000 recognized us as one of the country's top 10% fastest‑growing companies two years in a row.
- We have hubs in San Francisco, Bangalore, and Chicago, city offices in New York, Phoenix, and Singapore, and we are back to working together in‑person five days a week because we believe the best ideas happen when great people collaborate face‑to‑face.
- Personnel Privacy Policy.