Data Operations Analyst Intern

Ovii's Interpretation of the Role

Instawork seeks a detail‑oriented Operations Data Analyst Intern to support the Field Operations team. You will build and maintain Excel‑based route and territory plans, clean and validate location data, and deliver daily and weekly planning sheets that enable field teams to work efficiently.

Role Snapshot

• Build & maintain Excel route‑planning workbooks
• Clean & validate operational location data
• Create territory maps using Excel and mapping tools
• Track coverage gaps and flag issues
• Incorporate FO feedback to improve plans
• Deliver daily & weekly planning sheets

Must-Have 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
• Excel data analysis
• Route planning and territory design

Nice-to-Have Signals

• 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
• Google Sheets / Power Query
• Mapping tools
• Basic SQL

Work Setup

• Location: Bengaluru, India
• Work mode: ONSITE
• Employment type: Intern

Not Specified in JD

• Salary range
• Visa sponsorship
• Remote eligibility
• Education requirement
• Certifications
• Travel

What You'll Likely Work On

• Build and maintain Excel workbooks for route planning, territory coverage, and visit schedules
• Clean, validate, and organize location and operational data such as addresses, zones, and market tags
• Create route maps and territory layouts using Excel tables, pivots, conditional formatting, and mapping tools
• Support route optimization by grouping stops by geography, time windows, and field‑operations capacity
• Produce daily and weekly planning sheets that detail who visits where, in what order, and with what targets
• Track coverage gaps, flag issues to the FO lead, and maintain documentation of assumptions and version history
• Incorporate feedback from field operations and managers to improve plan accuracy and usability

Good Fit If You Have

• Strong attention to detail and data‑hygiene mindset
• Clear written communication through spreadsheets
• Comfort working with large datasets and geographic grouping
• Interest in logistics or field‑operations planning