Period
to 3 August 2021

The following table provides summary statistics for permanent job vacancies with a requirement for Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Warehouse over the 6 months to 3 August 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK
6 months to
3 Aug 2021
Same period 2020 Same period 2019
Rank 110 113 108
Rank change year-on-year +3 -5 +8
Permanent jobs citing Data Warehouse 3,402 1,929 4,477
As % of all permanent jobs advertised in the UK 3.00% 2.86% 3.11%
As % of the Database & Business Intelligence category 10.71% 10.37% 11.17%
Number of salaries quoted 2,744 1,570 3,744
10th Percentile £37,000 £36,250 £37,250
25th Percentile £45,000 £45,000 £43,721
Median annual salary (50th Percentile) £60,000 £60,000 £55,000
Median % change year-on-year - +9.09% +4.76%
75th Percentile £78,750 £75,000 £71,250
90th Percentile £90,000 £90,125 £83,750
UK excluding London median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% -

Data Warehouse 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.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 31,767 18,608 40,073
As % of all permanent IT jobs advertised in the UK 28.02% 27.64% 27.80%
Number of salaries quoted 21,229 15,251 33,181
10th Percentile £35,000 £32,500 £31,250
25th Percentile £42,500 £41,250 £37,500
Median annual salary (50th Percentile) £55,000 £55,000 £52,000
Median % change year-on-year - +5.77% +4.00%
75th Percentile £75,250 £72,500 £70,000
90th Percentile £92,500 £88,750 £85,000
UK excluding London median annual salary £49,000 £47,500 £45,000
% change year-on-year +3.16% +5.56% -

Data Warehouse
Job Vacancy Trend

Job postings citing Data Warehouse as a proportion of all IT jobs advertised.

Job vacancy trend for Data Warehouse in the UK

Data Warehouse
Salary Trend

3-month moving average salary quoted in jobs citing Data Warehouse.

Salary trend for Data Warehouse in the UK

Data Warehouse
Salary Histogram

Salary distribution for jobs citing Data Warehouse over the 6 months to 3 August 2021.

Salary histogram for Data Warehouse in the UK

Data Warehouse
Top 17 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the UK over the 6 months to 3 August 2021. 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
Job
Vacancies
England +2 3,083 £60,000 - 539
UK excluding London +7 1,638 £50,000 - 301
London -9 1,543 £70,000 - 251
Work from Home +15 620 £57,500 +15.00% 81
North of England +41 556 £48,500 -3.00% 75
Midlands -19 306 £47,500 -4.04% 72
South East -34 271 £50,000 -9.09% 71
Yorkshire +57 267 £48,000 -10.70% 20
North West +12 261 £50,000 - 48
West Midlands -1 234 £47,500 -5.00% 51
South West +19 204 £47,500 +5.56% 31
East of England -1 144 £60,000 +13.59% 35
Scotland -4 125 £50,000 +2.04% 17
East Midlands -39 72 £41,125 -4.70% 21
Wales -32 32 £45,000 -
North East -11 28 £41,000 -2.38% 7
Northern Ireland -32 5 £35,000 -

For the 6 months to 3 August 2021, IT jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for Data Warehouse.

1 2,244 (65.96%) SQL
2 2,185 (64.23%) Business Intelligence
3 1,515 (44.53%) ETL
4 1,366 (40.15%) Azure
5 1,339 (39.36%) Analytics
6 1,293 (38.01%) Power Platform
7 1,273 (37.42%) Power BI
8 1,041 (30.60%) SQL Server
9 1,024 (30.10%) Data Modelling
10 980 (28.81%) Python
11 919 (27.01%) SQL Server Integration Services
12 857 (25.19%) AWS
13 841 (24.72%) Microsoft
14 821 (24.13%) Agile Software Development
15 747 (21.96%) Finance
16 735 (21.60%) Social Skills
17 728 (21.40%) SQL Server Reporting Services
18 659 (19.37%) Data Lake
19 650 (19.11%) Visualisation
20 559 (16.43%) SQL Server Analysis Services
21 526 (15.46%) Analytical Skills
22 519 (15.26%) Big Data
23 495 (14.55%) T-SQL
24 491 (14.43%) Tableau
25 480 (14.11%) Data Architecture
25 480 (14.11%) Data Engineering
26 475 (13.96%) DevOps
27 460 (13.52%) Data Pipeline
28 454 (13.35%) Azure Data Factory
29 412 (12.11%) Data Science

