SQL BI Development Analyst
Head of MI/BI
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
- 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
- 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
- Data Analysis
Data quality and accuracy
Attention to detail
Verbal and written communication skills
- 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