BI Developer

Job Details
  • Location: Support Office, LE19 1SU
  • Type of Role: Full - Time
  • Hours: 37.5 hours per week, Monday - Friday
  • Salary: ¬£Competitive

We currently have an excellent opportunity for a Business Intelligence Developer to join our IT team. Reporting to the Data Development Manager, you will be responsible for the development, supply and validation of data which will allow business users to make informed decisions. This role will include a mixture of hybrid working, with the option to work from either home or the office based in Leicester, 

The Role

  • Creation of data / reports to meet user needs
  • Work with the management team and other internal customers to specify the requirement
  • Develop specification documentation of the request to be signed off by end users
  • Work to a prioritised development schedule
  • Responsible for the development and testing of reporting solutions
  • Creation of documentation, and the handover to the end user and IT Support function
  • Follow department version control methods using Team Foundation Services (TFS)
  • Deployment of the solution once UAT and sign off completed 
  • Support existing reporting
  • Enhance and redevelop reports to meet changing needs of the business
  • Create and Monitor Jobs and Schedules
  • Automate or increase efficiency of existing reports to ensure timely and accurate delivery of data.
  • Troubleshoot and fix ad-hoc user reporting issues
  • Develop and maintain the Data Warehouse (DW) using Extract Transform and Load (ETL) processes
  • Create Integration Services packages (SSIS) to load data from source to staging to live
  • Maintain and monitor the DW processes
  • Test and monitor the accuracy and performance of data loads

The Person

Essential                                                

  • SQL Server Management Studio
  • T-SQL to include - Data Definition Language (DDL) to include create, alter, drop of objects and Data Manipulation Language (MDL) to include select, insert, delete of data.
  • Creation of Views, Stored Procedures, Functions and Triggers
  • Maintain and update indexes, statistics, keys and constraints
  • Visual Studio / SQL Server Data Tools - BI
  • Integration Services Packages (SSIS)
  • Reporting Services reports (SSRS)
  • Analysis services Cubes (SSAS)
  • Strong communication and engagement skills at all levels

Desirable

  • PowerBI
  • Experience developing reports and dashboards using the PowerBI desktop application
  • A working knowledge of DAX
  • Team Foundation Services (TFS)
  • Experience of working with SLAs and KPIs
  • Experience of working in a multi-site/retail environment

For further information please contact beth.sutton@toppstiles.co.uk

Closing Date
Saturday 30 October 2021

Rewards

A competitive salary.

Bonus and uncapped commission schemes (dependent on your role) that run four times a year, helping you to share in our success.

A generous staff discount scheme allows you to make purchases from our stores at below market price.

Enhanced maternity/adoption and paternity pay, and childcare vouchers.

A ShareSave scheme that allows you to invest in us and share our success.

Pension & Life Assurance schemes with company contributions available to help you provide for your retirement.

A wide range of discounts with selected companies including discounts on insurance, holidays and retail vouchers.

Holiday entitlement that increases with length of service.