Data Analyst Intern

About us

Everything runs on a single Rails app and one Postgres database, deployed on Heroku. On-call rotates weekly and pays a flat stipend whether or not the pager goes off.

The internship

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote position. Most of the team is in Marseille, but nobody is required to come in. We ship you a laptop and accessories before your first day.

Day to day

• Create charts and short slide decks for the monthly review call
• Track marketing campaign results using Google Analytics 4 data
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Prepare the weekly MIS report and send it to the team lead every Monday

Requirements

• Based in France for the duration of the internship
• Available for the full internship period
• Currently enrolled in a bachelor's or master's degree, graduating 2027
• Laptop with Excel or Google Sheets and a stable internet connection
• Comfort with numbers and strong attention to detail
• Basic SQL, enough to write SELECT queries with joins and filters
• Must be able to follow up on data requests without constant reminders
• A sample dashboard or analysis project you can share
• Available 20 to 40 hours a week, Monday to Friday

Bonus points

• Python with pandas for data cleaning

What you get out of it

• Writing SQL against a real production warehouse
• Top interns are considered for a junior analyst opening

Duration: 5 months

Start date: Immediately

Stipend: €1,050-€1,250/month

Perks

• Possibility of a full-time offer
• Flexible hours
• Paid public holidays
• Internet allowance
• Mentorship
• Company laptop

Duration: 5 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Lucas Software EURL.