Period
to 20 January 2020

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

Data Warehousing
UK > UK excluding London
6 months to
20 Jan 2020
Same period 2019 Same period 2018
Rank 136 146 147
Rank change year-on-year +10 +1 -6
Permanent jobs citing Data Warehouse 1,656 1,920 2,374
As % of all permanent IT jobs advertised in the UK excluding London 2.34% 2.30% 2.40%
As % of the Database & Business Intelligence category 9.01% 8.15% 7.72%
Number of salaries quoted 1,357 1,631 2,006
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 £77,500 £75,000 £66,250
UK median annual salary £57,500 £55,000 £50,000
% change year-on-year +4.55% +10.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 18,389 23,570 30,750
As % of all permanent IT jobs advertised in the UK excluding London 25.98% 28.18% 31.07%
Number of salaries quoted 15,125 19,330 25,859
UK excluding London median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -
10th Percentile £29,750 £28,750 £27,500
90th Percentile £68,750 £70,000 £62,500
UK median annual salary £52,500 £52,500 £48,000
% change year-on-year - +9.38% +1.05%

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 20 January 2020.

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 20 January 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
North of England +46 514 £47,500 +5.56% 99
South East -39 343 £50,000 -1.48% 72
North West +71 334 £47,500 +5.56% 62
Midlands +31 282 £45,000 - 47
West Midlands +67 228 £45,000 -5.26% 26
East of England +43 172 £52,500 +16.67% 37
South West -18 168 £45,000 -14.29% 46
Yorkshire -11 131 £47,500 - 26
Scotland -21 94 £43,250 -13.50% 16
Wales +13 70 £42,500 - 17
East Midlands -57 54 £45,000 +5.88% 21
North East +14 50 £40,177 -33.04% 11
Northern Ireland +13 12 £45,000 - 1
Isle of Man - 1 £37,500 -
Channel Islands - 1 £60,000 -
Data Warehouse
UK

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

