London, Greater London, England, United Kingdom

Pantheon has been at the forefront of private markets investing for more than 40 years, earning a reputation for providing innovative solutions covering the full lifecycle of investments, from primary fund commitments to co-investments and secondary purchases, across private equity, real assets and private credit.

We have partnered with more than 650 clients, including institutional investors of all sizes as well as a growing number of private wealth advisers and investors, with approximately $65bn in discretionary assets under management (as of December 31, 2023).

Leveraging our specialized experience and global team of professionals across Europe, the Americas and Asia, we invest with purpose and lead with expertise to build secure financial futures.

For further details please visit www.pantheon.com

Purpose of Position

Pantheon is undergoing a multi-year programme to build out a new best in class Data Platform using cloud native technologies hosted in Azure. We require an experienced and passionate hands-on Senior BI Engineer to design and implement new Power BI Dashboards and Reports. This role will be integral to the success of this programme and establishing Pantheon as a data-centric organisation.

You will be part of a small and highly skilled team and you will need to be passionate about providing best in class solutions to our global user base.

Key Responsibilities

Pantheon require a highly capable, enthusiastic and experienced individual to join our team who will be responsible for leading the design & build of Pantheon’s BI capabilities. This will be achieved through developing solutions that are technically sound, forward looking and provide data in an intuitive manner.

The ideal candidate should have an excellent comprehension of Azure cloud services, have previous experience of building out dashboards for release enterprise wide and be a strong advocate for data visualisation.

To be successful in the role you will be expected to:

• Be an expert in delivering complete BI solutions.
• Great at designing visualisations and intuitive dashboards.
• Be comfortable in dealing with the Business and working strategically to define BI plans.
• Provide technical expertise for data acquisition, data set development, data modelling and report production.
• Coach and mentor team members in best practice and use of the BI toolset.
• Be expected to work closely with business colleagues to understand and jointly develop requirements to meet the needs of B.I. demands.
• Work closely with your Azure Data Engineering colleagues who will be building out the underlying data architecture.
• Be able to analyse data stores and recommend ways to improve data reliability, efficiency and quality.
• Someone with a positive can-do attitude, be open and welcoming to change, be a self-starter and be self-motivated.

Responsibilities include:

• Be a strong advocate for the effective and efficient use of the data sources within the business
• Design, build & deploy B.I. solutions using Microsoft Azure stack (PowerBI specifically
• Define and promote the team’s best practices and design principles for Business Intelligence
• Collaboration across teams to solve problems, develop & execute database queries and conduct analyses.
• Creating visualisations & reports for the Business Units
• Develop and update technical documentation.

Knowledge and Experience Required  

Essential Technical Skills

• Have at least 5 years’ experience in Business Intelligence and have built out enterprise dashboard solutions previously.
• Significant expertise of Data Analytics Expressions (DAX) – PowerBI
• Knowledge of Data Warehouse design (dimensional modelling) and data mining best practices
• Experience in implementing analytical workloads and service-service analytics scenarios.
• Experience of data transformation pipelines and workflow management tools
• Conversant with current industry developments and challenges with an interest in future trends
• Excellent communication skills with a natural problem-solving attitude.

Desirable Technical Skills 

• Familiarity in DevOps methodologies (Azure DevOps, Agile / Kanban / Scrum, CI/CD Pipeline etc.)
• Experience in Microsoft / Azure Stack (SQL Server, data lake, delta lake and Business Intelligence (SSIS, SSAS and SSRS))
• Other BI tools such as QlikSense, Tableau, Looker, ThoughtSpot