Job Purpose:

• Reporting to the Group IT Manager, the successful candidate will be expected to design, maintain, support, and enhance business intelligence and reporting, including the data backend.
• Engaging with the organisation and recommending / delivering modern, best-practice business intelligence and reporting solutions.
• Maximising the benefit of existing systems and lead the transition from legacy to current technologies.
• Working collaboratively in a cross-functional team to proactively drive innovation, business growth and use of systems through technology.
• Contributing to the overall governance, maintenance and development of the ERP system.
• Performing core database management and reporting frequency-based activities.

Main Responsibilities / Duties:

• Designing and implementing a modern and scalable data warehouse, OLAP-based reporting and BI (SSRS / PowerBI).
• Working with end users to ensure data and reports meet their business needs.
• Leading the design and implementation of reporting and database systems.
• Designing and monitoring end-user reporting tools and systems, ensuring reports are accurate and up-to-date.
• Responsible and accountable for day-to-day database processes and administration (invoices, MRP, overnight processing etc).
• Contributing to ERP systems administration, including month-end processing and reporting.
• Contributing to general IT support.

Qualifications:

• A Degree qualification in a relevant IT discipline is essential.
• A Masters Degree qualification in a relevant IT discipline is desirable.
• Relevant IT certification is desirable.

Experience / Skills:

Essential:

• Expert level experience with MS SQL Server database technologies.
• Experience with the delivery of database and BI solutions in an ERP environment.
• Experience with the design, development and maintenance of data warehouses and business reporting solutions.
• A strong track record of proactively applying expertise and driving strategic business change.
• Experience with Microsoft SQL Server database development & administration.
• Experience with T-SQL.
• Reporting development experience with OLAP and SSRS.
• Excel / MS-Query / VBA development experience.
• The role will involve more than SQL Database administration / development so in addition to having excellent skills in this field, the successful candidate will need to have an excellent awareness of the importance of business reporting, integration and analysis in order to drive wider business change.

Desirable:

• Background in software development.
• Experience with / exposure to the latest SQL Server e.g. 2017.
• Experience of working in a DevOps team.
• Kanban / Agile methodology experience.
• C# and .NET software development experience.
• ERP development / integration experience.
• Experience with the support, maintenance and development of an ERP.
• Power BI development experience.
• Business analysis / process design experience.
• Project management experience.
• Visual Studio experience.
• GIT experience.