Job Title Business Systems Analyst

• Perform the day-to-day administration and user support of Novus Cambria’s management information systems
• Provide support for innovation and development projects which enhance the organisation’s management information system
• Provide detailed reporting, analyses and interpretation of information contained within the organisation’s MIS systems.
• Perform systems analysis, development, programming and implementation of solutions using Microsoft SQL server and Microsoft Access to support improved business processes
• Develop, implement and maintain necessary controls and systems to capture contractual data
• Support learners, staff and managers in the use of all Learner Information Systems, as required, to ensure that data held and processed within these systems is accurate and compliant with GDPR. To provide ad hoc data extractions as required, in accordance with GDPR, to authorised persons via SQL
• Ensure the accuracy and timeliness of the Performance Management information reporting schedule submissions to stakeholders.
• Assist in improving the accuracy and efficiency of all processes related to data for performance and audit purposes.
• Produce comprehensive documentation of all systems specification and development undertaken.
• Develop appropriate material to support and contribute to staff training for designated systems.
• Ensure that procedures and systems meet contractual requirements
• Contribute to the development and implementation of effective performance data at establishment and national levels
• Contribute to the development, coordination, monitoring and evaluation of the internal funding and data audits conducted on site
• Work with on site managers and the Head of Learning and Skills to ensure that action plans related to improving performance against funding and data targets are completed
• Provide training and guidance to managers on performance and funding data, reporting processes and procedures
• Maintain excellent working relationships with all stakeholders. Proactively manage and resolve issues that may arise in a timely manner
• Quality check sessional hours and record and highlight anomalies to the appropriate manager
• Conduct scheduled establishment audits in line with agreed policies and procedures. Provide accurate, detailed audit reports on findings and corrective action. Monitor the effectiveness of the actions to ensure the required standards are achieved.
• Assist the Head of Learning and Skills with preparation for external audits.
• Assist with preparation for inspection, providing data and reports as required
• Monitor and report on procurement activities, to ensure actions are in line with agreed policies and procedures and comply with financial regulations
• Contribute to the development and improvement of business processes.
• To perform such other appropriate duties as required by the Head of Education in light of changing demands

n/a

n/a

• HND/Degree or Equivalent Professional Qualification in IT/Information Systems/Computing Essential
• Minimum Level 2 qualification in Literacy and Numeracy Essential
• Ability to speak fluent Welsh Desirable
• Subject to enhanced Disclosure and Barring Service (DBS) check Essential
• Software development processes Essential
• Relational databases and SQL Essential
• Good working knowledge of Excel formulas and functions Essential
• GDPR Essential
• SQL Server Desirable
• Microsoft Reporting Services Desirable

• Experience of EBS and/or Maytas Desirable
• Experience of Relational Databases Essential
• Experience of SQL Server, SQL Report Development Essential
• Experience of working within contractual targets and a funding framework Essential
• Track record of working to demanding, tight deadlines Essential
• Organised and self-motivated with the ability to meet deadlines
• Detail conscious, concerned for accuracy
• Demonstrable professional approach and positive attitude, with strong problem solving skills
• Able to deal with fluctuating workloads and maintain calm under pressure
• Able to work flexibly and be willing to support the College during peak times outside of normal business hours
• Committed to continuous professional development

• Able to ensure that control systems that are implemented are used effectively and produce necessary contractual data
• Able to produce and submit reports as required by the Authority in line with the relevant schedule
• Able to contribute to the preparation and smooth sunning of external audits
• Able to ensure that internal audit documentation is fit for purpose and is used to identify and test all relevant processes, procedures and documents required by funding bodies for external audits
• Able to ensure that internal audits are conducted as scheduled and produce effective action plans that are completed in a timely manner.
• Able to design action plans to improve specific performance issues, completed within planned timescales and are effective.
• Able to use MS SQL Server tables, views, triggers and stored procedures within multi-user database applications
• Strong analytical skills
• Ability to organise own workload and achieve deadlines
• Systematic approach and aptitude for setting up and working to systems and procedures
• Good communication skills, oral and written
• Ability to co-operate and share work with others

• Releasing potential
• Respect
• Collaboration
• Integrity
• Sustainability
• Accountability

• To actively contribute to Novus Cambria’s commitment to safeguarding and promoting the well-being of learners and staff.
• To actively contribute to the principles of Equality and Diversity within the prison.
• To work flexibly as required.
• To carry out such training, re-training and updating as may be necessary to fulfil the requirements of the post.
• To ensure duties are carried out with full regard to Health & Safety legislation and to enable Novus Cambria to meet its objectives in providing a safe and healthy environment for all users.
• To demonstrate an empathy with the Welsh culture.
• To undertake other duties that Management may, from time to time, reasonably require, commensurate with the grade.