Price Administrator

Job Title
Price Administrator
Job Summary
The Pricing Administrator reports to the VP of Marketing and will be located in Camarillo, CA. This position will be responsible for implementing and updating the company’s pricing in Microsoft Dynamics CRM system. A significant part of this work will be using Microsoft Excel.
Essential Functions
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Accurately maintain Johanson price files for all 1.8 million part numbers.
  • Actively participate with the implementation team on the Microsoft Dynamics CRM system.
  • Prepare/update procedures for price management in the system
  • Support the sales team in creating new price files and loading these into the system.
  • Help identify and assist with system enhancements.
  • Provide technical support to end users, diagnosing and resolving pricing problems.
  • Monitor data quality, data migrations, and data integration.
  • Ensure pricing information in our system is always accurate.
  • Capable of following Company and Department procedures/policies.
Knowledge, Skills & Abilities
  • Excel
    • Exploding a price summary sheet into ten thousand or twenty thousand part numbers and correctly assigns prices to each of those part numbers.
    • Create Macros to aid in creating the individual part number / price list.
    • Ensure thorough and accurate pricing for all part numbers.
    • Configuring this spreadsheet for import into our CRM system.
    • Competence in pivot tables to summarize data for management.
  • Microsoft Dynamics CRM
    • Importing these into our Microsoft CRM system
    • Running a Microsoft Power Automate process to revise/update pricing on part numbers.
    • Create procedures and techniques to maximize CRM use and minimize time required to enter or update data.
    • Participate in implementation team meetings and take a leadership role (working closely with the VP of Marketing) on the implementation of the Microsoft Dynamics CRM system
  • Establish rapport with sales teams and other departments to ensure a sense of team in training, all assignments and daily operations.
  • Proven track record of successfully working autonomously, while enjoying the opportunity to work on team-based tasks and projects
  • Proven experience in a global environment working with numerous Johanson locations
  • Strong/proven problem solving skills across multi-disciplinary skill sets and ability to function in a start-up environment
  • Strong ability to effectively prioritize competing requests, while keeping lines of communication open and the sales team satisfied
  • Strong knowledge of Microsoft Office 365 Tools
  • SharePoint experience a plus
  • Excellent English written, verbal and presentation skills
Supervisory Responsibility
This position has no supervisory responsibilities.
Responsibility for Confidentiality
The information in our business systems is company confidential and is not to be sold, taken or shared with any third parties.
Work Environment
This job operates in a manufacturing/ production environment. This role occasionally uses standard office equipment such as computers, phones, photocopiers.
Physical & Mental Demands
The physical and mental demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
  • The employee is regularly required to sit; use hands to handle or feel and talk or hear.
  • The employee is frequently required to reach with hands and arms.
  • The employee is occasionally required to stand; walk and stoop or kneel, crouch, or crawl.
  • Must understand and follow a set of clear oral and/or written procedures without deviation
  • Works with little need for guidance or reliance on oral or written instructions.
  • Must adhere to a provided work schedule to meet a set of qualitative production standards.
  • Free to plan work assignments and schedule to meet long-term goals and objectives.
  • Performs a wide range of tasks as dictated by variable demands and changing conditions.
  • Must work with diverse groups to obtain consensus on complex issues.
  • Must independently apply abstract principles to solve complex conceptual issues.
  • Implements others’ decisions/procedures with little judgement required.
  • Must write email and procedures / scripts to explain complex issues.
  • Persuade or explain complex issues in person or by phone.
Position Type/Expected hours of work
This is a full-time non-exempt position. Forty or more (40+) hours within a workweek.
None - Travel is not required for this position.
Required Education and Experience
  • Bachelor’s Degree in Business Administration or similar industry.
  • Minimum 2 years of experience managing pricing or product information.
  • Experience with information transfer between excel and a database ideally Microsoft Excel VLOOKUP and Pivot tables.
Preferred Experience
  • Bachelor’s Degree Information Technologies, Business Administration, or Accounting.
  • Advance Knowledge in Microsoft Excel VLOOKUP, Pivot tables and macro creation/troubleshooting
  • Microsoft Dynamics CE (CRM) Experience preferred
Additional Eligibility Qualifications
  • Proficient in Microsoft Suite (Outlook, Word, and PowerPoint).
AAP/EEO Statement
Johanson Technology Inc., and Johanson Dielectrics Inc. provides equal employment opportunity to all individuals regardless of their race, color, creed, religion, gender, age, sexual orientation, national origin, disability, veteran status, or any other characteristic protected by state, federal, or local law. Further, the company takes affirmative action to ensure that applicants are employed and employees are treated during employment without regard to any of these characteristics. Discrimination of any type will not be tolerated.
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job.
As an equal opportunity employer, Johanson Technology, is committed to a diverse workforce. If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation if you are unable or limited in your ability to use or access Johanson Technology’s career website as a result of your disability. You may request reasonable accommodations by contacting Human Resources 805-389-1166 and/or email us.
We offer a competitive compensation and benefit package which includes 100% employer-paid life insurance and excellent 401K match. If you want to be a part of this innovative team, send resume and salary requirements to: This email address is being protected from spambots. You need JavaScript enabled to view it.