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

Data Warehousing
UK
6 months to
7 Apr 2020
Same period 2019 Same period 2018
Rank 116 115 124
Rank change year-on-year -1 +9 -15
Permanent jobs citing Data Warehouse 3,086 4,276 4,833
As % of all permanent jobs advertised in the UK 2.68% 2.87% 2.71%
As % of the Database & Business Intelligence category 10.03% 10.13% 8.84%
Number of salaries quoted 2,669 3,682 4,185
Median annual salary £59,000 £55,000 £52,500
Median salary % change year-on-year +7.27% +4.76% -
10th Percentile £36,250 £36,250 £32,500
90th Percentile £87,500 £85,000 £78,750
UK excluding London median annual salary £48,000 £48,000 £45,000
% change year-on-year - +6.67% -

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 30,758 42,221 54,679
As % of all permanent IT jobs advertised in the UK 26.67% 28.30% 30.66%
Number of salaries quoted 25,139 34,625 45,618
Median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% +5.26%
10th Percentile £32,500 £31,250 £30,500
90th Percentile £87,500 £85,000 £80,000
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +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 7 April 2020.

Salary histogram for Data Warehouse in the UK

Data Warehouse
Top 19 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 7 April 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 -3 2,900 £60,000 +9.09% 293
London -15 1,547 £67,500 +8.00% 112
UK excluding London +7 1,500 £48,000 - 196
North of England +11 408 £50,000 +11.11% 57
South East -2 365 £55,000 +2.80% 28
Midlands +19 274 £45,000 - 56
North West +34 255 £50,000 +11.11% 17
West Midlands +47 202 £47,500 -5.00% 47
East of England +56 159 £59,000 +24.21% 17
Work from Home -22 134 £57,500 - 17
South West -25 132 £45,000 -14.29% 23
Yorkshire -13 119 £51,250 +13.89% 32
Wales +16 84 £42,500 +13.33% 12
East Midlands -25 70 £40,000 -5.88% 9
Scotland -29 61 £47,500 +5.56% 2
North East +12 34 £39,184 +4.49% 8
Northern Ireland +24 11 £45,000 -
Channel Islands - 6 £60,000 - 1
Isle of Man - 1 £37,500 -

