Power Query Contracts

Microsoft Power Query
UK

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

6 months to
20 May 2024
Same period 2023 Same period 2022
Rank 524 614 751
Rank change year-on-year +90 +137 -133
Contract jobs citing Power Query 55 80 112
As % of all contract jobs advertised in the UK 0.13% 0.14% 0.13%
As % of the Database & Business Intelligence category 0.75% 0.78% 0.64%
Number of daily rates quoted 41 53 88
10th Percentile £275 £325 £323
25th Percentile £338 £363 £383
Median daily rate (50th Percentile) £425 £475 £488
Median % change year-on-year -10.53% -2.56% +60.49%
75th Percentile £525 £575 £541
90th Percentile £563 £665 £575
UK excluding London median daily rate £385 £431 £405
% change year-on-year -10.72% +6.48% +92.86%
Number of hourly rates quoted 0 3 0
Median hourly rate - £79.19 -
UK excluding London median hourly rate - £79.19 -

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 contract job vacancies with a requirement for database or business intelligence skills.

Contract vacancies with a requirement for database or business intelligence skills 7,287 10,222 17,599
As % of all contract IT jobs advertised in the UK 17.13% 17.85% 19.93%
Number of daily rates quoted 5,225 7,278 12,532
10th Percentile £350 £375 £375
25th Percentile £425 £450 £450
Median daily rate (50th Percentile) £525 £545 £549
Median % change year-on-year -3.67% -0.73% +9.80%
75th Percentile £650 £663 £650
90th Percentile £775 £750 £750
UK excluding London median daily rate £475 £500 £495
% change year-on-year -5.00% +1.01% +10.00%
Number of hourly rates quoted 148 175 184
10th Percentile £14.00 £21.24 £15.00
25th Percentile £20.93 £32.30 £22.40
Median hourly rate £40.00 £57.50 £45.00
Median % change year-on-year -30.43% +27.78% +69.81%
75th Percentile £61.53 £73.73 £65.00
90th Percentile £73.25 £79.38 £75.00
UK excluding London median hourly rate £39.25 £55.00 £35.00
% change year-on-year -28.64% +57.14% +45.83%

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
Contractor Daily Rate Trend

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

Daily rate trend for Power Query in the UK

Power Query
Daily Rate Histogram

Daily rate distribution for jobs citing Power Query over the 6 months to 20 May 2024.

Daily rate histogram for Power Query in the UK

Power Query
Contractor Hourly Rate Trend

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

Hourly rate trend for Power Query in the UK

