Business Intelligence Developer

Vivid Rock

United Kingdom

On-site

GBP 55,000 - 75,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A progressive consulting firm in the UK is looking for a Mid-Senior level BI Developer to design and maintain business intelligence solutions. The ideal candidate has strong experience with Power BI, Azure Data Factory, and a solid understanding of financial services, especially loans and lending metrics. This full-time position offers competitive salary and benefits, and the role is primarily on-site in London.

Qualifications

Proven experience as a BI Developer or similar role.
Strong proficiency in Power BI (data modeling, DAX, performance tuning).
Solid understanding of data warehousing concepts and Medallion architecture.

Responsibilities

Design, build, and maintain BI solutions for reporting and analytics.
Develop and optimize ETL/ELT pipelines using Azure Data Factory.
Create and maintain Power BI dashboards and reports.

Skills

Power BI

Data warehousing concepts

Financial services experience

SQL skills

Analytical skills

Problem-solving skills

Communication skills

Tools

Azure Data Factory

Databricks

SQL Server

PostgreSQL

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Vivid Rock

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! Email – colin@vividrock.co.uk

Note This role is being advertised by Vivid Rock. We appreciate it’s a tricky time to navigate your career and it’s important to be authentic about the opportunities we share here. Please only apply if you meet the essential criteria outlined above.

We are expecting a high volume of applications; we may not be able to respond to every applicant. We will get in touch if we are keen to take your application further.

Vivid Rock is committed to championing diversity and challenging unconscious bias. Thank you for your interest and please follow our page for updates.

Seniority level