Microsoft Power Query
UK

The following table provides summary statistics for permanent job vacancies with a requirement for Power Query skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Power Query over the 6 months to 28 May 2024 with a comparison to the same period in the previous 2 years.

6 months to
28 May 2024
Same period 2023 Same period 2022
Rank 695 773 1022
Rank change year-on-year +78 +249 -199
Permanent jobs citing Power Query 221 179 216
As % of all permanent jobs advertised in the UK 0.22% 0.18% 0.13%
As % of the Database & Business Intelligence category 1.21% 0.85% 0.46%
Number of salaries quoted 143 141 146
10th Percentile £36,750 £36,250 £32,500
25th Percentile £41,250 £42,500 £38,750
Median annual salary (50th Percentile) £47,500 £57,500 £50,000
Median % change year-on-year -17.39% +15.00% +33.33%
75th Percentile £57,500 £72,500 £65,000
90th Percentile £67,500 £78,750 £71,692
UK excluding London median annual salary £45,000 £46,350 £42,500
% change year-on-year -2.91% +9.06% +21.43%

All Database and Business Intelligence Skills
UK

Power Query is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database or business intelligence skills.

Permanent vacancies with a requirement for database or business intelligence skills 18,328 21,007 47,066
As % of all permanent jobs advertised in the UK 17.86% 21.58% 28.19%
Number of salaries quoted 12,523 13,073 21,105
10th Percentile £35,000 £37,500 £36,250
25th Percentile £42,725 £47,500 £45,000
Median annual salary (50th Percentile) £57,500 £65,000 £60,000
Median % change year-on-year -11.54% +8.33% +9.09%
75th Percentile £77,500 £82,500 £80,000
90th Percentile £97,500 £103,750 £95,000
UK excluding London median annual salary £52,500 £55,000 £52,500
% change year-on-year -4.55% +4.76% +10.53%

Power Query
Job Vacancy Trend

Job postings citing Power Query as a proportion of all IT jobs advertised.

Job vacancy trend for Power Query in the UK

Power Query
Salary Trend

3-month moving average salary quoted in jobs citing Power Query.

Salary trend for Power Query in the UK

Power Query
Salary Histogram

Salary distribution for jobs citing Power Query over the 6 months to 28 May 2024.

Salary histogram for Power Query in the UK

Power Query
Top 16 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Power Query within the UK over the 6 months to 28 May 2024. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Jobs
England +126 201 £47,500 -29.63% 46
UK excluding London +58 178 £45,000 -2.91% 26
Work from Home +53 74 £46,664 -10.69% 19
South East +55 72 £45,000 -2.91% 7
North of England +65 46 £47,500 +15.15% 7
London +104 33 £67,500 -3.57% 20
Midlands +8 28 £41,492 -17.02% 7
Yorkshire +83 23 £47,500 +18.75% 2
North West +21 23 £41,500 -2.35% 4
West Midlands +16 17 £38,500 -26.67% 3
South West -14 17 £52,500 - 3
East Midlands -8 11 £41,492 -12.65% 4
Scotland -55 10 £42,500 -10.53%
Wales -8 3 - -
East of England -9 1 £62,500 +56.25% 3
Isle of Man - 1 £36,000 -

