We are looking to work with a creative and ambitious student or group of students to automate the extract, transform and load (ETL) of our supply chain data from multiple sources. At completion, the result will be automatic ETL of data from our distributors, including inventory and product updates and feeding cleaned data into the backend of our Shopify store. Ideally, the process can be automated so that it runs several times a day automatically. If time permits, merging data with manufacturers data sources will also be done. The work is continuing the work completed in Phase 1.

Project Scope

1) Data Mapping – recommended data mapping has already been documented but should be confirmed based on first hand assessment.

2) Development - Using Power Query or suitable mutually agreed alternative, create a robust and supportable ETL program that transforms data and merge it from multiple sources into normalized, high valued information ready for loading into the store.

3) Bonus - The student will be given the opportunity to work with Shopify’s GraphQL API to load the data into the store backend.

Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

1) All work can be done remotely, using on-line services for all aspects of the engagement (project deliverables, file sharing, communications, meetings, etc.).

2) Students are responsible for following current Covid-19 protocols and maintaining a safe work environment for themselves and others. This includes Covid-19 safety, but extends to all aspects of workplace safety.