Period
to 2 June 2020

The following table provides summary statistics for permanent job vacancies advertised in England 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 June 2020 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK > England
6 months to
2 Jun 2020
Same period 2019 Same period 2018
Rank 103 111 121
Rank change year-on-year +8 +10 -10
Permanent jobs citing Data Warehouse 2,414 3,967 4,510
As % of all permanent jobs advertised in England 2.97% 2.99% 2.78%
As % of the Database & Business Intelligence category 11.05% 10.71% 9.05%
Number of salaries quoted 2,101 3,410 3,844
Median annual salary £60,000 £55,000 £52,500
Median salary % change year-on-year +9.09% +4.76% +5.00%
10th Percentile £37,000 £37,500 £33,750
90th Percentile £87,500 £85,000 £82,500
UK median annual salary £60,000 £55,000 £52,500
% change year-on-year +9.09% +4.76% +5.00%

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 advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 21,854 37,040 49,834
As % of all permanent IT jobs advertised in England 26.93% 27.89% 30.73%
Number of salaries quoted 17,883 30,464 40,984
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £32,500 £31,250 £31,250
90th Percentile £90,000 £86,250 £81,250
UK median annual salary £53,931 £52,000 £50,000
% change year-on-year +3.71% +4.00% +5.26%

Data Warehouse
Job Vacancy Trend in England

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

Job vacancy trend for Data Warehouse in England

Data Warehouse
Salary Trend in England

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

Salary trend for Data Warehouse in England

Data Warehouse
Salary Histogram in England

Salary distribution for jobs citing Data Warehouse in England over the 6 months to 2 June 2020.

Salary histogram for Data Warehouse in England

Data Warehouse
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the England region over the 6 months to 2 June 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
London -18 1,301 £67,500 +8.00% 38
South East +23 318 £55,000 - 26
North of England +35 317 £50,000 +11.11% 30
Midlands +15 220 £47,500 +5.56% 38
North West +38 192 £50,000 +11.11% 25
West Midlands +41 150 £50,000 - 36
East of England +73 128 £58,250 +10.95% 21
South West -1 120 £47,500 -9.52% 14
Yorkshire +25 98 £52,500 +10.53% 3
East Midlands -8 68 £39,000 -8.24% 2
North East +12 27 £40,500 -14.74% 2
Data Warehouse
UK

For the 6 months to 2 June 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 across the England region with a requirement for Data Warehouse.

1 1,627 (67.40%) SQL
2 1,482 (61.39%) Business Intelligence
3 1,037 (42.96%) SQL Server
4 982 (40.68%) ETL
5 890 (36.87%) Power Platform
6 881 (36.50%) Power BI
7 807 (33.43%) Azure
8 798 (33.06%) SQL Server Integration Services
9 763 (31.61%) Analytics
10 756 (31.32%) Agile Software Development
11 682 (28.25%) Microsoft
12 663 (27.46%) Finance
13 650 (26.93%) Data Modelling
14 634 (26.26%) Python
15 586 (24.28%) SQL Server Reporting Services
16 524 (21.71%) SQL Server Analysis Services
17 438 (18.14%) AWS
18 426 (17.65%) Analytical Skills
19 425 (17.61%) Data Lake
20 389 (16.11%) Tableau
21 388 (16.07%) Big Data
22 365 (15.12%) Visualisation
23 361 (14.95%) T-SQL
24 320 (13.26%) Oracle
25 293 (12.14%) Migration
26 290 (12.01%) DevOps
27 268 (11.10%) Data Science
28 253 (10.48%) Java
29 252 (10.44%) Problem-Solving
30 248 (10.27%) Data Architecture