Power Query
Top 15 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Power Query within the UK over the 6 months to 20 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Jobs
England +80 39 £420 -11.58% 60
UK excluding London +47 29 £385 -10.72% 34
Work from Home +110 28 £425 -8.11% 29
London +76 16 £500 - 30
South East +20 11 £375 -31.82% 11
Wales - 6 £550 -
Midlands +19 4 £300 -17.24% 6
North of England +29 3 £369 -20.27% 9
West Midlands +22 3 £300 -17.24% 3
South West +8 3 £400 +10.34% 3
Yorkshire - 2 £375 - 4
Scotland +40 1 £275 -42.11% 1
East Midlands +17 1 - - 3
North West +14 1 £363 -21.62% 4
East of England +3 1 £375 +7.14% 4

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 4 (7.27%) SharePoint
2 2 (3.64%) Apache Spark
2 2 (3.64%) Confluence
3 1 (1.82%) Apache
Applications
1 13 (23.64%) Microsoft Excel
2 3 (5.45%) Microsoft PowerPoint
2 3 (5.45%) SPSS
3 2 (3.64%) MS Visio
3 2 (3.64%) Trello
4 1 (1.82%) Microsoft Office
4 1 (1.82%) Spreadsheet
Business Applications
1 3 (5.45%) Dynamics CRM
1 3 (5.45%) NetSuite
Cloud Services
1 50 (90.91%) Power Platform
2 23 (41.82%) Azure
3 12 (21.82%) Azure Data Factory
4 10 (18.18%) Power Automate
5 7 (12.73%) Azure Synapse Analytics
6 6 (10.91%) Microsoft 365
6 6 (10.91%) Snowflake
7 5 (9.09%) PowerApps
8 4 (7.27%) GitHub
8 4 (7.27%) Serverless
9 3 (5.45%) Azure DevOps
9 3 (5.45%) Azure Functions
10 2 (3.64%) AWS
10 2 (3.64%) Azure Cosmos DB
10 2 (3.64%) Azure Monitor
10 2 (3.64%) GCP
10 2 (3.64%) Google Data Studio
10 2 (3.64%) Google Sheets
10 2 (3.64%) Google Tag Manager
10 2 (3.64%) PaaS
Communications & Networking
1 2 (3.64%) HTTP
Database & Business Intelligence
1 50 (90.91%) Power BI
2 10 (18.18%) SQL Server
3 8 (14.55%) Azure SQL Database
4 7 (12.73%) PowerPivot
5 6 (10.91%) Data Lake
5 6 (10.91%) Data Warehouse
5 6 (10.91%) SQL Server Integration Services
6 5 (9.09%) SQL Server Reporting Services
7 4 (7.27%) NoSQL
7 4 (7.27%) Relational Database
8 3 (5.45%) BusinessObjects XI
8 3 (5.45%) Enterprise Data Warehouse
8 3 (5.45%) Microsoft Analysis Services
8 3 (5.45%) SQL Server Analysis Services
9 2 (3.64%) Data Mining
9 2 (3.64%) Parquet
10 1 (1.82%) Amazon Redshift
10 1 (1.82%) Oracle Reports
10 1 (1.82%) PostgreSQL
10 1 (1.82%) Tableau
Development Applications
1 2 (3.64%) Deequ
1 2 (3.64%) JIRA
1 2 (3.64%) Visual Studio
2 1 (1.82%) SQL Server Management Studio (SSMS)
General
1 26 (47.27%) Social Skills
2 20 (36.36%) Analytical Skills
3 10 (18.18%) Finance
4 7 (12.73%) Public Sector
5 5 (9.09%) Presentation Skills
6 3 (5.45%) Local Government
6 3 (5.45%) Marketing
7 2 (3.64%) Automotive
8 1 (1.82%) Electronics
8 1 (1.82%) Law
8 1 (1.82%) Organisational Skills
8 1 (1.82%) Publishing
8 1 (1.82%) Retail
8 1 (1.82%) Telecoms
Job Titles
1 25 (45.45%) Developer
2 21 (38.18%) Business Intelligence Developer
2 21 (38.18%) Power BI Developer
3 15 (27.27%) Analyst
4 7 (12.73%) Lead
5 6 (10.91%) Business Intelligence Analyst
5 6 (10.91%) Data Engineer
5 6 (10.91%) Senior
6 5 (9.09%) Azure Data Engineer
6 5 (9.09%) Azure Engineer
6 5 (9.09%) Consultant
6 5 (9.09%) Data Analyst
7 3 (5.45%) Excel Analyst
7 3 (5.45%) HR Analyst
7 3 (5.45%) Lead Data Engineer
7 3 (5.45%) Performance Analyst
7 3 (5.45%) Power BI Consultant
7 3 (5.45%) Power Platform Developer
7 3 (5.45%) Report Analyst
8 2 (3.64%) Senior Analyst
Libraries, Frameworks & Software Standards
1 4 (7.27%) JSON
2 2 (3.64%) Apache Avro
2 2 (3.64%) ARM Templates
2 2 (3.64%) Great Expectations
2 2 (3.64%) JSON Schema
2 2 (3.64%) Oracle Fusion
2 2 (3.64%) PySpark
Miscellaneous
1 3 (5.45%) Linked Data
2 2 (3.64%) Foreign Exchange (FX)
2 2 (3.64%) Management Information System
2 2 (3.64%) Product Ownership
2 2 (3.64%) Self-Motivation
2 2 (3.64%) Social Media
2 2 (3.64%) Team-Oriented Environment
3 1 (1.82%) Analytical Mindset
3 1 (1.82%) Data Structures
3 1 (1.82%) FMCG
Processes & Methodologies
1 46 (83.64%) Business Intelligence
2 26 (47.27%) Data Modelling
3 25 (45.45%) Visualisation
4 19 (34.55%) Data Visualisation
4 19 (34.55%) Problem-Solving
5 17 (30.91%) ETL
6 15 (27.27%) Analytics
6 15 (27.27%) Data Analysis
7 12 (21.82%) Agile
7 12 (21.82%) Decision-Making
8 9 (16.36%) Scrum
9 8 (14.55%) Stakeholder Management
10 7 (12.73%) Continuous Improvement
11 6 (10.91%) Actionable Insight
11 6 (10.91%) CI/CD
11 6 (10.91%) Data Collection
11 6 (10.91%) Translating Business Requirements
12 5 (9.09%) Dashboard Development
12 5 (9.09%) Data Management
12 5 (9.09%) User Experience
Programming Languages
1 36 (65.45%) SQL
2 33 (60.00%) Data Analysis Expressions
3 13 (23.64%) Python
4 7 (12.73%) T-SQL
5 2 (3.64%) VBA
6 1 (1.82%) R
6 1 (1.82%) Scala
Qualifications
1 3 (5.45%) Degree
2 2 (3.64%) BPSS Clearance
3 1 (1.82%) Computer Science Degree
Quality Assurance & Compliance
1 11 (20.00%) Data Quality
2 2 (3.64%) Actionable Recommendations
3 1 (1.82%) QA
Vendors
1 16 (29.09%) Microsoft
2 11 (20.00%) Databricks
3 3 (5.45%) Oracle
3 3 (5.45%) Workday
4 2 (3.64%) Google
4 2 (3.64%) ServiceNow
5 1 (1.82%) IFS