JOB SUMMARY:The Pricing + Publications Administrative Support provides support to ensure the ongoing maintenance and integrity of pricing and item data in our ERP system (Iptor). In addition, they perform the administrative functions required for the production of publications materials. They will enter data into Excel spreadsheets, the ERP system, and portals as required and perform some basic functions using various software programs. They are also responsible for communicating and tracking advertising outreach via email. Meeting strict deadlines, following procedures, and ensuring information is accurate are critical aspects of this position.
MAIN RESPONSIBILITIES:Item Maintenance:

• Data entry of information on all new items (sku's).
• Follows item (sku) discontinuation process.
• Updates all information on an ongoing basis.
• Uploads various forms and information.

Pricing:

• Creates Excel spreadsheets with pricing data for our Monthly Specials.
• Enters special pricing information into the ERP system for Planners and Flyers.
• Enters other special deals as generated by the Sales Team, within deadlines.
• Enters information into on-line portals and various forms.
• Creates specific price files for designated accounts and back-up for other accounts.
• Enters price files information into the ERP system.
• Acquires knowledge and understanding of the workflow and pricing schedule.

Publications Administrative Support:

• Exports mailing lists from QlikView system and distributes various reports and publications according to schedule.
• Uploads various files to FTP server daily.
• Formats, updates, consolidates and prepares excel data files for monthly specials and catalogues at various stages of the workflow.
• Writes HTML emails for various publications and performs updates.
• Supports the mailout of biannual catalogue. Orders mailing supplies, confirms policy pages and beverage container programs.
• Updates data sources for several files pertaining to catalogue and pricing information.
• Creates annual Master Supplier Promotional Excel File.
• Performs weekly updates to Master Supplier Promotional Excel File. Responsible for maintaining file.
• Provides vacation and other coverage for various colleagues in pricing and/or publications as needed.

Other Duties:

• Advertising outreach and tracking for various publications.
• Other duties as assigned.

QUALIFICATIONS + EXPECTATIONS:

• Post-secondary education, training, or a minimum 2 years of pricing, accounting or administrative experience in a business environment or equivalent combination of education and experience.
• Computer literacy, including MS365 and proprietary ERP system.
• Advanced Excel skills and experience with VLOOKUP, pivot tables, formatting, and formulas.
• Advanced data entry skills and attention to detail.
• Mathematical skills including calculations, formulas and cost related considerations; and the ability to follow processes and procedures.
• Strong analytical and problem-solving abilities.
• Ability to follow instructions with detailed steps.
• Ability to work autonomously, work under tight deadlines and manage multiple tasks simultaneously.
• Strong communication skills, both verbal and written.
• Open to learning new software programs as required.
• Ability to adapt effectively to change and shift tasks and priorities when needed.
• Experience with Dreamweaver, Photoshop and HTML preferred.

COMPENSATION + WORKING CONDITIONS:This is either a full-time or part-time position, working out of our office in South Burnaby. There is a possibility of a hybrid work schedule available. The starting rate for this role is $25.31/ hour.
We provide an extended medical, dental, and salary insurance package after three (3) full months of employment. Eligibility is based on a minimum number of hours worked.
Vacation pay is accrued at 6%, and 3-weeks' vacation time after the first year of employment. We have one Roving Stat (personal day) per year, and onsite parking.
PERKS + CULTURE:Focus on Wellness:

• Extended Medical + Dental (company-paid premiums).
• Disability, Life and AD&D insurances.
• EFAP immediately upon hire.
• Generous paid time off (3 weeks' vacation and personal day).
• Paid sick time, including dependent sick time for those with children (up to 13 days per year).
• Fitness + Well-being Subsidy.
• Discounted grocery and wellness products and lunch program.
• On-site gym.
• Dog friendly office.
• Scent-free environment.

Focus on our Community:

• Partnerships with Quest Food Exchange and The Downtown Eastside Women's Centre.
• Paid volunteer hours.

Focus on the Environment:

• Transit Subsidy - up to 100%.
• Shuttle Service from/to 22nd SkyTrain station.
• Cycling Subsidy.
• Indoor bike lock up area.
• Recycling + Composting Program, including multiple zero-waste boxes.
• Partnership with Urban Impact.

APPLICATION INFORMATION:Please apply with your resume listing relevant experience. Must be located in the Lower Mainland and be able to commute to our location.
Horizon is an equal opportunity employer valuing diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, ancestry, colour, place of origin, gender, gender identity, age, religion, disability, family status, sexual orientation, or any other status or characteristic protected by law. If you require assistance or a reasonable accommodation in any aspect of the application process, please contact the People + Culture department.
About Horizon Grocery + Wellness:

Horizon Grocery + Wellness is a leading distributor of organic and natural foods, household products, supplements, and natural personal care items, servicing thousands of locations across Western Canada. We thrive as a market leader via effective partnerships and primary relationships with our valued retailers and suppliers. We are a privately owned, 100% Canadian company with a 150,000 square foot Grocery facility and a 40,000 square foot Wellness facility located in south Burnaby, BC. Horizon Grocery + Wellness is the cornerstone of the Horizon Group, a privately held, Canadian-owned group of companies with distribution facilities servicing over 6000 customers across Canada.