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 4 December 2023 with a comparison to the same period in the previous 2 years.

6 months to
4 Dec 2023
Same period 2022 Same period 2021
Rank 614 859 940
Rank change year-on-year +245 +81 -216
Permanent jobs citing Power Query 127 217 159
As % of all permanent jobs advertised in the UK 0.24% 0.18% 0.12%
As % of the Database & Business Intelligence category 1.12% 0.76% 0.46%
Number of salaries quoted 84 167 118
10th Percentile £36,742 £34,575 £32,500
25th Percentile £41,250 £40,000 £37,500
Median annual salary (50th Percentile) £47,500 £52,500 £53,500
Median % change year-on-year -9.52% -1.87% -4.89%
75th Percentile £55,000 £65,000 £65,000
90th Percentile £67,500 £73,800 £71,250
UK excluding London median annual salary £47,500 £45,000 £42,500
% change year-on-year +5.56% +5.88% +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 11,310 28,707 34,865
As % of all permanent jobs advertised in the UK 21.25% 23.16% 27.19%
Number of salaries quoted 8,502 17,521 22,585
10th Percentile £37,000 £36,750 £35,704
25th Percentile £46,906 £46,250 £42,500
Median annual salary (50th Percentile) £60,000 £62,500 £58,500
Median % change year-on-year -4.00% +6.84% +6.36%
75th Percentile £80,000 £82,500 £77,500
90th Percentile £95,000 £100,000 £95,000
UK excluding London median annual salary £55,000 £55,000 £50,000
% change year-on-year - +10.00% +2.04%

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 4 December 2023.

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 4 December 2023. 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 +267 111 £48,000 -12.73% 42
UK excluding London +204 87 £47,500 +5.56% 25
Work from Home +222 60 £48,750 -2.50% 19
London +227 28 £56,250 -13.46% 19
North of England +161 28 £47,500 +20.25% 4
Yorkshire +112 23 £50,000 +81.82% 1
South East +157 18 £45,000 -25.00% 5
Midlands +99 14 £47,500 +4.40% 6
West Midlands +120 13 £47,500 +5.56% 3
South West +83 9 £42,500 -2.91% 2
Scotland +55 9 £39,132 -2.17% 5
East of England +120 5 £47,500 -17.39% 3
North West +97 3 £32,500 -19.75% 3
Wales +7 3 £33,500 -10.67%
North East +49 2 £47,500 +58.33%
Northern Ireland +36 1 £35,000 -
East Midlands +30 1 £41,000 -13.68% 3

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 6 (4.72%) SharePoint
2 5 (3.94%) Apache Spark
3 4 (3.15%) IBM Domino
Applications
1 41 (32.28%) Microsoft Excel
2 7 (5.51%) Microsoft Office
3 4 (3.15%) Microsoft PowerPoint
4 2 (1.57%) Microsoft Project
4 2 (1.57%) MS Visio
Business Applications
1 5 (3.94%) NetSuite
1 5 (3.94%) Shopify
2 4 (3.15%) Dynamics CRM
3 3 (2.36%) Dynamics NAV
4 2 (1.57%) Primavera
5 1 (0.79%) Dynamics AX
5 1 (0.79%) iTrent
Cloud Services
1 112 (88.19%) Power Platform
2 46 (36.22%) Azure
3 21 (16.54%) Azure DevOps
4 14 (11.02%) Power Automate
5 11 (8.66%) PowerApps
6 10 (7.87%) Dynamics 365
7 9 (7.09%) Microsoft 365
8 6 (4.72%) Azure Data Factory
9 5 (3.94%) AWS
9 5 (3.94%) GCP
9 5 (3.94%) Google Analytics
10 2 (1.57%) Azure Logic Apps
10 2 (1.57%) Azure Stack
10 2 (1.57%) Lucidchart
11 1 (0.79%) Azure Synapse Analytics
Database & Business Intelligence
1 109 (85.83%) Power BI
2 34 (26.77%) Data Warehouse
3 22 (17.32%) SQL Server Integration Services
4 21 (16.54%) Star Schema
5 17 (13.39%) Data Lake
6 14 (11.02%) SQL Server Reporting Services
7 11 (8.66%) SQL Server
8 8 (6.30%) Tableau
9 6 (4.72%) MS Access
10 5 (3.94%) BigQuery
10 5 (3.94%) BusinessObjects
10 5 (3.94%) Data Mining
10 5 (3.94%) QlikView
10 5 (3.94%) Relational Database
11 4 (3.15%) Microsoft Analysis Services
11 4 (3.15%) SQL Server Analysis Services
12 2 (1.57%) Azure SQL Database
12 2 (1.57%) Metadata
12 2 (1.57%) PowerPivot
13 1 (0.79%) Azure SQL Data Warehouse
General
1 59 (46.46%) Analytical Skills
2 37 (29.13%) Finance
3 28 (22.05%) Manufacturing
4 24 (18.90%) Social Skills
5 23 (18.11%) Marketing
6 22 (17.32%) Electronics
7 12 (9.45%) Law
8 10 (7.87%) Inclusion and Diversity
9 8 (6.30%) Banking
9 8 (6.30%) Public Sector
10 7 (5.51%) Presentation Skills
11 5 (3.94%) Legal
12 4 (3.15%) Organisational Skills
13 3 (2.36%) Retail
14 2 (1.57%) Aviation
14 2 (1.57%) Pharmaceutical
15 1 (0.79%) Social Housing
15 1 (0.79%) Telecoms
Job Titles
1 44 (34.65%) Developer
2 43 (33.86%) Analyst
3 38 (29.92%) Business Intelligence Developer
4 36 (28.35%) Power BI Developer
5 17 (13.39%) Business Intelligence Analyst
6 13 (10.24%) Senior
7 11 (8.66%) Data Analyst
8 10 (7.87%) Business Developer
8 10 (7.87%) Power BI Analyst
9 9 (7.09%) Consultant
9 9 (7.09%) Data Engineer
9 9 (7.09%) Insight Analyst
10 8 (6.30%) Dynamics 365 Developer
11 7 (5.51%) Support Engineer
12 6 (4.72%) Business Intelligence Consultant
12 6 (4.72%) Data Consultant
12 6 (4.72%) Power BI Consultant
12 6 (4.72%) Senior Analyst
12 6 (4.72%) Senior Business Intelligence Consultant
12 6 (4.72%) Senior Consultant
Libraries, Frameworks & Software Standards
1 6 (4.72%) Pandas
2 5 (3.94%) Middleware
3 1 (0.79%) D3.js
3 1 (0.79%) PySpark
3 1 (0.79%) REST
3 1 (0.79%) Web Services
Miscellaneous
1 8 (6.30%) Management Information System
2 7 (5.51%) Self-Motivation
3 5 (3.94%) Data Structures
4 4 (3.15%) Onboarding
5 2 (1.57%) Analytical Mindset
5 2 (1.57%) Greenfield Project
5 2 (1.57%) Legacy Systems
5 2 (1.57%) PMI
5 2 (1.57%) Replication
6 1 (0.79%) Data Centre
6 1 (0.79%) FMCG
6 1 (0.79%) Life Science
6 1 (0.79%) Low-Code
6 1 (0.79%) Renewable Energy
6 1 (0.79%) Team-Oriented Environment
Operating Systems
1 1 (0.79%) Windows
1 1 (0.79%) Windows 10
Processes & Methodologies
1 105 (82.68%) Business Intelligence
2 55 (43.31%) Analytics
2 55 (43.31%) Visualisation
3 49 (38.58%) Data Modelling
4 32 (25.20%) ETL
5 26 (20.47%) Data Visualisation
6 23 (18.11%) Business Analytics
7 22 (17.32%) DevOps
8 19 (14.96%) Problem-Solving
9 18 (14.17%) Decision-Making
10 17 (13.39%) Agile
10 17 (13.39%) Continuous Improvement
10 17 (13.39%) Data Analysis
10 17 (13.39%) Data Management
11 15 (11.81%) Data Analytics
12 11 (8.66%) Data Integration
12 11 (8.66%) Economics
12 11 (8.66%) Performance Tuning
13 10 (7.87%) Artificial Intelligence
13 10 (7.87%) Storytelling
Programming Languages
1 87 (68.50%) SQL
2 60 (47.24%) Data Analysis Expressions
3 29 (22.83%) Python
4 17 (13.39%) T-SQL
5 14 (11.02%) R
6 10 (7.87%) VBA
7 3 (2.36%) JavaScript
7 3 (2.36%) PowerShell
8 2 (1.57%) PHP
8 2 (1.57%) PL/SQL
9 1 (0.79%) C#
9 1 (0.79%) C++
Qualifications
1 43 (33.86%) Degree
2 3 (2.36%) Computer Science Degree
2 3 (2.36%) Microsoft Certification
3 2 (1.57%) PMI Certification
4 1 (0.79%) SC Cleared
4 1 (0.79%) Security Cleared
Quality Assurance & Compliance
1 6 (4.72%) Data Quality
2 3 (2.36%) GDPR
2 3 (2.36%) PMO
2 3 (2.36%) QA
3 2 (1.57%) GAAP
4 1 (0.79%) Actionable Recommendations
4 1 (0.79%) P3O
System Software
1 1 (0.79%) Active Directory
Vendors
1 52 (40.94%) Microsoft
2 5 (3.94%) Google
2 5 (3.94%) Salesforce
2 5 (3.94%) Splunk
2 5 (3.94%) Xero
3 4 (3.15%) Databricks
3 4 (3.15%) SAP
4 3 (2.36%) Nintex
5 2 (1.57%) Avaya
5 2 (1.57%) BMC
5 2 (1.57%) Oracle
6 1 (0.79%) Apple
6 1 (0.79%) IFS
6 1 (0.79%) Yardi