Data analyst internships are a good way into tech, finance, healthcare, retail, and almost any company that collects data, which is most of them. I work in product growth at Meta and spend most of my day in SQL and dashboards, so this is the advice I would give a student who wants that kind of job. The bar is lower than people think. You need a few core skills, one or two projects that prove them, and a lot of applications.
Learn the skills interns actually use
Most analyst internship postings ask for the same short list. Focus on these before anything else:
- SQL: joins, group by, window functions, and filtering. This is the most important skill by far.
- Spreadsheets: pivot tables, lookups, and basic charts in Excel or Google Sheets.
- One visualization tool: Tableau, Power BI, or Looker Studio. Pick one and get comfortable.
- Basic statistics: averages vs medians, percent change, and what an A/B test is.
- Python or R: helpful, but many internships treat it as a bonus. Learn pandas basics if you have time.
You do not need machine learning for an analyst internship. If you can pull data with SQL, clean it, and explain what it means in plain words, you are already ahead of most applicants.
Build one project that answers a real question
Recruiters want proof you can work with messy data. A good project starts with a question, uses a real public dataset, and ends with a clear answer.
Some ideas:
- Which neighborhoods in your city had the most 311 complaints last year, and why?
- How did prices change for a product you buy often?
- Which songs, games, or teams grew the most over five years?
Write up the project in a short README or blog post: the question, the data, the SQL or code you used, one or two charts, and what you found. Keep it short enough that someone can read it in two minutes. Put the link at the top of your resume.
Make your resume about results
Analyst resumes get skimmed fast. Each line should show a tool and an outcome. For example:
- Built a Tableau dashboard tracking club membership, used by 5 officers each week
- Wrote SQL queries on a 200k-row public dataset to find the top drivers of late deliveries
If you have no work experience, class projects, research help, and club roles all count. Anything where you counted, tracked, or reported on something belongs on there.
Practice the interview
Data analyst intern interviews usually have three parts:
- A SQL screen. Expect questions like "find the top 3 products by revenue in each month." Practice on free SQL problem sites until joins and window functions feel easy.
- A case or product question. For example, "daily active users dropped 10% yesterday, what would you check?" Walk through it step by step: is the data right, is it one platform or region, did something launch or break.
- A behavioral round. Have two or three short stories ready about a time you used data to make a decision or fixed a mistake.
Talk out loud while you solve problems. Interviewers care about how you think as much as the final answer.
Apply wider than the big names
Big tech and banks get the most applications. There are many more analyst internships at hospitals, insurance companies, retailers, sports teams, city governments, and mid-size software companies. Titles vary too, so search for business analyst, data analyst, analytics, business intelligence, operations analyst, and marketing analyst internships.
To find them, I Got An Internship is a free internship search tool that pulls openings straight from about 2,200 employer career pages across the US and Canada. Search for analyst internships in your city and you will see companies that never post on the big job boards.
Timing
Large companies and banks open summer analyst internships as early as July and August of the year before. Most other companies hire between January and April. If you are reading this in the fall, apply to the big programs now and keep a list of smaller companies to check every week through spring.
A simple plan
- Learn SQL first, then one visualization tool
- Build one project on a real public dataset and write it up
- Keep your resume to one page with tools and results on every line
- Practice SQL questions and one product case each week
- Apply to 50 or more roles across different industries and titles
Author bio: Amney Mounir is a Product Growth Analyst at Meta, founder of Dataford, and creator of I Got An Internship. He shares career and data content with more than 85,000 followers on LinkedIn. This article reflects his personal views.
Top comments (0)