Data Analyst Intern - Spring 2027

Second-generation ownership: the founder's daughter runs the agency now. We're looking for a Data Analyst Intern - Spring 2027. Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote, open to candidates across the US. Normal working hours, Monday to Friday. We use Slack, Notion and Google Meet. Cameras on for team calls.

The work:

• Document metric definitions so everyone calculates churn and conversion the same way.
• Check numbers across sources and flag mismatches before reports go out.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Answer ad hoc data requests from sales and support within a day or two.

Requirements:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Available 40 hours a week for the full internship.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Comfort with numbers and strong attention to detail.

4 months, starting Spring 2027. Stipend: $31.50 to $32.50 per hour.

Perks: Company laptop, Home office setup stipend, Mentorship from a dedicated buddy and manager, Learning and development stipend, Return offer opportunities, Paid company holidays.

Duration: 4 months. Start: Spring 2027.

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