Business Intelligence Analyst

Saltus; Whiteley; Hybrid; GBP 45,000 - 60,000; Full time

Benefits offered by this job

28 days holiday + bank holidays

Life assurance

Income protection

Pension

Flexible benefits platform

Hybrid working model (3 days in office

Job summary

Saltus is seeking a BI Analyst to build and deliver Power BI reports and dashboards that turn data into clear, actionable insight for the business.

This hands-on role with real visibility involves data modelling, DAX calculations, Power Query shaping, and writing SQL to support reliable, scalable reporting. The role operates with hybrid working in Whiteley, UK, and offers a salary between £45,000 and £60,000 with generous benefits.

Qualifications

• 3+ years building and publishing Power BI reports used daily by a business.
• Experience designing semantic models and performance-focused data solutions.
• Strong capability with DAX time intelligence, filter context, variables and iterators.
• Hands-on Power BI Service administration: workspaces, deployment pipelines, refresh, gateways and security.
• Familiar with version control and a structured release/UAT process.
• Experience in financial services, wealth management or regulated environments.

Responsibilities

• Develop, publish and maintain Power BI reports and dashboards for business insight.
• Work from requirements, validate with the BA, and ensure deliverables are complete.
• Build calculations and semantic models using DAX; shape data with M/Power Query.
• Write SQL to source and validate data behind reports.
• Set up deployment pipelines and manage Power BI Service workspaces and refresh.
• Test thoroughly, perform peer reviews and support UAT before release.
• Document report logic, calculations and automation for ongoing support.
• Identify data gaps, duplicates, and anomalies, and raise issues with the business.
• Optimize reports for performance and data integrity; spot trends for business actions.

Skills

Power BI reports

DAX

Power Query

SQL

Deployment pipelines

UAT

Documentation

Data quality

Performance tuning

Data modelling

Power Automate

Tools

Power BI

DAX

Power Query

SQL

Power Automate

Job description

We are looking for a BI Analyst to build and deliver Power BI reports and dashboards that turn our data into clear, actionable insight for the business.

Building high-quality reports against requirements agreed with stakeholders is the core focus of the role. That is supported by the data modelling and querying needed to make those reports accurate and performant, and by documenting the work so it can be picked up and maintained by others.

This is a hands-on role with real visibility and the work you produce will be used daily by teams across the business.

Why Saltus?

Our mission is to improve everyone’s relationship with their wealth: to make it a positive force for their future and at the same time to prevent it being a source of anxiety. We want everyone who works at Saltus to be proud to work here, and to find fulfilment and meaning in the work that they do.

We are incredibly proud of our culture and work really hard to ensure that Saltus is a great place to work for our people, where they can have fun and grow in their career, with a passion for excellence and customer service.

We’re proud that we’ve been recognized as a winner by the Sunday Times in the Best Places to Work 2024 awards, as well as a winner in the Professional Adviser awards 2024 for the Best Financial Advisers to Work For. These accolades reflect our commitment to creating an exceptional work environment and our dedication to excellence in the financial industry. Join our award-winning team and be a part of our continued success!

Saltus is a privately owned financial planning and discretionary investment management house. We are dedicated to providing a high-quality service for private clients, trusts, and smaller institutions.

Saltus Partners was founded in 2004 and has grown organically and through a small number of carefully integrated acquisitions. Originally the business started out as an investment manager and has now developed the financial planning side of the offering, putting this at the forefront of the client relationship.

Today Saltus manages and advises on over £11 billion of client assets, acquired through a combination of organic business growth and corporate acquisitions.

What does this role look like?

• Develop, publish and maintain Power BI reports and dashboards that are accurate, performant and easy for the business to self-serve from.
• Work from requirements provided by the BA, reviewing them with the BA and challenging anything unclear or incomplete before development starts
• Work through the BA as the point of contact for stakeholders, keeping them updated on progress and raising anything that puts a delivery date at risk
• Build calculations, measures and semantic models using DAX.
• Shape, clean and combine data using M / Power Query, with resilient error handling.
• Write SQL to investigate, validate and source the data behind your reports.
• Set up and manage deployment pipelines and workspaces in the Power BI Service, including refresh schedules and access.
• Test your work thoroughly, review colleagues' reports and have your own reviewed, and support UAT before release
• Write procedures and technical documentation covering report logic, calculations and any automation, so others can support and extend what you build.
• Spot issues in the data - gaps, duplicates, figures that don't look right - and raises them rather than reporting them as-is
• Optimise reports for performance and scalability and look after data accuracy and integrity throughout.
• Notice patterns and trends in the data and brings them to the business's attention

What we are looking for

• 3+ years building and publishing Power BI reports and dashboards used daily by a business
• Designs semantic models from scratch - relationships, understands why it matters for performance
• Confident with DAX beyond the basics: time intelligence, filter context, variables, iterators
• Strong Power Query / M - shaping and combining messy sources with error handling that doesn't break on refresh
• Hands-on with the Power BI Service: workspaces, deployment pipelines, refresh schedules, gateways, access and row-level security
• Optimises for performance and can explain what was slow and why
• Experience administering the Power BI Service - workspaces, deployment pipelines, gateways, row-level security.
• Documents what they build the logic, calculations, refresh setup so someone else can support it
• Well organised, with a track record of delivering to agreed timescales
• Naturally curious about the data: notices anomalies, breaks and emerging trends, and flags them to the business
• Experience administering the Power BI Service - workspaces, deployment pipelines, gateways, row-level security.
• Power Automate, or other workflow automation connected to reporting.
• Familiarity with version control and a structured release or UAT process.
• Experience in financial services, wealth management or another regulated environment.

Where will I be working?

We are looking for someone to be based out of our Whiteley office, and offer hybrid working, which includes 3 days in the office, with the remainder at home. We’re incredibly flexible about when and how you work: we don’t want anyone to be prevented from coming to work for Saltus as a result of the working pattern that they’re looking for. We are passionate about championing flexible working for our people, so if there’s a slightly different working pattern that you’re looking for, then please come and have a chat to us about it!

What benefits do I get when working for Saltus?

The salary is between £45,000 to £60,000pa (DOE), alongside 28 days’ holiday (plus bank holidays), life assurance, income protection and a pension, alongside access to our flexible benefits platform. The role is 40 hours per week between the hours of 8.30-5.30pm. Just as importantly, you’ll get to experience our culture, which we really do live and breathe ensuring that Saltus is a fantastic place to work for every single one of our 500+ people. We work hard, but we have an awful lot of fun along the way. If you think you’d like to come and join us, then please do get in touch... we’d love to hear from you!