Job Vacancy Trend Salary Trend Salary Histogram Job Locations Skill Sets
Period
to 2 December 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 2 December 2020 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK
6 months to
2 Dec 2020		 Same period 2019 Same period 2018
Rank 108 110 117
Rank change year-on-year +2 +7 +5
Permanent jobs citing Data Warehouse 1,640 3,836 4,587
As % of all permanent jobs advertised in the UK 2.92% 2.86% 2.87%
As % of the Database & Business Intelligence category 10.35% 10.54% 9.86%
Number of salaries quoted 1,449 3,300 3,989
Median annual salary £55,000 £55,000 £55,000
10th Percentile £37,500 £36,250 £34,200
90th Percentile £90,000 £85,000 £85,000
UK excluding London median annual salary £50,000 £47,500 £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 15,842 36,379 46,519
As % of all permanent IT jobs advertised in the UK 28.16% 27.11% 29.09%
Number of salaries quoted 13,476 30,007 38,320
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,750 £31,250
90th Percentile £87,500 £86,250 £83,750
UK excluding London median annual salary £49,000 £45,000 £45,000
% change year-on-year +8.89% - +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 2 December 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 2 December 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 +1 1,482 £56,000 +1.82% 268
UK excluding London +23 839 £50,000 +5.26% 175
London -13 748 £67,500 +3.85% 104
North of England +10 278 £50,000 +6.38% 61
Work from Home +8 181 £57,500 +9.81% 40
North West +16 177 £55,000 +15.79% 34
Midlands +35 155 £50,000 +11.11% 43
South East +18 126 £52,500 +5.00% 23
South West +22 103 £42,500 -15.00% 19
West Midlands +3 93 £50,000 +5.56% 32
Yorkshire +30 90 £46,250 +2.78% 19
Scotland +20 69 £50,500 +18.82% 7
East Midlands +70 62 £50,000 +11.11% 11
East of England +37 56 £60,000 +23.08% 16
Wales +21 31 £45,000 +9.76% 3
Northern Ireland +22 16 £35,000 -22.22% 3
North East -11 11 £40,250 -6.21% 8
Channel Islands +7 5 £55,000 -8.33%

