Lead the Business Intelligence team to provide ad-hoc and project reporting, data analysis, technical support and training to facilitate management decision making and operational activities across the PayPoint group. Working with all levels of staff, across multiple departments, to identify requirements and define, design and develop BI solutions. Provide assistance to BI Analysts during delivery of new projects and dealing with incidents. Knowledge of SQL Server and BI tools coupled with strong business analysis and communication skills are essential to the role.
Manage and support a small team of BI Analysts.
Analyse user requirements to define and design solutions.
Manage the development of reports in appropriate technology including Microstrategy, SQL Server Reporting Services (SSRS) and Microsoft Excel
Manage the development of ETL tools using SQL Server Integration Services (SSIS)
Integrate database views and cubes into reporting front end tools to create end user self service capability
Provide relevant user training for information gathering and analysis from both static report and BI self-service enabled tools
Integrate into project teams; represent BI requirements and practices for new project developments.
Maintain reporting data and structures.
Develop and execute test plans for larger BI projects
QUALIFICATIONS AND EXPERIENCE REQUIREMENTS Essential:
Team leadership experience
Good knowledge of the Microsoft SQL Server BI Stack (SSRS, SSIS, SSAS)
Experience of requirements analysis
Excellent analytical skills with a proven ability to use data to provide insights and identify root cause.
An understanding around the concepts of Data Warehousing, Data Mining and ETL technologies.
An appreciation of the PayPoint business and the information its users require in their day to day activities
Ability to translate end user business requirements into technical solutions
Exposure to NoSQL databases, preferably MongoDB
Knowledge of Master Data Management
Experience of MS Excel VBA programming or Microsoft C#
Experience with Big data processing engines e.g. Hadoop, Spark
A team player who can both work as part of and manage and motivate a development team.
A technically adept, motivated, focused individual with excellent analysis, organisation and planning skills.
Good written and verbal communication skills, ability to listen effectively and interact at all levels within the organisation.