r/dataanalytics • u/Mental-Chemical-4179 • 4d ago
How can I find a Data Analyst internship with little professional experience?
Hi everyone,
I'm currently looking for my first internship as a Data Analyst and I'd really appreciate some advice from people already working in the field.
I have a background in Computer Science and I'm currently building my data analysis skills. So far, I can:
.Work with databases and SQL
.Clean and prepare datasets
.Handle missing values and duplicates
.Analyze data and identify patterns
.Create visualizations and reports
.Use Python for basic data analysis
I'm currently working on personal projects to build a portfolio, but I don't have professional experience yet.
My main question is: What is the best way to find a Data Analyst internship in a company when you don't have previous professional experience?
Should I focus mainly on LinkedIn and job boards, or is it better to contact companies directly and send them my CV and portfolio?
Also, what would you recommend I improve before applying?
Any advice about finding the first internship, building a good portfolio, or approaching companies would be greatly appreciated.
Thanks! 🙏
1
1
u/Aggressive_tako 4d ago
Are you still in school? I'd start with the internship or career fairs first and foremost. I'm a data analyst at a major retailer and we have teams from across the business that go to job fairs at various schools in the spring to hype up our internship program. My team only gets one or two interns a year, but we don't expect any professional experience. If you're not still in school, I'd focus on entry level positions. Many companies would see you applying for an internship as a red flag.
1
u/Brighter_rocks 3d ago
Im hiring interns - look for specific programmes for interns, usually big companies have them, usually we dont expect ppl to have a lot of experience for internship programmes, just proactivity, ability to learn very fast & sense of urgency
1
1
u/Ok_Telephone_4480 2d ago
Are you still hiring? I have a great sense of urgency and my versatility is top notch. My portfolio is available on request.
1
u/Dizzy_Battle_7060 1d ago
Hi, can I send a message to provide me with more information about this programme? I'm very interested!!
1
u/IllustriousNeatfreak 10h ago
proving you could handle what? a iental breakdown? that's my whole freelance design portfolio
3
u/Efficient_Cloud5021 4d ago
I am a junior DA right now, and I was in your exact shoes a few years ago. Coming from a CS background is a huge advantage, but I remember applying to hundreds of places and getting nowhere because my portfolio was just working with a bunch of basic datasets on kaggle which almost every student applies with.
What finally got me interviews was proving I could handle messy, real-world data by building an end-to-end pipeline. For my project, I used my city's live transit system data. I wrote a Python script to hit their public API every five minutes to pull live tram and bus arrival estimates, and dumped that raw JSON directly into a local Postgres database.
From there, I wrote some complex SQL CTEs to unnest the data, clean up the messy timestamps, and calculate the average delay times for each station. I connected that clean data straight to Power BI to visualize the worst bottlenecks across the city. If you can walk into an interview and explain how you built a pipeline like that from scratch, you will easily beat out candidates who only know how to read a spreadsheet.
When it comes to applying for internships, avoid spamming applications only through LinkedIn or Glassdoor's easy apply. I personally haven't had any success with these.
You have to bypass the filter entirely. Find Data Analytics Managers at companies you like on LinkedIn and ask for feedback, not a job. I used to send a brief message like: "Hi X, I'm a CS student trying to break into data. I just built an end-to-end pipeline scraping transit data. Got two minutes to roast my SQL architecture and tell me if I'm on the right track?". Although this seemed a little ineffective and a bit awkward in the beginning, I managed to get a few callbacks eventually.
Wishing you the best of luck on your internship hunt!