Power Query
Co-occurring Skills and Capabilities by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same employment type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 16 (7.24%) SharePoint
2 4 (1.81%) Confluence
3 2 (0.90%) IBM Domino
3 2 (0.90%) SAS
4 1 (0.45%) CMS
Applications
1 59 (26.70%) Microsoft Excel
2 8 (3.62%) Spreadsheet
3 7 (3.17%) Microsoft PowerPoint
4 4 (1.81%) Trello
5 3 (1.36%) Microsoft Office
Business Applications
1 33 (14.93%) Dynamics CRM
2 8 (3.62%) Dynamics NAV
3 7 (3.17%) Dynamics AX
Cloud Services
1 180 (81.45%) Power Platform
2 84 (38.01%) Azure
3 39 (17.65%) PowerApps
4 31 (14.03%) Dynamics 365
5 29 (13.12%) Power Automate
6 13 (5.88%) Azure Data Factory
7 9 (4.07%) Azure Synapse Analytics
7 9 (4.07%) Microsoft 365
8 7 (3.17%) Azure DevOps
9 6 (2.71%) GCP
9 6 (2.71%) Google Analytics
10 5 (2.26%) GitHub
11 4 (1.81%) Azure Cosmos DB
11 4 (1.81%) Google Data Studio
11 4 (1.81%) Google Sheets
11 4 (1.81%) Google Tag Manager
11 4 (1.81%) PaaS
12 3 (1.36%) AWS
12 3 (1.36%) Google Workspace
13 2 (0.90%) Azure Sentinel
Communications & Networking
1 1 (0.45%) DNS
1 1 (0.45%) HTTP
Database & Business Intelligence
1 179 (81.00%) Power BI
2 38 (17.19%) SQL Server
3 36 (16.29%) Data Lake
4 33 (14.93%) SQL Server Integration Services
5 25 (11.31%) SQL Server Reporting Services
6 19 (8.60%) Data Warehouse
7 18 (8.14%) Tableau
8 14 (6.33%) PowerPivot
9 12 (5.43%) SQL Server Analysis Services
10 8 (3.62%) Star Schema
11 7 (3.17%) Azure SQL Database
12 6 (2.71%) QlikView
13 4 (1.81%) MySQL
13 4 (1.81%) Semantic Layer
14 2 (0.90%) Big Data
14 2 (0.90%) BigQuery
14 2 (0.90%) Microsoft Analysis Services
14 2 (0.90%) Relational Database
15 1 (0.45%) MS Access
15 1 (0.45%) Sisense
Development Applications
1 19 (8.60%) SQL Server Management Studio (SSMS)
2 6 (2.71%) JIRA
3 4 (1.81%) Visual Studio
4 3 (1.36%) Git
General
1 106 (47.96%) Analytical Skills
2 84 (38.01%) Finance
3 57 (25.79%) Social Skills
4 26 (11.76%) Law
5 25 (11.31%) Marketing
6 18 (8.14%) Inclusion and Diversity
7 16 (7.24%) Public Sector
8 13 (5.88%) Retail
9 8 (3.62%) Manufacturing
10 6 (2.71%) Documentation Skills
10 6 (2.71%) Influencing Skills
10 6 (2.71%) Legal
10 6 (2.71%) Presentation Skills
11 4 (1.81%) Telecoms
12 3 (1.36%) Publishing
13 2 (0.90%) Games
13 2 (0.90%) Italian Language
14 1 (0.45%) Advertising
14 1 (0.45%) Banking
14 1 (0.45%) General Ledger
Job Titles
1 100 (45.25%) Developer
2 73 (33.03%) Analyst
3 63 (28.51%) Business Intelligence Developer
4 49 (22.17%) Power BI Developer
5 42 (19.00%) Data Analyst
6 26 (11.76%) Business Intelligence Analyst
7 25 (11.31%) Senior
8 20 (9.05%) Senior Developer
9 19 (8.60%) Coordinator
9 19 (8.60%) Data Coordinator
10 15 (6.79%) Consultant
11 13 (5.88%) Analyst Developer
11 13 (5.88%) Dynamics 365 Developer
11 13 (5.88%) Financial Analyst
12 11 (4.98%) Insight Analyst
12 11 (4.98%) Power BI Consultant
13 10 (4.52%) Commercial Analyst
13 10 (4.52%) Developer Analyst
13 10 (4.52%) Senior Business Intelligence Developer
14 9 (4.07%) Business Intelligence Data Analyst
Libraries, Frameworks & Software Standards
1 9 (4.07%) CSS
1 9 (4.07%) HTML
2 6 (2.71%) MDX
3 4 (1.81%) .NET
3 4 (1.81%) JSON
4 3 (1.36%) Pandas
5 1 (0.45%) .NET Framework
5 1 (0.45%) ADO
5 1 (0.45%) D3.js
5 1 (0.45%) Web Services
Miscellaneous
1 37 (16.74%) Self-Motivation
2 8 (3.62%) Management Information System
3 4 (1.81%) NHS
3 4 (1.81%) PMI
3 4 (1.81%) Social Media
4 2 (0.90%) Algorithms
5 1 (0.45%) Data Protection Act
5 1 (0.45%) Data Structures
5 1 (0.45%) Foreign Exchange (FX)
5 1 (0.45%) Greenfield Project
5 1 (0.45%) Legacy Systems
Operating Systems
1 1 (0.45%) Windows
Processes & Methodologies
1 155 (70.14%) Business Intelligence
2 79 (35.75%) Visualisation
3 77 (34.84%) CRM
4 74 (33.48%) Analytics
5 63 (28.51%) Data Visualisation
6 59 (26.70%) Problem-Solving
7 58 (26.24%) Data Modelling
8 45 (20.36%) Data Management
9 44 (19.91%) Continuous Improvement
10 33 (14.93%) ETL
11 32 (14.48%) Decision-Making
12 28 (12.67%) Agile
13 25 (11.31%) Machine Learning
13 25 (11.31%) Requirements Gathering
14 24 (10.86%) Data Analysis
15 18 (8.14%) DevOps
16 17 (7.69%) Dashboard Development
17 16 (7.24%) Actionable Insight
17 16 (7.24%) Data Analytics
18 15 (6.79%) Data Integration
Programming Languages
1 108 (48.87%) SQL
2 100 (45.25%) Data Analysis Expressions
3 30 (13.57%) Python
4 21 (9.50%) T-SQL
5 15 (6.79%) VBA
6 7 (3.17%) JavaScript
7 6 (2.71%) Formula Language
8 5 (2.26%) PowerShell
8 5 (2.26%) R
9 3 (1.36%) C#
Qualifications
1 36 (16.29%) Degree
2 14 (6.33%) Computer Science Degree
3 10 (4.52%) DBS Check
4 5 (2.26%) Microsoft Certification
5 4 (1.81%) BPSS Clearance
5 4 (1.81%) PMI Certification
6 3 (1.36%) Master's Degree
7 1 (0.45%) Numerate Degree
Quality Assurance & Compliance
1 15 (6.79%) QA
2 3 (1.36%) Data Quality
3 1 (0.45%) GDPR
3 1 (0.45%) PMO
Vendors
1 72 (32.58%) Microsoft
2 36 (16.29%) Salesforce
3 18 (8.14%) Databricks
4 9 (4.07%) Google
5 6 (2.71%) Civica
5 6 (2.71%) Facebook
6 4 (1.81%) GoldenSource
6 4 (1.81%) SAP
7 2 (0.90%) Alteryx
7 2 (0.90%) Snow
7 2 (0.90%) Splunk
8 1 (0.45%) Ariba
8 1 (0.45%) MicroStrategy
8 1 (0.45%) Oracle
8 1 (0.45%) Progress