Your role
In your role as BI Data Analyst you understand, analyse and communicate data requirements, liaising with users, business analysts and other developers to ensure adherence to development standards and processes within Lloyds Bank GmbH. You have knowledge of the banking industry reporting standards and contribute on that basis to the Data Warehouse report development through thorough analysis and advanced understanding of data warehousing techniques including the ETL process and dimensional modelling (Kimball).
You close the gap between business questions, BI concepts, techniques and tools used to improve management direction of the organisation. You are able to translate, develop and professionalise the vision and strategy of data warehousing within BI team further. You independently translate a strategy in clear actions and organised projects from scratch based on business requirements, design and documentation.
Your responsibilities
Data Analysis
- Analysing complex datasets ensuring data accuracy and integrity while translating business requirements to technical requirements
- Continuous collaboration with team and Business
- Drive efficient and practical change management on processes, assessing their impact, and assure they land successfully within the team
- Follow up on incidents, including root cause analysis, formulation of tactical/structural solutions and communication to both clients and management
- Define BI Management Reports for Credit Risk, Finance, Collections and Recoveries, Marketing and Sales, Operations, Management, Business Risk and other departments as prioritised on the BI Product backlog
- Maintain relevant documentation such as data flows within core documentation repository
Stakeholders Collaboration
- Acquire and maintain knowledge of business processes for Mortgages and other financial business processes as required
- Explain technical challenges to business users and create workable solutions together with business stakeholders
Continuous Improvement:
- Keep yourself up-to-date with Mandatory Training to operate within Lloyds Banking Group standards and keep knowledge of BI field.
- Keeping up-to-date with the latest trends and technologies in data analytics and BI
- Recommending and implementing improvements to existing BI processes and tools
-9.jpg)
About Lloyds Bank
Lloyds Bank GmbH is part of Lloyds Banking Group, a financial institution with a large clientele in the UK and other parts of the world. Together with our office in Berlin, we form Lloyds Bank GmbH with its headquarters in Amsterdam and we have over 500 colleagues.
We aim to lead by example in the bold decisions we make as a business, from where and how we invest, to the products and services we offer, and of course the workplace we create. We will search for new ways to work with people, communities and businesses, to always evolve with their needs. And we will never stop innovating to make sustainable, ethical choices easy and rewarding.
At Lloyds Bank GmbH we play an important part in peoples’ lives, by the products we offer, and also how we operate. We finance your mortgage, keep your savings secure and also provide you with a personal loan if you need this. In Amsterdam we do this with an enthusiastic team of approximately 200 colleagues from different nationalities, and with an engagement score of 93%, colleagues find us a real ‘Great Place to Work’!
With our grand ambitions, we are looking for new colleagues who will bring fresh ideas to help us grow!
You and your experience
Experience and Knowledge
- 3 years experience in a related field
- Experienced in creating and reviewing ETL design and mapping specifications documents;
- Experienced in T-SQL based on SSMS versions 2016 and higher, PowerBI (nice to have)
Qualifications
- HBO/WO edcucation, preferably with a focus on Computer Science, Statistics, Mathematics
Skills and Capabilities
- Excellent technical and analytical skills with regards to design goals for modelling OLTP and dimension modelling for OLAP;
- Excellent communication skills in English and Dutch (verbal and writing);
- Strong customer focus
What's in it for you?
On top of being part of a great group of colleagues we offer you a position for 32 to 40 hours a week. This aligns with a compensation package in line with the market and excellent secondary employee benefits, including:
- 13th month salary, either paid monthly or once a year in December
- 30 days PTO (or 240 hours) per year (based on fulltime employment)
- You can ‘Swap Days’ to exchange Dutch National Holidays for another day of your choosing
- Non-contributory pension scheme
- You can join our collective medical scheme with a discount
- To support our Green goals, we encourage you to purchase a bike via our bike plan
- We want you to be healthy, so support you in joining a gym of your choosing through our sponsored (bedrijfs-) Fitness
- Get to know everyone in person and join the quarterly Connection Events
We also value your work-life balance, so offer;
- Flexible working; you can schedule your work hours to meet your personal needs
- Hybrid working; you can work from anywhere, even work from another country within the EU
- And provide you with a home office set up
Your recruitment process
Apply to our vacancies by sending your CV and motivation letter to recruitment@lloydsbank.nl, or use the application form on our website. After receiving your application, we'll review it and share a reply as soon as possible.
Your first chat with us will take place either online or at our Amsterdam office. The goal of this chat is get to know each other, and see if there's a match with the team, the organisation and the open position.
We're excited to have you meet additional collagues. The chat will take place either online or at our Amsterdam office, during which we'll dive deeper into the requirements of the position and the team you'll be joining.
Congratulations! We're happy to have you as our newest addition to the team. Do you feel the same way? Then you'll receive our offer by email. For most roles, a screening is part of the process. This will take place after accepting the offer.
Are you ready to join our journey?
Have we made you curious, and are you ready to join the team? Please introduce yourself to us in the best way possible and send this to: recruitment@lloydsbank.nl, or use the application form on our website.
We hope to meet you soon!