At a Glance
- Tasks: Design and build BI solutions for the loan lifecycle using modern data platforms.
- Company: Join a dynamic team at a leading financial services tech company.
- Benefits: Competitive salary and benefits package, with opportunities for growth.
- Other info: Collaborative environment with a focus on diversity and inclusion.
- Why this job: Make an impact by transforming complex financial data into actionable insights.
- Qualifications: Experience in BI development, Power BI, and financial services required.
The predicted salary is between 63000 - 77000 £ 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 employer: Vivid Rock
Join a well-established civil and structural engineering consultancy in South Wales, where you will be part of a friendly and collaborative team dedicated to delivering high-quality design solutions. With a strong focus on professional development, including chartership mentoring, and flexible working arrangements, this company offers a supportive environment for both Graduate and Experienced Structural Engineers to thrive and work on diverse, technically challenging projects.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Developer
✨Get to Grips with Data Visualisation Tools
If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.
✨Join Local Business Intelligence Meetups
Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like Vivid Rock!
✨Engage with Online BI Communities
Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.
✨Leverage Your University’s Career Support
If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!
We think you need these skills to ace Business Intelligence Developer
Some tips for your application 🫡
Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.
Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.
Tailor Your Documents for Us:When applying for a full-time role at Vivid Rock, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!
Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.
How to prepare for a job interview at Vivid Rock
✨Show off your analytical skills
In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!
✨Practice your technical know-how
Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.
✨Portfolio of Projects
Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.
✨Know their business model
Get familiar with Vivid Rock’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.