For the 6 months to 2 December 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 1,099 (67.01%) SQL
2 1,005 (61.28%) Business Intelligence
3 741 (45.18%) Azure
4 734 (44.76%) ETL
5 655 (39.94%) SQL Server
6 555 (33.84%) Power Platform
7 548 (33.41%) Power BI
8 526 (32.07%) Analytics
9 524 (31.95%) Agile Software Development
10 522 (31.83%) SQL Server Integration Services
11 490 (29.88%) Microsoft
12 461 (28.11%) Finance
13 450 (27.44%) AWS
14 449 (27.38%) Python
15 423 (25.79%) Data Modelling
16 421 (25.67%) SQL Server Reporting Services
17 337 (20.55%) Data Lake
18 313 (19.09%) SQL Server Analysis Services
19 284 (17.32%) DevOps
20 267 (16.28%) Visualisation
21 255 (15.55%) GCP
22 246 (15.00%) T-SQL
23 244 (14.88%) Analytical Skills
24 234 (14.27%) Big Data
25 222 (13.54%) Snowflake Schema
26 220 (13.41%) Tableau
27 202 (12.32%) Amazon Redshift
28 192 (11.71%) Data Engineering
29 177 (10.79%) Google
30 176 (10.73%) Data Management

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 135 (8.23%) Apache Spark
2 107 (6.52%) Apache
3 45 (2.74%) Apache Airflow
4 37 (2.26%) SharePoint
5 25 (1.52%) SAS
6 14 (0.85%) Elasticsearch
7 13 (0.79%) Luigi
8 10 (0.61%) Apache Synapse
9 9 (0.55%) Cloud Foundry
9 9 (0.55%) Confluence
10 8 (0.49%) Jupyter
11 6 (0.37%) nginx
11 6 (0.37%) Tomcat
12 5 (0.30%) Oracle Workflow
13 3 (0.18%) Apache Pig
13 3 (0.18%) CMS
14 2 (0.12%) Camunda
14 2 (0.12%) Mule
14 2 (0.12%) Mule ESB
14 2 (0.12%) SharePoint 2013
Applications
1 103 (6.28%) Microsoft Excel
2 18 (1.10%) Microsoft Office
3 8 (0.49%) Microsoft PowerPoint
3 8 (0.49%) MS Visio
4 3 (0.18%) SPSS
5 2 (0.12%) Microsoft Project
5 2 (0.12%) S-PLUS
Business Applications
1 10 (0.61%) Dynamics AX
2 7 (0.43%) Dynamics CRM
2 7 (0.43%) SAP CRM
3 4 (0.24%) SAP IS-U
3 4 (0.24%) Sparx Enterprise Architect
4 3 (0.18%) Cognos Business Intelligence
4 3 (0.18%) Eikon
4 3 (0.18%) Oracle EBS
4 3 (0.18%) Sentinel
5 2 (0.12%) Maximo
5 2 (0.12%) Oracle General Ledger
5 2 (0.12%) Oracle Internet Expenses
5 2 (0.12%) Oracle iProcurement
5 2 (0.12%) Oracle Procure-to-Pay
5 2 (0.12%) SAP APO
5 2 (0.12%) SAP SCM
5 2 (0.12%) SystmOne
6 1 (0.061%) JDE EnterpriseOne
6 1 (0.061%) Retail-J
6 1 (0.061%) Salesforce.com CRM
Cloud Services
1 741 (45.18%) Azure
2 555 (33.84%) Power Platform
3 450 (27.44%) AWS
4 255 (15.55%) GCP
5 175 (10.67%) Azure Data Factory
6 98 (5.98%) Serverless
7 89 (5.43%) AWS Lambda
8 55 (3.35%) Amazon ECS
9 42 (2.56%) SaaS
10 40 (2.44%) Amazon S3
11 38 (2.32%) Apigee
12 37 (2.26%) PaaS
13 33 (2.01%) Amazon EMR
14 23 (1.40%) Amazon EC2
15 21 (1.28%) Azure Stack
16 20 (1.22%) Logic Apps
16 20 (1.22%) Trello
17 17 (1.04%) IaaS
18 16 (0.98%) AWS CloudFormation
18 16 (0.98%) Dynamics 365
Communications & Networking
1 8 (0.49%) Firewall
2 7 (0.43%) SSH
3 6 (0.37%) Broadband
4 3 (0.18%) LAN
4 3 (0.18%) WAN
5 2 (0.12%) DNS
5 2 (0.12%) Internet
5 2 (0.12%) MPLS
5 2 (0.12%) VPN
5 2 (0.12%) WebEx
6 1 (0.061%) AMQP
6 1 (0.061%) HTTP
6 1 (0.061%) Kerberos
6 1 (0.061%) Skype
6 1 (0.061%) SSL
6 1 (0.061%) VLAN
Database & Business Intelligence
1 655 (39.94%) SQL Server
2 548 (33.41%) Power BI
3 522 (31.83%) SQL Server Integration Services
4 421 (25.67%) SQL Server Reporting Services
5 337 (20.55%) Data Lake
6 313 (19.09%) SQL Server Analysis Services
7 234 (14.27%) Big Data
8 222 (13.54%) Snowflake Schema
9 220 (13.41%) Tableau
10 202 (12.32%) Amazon Redshift
11 170 (10.37%) Azure SQL Data Warehouse
11 170 (10.37%) Azure SQL Database
11 170 (10.37%) NoSQL
12 125 (7.62%) Relational Database
13 109 (6.65%) MySQL
14 108 (6.59%) Hadoop
15 97 (5.91%) BigQuery
16 90 (5.49%) PostgreSQL
17 86 (5.24%) Microsoft Analysis Services
18 76 (4.63%) BusinessObjects
Development Applications
1 75 (4.57%) Jenkins
2 65 (3.96%) Git (software)
3 61 (3.72%) JIRA
4 38 (2.32%) Artifactory
4 38 (2.32%) GitLab
5 30 (1.83%) Visual Studio
6 27 (1.65%) Selenium
7 26 (1.59%) Cucumber
8 21 (1.28%) Team Foundation Server
9 16 (0.98%) Cypress.io
9 16 (0.98%) ERwin
10 15 (0.91%) SQL Server Management Studio (SSMS)
11 7 (0.43%) TeamCity
12 6 (0.37%) PowerDesigner
13 5 (0.30%) ER Studio
14 4 (0.24%) CA Release Automation
14 4 (0.24%) Octopus Deploy
14 4 (0.24%) Sonatype Nexus
14 4 (0.24%) SpecFlow
15 3 (0.18%) SoapUI
General
1 461 (28.11%) Finance
2 153 (9.33%) Banking
3 83 (5.06%) Back Office
4 69 (4.21%) Retail
5 53 (3.23%) Marketing
6 37 (2.26%) Law
7 36 (2.20%) Public Sector
8 30 (1.83%) Legal
9 23 (1.40%) Front Office
10 17 (1.04%) Advertising
11 16 (0.98%) Manufacturing
12 14 (0.85%) Games
13 10 (0.61%) Financial Institution
13 10 (0.61%) Telecoms
14 6 (0.37%) Digital Economy
14 6 (0.37%) Local Government
15 5 (0.30%) iGaming
15 5 (0.30%) Investment Banking
16 4 (0.24%) Pharmaceutical
17 3 (0.18%) Electronics
Job Titles
1 519 (31.65%) Developer
2 361 (22.01%) Data Engineer
3 280 (17.07%) Business Intelligence Developer
4 204 (12.44%) Analyst
5 192 (11.71%) Architect
6 142 (8.66%) Data Architect
7 127 (7.74%) SQL Developer
8 95 (5.79%) Data Warehouse Developer
9 87 (5.30%) Senior Developer
10 79 (4.82%) Solutions Architect
11 76 (4.63%) Consultant
12 72 (4.39%) Data Analyst
13 66 (4.02%) Azure Engineer
14 60 (3.66%) Data Manager
15 59 (3.60%) Business Intelligence Analyst
16 57 (3.48%) Business Developer
16 57 (3.48%) Power BI Developer
16 57 (3.48%) SQL BI Developer
17 56 (3.41%) Senior Business Intelligence Developer
18 51 (3.11%) Azure Developer
Libraries, Frameworks & Software Standards
1 121 (7.38%) Kafka
2 85 (5.18%) Web Services
3 83 (5.06%) .NET
4 44 (2.68%) gRPC
5 43 (2.62%) REST
6 38 (2.32%) JSON
6 38 (2.32%) OAuth
6 38 (2.32%) Swagger
6 38 (2.32%) XML
7 33 (2.01%) HTML
8 32 (1.95%) MDX
9 29 (1.77%) PySpark
10 28 (1.71%) SOAP
11 21 (1.28%) CSS
11 21 (1.28%) Node.js
12 19 (1.16%) AngularJS
12 19 (1.16%) Apache NiFi
13 18 (1.10%) React
14 15 (0.91%) Spring Boot
15 14 (0.85%) .NET Core
Miscellaneous
1 244 (14.88%) Analytical Skills
2 77 (4.70%) Data Structures
2 77 (4.70%) Management Information System
3 54 (3.29%) Hedge funds
4 44 (2.68%) Greenfield Project
5 35 (2.13%) User Experience
6 24 (1.46%) Clustering
6 24 (1.46%) Self-Motivation
7 23 (1.40%) Virtual Team
8 21 (1.28%) Algorithms
9 20 (1.22%) Replication
10 19 (1.16%) NHS
11 18 (1.10%) Mobile App
11 18 (1.10%) Reference Data
12 17 (1.04%) Online Banking
13 15 (0.91%) Data Centre
14 14 (0.85%) Analytical Mindset
14 14 (0.85%) Cloud Native
15 13 (0.79%) Derivative
16 12 (0.73%) Mobile Banking
Operating Systems
1 53 (3.23%) Linux
2 50 (3.05%) Windows
3 36 (2.20%) Unix
4 17 (1.04%) Windows Server
5 12 (0.73%) Windows Server 2016
6 8 (0.49%) Red Hat Enterprise Linux
7 5 (0.30%) Windows Server 2019
8 4 (0.24%) Windows 10
9 3 (0.18%) Android
9 3 (0.18%) Apple iOS
10 2 (0.12%) Solaris
11 1 (0.061%) Windows Server 2008
Processes & Methodologies
1 1,005 (61.28%) Business Intelligence
2 734 (44.76%) ETL
3 526 (32.07%) Analytics
4 524 (31.95%) Agile Software Development
5 423 (25.79%) Data Modelling
6 284 (17.32%) DevOps
7 267 (16.28%) Visualisation
8 192 (11.71%) Data Engineering
9 176 (10.73%) Data Management
10 164 (10.00%) Data Visualisation
11 162 (9.88%) Migration
12 153 (9.33%) Stakeholder Management
13 149 (9.09%) Data Science
14 143 (8.72%) Data Integration
15 141 (8.60%) Data Architecture
16 134 (8.17%) Data Analytics
17 127 (7.74%) Problem-Solving
18 115 (7.01%) Mentoring
19 113 (6.89%) Data Analysis
20 106 (6.46%) Scrum
Programming Languages
1 1,099 (67.01%) SQL
2 449 (27.38%) Python
3 246 (15.00%) T-SQL
4 167 (10.18%) Java
5 93 (5.67%) R
6 84 (5.12%) C#
7 65 (3.96%) Data Analysis Expressions (DAX)
8 52 (3.17%) Scala
9 47 (2.87%) JavaScript
10 35 (2.13%) PowerShell
11 28 (1.71%) PL/SQL
12 21 (1.28%) C
13 20 (1.22%) VBA
14 15 (0.91%) C++
14 15 (0.91%) Shell Script
15 10 (0.61%) Bash Shell
16 9 (0.55%) VB
17 8 (0.49%) U-SQL
18 7 (0.43%) Julia
18 7 (0.43%) Perl
Qualifications
1 123 (7.50%) Degree
2 38 (2.32%) Sun Certification
3 30 (1.83%) Computer Science Degree
4 28 (1.71%) Microsoft Certification
5 20 (1.22%) Security Cleared
6 14 (0.85%) SC Cleared
7 9 (0.55%) AWS Certification
8 6 (0.37%) ISEB
9 5 (0.30%) Master's Degree
10 4 (0.24%) PhD
11 3 (0.18%) DV Cleared
11 3 (0.18%) ISTQB
11 3 (0.18%) MCSA
11 3 (0.18%) VMware Certified Professional (VCP)
12 2 (0.12%) CISSP
12 2 (0.12%) IIBA
12 2 (0.12%) ITIL Certification
12 2 (0.12%) ITIL Foundation Certificate
12 2 (0.12%) MCPD
12 2 (0.12%) Postgraduate
Quality Assurance & Compliance
1 161 (9.82%) Data Quality
2 51 (3.11%) QA
3 44 (2.68%) GDPR
4 13 (0.79%) SLA
5 5 (0.30%) PMO
6 2 (0.12%) DICOM
6 2 (0.12%) ISO/IEC 20000
6 2 (0.12%) ISO/IEC 27001
6 2 (0.12%) NIST
7 1 (0.061%) COBIT
7 1 (0.061%) HIPAA
7 1 (0.061%) MiFID
7 1 (0.061%) NCSC
7 1 (0.061%) PCI DSS
7 1 (0.061%) UCITS
System Software
1 92 (5.61%) Docker
2 13 (0.79%) Active Directory
3 6 (0.37%) Varnish
4 5 (0.30%) VMware Infrastructure
5 4 (0.24%) Hyper-V
6 3 (0.18%) HDFS
7 2 (0.12%) Apache Flume
7 2 (0.12%) Terminal Services
8 1 (0.061%) Oracle RAC
8 1 (0.061%) Tivoli Workload Scheduler
8 1 (0.061%) zsh
Systems Management
1 80 (4.88%) Kubernetes
2 21 (1.28%) Terraform
3 5 (0.30%) Ansible
4 3 (0.18%) Failover Clustering
4 3 (0.18%) HP Quality Center
4 3 (0.18%) Microsoft Clustering
4 3 (0.18%) Opscode Chef
5 2 (0.12%) Puppet
6 1 (0.061%) Control-M
6 1 (0.061%) Enterprise Manager Cloud Control
6 1 (0.061%) Fluentd
6 1 (0.061%) Foglight
6 1 (0.061%) Oozie
6 1 (0.061%) Oracle Enterprise Manager
6 1 (0.061%) Oracle RMAN
6 1 (0.061%) Tivoli
Vendors
1 490 (29.88%) Microsoft
2 177 (10.79%) Google
3 153 (9.33%) Databricks
4 128 (7.80%) Oracle
5 72 (4.39%) SAP
6 58 (3.54%) Informatica
7 45 (2.74%) Cognos
8 38 (2.32%) Teradata
9 37 (2.26%) Talend
10 30 (1.83%) IBM
11 21 (1.28%) Salesforce.com
12 17 (1.04%) Alteryx
13 11 (0.67%) Vertica
14 10 (0.61%) Ab Initio
14 10 (0.61%) Red Hat
15 9 (0.55%) MicroStrategy
15 9 (0.55%) Netezza
16 8 (0.49%) Splunk
16 8 (0.49%) TIBCO
17 6 (0.37%) StreamSets
293 Data Warehouse job vacancies Nationwide