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 8 May 2024 with a comparison to the same period in the previous 2 years.

6 months to
8 May 2024
Same period 2023 Same period 2022
Rank 678 818 1036
Rank change year-on-year +140 +218 -225
Permanent jobs citing Power Query 213 177 200
As % of all permanent jobs advertised in the UK 0.21% 0.17% 0.13%
As % of the Database & Business Intelligence category 1.17% 0.82% 0.45%
Number of salaries quoted 136 147 131
10th Percentile £36,750 £36,250 £35,000
25th Percentile £41,250 £41,250 £39,125
Median annual salary (50th Percentile) £47,500 £57,500 £50,000
Median % change year-on-year -17.39% +15.00% +17.65%
75th Percentile £57,500 £72,500 £65,000
90th Percentile £67,500 £78,000 £72,135
UK excluding London median annual salary £45,828 £42,500 £42,500
% change year-on-year +7.83% - +18.88%

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,197 21,669 43,969
As % of all permanent jobs advertised in the UK 18.35% 21.34% 27.93%
Number of salaries quoted 12,547 13,515 21,192
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 £76,250 £83,750 £79,000
90th Percentile £95,000 £102,500 £95,000
UK excluding London median annual salary £52,500 £55,000 £52,500
% change year-on-year -4.55% +4.76% +8.25%

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 8 May 2024.

Salary histogram for Power Query in the UK

