Product Features
Blog
Contact Us
Sign In
Digital Waffle Limited
,
Solihull, West Midlands
BI Developer
|
|
Salary: £40000 - £45000 per annum + Bonus & Remote working |
|---|
Overview
BI Developer (Business intelligence) Location: Solihull - Central Salary: £40,000 - £45,000 DOE Bonus Buzz Words - Business Intelligence / BI / DWH / Data Warehouse / SQL / ETL / SSIS / SSRS / SSAS / Power BI / Solihull / Birmingham / Permanent Jobs / Remote working / Flexible hours / Financial Services / Banking Sector Opportunity This role sits within the Data Warehouse team. The team is responsible for developing and maintaining the SQL Data Warehouse, which holds key loan by loan data from the core servicing platforms for the entire range of the bank's loan and savings portfolios. This data is updated on a daily basis and the warehouse is designed to facilitate analysis and fulfil all the bank's reporting and Business Intelligence requirements. Staff progression and happiness if right on top of the priority list when it comes to this organisation, and as a result, they create personalised career progression plans from day one, and give you the choice of a number of exciting training course programmes that they will offer and pay for, so you keep up to date with what's exciting and hot in the Data market - Not good enough I hear you say… Well, this fantastic organisation also believes in staff flexibility in all areas, so you will get the chance to do some remote working or do the hours of your choice (you can start anytime between 7 am - 11 am, and leave early or late, depending on your circumstances), but no, it doesn't stop there also They also believe in rewarding good work and offer staff Bonus for good work, with lots of other goo perks that I'm sure you will be excited to hear about if you apply for this role. Role: Design and develop automated solutions to assist the business in its operation, utilising the Microsoft SQL Server 2016 suite of products Investigate and remediate issues arising in the overnight runs Analysing trends in the performance and behaviour of the Group's loan assets based upon historical data Ongoing reconciliation and validation of account data Production of regular and ad hoc reporting solutions as and when requested by the business areas across the organisation Producing analysis and insight to understand performance over time Provide recommendations to the business based on the results of analysis undertaken Ability to work in a controlled environment in adherence to the Data Governance Framework Develop a good understanding of Clients core IT servicing platforms and loan portfolios with the longer-term aim of rebuilding the Data Warehouse incorporating techniques such as dimensional modelling and the Kimball methodology Responsibility for testing new SQL code to ensure correct results are achieved before being incorporated into the 'Live' warehouse Applying GDPR standards to data Requirements Strong SQL background, with experience of T-SQL & SSIS Experience of designing and developing data warehouse solutions Experience of analysing and reporting on large/complex datasets Ability to develop new solutions using methodologies consistent with current solutions Strong commercial acumen Analytically focussed and detail conscious Excellent written and verbal communication skills Ability to work as part of a team Desirable: Experience within the Financial Services Industry Experience of using a database source control solution Experience of developing Power BI Datasets Numeric based degree (minimum 2:1) If you feel you have the required skills and experience to be considered for this opportunity and would like to hear more details, please forward an up to date version of your CV, and you will be contacted back within 24 hours Buzz Words - Business Intelligence / BI / DWH / Data Warehouse / SQL / ETL / SSIS / SSRS / SSAS / Power BI / Solihull / Birmingham / Permanent Jobs / Remote working / Flexible hours / Financial Services / Banking Sector Buzz Words - Business Intelligence / BI / DWH / Data Warehouse / SQL / ETL / SSIS / SSRS / SSAS / Power BI / Solihull / Birmingham / Permanent Jobs / Remote working / Flexible hours / Financial Services / Banking Sector This job was originally posted as www.totaljobs.com/job/89867522