Business Intelligence Developer

£65,000 | | Permanent
Posted 2 months ago

A fantastic opportunity for a BI Developer to work within the financial sector based in central London.

The purpose of the BI Developer is to enhance our strategic data warehouse through the design and development of high quality solutions using the Microsoft Business Intelligence stack

Principal duties and responsibilities:
• Analyse, design and develop MS Business Intelligence solutions working closely with the business to understand their requirements.
• Write ETL and SQL to load data from various bank system sources.
• Write MDX queries and optimise.
• Build and enhance OLAP cubes using Microsoft's Analysis Services
• Developer SSRS reports publishing them in SharePoint.
• Microsoft Power BI: Power Pivot, Power Query, Power View, Power Map.
• Write complex ad-hoc T-SQL queries to meet urgent needs not yet fulfilled by the Cubes.
• Write clear documentation relating to design, development and support.
•
Background and experience necessary:
• Full lifecycle experience working on complex data warehousing projects, ideally in retail banking.
• Full SQL Server BI Stack (SSIS, SSRS, SSAS), 2008r2, 2016
• Good working experience with SQL Server 2008r2 / 2016 databases and migration experience.
• Proven ability to model Data Warehouse entities using Dimensional Modelling (Kimball)
• Experience with Microsoft SharePoint to publish reports is a definite advantage.
• Experience of Kanban/Scrum Agile methodology.
• Experience with TFS, release building, labelling, branching, and Kanban.

Qualifications Desired:

Degree level or equivalent

For immediate consideration please send your CV to laura.swift@itqerp.com

For more information about this role, please contact:

Laura Swift

laura.swift@itqerp.com
01423 874566

See Laura Swift's jobs
Related Jobs

Oracle Analyst / Programmer

Competitive | London | Contract

The suitable candidate will be a highly skilled Oracle Developer with at least five years proven Oracle Development experience. • Significant development experience of Oracle Database version 11gR2. • Oracle Forms 10g deployed on...


SCCM Engineer

Competitive | Kent | Contract

SCCM Engineer • Extensive technical experience covering the following; ? Enterprise level systems management infrastructure support (SCCM 2007/2012/Current Branch) ? Enterprise level endpoint management (including task sequences, software deployments, security patching, anti-virus, mobile device...


RPA Business Analyst

Competitive | Greater London | Contract

RPA Business Analysts - Contract - London We need candidates who have RPA experience, around opportunity identification across capital markets in a business analyst capacity. Identification and assessment of opportunities...