Positions Available: 2 Students

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.

Project Scope

1) Context Setting - Gain familiarity with the information technology ecosystem of Werrv’s supply chain, specifically including the dataflows from distributors and manufacturers and Werrv’s storefront on Shopify.

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

3) 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.

4) Bonus - If time permits, 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) Introductory Meeting - At the commencement of the project, candidates will be provide with additional background material and engage in an introductory on-line, discussion about WERRV goals, project priorities and opportunities. Candidates are encouraged to ask questions and pitch ideas to maximize their results.

2) Chat/On-line Meetings- Students can ask questions, pitch ideas, request feedback and communicate anything required via chat, screen sharing, on-line, etc. as frequently as required to maintain momentum and maximize results. Timely responses will be provided - generally within minutes or hours and rarely more than 24 hours.

3) Project Milestone Updates- Project update summaries against milestones can be provided by e-mail on a periodic (weekly, or as deemed mutually appropriate given the timelines and feedback will be provided as required.