BI/SQL Developer/Consultant

Company Profile:

An applied analytics and advisory business with a unique in-house developed solution that combines an improvement science methodology with a proprietary improvement analytics platform. Clients operate predominantly in the NHS, general healthcare and emergency services.

Projects range from small-scale data marts to much larger and more complex solutions. These business intelligence solutions are accessed through a Web App, and utilise an SQL Server data warehouse with typically anything up to 100 million records and 5-10 fact tables built using the client’s data. They are hosted on a managed service or with the client.

Required Skills:

  • T-SQL and SSIS development
  • .NET programming in VB or C#
  • Presentation and visualisation skills
  • Dimensional analysis and modelling
  • Ability to communicate effectively across organisational, technical and political boundaries


  • Produce and communicate logical and conceptual health models of key business processes and data flows using use case, process diagrams or other appropriate visualisation tools
  • Assess data availability, suitability and quality
  • Help identify possible transformation initiatives. Assist with re-packaging such initiatives for use with other clients
  • Provide data structures that can be synchronised with data integrity maintained
  • Identifying key project risks and work with the project manager to mitigate these
  • Communicating solution requirements to other technical consultants and system builders
  • Assist with creating a business data glossary and other key user documentation
  • Formulate plans for, and help manage, system testing and user acceptance testing

Desirable Skills:

  • Knowledge of a variety of BI tools such as Qlikview, Business Objects, IBM Cognos, Microsoft Power BI/SSAS, Tableau
  • Process and data modelling in acute healthcare
  • Statistical process improvement/Six Sigma/CMMI/Lean
  • Simulation and numerical modelling techniques and software such as Simul8
  • Development of test data
  • Machine Learning and AI
  • Scrum/Agile, ISO 27001 and ITIL

The company offer a competitive basic salary and a comprehensive benefits package. The role will be home working for the foreseeable future, travel within the UK to client sites will normally be required.

Excellent opportunity, please apply for a prompt response.

To apply for this job email your details to