For the 6 months to 7 April 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 2,078 (67.34%) SQL
2 1,931 (62.57%) Business Intelligence
3 1,337 (43.32%) ETL
4 1,334 (43.23%) SQL Server
5 1,087 (35.22%) Power Platform
6 1,079 (34.96%) Power BI
7 1,051 (34.06%) SQL Server Integration Services
8 964 (31.24%) Analytics
9 955 (30.95%) Azure
10 907 (29.39%) Agile Software Development
11 903 (29.26%) Microsoft
12 842 (27.28%) Data Modelling
13 806 (26.12%) SQL Server Reporting Services
14 798 (25.86%) Finance
15 702 (22.75%) Python
16 695 (22.52%) SQL Server Analysis Services
17 542 (17.56%) Analytical Skills
18 518 (16.79%) T-SQL
19 517 (16.75%) Tableau
20 516 (16.72%) AWS
21 494 (16.01%) Big Data
22 475 (15.39%) Visualisation
23 442 (14.32%) Data Lake
24 407 (13.19%) Oracle
25 390 (12.64%) Migration
26 342 (11.08%) Problem-Solving
27 328 (10.63%) DevOps
28 325 (10.53%) Data Science
29 323 (10.47%) Data Management
30 309 (10.01%) Data Architecture

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 230 (7.45%) Apache Spark
2 67 (2.17%) SAS
3 65 (2.11%) Apache
4 58 (1.88%) SharePoint
5 48 (1.56%) Apache Airflow
6 47 (1.52%) Confluence
7 22 (0.71%) Elasticsearch
8 19 (0.62%) IIS
9 18 (0.58%) Tomcat
10 15 (0.49%) Apache Pig
11 11 (0.36%) Luigi
12 10 (0.32%) Oracle Workflow
12 10 (0.32%) PowerExchange
13 9 (0.29%) MQSeries
14 8 (0.26%) CMS
14 8 (0.26%) Jupyter
14 8 (0.26%) Oracle SOA Suite
15 7 (0.23%) BizTalk Server
16 4 (0.13%) Apache Solr
16 4 (0.13%) Apache Synapse
Applications
1 205 (6.64%) Microsoft Excel
2 59 (1.91%) Microsoft Office
3 25 (0.81%) Microsoft PowerPoint
4 12 (0.39%) SPSS
5 9 (0.29%) MS Visio
6 5 (0.16%) Spreadsheet
7 2 (0.065%) InfoPath
Business Applications
1 35 (1.13%) Dynamics CRM
2 20 (0.65%) Dynamics GP
3 16 (0.52%) Cognos Business Intelligence
4 9 (0.29%) Markit EDM
5 7 (0.23%) NetSuite
6 5 (0.16%) Oracle EBS
6 5 (0.16%) RiskWrite
7 4 (0.13%) Oracle Financials
7 4 (0.13%) Raiser's Edge
7 4 (0.13%) SAP BPC
8 3 (0.097%) Dynamics AX
8 3 (0.097%) Oracle Applications
8 3 (0.097%) Oracle EBS R12
8 3 (0.097%) SAP ERP
8 3 (0.097%) Sparx Enterprise Architect
9 2 (0.065%) Eikon
9 2 (0.065%) Maximo
9 2 (0.065%) Oracle ERP
9 2 (0.065%) SAP IBP
9 2 (0.065%) SAP MDG
Cloud Services
1 1,087 (35.22%) Power Platform
2 955 (30.95%) Azure
3 516 (16.72%) AWS
4 249 (8.07%) Azure Data Factory
5 199 (6.45%) GCP
6 115 (3.73%) SaaS
7 109 (3.53%) PaaS
8 68 (2.20%) Serverless
9 58 (1.88%) IaaS
10 54 (1.75%) Amazon S3
11 42 (1.36%) Dynamics 365
12 37 (1.20%) AWS Lambda
12 37 (1.20%) Azure Stack
12 37 (1.20%) Cloud Computing
13 31 (1.00%) Amazon Kinesis
13 31 (1.00%) Data Lake Analytics
13 31 (1.00%) Google Analytics
14 28 (0.91%) Office 365
15 26 (0.84%) Amazon EMR
16 25 (0.81%) GitHub
Communications & Networking
1 34 (1.10%) Internet
2 9 (0.29%) ZigBee
3 8 (0.26%) Skype
4 7 (0.23%) Intranet
4 7 (0.23%) Wi-Fi
5 5 (0.16%) Radio Access Network
6 4 (0.13%) Broadband
6 4 (0.13%) SMS
7 3 (0.097%) ATM
7 3 (0.097%) Extranet
7 3 (0.097%) Firewall
7 3 (0.097%) FTP
7 3 (0.097%) SAN
8 2 (0.065%) NAS
8 2 (0.065%) TCP/IP
8 2 (0.065%) VoIP
9 1 (0.032%) DMZ
9 1 (0.032%) LAN
9 1 (0.032%) VLAN
9 1 (0.032%) WAN
Database & Business Intelligence
1 1,334 (43.23%) SQL Server
2 1,079 (34.96%) Power BI
3 1,051 (34.06%) SQL Server Integration Services
4 806 (26.12%) SQL Server Reporting Services
5 695 (22.52%) SQL Server Analysis Services
6 494 (16.01%) Big Data
7 442 (14.32%) Data Lake
8 272 (8.81%) Relational Database
9 266 (8.62%) Azure SQL Database
10 256 (8.30%) Snowflake Schema
11 229 (7.42%) Hadoop
12 226 (7.32%) Amazon Redshift
12 226 (7.32%) Azure SQL Data Warehouse
13 219 (7.10%) NoSQL
14 197 (6.38%) Microsoft Analysis Services
15 159 (5.15%) QlikView
16 147 (4.76%) BusinessObjects
17 132 (4.28%) PostgreSQL
18 125 (4.05%) Enterprise Data Warehouse
19 119 (3.86%) OLAP
Development Applications
1 123 (3.99%) JIRA
2 108 (3.50%) Git (software)
3 66 (2.14%) Visual Studio
4 55 (1.78%) SQL Server Management Studio (SSMS)
5 53 (1.72%) Team Foundation Server
6 51 (1.65%) Visual Studio Team System
7 38 (1.23%) ERwin
8 26 (0.84%) Jenkins
9 20 (0.65%) TeamCity
10 12 (0.39%) Eclipse
10 12 (0.39%) PowerDesigner
11 11 (0.36%) Maven
11 11 (0.36%) Octopus Deploy
11 11 (0.36%) SoapUI
12 10 (0.32%) Bitbucket
13 8 (0.26%) JUnit
14 7 (0.23%) ER Studio
14 7 (0.23%) MSBuild
14 7 (0.23%) Oracle Forms
14 7 (0.23%) Subversion
General
1 798 (25.86%) Finance
2 152 (4.93%) Marketing
3 129 (4.18%) Retail
4 93 (3.01%) Banking
5 67 (2.17%) Public Sector
6 51 (1.65%) Legal
7 39 (1.26%) Advertising
7 39 (1.26%) Games
8 37 (1.20%) Law
9 28 (0.91%) Manufacturing
10 24 (0.78%) Publishing
11 23 (0.75%) Back Office
12 22 (0.71%) Financial Institution
12 22 (0.71%) Telecoms
13 18 (0.58%) Automotive
14 16 (0.52%) Investment Banking
15 11 (0.36%) Billing
15 11 (0.36%) Front Office
15 11 (0.36%) Pharmaceutical
16 9 (0.29%) Police
Job Titles
1 1,037 (33.60%) Developer
2 523 (16.95%) Business Intelligence Developer
3 520 (16.85%) Analyst
4 415 (13.45%) Architect
5 380 (12.31%) Data Engineer
6 292 (9.46%) SQL Developer
7 272 (8.81%) Data Architect
8 188 (6.09%) Business Intelligence Analyst
9 178 (5.77%) Data Warehouse Developer
10 144 (4.67%) Senior Developer
11 132 (4.28%) Data Analyst
12 130 (4.21%) DBA
13 124 (4.02%) Consultant
14 118 (3.82%) Business Analyst
15 104 (3.37%) ETL Developer
16 93 (3.01%) Business Developer
16 93 (3.01%) Solutions Architect
16 93 (3.01%) SSIS Developer
17 88 (2.85%) Azure Engineer
18 85 (2.75%) SQL DBA
Libraries, Frameworks & Software Standards
1 199 (6.45%) .NET
2 172 (5.57%) Kafka
3 135 (4.37%) Web Services
4 107 (3.47%) MDX
5 77 (2.50%) XML
6 65 (2.11%) HTML
7 63 (2.04%) JSON
8 57 (1.85%) REST
9 47 (1.52%) AngularJS
9 47 (1.52%) ASP.NET
10 39 (1.26%) HTML5
11 35 (1.13%) CSS
12 34 (1.10%) Middleware
13 33 (1.07%) React
14 31 (1.00%) RESTful
15 26 (0.84%) PySpark
16 23 (0.75%) Elastic Stack
17 22 (0.71%) .NET Framework
18 20 (0.65%) SOAP
19 19 (0.62%) Apache NiFi
Miscellaneous
1 542 (17.56%) Analytical Skills
2 205 (6.64%) Management Information System
3 189 (6.12%) Data Structures
4 118 (3.82%) Greenfield Project
5 74 (2.40%) Self-Motivation
6 61 (1.98%) Reinsurance
7 35 (1.13%) Algorithms
8 31 (1.00%) NHS
8 31 (1.00%) Reference Data
9 27 (0.87%) Tandem
10 26 (0.84%) User Experience
11 24 (0.78%) Clustering
12 21 (0.68%) Enterprise Software
12 21 (0.68%) Public Cloud
13 20 (0.65%) FMCG
14 19 (0.62%) Data Centre
14 19 (0.62%) Foreign Exchange (FX)
14 19 (0.62%) Virtual Team
15 17 (0.55%) Derivative
15 17 (0.55%) Replication
Operating Systems
1 129 (4.18%) Windows
2 109 (3.53%) Unix
3 99 (3.21%) Linux
4 44 (1.43%) Windows Server
5 12 (0.39%) Windows 7
6 10 (0.32%) Windows 2000
6 10 (0.32%) Windows XP
7 9 (0.29%) AIX
8 6 (0.19%) Solaris
9 5 (0.16%) Windows 10
9 5 (0.16%) Windows Server 2008
10 3 (0.097%) Oracle Linux
10 3 (0.097%) Windows Server 2012
11 2 (0.065%) CentOS
11 2 (0.065%) Red Hat Enterprise Linux
11 2 (0.065%) VME
11 2 (0.065%) Windows Server 2003
12 1 (0.032%) Android
12 1 (0.032%) MVS
12 1 (0.032%) VMS
Processes & Methodologies
1 1,931 (62.57%) Business Intelligence
2 1,337 (43.32%) ETL
3 964 (31.24%) Analytics
4 907 (29.39%) Agile Software Development
5 842 (27.28%) Data Modelling
6 475 (15.39%) Visualisation
7 390 (12.64%) Migration
8 342 (11.08%) Problem-Solving
9 328 (10.63%) DevOps
10 325 (10.53%) Data Science
11 323 (10.47%) Data Management
12 309 (10.01%) Data Architecture
13 290 (9.40%) Data Visualisation
14 281 (9.11%) Data Analysis
15 258 (8.36%) Data Analytics
16 255 (8.26%) Data Integration
17 251 (8.13%) Data Engineering
18 243 (7.87%) Kimball Methodology
19 231 (7.49%) Stakeholder Management
20 216 (7.00%) Decision-Making
Programming Languages
1 2,078 (67.34%) SQL
2 702 (22.75%) Python
3 518 (16.79%) T-SQL
4 282 (9.14%) Java
5 264 (8.55%) C#
6 188 (6.09%) R
7 166 (5.38%) Data Analysis Expressions (DAX)
8 147 (4.76%) PL/SQL
9 111 (3.60%) Scala
10 104 (3.37%) PowerShell
11 82 (2.66%) JavaScript
12 71 (2.30%) VBA
13 45 (1.46%) Shell Script
14 44 (1.43%) VB.NET
15 34 (1.10%) Bash Shell
15 34 (1.10%) Java 8
16 33 (1.07%) VB
17 27 (0.87%) U-SQL
18 22 (0.71%) PHP
19 20 (0.65%) C
Qualifications
1 289 (9.36%) Degree
2 118 (3.82%) Computer Science Degree
3 42 (1.36%) Security Cleared
4 32 (1.04%) Microsoft Certification
5 26 (0.84%) Master's Degree
6 19 (0.62%) ISTQB
7 18 (0.58%) AWS Certification
7 18 (0.58%) SC Cleared
8 14 (0.45%) Numerate Degree
9 12 (0.39%) MBA
10 11 (0.36%) PRINCE2 Practitioner
11 9 (0.29%) PhD
11 9 (0.29%) TOGAF Certification
12 8 (0.26%) MCSA
13 6 (0.19%) ISEB
14 5 (0.16%) CFA
14 5 (0.16%) Postgraduate
15 4 (0.13%) DV Cleared
15 4 (0.13%) ITIL Certification
16 3 (0.097%) MCSE
Quality Assurance & Compliance
1 294 (9.53%) Data Quality
2 149 (4.83%) QA
3 52 (1.69%) GDPR
4 25 (0.81%) Solvency II
5 20 (0.65%) SLA
6 13 (0.42%) Sarbanes-Oxley
7 12 (0.39%) Actionable Recommendations
8 8 (0.26%) PMO
9 7 (0.23%) ISO/IEC 27001
10 4 (0.13%) COBIT
11 3 (0.097%) UCITS
12 2 (0.065%) EMIR
12 2 (0.065%) MiFID
13 1 (0.032%) Basel III
13 1 (0.032%) IFRS
13 1 (0.032%) IFRS 9
13 1 (0.032%) ISO 9000
13 1 (0.032%) PCI DSS
System Software
1 81 (2.62%) Docker
2 30 (0.97%) Active Directory
3 29 (0.94%) Apache Flume
4 21 (0.68%) HDFS
5 15 (0.49%) Hyper-V
5 15 (0.49%) VMware Infrastructure
6 12 (0.39%) Virtual Machines
7 9 (0.29%) Microsoft App-V
8 5 (0.16%) Tivoli Workload Scheduler
9 3 (0.097%) Apache ZooKeeper
9 3 (0.097%) Oracle RAC
10 2 (0.065%) Oracle Clusterware
10 2 (0.065%) Varnish
10 2 (0.065%) vSphere
11 1 (0.032%) Cronacle
11 1 (0.032%) Firmware
11 1 (0.032%) Postfix
Systems Management
1 85 (2.75%) Kubernetes
2 30 (0.97%) Oozie
3 27 (0.87%) Opscode Chef
3 27 (0.87%) Terraform
4 24 (0.78%) Puppet
5 22 (0.71%) Ansible
6 19 (0.62%) Control-M
7 11 (0.36%) Hadoop YARN
8 9 (0.29%) SCCM
9 8 (0.26%) Single Sign-On
10 7 (0.23%) SCVMM
11 5 (0.16%) Kibana
11 5 (0.16%) Salt
11 5 (0.16%) Tivoli
12 4 (0.13%) BMC PATROL
13 3 (0.097%) Argo
13 3 (0.097%) BladeLogic
13 3 (0.097%) Data Guard
13 3 (0.097%) Mesos
13 3 (0.097%) Oracle RMAN
Vendors
1 903 (29.26%) Microsoft
2 517 (16.75%) Tableau
3 407 (13.19%) Oracle
4 196 (6.35%) Informatica
5 183 (5.93%) Databricks
6 182 (5.90%) Google
7 141 (4.57%) SAP
8 109 (3.53%) IBM
9 95 (3.08%) Cognos
10 80 (2.59%) Talend
11 57 (1.85%) Teradata
12 54 (1.75%) Salesforce.com
13 45 (1.46%) Cloudera
14 40 (1.30%) Netezza
15 35 (1.13%) MicroStrategy
16 33 (1.07%) Alteryx
17 28 (0.91%) Sybase
18 19 (0.62%) Ab Initio
18 19 (0.62%) Hortonworks
18 19 (0.62%) InterSystems