Business Intelligence Consultant

  • Location

    Solihull, West Midlands

  • Sector:


  • Job type:


  • Salary:

    £60000 - £65000.00 per annum + Car, Bonus and more

  • Contact:

    Luke Byrne

  • Contact email:

  • Job ref:


  • Published:

    9 months ago

  • Expiry date:


  • Start date:


  • Client:


Business Intelligence Consultant


Up to £65,000 + Bonus & Car

Experis IT are currently recruiting for a BI Consultant to join one of our key clients based in Solihull. As part of the MI&A team, the BI Consultant will be responsible for delivering data solutions to enable effective reporting and insight by business teams. They will engage closely with leads in the business to understand and develop requirements, provide expert knowledge of the data structures and tools in order to deliver value-adding solutions. They will bring innovation and pragmatism to help develop new insights to grow and optimise the business.

The primary data platforms include Microsoft SQL Azure and Power BI. The MI&A team are responsible for the technical roadmaps and driving improvements in consultation with Group and Divisional CIOs, IT strategy and with IT Partners.


  • Build strong relationships with business and functional stakeholders to understand business direction, processes, issues, decisions, and shape data requirements for reporting, analysis and insight.
  • Translate business requirements into costed end-to-end data designs, including source system analysis, data capture, transformation, modelling, presentation queries and reports/dashboards and analysis models.
  • Develop rapid prototype and proof of concepts to shape solution approaches, engaging closely with business stakeholders
  • Evaluate and recommend the pragmatic and cost effective build approaches for data solutions, such as in-house development, delivery partner, specialist 3rd parties or otherwise based on scale, complexity and priority.
  • Manage and oversee the delivery of data solutions through technical and delivery governance
  • Deliver specific components or the complete data solution - source to report.
  • Using a "continuous improvement mind-set": Identify, recommend and implement solution design optimisations and performance tuning improvements.
  • Support the Service Lead to analyse and understand system and user behaviour to drive adoption and business value-add.
  • Create high-quality documentation to describe the technical solution and business-facing documents to explain in clear language the data model, measures, dimensions, hierarchies, history and data quality characteristics.
  • Contribute to the BI platform strategy and functional roadmaps to ensure the MI&A service remains technically appropriate to meet business requirements.
  • Strong experience designing and building BI solutions with a focus on designing and implementing Data Warehouse solutions
  • Assist support teams in resolving technical issues with data solutions.

Technical Skill

Broad BI solution and data management experience is essential together with proven expertise with the following technology -

  • SQL on Azure
  • SSIS
  • SSAS
  • Power BI