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.
