Summer data engineering internship challenge
Model a messy retail dataset and defend your schema choices.
What each place wins
- 1st place3 winners
Interview nomination
Data Engineering Intern
Skips to the technical round
Internship3 nominationsClaimable for 30 days after results
An opportunity to interview, not an offer of employment. The hiring decision stays with the company.
Your work stays yours
The organizer may view, store and judge what you submit. Nothing else. Entering does not transfer copyright or any other right in your work, whether you win or not.
About this challenge
We will give you three years of anonymised transaction data from a retail chain, exported by four different systems that disagree with each other about almost everything.
Build a warehouse schema for it, load it, and answer six business questions with SQL. We care more about how you handle the disagreements than about how fast the queries run.
This one is aimed at students and recent graduates. The top three enter our internship interview process directly.
Rules
Open to students and graduates of the last two years.
Any warehouse. Bring your own compute or use the free tier of anything you like.