Pricing/Publications Administrative Support

Horizon Grocery + Wellness; Burnaby; On-site; CAD 30,000 - 60,000; Full time

Job summary

A leading company in the wellness industry is seeking a Pricing + Publications Administrative Support to ensure data integrity and assist in administrative tasks. Responsibilities include data entry, pricing updates, and supporting public outreach for their departmental operations. This position offers flexibility in work hours and a friendly company culture focused on wellness and community engagement.

Benefits

Extended Medical + Dental

Paid sick time

Vacation pay accrued at 6%

Fitness + Well-being Subsidy

On-site gym

Discounted grocery products

Paid volunteer hours

Transit Subsidy

Shuttle Service

Cycling Subsidy

Qualifications

• Minimum 2 years of pricing, accounting or administrative experience.
• Computer literacy in MS365 and ERP systems.
• Strong attention to detail and ability to work under deadlines.

Responsibilities

• Data entry of pricing information into ERP and Excel.
• Supports production of publications and manages mailing lists.
• Tracks advertising outreach and performance.

Skills

Data entry

Advanced Excel

Analytical skills

Communication skills

Problem-solving

Education

Post-secondary education

Tools

Excel

QlikView

Dreamweaver

Photoshop

Job description

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.