Business Intelligence Developer

Job details

  • Reference: TT-JY-GPOC6AG
  • Hours: 37.5 hours per week, Monday - Friday
  • Location: Leicester (map)
  • Salary: Up to £25,000 dependent on experience, company bonus up to 20%

   

Big things are happening at Topps Tiles. As Britain’s largest specialist tile retailer, selling only the very best quality on-trend products, £1 of every £3 spent in the UK domestic tile market is spent with us. We have just opened our 370th store and hit record sales of £215m. In addition, we are as big on career opportunities as we are on outstanding service and great value. After all, brilliant, friendly, knowledgeable people make us special. Right now, we are on a journey of exciting growth, as we build on eight consecutive years of success – there has never been a better time to join the Topps Tiles family.

Summary

We currently have an excellent opportunity for a Business Intelligence Developer to join our IT team based at our Head Office in Grove Park, Leicester. Reporting to the Database Administrator, you will be responsible for the development, supply and validation of data which will allow business users to make informed decisions.

The Role

  • 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 accuracy and performance of data loads
  • 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 request to be signed off by end user
    • Work to a prioritised schedule to produce output
    • Develop and Test solution using the best tools identified during specification
    • Create documentation and handover for end users and IT Support function
    • Follow the department version control methods using Team Foundation Services (TFS)
    • Deploy 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

 

The Person

Essential                                                

  • SQL Server Management Studio
    • T-SQL to include
      1. Data Definition Language (DDL) to include create, alter, drop of objects
      2. Data Manipulation Language (MDL) to include select, insert, delete of data
  • Creation of Views, Stored Procedures, Functions and Triggers
  • Security setup
  • 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

  • Team Foundation Services (TFS)
    • Experience of working with SLAs and KPIs
    • Experience of working in a multi-site/retail environment
Apply

A career with Topps Tiles

There's plenty about Topps Tiles that might surprise you. Like the fact that you don't need to be a DIY or tile expert to work in one of our stores or Head Office.

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.