1 1,086 (65.58%) Business Intelligence
2 1,081 (65.28%) SQL
3 754 (45.53%) ETL
4 720 (43.48%) SQL Server
5 583 (35.21%) SQL Server Integration Services
6 575 (34.72%) Power BI
6 575 (34.72%) Power Platform
7 535 (32.31%) Microsoft
8 522 (31.52%) SQL Server Reporting Services
9 461 (27.84%) Analytics
10 453 (27.36%) Data Modelling
11 442 (26.69%) Agile Software Development
12 432 (26.09%) Azure
13 360 (21.74%) Finance
14 354 (21.38%) SQL Server Analysis Services
15 328 (19.81%) T-SQL
16 309 (18.66%) Analytical Skills
17 246 (14.86%) Tableau
18 240 (14.49%) Visualisation
19 230 (13.89%) AWS
20 213 (12.86%) Big Data
21 212 (12.80%) Python
22 200 (12.08%) Problem-Solving
23 191 (11.53%) Oracle
24 171 (10.33%) Data Integration
25 157 (9.48%) Migration
26 151 (9.12%) Data Analysis
26 151 (9.12%) Relational Database
27 150 (9.06%) Data Quality
27 150 (9.06%) Data Management

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 76 (4.59%) Apache Spark
2 59 (3.56%) SAS
3 49 (2.96%) SharePoint
4 23 (1.39%) Confluence
5 21 (1.27%) Apache
6 16 (0.97%) IIS
7 13 (0.79%) Tomcat
8 9 (0.54%) BizTalk Server
9 7 (0.42%) PowerExchange
10 6 (0.36%) CMS
11 3 (0.18%) Apache Pig
11 3 (0.18%) Elasticsearch
11 3 (0.18%) MS Exchange
11 3 (0.18%) Oracle SOA Suite
12 2 (0.12%) Alfresco
12 2 (0.12%) Jupyter
12 2 (0.12%) nginx
12 2 (0.12%) OpenEdge
12 2 (0.12%) Sitecore CMS
12 2 (0.12%) WebSphere Application Server
Applications
1 117 (7.07%) Microsoft Excel
2 31 (1.87%) Microsoft Office
3 13 (0.79%) Spreadsheet
4 12 (0.72%) Microsoft PowerPoint
4 12 (0.72%) MS Visio
5 4 (0.24%) SPSS
6 1 (0.060%) Microsoft Project
Business Applications
1 18 (1.09%) Dynamics CRM
2 16 (0.97%) Dynamics GP
3 7 (0.42%) Cognos Business Intelligence
4 6 (0.36%) OPENHousing
5 5 (0.30%) Dynamics AX
6 4 (0.24%) Oracle Receivables
6 4 (0.24%) SAP ERP
7 2 (0.12%) Epicor Tropos
7 2 (0.12%) NetSuite
7 2 (0.12%) Oracle Financials
7 2 (0.12%) Remedy ITSM
8 1 (0.060%) Adobe Campaign
8 1 (0.060%) Elite 3E
8 1 (0.060%) Oracle Applications
8 1 (0.060%) Oracle EBS
8 1 (0.060%) Raiser's Edge
8 1 (0.060%) Salesforce.com CRM
8 1 (0.060%) SAP CAR
8 1 (0.060%) SAP Payroll
Cloud Services
1 575 (34.72%) Power Platform
2 432 (26.09%) Azure
3 230 (13.89%) AWS
4 98 (5.92%) GCP
5 71 (4.29%) Azure Data Factory
6 47 (2.84%) SaaS
7 34 (2.05%) Office 365
8 33 (1.99%) Cloud Computing
9 32 (1.93%) PaaS
10 25 (1.51%) IaaS
11 21 (1.27%) Dynamics 365
12 18 (1.09%) OpenShift
13 14 (0.85%) Serverless
14 12 (0.72%) Amazon Kinesis
15 11 (0.66%) PowerApps
16 10 (0.60%) Google Analytics
17 9 (0.54%) AWS CloudFormation
17 9 (0.54%) AWS Lambda
18 6 (0.36%) Amazon S3
19 4 (0.24%) Amazon EMR
Communications & Networking
1 27 (1.63%) Internet
2 9 (0.54%) ZigBee
3 8 (0.48%) SAN
4 7 (0.42%) Wi-Fi
5 6 (0.36%) Intranet
6 5 (0.30%) ATM
6 5 (0.30%) SMS
7 4 (0.24%) Fibre Channel
8 3 (0.18%) HTTP
9 2 (0.12%) Broadband
9 2 (0.12%) NAS
9 2 (0.12%) SSL
10 1 (0.060%) ASN.1
10 1 (0.060%) CHAP
10 1 (0.060%) FTP
10 1 (0.060%) Radio Access Network
10 1 (0.060%) Skype
10 1 (0.060%) TCP/IP
Database & Business Intelligence
1 720 (43.48%) SQL Server
2 583 (35.21%) SQL Server Integration Services
3 575 (34.72%) Power BI
4 522 (31.52%) SQL Server Reporting Services
5 354 (21.38%) SQL Server Analysis Services
6 213 (12.86%) Big Data
7 151 (9.12%) Relational Database
8 148 (8.94%) Data Lake
9 126 (7.61%) Hadoop
10 120 (7.25%) QlikView
11 107 (6.46%) Azure SQL Data Warehouse
12 106 (6.40%) BusinessObjects
13 88 (5.31%) Snowflake Schema
14 85 (5.13%) NoSQL
15 82 (4.95%) Enterprise Data Warehouse
16 77 (4.65%) PostgreSQL
17 74 (4.47%) Amazon Redshift
18 69 (4.17%) OLTP
19 66 (3.99%) Azure SQL Database
19 66 (3.99%) OLAP
Development Applications
1 73 (4.41%) JIRA
2 57 (3.44%) Git (software)
3 31 (1.87%) Team Foundation Server
4 29 (1.75%) SQL Server Management Studio (SSMS)
5 28 (1.69%) Visual Studio
6 25 (1.51%) ERwin
7 18 (1.09%) IBM UrbanCode
8 13 (0.79%) SoapUI
9 11 (0.66%) Postman
9 11 (0.66%) Visual Studio Team System
10 9 (0.54%) Selenium
11 7 (0.42%) Jenkins
11 7 (0.42%) JMeter
12 6 (0.36%) Bitbucket
12 6 (0.36%) Cucumber
12 6 (0.36%) MSBuild
12 6 (0.36%) Oracle Forms
13 4 (0.24%) JUnit
13 4 (0.24%) Zephyr
14 3 (0.18%) Maven
General
1 360 (21.74%) Finance
2 80 (4.83%) Retail
3 78 (4.71%) Marketing
4 69 (4.17%) Public Sector
5 53 (3.20%) Banking
6 33 (1.99%) Manufacturing
7 30 (1.81%) Legal
8 23 (1.39%) Telecoms
9 18 (1.09%) Billing
10 17 (1.03%) Automotive
11 13 (0.79%) Back Office
11 13 (0.79%) Electronics
12 11 (0.66%) Law
13 9 (0.54%) Advertising
13 9 (0.54%) Games
14 8 (0.48%) Aerospace
15 6 (0.36%) Pharmaceutical
15 6 (0.36%) Social Housing
16 4 (0.24%) Police
17 3 (0.18%) Publishing
Job Titles
1 582 (35.14%) Developer
2 379 (22.89%) Business Intelligence Developer
3 283 (17.09%) Analyst
4 206 (12.44%) Architect
5 127 (7.67%) Data Architect
6 126 (7.61%) SQL Developer
7 125 (7.55%) Data Engineer
8 104 (6.28%) Business Intelligence Analyst
9 96 (5.80%) Business Developer
10 78 (4.71%) DBA
11 66 (3.99%) Senior Developer
12 59 (3.56%) Administrator
13 55 (3.32%) Solutions Architect
14 53 (3.20%) Senior Business Intelligence Developer
15 52 (3.14%) Consultant
16 49 (2.96%) ETL Developer
17 48 (2.90%) Business Analyst
18 47 (2.84%) Data Analyst
19 46 (2.78%) Business Intelligence Lead
19 46 (2.78%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 84 (5.07%) .NET
2 78 (4.71%) Web Services
3 49 (2.96%) MDX
4 47 (2.84%) Kafka
5 40 (2.42%) ASP.NET
6 32 (1.93%) HTML
6 32 (1.93%) WCF
7 27 (1.63%) HTML5
7 27 (1.63%) XML
8 24 (1.45%) Apache Flex
9 23 (1.39%) CSS
10 18 (1.09%) AngularJS
10 18 (1.09%) WPF
11 17 (1.03%) REST
12 16 (0.97%) JSON
13 14 (0.85%) .NET Framework
13 14 (0.85%) CSS3
14 13 (0.79%) Elastic Stack
14 13 (0.79%) RESTful
14 13 (0.79%) SOAP
Miscellaneous
1 309 (18.66%) Analytical Skills
2 118 (7.13%) Management Information System
3 54 (3.26%) Data Structures
4 43 (2.60%) Self-Motivation
5 28 (1.69%) Greenfield Project
6 27 (1.63%) Reinsurance
7 26 (1.57%) Replication
8 22 (1.33%) NHS
8 22 (1.33%) Tandem
9 21 (1.27%) User Experience
10 19 (1.15%) Data Centre
11 15 (0.91%) Reference Data
12 14 (0.85%) Linux Command Line
13 12 (0.72%) Social Media
14 11 (0.66%) Clustering
15 10 (0.60%) Smart Meter
16 9 (0.54%) Credit Risk
16 9 (0.54%) Private Cloud
16 9 (0.54%) Smart Energy
17 8 (0.48%) Social Network
Operating Systems
1 111 (6.70%) Linux
2 70 (4.23%) Windows
3 69 (4.17%) Unix
4 15 (0.91%) Windows Server
5 10 (0.60%) Windows 7
6 8 (0.48%) Red Hat Enterprise Linux
7 7 (0.42%) Solaris
8 6 (0.36%) Oracle Linux
9 5 (0.30%) Windows Server 2012
10 4 (0.24%) VME
11 3 (0.18%) Windows 10
11 3 (0.18%) Windows Server 2008
12 2 (0.12%) AIX
12 2 (0.12%) Android
12 2 (0.12%) Apple iOS
12 2 (0.12%) VMS
12 2 (0.12%) Windows Server 2003
13 1 (0.060%) zOS
Processes & Methodologies
1 1,086 (65.58%) Business Intelligence
2 754 (45.53%) ETL
3 461 (27.84%) Analytics
4 453 (27.36%) Data Modelling
5 442 (26.69%) Agile Software Development
6 240 (14.49%) Visualisation
7 200 (12.08%) Problem-Solving
8 171 (10.33%) Data Integration
9 157 (9.48%) Migration
10 151 (9.12%) Data Analysis
11 150 (9.06%) Data Management
12 147 (8.88%) Kimball Methodology
13 143 (8.64%) Data Architecture
14 129 (7.79%) SDLC
15 127 (7.67%) Data Visualisation
16 125 (7.55%) Data Analytics
16 125 (7.55%) Mentoring
17 120 (7.25%) Data Science
18 118 (7.13%) Stakeholder Management
19 116 (7.00%) DevOps
Programming Languages
1 1,081 (65.28%) SQL
2 328 (19.81%) T-SQL
3 212 (12.80%) Python
4 87 (5.25%) C#
5 84 (5.07%) Data Analysis Expressions (DAX)
6 79 (4.77%) Java
7 62 (3.74%) PL/SQL
8 60 (3.62%) JavaScript
9 52 (3.14%) R
10 45 (2.72%) VBA
11 43 (2.60%) Bash Shell
12 41 (2.48%) PowerShell
13 23 (1.39%) Scala
14 20 (1.21%) Shell Script
15 19 (1.15%) VB
15 19 (1.15%) VB.NET
16 14 (0.85%) Perl
17 11 (0.66%) Korn
18 10 (0.60%) PHP
19 9 (0.54%) Ruby
Qualifications
1 112 (6.76%) Degree
2 26 (1.57%) Security Cleared
3 22 (1.33%) ISTQB
4 17 (1.03%) Computer Science Degree
5 14 (0.85%) Microsoft Certification
6 10 (0.60%) SC Cleared
7 8 (0.48%) ISTQB Foundation Certification
7 8 (0.48%) MCSA
8 7 (0.42%) ITIL Certification
9 6 (0.36%) Numerate Degree
10 5 (0.30%) ISEB
11 4 (0.24%) AWS Certification
12 3 (0.18%) Master's Degree
12 3 (0.18%) MCSE
12 3 (0.18%) PMI Certification
12 3 (0.18%) Sun Certification
12 3 (0.18%) TOGAF Certification
13 2 (0.12%) ITIL Foundation Certificate
13 2 (0.12%) PRINCE2 Certification
13 2 (0.12%) SAS Certification
Quality Assurance & Compliance
1 150 (9.06%) Data Quality
2 94 (5.68%) QA
3 44 (2.66%) SLA
4 40 (2.42%) GDPR
5 18 (1.09%) Solvency II
6 11 (0.66%) ISO/IEC 27001
7 4 (0.24%) PMO
7 4 (0.24%) Sarbanes-Oxley
8 3 (0.18%) COBIT
9 2 (0.12%) ISO 22301
9 2 (0.12%) PCI DSS
10 1 (0.060%) GMP
10 1 (0.060%) ISO 9000
10 1 (0.060%) ISO 9001
10 1 (0.060%) NCSC
System Software
1 40 (2.42%) Docker
2 26 (1.57%) Active Directory
3 18 (1.09%) Apache Flume
3 18 (1.09%) Tivoli Workload Scheduler
4 16 (0.97%) HDFS
5 12 (0.72%) VMware Infrastructure
6 10 (0.60%) Hyper-V
7 9 (0.54%) Microsoft App-V
8 6 (0.36%) Oracle RAC
9 4 (0.24%) NFS
9 4 (0.24%) Veritas Volume Manager
10 3 (0.18%) Virtual Machines
11 2 (0.12%) Oracle Clusterware
12 1 (0.060%) Apache ZooKeeper
Systems Management
1 33 (1.99%) Kubernetes
2 18 (1.09%) Oozie
2 18 (1.09%) Tivoli
3 15 (0.91%) Foglight
3 15 (0.91%) LiteSpeed
4 10 (0.60%) SCOM
5 9 (0.54%) SCCM
6 8 (0.48%) Oracle RMAN
7 7 (0.42%) Ansible
8 6 (0.36%) BMC PATROL
8 6 (0.36%) Oracle Enterprise Manager
8 6 (0.36%) Terraform
9 5 (0.30%) Opscode Chef
9 5 (0.30%) Puppet
10 4 (0.24%) AirWatch
10 4 (0.24%) HP ALM
10 4 (0.24%) Netcool
10 4 (0.24%) Oracle ZFS
10 4 (0.24%) Simpana
11 3 (0.18%) Single Sign-On
Vendors
1 535 (32.31%) Microsoft
2 246 (14.86%) Tableau
3 191 (11.53%) Oracle
4 105 (6.34%) IBM
5 100 (6.04%) SAP
6 97 (5.86%) Informatica
7 95 (5.74%) Cognos
8 74 (4.47%) Google
9 54 (3.26%) Teradata
10 45 (2.72%) Cloudera
11 41 (2.48%) Databricks
12 35 (2.11%) Talend
13 29 (1.75%) Netezza
14 18 (1.09%) InterSystems
15 17 (1.03%) Salesforce.com
16 16 (0.97%) Ab Initio
16 16 (0.97%) Alteryx
17 14 (0.85%) Sage
18 12 (0.72%) VMware
19 11 (0.66%) Sun