Period
to 18 September 2020

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 18 September 2020 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK
6 months to
18 Sep 2020
Same period 2019 Same period 2018
Rank 106 102 114
Rank change year-on-year -4 +12 +1
Permanent jobs citing Data Warehouse 1,520 4,380 4,841
As % of all permanent jobs advertised in the UK 3.01% 3.09% 2.89%
As % of the Database & Business Intelligence category 10.64% 11.42% 9.70%
Number of salaries quoted 1,292 3,795 4,173
Median annual salary £55,000 £55,000 £55,000
10th Percentile £36,250 £36,250 £35,000
90th Percentile £95,000 £83,350 £85,000
UK excluding London median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +5.56%

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 14,281 38,358 49,923
As % of all permanent IT jobs advertised in the UK 28.26% 27.09% 29.76%
Number of salaries quoted 11,858 31,320 40,713
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £33,750 £31,250 £31,250
90th Percentile £90,000 £85,000 £82,500
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

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 18 September 2020.

Salary histogram for Data Warehouse in the UK

Data Warehouse
Top 18 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 18 September 2020. 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 -8 1,389 £57,500 +4.55% 197
UK excluding London +28 760 £50,000 +5.26% 121
London -26 729 £67,500 +8.00% 94
North of England +11 212 £50,000 +7.53% 38
Midlands +37 163 £50,000 +11.11% 22
North West +12 146 £52,250 +10.00% 25
South East +12 128 £52,500 +5.00% 23
West Midlands +43 105 £50,000 +5.26% 12
Work from Home 0 98 £50,000 -4.51% 22
South West +7 88 £42,500 -19.05% 12
East of England +64 62 £52,500 +10.53% 5
Yorkshire +32 60 £47,500 +5.56% 12
East Midlands +35 57 £45,000 - 10
Scotland +27 50 £47,500 +4.40% 9
Wales +41 35 £45,000 +9.76% 6
Northern Ireland +26 14 £35,000 -26.32% 5
Channel Islands +7 8 £55,000 +10.00%
North East -7 6 £38,500 -23.00% 1

