Data Operations Analyst Intern

Data Operations Analyst Intern 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. About the Role 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. 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 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. 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. 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. Sample Deliverables 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. Expectations 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. Our Values Empathy, Trust & Candor 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. Bias for Action 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! Always Be Learning 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. Act Like an Owner 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 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. We're not just helping fill shifts, we're supporting local economies—and we're just getting started! 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. 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. Ready to make an impact? Learn more at www.instawork.com/about . Personnel Privacy Policy Experience Level Entry Level