Period
to 21 May 2019

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 21 May 2019 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK
6 months to
21 May 2019
Same period 2018 Same period 2017
Rank 110 123 109
Rank change year-on-year +13 -14 -25
Permanent jobs citing Data Warehouse 4,232 4,686 4,797
As % of all permanent IT jobs advertised in the UK 2.94% 2.73% 2.84%
As % of the Database & Business Intelligence category 10.45% 8.89% 9.19%
Number of salaries quoted 3,453 3,804 4,120
UK median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% -4.76%
10th Percentile £37,500 £33,750 £32,500
90th Percentile £85,000 £82,500 £80,000
UK excluding London median annual salary £49,000 £45,000 £45,000
% change year-on-year +8.89% - -

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 40,485 52,689 52,175
As % of all permanent IT jobs advertised in the UK 28.08% 30.68% 30.90%
Number of salaries quoted 32,995 43,333 44,260
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £31,250 £29,750
90th Percentile £85,000 £80,000 £77,500
UK excluding London median annual salary £45,000 £44,000 £42,000
% change year-on-year +2.27% +4.76% +1.20%

Data Warehouse
Job Vacancy Trend

Job postings citing Data Warehouse as a percentage of all IT jobs advertised.

Job vacancy trend for Data Warehouse in the UK

Data Warehouse
Salary Trend

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

Salary trend for Data Warehouse in the UK

Data Warehouse
Salary Histogram

The salary distribution of IT jobs citing Data Warehouse over the 6 months to 21 May 2019.

Salary histogram for Data Warehouse in the UK

Data Warehouse
Top 17 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 21 May 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
England +11 3,967 £55,000 +4.76% 303
London +18 2,233 £62,500 +4.17% 137
UK excluding London -3 1,924 £49,000 +8.89% 189
South East +11 526 £55,000 +10.00% 26
North of England -24 499 £45,000 - 73
Midlands 0 332 £46,500 +3.33% 30
North West +1 274 £45,000 - 40
South West +19 231 £52,500 +26.51% 20
Yorkshire -45 197 £47,500 +5.56% 29
West Midlands -4 190 £50,000 +6.38% 13
East Midlands +5 142 £42,500 - 17
Scotland +20 140 £45,000 - 11
East of England -7 136 £52,500 +5.00% 17
Wales +15 50 £45,000 +9.09% 11
North East -7 28 £46,000 +18.71% 4
Northern Ireland -20 12 £54,937 +83.12%
Channel Islands +3 2 £50,000 +11.11% 1

For the 6 months to 21 May 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 with a requirement for Data Warehouse.

