Business Intelligence Analyst

This position combines data engineering, semantic modelling, and analytics delivery, and is responsible for creating reliable and, 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

• 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

• £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.