Job Advert
Job Title: Senior Business Intelligence Analyst
Role Summary
This position combines data engineering, semantic modelling, and analytics delivery, and is responsible for creating reliable and high-performing reports used throughout the business.
Experience & Qualifications
-
Technical proficiency in BI, analytics engineering, or data engineering roles.
-
Degree in a relevant field or equivalent professional experience and certifications.
-
Experience delivering BI solutions in complex, legacy data landscapes is essential.
Core Responsibilities
-
Design and implement end-to-end Power BI solutions, including data ingestion, semantic models, dashboards, paginated reports, and apps.
-
Develop and maintain robust Power BI semantic models featuring clear logic, reusable measures, and strong performance.
-
Work effectively in legacy environments to enhance data quality, simplify models, and update reporting processes.
-
Collaborate with stakeholders to deliver analytics that are trusted, high-performing, and essential for decision-making.
Technical Skills & Experience
-
Strong SQL skills and experience working with large datasets.
-
Power BI
-
Experience implementing and managing Row Level Security (RLS), Object Level Security (OLS), and role-based access.
-
Expertise in DAX (performance-optimized, reusable logic), Power Query, and transformations.
-
Experience with dashboards and interactive reports and creating paginated reports using Power BI Report Builder.
-
Power BI Embedded
-
Microsoft Fabric & Azure
-
Lakehouse and Warehouse
-
Azure Data Factory (or Fabric equivalents) and pipelines
-
Dataflows Gen2
-
Microsoft Excel (pivots, vlookups, Macros)
-
Crystal Reports
What can we offer you?
-
£50,000 per annum
-
40 hours per week, Monday – Friday 08.30 -17.00 (40 hours a week)
-
Up to 25 days holiday (including bank holidays) plus optional 5 unpaid days
-
Company Pension Scheme
-
Life Assurance
-
A rewards scheme – 200+ exclusive perks and discounts from leading retailers and leisure outlets
Millbrook Healthcare Group are an inclusive and caring employer who understand that not everyone’s job needs are the same. Therefore we are open to supporting flexible working requests such as part time working, job shares and flexible hours wherever possible, to support our colleagues life style differences. So please feel free to let us know of any specific requirements you may have and these can then be discussed in more detail if you are successful in your application.
Our ambition at Millbrook Healthcare is to become the leading provider in the assisted living sector whilst ensuring our core company values ‘CARES’ remain unchanged. We are always looking to recruit hard working and talented individuals to become a part of our ongoing growth and success. You’ll enjoy all the support and encouragement you need to reach your own potential and develop a rewarding career along the way.
Care and respect for our colleagues and service users
Accountable and proud
Ready to learn and grow
Enhance our service users’ lives
Socially responsible, ethical and transparent
This role is working in a regulated activity and may be subject to a standard DBS disclosure and Social Media Screening.
No terminology in the advert you have seen is intended to discriminate on the grounds of age, gender, race, colour, religion, disability or sexual orientation, and we will gladly accept applications from all sections of the community.
