Business Intelligence Analyst - London

Recruiter
MBN Recruitment Solutions Ltd
Location
London
Salary
£70,000
Posted
02 Dec 2016
Job Sector
IT
Contract Type
Permanent
Hours
Full Time
Business Intelligence Analyst

Responsibilities

- Liaise with Finance and Technology departments to continuously develop the company's BI strategy, and to put this into practice.
- Understanding the process of data transformed into knowledge and information and how that knowledge supports and helps decide important business decisions.
- Understanding the Practice Management System (data models) and similar systems
- Advising on most efficient use of visualizations and implementation BI solutions
- The maintenance and extension of data warehouse offering on the design and content with use of T-SQL and SSAS.
- Operation of ETL processes using SSIS.
- Using SSRS to design, implement and maintain dashboards, reports and subscriptions
- Integration of Power BI and SSRS with SharePoint 2016.
- Mentor IT Development staff on operation of BI-related technologies and architectures

Requirements

- Strong experience of Microsoft BI stack including T-SQL, SSAS, SSIS, SSRS, Power BI and Excel
- Working knowledge of data warehouse design/optimisation
- Building reports and dashboards
- Experience working with stakeholders to derive BI requirements and transfer into working solutions
- Experience integrating SSRS and Power BI /Excel with SharePoint 2016 is desirable
- Understanding of R and Master Data Services would be of preferred