1 2,721 (64.30%) SQL
2 2,660 (62.85%) Business Intelligence
3 1,900 (44.90%) ETL
4 1,877 (44.35%) SQL Server
5 1,688 (39.89%) SQL Server Integration Services
6 1,548 (36.58%) Agile Software Development
7 1,387 (32.77%) SQL Server Reporting Services
8 1,366 (32.28%) Analytics
9 1,311 (30.98%) Microsoft
10 1,164 (27.50%) SQL Server Analysis Services
11 1,125 (26.58%) Power BI
11 1,125 (26.58%) Power Platform
12 1,098 (25.95%) Microsoft Azure
13 1,061 (25.07%) Data Modelling
14 1,033 (24.41%) Finance
15 978 (23.11%) T-SQL
16 744 (17.58%) Tableau
17 738 (17.44%) Big Data
18 702 (16.59%) Oracle
19 681 (16.09%) Visualisation
20 676 (15.97%) Python
21 666 (15.74%) Analytical Skills
22 553 (13.07%) Amazon AWS
23 495 (11.70%) Data Lake
24 489 (11.55%) Hadoop
25 470 (11.11%) Kimball Methodology
26 466 (11.01%) Data Quality
27 462 (10.92%) C#
28 454 (10.73%) Scrum
29 451 (10.66%) 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 279 (6.59%) Apache Spark
2 189 (4.47%) SAS
3 119 (2.81%) SharePoint
4 73 (1.72%) Apache
5 57 (1.35%) Apache Pig
6 51 (1.21%) Elasticsearch
7 27 (0.64%) IIS
8 25 (0.59%) Apache Solr
9 22 (0.52%) CMS
9 22 (0.52%) Confluence
10 21 (0.50%) WebLogic
11 16 (0.38%) Apache Airflow
12 15 (0.35%) Oracle SOA Suite
13 11 (0.26%) BizTalk Server
14 6 (0.14%) MS Exchange
14 6 (0.14%) Skype for Business
15 4 (0.095%) Drupal
16 3 (0.071%) Luigi
16 3 (0.071%) nginx
16 3 (0.071%) Oracle Service Bus
Applications
1 238 (5.62%) Microsoft Excel
2 90 (2.13%) Microsoft Office
3 37 (0.87%) MS Visio
4 35 (0.83%) Microsoft PowerPoint
5 32 (0.76%) Microsoft Project
6 28 (0.66%) SPSS
7 7 (0.17%) Spreadsheet
8 3 (0.071%) Adobe After Effects
8 3 (0.071%) Adobe Illustrator
9 2 (0.047%) Chatbot
9 2 (0.047%) GNU Octave
9 2 (0.047%) Mingle
Business Applications
1 42 (0.99%) Dynamics CRM
2 22 (0.52%) Cognos Business Intelligence
3 19 (0.45%) SAP BPC
4 11 (0.26%) Infor SunSystems
5 10 (0.24%) Cognos TM1
5 10 (0.24%) SAP ERP
5 10 (0.24%) SAP S/4HANA
6 8 (0.19%) Dynamics AX
6 8 (0.19%) FastStats
6 8 (0.19%) Markit EDM
7 7 (0.17%) Oracle EBS
7 7 (0.17%) Raiser's Edge
8 6 (0.14%) Maximo
8 6 (0.14%) NetSuite
8 6 (0.14%) Oracle EBS R12
9 5 (0.12%) Oracle Payables
9 5 (0.12%) Oracle Procure-to-Pay
9 5 (0.12%) Oracle Receivables
10 4 (0.095%) Oracle Applications
10 4 (0.095%) Oracle General Ledger
Cloud Services
1 1,125 (26.58%) Power Platform
2 1,098 (25.95%) Microsoft Azure
3 553 (13.07%) Amazon AWS
4 226 (5.34%) Azure Data Factory
5 192 (4.54%) Google Cloud Platform
6 100 (2.36%) SaaS
7 96 (2.27%) PaaS
8 83 (1.96%) Serverless
9 56 (1.32%) Amazon S3
10 43 (1.02%) Amazon EMR
11 42 (0.99%) Cloud Computing
11 42 (0.99%) Data Lake Analytics
12 39 (0.92%) Azure Machine Learning
13 38 (0.90%) Cortana Intelligence Suite
14 31 (0.73%) Azure Functions
15 29 (0.69%) Azure Stack
16 28 (0.66%) IaaS
17 22 (0.52%) AWS Lambda
18 21 (0.50%) GitHub
18 21 (0.50%) PowerApps
Communications & Networking
1 35 (0.83%) Internet
2 27 (0.64%) Broadband
3 16 (0.38%) Intranet
4 15 (0.35%) FTP
5 10 (0.24%) HTTP
6 9 (0.21%) Firewall
7 7 (0.17%) DNS
7 7 (0.17%) Wi-Fi
8 6 (0.14%) SAN
8 6 (0.14%) TCP/IP
8 6 (0.14%) VoIP
9 5 (0.12%) Skype
9 5 (0.12%) SMS
10 4 (0.095%) DHCP
10 4 (0.095%) Extranet
10 4 (0.095%) WAN
11 3 (0.071%) HTTPS
11 3 (0.071%) MVNO
12 2 (0.047%) LAN
12 2 (0.047%) SSL
Database & Business Intelligence
1 1,877 (44.35%) SQL Server
2 1,688 (39.89%) SQL Server Integration Services
3 1,387 (32.77%) SQL Server Reporting Services
4 1,164 (27.50%) SQL Server Analysis Services
5 1,125 (26.58%) Power BI
6 738 (17.44%) Big Data
7 495 (11.70%) Data Lake
8 489 (11.55%) Hadoop
9 447 (10.56%) Relational Database
10 360 (8.51%) BusinessObjects
11 352 (8.32%) QlikView
12 307 (7.25%) NoSQL
13 278 (6.57%) SQL Server 2012
14 273 (6.45%) Azure SQL Database
15 246 (5.81%) OLAP
16 228 (5.39%) Azure SQL Data Warehouse
17 196 (4.63%) Amazon Redshift
18 195 (4.61%) Microsoft Analysis Services
19 187 (4.42%) Apache Hive
20 182 (4.30%) SQL Server 2016
Development Applications
1 167 (3.95%) Team Foundation Server
2 156 (3.69%) Git (software)
3 151 (3.57%) Visual Studio
4 99 (2.34%) JIRA
5 71 (1.68%) Jenkins
6 65 (1.54%) SQL Server Management Studio (SSMS)
7 39 (0.92%) ERwin
8 35 (0.83%) Maven
9 33 (0.78%) Selenium
10 30 (0.71%) Visual Studio Team System
11 29 (0.69%) Bitbucket
11 29 (0.69%) Cucumber
12 25 (0.59%) Subversion
13 24 (0.57%) TeamCity
14 22 (0.52%) Octopus Deploy
15 19 (0.45%) ProC
16 18 (0.43%) ER Studio
17 17 (0.40%) Hudson
18 16 (0.38%) Oracle Forms
19 15 (0.35%) Toad
General
1 1,033 (24.41%) Finance
2 335 (7.92%) Retail
3 276 (6.52%) Banking
4 233 (5.51%) Marketing
5 100 (2.36%) Telecoms
6 74 (1.75%) Investment Banking
7 63 (1.49%) Legal
8 57 (1.35%) Manufacturing
9 48 (1.13%) Law
10 42 (0.99%) Advertising
11 38 (0.90%) Electronics
12 25 (0.59%) Financial Institution
12 25 (0.59%) Local Government
13 22 (0.52%) Back Office
13 22 (0.52%) Games
14 13 (0.31%) Automotive
14 13 (0.31%) Front Office
15 11 (0.26%) General Ledger
16 10 (0.24%) Pharmaceutical
16 10 (0.24%) Publishing
Job Titles
1 1,745 (41.23%) Developer
2 934 (22.07%) Business Intelligence Developer
3 566 (13.37%) SQL Developer
4 554 (13.09%) Analyst
5 492 (11.63%) Architect
6 401 (9.48%) Data Engineer
7 310 (7.33%) Data Architect
8 295 (6.97%) SQL BI Developer
9 270 (6.38%) Senior Developer
10 261 (6.17%) Data Warehouse Developer
11 219 (5.17%) Business Intelligence Analyst
12 171 (4.04%) SSIS Developer
13 170 (4.02%) Consultant
14 165 (3.90%) SSRS Developer
15 164 (3.88%) Data Analyst
16 155 (3.66%) Senior Business Intelligence Developer
17 154 (3.64%) Business Developer
18 139 (3.28%) ETL Developer
19 138 (3.26%) DBA
20 132 (3.12%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 335 (7.92%) .NET
2 235 (5.55%) MDX
3 197 (4.66%) Kafka
4 179 (4.23%) Web Services
5 118 (2.79%) XML
6 97 (2.29%) HTML
7 85 (2.01%) JSON
8 70 (1.65%) CSS
9 54 (1.28%) REST
10 50 (1.18%) ASP.NET
11 49 (1.16%) AngularJS
12 46 (1.09%) Middleware
13 45 (1.06%) .NET Framework
13 45 (1.06%) WCF
14 40 (0.95%) Apache NiFi
14 40 (0.95%) React
15 32 (0.76%) RESTful
16 31 (0.73%) HTML5
17 29 (0.69%) SOAP
18 26 (0.61%) ASP.NET Web API
Miscellaneous
1 666 (15.74%) Analytical Skills
2 169 (3.99%) Data Structures
3 167 (3.95%) Management Information System
4 152 (3.59%) Greenfield Project
5 100 (2.36%) Self-Motivation
6 93 (2.20%) Fintech
7 91 (2.15%) Replication
8 67 (1.58%) Clustering
9 64 (1.51%) Data Centre
10 60 (1.42%) User Experience
11 53 (1.25%) Algorithms
12 48 (1.13%) NHS
13 36 (0.85%) Virtual Team
14 35 (0.83%) Enterprise Software
14 35 (0.83%) Reinsurance
15 28 (0.66%) Credit Risk
16 27 (0.64%) Hedge funds
16 27 (0.64%) Mobile App
17 26 (0.61%) Market Risk
17 26 (0.61%) Reference Data
Operating Systems
1 168 (3.97%) Unix
2 147 (3.47%) Linux
3 104 (2.46%) Windows
4 29 (0.69%) Red Hat Enterprise Linux
5 27 (0.64%) Windows Server
6 25 (0.59%) Solaris
7 12 (0.28%) Apple iOS
8 11 (0.26%) CentOS
8 11 (0.26%) Ubuntu
9 9 (0.21%) Windows Server 2012
10 6 (0.14%) AIX
11 5 (0.12%) Mac OS X
12 4 (0.095%) Oracle Linux
13 3 (0.071%) Windows 10
13 3 (0.071%) Windows 7
14 1 (0.024%) Kali Linux
14 1 (0.024%) VMS
14 1 (0.024%) Windows Server 2008
14 1 (0.024%) Windows XP
Processes & Methodologies
1 2,660 (62.85%) Business Intelligence
2 1,900 (44.90%) ETL
3 1,548 (36.58%) Agile Software Development
4 1,366 (32.28%) Analytics
5 1,061 (25.07%) Data Modelling
6 681 (16.09%) Visualisation
7 470 (11.11%) Kimball Methodology
8 454 (10.73%) Scrum
9 451 (10.66%) Data Architecture
10 439 (10.37%) Data Management
11 426 (10.07%) Problem-Solving
12 401 (9.48%) Migration
13 397 (9.38%) Data Science
14 388 (9.17%) Data Visualisation
15 368 (8.70%) Data Analysis
16 363 (8.58%) Data Analytics
17 356 (8.41%) Data Integration
18 305 (7.21%) SDLC
19 300 (7.09%) Machine Learning
20 297 (7.02%) DevOps
Programming Languages
1 2,721 (64.30%) SQL
2 978 (23.11%) T-SQL
3 676 (15.97%) Python
4 462 (10.92%) C#
5 375 (8.86%) Java
6 266 (6.29%) Data Analysis Expressions (DAX)
7 255 (6.03%) R
8 231 (5.46%) PL/SQL
9 174 (4.11%) JavaScript
10 154 (3.64%) Scala
11 129 (3.05%) PowerShell
12 128 (3.02%) VBA
13 48 (1.13%) PHP
14 46 (1.09%) C
15 43 (1.02%) Shell Script
16 42 (0.99%) VB
17 32 (0.76%) VB.NET
18 30 (0.71%) Go
18 30 (0.71%) HiveQL
19 24 (0.57%) MATLAB
Qualifications
1 408 (9.64%) Degree
2 93 (2.20%) Computer Science Degree
3 86 (2.03%) Microsoft Certification
4 50 (1.18%) Security Cleared
5 49 (1.16%) TOGAF Certification
6 40 (0.95%) Master's Degree
7 33 (0.78%) MCSA
8 25 (0.59%) ISEB
8 25 (0.59%) ISTQB
9 20 (0.47%) MCSE
10 15 (0.35%) SC Cleared
11 13 (0.31%) AWS Certification
12 12 (0.28%) Numerate Degree
13 11 (0.26%) PMP
14 10 (0.24%) DBS Check
14 10 (0.24%) MCT
14 10 (0.24%) PMI Certification
15 9 (0.21%) PRINCE2 Certification
16 8 (0.19%) MCP
17 6 (0.14%) PhD
Quality Assurance & Compliance
1 466 (11.01%) Data Quality
2 145 (3.43%) QA
3 124 (2.93%) GDPR
4 32 (0.76%) SLA
5 21 (0.50%) PMO
6 16 (0.38%) ISO/IEC 27001
7 15 (0.35%) Solvency II
8 11 (0.26%) COBIT
9 8 (0.19%) IFRS
9 8 (0.19%) PCI DSS
10 7 (0.17%) HIPAA
10 7 (0.17%) MiFID
11 2 (0.047%) IFRS 9
11 2 (0.047%) PA-DSS
12 1 (0.024%) FedRAMP
12 1 (0.024%) GAAP
12 1 (0.024%) ISO 14001
12 1 (0.024%) ISO 9001
12 1 (0.024%) NIST 800
System Software
1 80 (1.89%) Docker
2 61 (1.44%) HDFS
3 52 (1.23%) Apache Flume
4 41 (0.97%) VMware Infrastructure
5 29 (0.69%) Active Directory
6 11 (0.26%) Tivoli Workload Scheduler
7 7 (0.17%) Apache ZooKeeper
7 7 (0.17%) Oracle RAC
8 5 (0.12%) GPFS
9 4 (0.095%) Virtual Machines
10 3 (0.071%) Cronacle
10 3 (0.071%) etcd
10 3 (0.071%) Hyper-V
10 3 (0.071%) Veritas File System
10 3 (0.071%) Veritas Volume Manager
11 2 (0.047%) KVM
12 1 (0.024%) Varnish
Systems Management
1 58 (1.37%) Terraform
2 49 (1.16%) Kubernetes
3 44 (1.04%) Hadoop YARN
4 30 (0.71%) Ansible
5 27 (0.64%) Opscode Chef
6 26 (0.61%) Oozie
7 25 (0.59%) Ambari
7 25 (0.59%) Puppet
8 23 (0.54%) Failover Clustering
9 21 (0.50%) Control-M
9 21 (0.50%) Perfmon
10 17 (0.40%) SQL Sentry
11 15 (0.35%) Oracle RMAN
12 11 (0.26%) Tivoli
13 9 (0.21%) HP Quality Center
14 7 (0.17%) Nagios
15 5 (0.12%) Data Guard
15 5 (0.12%) logstash
16 4 (0.095%) Chukwa
16 4 (0.095%) Grafana
Vendors
1 1,311 (30.98%) Microsoft
2 744 (17.58%) Tableau
3 702 (16.59%) Oracle
4 374 (8.84%) SAP
5 341 (8.06%) Informatica
6 191 (4.51%) Google
7 185 (4.37%) IBM
8 154 (3.64%) Cognos
8 154 (3.64%) Databricks
9 149 (3.52%) Talend
10 143 (3.38%) Teradata
11 107 (2.53%) Cloudera
12 62 (1.47%) Hortonworks
13 46 (1.09%) VMware
14 45 (1.06%) Ab Initio
14 45 (1.06%) MicroStrategy
15 44 (1.04%) Netezza
16 43 (1.02%) Vertica
17 42 (0.99%) MapR
17 42 (0.99%) RedGate