Job Description

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.



We work alongside employers, trustees and financial services institutions, offering independent pensions, investments, benefits and risk consulting services, as well as data and technology solutions.


That's the who and the what. More important is the 'why'. The work we do may not always seem the sexiest. But it's difficult, it's complex, and it's important. We help our clients, their employees, members and customers make decisions that have real and direct consequences on their financial futures.


For 100 years we've taken this responsibility seriously. Together, as a team and with our clients and partners, we're here to build better futures.