Data Operations Analyst Intern

<div class="content-intro"><p>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, we’re looking for exceptional talent to reimagine the way the world works.</p></div><p id="p-rc_4227a30f71c1435a-49" data-path-to-node="5"><span data-path-to-node="5,0"><strong data-path-to-node="5,0" data-index-in-node="0">About the Role</strong> </span><span data-path-to-node="5,2"><span class="citation-143">We are looking for detail-oriented Operations Data Analyst Interns to support Instawork's Field Operations (FO) team. </span></span><span data-path-to-node="5,5"><span class="citation-142">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. </span></span><span data-path-to-node="5,8"><span class="citation-141">This is a fully remote internship with clear deliverables, performance incentives, and regular feedback. </span></span><span data-path-to-node="5,11"><span class="citation-140">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. </span></span></p> <p data-path-to-node="6"><strong data-path-to-node="6" data-index-in-node="0">Key Responsibilities</strong></p> <ul data-path-to-node="7"> <li> <p id="p-rc_4227a30f71c1435a-50" data-path-to-node="7,0,0"><span data-path-to-node="7,0,0,1"><span class="citation-139">Build and maintain Excel workbooks for FO route planning, territory coverage, and visit schedules. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-51" data-path-to-node="7,1,0"><span data-path-to-node="7,1,0,1"><span class="citation-138">Clean, validate, and organize location and operational data (addresses, zones, markets, visit frequency, priorities). </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-52" data-path-to-node="7,2,0"><span data-path-to-node="7,2,0,1"><span class="citation-137">Create route maps and territory layouts using Excel (tables, pivots, conditional formatting) and/or mapping tools (e.g., Google Maps) as directed. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-53" data-path-to-node="7,3,0"><span data-path-to-node="7,3,0,1"><span class="citation-136">Support route optimization by grouping stops by geography, time windows, and FO capacity. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-54" data-path-to-node="7,4,0"><span data-path-to-node="7,4,0,1"><span class="citation-135">Produce weekly and daily planning sheets for FOs: who visits where, in what order, and with what targets. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-55" data-path-to-node="7,5,0"><span data-path-to-node="7,5,0,1"><span class="citation-134">Track coverage gaps (uncovered businesses, overdue visits, imbalanced territories) and flag issues to the FO lead. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-56" data-path-to-node="7,6,0"><span data-path-to-node="7,6,0,1"><span class="citation-133">Maintain documentation of assumptions, data sources, and version history for planning files. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-57" data-path-to-node="7,7,0"><span data-path-to-node="7,7,0,1"><span class="citation-132">Incorporate feedback from FOs and managers to improve accuracy and usability of plans.<br><br></span></span></p> </li> </ul> <p data-path-to-node="8"><strong data-path-to-node="8" data-index-in-node="0">Required Skills (Must-Have)<br></strong></p> <ul data-path-to-node="9"> <li> <p data-path-to-node="9,0,0"><strong data-path-to-node="9,0,1,0" data-index-in-node="0"><span class="citation-131">Microsoft Excel:</span></strong><span class="citation-131"> Intermediate-advanced: VLOOKUP/XLOOKUP, INDEX-MATCH, pivot tables, conditional formatting, data validation, named ranges, SUMIFS, COUNTIFS, IF, date logic.</span></p> </li> <li> <p data-path-to-node="9,1,0"><strong data-path-to-node="9,1,1,0" data-index-in-node="0"><span class="citation-130">Data hygiene:</span></strong><span class="citation-130"> Sorting/filtering large datasets, deduplication, standardizing addresses/zones, spotting inconsistencies.</span></p> </li> <li> <p data-path-to-node="9,2,0"><strong data-path-to-node="9,2,1,0" data-index-in-node="0"><span class="citation-129">Spatial / route thinking:</span></strong><span class="citation-129"> Grouping locations by proximity, zones, or drive time; basic understanding of territories and visit sequencing.</span></p> </li> <li> <p data-path-to-node="9,3,0"><strong data-path-to-node="9,3,1,0" data-index-in-node="0"><span class="citation-128">Attention to detail:</span></strong><span class="citation-128"> Accurate data entry, cross-checking outputs, catching errors before plans go to the field.</span></p> </li> <li> <p data-path-to-node="9,4,0"><strong data-path-to-node="9,4,1,0" data-index-in-node="0"><span class="citation-127">Communication:</span></strong><span class="citation-127"> Clear notes in spreadsheets; ability to explain how a route or territory was built.</span></p> </li> <li> <p data-path-to-node="9,5,0"><strong data-path-to-node="9,5,1,0" data-index-in-node="0"><span class="citation-126">Reliability:</span></strong><span class="citation-126"> Meet deadlines; follow templates and SOPs; respond to revision requests quickly.</span></p> </li> </ul> <p data-path-to-node="10"><strong data-path-to-node="10" data-index-in-node="0">Nice-to-Have</strong></p> <ul data-path-to-node="11"> <li> <p id="p-rc_4227a30f71c1435a-64" data-path-to-node="11,0,0"><span data-path-to-node="11,0,0,1"><span class="citation-125">Experience with Google Sheets or Excel Power Query for imports and refreshes. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-65" data-path-to-node="11,1,0"><span data-path-to-node="11,1,0,1"><span class="citation-124">Familiarity with mapping tools (Google My Maps, QGIS, or route APIs). </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-66" data-path-to-node="11,2,0"><span data-path-to-node="11,2,0,1"><span class="citation-123">Basic SQL or comfort exporting from dashboards/CSVs into Excel. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-67" data-path-to-node="11,3,0"><span data-path-to-node="11,3,0,1"><span class="citation-122">Prior work in logistics, field sales, delivery routing, or operations planning. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-68" data-path-to-node="11,4,0"><span data-path-to-node="11,4,0,1"><span class="citation-121">Understanding of US/Canada metro markets or multi-city territory design. </span></span></p> </li> </ul> <p data-path-to-node="12"><strong data-path-to-node="12" data-index-in-node="0">Sample Deliverables</strong></p> <ul data-path-to-node="13"> <li> <p id="p-rc_4227a30f71c1435a-69" data-path-to-node="13,0,0"><span data-path-to-node="13,0,0,1"><span class="citation-120">Territory assignment sheet: businesses to FO to zone to visit cadence. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-70" data-path-to-node="13,1,0"><span data-path-to-node="13,1,0,1"><span class="citation-119">Weekly route plan: ordered stop list per FO with estimated time/distance notes. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-71" data-path-to-node="13,2,0"><span data-path-to-node="13,2,0,1"><span class="citation-118">Coverage dashboard: % of accounts visited, gaps by market, overdue visits. </span></span></p> </li> <li> <p id="p-rc_4227a30f71c1435a-72" data-path-to-node="13,3,0"><span data-path-to-node="13,3,0,1"><span class="citation-117">Master location file: validated addresses, geocodes (if available), market tags. </span></span></p> </li> </ul> <p data-path-to-node="14"><strong data-path-to-node="14" data-index-in-node="0">Expectations</strong></p> <ul data-path-to-node="15"> <li> <p data-path-to-node="15,0,0"><strong data-path-to-node="15,0,1,0" data-index-in-node="0"><span class="citation-116">Daily:</span></strong><span class="citation-116"> Update planning files from latest operational data; fix errors flagged by FOs.</span></p> </li> <li> <p data-path-to-node="15,1,0"><strong data-path-to-node="15,1,1,0" data-index-in-node="0"><span class="citation-115">Weekly:</span></strong><span class="citation-115"> Refresh route maps and territory balances; submit summary of changes and open gaps.</span></p> </li> <li> <p data-path-to-node="15,2,0"><strong data-path-to-node="15,2,1,0" data-index-in-node="0"><span class="citation-114">Quality bar:</span></strong><span class="citation-114"> Plans must be accurate, reproducible, and easy for a non-analyst FO to follow.</span></p> </li> </ul><div class="content-conclusion"><p><strong><span style="font-size: 14pt;">Our Values&nbsp;</span></strong></p> <ul> <li> <p><strong><span style="text-decoration: underline;">Empathy, Trust &amp; Candor</span><br></strong>We put ourselves in the shoes of our colleagues and customers and don’t shy away from uncomfortable conversations, instead building trust through honest and direct feedback.</p> </li> <li> <p><strong><span style="text-decoration: underline;">Bias for Action</span><br></strong>We practice high-velocity decision-making, clear-eyed that we often operate with incomplete information. Growing quickly means it’s OK to be wrong, so long as we learn from our mistakes and course correct!</p> </li> <li> <p><strong><span style="text-decoration: underline;">Always Be Learning</span><br></strong>We’re a curious bunch, and with AI transforming our workplace we encourage everyone to learn from each other, compounding our knowledge and experience to help us change an entire industry.</p> </li> <li> <p><strong><span style="text-decoration: underline;">Act Like an Owner</span><br></strong>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.</p> </li> </ul> <p><strong><span style="font-size: 14pt;">About Instawork</span></strong></p> <p>Founded in 2015,&nbsp;<a href="https://www.instawork.com">Instawork</a> 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. We're not just helping fill shifts, we're supporting local economies—and we're just getting started!</p> <p>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. But what matters most is our impact. We're solving real problems for real people, and we’re doing it at scale.</p> <p>Join our team to help us build something that matters! We’re looking for superstars who want to help us shape the future of work. With hubs in San Francisco, Bangalore, and Chicago, city offices in New York, Phoenix, and Singapore, we're back to working together in-person five days a week because we believe the best ideas happen when great people collaborate face-to-face. We also value diverse perspectives and encourage applications from candidates of all backgrounds.<br><br>Ready to make an impact? Learn more at <a href="http://www.instawork.com/about">www.instawork.com/about</a>.</p> <p><a href="https://info.instawork.com/legal/california-personnel-privacy-policy">Personnel Privacy Policy</a></p> <p>&nbsp;</p></div>