Sales System Analyst - 00033

PGK Engineering
Job Description
Position Overview:

The Sales Forecast Database is a key system for all Divisions and Groups to support them in monitoring and tracking sales and business development opportunities. Support the vision and direction of the combined efforts of our sales & marketing, business development and finance departments by providing application support in the development, implementation and operation of the Database. Assess issues related to the ongoing development of the application and ensure the system is consistently reliable and user friendly. The Sales System Analyst will work closely with the Senior Sales Systems Analyst and support the Director of Business Systems and other functions as needed.

Essential Duties and Responsibilities:

— Support the Senior Sales Systems Analyst with all required upgrades, system maintenance and consolidation of system data
— Work closely with IT that is responsible for all system changes and support, including detailed testing for all system changes and updates
— Work closely with Hyperion Financial Management ( "HFM”) system administrators ensuring all change requests, that impact HFM, are assessed and if necessary updated in the Sales Database (e.g. all company hierarchy changes, foreign exchange rate updates, security, etc.)
— Assist with maintenance and control of all system access for the company and the Group Administrators
— Assist with maintenance of all master data fields, updating when necessary for approved change items including: customer master list, product structure, and other reporting related tables
— Serve as a technical resource for day-to-day application support including: routine maintenance and investigation of interface issues, including coordination of scheduling, testing and implementation
— Assist with the coordination of the upload of global volume data from Marketing into the database
— Support month-end closing and reporting process across corporate and groups
— Work closely with Senior Sales Systems Analyst and IT in the maintenance and creation of all reports required for the system users and coordinate all common reports required for groups and divisions
— Assist with coordination of all training of corporate level users and group trainers
— Assist with maintenance of system documentation and training materials including the user manual, ensuring that group administrators are updated for changes to the system
— Support the process of identifying, diagnosing and solving existing process and system issues
— Analyze and assess business processes to identify improvements/enhancements in the database
— Work closely with management and end-users to develop and enhance the application processes that will result in a stable productive environment
— Collaborate with the user community to gather, confirm and document user requirements
— Collaborate with the user community to define and map (document) business processes, both current and future
— Build collaborative relationships with other supporting IT services and the functional Hyperion application administrators
— Work with the Finance functional area to assist in tying in the GSD system to the business plan process
— Participate in future roll-outs of the application to new sites/areas, as required
— Train end users to operate new or modified software applications

— 1 + years of automotive experience with basic understanding of major OEMs and product (vehicle) life cycles
— General understanding of systems and how a forecast is built

Education / Experience:
— College diploma or University degree in the field of Business, Computer Science, Information Systems, or Software Engineering, and/or equivalent work experience

Special Knowledge / Skills:
— Proficient in Excel, in particular pivot tables to analyze large quantities of data
— From time to time, work off-hours to support clients across different time zones and during periodically scheduled update/maintenance procedures
— Excellent analytical skills and the ability to work with customer oriented teams in a global environment
— Excellent communication, interpersonal, facilitation and organizational skills
— Creative problem solving abilities with attention to detail
— Flexible and independent while at the same time a team player in a demanding environment with changing priorities
— Knowledge of PowerBI would be a plus as well as SQL server
— Ability to quickly learn and adapt to changing needs
— Ability to work with people at varying levels of the organization
Physical Demands / Work Environment:

— Normal amount of sitting or standing.
— Average mobility to move around an office environment.
— Able to conduct normal amount of work at a computer. Vision abilities required by this job include close vision and ability to adjust focus.
— Drug and Background Check Required
To apply, visit our website at
— From the three line menu icon, select "Current Jobs”
— From laptop or PC, scroll to bottom of page to see all current openings
— From phone, select Search to see all current openings
— Refer to Job Code 18-00033
PGK is an equal opportunity at will employer.

This job description in no way states or implies that these are the only duties to be performed by the employee(s) incumbent in this position. Employee(s) will be required to follow all job-related instructions and to perform any other job-related duties requested by an individual authorized to give instructions or assignments. A review of this position has excluded the marginal functions of the position that are incidental to the performance of fundamental job duties. All duties and responsibilities are essential to job functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this job successfully, the incumbent(s) will possess the skills, aptitudes, and abilities to perform each duty proficiently. The requirements listed in this document are the minimum levels of knowledge, skills or abilities.

Applicants must be authorized to work in the United States for any employer. No Sponsorship available for this position.

All offers of employment are contingent upon satisfactory results of a background check & drug test.
Contact Information

Foundation Members