Job Description

####

Reports To

MI Team Manager

####

Location

Thorpe Park, Leeds 15

####

Hours of Work

37.5 hours per week between 8am and 6pm (hours of work will be flexible and dictated by the needs of the business, therefore it is expected that the successful applicant will work those hours necessary to successfully discharge the duties of the role).

####

Benefits

25 days holiday with the option to buy or sell up to 5 days holiday per year Birthday off Monthly bonus scheme Cash healthcare plan Auto enrolment pension scheme Learning & Development programme Life assurance Flexible working options Volunteering days Gym discounts
###

The Role

####

Overview

A business support role focusing on building and servicing bespoke management information infrastructure and reporting for the business and other key stakeholders. Supporting ongoing business growth through development with technology.

####

Key Outputs

Develop, maintain, and enhance Management Information and reporting, using SQL Server 2019+, PowerBi, Reporting Services, Python and Excel. Model data sets from software databases into reporting databases Assist in identifying data fields for adding to warehouse Actively participate in the ongoing development of the warehouse and associated infrastructures Assist in upgrading current reporting assets Work with external stakeholders to deliver on reporting requirements Assist in maintenance of daily reporting quality Processing Ad-hoc data requests for internal and external stakeholders. Work closely with team leads, team members and all business stakeholders to extract and analyse requirements, deliver solutions and provide feedback into these. Supporting others in acquiring knowledge, and providing expert technical advice through peer reviews.

This job description is not exhaustive and serves only as a broad outline of the duties required. This job description may be amended as necessary.

###

The Person

####

Overview

A highly self-motivated person who has excellent analytical and problem-solving skills. Good interpersonal skills and an adaptive communicator who can work well alone, with colleagues and 3rd parties to deliver MI solutions efficiently. Be committed to self-development to stay ahead of business requirements in terms of technical skills. Somebody who will embody our values of honesty, simplicity and responsibility in how they approach their work and those around them.

####

Skills & Experience

####

Mandatory

5 years + experience working within a data centric role 5 years + experience writing T-SQL queries using Stored procedures, Views, tables, functions, etc 5 years + experience using excel to an advanced level including Power query/ Microsoft query/ VBA, etc 3 years + experience building/ maintaining Extract, Transformation and Load processes in conjunction with data warehouses through stored procedures/ SSIS or similar Prior experience working with Kanban using DevOps/ Jira or similar Prior experience of using source control methods and technologies Experience working in a role demonstrative of: + Excellent communication skills + Strong decision-making, analytical and problem-solving skills
+ Quality focus with an eye for detail
+ Logical thinking and the ability to produce imaginative solutions to process or procedural problems
+ Being adaptable and resilient to changing needs and priorities.
+ High self-motivation and self-starting abilities.
+ Technical self-development.

####

Desirable

Python SQL server reporting services Power Bi with utilisation of DAX SQL server integration services SQL server analytical services
####

Qualifications

####

Mandatory

* I.T/ B.I. qualifications but not essential