Business Intelligence (BI) Consultant SQL
London, England, United Kingdom
We are looking for a Senior Business Intelligence (BI) Consultant for our Global client in London.
Participation in projects related to Business Intelligence, performing different roles: Analyst, Developer, Team Leader, Project Management
Key Responsibilities:
Project definition, management, and development of BI complex systems for
data governance and data modeling,
Analysis and improvement of information flow for decision making,
Design and development of dashboard and reports, Data Marts and DW,
Proactively collaborate with cross-functional teams and subject matter experts to create best practices and deliver consistent data, reporting and insights across the organisation
Management and development of a Datawarehouse data model
Manage a team, prioritise team workload for maximum impact and efficiency of
Use
Identify and develop business intelligence, reporting, and data analysis needs,
Working with business and development teams to identify and define business problem and case during whole BI project lifecycle,
In charge of maintaining existing systems/software, improve, implement and integrate BI solutions
Collect and process data which measures business performance and supports business decisions, KPIs
Involved in the entire development process (design, development and deployment) with Data mining, Data Warehouse, Data Mart, Information Modelling,
Creating documentation and data testing schedule,Key technologies and tools:
Requirements
Microsoft BI Stack (SSIS, SSRS, SSAS, Power BI)
SQL Server Data Tools (SSDT) 2017,
Azure Data Factory, Azure Data Warehouse, Azure SQL Database
MS Visual Studio 2017, Power BI Desktop
MS SQL Server Management Studio,
PowerPivot, Power View, Power Query, QlikView
Databases: MS SQL Server 2012 - 2017, MS Access, Oracle
Programming languages: SQL, T-SQL, DAX, MDX, C#, VB.NET, VB, VBA
MS SQL Server Integration Services (SSIS)
MS SQL Server Reporting Services (SSRS)
MS SQL Server Analysis Services (SSAS)
MS SQL Server Management Studio 2008