Johnstone's Corporate Headquarters, located in Portland, OR, provides services and benefits to our Cooperative Members who operate over 400 Johnstone stores nationwide. We are the nation's largest HVACR distribution Cooperative and our mission is to make business easy for the HVACR service and installation contractor. We partner with some of the world's largest companies, including Honeywell, Emerson, and Johnson Controls, to deliver the best brands in the industry to the best contractors.

Johnstone is looking for a Product/Pricing Assistant to creates, loads and maintains product and price information into various systems and databases to support locally sourced, special order, and stock numbered products.  Runs pivot table, data warehouse and defined SQL reports to assist product management, suppliers and stores with accurate and timely information.  Creates and maintains cooperative communications related to product, price and suppliers accurately and consistently across all media and systems. Researches issues and discrepancies as well as works other long and short term projects as required.  Supports efforts to improve, simplify and standardize department processes and procedures. 

Essential Job Results

1. Collect and maintain accurate and timely product and pricing information for product lines in all internal databases, transmissions and files.
2. Ensures product, supplier and pricing changes, additions, or deletions are effectively communicated to Members, Suppliers, Distribution Centers, and stakeholders within the Corporate Office by writing bulletins following company guidelines; uploading information; talking to stakeholders and writing informative emails.
3. Resolves price discrepancies by collecting and analyzing information such as order parameters, purchase orders and invoicing. Instructs Accounts Payable, Dropship or Warehouse personnel of corrective action to take.  Ensures discrepancies caused by inaccurate information are corrected in the system.
4. Makes changes in existing product specifications, such as pricing changes or discontinued items. Ensures that changes are documented, filed, and communicated to all stakeholders (i.e. Stores, Advertising, and Accounts Payable).  Completes files and forwards necessary paperwork.
5. Provides customer service to Stores and internal stakeholders by supplying information on products, pricing, or directing them to other resources.
6. Serves as a liaison between the Marketing department and Suppliers, Stores and other internal departments (Advertising, Distribution Centers, and Accounts Payable). Maintains timely, accurate communications with all stakeholders involved in a particular issue.
7. Assists with the collection of data for new vendors and products by emailing vendor contacts with spreadsheet template to enter new data; timely review completed vendor information for completeness and accuracy, follow-up with vendor as needed.
8. Updates and maintains all necessary product marketing and supplier information, including copy, artwork and other digital assets. Proofread flyers, bulletins, department correspondence, catalog ads, and product or Supplier paperwork for completeness and accuracy.
9. Maintains and updates a regional database of market intelligence by collecting and formatting data regarding market conditions, pricing and purchasing history. Assesses product performance and provide complete information for decision-making purposes.

Education and Experience:

Associate's degree (A.A.) or equivalent from two-year college or technical school; two years related experience and/or training; or equivalent combination of education and experience. 

Job-Specific Knowledge, Skills & Abilities: 

Mastery of the Microsoft Office Suite and other software and systems

• Excel – Advanced
• Word – Advanced
• Outlook - Advanced
• Access/SQL – Proficient
• PowerPoint – Proficient
• SharePoint – Proficient
• Data Warehouse
• Product Information Management (PIM) system - Enable
• Pricing - epaCUBE
• ERP – Infor SX.e

 Extremely detail oriented and organized

• Ability to pay attention to details –especially with numerical data (number recognition) and proofreading.
• Ability to recognize inconsistencies/errors in both text and numerical data
• Ability to recognize priorities and organize workload accordingly.
• Ability to manage work time to meet deadlines.
• Ability to work under multiple deadlines at one time.
• Ability to develop and use systems for organizing and keeping track of information.
• Ability to manage work time to meet deadlines including recognize priorities and organize workload accordingly.

Problem-solving and resolution skills: 

• Ability to listen, interpret, and meet the needs of others; diagnosing and rectifying problems.
• Ability to apply mathematical concepts such as basic algebra
• Ability to calculate margins, net profit/loss, discounts, commissions, and percentages
• Skill in adapting standard procedures to meet the requirements of a given situation.
• Skill in following-up with individuals, information, or processes until project completion.
• Ability to use a variety of tools in conducting market research, such as knowledgeable individuals, the Internet, and competitor or industry publications.

 Communication

• Ability to demonstrate considerable tact and diplomacy in dealing with others.
• Ability to write business correspondence and procedures.
• Skill in communicating with others to obtain information or assistance from them in a timely manner.
• Ability to interface with both internal and external stake holders in communicating information.
• Ability to communicate across different individuals, departments, and external parties.

Expected Work Behaviors:

• Ability to work with others in a team-based environment.
• Desire to support and meet the needs of customers, employees, and the Cooperative as a whole.
• Ability to manage changing priorities, deadlines and work under stressful conditions.
• Ability to accurately output a high volume of work while collaborating in a team-based environment.

Working for the Johnstone Corporate team has its rewards. We offer a competitive pay and benefits package, including:

Paid Time Off
Medical
Dental
Vision coverage
401(k) plan


We also take pride in creating a positive work environment where we work hard and accomplishments are recognized. At Johnstone you'll work with dedicated people that not only know their stuff, but also know how to have a little fun now and then!