Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and build BI solutions for the loan lifecycle using modern data platforms.
- Company: Join a forward-thinking financial services company with a focus on innovation.
- Benefits: Competitive salary and benefits package, plus opportunities for growth.
- Why this job: Make an impact by transforming complex financial data into actionable insights.
- Qualifications: Experience with Power BI, Azure Data Factory, and strong financial knowledge required.
- Other info: Dynamic team environment with a commitment to diversity and inclusion.
The predicted salary is between 36000 - 60000 £ per year.
Are you an experienced Business Intelligence Developer looking for your next challenge? If yes, please read on as my client is seeking a highly skilled BI Developer to join their team.
The ideal candidate will have hands-on experience with modern data platforms, including Azure Data Factory, Databricks, and Power BI, combined with strong financial domain knowledge in loans and lending. This role requires both technical expertise in building BI solutions and the ability to understand and translate complex financial requirements into meaningful insights for the business.
Responsibilities
- Design, build, and maintain BI solutions to support reporting and analytics across the loan/lending lifecycle (origination, servicing, collections, and delinquency).
- Develop and optimize ETL/ELT pipelines using Azure Data Factory and Databricks (Delta Lake, Medallion Architecture).
- Design and implement semantic data models that serve as a single source of truth for reporting.
- Create and maintain Power BI dashboards and reports, ensuring accuracy, usability, and performance.
- Work closely with business stakeholders to gather, define, and validate reporting and analytics requirements.
- Ensure data quality, consistency, and governance across all data layers.
- Collaborate with data engineers, analysts, and project managers to deliver high-quality BI solutions on time.
- Apply financial knowledge of loan products, repayment schedules, interest calculations, and delinquency metrics to ensure data and reports align with business needs.
- Document solutions, data definitions, and processes for long-term maintainability.
Required Skills & Experience
- Proven experience as a BI Developer or similar role.
- Strong proficiency in Power BI (data modeling, DAX, performance tuning, publishing).
- Solid understanding of data warehousing concepts and Medallion architecture (Bronze, Silver, Gold layers).
- Experience in financial services with knowledge of loans and lending products (origination, repayment schedules, interest calculations, delinquency tracking).
- Experience with relational databases (e.g., SQL Server, PostgreSQL).
- Strong SQL skills (query optimization, stored procedures, views).
- Ability to gather and translate business requirements into technical solutions.
- Strong analytical, problem-solving, and communication skills.
Compensation
Competitive salary - plus benefits package.
If you're excited by everything you've read above and have the experience to match, please get in touch as we would love to tell you more!
Business Intelligence Developer in London employer: Vivid Rock
Contact Detail:
Vivid Rock Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Developer in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at companies you're interested in. A friendly message can go a long way in getting your foot in the door.
✨Tip Number 2
Prepare for interviews by practising common BI-related questions. Make sure you can talk confidently about your experience with Azure Data Factory, Databricks, and Power BI. We want you to shine!
✨Tip Number 3
Showcase your skills with a portfolio! Create a few sample dashboards or reports that highlight your expertise in financial data analysis. This will give potential employers a taste of what you can do.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take the initiative to connect directly with us.
We think you need these skills to ace Business Intelligence Developer in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Business Intelligence Developer role. Highlight your experience with Azure Data Factory, Databricks, and Power BI, as well as any financial domain knowledge you have. We want to see how your skills match what we're looking for!
Showcase Your Projects: Include specific examples of BI solutions you've designed or built in the past. If you've worked on ETL/ELT pipelines or created Power BI dashboards, let us know! This helps us understand your hands-on experience and how you can contribute to our team.
Be Clear and Concise: When writing your application, keep it clear and to the point. Use bullet points where possible to make it easy for us to read through your qualifications and experiences. We appreciate straightforward communication!
Apply Through Our Website: We encourage you to apply directly through our website. This ensures your application gets to the right place and allows us to process it more efficiently. Plus, it shows you're serious about joining our team!
How to prepare for a job interview at Vivid Rock
✨Know Your Tools Inside Out
Make sure you’re well-versed in Azure Data Factory, Databricks, and Power BI. Brush up on your DAX skills and be ready to discuss how you've used these tools to build effective BI solutions in the past.
✨Understand the Financial Landscape
Since this role requires strong financial domain knowledge, take some time to review key concepts related to loans and lending. Be prepared to explain how you’ve applied this knowledge in previous projects, especially around repayment schedules and delinquency metrics.
✨Prepare for Technical Questions
Expect to face technical questions about data warehousing concepts and ETL/ELT processes. Practise explaining your approach to designing semantic data models and optimising query performance, as these are crucial for the role.
✨Showcase Your Collaboration Skills
This position involves working closely with various stakeholders. Be ready to share examples of how you’ve gathered and translated business requirements into technical solutions, highlighting your communication and problem-solving skills.
