Data Operations Analyst Intern
Core
Build and maintain Excel workbooks and route maps to support Field Operations teams in planning territories, visit schedules, and coverage gaps.
Role type
Operations Data Analyst Intern
Builds
Route maps, territory layouts, and weekly/daily planning sheets for Field Operations
Domain
Labor marketplace operations / logistics planning
Deliverable
product features
Required skills
Microsoft Excel (VLOOKUP/XLOOKUP, INDEX-MATCH, pivot tables, conditional formatting), data hygiene (sorting, deduplication, standardization), spatial/route thinking (grouping by proximity, zones, drive time), attention to detail
Preferred skills
Google Sheets, Excel Power Query, mapping tools (Google My Maps, QGIS), basic SQL, logistics or operations planning experience
Technologies
Microsoft Excel, Google Maps, Google My Maps, QGIS
Responsibilities
Build and maintain Excel workbooks for FO route planning and territory coverage; Clean, validate, and organize location and operational data; Create route maps and territory layouts; Support route optimization by grouping stops; Produce weekly and daily planning sheets; Track coverage gaps and flag issues; Maintain documentation of assumptions and data sources
Seniority
Intern
