Summer data engineering internship 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.

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.