SYSPRO Applications Specialist

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.