Job Description
BI Data Analyst
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. You know 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 the management direction of the organisation. You can translate, develop and professionalise the vision and strategy of data warehousing within the 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 ensuring 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 the 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 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
You and your experience
Qualifications
- HBO/WO education, preferably with a focus on Computer Science, Statistics, Mathematics
Knowledge & Experience
- 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)
Skills & Capabilities
- Excellent technical and analytical skills with regards to design goals for modelling OLTP and dimension modelling for OLAP;
- 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 full-time 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 we 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 we 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