Period
to 15 October 2019

The following table provides summary statistics for permanent job vacancies advertised in the UK excluding London 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 15 October 2019 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK > UK excluding London
6 months to
15 Oct 2019
Same period 2018 Same period 2017
Rank 140 135 141
Rank change year-on-year -5 +6 +2
Permanent jobs citing Data Warehouse 1,868 2,242 2,352
As % of all permanent IT jobs advertised in the UK excluding London 2.37% 2.43% 2.45%
As % of the Database & Business Intelligence category 9.09% 8.44% 7.83%
Number of salaries quoted 1,561 1,850 2,022
UK excluding London median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% -5.26%
10th Percentile £33,000 £32,500 £31,250
90th Percentile £70,102 £73,750 £67,500
UK median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% -7.41%

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 the UK excluding London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK excluding London
Permanent vacancies with a requirement for database or business intelligence skills 20,548 26,552 30,041
As % of all permanent IT jobs advertised in the UK excluding London 26.08% 28.74% 31.27%
Number of salaries quoted 16,814 22,114 25,272
UK excluding London median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% +2.41%
10th Percentile £29,000 £28,000 £27,500
90th Percentile £67,500 £67,500 £63,750
UK median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% -

Data Warehouse
Job Vacancy Trend in the UK excluding London

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in the UK excluding London.

Job vacancy trend for Data Warehouse in the UK excluding London

Data Warehouse
Salary Trend in the UK excluding London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Warehouse in the UK excluding London.

Salary trend for Data Warehouse in the UK excluding London

Data Warehouse
Salary Histogram in the UK excluding London

The salary distribution of IT jobs citing Data Warehouse in the UK excluding London over the 6 months to 15 October 2019.

Salary histogram for Data Warehouse in the UK excluding London

Data Warehouse
Job Locations in the UK excluding London

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 excluding London region over the 6 months to 15 October 2019. 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
North of England +1 552 £45,412 +0.92% 146
South East -31 435 £50,000 -4.76% 71
North West +25 325 £47,500 +5.56% 75
Midlands +15 297 £45,000 +3.45% 59
South West +19 232 £51,000 +13.33% 31
West Midlands +53 197 £48,750 +8.33% 38
Yorkshire -31 180 £45,000 -5.26% 54
East of England -10 153 £48,750 -2.50% 45
Scotland +4 141 £45,500 -9.00% 20
East Midlands -24 100 £44,750 +2.87% 19
Wales -4 50 £41,000 -3.53% 10
North East +12 48 £45,412 -11.39% 17
Northern Ireland -4 7 £43,750 - 1
Channel Islands +7 2 £56,250 +25.00% 1
Data Warehouse
UK

For the 6 months to 15 October 2019, 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 UK excluding London region with a requirement for Data Warehouse.

1 1,231 (65.90%) SQL
2 1,164 (62.31%) Business Intelligence
3 877 (46.95%) ETL
4 849 (45.45%) SQL Server
5 678 (36.30%) SQL Server Integration Services
6 620 (33.19%) Agile Software Development
7 600 (32.12%) Power Platform
8 597 (31.96%) Power BI
9 586 (31.37%) Analytics
10 580 (31.05%) Microsoft
11 550 (29.44%) SQL Server Reporting Services
12 480 (25.70%) Azure
13 479 (25.64%) Data Modelling
14 408 (21.84%) T-SQL
15 387 (20.72%) SQL Server Analysis Services
16 367 (19.65%) Finance
17 348 (18.63%) Analytical Skills
18 306 (16.38%) Tableau
19 305 (16.33%) Visualisation
20 281 (15.04%) Python
21 278 (14.88%) Big Data
22 269 (14.40%) Oracle
23 255 (13.65%) AWS
24 242 (12.96%) Data Lake
25 199 (10.65%) Hadoop
26 190 (10.17%) Data Integration
27 186 (9.96%) Relational Database
28 180 (9.64%) Data Architecture
29 177 (9.48%) Scrum
30 176 (9.42%) Problem-Solving

