Key Purpose of the Job
The role will work as part of a larger team implementing our new ticketing system and its interface to other existing systems and services.
To develop extracts reports and interfaces from and between different ICT systems. The role will require strong SQL skills with Power BI an advantage.
Strong capability in Data Warehousing and database systems is a mandatory requirement as is the ability to discuss requirements with end users.
Main Duties and Responsibilities
- Extracting and manipulating data from existing MS SQL database systems.
- Developing bespoke and modifying standard reports produced by our ICT systems.
- Modifying and developing new Power BI dashboards and reports.
- Working closely with the business to ensure reporting requirements are fit for purpose. Specific but not exhaustively these areas are Finance Membership Marketing and Sales.
- Identifying and managing through to resolution issues and problems.
- Enabling the scheduling and monitoring of reports.
- Data load unload transformation and migration.
- Helping to train users on reporting.
- Gaining a complete understanding of off the shelf reporting from the product and how this can be used.
- Hands on implementation of the software product including but not limited to configuration change requests problem management BAU activities reporting etc.
Expectations of job holder
- To ensure that the policy for equality of opportunity is adhered to and promoted in all aspects of the post holders work.
- To ensure effective quality control and continuous improvement in all aspects of the work and responsibilities attached to this post.
- Demonstrate professionalism towards sensitive and confidential information.
- To comply with and promote Health and Safety policies and procedures and to undertake recommended Health and Safety training as and when necessary.
- To be committed to professional selfdevelopment through participation in inservice training as necessary for the successful carrying out of the job.
- To undertake such other duties as are commensurate with the grade of the post.
Person Specification
- Have whole business focus and understanding.
- Able to engage and communicate across all levels of the business be able to work well under pressure and have excellent attention to detail.
- Collaborative nature can build relationships able to adapt approach to problem solving to reflect the nature of the audience and work well with peers.
- Flexible and pragmatic to achieve goals.
- Ability to engage and influence colleagues.
- Able to command the respect of senior stakeholders at board and steering group.
- Proven experience of business analysis including requirements analysis.
- Previous experience of data migration and developing reports/ing software.
- Data warehouse experience.
- Power BI an advantage.
Qualifications & Experience
- Excellent SQL expertise.
- Previous ticketing experience an advantage.
- Demonstrable experience of working with SaaS and on premise products.
Knowledge
- Ticketing system knowledge an advantage.
- SQL.
- Power BI.
- Data load and manipulation techniques.
- Good technical skills and capabilities in a Microsoft environment.
Skills & Abilities
- Technical skills in MS and SQL environment.
- A team player able to work collaboratively across reporting lines.
- Able to organise the ideas and thoughts of others into a logical set of steps and processes.
- Able to establish good working relationships through excellent communications skills and the ability to interact with staff at all levels of the business.
- Ability to be flexible and modify work approach to meet changing business priorities
Other Requirements
- While predominately a Monday to Friday role there is a need to work occasional weekends or evenings during go live periods.
- The role is primarily remote with attendance in London 12 days per week.