Data Warehouse
Co-occurring IT Skills by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 283 (8.32%) Apache Spark
2 176 (5.17%) Apache Airflow
3 107 (3.15%) Apache
4 56 (1.65%) Confluence
5 52 (1.53%) SharePoint
6 43 (1.26%) SAS
7 33 (0.97%) Elasticsearch
8 19 (0.56%) Oracle Application Server
8 19 (0.56%) Oracle Workflow
9 17 (0.50%) Gunicorn
10 16 (0.47%) Luigi
11 11 (0.32%) Apache Synapse
12 10 (0.29%) IIS
13 9 (0.26%) CMS
14 8 (0.24%) Apache Pig
15 5 (0.15%) NServiceBus
15 5 (0.15%) WebLogic
16 4 (0.12%) Sitecore CMS
17 2 (0.059%) Oracle SOA Suite
17 2 (0.059%) WordPress
Applications
1 237 (6.97%) Microsoft Excel
2 49 (1.44%) Microsoft Office
3 26 (0.76%) MS Visio
4 15 (0.44%) Microsoft PowerPoint
4 15 (0.44%) Spreadsheet
5 14 (0.41%) Microsoft Project
6 2 (0.059%) Oracle Smart View
7 1 (0.029%) Chatbot
7 1 (0.029%) SPSS
Business Applications
1 49 (1.44%) Dynamics CRM
2 35 (1.03%) NetSuite
3 27 (0.79%) Dynamics AX
4 14 (0.41%) Shopify
5 13 (0.38%) Oracle EBS
6 11 (0.32%) Dynamics NAV
7 10 (0.29%) Sage 50
8 7 (0.21%) HFM
8 7 (0.21%) Magento
9 6 (0.18%) Sentinel
10 5 (0.15%) Academy Revenues and Benefits
11 4 (0.12%) Adobe Campaign
11 4 (0.12%) JDE OneWorld
11 4 (0.12%) OPENHousing
11 4 (0.12%) SAP S/4HANA
12 3 (0.088%) Hyperion Planning
12 3 (0.088%) Oracle Financials
12 3 (0.088%) Oracle Subledger Accounting
12 3 (0.088%) SAP ERP
13 2 (0.059%) SAP Oil and Gas
Cloud Services
1 1,366 (40.15%) Azure
2 1,293 (38.01%) Power Platform
3 857 (25.19%) AWS
4 454 (13.35%) Azure Data Factory
5 339 (9.96%) GCP
6 316 (9.29%) Snowflake
7 204 (6.00%) Azure Synapse Analytics
8 131 (3.85%) Serverless
9 122 (3.59%) SaaS
10 100 (2.94%) PaaS
11 96 (2.82%) Amazon S3
12 85 (2.50%) Dynamics 365
13 68 (2.00%) PowerApps
14 66 (1.94%) AWS Lambda
15 64 (1.88%) GitHub
16 61 (1.79%) Azure Stack
17 55 (1.62%) Google Analytics
18 52 (1.53%) dbt
18 52 (1.53%) IaaS
18 52 (1.53%) Microsoft 365
Communications & Networking
1 19 (0.56%) SSH
2 18 (0.53%) Internet
3 16 (0.47%) FTP
4 12 (0.35%) Network Security
5 10 (0.29%) VPN
6 9 (0.26%) DNS
6 9 (0.26%) HTTPS
7 8 (0.24%) Intranet
8 7 (0.21%) Extranet
8 7 (0.21%) Firewall
8 7 (0.21%) HTTP
9 6 (0.18%) DHCP
9 6 (0.18%) IPv4
9 6 (0.18%) IPv6
9 6 (0.18%) SMTP
9 6 (0.18%) SNMP
9 6 (0.18%) TCP/IP
10 4 (0.12%) Reverse Proxy
11 3 (0.088%) PuTTY
11 3 (0.088%) WinSCP
Database & Business Intelligence
1 1,273 (37.42%) Power BI
2 1,041 (30.60%) SQL Server
3 919 (27.01%) SQL Server Integration Services
4 728 (21.40%) SQL Server Reporting Services
5 659 (19.37%) Data Lake
6 559 (16.43%) SQL Server Analysis Services
7 519 (15.26%) Big Data
8 491 (14.43%) Tableau
9 288 (8.47%) Relational Database
10 252 (7.41%) Azure SQL Data Warehouse
11 246 (7.23%) Amazon Redshift
11 246 (7.23%) NoSQL
12 237 (6.97%) Azure SQL Database
13 206 (6.06%) Hadoop
14 164 (4.82%) Enterprise Data Warehouse
14 164 (4.82%) Microsoft Analysis Services
15 135 (3.97%) MySQL
16 129 (3.79%) PostgreSQL
17 122 (3.59%) BigQuery
18 110 (3.23%) Metadata
Development Applications
1 169 (4.97%) Git (software)
2 147 (4.32%) JIRA
3 87 (2.56%) Visual Studio
4 55 (1.62%) Team Foundation Server
5 54 (1.59%) Jenkins
5 54 (1.59%) Oracle APEX
6 36 (1.06%) SQL Server Management Studio (SSMS)
7 34 (1.00%) Bitbucket
8 33 (0.97%) ERwin
9 19 (0.56%) CircleCI
10 18 (0.53%) ER Studio
11 12 (0.35%) PowerDesigner
11 12 (0.35%) Selenium
11 12 (0.35%) Visual Studio Code
12 11 (0.32%) Jasmine
12 11 (0.32%) TeamCity
13 10 (0.29%) Sonatype Nexus
14 9 (0.26%) Spinnaker
15 8 (0.24%) Bundler
15 8 (0.24%) SpecFlow
General
1 747 (21.96%) Finance
2 735 (21.60%) Social Skills
3 526 (15.46%) Analytical Skills
4 126 (3.70%) Retail
5 111 (3.26%) Marketing
6 104 (3.06%) Banking
7 96 (2.82%) Presentation Skills
8 84 (2.47%) Law
9 66 (1.94%) Back Office
10 58 (1.70%) Manufacturing
11 53 (1.56%) Public Sector
12 49 (1.44%) Legal
13 45 (1.32%) Advertising
13 45 (1.32%) Publishing
14 44 (1.29%) Investment Banking
15 40 (1.18%) Influencing Skills
16 35 (1.03%) Organisational Skills
17 25 (0.73%) Pharmaceutical
18 23 (0.68%) Automotive
19 19 (0.56%) Inclusion and Diversity
Job Titles
1 838 (24.63%) Developer
2 815 (23.96%) Data Engineer
3 504 (14.81%) Business Intelligence Developer
4 486 (14.29%) Architect
5 437 (12.85%) Analyst
6 371 (10.91%) Data Architect
7 187 (5.50%) Data Analyst
8 177 (5.20%) Azure Engineer
9 145 (4.26%) SQL Developer
10 141 (4.14%) Senior Data Engineer
11 136 (4.00%) Business Intelligence Analyst
12 130 (3.82%) Consultant
13 126 (3.70%) Business Developer
14 117 (3.44%) Azure Architect
15 112 (3.29%) Solutions Architect
16 107 (3.15%) Power BI Developer
17 95 (2.79%) Data Warehouse Developer
18 85 (2.50%) DBA
19 76 (2.23%) Senior Architect
20 75 (2.20%) Business Intelligence Lead
Libraries, Frameworks & Software Standards
1 217 (6.38%) Kafka
2 204 (6.00%) .NET
3 126 (3.70%) Web Services
4 111 (3.26%) XML
5 105 (3.09%) MDX
6 93 (2.73%) REST
7 81 (2.38%) HTML
7 81 (2.38%) JSON
8 80 (2.35%) PySpark
9 64 (1.88%) React
10 60 (1.76%) .NET Framework
11 47 (1.38%) Middleware
12 41 (1.21%) .NET Core
13 39 (1.15%) ASP.NET
13 39 (1.15%) Pandas
14 38 (1.12%) Oracle GoldenGate
15 35 (1.03%) CSS
16 31 (0.91%) GraphQL
16 31 (0.91%) Node.js
17 30 (0.88%) Apache Beam
Miscellaneous
1 205 (6.03%) Data Structures
2 147 (4.32%) Management Information System
3 97 (2.85%) Algorithms
4 85 (2.50%) Self-Motivation
5 75 (2.20%) Greenfield Project
6 60 (1.76%) Legacy Systems
7 58 (1.70%) Life Science
8 57 (1.68%) User Experience
9 39 (1.15%) Cloud Native
10 36 (1.06%) Enterprise Software
11 33 (0.97%) Public Cloud
11 33 (0.97%) Taxonomies
12 30 (0.88%) Analytical Mindset
13 28 (0.82%) Video Conferencing
14 26 (0.76%) Renewable Energy
15 25 (0.73%) Reference Data
15 25 (0.73%) Video\Live Streaming
16 24 (0.71%) Blog
16 24 (0.71%) Replication
17 23 (0.68%) New Media
Operating Systems
1 169 (4.97%) Linux
2 114 (3.35%) Windows
3 54 (1.59%) Unix
4 35 (1.03%) Red Hat Enterprise Linux
5 31 (0.91%) Android
6 28 (0.82%) Apple iOS
7 17 (0.50%) Windows 10
8 16 (0.47%) Windows Server
9 6 (0.18%) SUSE
9 6 (0.18%) Windows 7
10 3 (0.088%) Windows Server 2012
11 2 (0.059%) CentOS
12 1 (0.029%) Ubuntu
12 1 (0.029%) VMS
12 1 (0.029%) zOS
Processes & Methodologies
1 2,185 (64.23%) Business Intelligence
2 1,515 (44.53%) ETL
3 1,339 (39.36%) Analytics
4 1,024 (30.10%) Data Modelling
5 821 (24.13%) Agile Software Development
6 650 (19.11%) Visualisation
7 480 (14.11%) Data Architecture
7 480 (14.11%) Data Engineering
8 475 (13.96%) DevOps
9 460 (13.52%) Data Pipeline
10 412 (12.11%) Data Science
11 408 (11.99%) Problem-Solving
12 364 (10.70%) Migration
13 348 (10.23%) Data Analytics
14 339 (9.96%) Data Management
15 337 (9.91%) Data Visualisation
16 318 (9.35%) Data Analysis
17 277 (8.14%) Data Integration
18 267 (7.85%) Machine Learning
19 261 (7.67%) Stakeholder Management
Programming Languages
1 2,244 (65.96%) SQL
2 980 (28.81%) Python
3 495 (14.55%) T-SQL
4 270 (7.94%) Java
5 231 (6.79%) C#
6 177 (5.20%) Data Analysis Expressions (DAX)
7 142 (4.17%) PowerShell
8 140 (4.12%) R
9 116 (3.41%) Scala
10 114 (3.35%) JavaScript
11 76 (2.23%) PL/SQL
12 47 (1.38%) C++
13 40 (1.18%) Bash Shell
14 32 (0.94%) Go
14 32 (0.94%) Shell Script
15 31 (0.91%) C
16 29 (0.85%) PHP
16 29 (0.85%) TypeScript
17 28 (0.82%) VBA
18 24 (0.71%) Kotlin
Qualifications
1 258 (7.58%) Degree
2 77 (2.26%) Security Cleared
3 72 (2.12%) SC Cleared
4 50 (1.47%) Microsoft Certification
5 47 (1.38%) Computer Science Degree
6 32 (0.94%) PhD
7 23 (0.68%) Master's Degree
8 22 (0.65%) Numerate Degree
9 19 (0.56%) TOGAF Certification
10 17 (0.50%) ISEB
11 13 (0.38%) BPSS Clearance
11 13 (0.38%) ISTQB
12 11 (0.32%) DV Cleared
13 7 (0.21%) PRINCE2 Practitioner
14 6 (0.18%) ACCA
14 6 (0.18%) CIMA
14 6 (0.18%) CISA
14 6 (0.18%) CISM
14 6 (0.18%) CISSP
14 6 (0.18%) ISSAP
Quality Assurance & Compliance
1 358 (10.52%) Data Quality
2 120 (3.53%) QA
3 105 (3.09%) GDPR
4 22 (0.65%) GRC
5 16 (0.47%) ISO/IEC 27001
6 12 (0.35%) Sarbanes-Oxley
7 11 (0.32%) SLA
8 7 (0.21%) NIST
9 6 (0.18%) COBIT
9 6 (0.18%) PMO
10 5 (0.15%) Accessibility
11 3 (0.088%) SOC 2
12 2 (0.059%) HL7
12 2 (0.059%) Solvency II
13 1 (0.029%) GxP
13 1 (0.029%) NCSC
13 1 (0.029%) PCI DSS
System Software
1 151 (4.44%) Docker
2 25 (0.73%) Active Directory
3 15 (0.44%) Virtual Machines
4 13 (0.38%) Apache ZooKeeper
5 11 (0.32%) etcd
6 8 (0.24%) VMware Infrastructure
7 7 (0.21%) Ceph
8 6 (0.18%) Hyper-V
9 5 (0.15%) HDFS
9 5 (0.15%) Virtual Desktop
10 3 (0.088%) Apache Flume
10 3 (0.088%) VirtualBox
10 3 (0.088%) VMware ESXi
11 1 (0.029%) Firmware
11 1 (0.029%) NFS
11 1 (0.029%) Oracle Clusterware
11 1 (0.029%) Oracle RAC
Systems Management
1 120 (3.53%) Kubernetes
2 80 (2.35%) Terraform
3 30 (0.88%) Puppet
4 25 (0.73%) Ansible
5 19 (0.56%) Opscode Chef
6 15 (0.44%) Grafana
6 15 (0.44%) Prometheus
7 11 (0.32%) Consul
8 9 (0.26%) Oracle Enterprise Manager
9 8 (0.24%) Data Guard
9 8 (0.24%) HP Quality Center
10 7 (0.21%) Galera Cluster
10 7 (0.21%) Hadoop YARN
11 6 (0.18%) Single Sign-On
12 5 (0.15%) Oozie
12 5 (0.15%) Oracle RMAN
13 4 (0.12%) Control-M
13 4 (0.12%) Enterprise Manager Cloud Control
13 4 (0.12%) HP ALM
14 3 (0.088%) Docker Swarm
Vendors
1 841 (24.72%) Microsoft
2 329 (9.67%) Databricks
3 321 (9.44%) Oracle
4 258 (7.58%) Google
5 151 (4.44%) Informatica
6 127 (3.73%) SAP
7 103 (3.03%) Talend
8 100 (2.94%) Salesforce.com
9 84 (2.47%) Alteryx
10 72 (2.12%) Teradata
11 42 (1.23%) IBM
12 41 (1.21%) Cognos
13 32 (0.94%) Red Hat
14 28 (0.82%) JD Edwards
15 23 (0.68%) Sage
16 21 (0.62%) Cloudera
17 19 (0.56%) MuleSoft
17 19 (0.56%) StreamSets
18 18 (0.53%) VMware
19 16 (0.47%) Splunk