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 HERE 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.