Business Intelligence Business Analyst - SQL, Kimball, Data

Business Intelligence Business Analyst - SQL, Kimball, Data, Data Warehousing - PERM - CITY

A Business Analyst role has come up within the operations department of this city based service provider, reporting to the Senior BI Manager and focusing specifically on an initiative to improve their data and reporting solutions.

Your primary focus in this role will be to document the core systems and processes that support the business, and to document the business requirements for data and reporting projects for both internal teams and external clients, before translating these requirements to support the delivery of BAU data systems and the new data warehouse and reporting solution.

You will be working with internal business stakeholders to understand their specific data, processing and reporting requirements - the role will be pivotal in shaping the data strategy for the business.

They need a highly motivated self-starter with exceptional communication skills and a positive attitude, who can influence without authority and work with stakeholders at all levels.

You should have been involved in programmes like this before in a Business Analysis capacity, and should be well versed in BI and DW concepts, processes and approaches (e.g.


Key responsibilities:

Analyse and document key IT systems and data sources

Document As-Is and To-Be business and system processes

Capture and document data and reporting requirements

Document source to target requirements and build data dictionaries

Write functional requirements specifications

Translate system requirements into Data Warehouse requirements

Data analysis and data profiling to assist in the understanding of data and data issues

Assist in improving data quality and process issues

Translate requirements and current business challenges into a business case for change

Support QA and user acceptance testing processes

Support change processes

Assist in the identification of potential risks, dependencies and assumptions

Assist with the creation of training material

Knowledge, Skills and Experience:

Solid understanding of Data Warehouse principles including Kimball methodology

Solid experience of analysing and documenting complex business processes and systems

Gathering requirements and generating documentation including As-Is/To-Be business process models, wireframes, data models, security models and functional specifications

Skilled within UML, ER Diagram, Data Flow Diagrams and Process Flows

Experience with Microsoft databases and MS BI solutions

Proven track record of delivering business requirements, scoping, systems design, testing and training for large scale, large budget software delivery projects

Experience with Requirement Traceability, Data Traceability, Requirement User Stories, Backlog Management, Stakeholder Management

Can conduct data profiling to assess quality of data and identify data issues

Able to conduct stakeholder sessions including interviews, workshops and presentations

Facilitate consensus between technical roles and business stakeholders whilst managing expectation

Person Specification:

Attention to detail and accuracy

Methodical and structured approach to work

Able to deal with tight deadlines and changing priorities

Fast-learner able to hit the ground running

Exceptional communicator who can adapt terminology depending on the audience

An organised problem solver, able to manage individual workload and operate within the context of a team

Aptitude to be client facing

Highly motivated, self-starter with a positive attitude and a passion delivering improvements

Business Intelligence Business Analyst - SQL, Kimball, Data, Data Warehousing - PERM - CITY

Share Job