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

6 months to
1 Jun 2024
Same period 2023 Same period 2022
Rank 520 611 733
Rank change year-on-year +91 +122 -94
Contract jobs citing Power Query 55 71 105
As % of all contract jobs advertised in the UK 0.13% 0.13% 0.12%
As % of the Database & Business Intelligence category 0.75% 0.72% 0.61%
Number of daily rates quoted 42 48 83
10th Percentile £276 £325 £320
25th Percentile £342 £375 £379
Median daily rate (50th Percentile) £425 £488 £500
Median % change year-on-year -12.82% -2.50% +55.28%
75th Percentile £525 £575 £556
90th Percentile £563 £679 £575
UK excluding London median daily rate £393 £400 £413
% change year-on-year -1.88% -3.03% +91.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,300 9,902 17,265
As % of all contract IT jobs advertised in the UK 16.95% 17.66% 19.71%
Number of daily rates quoted 5,235 7,035 12,303
10th Percentile £350 £375 £375
25th Percentile £425 £450 £450
Median daily rate (50th Percentile) £525 £550 £550
Median % change year-on-year -4.46% -0.09% +10.00%
75th Percentile £650 £663 £650
90th Percentile £775 £754 £750
UK excluding London median daily rate £475 £500 £500
% change year-on-year -5.00% - +11.11%
Number of hourly rates quoted 150 179 180
10th Percentile £14.00 £21.24 £15.45
25th Percentile £20.77 £33.70 £21.69
Median hourly rate £40.00 £60.00 £45.00
Median % change year-on-year -33.33% +33.33% +69.81%
75th Percentile £56.88 £73.75 £63.60
90th Percentile £72.75 £80.50 £75.00
UK excluding London median hourly rate £35.00 £58.59 £35.00
% change year-on-year -40.26% +67.40% +42.86%

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 1 June 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 1 June 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 +61 40 £415 -14.87% 36
UK excluding London +37 30 £393 -1.88% 23
Work from Home +115 28 £420 -10.40% 14
London +74 16 £500 - 13
South East +11 11 £375 -32.40% 7
Wales - 6 £550 -
Midlands +25 5 £350 -3.45% 4
West Midlands +16 4 £350 -3.45% 1
North of England +22 3 £369 -20.27% 7
South West +5 3 £400 +10.34% 2
Yorkshire - 2 £375 - 2
Scotland +36 1 £275 -42.11% 1
North West +19 1 £363 -21.62% 4
East Midlands +12 1 - - 3
East of England -1 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 3 (5.45%) SharePoint
2 2 (3.64%) Apache Spark
2 2 (3.64%) Confluence
3 1 (1.82%) Apache
Applications
1 12 (21.82%) 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 22 (40.00%) Azure
3 11 (20.00%) Azure Data Factory
4 10 (18.18%) Power Automate
5 6 (10.91%) Azure Synapse Analytics
5 6 (10.91%) Microsoft 365
5 6 (10.91%) Snowflake
6 5 (9.09%) PowerApps
7 4 (7.27%) GitHub
7 4 (7.27%) Serverless
8 3 (5.45%) Azure DevOps
8 3 (5.45%) Azure Functions
9 2 (3.64%) AWS
9 2 (3.64%) Azure Cosmos DB
9 2 (3.64%) Azure Monitor
9 2 (3.64%) GCP
9 2 (3.64%) Google Data Studio
9 2 (3.64%) Google Sheets
9 2 (3.64%) Google Tag Manager
9 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%) SQL Server Integration Services
6 5 (9.09%) SQL Server Reporting Services
7 4 (7.27%) Data Warehouse
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 RDS
10 1 (1.82%) Amazon Redshift
10 1 (1.82%) Oracle Reports
10 1 (1.82%) PostgreSQL
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 27 (49.09%) 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%) Retail
8 1 (1.82%) Telecoms
Job Titles
1 27 (49.09%) Developer
2 23 (41.82%) Business Intelligence Developer
2 23 (41.82%) 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
6 5 (9.09%) Azure Data Engineer
6 5 (9.09%) Azure Engineer
6 5 (9.09%) Data Analyst
6 5 (9.09%) Senior
7 4 (7.27%) Consultant
8 3 (5.45%) Excel Analyst
8 3 (5.45%) HR Analyst
8 3 (5.45%) Lead Data Engineer
8 3 (5.45%) Performance Analyst
8 3 (5.45%) Power Platform Developer
8 3 (5.45%) Report Analyst
9 2 (3.64%) HR Business Analyst
9 2 (3.64%) Process Mapping Business 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 20 (36.36%) Data Visualisation
5 19 (34.55%) Problem-Solving
6 18 (32.73%) ETL
7 16 (29.09%) Analytics
8 14 (25.45%) Data Analysis
9 12 (21.82%) Agile
9 12 (21.82%) Decision-Making
10 9 (16.36%) Scrum
11 8 (14.55%) Stakeholder Management
12 7 (12.73%) Continuous Improvement
13 6 (10.91%) Actionable Insight
13 6 (10.91%) Data Collection
13 6 (10.91%) Translating Business Requirements
14 5 (9.09%) CI/CD
14 5 (9.09%) Dashboard Development
14 5 (9.09%) Data Management
14 5 (9.09%) User Experience
Programming Languages
1 34 (61.82%) SQL
2 33 (60.00%) Data Analysis Expressions
3 13 (23.64%) Python
4 6 (10.91%) 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 17 (30.91%) Microsoft
2 10 (18.18%) 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