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

6 months to
26 Apr 2024
Same period 2023 Same period 2022
Rank 519 603 749
Rank change year-on-year +84 +146 -163
Contract jobs citing Power Query 60 97 111
As % of all contract jobs advertised in the UK 0.14% 0.16% 0.13%
As % of the Database & Business Intelligence category 0.82% 0.90% 0.62%
Number of daily rates quoted 43 66 84
10th Percentile £281 £325 £304
25th Percentile £359 £375 £364
Median daily rate (50th Percentile) £443 £488 £450
Median % change year-on-year -9.13% +8.33% +57.21%
75th Percentile £525 £572 £528
90th Percentile £563 £606 £575
UK excluding London median daily rate £413 £450 £375
% change year-on-year -8.33% +20.00% +85.19%
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,306 10,806 17,919
As % of all contract IT jobs advertised in the UK 16.77% 18.02% 20.20%
Number of daily rates quoted 5,191 7,697 12,774
10th Percentile £350 £375 £375
25th Percentile £425 £450 £450
Median daily rate (50th Percentile) £525 £540 £542
Median % change year-on-year -2.78% -0.41% +8.45%
75th Percentile £650 £660 £650
90th Percentile £763 £750 £750
UK excluding London median daily rate £483 £500 £488
% change year-on-year -3.50% +2.56% +10.80%
Number of hourly rates quoted 146 184 186
10th Percentile £14.00 £21.24 £15.00
25th Percentile £20.98 £35.00 £22.40
Median hourly rate £40.00 £60.00 £42.50
Median % change year-on-year -33.33% +41.18% +57.64%
75th Percentile £57.61 £71.75 £60.00
90th Percentile £72.50 £79.19 £69.05
UK excluding London median hourly rate £40.00 £57.50 £35.00
% change year-on-year -30.43% +64.29% +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 26 April 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 26 April 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 +67 41 £425 -15.00% 35
Work from Home +117 34 £450 -5.26% 16
UK excluding London +57 29 £413 -8.33% 18
London +80 18 £500 - 18
South East +23 10 £349 -36.59% 4
Wales - 6 £550 - 1
Midlands +28 5 £363 -14.71% 2
West Midlands +31 4 £363 -14.71% 2
North of England +25 3 £369 -19.18% 8
Scotland +32 2 £400 -
Yorkshire +21 2 £375 -16.67%
South West +18 2 £475 +22.58% 1
East Midlands +22 1 - -
North West +18 1 £363 -21.62% 6
East of England +5 1 £375 +7.14% 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 (10.00%) SharePoint
2 2 (3.33%) Apache Spark
3 1 (1.67%) Apache
3 1 (1.67%) Confluence
3 1 (1.67%) Microsoft Exchange
3 1 (1.67%) SAS
Applications
1 12 (20.00%) Microsoft Excel
2 3 (5.00%) Microsoft PowerPoint
2 3 (5.00%) SPSS
3 2 (3.33%) MS Visio
4 1 (1.67%) Microsoft Office
4 1 (1.67%) Spreadsheet
4 1 (1.67%) Trello
Business Applications
1 3 (5.00%) Dynamics CRM
1 3 (5.00%) NetSuite
Cloud Services
1 55 (91.67%) Power Platform
2 27 (45.00%) Azure
3 16 (26.67%) Azure Data Factory
4 11 (18.33%) Power Automate
5 9 (15.00%) Azure Synapse Analytics
5 9 (15.00%) PowerApps
6 8 (13.33%) Microsoft 365
7 6 (10.00%) Serverless
8 5 (8.33%) Azure DevOps
8 5 (8.33%) Snowflake
9 4 (6.67%) Azure Functions
10 3 (5.00%) Dynamics 365
10 3 (5.00%) GitHub
11 2 (3.33%) AWS
11 2 (3.33%) Azure Monitor
12 1 (1.67%) Azure Cosmos DB
12 1 (1.67%) Azure Storage
12 1 (1.67%) Google Data Studio
12 1 (1.67%) Google Sheets
12 1 (1.67%) OCI
Communications & Networking
1 2 (3.33%) HTTP
2 1 (1.67%) DNS
Database & Business Intelligence
1 53 (88.33%) Power BI
2 13 (21.67%) SQL Server
3 9 (15.00%) Azure SQL Database
3 9 (15.00%) Data Lake
4 8 (13.33%) SQL Server Integration Services
5 7 (11.67%) Data Warehouse
5 7 (11.67%) PowerPivot
5 7 (11.67%) SQL Server Reporting Services
6 4 (6.67%) Enterprise Data Warehouse
6 4 (6.67%) Microsoft Analysis Services
6 4 (6.67%) NoSQL
6 4 (6.67%) Relational Database
6 4 (6.67%) SQL Server Analysis Services
7 3 (5.00%) BusinessObjects XI
8 2 (3.33%) Data Mining
8 2 (3.33%) Parquet
8 2 (3.33%) Tableau
9 1 (1.67%) Amazon RDS
9 1 (1.67%) Amazon Redshift
9 1 (1.67%) Big Data
Development Applications
1 2 (3.33%) Deequ
2 1 (1.67%) JIRA
2 1 (1.67%) SQL Server Management Studio (SSMS)
2 1 (1.67%) Visual Studio
General
1 24 (40.00%) Social Skills
2 21 (35.00%) Analytical Skills
3 11 (18.33%) Finance
4 7 (11.67%) Public Sector
5 5 (8.33%) Presentation Skills
6 3 (5.00%) Local Government
6 3 (5.00%) Marketing
7 2 (3.33%) Electronics
7 2 (3.33%) Telecoms
8 1 (1.67%) Automotive
8 1 (1.67%) Law
8 1 (1.67%) Manufacturing
8 1 (1.67%) Organisational Skills
8 1 (1.67%) Publishing
8 1 (1.67%) Retail
Job Titles
1 27 (45.00%) Developer
2 20 (33.33%) Power BI Developer
3 19 (31.67%) Business Intelligence Developer
4 14 (23.33%) Analyst
5 8 (13.33%) Azure Engineer
5 8 (13.33%) Data Engineer
6 7 (11.67%) Azure Data Engineer
6 7 (11.67%) Lead
7 6 (10.00%) Business Intelligence Analyst
7 6 (10.00%) Consultant
7 6 (10.00%) Senior
8 5 (8.33%) Data Analyst
9 4 (6.67%) Power BI Consultant
9 4 (6.67%) Power Platform Developer
10 3 (5.00%) Business Intelligence Consultant
10 3 (5.00%) Excel Analyst
10 3 (5.00%) HR Analyst
10 3 (5.00%) Lead Data Engineer
10 3 (5.00%) Report Analyst
11 2 (3.33%) Business Analyst
Libraries, Frameworks & Software Standards
1 4 (6.67%) JSON
2 3 (5.00%) PySpark
3 2 (3.33%) Apache Avro
3 2 (3.33%) ARM Templates
3 2 (3.33%) Great Expectations
3 2 (3.33%) JSON Schema
3 2 (3.33%) Oracle Fusion
4 1 (1.67%) HTML5 Canvas
Miscellaneous
1 3 (5.00%) Linked Data
2 2 (3.33%) Foreign Exchange (FX)
2 2 (3.33%) Management Information System
2 2 (3.33%) Self-Motivation
2 2 (3.33%) Team-Oriented Environment
3 1 (1.67%) Analytical Mindset
3 1 (1.67%) BYOD
3 1 (1.67%) Data Structures
3 1 (1.67%) FMCG
3 1 (1.67%) Product Ownership
3 1 (1.67%) Social Media
Processes & Methodologies
1 49 (81.67%) Business Intelligence
2 28 (46.67%) Data Modelling
3 23 (38.33%) Visualisation
4 20 (33.33%) Problem-Solving
5 18 (30.00%) ETL
6 17 (28.33%) Analytics
6 17 (28.33%) Data Visualisation
7 15 (25.00%) Data Analysis
8 13 (21.67%) Agile
9 11 (18.33%) Decision-Making
10 10 (16.67%) Scrum
11 7 (11.67%) CI/CD
11 7 (11.67%) Continuous Improvement
11 7 (11.67%) Data Integration
11 7 (11.67%) Stakeholder Management
12 6 (10.00%) Actionable Insight
12 6 (10.00%) DevOps
12 6 (10.00%) Translating Business Requirements
13 5 (8.33%) Data Transformation
13 5 (8.33%) User Experience
Programming Languages
1 41 (68.33%) SQL
2 34 (56.67%) Data Analysis Expressions
3 16 (26.67%) Python
4 8 (13.33%) T-SQL
5 2 (3.33%) R
5 2 (3.33%) VBA
6 1 (1.67%) Scala
Qualifications
1 3 (5.00%) Degree
2 1 (1.67%) BPSS Clearance
2 1 (1.67%) Computer Science Degree
2 1 (1.67%) SC Cleared
2 1 (1.67%) Security Cleared
Quality Assurance & Compliance
1 13 (21.67%) Data Quality
2 2 (3.33%) Actionable Recommendations
3 1 (1.67%) QA
Vendors
1 18 (30.00%) Microsoft
2 13 (21.67%) Databricks
3 4 (6.67%) Oracle
4 3 (5.00%) Workday
5 2 (3.33%) ServiceNow
6 1 (1.67%) Google
6 1 (1.67%) IFS
6 1 (1.67%) SAP