Connecting to LinkedIn...

BI (MS STACK) Internal Technical Consultant

Job Title: BI (MS STACK) Internal Technical Consultant
Contract Type: Permanent
Location: Peterborough, United Kingdom
REF: 1638
Contact Name: Gary Fay
Job Published: about 1 year ago

Job Description

BI (MS STACK) Internal Technical Consultant


You will be leading and driving forwards the existing Business Intelligence Centre of Excellence. Delivering reporting analytics and solutions developed in house by utilising their existing MS BI Stack to a broad range of internal business units and functions who are spread across 30 countries, throughout the world.


This role would suit a senior BI developer who is ready for their next step or a leader who is looking to broaden their skill set and technology or you may already be delivering something similar – you will be working with senior stakeholders both internally and externally, you do have a small local team around you who require leadership and mentoring  but this is not about local team management in the traditional form, it’s about leadership and being responsible for BI services to a wider ranging audience.


The role is also responsible for all MI/ BI Analytics and Reporting services (e.g. the design, implementation and support of BI software, systems and solutions, including integration with databases and data warehouses, and report writing). Operating in a Multi-platform / Technology Environment, with Microsoft SQL Server being the core MI / BI platform and technology stack.


Progression towards greater use of Cognos Business Intelligence is also underway, this starting from the TM1 application suite.


We would expect you to be technically hands on, with a consultative, almost internal technical pre sales approach, influencing stakeholders of the benefits in adopting BI / Analytics and Services from your centre of excellence. 

You will need to build confidence and trust, rapport and relationships with stakeholders and you must be able to show that you’re technically aware and capable, for example we would expect you to have extensive experience in installing, configuring, administering, and troubleshooting MI/ BI applications – every day BAU issues still need to be resolved and a daily service still needs to be delivered.


Areas of responsibility - Central Development / Delivery Activities

  • Reports and Dashboards Solution development (code and configuration)
  • Data warehouse Design, Solution development
  • Microsoft SQL Server Database design Solution development
  • Microsoft SQL Server SSIS, SSRS, SSAS Solution development
  • Application / Data Integration Solution development
  • Application / Data ETL Solution development

Some design, governance and standards experience would be highly desired (but not essential), as would an awareness of cloud based products – Azure Hosting, 365, Azure Data Factory / MS Flow and Power Apps.

You will have an opportunity to work with Microsoft as they assist and advise on the future roadmap and direction and delivery of this company’s BI journey.