SQL BI Developer

Business Intelligence & Data Warehousing | £0 per year + Bonus and Benefits | England, Greater London, London

Role

SQL BI Development Analyst

Department

Operations

Reporting to

Head of MI/BI

Job Location

London

Date

February 2019

About Masthaven Bank Ltd

We were the first new bank to be awarded a banking licence in 2016. But we’re not new. We’ve been providing a flexible and personalised approach to bridging loans and secured lending since 2004 and recently brought that expertise to retail banking. Our London-based team is made up of knowledgeable and experienced specialists in savings, lending and the rest of the bank’s specialist support functions. We’re committed to providing flexible and fixed term products that meet the needs of savers and borrowers: savings accounts, bridging loans, development finance loans and first and second charge mortgages. We’re a digital bank with a human heartbeat, choosing to look at the person behind each application.

Purpose of Role

The SQL Development Analyst is responsible for the overall continuing development and enhancement, management and maintenance of the data warehouse supporting Masthaven Bank. Work with available tools to design, develop, unit test, implement, and maintain BI solutions. Support Business As Usual (BAU) activities, liaising closely with the BI analysts. W ork as part of a cross-functional team to deliver high-quality, accurate data and reporting solutions which satisfy customer expectations. Code and implement Data Imports & Reporting requirements to specification, write code and queries to enhance the existing processes

Key Competencies

    Strong background in SQL Server, ETL and data warehousing.

    Exposure to cloud based tech is desirable, such as Azure.

    Strong SQL Programming skills (T-SQL, Stored procedures, Functions, etc.)

    Strong background with the Microsoft BI stack (SSIS, SSRS, SSAS).

    Strong Stakeholder Management experience, the ability to collaborate and communicate effectively with both technical and non-technical users.

    BI design skills, dimensional modelling, star schema.

    OLAP cube design

Key Responsibilities

    Develop reports in SQL Server Reporting Services.

    Design, Develop and Deploy SSIS Packages.

    Participate in development and creation of the Data warehouse.

    Create and maintain documentation for all projects

    Create cubes in SQL Server Analysis Services.

    Perform quality checks on reports and extracts to ensure full reconciliation

    Create exception reports to ensure data quality issues are addressed

    Implement business rules via stored procedures, middleware, or other technologies

    To abide by all financial crime related policies, procedures and reporting obligations applicable to their job

Key Measures

    Data Analysis

    Data quality and accuracy

    Attention to detail

    Verbal and written communication skills

Entry

    5+ Years’ experience of Data Warehouse design and development

    Strong Knowledge of Financial Services products (10+ years) ideally in a similar organisation ? Knowledge of DPR data warehouse/application extremely desirable.

    BSc in Computer Science or related field

    Financial Services experience preferred

, ,

Apply Now