Power Query Contracts with Work from Home Options

Microsoft Power Query
UK > Work from Home

The table below provides summary statistics for contract job vacancies with an option to work from home (WFH) and 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 16 May 2024 with a comparison to the same period in the previous 2 years.

6 months to
16 May 2024
Same period 2023 Same period 2022
Rank 319 435 546
Rank change year-on-year +116 +111 -107
Contract jobs citing Power Query 28 33 76
As % of all contract jobs with a WFH option 0.19% 0.13% 0.17%
As % of the Database & Business Intelligence category 0.97% 0.70% 0.80%
Number of daily rates quoted 22 25 59
10th Percentile £284 £318 £361
25th Percentile £325 £363 £400
Median daily rate (50th Percentile) £438 £463 £500
Median % change year-on-year -5.41% -7.50% +129.89%
75th Percentile £525 £525 £556
90th Percentile £571 £575 £575
UK median daily rate £425 £475 £488
% change year-on-year -10.53% -2.56% +63.87%

All Database and Business Intelligence Skills
Work from Home

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 WFH option and a requirement for database or business intelligence skills.

Contract vacancies with a requirement for database or business intelligence skills 2,875 4,698 9,504
As % of all contract jobs with a WFH option 19.43% 19.06% 21.63%
Number of daily rates quoted 2,118 3,428 6,908
10th Percentile £357 £385 £370
25th Percentile £425 £450 £440
Median daily rate (50th Percentile) £524 £525 £525
Median % change year-on-year -0.29% - +5.00%
75th Percentile £650 £650 £638
90th Percentile £750 £750 £731
UK median daily rate £525 £545 £545
% change year-on-year -3.67% - +9.00%
Number of hourly rates quoted 37 80 91
10th Percentile £20.06 £22.16 £20.00
25th Percentile £22.61 £43.75 £23.05
Median hourly rate £40.25 £66.00 £47.50
Median % change year-on-year -39.02% +38.95% +41.79%
75th Percentile £63.00 £75.00 £65.54
90th Percentile £72.50 £85.00 £75.00
UK median hourly rate £40.00 £60.00 £46.00
% change year-on-year -33.33% +30.43% +73.58%

Power Query
Trend for Jobs with a WFH Option

Job vacancies with a work from home option citing Power Query as a proportion of all IT jobs advertised.

Power Query trend for jobs with a WFH option

Power Query
Daily Rate Trend for Jobs with a WFH Option

3-month moving average daily rate quoted in job vacancies with a work from home option citing Power Query.

Power Query daily rate for jobs with a WFH option

Power Query
Daily Rate Histogram for Jobs with a WFH Option

Daily rate distribution for jobs with a work from home option citing Power Query over the 6 months to 16 May 2024.

Power Query daily rate histogram for jobs with a WFH option

