Syspro ERP Administrator
Beaver Dam, KY 42320
Contract to Perm or Direct Hire
Reports to the Information Technology Manager. Responsible for day to day support of the Syspro (ERP/Financial) application and MS SQL 2012 Server database. Responsible for responding to Syspro user requests in a 24-hour production environment which includes after hours support.
Principal Duties and Responsibilities:
Support of Syspro 7 environment including Application Server, database and client PCs operating in a high volume production environment.
Strong understanding of financial and production concepts.
Syspro functional experience including financial, distribution and manufacturing modules.
Ad Hoc reporting and development as needed including Syspro and SQL Server
End user training at all levels (Management and shop floor) with version upgrades.
Make up training/reference manuals for Syspro ERP modules in use.
Mine data and provide periodic ad-hoc reporting to accounting and operations.
Work directly with accounting department and production control staff to streamline processes and correct impediments.
Perform function of SQL2012 database admin, SQL backups, user security, database maintenance etc.
Write complex queries using T-SQL combining data from multiple companies and Servers.
Optimize T-SQL code and stored procedures.
SQL Server Reporting services (SSRS) to write reports not possible using Syspro Report Writer, users can print reports or export to Excel or PDF format. These SSRS reports include production and scrap reports to track productivity by cost center by machine throughout the factory, also reports to track delivery performance to customers and from suppliers to mention but a few. Use SSRS subscriptions to email reports daily and weekly to staff in PDF and Excel formats.
Interpret stringent automotive customer labeling requirements and maintain customer labels in Bartender to meet requirements
3 years Syspro application administration with MS SQL Server administration and development
Syspro 6 and 7
SQL Server 2012
SSRS experience integrate Syspro with other databases
Excellent technical and nontechnical communication
Excellent problem solving skills
End to end project management and issue resolution experience
Additional Skills Desired
Bartender label software
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform essential functions.
The individual in this position must be able to understand all policies, procedures, instructions, rules and regulations (including all safety training and safety information) associated with this position, which are written in English. In addition, the individual must be able to appropriately respond to these and where needed, provide reports, presentations, information and communications in English.
Ability to define problems, collect data, establish facts, and draw valid conclusions. Must be able to read, comprehend and interpret laws and regulations.
Lighting and temperature as required for an office environment. High level of visual strain occasionally required due to detail attention necessary for confidential reports. Appropriate safety equipment required in designated areas. May work and be exposed to hazardous, safety sensitive materials. The work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of the job.
Ability to read and interpret documents such as safety rules, procedure manuals and governmental regulations. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees and effectively engage internal and external customers.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to move throughout the facility, traverse within production areas, communicate with others, and detect or exchange information or ideas. The employee occasionally is required to perform functions which require the manual operation of both general office productivity and test equipment as well as the ability to place, reach, detect, ascend/descend, and position self to navigate within confined working spaces. The employee is frequently required to remain in a stationary position. The employee must occasionally move or transport up to 25 pounds. Specific vision abilities required by this job include close inspection, identification of objects from a distance, color determination, peripheral detection, depth judgment, and the ability to identify details in varying conditions.
Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.
For immediate consideration, please forward resume to (see below)
Duration: 6 month Contract to Perm or Perm
Pay: $85,000 to $95,000 USD
Pay Period: Annual
Click here to apply
Please mention that you saw the job on TriplePundit