Business Intelligence Consultant - Home Based

Up to 50k + Bonus

Date Posted: Tuesday 18 July 2023

Sorry, this advert is now closed. Click here to view our live vacancies.
About the role;

As a Business Intelligence Consultant, you will work on all aspects of implementation and support of customer facing Data and Analytics Projects, from presales discovery and requirements gathering to solution design, installation and development, to implementation, testing, training and handover of the BI solution to the customer.
As a Practice, we aim to deliver business improvement to customers in a wide range of industries. You will focus on analysing new and existing software development requirements, proposing appropriate solutions and timelines, and carrying out development work individually or as part of a wider development team. This will include data analytics as well as data engineering activities, such as building data pipelines to extract, transform, model and warehousing data via ETL/ETL methodologies, then building dashboards and reports, to answer the key questions the customer has, taking their data and turning it into knowledge, information and wisdom.
You will be exposed to projects on a variety of product stacks, with a ‘T’ shaped approach, predominantly focusing on Data Warehousing using Azure and SQL Server technologies, but also tools such Qlik Sense and Power BI, either individually or as part of a cross-practice team, depending on project size and scope.
Who are we?
TSG (Technology Services Group) are a Managed IT Services provider servicing businesses UK Wide. At TSG our people have a passion for delivering exceptional customer service, something which is proven in our consistent world class NPS score of +80. Our values are Team TSG, Service Excellence and Shared Growth, these sit at the core of our business helping us to achieve our mission.
Why should I work for TSG?
It is our people that make TSG what it is and a great place to work. We put a lot of work in to creating a trusted, open, fair culture and as a result, we have been named as one of the ‘UKs Top 100 Best Large Companies’ and one of the ‘Top 50 Technology Companies’ to work for. In addition, we have been awarded a 2 star accreditation for ‘Outstanding’ employee engagement. 
Here’s why;  
  • Our open and honest culture where feedback is taken on-board and acted upon
  • The monthly wellbeing check-ins we complete with all staff and the support provided off the back of those where needed
  • Our social events. In addition to regular virtual quizzes and other ad hoc team building events, we launched the very first ‘TSG Festival’ in 2021, Team TSG’s feedback was so positive that we have decided to make it a yearly event 
  • Two paid CSR days per annum that you can use towards giving something back
  • Our charity fundraising - TSG have raised over £20,000 in the last 2 years for our current chosen charity Mental Health UK. We have also recently launched our very own ‘TSG Foundation’
  • Our responsibility as a business to the environment as we are working towards becoming a net carbon zero business
  • Flexible working policy
  • Relaxed dress policy
  • Excellent progression opportunities, training and support, including recognised qualifications
Job responsibilities will include, but are not limited to;
  • Deliver end to end Business Intelligence (BI) projects, from a Data Engineering / Data Warehousing perspective, using an agile methodology
  • Scope, analyse, and gather requirements, and design and architect appropriate Data Warehousing solutions.
  • Extract data from multiple data sources, following ETL / ELT best practices
  • Build data pipelines to transform and load data into dimensional models in a Data Warehouse for use by downstream analytics tools 
  • Build user friendly, functional, yet beautiful dashboards and reports using data visualisation techniques using Power BI and Qlik technologies
  • Manage projects following TSG best practices
  • Provide technical support to the TSG Service Desk, to resolve customer BI issues and queries
  • Assist the sales cycle via presales/discovery activities and building proof of concept dashboards/ETLs
  • Provide training and facilitate workshops to customers
  • UK wide travel and overnight stays to meet customer requirements 
  • Proactively manage personal development and ‘up skilling’ of technical abilities
  • Mentor and train junior members of the team to develop and grow their skillset
Knowledge, Skills & Experience;                       
  • At least 3 years demonstratable experience of developing/implementing/supporting solutions with any major ETL tools, for example:
    Azure: Azure Synapse Analytics / Azure Data Factory / Azure Data Lake / Azure SQL
    SQL Server:  SQL Server Integration Services (SSIS) / Analysis Services (SSAS) / Reporting Services (SSRS), T-SQL
  • SQL programming
  • ETL, Data warehousing and Dimensional (Kimball) modelling
  • Certifications in Microsoft Azure Data Fundamentals / Data Engineer, Qlik and Power BI would be advantageous
  • Experience in Power BI or Qlik Sense/QlikView would be advantageous
  • Data visualisation skills, using design flair to design beautiful yet functional dashboards
  • Ability to communicate clearly and effectively in written and spoken English with project stakeholders and colleagues
  • Software design principles and best practice
  • Company bonus scheme
  • 25 days annual leave + public holidays
  • Life assurance 4 x Salary
  • Contributory pension scheme at 4% matched
  • Perkbox discounts
  • Paid CSR Days
  • Company sick pay
  • Income protection cover
  • Enhanced Maternity and Paternity pay
  • Home-based and hybrid opportunities
  • Long service benefits including increased annual leave accrued with service
  • Cycle to work scheme
  • Employee recognition scheme
If this sounds like the role for you, please apply today to be considered.