Job Description
Job Title: SYSPRO Applications Specialist
* Team: Working within a team of IT professionals, comprising IT Support, IT Developers and Systems Administrators.
* Reports To (job title): Development Team Lead
* Location: Camberley
Role Purpose and Department Purpose
* To plan, support, maintain and develop the Company's SYSPRO ERP system, and associated applications, ensuring optimum usage of the system and serving as a technical lead on projects involving implementation and maintenance of ERP-related applications, databases and reports.
* Requires thorough knowledge about all aspects of the ERP system's software and related database schema.
Dimensions of the Role
* Travel Required? Yes ? No ?
* Travel to regional offices, suppliers and seminars to meet key stakeholders, review performance, identify operational improvements and to develop understanding of best practice and on-going developments in IT Support.
* Responsibilities: Indirect supervision and evaluation of work of development, infrastructure and support staff related to ERP Applications
The Role and Role Specific Competencies
* To perform day-to-day system administration functions for Syspro and related application and database infrastructure
* This includes testing and application of system patches, measurement and maintenance of system performance, security of data through role configuration etc.
* Troubleshoot and resolve day-to-day and complex technical problems with Syspro and related applications, including database applications and server problems, liaising with colleagues and escalating to vendor as appropriate.
* Managing the support and development relationship with the vendor to maintain required levels of coverage and proactive implementation/development of additional functionality
* Develop/implement changes to the Syspro environment to support business process changes and efficiency improvements.
* To function as the lead specialist on projects to enhance or test ERP systems and applications to meet changing business needs.
* Maintain system documentation for Syspro and the wider ERP infrastructure.
* To manage the Syspro software configuration, the testing and debugging of ERP functional modules and the maintenance of Syspro database tables.
* Develop and maintain reports, spreadsheets and external integration pieces to support business reporting requirements.
* Identify, design and implement ancillary functions to enhance core Syspro functionality using established toolsets where necessary.
* Identify and evaluate new features and functionality which may be of benefit to the business.
* Develop and maintain DataSwitch integrations with other systems.
* Analyse business process changes with users and other stakeholders to identify the most appropriate solution within Syspro and other line-of-business applications.
Knowledge, Skills and Experience
Essential
* Expert Technical Knowledge of ERP systems
* Microsoft SQL server database administration
* SQL queries, view and stored procedure design.
* Knowledge and understanding of database schemas.
* Experience of database reporting tools
* Evidence of supporting large-scale business process change projects.
* Expert in use and development of Excel functions, macros and data connections
* Working knowledge of C#, ASP.NET framework/.NET core
* Excellent knowledge of VBScript/VBA
* DataSwitch development and administration
* Business process analysis experience
Desirable
* Experience of managing others
* Familiar with standard concepts, DB best practices and procedures within the particular field.
* Experience of managing suppliers and 3rd party or outsourced contracts.
* Competent in using Office 365
* Power BI
* JavaScript
* Expert technical knowledge of Syspro 8
* Experience of Crystal Reports
* Experience of writing business requirements documentation.