At a Glance
- Tasks: Create impactful Power BI reports and dashboards that drive business insights.
- Company: Join Saltus, an award-winning financial planning and investment management firm.
- Benefits: Enjoy a competitive salary, 28 days holiday, and flexible working options.
- Other info: Flexible working patterns available to suit your lifestyle.
- Why this job: Make a real difference with your data skills in a fun and supportive environment.
- Qualifications: 3+ years of Power BI experience and strong DAX skills required.
The predicted salary is between 45000 - 60000 £ per year.
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.
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 raise 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 bring 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 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.
BI Analyst employer: Saltus Partners LLP
Saltus Partners LLP is an exceptional employer, offering a dynamic work environment in the heart of London where innovation and collaboration thrive. With a strong focus on employee development, the company provides ample opportunities for growth within the financial services marketing sector, alongside a competitive salary and benefits package. The hybrid working model ensures a healthy work-life balance, making it an ideal place for graduates eager to kickstart their careers.
StudySmarter Expert Advice🤫
We think this is how you could land BI Analyst
✨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 Saltus Partners LLP!
✨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 BI Analyst
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 Saltus Partners LLP, 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 Saltus Partners LLP
✨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 Saltus Partners LLP’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.
