VisaliaRecruiter Since 2001
the smart solution for Visalia jobs

Pricing Administrator - VLOOKUP Expert needed

Company: Johanson Technology, Inc.
Location: Stratford
Posted on: April 10, 2021

Job Description:

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.KEY RESPONSIBILITIES
    • 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.
    • 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 ResponsibilityThis position has no supervisory responsibilities. RESPONSIBILITY FOR CONFIDENTIALITYThe information in our business systems is company confidential and is not to be sold, taken or shared with any third parties. Work EnvironmentThis job operates in a manufacturing/ production environment. This role occasionally uses standard office equipment such as computers, phones, photocopiers. Physical AND MENTAL DemandsThe 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 WorkThis is a full-time non-exempt position. Forty or more (40+) hours within a workweek. TRAVELNone - 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 Education and 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

Keywords: Johanson Technology, Inc., Visalia , Pricing Administrator - VLOOKUP Expert needed, Other , Stratford, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Other Jobs

Now Hiring Nanny Needed For 1 Child In Fresno
Description: We need a nanny to take care
Location: Fresno
Posted on: 04/20/2021

Permit Specialist
Description: Overview: To undertake such a huge task, we need motivated people who want to make a difference. Right now, we are seeking a Permit Specialist that will be a solid contributor within Vivint Solar. As (more...)
Company: Sunrun Inc.
Location: Fresno
Posted on: 04/20/2021

Flexible Gig - Drive with Uber
Description: Drive with Uber and earn money anytime it works for you. Driving is an easy way to earn extra, and it's totally flexible around your schedule. You decide when and how much you drive. What you need to (more...)
Company: Uber
Location: San Joaquin
Posted on: 04/20/2021

Description: Job DescriptionDescription: MULTI-DISCIPLINARY CALIFORNIA PRACTICE SEEKS NEUROLOGIST We are seeking a Neurologist with specialized training in diagnosing
Company: Lags Spine and Sportcare Medical Centers Inc
Location: Fresno
Posted on: 04/20/2021

CDL-A Truck Driver - Walmart Transportation
Description: LOCATION McClellan Park, CA CAREER AREA Drivers Transportation JOB FUNCTION Driver EMPLOYMENT TYPE Full Time POSITION TYPE - REQUISITION 1442281BR What you'll do WALMART TRANSPORTATION is Hiring CDL-A (more...)
Company: Walmart
Location: Mendota
Posted on: 04/20/2021

Sr. Trial Attorney
Description: If you're passionate about being part of a diverse organization that enables a Fortune 100 company to deliver innovative business solutions with excellence, then Nationwide's Legal team could be the (more...)
Company: Nationwide Mutual Insurance Company
Location: Fresno
Posted on: 04/20/2021

Become a storage host - part-time gig
Description: Neighbor Parking Storage Host Rent out your parking space or your garage and earn 4,000 / year We are looking for side hustlers and passive income lovers to join Neighbor as independent hostsNeighbor (more...)
Company: Neighbor
Location: Fresno
Posted on: 04/20/2021

Description: GreeterKnow what it's like to be in the stadium on game day Then you know what it's like to work at Buffalo Wild Wings. It's fun. It's fast-paced. We're at the top of our game - and we want to keep it (more...)
Company: Buffalo Wild Wings
Location: Fresno
Posted on: 04/20/2021

Class A CDL OTR Truck Driver
Description: Job Description: br br Class A CDL OTR Truck Driver br Call 866 744-1793 or Apply Online Below br br We offer: br ul li
Company: KMS Express Inc
Location: Fresno
Posted on: 04/20/2021

Physician - Academics - Nephrology - Academic Nephrology Opportunity - Fresno, CA
Description: The VA Central California Health Care System in Fresno, CA is actively recruiting to fill a 0.50 FTE Board Certified Staff Nephrology Physician BE considered to provide comprehensive outpatient inpatient (more...)
Company: Veterans Health Administration
Location: Fresno
Posted on: 04/20/2021

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Visalia RSS job feeds