Challenge: Data Engineering – Creating a Ecommerce Sales Data Mart – Design

LotsOfStuff, an ecommerce store, originally found success in South Africa, starting in a residential garage. By focusing on their business operations they have ended up with two headquarters - one in Johannesburg and the other in Lagos, Nigeria.

While LotsOfStuff is doing an excellent job of delivering value to their customers with speedy deliveries and great quality products, the company's data strategy has fallen behind!

You will play the role of lead data engineer to help build a sales data mart to help LotsOfStuff's team track sales volumes and values to support their reporting, and potential BI and data science use cases.