Business Intelligence Analyst

Portman Dental Care

Company Description

PortmanDentex is one of the largest dental groups in the UK.

We value diversity and the unique perspectives our colleagues bring, promoting a culture of collaboration and continuous improvement. With an unwavering commitment to patient care at our core, we focus on delivering exceptional experiences every day.

Job Description

Are you a Business Intelligence Analyst looking for a new challenge in a fast-paced, high-growth business?  If so, we have a new vacancy at this level in our Technology team. 

You’ll have the opportunity to work closely with our Business Intelligence function to drive the current deployment and future development of our company-wide Data Warehouse.  You’ll be an expert, champion and trusted point of contact for the Data Warehouse across the business, supporting its maintenance as well as resolving any issues that arise.

Some of your key responsibilities will include:

  • Overseeing the ongoing maintenance and housekeeping of the company-wide Data Warehouse, liaising with all functions, particularly with Finance, People (HR), Operations, Marketing and IT
  • Helping to define requirements and shape the content for future automated daily, weekly and monthly reporting from the Data Warehouse
  • Developing enriched content within analysis dashboards using Microsoft PowerBI to author queries, datasets, visuals and reports
  • Ensuring that all agreed reports are produced from the Data Warehouse in a timely manner and sent to the relevant recipients on a working-daily basis

You can read the full job description here


We welcome your application if you have the following qualifications and skills:

  • Microsoft PowerBI to an Intermediate/Advanced level, including understanding and writing DAX
  • A background in producing regular reporting
  • Data visualisation and analytics experience, for example using Microsoft SSRS, Google Data Studio, Tableau or PowerBI
  • Experience of data warehouses with knowledge and ability of reading and writing SQL
  • In-depth understanding of database design and management
  • Broad level of commercial awareness, and the information needs of different functions within a business
  • Problem solving skills and creativity evidenced by experience in writing complex Excel formulas or the equivalent in PowerBI
  • An understanding of report design and how to convey information to end users in a clear and informative way using tables, graphs and other similar visuals

Additional Information

At PortmanDentex, you’ll be part of an inclusive, collaborative team environment where your development and potential are encouraged, and your new ideas and innovative approaches are welcomed.

We offer a hybrid working model that allows you to split your week between working from home, and our support office in Cheltenham.  Alternatively, you can work remotely from anywhere in the UK – as long as you’re able to visit the office as required for meetings (potentially monthly or at most bi-monthly).  Our office is conveniently located opposite the racecourse entrance.  It features a café on-site, free parking, and is surrounded by beautiful parkland.

In addition to a competitive salary, our benefits package includes:

  • Bonus scheme which recognises our combined contribution
  • 25 days of annual leave plus bank holidays, special days off (such as your birthday), and the opportunity to purchase up to 3 additional annual leave days
  • Enhanced maternity and paternity leave
  • Life assurance and contributory pension scheme
  • Health and Wellbeing benefits, including an expensed dental check-up and hygienist appointment per year, confidential helpline and counselling services, and access to a 24/7 GP service

If you’re ready to make a difference and showcase your skills, apply for our Business Intelligence Analyst vacancy by submitting your latest CV. Alternatively, please feel free to share this opportunity with your friends or colleagues who may be interested.



We are an equal opportunity employer and value diversity, equity and inclusion in our workplace. We are committed to creating an environment of mutual respect and are dedicated to providing equal employment opportunities regardless of race, religion or belief, sex, sexual orientation, gender reassignment, pregnancy or maternity, marital or civil partner status, disability, age, or nationality.

Apply now
To help us track our recruitment effort, please indicate in your email/cover letter where ( you saw this job posting.

Job Location