Power Query
Co-occurring Skills and Capabilities with WFH Options 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 (10.71%) SharePoint
2 1 (3.57%) Apache Spark
Applications
1 6 (21.43%) Microsoft Excel
2 3 (10.71%) Microsoft PowerPoint
3 2 (7.14%) MS Visio
4 1 (3.57%) Microsoft Office
4 1 (3.57%) Spreadsheet
Business Applications
1 3 (10.71%) NetSuite
2 1 (3.57%) Dynamics CRM
Cloud Services
1 26 (92.86%) Power Platform
2 12 (42.86%) Azure
3 5 (17.86%) Azure Data Factory
3 5 (17.86%) Azure Synapse Analytics
3 5 (17.86%) Serverless
4 4 (14.29%) Azure DevOps
4 4 (14.29%) PowerApps
5 3 (10.71%) Azure Functions
5 3 (10.71%) Microsoft 365
5 3 (10.71%) Power Automate
6 2 (7.14%) GitHub
7 1 (3.57%) AWS
7 1 (3.57%) AWS Lambda
7 1 (3.57%) Azure Monitor
7 1 (3.57%) Azure Storage
7 1 (3.57%) Snowflake
Communications & Networking
1 2 (7.14%) HTTP
Database & Business Intelligence
1 26 (92.86%) Power BI
2 7 (25.00%) SQL Server
3 5 (17.86%) Azure SQL Database
3 5 (17.86%) Data Lake
4 4 (14.29%) PowerPivot
5 3 (10.71%) Enterprise Data Warehouse
5 3 (10.71%) Microsoft Analysis Services
5 3 (10.71%) Relational Database
5 3 (10.71%) SQL Server Analysis Services
6 2 (7.14%) Data Warehouse
6 2 (7.14%) NoSQL
7 1 (3.57%) Amazon RDS
7 1 (3.57%) Metadata
7 1 (3.57%) Parquet
7 1 (3.57%) PostgreSQL
7 1 (3.57%) Tableau
Development Applications
1 1 (3.57%) Deequ
General
1 16 (57.14%) Social Skills
2 11 (39.29%) Analytical Skills
3 5 (17.86%) Finance
3 5 (17.86%) Presentation Skills
4 1 (3.57%) Automotive
4 1 (3.57%) Electronics
4 1 (3.57%) Law
4 1 (3.57%) Marketing
4 1 (3.57%) Organisational Skills
4 1 (3.57%) Public Sector
4 1 (3.57%) Retail
4 1 (3.57%) Telecoms
Job Titles
1 14 (50.00%) Developer
2 11 (39.29%) Business Intelligence Developer
2 11 (39.29%) Power BI Developer
3 6 (21.43%) Analyst
4 5 (17.86%) Azure Data Engineer
4 5 (17.86%) Azure Engineer
4 5 (17.86%) Data Engineer
5 4 (14.29%) Consultant
6 3 (10.71%) Business Intelligence Analyst
6 3 (10.71%) Data Analyst
6 3 (10.71%) Excel Analyst
6 3 (10.71%) HR Analyst
6 3 (10.71%) Senior
7 2 (7.14%) Business Intelligence Data Analyst
7 2 (7.14%) HR Business Analyst
7 2 (7.14%) Power BI Consultant
7 2 (7.14%) Power Platform Consultant
7 2 (7.14%) Power Platform Developer
7 2 (7.14%) Process Mapping Analyst
7 2 (7.14%) Process Mapping Business Analyst
Libraries, Frameworks & Software Standards
1 2 (7.14%) PySpark
2 1 (3.57%) Apache Avro
2 1 (3.57%) ARM Templates
2 1 (3.57%) Great Expectations
2 1 (3.57%) JSON
2 1 (3.57%) JSON Schema
Miscellaneous
1 2 (7.14%) Foreign Exchange (FX)
2 1 (3.57%) Analytical Mindset
2 1 (3.57%) Data Structures
2 1 (3.57%) FMCG
Processes & Methodologies
1 24 (85.71%) Business Intelligence
2 13 (46.43%) Data Modelling
3 11 (39.29%) Problem-Solving
4 10 (35.71%) Visualisation
5 8 (28.57%) Data Visualisation
5 8 (28.57%) ETL
6 7 (25.00%) Agile
6 7 (25.00%) Analytics
6 7 (25.00%) Data Analysis
7 6 (21.43%) Scrum
8 5 (17.86%) Stakeholder Management
9 4 (14.29%) CI/CD
9 4 (14.29%) Data Transformation
9 4 (14.29%) DevOps
9 4 (14.29%) Translating Business Requirements
10 3 (10.71%) Data Engineering
10 3 (10.71%) TDD
10 3 (10.71%) Workshop Facilitation
11 2 (7.14%) Data Management
11 2 (7.14%) Data Pipeline
Programming Languages
1 21 (75.00%) Data Analysis Expressions
2 17 (60.71%) SQL
3 8 (28.57%) Python
4 1 (3.57%) R
4 1 (3.57%) Scala
4 1 (3.57%) VBA
Qualifications
1 3 (10.71%) Degree
2 1 (3.57%) Computer Science Degree
Quality Assurance & Compliance
1 3 (10.71%) Data Quality
Vendors
1 12 (42.86%) Microsoft
2 5 (17.86%) Databricks
3 3 (10.71%) Workday
4 2 (7.14%) ServiceNow