Integrate and Transform Supply Chain Data Automatically Phase 2
Preferred learners
- Anywhere
- Academic experience or paid work
Categories
Skills
Project scope
- What is the main goal for this project?
-
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.
- What is the main goal for this project?
-
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.
- What tasks will learners need to complete to achieve the project goal?
-
No deliverables exist for this project.
About the company
- https://werrv.ca/
- 2 - 10 employees
- Retail, Automotive, Travel & tourism
Werrv ( https://werrv.ca/ ) is an entrepreneurial Canadian company with the goal of disrupting and transforming the aftermarket parts and services industry for recreational vehicles (RVs), boats and recreationally watersports. Werrv serves Canadians from coast to coast and US Customers in the lower 48 states.
Our mission is to help people enjoy their best life while experiencing the great outdoors.
Werrv seeks to engage ambitious and entrepreneurial students to want engaging, challenging, referenceable and rewarding experiences to develop and demonstrate their full potential and workforce readiness. If you're intrigued by #vanlife, even better... Let's make things happen. Check our consistent 5-star ratings on Riipen Feedback.