Data Warehouse
Co-occurring IT Skills in England 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 183 (7.58%) Apache Spark
2 77 (3.19%) Apache
3 39 (1.62%) SharePoint
4 34 (1.41%) Apache Airflow
5 25 (1.04%) Confluence
6 21 (0.87%) SAS
7 19 (0.79%) Elasticsearch
8 12 (0.50%) IIS
9 11 (0.46%) Luigi
10 10 (0.41%) Apache Pig
11 9 (0.37%) Tomcat
12 8 (0.33%) Jupyter
12 8 (0.33%) MQSeries
12 8 (0.33%) Oracle Workflow
13 7 (0.29%) Oracle SOA Suite
14 6 (0.25%) CMS
15 5 (0.21%) Apache Synapse
15 5 (0.21%) BizTalk Server
16 3 (0.12%) SharePoint 2010
16 3 (0.12%) SharePoint 2013
Applications
1 132 (5.47%) Microsoft Excel
2 45 (1.86%) Microsoft Office
3 16 (0.66%) Microsoft PowerPoint
4 9 (0.37%) SPSS
5 7 (0.29%) MS Visio
6 2 (0.083%) Chatbot
6 2 (0.083%) InfoPath
7 1 (0.041%) Spreadsheet
Business Applications
1 20 (0.83%) Dynamics CRM
2 15 (0.62%) Cognos Business Intelligence
3 12 (0.50%) SAP BPC
4 11 (0.46%) Markit EDM
5 8 (0.33%) Dynamics GP
6 5 (0.21%) Dynamics AX
6 5 (0.21%) NetSuite
7 4 (0.17%) Oracle EBS
7 4 (0.17%) Raiser's Edge
7 4 (0.17%) RiskWrite
8 3 (0.12%) Maximo
8 3 (0.12%) SAP IS-U
8 3 (0.12%) Teamcenter
9 2 (0.083%) Oracle Applications
9 2 (0.083%) Oracle EBS R12
9 2 (0.083%) Oracle General Ledger
9 2 (0.083%) Oracle Internet Expenses
9 2 (0.083%) Oracle iProcurement
9 2 (0.083%) Oracle Procure-to-Pay
9 2 (0.083%) SimCorp Dimension
Cloud Services
1 890 (36.87%) Power Platform
2 807 (33.43%) Azure
3 438 (18.14%) AWS
4 231 (9.57%) Azure Data Factory
5 202 (8.37%) GCP
6 88 (3.65%) Serverless
7 83 (3.44%) SaaS
8 80 (3.31%) PaaS
9 60 (2.49%) AWS Lambda
10 48 (1.99%) Amazon S3
11 40 (1.66%) IaaS
12 39 (1.62%) Azure Stack
13 35 (1.45%) Amazon ECS
14 31 (1.28%) Dynamics 365
15 27 (1.12%) Cloud Computing
16 26 (1.08%) Data Lake Analytics
17 25 (1.04%) Amazon Kinesis
18 24 (0.99%) Azure Machine Learning
19 21 (0.87%) Amazon EMR
20 20 (0.83%) OpenShift
Communications & Networking
1 28 (1.16%) Internet
2 9 (0.37%) ZigBee
3 8 (0.33%) Skype
4 6 (0.25%) Broadband
4 6 (0.25%) Intranet
4 6 (0.25%) WebEx
5 3 (0.12%) Extranet
5 3 (0.12%) Firewall
5 3 (0.12%) SSH
6 2 (0.083%) Network Security
6 2 (0.083%) Software-Defined Networking
6 2 (0.083%) VoIP
7 1 (0.041%) ASN.1
7 1 (0.041%) FTP
7 1 (0.041%) MPLS
7 1 (0.041%) Radio Access Network
7 1 (0.041%) SMS
7 1 (0.041%) TCP/IP
7 1 (0.041%) Wi-Fi
Database & Business Intelligence
1 1,037 (42.96%) SQL Server
2 881 (36.50%) Power BI
3 798 (33.06%) SQL Server Integration Services
4 586 (24.28%) SQL Server Reporting Services
5 524 (21.71%) SQL Server Analysis Services
6 425 (17.61%) Data Lake
7 388 (16.07%) Big Data
8 232 (9.61%) Azure SQL Database
9 208 (8.62%) Snowflake Schema
10 206 (8.53%) Relational Database
11 203 (8.41%) Azure SQL Data Warehouse
12 200 (8.29%) Amazon Redshift
13 194 (8.04%) Hadoop
14 188 (7.79%) NoSQL
15 160 (6.63%) Microsoft Analysis Services
16 126 (5.22%) QlikView
17 122 (5.05%) PostgreSQL
18 113 (4.68%) OLAP
19 111 (4.60%) BusinessObjects
20 105 (4.35%) Enterprise Data Warehouse
Development Applications
1 91 (3.77%) Git (software)
2 90 (3.73%) JIRA
3 51 (2.11%) Visual Studio
4 48 (1.99%) ERwin
5 45 (1.86%) Jenkins
6 40 (1.66%) SQL Server Management Studio (SSMS)
6 40 (1.66%) Visual Studio Team System
7 29 (1.20%) Team Foundation Server
8 21 (0.87%) GitLab
9 19 (0.79%) PowerDesigner
10 18 (0.75%) TeamCity
11 16 (0.66%) Artifactory
12 13 (0.54%) Cucumber
13 12 (0.50%) ER Studio
14 11 (0.46%) Eclipse
15 10 (0.41%) Maven
15 10 (0.41%) Octopus Deploy
16 9 (0.37%) Selenium
17 7 (0.29%) JUnit
17 7 (0.29%) WebDriver
General
1 663 (27.46%) Finance
2 123 (5.10%) Marketing
3 120 (4.97%) Banking
4 91 (3.77%) Retail
5 54 (2.24%) Back Office
6 41 (1.70%) Public Sector
7 39 (1.62%) Advertising
8 27 (1.12%) Games
8 27 (1.12%) Law
9 26 (1.08%) Legal
10 19 (0.79%) Manufacturing
11 18 (0.75%) Investment Banking
12 16 (0.66%) Financial Institution
13 14 (0.58%) Publishing
14 12 (0.50%) Front Office
15 11 (0.46%) Pharmaceutical
16 10 (0.41%) Telecoms
17 9 (0.37%) Automotive
18 5 (0.21%) Local Government
18 5 (0.21%) Police
Job Titles
1 786 (32.56%) Developer
2 406 (16.82%) Analyst
3 390 (16.16%) Business Intelligence Developer
4 352 (14.58%) Data Engineer
5 303 (12.55%) Architect
6 229 (9.49%) SQL Developer
7 209 (8.66%) Data Architect
8 178 (7.37%) Data Warehouse Developer
9 148 (6.13%) Business Intelligence Analyst
10 106 (4.39%) Data Analyst
11 103 (4.27%) SSIS Developer
12 102 (4.23%) Consultant
13 100 (4.14%) Senior Developer
14 91 (3.77%) Business Analyst
15 89 (3.69%) Azure Engineer
16 88 (3.65%) ETL Developer
17 87 (3.60%) SQL BI Developer
18 80 (3.31%) DBA
19 79 (3.27%) Solutions Architect
20 70 (2.90%) Business Developer
Libraries, Frameworks & Software Standards
1 171 (7.08%) .NET
2 149 (6.17%) Kafka
3 129 (5.34%) Web Services
4 80 (3.31%) MDX
5 64 (2.65%) XML
6 52 (2.15%) JSON
7 48 (1.99%) REST
8 47 (1.95%) HTML
9 39 (1.62%) ASP.NET
10 37 (1.53%) AngularJS
11 33 (1.37%) Middleware
11 33 (1.37%) PySpark
12 32 (1.33%) gRPC
13 31 (1.28%) CSS
14 27 (1.12%) HTML5
15 25 (1.04%) React
16 22 (0.91%) RESTful
17 21 (0.87%) OAuth
18 18 (0.75%) Apache NiFi
19 16 (0.66%) Swagger
Miscellaneous
1 426 (17.65%) Analytical Skills
2 163 (6.75%) Management Information System
3 159 (6.59%) Data Structures
4 121 (5.01%) Greenfield Project
5 44 (1.82%) Reinsurance
6 40 (1.66%) Self-Motivation
7 37 (1.53%) Hedge funds
8 30 (1.24%) Algorithms
8 30 (1.24%) Clustering
8 30 (1.24%) Reference Data
9 27 (1.12%) User Experience
10 24 (0.99%) FMCG
10 24 (0.99%) Foreign Exchange (FX)
11 23 (0.95%) Derivative
12 22 (0.91%) Enterprise Software
13 20 (0.83%) Tandem
14 16 (0.66%) NHS
15 14 (0.58%) Online Games
15 14 (0.58%) SWIFT
16 13 (0.54%) Mobile App
Operating Systems
1 95 (3.94%) Windows
2 72 (2.98%) Unix
3 64 (2.65%) Linux
4 28 (1.16%) Windows Server
5 11 (0.46%) Windows 7
6 10 (0.41%) Windows 2000
6 10 (0.41%) Windows XP
7 7 (0.29%) AIX
8 2 (0.083%) Android
8 2 (0.083%) Apple iOS
8 2 (0.083%) Red Hat Enterprise Linux
8 2 (0.083%) Windows 10
9 1 (0.041%) CentOS
9 1 (0.041%) MVS
9 1 (0.041%) Solaris
9 1 (0.041%) Windows Server 2008
9 1 (0.041%) Windows Server 2012
Processes & Methodologies
1 1,482 (61.39%) Business Intelligence
2 982 (40.68%) ETL
3 763 (31.61%) Analytics
4 756 (31.32%) Agile Software Development
5 650 (26.93%) Data Modelling
6 365 (15.12%) Visualisation
7 293 (12.14%) Migration
8 290 (12.01%) DevOps
9 268 (11.10%) Data Science
10 252 (10.44%) Problem-Solving
11 248 (10.27%) Data Architecture
12 236 (9.78%) Data Management
13 230 (9.53%) Data Analytics
14 221 (9.15%) Data Visualisation
15 220 (9.11%) Data Engineering
16 208 (8.62%) Data Analysis
17 204 (8.45%) Stakeholder Management
18 179 (7.42%) Kimball Methodology
19 173 (7.17%) Data Integration
20 162 (6.71%) Machine Learning
Programming Languages
1 1,627 (67.40%) SQL
2 634 (26.26%) Python
3 361 (14.95%) T-SQL
4 253 (10.48%) Java
5 223 (9.24%) C#
6 155 (6.42%) R
7 129 (5.34%) Data Analysis Expressions (DAX)
8 104 (4.31%) Scala
9 100 (4.14%) PL/SQL
10 82 (3.40%) PowerShell
11 70 (2.90%) JavaScript
12 62 (2.57%) VBA
13 51 (2.11%) VB.NET
14 35 (1.45%) Shell Script
15 30 (1.24%) C
16 27 (1.12%) Java 8
17 25 (1.04%) VB
18 24 (0.99%) U-SQL
19 22 (0.91%) C++
20 16 (0.66%) Ruby
Qualifications
1 241 (9.98%) Degree
2 103 (4.27%) Computer Science Degree
3 31 (1.28%) Master's Degree
4 26 (1.08%) Microsoft Certification
5 22 (0.91%) AWS Certification
6 21 (0.87%) Security Cleared
7 17 (0.70%) Sun Certification
8 13 (0.54%) ISTQB
8 13 (0.54%) SC Cleared
9 11 (0.46%) PhD
10 8 (0.33%) ISEB
10 8 (0.33%) Numerate Degree
10 8 (0.33%) PRINCE2 Practitioner
10 8 (0.33%) TOGAF Certification
11 6 (0.25%) MBA
12 5 (0.21%) CFA
13 4 (0.17%) A+ Certification
14 3 (0.12%) MCPD
14 3 (0.12%) MCSA
15 2 (0.083%) DV Cleared
Quality Assurance & Compliance
1 174 (7.21%) Data Quality
2 129 (5.34%) QA
3 46 (1.91%) GDPR
4 17 (0.70%) Sarbanes-Oxley
5 15 (0.62%) Actionable Recommendations
6 14 (0.58%) SLA
7 11 (0.46%) Solvency II
8 10 (0.41%) PMO
9 5 (0.21%) COBIT
9 5 (0.21%) UCITS
10 3 (0.12%) ISO/IEC 27001
11 2 (0.083%) EMIR
11 2 (0.083%) MiFID
12 1 (0.041%) IFRS
12 1 (0.041%) PCI DSS
System Software
1 92 (3.81%) Docker
2 25 (1.04%) Active Directory
3 24 (0.99%) Apache Flume
4 15 (0.62%) HDFS
4 15 (0.62%) Virtual Machines
5 12 (0.50%) Hyper-V
6 9 (0.37%) Microsoft App-V
7 5 (0.21%) Tivoli Workload Scheduler
7 5 (0.21%) VMware Infrastructure
8 2 (0.083%) Apache ZooKeeper
8 2 (0.083%) vSphere
9 1 (0.041%) Oracle RAC
9 1 (0.041%) Postfix
9 1 (0.041%) Varnish
Systems Management
1 106 (4.39%) Kubernetes
2 22 (0.91%) Oozie
3 21 (0.87%) Terraform
4 18 (0.75%) Control-M
4 18 (0.75%) Opscode Chef
5 17 (0.70%) Puppet
6 16 (0.66%) Ansible
7 11 (0.46%) SCVMM
8 9 (0.37%) Hadoop YARN
8 9 (0.37%) SCCM
9 7 (0.29%) Single Sign-On
10 6 (0.25%) Kibana
11 5 (0.21%) HP Quality Center
11 5 (0.21%) Salt
11 5 (0.21%) Tivoli
12 3 (0.12%) Argo
13 2 (0.083%) Oracle Enterprise Manager
14 1 (0.041%) Data Guard
14 1 (0.041%) Microsoft Clustering
14 1 (0.041%) Oracle RMAN
Vendors
1 682 (28.25%) Microsoft
2 389 (16.11%) Tableau
3 320 (13.26%) Oracle
4 176 (7.29%) Google
5 171 (7.08%) Databricks
6 144 (5.97%) Informatica
7 106 (4.39%) SAP
8 68 (2.82%) IBM
9 65 (2.69%) Talend
10 55 (2.28%) Cognos
11 50 (2.07%) Teradata
12 42 (1.74%) Salesforce.com
13 34 (1.41%) Cloudera
14 29 (1.20%) Netezza
15 27 (1.12%) Alteryx
16 21 (0.87%) Hortonworks
17 20 (0.83%) MicroStrategy
18 19 (0.79%) Guidewire
18 19 (0.79%) InterSystems
18 19 (0.79%) Sybase