The Vacancy
We currently have an exciting opportunity to join our Finance department as a Power BI Analyst in our Glasgow Office.
*We are open to considering candidates on a part time or full-time basis*
What will your role look like?
As a Power BI Analyst, you’ll work closely with Finance and other key stakeholders to design, develop, and maintain insightful Power BI dashboards and reports. You’ll be responsible for gathering and documenting requirements, managing data sources, and delivering high-quality reporting solutions that support strategic decision-making.
Though this is a varied role, your key tasks will include:
- Design and build Power BI dashboards and reports using a variety of on-premise and cloud-based data sources.
- Translate business requirements into effective data visualisations and reporting solutions.
- Maintain and optimise the data warehouse and SQL data models that support Power BI.
- Collaborate with data engineers to ensure the data warehouse is up to date and fit for purpose.
- Engage with stakeholders to understand their data needs and provide tailored reporting solutions.
- Conduct unit testing and troubleshoot data or reporting issues.
- Promote the adoption of Power BI across the business and support end users.
- Act as a subject matter expert in data reporting best practices.
- Ensure data quality, security, and governance standards are upheld.
- Contribute to the roadmap for management information (MI) and reporting development.
- Provide training and share knowledge with colleagues to build internal capability.
- Work with other Power BI users across the firm to enhance our reporting approach.
- Maintain up-to-date technical documentation and user guides.
- Stay informed on industry trends and emerging technologies.
To enjoy and succeed in this role, you will have:
- Proven experience developing Power BI dashboards and reports.
- Strong SQL querying and DAX skills, with a deep understanding of data modelling (e.g. star schema).
- Excellent data visualisation and storytelling capabilities.
- Experience with data models, integration techniques, data mining, and database design.
- Strong analytical and problem-solving skills with great attention to detail.
- Ability to manage relationships and influence stakeholders across the business.
- A genuine interest in coding and data analysis.
- Self-motivated with a drive to identify opportunities and deliver improvements.
Desirable
- Experience with Power BI Report Builder (Paginated Reports).
- Microsoft Certified Data Analyst (or working towards).
- Background in finance systems or working within a finance team.
We would also encourage applications from candidates who perhaps do not possess all the attributes and experience listed above but are competent with the majority and would be able to quickly develop the additional skills and experience required in post with our full support.
In addition to a competitive salary and access to our profit share scheme, we offer:
- A flexible selection of employee benefits, so you can choose a package that best matches your lifestyle and needs.
- A collaborative and encouraging work environment where your thinking and ideas are encouraged.
- On site mental health and wellbeing assistance.
- A commitment to helping you develop both personally and professionally, with mentoring opportunities and access to our award-winning learning portal, Aspire.
- Regular social activities, in addition to three days paid volunteering leave each year and a day’s leave to celebrate your birthday.
- Hybrid working so you can enjoy the positive wellbeing of working from home as well as the benefits of meeting colleagues in our sociable, modern office environments – with the expectation of two ‘in-office’ days per week.
- A flexible working window, allowing colleagues the freedom to work flexibly between the hours of 7am and 7pm.
Please note, we recruit on a rolling basis so early applications are recommended to avoid disappointment.
About Us
Together, we’ve been building better futures for over 100 years. For our people, our clients and their people, our communities and the environment.
We thrive on tackling complex problems. And we believe those problems are best solved by diverse teams – diverse in skills, approaches and backgrounds. Our independence lets our people be themselves and think freely, while working in a collaborative, supportive environment. We love innovative, independent thinking and want everyone to share their ideas.
Working alongside employers, trustees and financial services institutions, we offer pensions, investments, benefits and risk consulting services, as well as data and technology solutions. With over 1000 employees and counting, we’re one of the leading consultancies in our field and are proud to be recognised by numerous industry awards.
We’re committed to developing our people and encourage everyone to carve out their own career path. We’ve many colleagues who started out in one team in the business and have ended up somewhere completely different, having had the chance to develop new skills and explore new passions.
We are continually working to improve our inclusive culture and employ diverse talent. We therefore welcome applications from people from all backgrounds, which includes but isn’t limited to: age, disability, ethnic heritage, gender, marital or civil partnership status, neurodiversity, religion, sexual orientation, and socio-economic background.
Our hybrid working model offers the best of both worlds – home working as well as a fun, collaborative office environment - meaning flexible working patterns to accommodate individual needs. Find out more about our careers
here .
If you need any assistance in relation to a personal requirement, medical condition or neurological difference during our selection process then please let us know.
Together, we can make this the best job you’ll ever have.
We Offer
Our culture
We live and breathe our four values – friendly, confident, partnering and straightforward – and genuinely care about out people, clients, community and the environment.
Job satisfaction
Every employee can genuinely make a difference and contribute towards achieving our purpose – together, building better futures. Whether that’s helping our clients build more secure financial futures, using your 3 days volunteering or helping us reduce our carbon footprint.
Reward and wellbeing
We offer competitive salaries, a share of company profits and an award-winning benefits package. We also take your mental, physical, social and financial wellbeing seriously, both in and outside of work.
Flexible working
We trust our people to work in a pattern that suits their circumstances with a healthy balance of home and office working.
Latest technology
We use the most up-to-date technology and software to match our ground-breaking business solutions that make life easier for us and our clients.
Career development
There is no linear path – learning opportunities are plentiful and empower you to carve out your own career.
