Job Description

Posted 2 weeks ago

Power BI Specialist – London (SW1)

My client a market leading provider grants clients access to bespoke data insights and analytics specific to their needs, providing research, data and expertise to support clients and all lines of business (Advisory, Digital, Search). They is an innovation centre focused on illuminating key trends and drivers of human and organizational performance, and also has a focus on delivering deep insights to clients, working collaboratively with our colleagues across the business.

We are seeking an experienced and highly skilled Power BI Specialist to join our team. You will be responsible for designing, developing, and maintaining complex Power BI solutions to meet the analytical needs of our organisation, as well as advising on and maintaining our Power BI architecture and environment.

This role will be based from my clients SW1 office, however both the hybrid working model and salary / package are to be discussed during interview as it will vary from candidate to candidate (Please note however all candidates must be within a commutable distance to London and have the full right to work in the UK!)

Responsibilities:

Power BI architecture, environment and dataflows

Establish best practices and standards for managing Power BI artifacts, including reports, datasets, and dataflows within workspaces.
Configure and manage dataflows to ingest, transform, and prepare data from various sources for analysis within Power BI.
Develop and implement strategies for automating data refresh processes to keep Power BI reports and dashboards up-to-date.
Manage Power BI deployment pipelines for development, testing, and production environments.
Leverage Power BI REST APIs to automate CI/CD pipelines for updating, publishing, and deploying numerous dashboards at scale.

Power BI development

Develop advanced Power BI reports, dashboards, and interactive visualizations that provide actionable insights and drive data-driven decision-making.
Design and implement efficient and scalable data models using Power BI Desktop and SQL Server Analysis Services (SSAS).
Write complex M query and DAX calculations to manipulate and transform data for analysis and reporting purposes.
Integrate Python and/or R scripts into Power BI for data transformation and data visualization.
Optimise performance of Power BI reports and dashboards to ensure fast load times and smooth user experience.

Documentation, training and support

Create and maintain documentation related to Power BI solutions, including data models, calculations, and report designs.
Provide training and support to upskill other data scientists on how to improve their Power BI capabilities.

Requirements:

5 – 10 years of experience in business intelligence and data analytics, ideally with 5 years of hands-on experience with Power BI.
Expertise in designing and developing complex Power BI reports and dashboards from scratch, with strengths in creating elegant, highly professional data visualisations.
Strong understanding of data modeling and data integration concepts and experience building data models using Power BI Desktop and SSAS.
Proven expertise in designing and implementing Power BI architecture, including workspaces, datasets, and dataflows.
Proficiency in Power Query M language and writing advanced DAX calculations and optimizing performance of Power BI solutions.
Proficiency in configuring and managing data refresh schedules and automating data pipelines in Power BI.
Experience working with large and complex datasets from multiple sources.
Experience working with Power BI gateways.

Microsoft Power BI certification(s) – Desirable.

If the above role is of interest and you've got the required experience, apply with your most up to date CV for immediate consideration and interview!

Alternatively, if you would like to find out more about the position, reach out to me on (phone number removed) or at

In Technology Group Ltd is acting as an Employment Agency in relation to this vacancy