For the 6 months to 18 September 2020, 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 990 (65.13%) SQL
2 902 (59.34%) Business Intelligence
3 643 (42.30%) SQL Server
4 642 (42.24%) Azure
5 607 (39.93%) ETL
6 510 (33.55%) Agile Software Development
7 501 (32.96%) Power Platform
8 498 (32.76%) Power BI
9 475 (31.25%) SQL Server Integration Services
10 472 (31.05%) Finance
11 453 (29.80%) Analytics
12 442 (29.08%) Microsoft
13 408 (26.84%) Python
14 393 (25.86%) Data Modelling
15 381 (25.07%) SQL Server Reporting Services
16 373 (24.54%) AWS
17 308 (20.26%) Data Lake
18 286 (18.82%) SQL Server Analysis Services
19 276 (18.16%) DevOps
20 245 (16.12%) Analytical Skills
21 238 (15.66%) GCP
22 237 (15.59%) Visualisation
23 230 (15.13%) T-SQL
24 229 (15.07%) Big Data
25 201 (13.22%) Tableau
26 193 (12.70%) Java
27 176 (11.58%) Snowflake Schema
28 175 (11.51%) Data Engineering
29 173 (11.38%) Amazon Redshift
30 166 (10.92%) Google

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 124 (8.16%) Apache
2 108 (7.11%) Apache Spark
3 32 (2.11%) Apache Airflow
4 29 (1.91%) SharePoint
5 20 (1.32%) SAS
6 13 (0.86%) Luigi
7 12 (0.79%) Confluence
8 11 (0.72%) Elasticsearch
9 9 (0.59%) Apache Synapse
9 9 (0.59%) Cloud Foundry
10 7 (0.46%) Apache Pig
11 6 (0.39%) Jupyter
11 6 (0.39%) SharePoint 2010
11 6 (0.39%) SharePoint 2013
12 5 (0.33%) IIS
12 5 (0.33%) nginx
12 5 (0.33%) Tomcat
13 4 (0.26%) CMS
13 4 (0.26%) Oracle SOA Suite
14 3 (0.20%) MQSeries
Applications
1 87 (5.72%) Microsoft Excel
2 23 (1.51%) Microsoft Office
3 11 (0.72%) Microsoft PowerPoint
4 10 (0.66%) MS Visio
5 4 (0.26%) SPSS
6 2 (0.13%) Chatbot
6 2 (0.13%) S-PLUS
7 1 (0.066%) Microsoft Project
Business Applications
1 9 (0.59%) SAP BPC
2 8 (0.53%) Dynamics CRM
3 6 (0.39%) Maximo
4 5 (0.33%) SAP IS-U
5 4 (0.26%) Dynamics AX
5 4 (0.26%) Eikon
5 4 (0.26%) Markit EDM
6 3 (0.20%) Oracle EBS
6 3 (0.20%) Oracle General Ledger
6 3 (0.20%) Oracle Internet Expenses
6 3 (0.20%) Oracle iProcurement
6 3 (0.20%) Oracle Procure-to-Pay
6 3 (0.20%) Teamcenter
7 1 (0.066%) Cognos Business Intelligence
7 1 (0.066%) Dynamics NAV
7 1 (0.066%) FLEXCUBE
7 1 (0.066%) NetSuite
7 1 (0.066%) Oracle Applications
7 1 (0.066%) SAP Oil and Gas
7 1 (0.066%) Unit4 Business World
Cloud Services
1 642 (42.24%) Azure
2 501 (32.96%) Power Platform
3 373 (24.54%) AWS
4 238 (15.66%) GCP
5 155 (10.20%) Azure Data Factory
6 113 (7.43%) Serverless
7 95 (6.25%) AWS Lambda
8 76 (5.00%) Amazon ECS
9 54 (3.55%) SaaS
10 48 (3.16%) Apigee
11 41 (2.70%) Amazon S3
12 31 (2.04%) PaaS
13 21 (1.38%) Amazon EC2
13 21 (1.38%) Amazon EMR
14 18 (1.18%) Azure Stack
15 15 (0.99%) Logic Apps
16 14 (0.92%) Azure Machine Learning
17 13 (0.86%) IaaS
18 12 (0.79%) Data Lake Analytics
18 12 (0.79%) Trello
Communications & Networking
1 10 (0.66%) Internet
2 8 (0.53%) Broadband
2 8 (0.53%) WebEx
3 5 (0.33%) Firewall
4 4 (0.26%) Skype
4 4 (0.26%) SSH
5 3 (0.20%) LAN
5 3 (0.20%) WAN
6 2 (0.13%) DNS
6 2 (0.13%) Intranet
6 2 (0.13%) MPLS
6 2 (0.13%) Network Security
6 2 (0.13%) Software-Defined Networking
6 2 (0.13%) SSL
7 1 (0.066%) AMQP
7 1 (0.066%) VLAN
7 1 (0.066%) VPN
Database & Business Intelligence
1 643 (42.30%) SQL Server
2 498 (32.76%) Power BI
3 475 (31.25%) SQL Server Integration Services
4 381 (25.07%) SQL Server Reporting Services
5 308 (20.26%) Data Lake
6 286 (18.82%) SQL Server Analysis Services
7 229 (15.07%) Big Data
8 176 (11.58%) Snowflake Schema
9 173 (11.38%) Amazon Redshift
10 146 (9.61%) Azure SQL Data Warehouse
10 146 (9.61%) Azure SQL Database
11 135 (8.88%) NoSQL
12 115 (7.57%) MySQL
13 105 (6.91%) Hadoop
14 104 (6.84%) Relational Database
15 100 (6.58%) BigQuery
15 100 (6.58%) PostgreSQL
16 85 (5.59%) OLAP
17 81 (5.33%) Microsoft Analysis Services
18 79 (5.20%) Looker
Development Applications
1 87 (5.72%) Jenkins
2 71 (4.67%) JIRA
3 66 (4.34%) Git (software)
4 52 (3.42%) GitLab
5 48 (3.16%) Artifactory
6 33 (2.17%) Visual Studio
7 32 (2.11%) Cucumber
7 32 (2.11%) Selenium
8 28 (1.84%) ERwin
9 17 (1.12%) SQL Server Management Studio (SSMS)
10 16 (1.05%) PowerDesigner
11 14 (0.92%) Cypress.io
11 14 (0.92%) Team Foundation Server
12 12 (0.79%) ER Studio
13 6 (0.39%) SpecFlow
13 6 (0.39%) WebDriver
14 5 (0.33%) Selenium IDE
14 5 (0.33%) TeamCity
15 4 (0.26%) Visual Studio Code
15 4 (0.26%) Visual Studio Team System
General
1 472 (31.05%) Finance
2 155 (10.20%) Banking
3 109 (7.17%) Back Office
4 65 (4.28%) Marketing
5 41 (2.70%) Retail
6 34 (2.24%) Advertising
7 29 (1.91%) Law
8 15 (0.99%) Games
9 13 (0.86%) Manufacturing
10 12 (0.79%) Legal
11 10 (0.66%) Financial Institution
11 10 (0.66%) Front Office
11 10 (0.66%) Investment Banking
12 8 (0.53%) Pharmaceutical
13 7 (0.46%) Public Sector
14 6 (0.39%) Local Government
15 5 (0.33%) Telecoms
16 4 (0.26%) Electronics
16 4 (0.26%) Police
17 3 (0.20%) General Ledger
Job Titles
1 517 (34.01%) Developer
2 307 (20.20%) Data Engineer
3 270 (17.76%) Business Intelligence Developer
4 221 (14.54%) Analyst
5 177 (11.64%) Architect
6 151 (9.93%) SQL Developer
7 131 (8.62%) Data Architect
8 123 (8.09%) Data Warehouse Developer
9 87 (5.72%) Solutions Architect
10 86 (5.66%) Senior Developer
11 70 (4.61%) Business Intelligence Analyst
12 65 (4.28%) Azure Engineer
12 65 (4.28%) SQL BI Developer
13 62 (4.08%) Business Developer
13 62 (4.08%) Data Analyst
14 57 (3.75%) Power BI Developer
15 55 (3.62%) Cloud Architect
15 55 (3.62%) Senior Business Intelligence Developer
15 55 (3.62%) SSIS Developer
16 54 (3.55%) AWS Architect
Libraries, Frameworks & Software Standards
1 114 (7.50%) Web Services
2 108 (7.11%) Kafka
3 83 (5.46%) .NET
4 70 (4.61%) gRPC
5 56 (3.68%) REST
6 48 (3.16%) OAuth
6 48 (3.16%) Swagger
7 43 (2.83%) JSON
7 43 (2.83%) XML
8 37 (2.43%) HTML
8 37 (2.43%) MDX
9 29 (1.91%) ASP.NET
10 28 (1.84%) CSS
11 27 (1.78%) PySpark
12 26 (1.71%) SOAP
13 24 (1.58%) AngularJS
14 20 (1.32%) Middleware
15 18 (1.18%) .NET Core
16 16 (1.05%) HTML5
17 15 (0.99%) .NET Framework
Miscellaneous
1 245 (16.12%) Analytical Skills
2 101 (6.64%) Management Information System
3 95 (6.25%) Data Structures
4 79 (5.20%) Hedge funds
5 59 (3.88%) Greenfield Project
6 30 (1.97%) Clustering
6 30 (1.97%) User Experience
7 27 (1.78%) Self-Motivation
8 19 (1.25%) Data Centre
8 19 (1.25%) Derivative
9 18 (1.18%) Algorithms
9 18 (1.18%) Mobile App
9 18 (1.18%) Replication
10 17 (1.12%) Reference Data
11 14 (0.92%) Foreign Exchange (FX)
12 10 (0.66%) Analytical Mindset
12 10 (0.66%) Cloud Native
12 10 (0.66%) FMCG
12 10 (0.66%) Virtual Team
13 9 (0.59%) NHS
Operating Systems
1 49 (3.22%) Windows
2 41 (2.70%) Linux
3 32 (2.11%) Unix
4 23 (1.51%) Windows Server
5 7 (0.46%) Windows Server 2016
6 5 (0.33%) Android
6 5 (0.33%) Apple iOS
7 4 (0.26%) Windows 10
8 2 (0.13%) AIX
8 2 (0.13%) Red Hat Enterprise Linux
8 2 (0.13%) Solaris
9 1 (0.066%) MVS
9 1 (0.066%) Windows Server 2008
Processes & Methodologies
1 902 (59.34%) Business Intelligence
2 607 (39.93%) ETL
3 510 (33.55%) Agile Software Development
4 453 (29.80%) Analytics
5 393 (25.86%) Data Modelling
6 276 (18.16%) DevOps
7 237 (15.59%) Visualisation
8 175 (11.51%) Data Engineering
9 150 (9.87%) Data Architecture
10 149 (9.80%) Data Visualisation
11 144 (9.47%) Data Analytics
12 139 (9.14%) Data Management
13 132 (8.68%) Stakeholder Management
14 127 (8.36%) Migration
14 127 (8.36%) Problem-Solving
15 126 (8.29%) Data Science
16 125 (8.22%) Software Engineering
17 123 (8.09%) Microservices
18 120 (7.89%) SDLC
19 119 (7.83%) Data Integration
Programming Languages
1 990 (65.13%) SQL
2 408 (26.84%) Python
3 230 (15.13%) T-SQL
4 193 (12.70%) Java
5 99 (6.51%) C#
6 70 (4.61%) R
6 70 (4.61%) Scala
7 68 (4.47%) Data Analysis Expressions (DAX)
8 55 (3.62%) JavaScript
9 46 (3.03%) PowerShell
10 32 (2.11%) C
11 30 (1.97%) PL/SQL
12 26 (1.71%) C++
13 25 (1.64%) VBA
14 18 (1.18%) VB.NET
15 15 (0.99%) Shell Script
16 11 (0.72%) Java 8
17 10 (0.66%) U-SQL
18 9 (0.59%) Ruby
18 9 (0.59%) VB
Qualifications
1 125 (8.22%) Degree
2 48 (3.16%) Sun Certification
3 42 (2.76%) Computer Science Degree
4 21 (1.38%) Microsoft Certification
5 17 (1.12%) AWS Certification
6 15 (0.99%) Security Cleared
7 14 (0.92%) Master's Degree
8 10 (0.66%) SC Cleared
9 8 (0.53%) ISEB
9 8 (0.53%) ISTQB
10 6 (0.39%) MCPD
11 5 (0.33%) DV Cleared
11 5 (0.33%) MCSA
12 4 (0.26%) A+ Certification
12 4 (0.26%) PhD
13 3 (0.20%) VMware Certified Professional (VCP)
14 2 (0.13%) CISSP
14 2 (0.13%) ITIL Foundation Certificate
14 2 (0.13%) Numerate Degree
15 1 (0.066%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 128 (8.42%) Data Quality
2 79 (5.20%) QA
3 40 (2.63%) GDPR
4 15 (0.99%) SLA
5 9 (0.59%) Sarbanes-Oxley
6 6 (0.39%) Actionable Recommendations
7 3 (0.20%) UCITS
8 2 (0.13%) COBIT
8 2 (0.13%) ISO/IEC 27001
8 2 (0.13%) NIST
8 2 (0.13%) PMO
9 1 (0.066%) HIPAA
9 1 (0.066%) IFRS
9 1 (0.066%) MiFID
9 1 (0.066%) NCSC
9 1 (0.066%) PCI DSS
9 1 (0.066%) Solvency II
System Software
1 90 (5.92%) Docker
2 13 (0.86%) Active Directory
3 9 (0.59%) Hyper-V
4 8 (0.53%) Virtual Machines
5 5 (0.33%) Varnish
6 4 (0.26%) Apache Flume
6 4 (0.26%) HDFS
6 4 (0.26%) VMware Infrastructure
7 3 (0.20%) Tivoli Workload Scheduler
8 2 (0.13%) Terminal Services
9 1 (0.066%) Oracle RAC
9 1 (0.066%) zsh
Systems Management
1 94 (6.18%) Kubernetes
2 20 (1.32%) Terraform
3 8 (0.53%) HP Quality Center
3 8 (0.53%) Opscode Chef
3 8 (0.53%) SCVMM
4 6 (0.39%) Puppet
5 5 (0.33%) Ansible
5 5 (0.33%) Control-M
6 3 (0.20%) Kibana
6 3 (0.20%) Oozie
6 3 (0.20%) Tivoli
7 2 (0.13%) Argo
8 1 (0.066%) Data Guard
8 1 (0.066%) Fluentd
8 1 (0.066%) Oracle Enterprise Manager
8 1 (0.066%) Oracle ZFS
8 1 (0.066%) Salt
8 1 (0.066%) Single Sign-On
Vendors
1 442 (29.08%) Microsoft
2 201 (13.22%) Tableau
3 166 (10.92%) Google
4 160 (10.53%) Oracle
5 134 (8.82%) Databricks
6 66 (4.34%) SAP
7 55 (3.62%) Informatica
8 46 (3.03%) Teradata
9 25 (1.64%) Cognos
9 25 (1.64%) IBM
10 20 (1.32%) Talend
11 15 (0.99%) Salesforce.com
12 14 (0.92%) Alteryx
13 13 (0.86%) Hortonworks
13 13 (0.86%) MicroStrategy
14 11 (0.72%) Ab Initio
14 11 (0.72%) Sybase
15 10 (0.66%) Netezza
16 8 (0.53%) Atlassian
16 8 (0.53%) PlateSpin