Data Analyst Intern (Summer 2027)

Most clients live within an hour's drive and come in for reviews twice a year. Founded in 1982 by an advisor who left a large brokerage to go independent.

About the role:

Remote internship for a student who likes spreadsheets and is not scared of messy data. This role is fully remote within the US. Monday to Friday, regular working hours, flexible start and finish. Equipment is provided, including a laptop.

Responsibilities:

• Create charts and short slide decks for the monthly review call
• Analyse funnel drop-offs and summarise findings in a one-page note
• Prepare the weekly MIS report and send it to the team lead every Monday
• Maintain the data dictionary and keep dashboard filters up to date
• Track marketing campaign results using Google Analytics 4 data
• Answer ad hoc data requests from sales and support within a day or two
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery

Who can apply:

• Available 40 hours a week for the full internship
• Based in the US for the duration of the internship
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028
• Some familiarity with Power BI or Tableau, even from a course or certification
• Comfort with numbers and strong attention to detail
• A sample dashboard or analysis project you can share
• Basic SQL, enough to write SELECT queries with joins and filters
• Available 20 to 40 hours a week, Monday to Friday

Preferred:

• Prior project with real business data from a college club, family business or freelance client

What you'll learn:

• How business metrics like CAC, churn and retention are actually calculated
• Writing SQL against a real production warehouse
• Top interns are considered for a junior analyst opening

Duration: 10 weeks

Start date: Summer 2027

Stipend: $32.50 to $37.00 per hour

What we offer:

• Paid company holidays
• Flexible hours
• Return offer opportunities
• Home office setup stipend
• Learning and development stipend
• Paid sick time

Duration: 10 weeks. Start: Summer 2027.

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