Data Warehouse
Co-occurring IT Skills in the UK excluding London 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 131 (7.01%) Apache Spark
2 66 (3.53%) SAS
3 58 (3.10%) SharePoint
4 30 (1.61%) Apache
5 14 (0.75%) Confluence
6 10 (0.54%) WordPress
7 8 (0.43%) CMS
8 7 (0.37%) BizTalk Server
9 6 (0.32%) IIS
9 6 (0.32%) Oracle SOA Suite
10 5 (0.27%) Apache Pig
10 5 (0.27%) Tomcat
11 4 (0.21%) PowerExchange
11 4 (0.21%) Sitecore CMS
12 3 (0.16%) Apache Airflow
13 2 (0.11%) Elasticsearch
13 2 (0.11%) IBM Domino
13 2 (0.11%) nginx
13 2 (0.11%) Oracle Workflow
13 2 (0.11%) SugarCRM
Applications
1 114 (6.10%) Microsoft Excel
2 51 (2.73%) Microsoft Office
3 29 (1.55%) Spreadsheet
4 14 (0.75%) MS Visio
5 13 (0.70%) Microsoft PowerPoint
6 9 (0.48%) SPSS
7 4 (0.21%) InfoPath
8 1 (0.054%) Microsoft Project
Business Applications
1 21 (1.12%) Dynamics CRM
2 19 (1.02%) SAP ERP
3 14 (0.75%) Dynamics NAV
4 11 (0.59%) Cognos Business Intelligence
5 9 (0.48%) JDE OneWorld
5 9 (0.48%) SAP Hybris
5 9 (0.48%) SAP Oil and Gas
6 6 (0.32%) OPENHousing
7 4 (0.21%) Dynamics AX
7 4 (0.21%) NetSuite
7 4 (0.21%) Oracle Receivables
8 3 (0.16%) Dynamics GP
9 2 (0.11%) HFM
9 2 (0.11%) Oracle 11i
9 2 (0.11%) Oracle EBS R12
9 2 (0.11%) Oracle ERP
9 2 (0.11%) Remedy ITSM
9 2 (0.11%) SAP CRM
9 2 (0.11%) SAP HR
9 2 (0.11%) SAP Payroll
Cloud Services
1 600 (32.12%) Power Platform
2 480 (25.70%) Azure
3 255 (13.65%) AWS
4 119 (6.37%) GCP
5 101 (5.41%) Azure Data Factory
6 42 (2.25%) SaaS
7 39 (2.09%) Office 365
8 36 (1.93%) PaaS
9 27 (1.45%) Cloud Computing
10 25 (1.34%) Serverless
11 24 (1.28%) PowerApps
12 22 (1.18%) IaaS
13 19 (1.02%) Amazon S3
14 14 (0.75%) Amazon EMR
14 14 (0.75%) Dynamics 365
15 10 (0.54%) npm
16 9 (0.48%) Boomi
17 7 (0.37%) Amazon EC2
17 7 (0.37%) AWS Lambda
18 6 (0.32%) Google Analytics
Communications & Networking
1 22 (1.18%) Internet
2 10 (0.54%) Broadband
3 9 (0.48%) Intranet
4 7 (0.37%) FTP
4 7 (0.37%) SAN
5 5 (0.27%) HTTP
5 5 (0.27%) Wi-Fi
6 4 (0.21%) Fibre Channel
6 4 (0.21%) SMS
7 3 (0.16%) ATM
8 2 (0.11%) DHCP
8 2 (0.11%) DNS
8 2 (0.11%) HTTPS
8 2 (0.11%) MVNO
8 2 (0.11%) SSL
9 1 (0.054%) NAS
9 1 (0.054%) Wireless
Database & Business Intelligence
1 849 (45.45%) SQL Server
2 678 (36.30%) SQL Server Integration Services
3 597 (31.96%) Power BI
4 550 (29.44%) SQL Server Reporting Services
5 387 (20.72%) SQL Server Analysis Services
6 278 (14.88%) Big Data
7 242 (12.96%) Data Lake
8 199 (10.65%) Hadoop
9 186 (9.96%) Relational Database
10 146 (7.82%) QlikView
11 141 (7.55%) Azure SQL Data Warehouse
12 118 (6.32%) BusinessObjects
13 115 (6.16%) NoSQL
14 88 (4.71%) Azure SQL Database
15 87 (4.66%) Amazon Redshift
16 77 (4.12%) BigQuery
17 74 (3.96%) SQL Server 2016
18 72 (3.85%) Apache Hive
19 71 (3.80%) SQL Server 2012
20 70 (3.75%) Oracle Database
Development Applications
1 81 (4.34%) Git (software)
2 60 (3.21%) JIRA
3 49 (2.62%) Team Foundation Server
4 37 (1.98%) Jenkins
4 37 (1.98%) Visual Studio
5 28 (1.50%) IBM UrbanCode
5 28 (1.50%) SQL Server Management Studio (SSMS)
6 24 (1.28%) Cucumber
7 18 (0.96%) ERwin
7 18 (0.96%) Maven
8 16 (0.86%) Selenium
9 13 (0.70%) Bitbucket
10 11 (0.59%) Artifactory
10 11 (0.59%) git-flow
11 10 (0.54%) Octopus Deploy
11 10 (0.54%) Sinon.JS
11 10 (0.54%) Subversion
11 10 (0.54%) TeamCity
11 10 (0.54%) webpack
12 7 (0.37%) Oracle Forms
General
1 367 (19.65%) Finance
2 156 (8.35%) Retail
3 98 (5.25%) Marketing
4 88 (4.71%) Banking
5 80 (4.28%) Public Sector
6 65 (3.48%) Manufacturing
7 63 (3.37%) Telecoms
8 33 (1.77%) Electronics
9 26 (1.39%) Billing
10 23 (1.23%) Legal
11 13 (0.70%) Social Housing
12 9 (0.48%) Pharmaceutical
13 8 (0.43%) Aerospace
13 8 (0.43%) Games
13 8 (0.43%) Local Government
14 7 (0.37%) Advertising
14 7 (0.37%) Automotive
15 6 (0.32%) Retail Banking
16 5 (0.27%) Law
17 3 (0.16%) Investment Banking
Job Titles
1 727 (38.92%) Developer
2 446 (23.88%) Business Intelligence Developer
3 241 (12.90%) Analyst
4 188 (10.06%) Data Engineer
5 187 (10.01%) Architect
6 184 (9.85%) SQL Developer
7 120 (6.42%) Data Architect
8 115 (6.16%) Business Developer
9 95 (5.09%) Business Intelligence Analyst
10 90 (4.82%) SQL BI Developer
11 81 (4.34%) DBA
12 77 (4.12%) Senior Developer
13 59 (3.16%) Business Intelligence Manager
13 59 (3.16%) Senior Business Intelligence Developer
14 58 (3.10%) ETL Developer
15 57 (3.05%) Data Warehouse Developer
16 52 (2.78%) Administrator
16 52 (2.78%) Consultant
17 50 (2.68%) Data Analyst
18 48 (2.57%) SSIS Developer
Libraries, Frameworks & Software Standards
1 120 (6.42%) .NET
2 80 (4.28%) Web Services
3 55 (2.94%) ASP.NET
4 52 (2.78%) MDX
5 41 (2.19%) Kafka
6 38 (2.03%) WCF
7 37 (1.98%) XML
8 36 (1.93%) HTML
9 29 (1.55%) .NET Framework
10 28 (1.50%) JSON
10 28 (1.50%) WPF
11 27 (1.45%) Apache Flex
12 25 (1.34%) CSS
13 23 (1.23%) HTML5
14 18 (0.96%) React
14 18 (0.96%) REST
15 17 (0.91%) SOAP
16 16 (0.86%) AngularJS
17 14 (0.75%) CSS3
17 14 (0.75%) Entity Framework
Miscellaneous
1 348 (18.63%) Analytical Skills
2 114 (6.10%) Management Information System
3 46 (2.46%) Data Structures
4 40 (2.14%) Self-Motivation
5 36 (1.93%) NHS
6 34 (1.82%) Replication
7 29 (1.55%) Greenfield Project
8 21 (1.12%) User Experience
9 20 (1.07%) Data Centre
10 16 (0.86%) Algorithms
11 14 (0.75%) Enterprise Software
11 14 (0.75%) Life Science
11 14 (0.75%) Mainframe
11 14 (0.75%) Virtual Team
12 11 (0.59%) Clustering
13 10 (0.54%) Social Media
14 8 (0.43%) FMCG
14 8 (0.43%) Mobile App
14 8 (0.43%) Reference Data
15 6 (0.32%) Podcast
Operating Systems
1 92 (4.93%) Linux
2 76 (4.07%) Unix
3 48 (2.57%) Windows
4 14 (0.75%) Windows Server
5 7 (0.37%) Red Hat Enterprise Linux
5 7 (0.37%) Solaris
6 6 (0.32%) Oracle Linux
7 5 (0.27%) Windows Server 2012
8 4 (0.21%) VME
8 4 (0.21%) Windows Server 2008
9 3 (0.16%) AIX
9 3 (0.16%) Android
9 3 (0.16%) Apple iOS
10 2 (0.11%) Windows 10
10 2 (0.11%) Windows 8
10 2 (0.11%) Windows XP
11 1 (0.054%) VMS
11 1 (0.054%) Windows 7
11 1 (0.054%) Windows Server 2003
11 1 (0.054%) zOS
Processes & Methodologies
1 1,164 (62.31%) Business Intelligence
2 877 (46.95%) ETL
3 620 (33.19%) Agile Software Development
4 586 (31.37%) Analytics
5 479 (25.64%) Data Modelling
6 305 (16.33%) Visualisation
7 190 (10.17%) Data Integration
8 180 (9.64%) Data Architecture
9 177 (9.48%) Scrum
10 176 (9.42%) Problem-Solving
11 174 (9.31%) Mentoring
12 165 (8.83%) Data Visualisation
13 156 (8.35%) Data Analysis
13 156 (8.35%) Data Management
14 137 (7.33%) Data Science
15 133 (7.12%) Data Engineering
16 132 (7.07%) SDLC
17 130 (6.96%) Stakeholder Management
18 129 (6.91%) DevOps
19 128 (6.85%) Kimball Methodology
Programming Languages
1 1,231 (65.90%) SQL
2 408 (21.84%) T-SQL
3 281 (15.04%) Python
4 135 (7.23%) C#
5 115 (6.16%) Data Analysis Expressions (DAX)
6 113 (6.05%) R
7 92 (4.93%) Java
8 81 (4.34%) PL/SQL
9 75 (4.01%) JavaScript
9 75 (4.01%) VBA
10 61 (3.27%) Scala
11 38 (2.03%) PowerShell
12 34 (1.82%) Bash Shell
13 22 (1.18%) VB.NET
14 20 (1.07%) PHP
15 19 (1.02%) Shell Script
16 18 (0.96%) Perl
17 14 (0.75%) HiveQL
18 13 (0.70%) C
18 13 (0.70%) VB
Qualifications
1 133 (7.12%) Degree
2 23 (1.23%) ISTQB
3 19 (1.02%) Microsoft Certification
3 19 (1.02%) Security Cleared
4 12 (0.64%) Computer Science Degree
5 10 (0.54%) ISEB
6 9 (0.48%) ISTQB Foundation Certification
6 9 (0.48%) Master's Degree
6 9 (0.48%) SC Cleared
7 7 (0.37%) MCSA
8 6 (0.32%) AWS Certification
8 6 (0.32%) PMI Certification
8 6 (0.32%) TOGAF Certification
9 5 (0.27%) ITIL Certification
10 4 (0.21%) CTC Cleared
10 4 (0.21%) DBS Check
11 3 (0.16%) ITIL Foundation Certificate
11 3 (0.16%) MCSE
11 3 (0.16%) Numerate Degree
12 2 (0.11%) PMP
Quality Assurance & Compliance
1 151 (8.08%) Data Quality
2 79 (4.23%) QA
3 39 (2.09%) SLA
4 37 (1.98%) GDPR
5 19 (1.02%) PMO
6 11 (0.59%) ISO/IEC 27001
7 2 (0.11%) COBIT
7 2 (0.11%) ISO 22301
7 2 (0.11%) Solvency II
8 1 (0.054%) GMP
8 1 (0.054%) ISO 9001
8 1 (0.054%) JSP 440
8 1 (0.054%) NCSC
8 1 (0.054%) PCI DSS
8 1 (0.054%) Sarbanes-Oxley
System Software
1 40 (2.14%) Docker
2 30 (1.61%) Tivoli Workload Scheduler
3 21 (1.12%) Active Directory
4 14 (0.75%) VMware Infrastructure
5 11 (0.59%) HDFS
6 10 (0.54%) Apache Flume
7 5 (0.27%) Hyper-V
7 5 (0.27%) Oracle RAC
8 4 (0.21%) Citrix Hypervisor
8 4 (0.21%) NFS
8 4 (0.21%) Veritas Volume Manager
8 4 (0.21%) XenDesktop
9 3 (0.16%) Apache ZooKeeper
10 2 (0.11%) Firmware
10 2 (0.11%) Virtual Machines
11 1 (0.054%) Oracle Clusterware
Systems Management
1 30 (1.61%) Tivoli
2 17 (0.91%) Terraform
3 16 (0.86%) Kubernetes
4 15 (0.80%) Foglight
4 15 (0.80%) LiteSpeed
5 13 (0.70%) AirWatch
5 13 (0.70%) Netcool
6 12 (0.64%) Ansible
7 10 (0.54%) SCOM
8 9 (0.48%) Hadoop YARN
9 7 (0.37%) BMC PATROL
9 7 (0.37%) HP ALM
9 7 (0.37%) Oozie
9 7 (0.37%) Oracle RMAN
10 6 (0.32%) Oracle Enterprise Manager
11 5 (0.27%) Opscode Chef
11 5 (0.27%) Puppet
12 4 (0.21%) Oracle ZFS
12 4 (0.21%) SCCM
12 4 (0.21%) Simpana
Vendors
1 580 (31.05%) Microsoft
2 306 (16.38%) Tableau
3 269 (14.40%) Oracle
4 170 (9.10%) Informatica
5 130 (6.96%) SAP
6 104 (5.57%) IBM
7 103 (5.51%) Cognos
8 99 (5.30%) Teradata
9 85 (4.55%) Google
10 55 (2.94%) Databricks
11 51 (2.73%) Talend
12 40 (2.14%) Netezza
13 38 (2.03%) Cloudera
14 28 (1.50%) Ab Initio
15 21 (1.12%) Salesforce.com
16 20 (1.07%) Alteryx
17 19 (1.02%) Remedy
18 15 (0.80%) VMware
19 13 (0.70%) JD Edwards
20 12 (0.64%) Vertica