Business Analyst Intern - Summer 2027

Advertising sales teams work with local businesses and national agencies. Stations in California include network affiliates and independent stations.

About the role

This role is about accuracy first. A wrong number in a report is worse than a late one. This role is fully remote within the US. Flexible hours with a daily team call in the morning.

What you'll do

• Create charts and short slide decks for the monthly review call.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Track marketing campaign results using Google Analytics 4 data.
• Maintain the data dictionary and keep dashboard filters up to date.
• Check numbers across sources and flag mismatches before reports go out.
• Build and update dashboards in Power BI, Tableau or Looker Studio.

What we're looking for

• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Comfort with numbers and strong attention to detail.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027 or 2028.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Available 20 to 40 hours a week, Monday to Friday.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Basic SQL, enough to write SELECT queries with joins and filters.

Preferred

• Familiarity with DAX in Power BI.
• Experience with Google Analytics 4 or Mixpanel.

Duration: 10 weeks

Start date: Summer 2027

Stipend: $34.00 - $47.50 per hour

What we offer

• Final presentation to leadership.
• Mentorship from a dedicated buddy and manager.
• Learning and development stipend.

Please include a short note on why this role interests you.

Duration: 10 weeks. Start: Summer 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at The Fremont Times LLC.