operations
Posted 4 hours agoData Operations Analyst Intern
at Instawork
Bengaluru, IndiaOn-site
Responsibilities
- Build and maintain Excel workbooks for FO route planning, territory coverage, and visit schedules. •
- 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.
Requirements
- Our AI-powered labor marketplace helps local businesses scale, and enables global technology companies to push the frontiers of robotics and AI.
- This is a fully onsite internship with clear deliverables, performance incentives, and regular feedback.
- If you enjoy working with data in Excel, have strong attention to detail, and want hands-on exposure to operations at a fast-growing marketplace-this role is for you. Key Responsibilities •
- Required Skills (Must-Have) •
- Microsoft Excel: Intermediate-advanced: VLOOKUP/XLOOKUP, INDEX-MATCH, pivot tables, conditional formatting, data validation, named ranges, SUMIFS, COUNTIFS, IF, date logic. •
- Spatial / route thinking: Grouping locations by proximity, zones, or drive time; basic understanding of territories and visit sequencing. •
- 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. •
- Understanding of US/Canada metro markets or multi-city territory design. Sample Deliverables •
- We’re a curious bunch, and with AI transforming our workplace we encourage everyone to learn from each other, compounding our knowledge and
- We work long, hard, and smart, building products that delight our users and drive growth. Your ability to impact Instawork is limited only by your courage and conviction, not your job description. About Instawork