Period
to 17 October 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 17 October 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK
6 months to
17 Oct 2021
Same period 2020 Same period 2019
Rank 113 106 108
Rank change year-on-year -7 +2 +10
Permanent jobs citing Data Warehouse 3,820 1,453 4,149
As % of all permanent jobs advertised in the UK 3.07% 3.03% 3.02%
As % of the Database & Business Intelligence category 10.98% 10.56% 11.05%
Number of salaries quoted 3,053 1,162 3,460
10th Percentile £37,500 £36,775 £36,250
25th Percentile £46,250 £45,000 £42,750
Median annual salary (50th Percentile) £60,000 £55,000 £55,000
Median % change year-on-year +9.09% - +2.80%
75th Percentile £80,000 £73,750 £71,250
90th Percentile £91,250 £97,500 £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 34,780 13,761 37,563
As % of all permanent IT jobs advertised in the UK 27.93% 28.73% 27.36%
Number of salaries quoted 22,267 11,676 31,078
10th Percentile £35,000 £33,750 £31,250
25th Percentile £42,500 £42,000 £38,250
Median annual salary (50th Percentile) £57,500 £55,000 £52,500
Median % change year-on-year +4.55% +4.76% +5.00%
75th Percentile £77,500 £72,500 £70,000
90th Percentile £95,000 £88,750 £86,250
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +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 17 October 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 17 October 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 +5 3,473 £60,000 +4.35% 590
UK excluding London +3 1,825 £50,000 - 360
London -8 1,748 £70,000 +3.70% 251
Work from Home +23 763 £60,000 +18.81% 101
North of England +16 619 £47,000 -6.00% 118
Midlands -25 325 £50,000 - 80
South East -21 317 £57,500 +4.55% 86
North West -7 309 £50,000 -4.76% 63
Yorkshire +28 275 £45,000 -5.26% 30
West Midlands -14 242 £52,500 +5.00% 53
South West -1 220 £50,000 +17.65% 22
East of England -1 178 £55,000 +5.77% 28
Scotland -36 130 £50,000 +3.09% 12
East Midlands -50 83 £47,500 - 27
Wales -40 42 £39,500 -1.87% 9
North East -2 35 £45,000 +18.42% 25
Northern Ireland -57 1 £24,000 -31.43% 5

