Business Intelligence Analyst

Cheltenham - £25000 to £35000

About Commercial

Commercial Group was established in 1991 and has since grown to become the largest independently owned Business Services Group in the UK. Today, comprising of 6 divisions; Managed IT, Office Supplies, Interiors, Managed Print Services, Technology Supplies and Print, the £65m turnover Company is renowned for delivering superior quality product, service and consultancy to business nationwide.

We are currently embarking on exciting and ambitious growth plans to grow to a turnover of £70m by 2019 so we need talented people to support this growth. We understand that superior performance starts and ends with our people; people with passion who like to make a difference and most importantly love what they do. If you would like to be a part of this exciting journey then we would love to hear from you!

Job Description

We currently have a vacancy for a Business Intelligence Analyst within the Business Solutions Team based at the Head Office in Cheltenham. The key purpose of the role is to implement, support, maintain and develop Commercial’s Reporting and Data warehouse. Applicants are required to have proven experience of SQL development and Reports development

We want you to…
  • Develop Business Critical Reports
  • Maintain and Support existing Business Critical Reports
  • Manage data manipulation using SQL
  • Provide advanced Data Warehouse support and development.
  • Manage priorities and time effectively across multiple Projects/Change Requests
  • Ensure that all requests from users are logged, updated and closed in line with operational level agreements.
  • Liaise with both technical and non-technical stakeholders to gather requirements
  • Build and maintain relationships with key stakeholders across the business
  • Tackle problems confidently and presenting reporting and data solutions

Candidate Requirements

You have got…

  • Experience in SQL Server Reporting Services (SSRS) including Report Builder
  • Development experience with Microsoft SQL Server 2012/2014/2016
  • Strong T-SQL Skills - Creating stored procedures/functions for reporting and for transforming data
  • Experience of designing and creating views/tables
  • Relational Database Design and query performance optimization.
  • Strong Excel skills (Macros, Formulas and ODBC Data links)
  • Requirements gathering, producing scope and design documents
  • Excellent debugging and diagnostic skills with the ability to resolve technical problems with simple solutions
  • Excellent communication skills

The following skills would be an advantage, although not essential:

  • SQL Server Integration Services (SSIS)
  • SQL Server Analytical Services (SSAS)
  • Power BI
  • Crystal Reports
  • Team Foundation Server (TFS)
  • No SQL Databases

Additional Info

Why Commercial..?

  • Competitive salary
  • We all get a generous holiday allowance of 25 days plus bank holidays which increases with length of service
  • Laptop and mobile phone
  • A variety of training & Development programmes tailored to you
  • Earn extra money if we hire your friends or family with our employee referral programme
  • Want to get healthy? We have free fruit delivered for all staff! And our state of the art coffee machine will be sure to set you up for the day
  • Looking for a little extra? You could get a day off for doing charity work and you might even get a treat on your birthday and work anniversary!
  • A range of team and social events
  • Cycle to work scheme, pension contributions, Employee support programme, Flexi time scheme and more