Interview Questions
New Brew
Operations Intern (21+ years or older)

In a given week, your responsibilities range from updating financial models, to scheduling with external partners, to tracking inventory movement, to prepping decks for a marketing meeting. How do you prioritize and execute when everything is urgent?
In fast-paced environments like New Brew, I prioritize by impact and deadlines. First, I tackle time-sensitive data tasks—updating financial models and inventory trackers that affect immediate decisions, much like the real-time COGS spreadsheets I maintain for my e-commerce business. Next, I secure external partner schedules early in the week, drawing on my experience coordinating 20+ weekly appointments as a virtual assistant. For recurring tasks like marketing decks, I use pre-built templates to streamline work—a technique that saved me 5+ hours weekly when managing social media campaigns. I maintain flexibility by blocking 30-minute daily check-ins to reassess priorities using a simple 'Now/Next/Later' system, which helped me reduce missed deadlines by 80% across all my roles. This balanced approach ensures nothing slips through the cracks while keeping strategic goals on track.
New Brew
Operations Intern (21+ years or older)

Tell us about a time when maintaining accurate data was crucial to your role. How did you ensure the data stayed clean, up to date, and aligned across systems or teams?
Accuracy was critical when managing inventory for my multi-platform e-commerce business (Etsy/eBay/Poshmark). With 100+ SKUs across three platforms, I implemented a system that:
1) Automated Syncing: Used Google Sheets' IMPORTRANGE to create a master database that updated all listings in real-time, eliminating manual entry errors
2) Validation Protocols: Set up dropdown menus and data validation rules to ensure uniform product categorization (reduced listing inconsistencies by 90%)
3) Daily Reconciliation: Compared platform sales reports against bank deposits with conditional formatting to flag discrepancies immediately
For my virtual assistant role, I applied similar rigor when managing client databases - creating duplicate entry alerts and scheduled weekly audits. This system maintained 99.8% data accuracy across 50+ real estate listings and prevented double-bookings.
New Brew
Operations Intern (21+ years or older)

Walk us through a time when you built or managed a complex spreadsheet system to track operational or financial data.
Running my multi-platform e-commerce business (Etsy, eBay, Poshmark), I developed a master inventory spreadsheet that:
- Automatically syncs stock levels across all platforms using IMPORTRANGE functions
- Tracks 50+ SKUs with color-coded low inventory alerts (reduced stockouts by 40%)
- Generates weekly profit reports with pivot tables analyzing fees, shipping costs, and net margins
- Includes customer behavior tabs that correlate promotions with sales spikes
This system saves me 10+ hours weekly on operations while maintaining 99% inventory accuracy - skills I'd apply to streamline New Brew's data tracking.