For the 6 months to 17 October 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,626 (68.74%) SQL
2 2,387 (62.49%) Business Intelligence
3 1,760 (46.07%) ETL
4 1,571 (41.13%) Azure
5 1,540 (40.31%) Analytics
6 1,369 (35.84%) Power Platform
7 1,353 (35.42%) Power BI
8 1,224 (32.04%) Data Modelling
9 1,175 (30.76%) SQL Server
10 1,145 (29.97%) Python
11 1,062 (27.80%) Microsoft
12 979 (25.63%) Agile Software Development
13 967 (25.31%) SQL Server Integration Services
14 883 (23.12%) Social Skills
15 871 (22.80%) AWS
16 848 (22.20%) Finance
17 799 (20.92%) Data Lake
18 763 (19.97%) SQL Server Reporting Services
19 735 (19.24%) Visualisation
20 682 (17.85%) Analytical Skills
21 588 (15.39%) Big Data
22 579 (15.16%) SQL Server Analysis Services
23 576 (15.08%) Problem-Solving
24 574 (15.03%) DevOps
25 562 (14.71%) Data Engineering
26 552 (14.45%) T-SQL
27 536 (14.03%) Tableau
28 534 (13.98%) Data Architecture
29 525 (13.74%) Azure Data Factory
30 487 (12.75%) Data Pipeline

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 338 (8.85%) Apache Spark
2 208 (5.45%) Apache Airflow
3 123 (3.22%) Apache
4 94 (2.46%) Confluence
5 82 (2.15%) SAS
6 77 (2.02%) SharePoint
7 27 (0.71%) Luigi
8 26 (0.68%) Elasticsearch
9 21 (0.55%) Gunicorn
10 19 (0.50%) Apache Pig
10 19 (0.50%) Oracle Application Server
11 12 (0.31%) Oracle Workflow
12 11 (0.29%) CMS
13 9 (0.24%) Apache Synapse
13 9 (0.24%) IIS
13 9 (0.24%) Oracle SOA Suite
14 5 (0.13%) Jupyter
15 4 (0.10%) Sitecore CMS
16 3 (0.079%) Apache Solr
16 3 (0.079%) Facebook Platform
Applications
1 296 (7.75%) Microsoft Excel
2 64 (1.68%) Microsoft Office
3 35 (0.92%) MS Visio
4 18 (0.47%) Spreadsheet
5 16 (0.42%) Microsoft PowerPoint
6 15 (0.39%) Microsoft Project
7 6 (0.16%) Oracle Smart View
8 5 (0.13%) Chatbot
Business Applications
1 45 (1.18%) Dynamics CRM
2 37 (0.97%) NetSuite
3 33 (0.86%) Oracle EBS
4 18 (0.47%) Dynamics AX
5 10 (0.26%) Dynamics NAV
5 10 (0.26%) Shopify
6 7 (0.18%) Academy Revenues and Benefits
7 6 (0.16%) HFM
7 6 (0.16%) Sage 50
7 6 (0.16%) SAP S/4HANA
8 5 (0.13%) JDE EnterpriseOne
8 5 (0.13%) JDE OneWorld
8 5 (0.13%) Oracle Applications
9 4 (0.10%) OPENHousing
9 4 (0.10%) Oracle Retail
9 4 (0.10%) Unit4 Business World
10 3 (0.079%) Maximo
10 3 (0.079%) Oracle BPM
10 3 (0.079%) Oracle ERP
10 3 (0.079%) Oracle Financials
Cloud Services
1 1,571 (41.13%) Azure
2 1,369 (35.84%) Power Platform
3 871 (22.80%) AWS
4 525 (13.74%) Azure Data Factory
5 413 (10.81%) GCP
6 358 (9.37%) Snowflake
7 250 (6.54%) Azure Synapse Analytics
8 172 (4.50%) SaaS
9 129 (3.38%) Serverless
10 117 (3.06%) PaaS
11 116 (3.04%) GitHub
12 102 (2.67%) Amazon S3
13 75 (1.96%) Dynamics 365
14 67 (1.75%) Microsoft 365
15 64 (1.68%) Azure Logic Apps
16 62 (1.62%) PowerApps
17 58 (1.52%) AWS Lambda
18 53 (1.39%) Google Analytics
19 51 (1.34%) Azure Functions
19 51 (1.34%) IaaS
Communications & Networking
1 19 (0.50%) Internet
2 18 (0.47%) FTP
3 14 (0.37%) SSH
4 13 (0.34%) DNS
4 13 (0.34%) HTTP
5 12 (0.31%) HTTPS
6 10 (0.26%) Intranet
7 9 (0.24%) DHCP
7 9 (0.24%) IPv4
7 9 (0.24%) IPv6
7 9 (0.24%) Network Security
7 9 (0.24%) SMTP
7 9 (0.24%) SNMP
7 9 (0.24%) TCP/IP
8 7 (0.18%) Broadband
9 6 (0.16%) VPN
10 5 (0.13%) Firewall
11 4 (0.10%) Extranet
12 3 (0.079%) SMPP
12 3 (0.079%) SMS
Database & Business Intelligence
1 1,353 (35.42%) Power BI
2 1,175 (30.76%) SQL Server
3 967 (25.31%) SQL Server Integration Services
4 799 (20.92%) Data Lake
5 763 (19.97%) SQL Server Reporting Services
6 588 (15.39%) Big Data
7 579 (15.16%) SQL Server Analysis Services
8 536 (14.03%) Tableau
9 368 (9.63%) Relational Database
10 306 (8.01%) Azure SQL Data Warehouse
11 289 (7.57%) Azure SQL Database
12 283 (7.41%) Amazon Redshift
13 279 (7.30%) NoSQL
14 261 (6.83%) MySQL
15 249 (6.52%) Hadoop
16 212 (5.55%) PostgreSQL
17 180 (4.71%) Enterprise Data Warehouse
18 156 (4.08%) BigQuery
18 156 (4.08%) OLAP
19 135 (3.53%) Microsoft Analysis Services
Development Applications
1 234 (6.13%) Git (software)
2 204 (5.34%) JIRA
3 122 (3.19%) Visual Studio
4 81 (2.12%) Jenkins
5 70 (1.83%) Team Foundation Server
6 57 (1.49%) SQL Server Management Studio (SSMS)
7 50 (1.31%) Oracle APEX
8 42 (1.10%) ERwin
9 30 (0.79%) Bitbucket
10 27 (0.71%) CircleCI
11 25 (0.65%) VSS/SourceSafe
12 18 (0.47%) ER Studio
12 18 (0.47%) GitLab
13 16 (0.42%) TeamCity
14 14 (0.37%) Octopus Deploy
14 14 (0.37%) Visual Studio Code
15 12 (0.31%) PowerDesigner
15 12 (0.31%) Selenium
15 12 (0.31%) Subversion
16 11 (0.29%) Visual Studio Team System
General
1 883 (23.12%) Social Skills
2 848 (22.20%) Finance
3 682 (17.85%) Analytical Skills
4 162 (4.24%) Retail
5 135 (3.53%) Marketing
6 127 (3.32%) Banking
7 107 (2.80%) Presentation Skills
8 104 (2.72%) Law
9 87 (2.28%) Publishing
10 83 (2.17%) Public Sector
11 66 (1.73%) Legal
12 63 (1.65%) Advertising
13 54 (1.41%) Manufacturing
14 52 (1.36%) Investment Banking
15 46 (1.20%) Inclusion and Diversity
16 41 (1.07%) Organisational Skills
17 40 (1.05%) Influencing Skills
18 39 (1.02%) Back Office
19 37 (0.97%) Automotive
20 35 (0.92%) Pharmaceutical
Job Titles
1 935 (24.48%) Developer
2 920 (24.08%) Data Engineer
3 530 (13.87%) Business Intelligence Developer
4 505 (13.22%) Analyst
5 478 (12.51%) Architect
6 377 (9.87%) Data Architect
7 233 (6.10%) Data Analyst
8 174 (4.55%) Azure Engineer
9 161 (4.21%) SQL Developer
10 159 (4.16%) Business Intelligence Analyst
11 147 (3.85%) Senior Data Engineer
12 141 (3.69%) Consultant
13 124 (3.25%) Administrator
14 123 (3.22%) Solutions Architect
15 113 (2.96%) DBA
16 106 (2.77%) Business Developer
16 106 (2.77%) Data Warehouse Developer
17 101 (2.64%) Power BI Developer
18 98 (2.57%) Azure Architect
19 94 (2.46%) Data Manager
Libraries, Frameworks & Software Standards
1 266 (6.96%) Kafka
2 197 (5.16%) .NET
3 152 (3.98%) MDX
4 135 (3.53%) Web Services
5 122 (3.19%) XML
6 104 (2.72%) REST
7 93 (2.43%) JSON
8 92 (2.41%) PySpark
9 68 (1.78%) React
10 53 (1.39%) HTML
11 49 (1.28%) .NET Framework
12 46 (1.20%) Pandas
13 38 (0.99%) GraphQL
13 38 (0.99%) Oracle GoldenGate
14 36 (0.94%) ASP.NET
14 36 (0.94%) Node.js
15 35 (0.92%) SOAP
16 34 (0.89%) Apache Beam
16 34 (0.89%) NumPy
17 33 (0.86%) .NET Core
Miscellaneous
1 222 (5.81%) Data Structures
2 206 (5.39%) Management Information System
3 120 (3.14%) Algorithms
4 101 (2.64%) Self-Motivation
5 74 (1.94%) Life Science
6 72 (1.88%) Greenfield Project
7 62 (1.62%) Legacy Systems
8 58 (1.52%) User Experience
9 57 (1.49%) Clustering
10 54 (1.41%) Data Protection Act
11 52 (1.36%) Cloud Native
11 52 (1.36%) Public Cloud
12 46 (1.20%) Driving Licence
13 39 (1.02%) Analytical Mindset
14 33 (0.86%) Renewable Energy
15 31 (0.81%) Enterprise Software
15 31 (0.81%) Reference Data
16 30 (0.79%) Virtual Team
17 28 (0.73%) Replication
18 25 (0.65%) NHS
Operating Systems
1 139 (3.64%) Linux
2 80 (2.09%) Windows
3 76 (1.99%) Unix
4 24 (0.63%) Android
5 21 (0.55%) Apple iOS
6 17 (0.45%) Windows Server
7 12 (0.31%) Windows 10
8 10 (0.26%) Red Hat Enterprise Linux
9 3 (0.079%) Windows 7
9 3 (0.079%) Windows Server 2012
10 1 (0.026%) SUSE
10 1 (0.026%) VMS
10 1 (0.026%) zOS
Processes & Methodologies
1 2,387 (62.49%) Business Intelligence
2 1,760 (46.07%) ETL
3 1,540 (40.31%) Analytics
4 1,224 (32.04%) Data Modelling
5 979 (25.63%) Agile Software Development
6 735 (19.24%) Visualisation
7 576 (15.08%) Problem-Solving
8 574 (15.03%) DevOps
9 562 (14.71%) Data Engineering
10 534 (13.98%) Data Architecture
11 487 (12.75%) Data Pipeline
12 482 (12.62%) Migration
13 478 (12.51%) Data Science
14 476 (12.46%) Data Management
15 398 (10.42%) Data Analytics
16 382 (10.00%) Data Visualisation
17 381 (9.97%) Data Analysis
18 326 (8.53%) Data Integration
19 320 (8.38%) Stakeholder Management
20 291 (7.62%) Machine Learning
Programming Languages
1 2,626 (68.74%) SQL
2 1,145 (29.97%) Python
3 552 (14.45%) T-SQL
4 344 (9.01%) Java
5 280 (7.33%) C#
6 233 (6.10%) R
7 220 (5.76%) Data Analysis Expressions (DAX)
8 212 (5.55%) PowerShell
9 141 (3.69%) Scala
10 124 (3.25%) JavaScript
11 122 (3.19%) PL/SQL
12 65 (1.70%) VB
13 58 (1.52%) C++
14 46 (1.20%) Go
15 37 (0.97%) Shell Script
15 37 (0.97%) TypeScript
16 35 (0.92%) VBA
17 34 (0.89%) Bash Shell
18 29 (0.76%) Kotlin
19 23 (0.60%) C
Qualifications
1 297 (7.77%) Degree
2 88 (2.30%) Security Cleared
3 78 (2.04%) SC Cleared
4 53 (1.39%) Microsoft Certification
5 51 (1.34%) Computer Science Degree
6 46 (1.20%) PhD
7 35 (0.92%) Master's Degree
8 23 (0.60%) TOGAF Certification
9 21 (0.55%) BPSS Clearance
9 21 (0.55%) ISEB
10 20 (0.52%) ISTQB
10 20 (0.52%) Numerate Degree
11 16 (0.42%) PMI Certification
12 8 (0.21%) ITIL Certification
13 6 (0.16%) AWS Certification
13 6 (0.16%) SAS Certification
14 5 (0.13%) ACCA
14 5 (0.13%) CIMA
14 5 (0.13%) PMP
14 5 (0.13%) Tableau Certification
Quality Assurance & Compliance
1 471 (12.33%) Data Quality
2 160 (4.19%) GDPR
2 160 (4.19%) QA
3 27 (0.71%) GRC
4 16 (0.42%) PMO
5 15 (0.39%) Sarbanes-Oxley
6 14 (0.37%) ISO/IEC 27001
7 13 (0.34%) SLA
8 8 (0.21%) Accessibility
9 5 (0.13%) PMBOK
9 5 (0.13%) Solvency II
10 4 (0.10%) CDISC
11 2 (0.052%) COBIT
11 2 (0.052%) NCSC
11 2 (0.052%) NIST
11 2 (0.052%) PCI DSS
12 1 (0.026%) GxP
12 1 (0.026%) HL7
12 1 (0.026%) SOC 2
System Software
1 150 (3.93%) Docker
2 28 (0.73%) VMware Infrastructure
3 23 (0.60%) Active Directory
4 21 (0.55%) HDFS
5 12 (0.31%) Apache ZooKeeper
6 11 (0.29%) etcd
7 10 (0.26%) Virtual Machines
8 6 (0.16%) Ceph
8 6 (0.16%) Hyper-V
9 5 (0.13%) Apache Flume
10 3 (0.079%) Oracle RAC
10 3 (0.079%) VMware ESXi
11 1 (0.026%) Firmware
11 1 (0.026%) NFS
11 1 (0.026%) Oracle Clusterware
11 1 (0.026%) VirtualBox
Systems Management
1 111 (2.91%) Kubernetes
2 91 (2.38%) Terraform
3 29 (0.76%) Ansible
4 21 (0.55%) Puppet
5 19 (0.50%) Opscode Chef
6 16 (0.42%) Grafana
6 16 (0.42%) Prometheus
7 11 (0.29%) Consul
7 11 (0.29%) HP Quality Center
8 10 (0.26%) Hadoop YARN
8 10 (0.26%) Oozie
9 8 (0.21%) Control-M
10 7 (0.18%) HP ALM
11 6 (0.16%) Data Guard
11 6 (0.16%) Galera Cluster
11 6 (0.16%) Oracle RMAN
12 5 (0.13%) logstash
13 4 (0.10%) BMC PATROL
13 4 (0.10%) Enterprise Manager Cloud Control
13 4 (0.10%) Oracle Enterprise Manager
Vendors
1 1,062 (27.80%) Microsoft
2 454 (11.88%) Oracle
3 397 (10.39%) Databricks
4 300 (7.85%) Google
5 228 (5.97%) Informatica
6 136 (3.56%) SAP
7 134 (3.51%) Talend
8 108 (2.83%) Salesforce.com
9 95 (2.49%) Alteryx
10 67 (1.75%) Teradata
11 60 (1.57%) IBM
12 45 (1.18%) Cognos
13 40 (1.05%) VMware
14 32 (0.84%) JD Edwards
15 31 (0.81%) StreamSets
16 29 (0.76%) MuleSoft
17 24 (0.63%) Cloudera
18 20 (0.52%) Citrix
19 19 (0.50%) SnapLogic
20 16 (0.42%) Hortonworks