Business Analyst Intern

We operate two 24/7 network operations centers and a security operations center, staffed in three shifts.

The internship:

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote position. Most of the team is in New York City, but nobody is required to come in. Normal working hours, Monday to Friday. We send you a laptop and the accessories you need on day one.

Day to day:

Create charts and short slide decks for the monthly review call. Document metric definitions so everyone calculates churn and conversion the same way. Prepare the weekly MIS report and send it to the team lead every Monday. Build and update dashboards in Power BI, Tableau or Looker Studio. Answer ad hoc data requests from sales and support within a day or two. Maintain the data dictionary and keep dashboard filters up to date. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.

What we're looking for:

Available 40 hours a week for the full internship. Based in the US for the duration of the internship. Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028. Authorized to work in the US. CPT and OPT candidates are welcome to apply. Laptop with Excel or Google Sheets and a stable internet connection. Clear written English for reports and status updates. Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

Preferred:

Experience with Google Analytics 4 or Mixpanel. Prior project with real business data from a college club, family business or freelance client. Google Data Analytics or Microsoft PL-300 certification.

What you get out of it:

Top interns are considered for a junior analyst opening. How business metrics like CAC, churn and retention are actually calculated. Writing SQL against a real production warehouse. You will build at least one dashboard that managers use every week.

Duration: 12 weeks

Start date: Summer 2027

Stipend: $30.50 - $35.50 per hour

Perks:

Learning and development stipend. Final presentation to leadership. Mentorship from a dedicated buddy and manager. Paid sick time. Home office setup stipend. Company laptop.

Duration: 12 weeks. Start: Summer 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Patel Networks.