Power Query
Top 17 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 8 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 +129 195 £47,500 -29.63% 40
UK excluding London +68 169 £45,828 +7.83% 21
Work from Home +57 69 £47,500 - 19
South East +69 68 £45,828 -1.13% 9
North of England +63 46 £47,500 +20.25% 7
London +78 32 £65,000 -7.14% 19
Midlands +16 30 £41,492 -12.65% 1
Yorkshire +92 23 £47,500 +18.75% 1
North West +17 22 £40,500 +3.85% 4
West Midlands +18 18 £38,500 -6.67% 1
East Midlands -7 12 £41,492 -12.65%
South West -16 12 £52,500 +56.72% 1
Scotland -58 8 £42,500 -
Wales -4 3 - -
East of England +7 1 £62,500 +47.06% 3
North East -3 1 £50,000 -4.76% 2
Isle of Man - 1 £36,000 - 1

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 17 (7.98%) SharePoint
2 4 (1.88%) Confluence
3 2 (0.94%) IBM Domino
3 2 (0.94%) SAS
4 1 (0.47%) Apache Spark
4 1 (0.47%) CMS
Applications
1 55 (25.82%) Microsoft Excel
2 8 (3.76%) Spreadsheet
3 5 (2.35%) Microsoft PowerPoint
4 4 (1.88%) Trello
5 3 (1.41%) Microsoft Office
Business Applications
1 32 (15.02%) Dynamics CRM
2 8 (3.76%) Dynamics NAV
3 7 (3.29%) Dynamics AX
Cloud Services
1 169 (79.34%) Power Platform
2 78 (36.62%) Azure
3 40 (18.78%) PowerApps
4 30 (14.08%) Dynamics 365
5 29 (13.62%) Power Automate
6 10 (4.69%) Azure Data Factory
6 10 (4.69%) Microsoft 365
7 7 (3.29%) Azure DevOps
7 7 (3.29%) Azure Synapse Analytics
7 7 (3.29%) GCP
7 7 (3.29%) Google Analytics
8 5 (2.35%) GitHub
9 4 (1.88%) Azure Cosmos DB
9 4 (1.88%) Google Data Studio
9 4 (1.88%) Google Sheets
9 4 (1.88%) Google Tag Manager
9 4 (1.88%) PaaS
10 3 (1.41%) AWS
11 2 (0.94%) Azure Logic Apps
11 2 (0.94%) Azure Sentinel
Communications & Networking
1 1 (0.47%) DNS
1 1 (0.47%) HTTP
Database & Business Intelligence
1 168 (78.87%) Power BI
2 36 (16.90%) Data Lake
2 36 (16.90%) SQL Server
3 30 (14.08%) SQL Server Integration Services
4 25 (11.74%) SQL Server Reporting Services
5 19 (8.92%) Tableau
6 17 (7.98%) Data Warehouse
7 13 (6.10%) SQL Server Analysis Services
8 12 (5.63%) PowerPivot
9 8 (3.76%) Azure SQL Database
9 8 (3.76%) Star Schema
10 7 (3.29%) QlikView
11 4 (1.88%) MySQL
11 4 (1.88%) Semantic Layer
12 3 (1.41%) BigQuery
12 3 (1.41%) Microsoft Analysis Services
13 2 (0.94%) Big Data
13 2 (0.94%) Relational Database
14 1 (0.47%) GIS
14 1 (0.47%) MS Access
Development Applications
1 19 (8.92%) SQL Server Management Studio (SSMS)
2 6 (2.82%) JIRA
3 4 (1.88%) Visual Studio
General
1 106 (49.77%) Analytical Skills
2 85 (39.91%) Finance
3 52 (24.41%) Social Skills
4 25 (11.74%) Law
5 21 (9.86%) Marketing
6 18 (8.45%) Inclusion and Diversity
6 18 (8.45%) Public Sector
7 13 (6.10%) Retail
8 9 (4.23%) Manufacturing
9 6 (2.82%) Documentation Skills
9 6 (2.82%) Legal
10 5 (2.35%) Presentation Skills
10 5 (2.35%) Telecoms
11 4 (1.88%) Influencing Skills
12 3 (1.41%) Publishing
13 2 (0.94%) Banking
13 2 (0.94%) Games
13 2 (0.94%) Italian Language
14 1 (0.47%) General Ledger
14 1 (0.47%) Social Housing
Job Titles
1 91 (42.72%) Developer
2 75 (35.21%) Analyst
3 62 (29.11%) Business Intelligence Developer
4 46 (21.60%) Power BI Developer
5 43 (20.19%) Data Analyst
6 24 (11.27%) Business Intelligence Analyst
6 24 (11.27%) Senior
7 19 (8.92%) Coordinator
7 19 (8.92%) Data Coordinator
8 18 (8.45%) Senior Developer
9 14 (6.57%) Consultant
10 13 (6.10%) Analyst Developer
10 13 (6.10%) Dynamics 365 Developer
10 13 (6.10%) Insight Analyst
11 11 (5.16%) Financial Analyst
11 11 (5.16%) Power BI Consultant
12 10 (4.69%) Data Insight Analyst
12 10 (4.69%) Developer Analyst
12 10 (4.69%) Insight Data Analyst
13 9 (4.23%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 6 (2.82%) CSS
1 6 (2.82%) HTML
1 6 (2.82%) MDX
2 4 (1.88%) JSON
2 4 (1.88%) Pandas
3 1 (0.47%) .NET
3 1 (0.47%) .NET Framework
3 1 (0.47%) ADO
3 1 (0.47%) D3.js
3 1 (0.47%) Web Services
Miscellaneous
1 41 (19.25%) Self-Motivation
2 8 (3.76%) Management Information System
3 4 (1.88%) PMI
3 4 (1.88%) Social Media
4 2 (0.94%) Algorithms
4 2 (0.94%) NHS
5 1 (0.47%) Data Protection Act
5 1 (0.47%) Data Structures
5 1 (0.47%) Foreign Exchange (FX)
5 1 (0.47%) Greenfield Project
5 1 (0.47%) Legacy Systems
5 1 (0.47%) Low-Code
5 1 (0.47%) Team-Oriented Environment
Operating Systems
1 1 (0.47%) Windows
Processes & Methodologies
1 152 (71.36%) Business Intelligence
2 77 (36.15%) CRM
3 73 (34.27%) Visualisation
4 70 (32.86%) Analytics
5 66 (30.99%) Problem-Solving
6 59 (27.70%) Data Visualisation
7 57 (26.76%) Data Modelling
8 49 (23.00%) Continuous Improvement
9 48 (22.54%) Data Management
10 33 (15.49%) Decision-Making
10 33 (15.49%) ETL
11 30 (14.08%) Agile
12 25 (11.74%) Data Analysis
12 25 (11.74%) Machine Learning
13 24 (11.27%) Requirements Gathering
14 19 (8.92%) Actionable Insight
15 18 (8.45%) Data Analytics
16 16 (7.51%) Data Integration
16 16 (7.51%) DevOps
17 14 (6.57%) Artificial Intelligence
Programming Languages
1 95 (44.60%) SQL
2 91 (42.72%) Data Analysis Expressions
3 31 (14.55%) Python
4 19 (8.92%) T-SQL
5 12 (5.63%) VBA
6 9 (4.23%) R
7 7 (3.29%) JavaScript
8 6 (2.82%) Formula Language
9 3 (1.41%) PowerShell
Qualifications
1 32 (15.02%) Degree
2 12 (5.63%) Computer Science Degree
3 10 (4.69%) DBS Check
4 5 (2.35%) Microsoft Certification
5 4 (1.88%) BPSS Clearance
5 4 (1.88%) PMI Certification
6 2 (0.94%) Master's Degree
7 1 (0.47%) Numerate Degree
7 1 (0.47%) SC Cleared
7 1 (0.47%) Security Cleared
Quality Assurance & Compliance
1 15 (7.04%) QA
2 4 (1.88%) Data Quality
3 2 (0.94%) GDPR
4 1 (0.47%) Actionable Recommendations
4 1 (0.47%) PMO
Vendors
1 71 (33.33%) Microsoft
2 39 (18.31%) Salesforce
3 15 (7.04%) Databricks
4 7 (3.29%) Google
5 6 (2.82%) Civica
5 6 (2.82%) Facebook
6 5 (2.35%) SAP
7 4 (1.88%) GoldenSource
8 3 (1.41%) Splunk
9 2 (0.94%) Alteryx
9 2 (0.94%) Snow
10 1 (0.47%) Ariba
10 1 (0.47%) MicroStrategy
10 1 (0.47%) Nintex
10 1 (0.47%) Oracle
10 1 (0.47%) Progress