IMPORTANT: OPEN TO FILIPINO CITIZENS WHO ARE CURRENTLY RESIDING IN THE PHILIPPINES Position: Reports Analyst
Working hours: A bit more flexible – 9 am - 5 pm EST Mon-Fri, but Sun-Thurs opposite hours might also work.
Holiday/s: US and/or PH holidays
Salary Range: USD 1,000 - 1,500/month
About the company: Building enduring brands at the intersection of real estate and retail.
About the role: Work directly with the Director of Operations to provide various reports and
administrative support. Work can be done off-hours of 9 am-5 pm EST but needs to
have work completed by 9 am EST daily Sunday through Thursday
Duties and responsibilities: Develop a comprehensive suite of reports on business performance & insights both in retail and partnerships. Condense large data sets into clear and concise reports, observations, and recommendations. Provide insights in a timely manner to better inform strategic decision-making. Provide research and analytical support on additional assigned projects. Assist with administrative tasks as required. Examples of work to complete on a weekly, biweekly & monthly basis Weekly (Mon/Tues for previous week) Compile reports Weekly Report with sales metrics comparing to LW or LY per location best sellers & low performing SKUs in assortment per location New Customers Report (where the source) per location Session Origin Report (source of session) per location Promotional & discount performance via different channels (online sales, in-store, newsletter) Prepare weekly suggested orders based on the "Never Out Of Stock" List & previous weeks through (by Fri PM for Dundas & Wed PM for Hamilton) Calculate approx payroll from the week prior Weekly Admin as needed Assist with updating products in Cova & Shopify (optimize images before uploading, adding new SKUs, updating prices/sale prices, etc) Assist with entering order POs & uploading to Cova/Shopify Bi-Weekly Monitor Innovation/new SKUs performance in assortment (sell through within a week-two weeks = good seller) Cross-reference IRCC/Canna Collective Brand Offers to load in promotional stock (can help in choosing promotional SKUs for next month) Compile Bi-Weekly Data Reports for partner brands Monthly Compile suggested delisting SKUs based on low velocity (no sales in 30-60 days) Create monthly accessory report per location with suggested reorders per location via multiple vendors Assist in quarterly reconciliation reporting for finance Requirements Well-versed in compiling data from multiple sources to reflect in-store and online channel results Comfortable with adapting to multiple systems to gather and compile data Software proficiency requirement:
Google Analytics/G4 (Traffic Data) - REQUIRED Shopify (inventory, Reporting/Sales Data, Promotional) - REQUIRED Cova (Inventory, Reporting/Sales Data) - PREFERRED ONLY Headset (Sales Data) - PREFERRED ONLY Push (Sales/Labour Reporting) - PREFERRED ONLY Klaviyo (Newsletter Data/Sales & Traffic Reporting) - PREFERRED ONLY Slack (Communications) - PREFERRED ONLY Google Suite (Numbers/Excel for reporting purposes, Slides for presentations) - PREFERRED ONLY
