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

Data Warehousing
UK
6 months to
21 Jan 2019
Same period 2018 Same period 2017
Rank 120 123 107
Rank change year-on-year +3 -16 -27
Permanent jobs citing Data Warehouse 4,236 4,632 4,989
As % of all permanent IT jobs advertised in the UK 2.81% 2.69% 2.84%
As % of the Database & Business Intelligence category 9.81% 8.82% 9.48%
Number of salaries quoted 3,505 3,712 4,299
UK median annual salary £55,000 £50,000 £54,000
Median salary % change year-on-year +10.00% -7.41% +8.00%
10th Percentile £35,500 £32,500 £33,000
90th Percentile £85,000 £77,500 £82,500
UK excluding London median annual salary £47,500 £45,000 £47,500
% change year-on-year +5.56% -5.26% +5.56%

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 43,193 52,539 52,612
As % of all permanent IT jobs advertised in the UK 28.65% 30.56% 29.90%
Number of salaries quoted 35,501 43,580 45,038
UK median annual salary £52,500 £48,000 £47,500
Median salary % change year-on-year +9.38% +1.05% +5.56%
10th Percentile £31,250 £30,000 £29,250
90th Percentile £85,000 £77,500 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +4.94%

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 January 2019.

Salary histogram for Data Warehouse in the UK

Data Warehouse
Top 16 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 January 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 +8 3,979 £55,000 +7.84% 674
London +14 2,244 £60,000 +1.69% 294
UK excluding London +3 1,937 £47,500 +5.56% 429
South East +31 539 £51,500 +7.29% 115
North of England -28 476 £45,000 - 122
Midlands -16 289 £45,000 -4.26% 70
North West -32 248 £45,000 - 71
South West -15 217 £52,500 +26.51% 39
East of England +7 204 £46,000 -16.36% 34
Yorkshire -24 202 £47,500 +2.15% 46
Scotland +20 163 £50,000 +11.11% 41
West Midlands -45 145 £47,500 -5.00% 41
East Midlands +34 143 £42,500 - 29
Wales +19 48 £42,500 +21.43% 5
North East +21 40 £60,000 +70.21% 5
Northern Ireland -10 8 - - 3

For the 6 months to 21 January 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,767 (65.32%) SQL
2 2,670 (63.03%) Business Intelligence
3 1,980 (46.74%) SQL Server
4 1,843 (43.51%) ETL
5 1,740 (41.08%) SQL Server Integration Services
6 1,498 (35.36%) Microsoft
7 1,362 (32.15%) SQL Server Reporting Services
8 1,328 (31.35%) Agile Software Development
9 1,221 (28.82%) Analytics
10 1,128 (26.63%) Finance
11 1,080 (25.50%) SQL Server Analysis Services
12 1,044 (24.65%) T-SQL
13 1,036 (24.46%) Power BI
14 969 (22.88%) Data Modelling
15 886 (20.92%) Microsoft Azure
16 724 (17.09%) Tableau
17 687 (16.22%) Analytical Skills
17 687 (16.22%) Oracle
18 673 (15.89%) Big Data
19 663 (15.65%) Visualisation
20 598 (14.12%) Python
21 517 (12.20%) Amazon AWS
22 494 (11.66%) Data Quality
23 486 (11.47%) C#
24 447 (10.55%) Data Management
25 440 (10.39%) Relational Database
26 426 (10.06%) Degree
27 420 (9.92%) Problem-Solving
28 419 (9.89%) .NET
29 411 (9.70%) Data Analysis

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 237 (5.59%) Apache Spark
2 183 (4.32%) SAS
3 156 (3.68%) SharePoint
4 81 (1.91%) Apache
5 48 (1.13%) Elasticsearch
6 39 (0.92%) Confluence
7 38 (0.90%) IIS
7 38 (0.90%) Oracle SOA Suite
8 22 (0.52%) Apache Pig
8 22 (0.52%) CMS
9 21 (0.50%) MS Exchange
9 21 (0.50%) Skype for Business
10 19 (0.45%) Apache Solr
10 19 (0.45%) WebLogic
11 18 (0.42%) Apache Airflow
12 11 (0.26%) JBoss
13 10 (0.24%) BizTalk Server
13 10 (0.24%) Drupal
14 8 (0.19%) Documentum
14 8 (0.19%) nginx
Applications
1 356 (8.40%) Microsoft Excel
2 96 (2.27%) Microsoft Office
3 68 (1.61%) MS Visio
4 38 (0.90%) Microsoft PowerPoint
5 15 (0.35%) SPSS
6 14 (0.33%) Microsoft Project
7 8 (0.19%) Spreadsheet
8 5 (0.12%) Adobe After Effects
8 5 (0.12%) Adobe Illustrator
9 3 (0.071%) InfoPath
10 2 (0.047%) GNU Octave
10 2 (0.047%) Mingle
11 1 (0.024%) CPLEX
Business Applications
1 58 (1.37%) Dynamics CRM
2 42 (0.99%) Cognos Business Intelligence
3 41 (0.97%) Cognos TM1
4 29 (0.68%) Dynamics AX
5 21 (0.50%) Dynamics NAV
5 21 (0.50%) Oracle EBS
6 16 (0.38%) SAP BPC
7 14 (0.33%) Oracle Payables
8 12 (0.28%) NetSuite
9 11 (0.26%) FastStats
10 9 (0.21%) Oracle EBS R12
10 9 (0.21%) Oracle Procure-to-Pay
10 9 (0.21%) SAP CO
10 9 (0.21%) SAP FI
10 9 (0.21%) SAP FI/CO
11 8 (0.19%) Oracle Subledger Accounting
11 8 (0.19%) SAP Bank Analyzer
11 8 (0.19%) SAP FS
11 8 (0.19%) SAP MDM
12 6 (0.14%) SAP ERP
Cloud Services
1 886 (20.92%) Microsoft Azure
2 517 (12.20%) Amazon AWS
3 182 (4.30%) Azure Data Factory
4 142 (3.35%) PaaS
5 135 (3.19%) Google Cloud Platform
6 104 (2.46%) SaaS
7 71 (1.68%) Serverless
8 55 (1.30%) IaaS
9 54 (1.27%) Data Lake Analytics
10 51 (1.20%) Cloud Computing
11 45 (1.06%) Office 365
12 35 (0.83%) Amazon S3
13 33 (0.78%) Azure Machine Learning
14 32 (0.76%) Azure Functions
15 27 (0.64%) Cortana Intelligence Suite
16 24 (0.57%) AWS Lambda
16 24 (0.57%) Dynamics 365
17 23 (0.54%) Amazon EC2
17 23 (0.54%) GitHub
18 22 (0.52%) Amazon EMR
Communications & Networking
1 51 (1.20%) Internet
2 29 (0.68%) HTTP
3 28 (0.66%) WAN
4 27 (0.64%) Firewall
5 23 (0.54%) SAN
6 20 (0.47%) LAN
7 17 (0.40%) VoIP
8 16 (0.38%) DNS
9 12 (0.28%) FTP
10 11 (0.26%) DHCP
11 9 (0.21%) TCP/IP
12 8 (0.19%) Intranet
12 8 (0.19%) Skype
13 7 (0.17%) Cisco IOS
13 7 (0.17%) HTTPS
13 7 (0.17%) MPLS
13 7 (0.17%) Network Security
14 5 (0.12%) OSPF
14 5 (0.12%) SSH
14 5 (0.12%) VLAN
Database & Business Intelligence
1 1,980 (46.74%) SQL Server
2 1,740 (41.08%) SQL Server Integration Services
3 1,362 (32.15%) SQL Server Reporting Services
4 1,080 (25.50%) SQL Server Analysis Services
5 1,036 (24.46%) Power BI
6 673 (15.89%) Big Data
7 440 (10.39%) Relational Database
8 400 (9.44%) Data Lake
8 400 (9.44%) Hadoop
9 328 (7.74%) BusinessObjects
10 292 (6.89%) QlikView
11 251 (5.93%) SQL Server 2012
12 243 (5.74%) OLAP
13 242 (5.71%) NoSQL
14 215 (5.08%) Microsoft Analysis Services
15 212 (5.00%) Azure SQL Data Warehouse
16 211 (4.98%) SQL Server 2016
17 198 (4.67%) Azure SQL Database
17 198 (4.67%) SQL Server 2008
18 181 (4.27%) Oracle Database
Development Applications
1 179 (4.23%) Visual Studio
2 165 (3.90%) Team Foundation Server
3 162 (3.82%) Git (software)
4 96 (2.27%) Jenkins
5 90 (2.12%) JIRA
6 75 (1.77%) SQL Server Management Studio (SSMS)
7 74 (1.75%) ERwin
8 53 (1.25%) Visual Studio Team System
9 49 (1.16%) Octopus Deploy
10 37 (0.87%) TeamCity
11 34 (0.80%) ER Studio
12 33 (0.78%) Subversion
13 30 (0.71%) Oracle APEX
14 25 (0.59%) SoapUI
15 24 (0.57%) Selenium
16 23 (0.54%) Eclipse
17 19 (0.45%) Maven
17 19 (0.45%) Toad
18 18 (0.42%) Atlassian Bamboo
18 18 (0.42%) tSQLt
General
1 1,128 (26.63%) Finance
2 355 (8.38%) Retail
3 277 (6.54%) Banking
4 224 (5.29%) Marketing
5 101 (2.38%) Advertising
6 79 (1.86%) Investment Banking
7 57 (1.35%) Legal
8 56 (1.32%) Telecoms
9 48 (1.13%) Manufacturing
10 38 (0.90%) Law
11 37 (0.87%) Games
12 36 (0.85%) Publishing
13 30 (0.71%) Back Office
14 26 (0.61%) Corporate Banking
15 22 (0.52%) General Ledger
16 21 (0.50%) Front Office
17 19 (0.45%) Automotive
18 16 (0.38%) Financial Institution
18 16 (0.38%) Local Government
18 16 (0.38%) Pharmaceutical
Job Titles
1 1,575 (37.18%) Developer
2 751 (17.73%) Business Intelligence Developer
3 748 (17.66%) Analyst
4 581 (13.72%) Architect
5 520 (12.28%) SQL Developer
6 384 (9.07%) Data Architect
7 298 (7.03%) Data Engineer
8 258 (6.09%) Business Intelligence Analyst
9 247 (5.83%) Senior Developer
10 240 (5.67%) Consultant
11 235 (5.55%) SQL BI Developer
12 231 (5.45%) Data Warehouse Developer
13 222 (5.24%) SSIS Developer
14 215 (5.08%) Data Analyst
15 180 (4.25%) Business Analyst
16 166 (3.92%) ETL Developer
17 157 (3.71%) DBA
18 148 (3.49%) SQL Server Developer
19 142 (3.35%) SSRS Developer
20 135 (3.19%) Solutions Architect
Libraries, Frameworks & Software Standards
1 419 (9.89%) .NET
2 243 (5.74%) Web Services
3 192 (4.53%) MDX
4 180 (4.25%) XML
5 173 (4.08%) Kafka
6 131 (3.09%) HTML
7 121 (2.86%) JSON
8 95 (2.24%) CSS
9 88 (2.08%) Middleware
10 79 (1.86%) ASP.NET
11 71 (1.68%) REST
12 55 (1.30%) AngularJS
13 48 (1.13%) SOAP
14 46 (1.09%) .NET Framework
15 42 (0.99%) WCF
16 39 (0.92%) HTML5
17 32 (0.76%) ASP.NET MVC
17 32 (0.76%) React
18 30 (0.71%) ASP.NET Web API
18 30 (0.71%) Spark Streaming
Miscellaneous
1 687 (16.22%) Analytical Skills
2 225 (5.31%) Data Structures
3 163 (3.85%) Management Information System
4 157 (3.71%) Greenfield Project
5 102 (2.41%) Replication
6 78 (1.84%) Fintech
7 77 (1.82%) Self-Motivation
8 72 (1.70%) NHS
9 65 (1.53%) Algorithms
10 60 (1.42%) Clustering
10 60 (1.42%) Reinsurance
11 57 (1.35%) Reference Data
12 47 (1.11%) Enterprise Software
12 47 (1.11%) User Experience
13 43 (1.02%) Credit Risk
14 37 (0.87%) Mobile App
15 34 (0.80%) Virtual Team
16 30 (0.71%) Hedge funds
17 29 (0.68%) Market Risk
18 28 (0.66%) Data Centre
Operating Systems
1 254 (6.00%) Linux
2 220 (5.19%) Windows
3 205 (4.84%) Unix
4 68 (1.61%) Windows Server
5 65 (1.53%) Red Hat Enterprise Linux
6 30 (0.71%) AIX
7 25 (0.59%) Solaris
8 18 (0.42%) Apple iOS
9 16 (0.38%) CentOS
10 15 (0.35%) Ubuntu
10 15 (0.35%) Windows Server 2008
11 13 (0.31%) HPUX
11 13 (0.31%) Windows Server 2012
12 6 (0.14%) Kali Linux
13 4 (0.094%) Mac OS X
13 4 (0.094%) zOS
14 3 (0.071%) Oracle Linux
14 3 (0.071%) Windows 10
15 2 (0.047%) Windows 7
15 2 (0.047%) Windows XP
Processes & Methodologies
1 2,670 (63.03%) Business Intelligence
2 1,843 (43.51%) ETL
3 1,328 (31.35%) Agile Software Development
4 1,221 (28.82%) Analytics
5 969 (22.88%) Data Modelling
6 663 (15.65%) Visualisation
7 447 (10.55%) Data Management
8 420 (9.92%) Problem-Solving
9 411 (9.70%) Data Analysis
10 409 (9.66%) Migration
11 392 (9.25%) Data Architecture
12 383 (9.04%) Scrum
13 364 (8.59%) Data Integration
14 351 (8.29%) Kimball Methodology
15 332 (7.84%) Dimensional Modelling
16 325 (7.67%) Data Analytics
17 319 (7.53%) SDLC
18 315 (7.44%) Data Science
18 315 (7.44%) Performance Tuning
19 300 (7.08%) Data Visualisation
Programming Languages
1 2,767 (65.32%) SQL
2 1,044 (24.65%) T-SQL
3 598 (14.12%) Python
4 486 (11.47%) C#
5 284 (6.70%) Java
6 228 (5.38%) PL/SQL
7 211 (4.98%) R
8 191 (4.51%) JavaScript
9 170 (4.01%) Data Analysis Expressions (DAX)
10 137 (3.23%) PowerShell
11 131 (3.09%) VBA
12 121 (2.86%) Scala
13 84 (1.98%) Shell Script
14 67 (1.58%) VB
15 58 (1.37%) PHP
16 42 (0.99%) VB.NET
17 38 (0.90%) C
18 37 (0.87%) U-SQL
19 31 (0.73%) Bash Shell
20 28 (0.66%) Ruby
Qualifications
1 426 (10.06%) Degree
2 99 (2.34%) Microsoft Certification
3 83 (1.96%) Computer Science Degree
4 70 (1.65%) Security Cleared
5 48 (1.13%) ISEB
6 38 (0.90%) MCSA
7 36 (0.85%) TOGAF Certification
8 33 (0.78%) SC Cleared
9 25 (0.59%) Master's Degree
10 22 (0.52%) MCSE
11 19 (0.45%) PMP
12 16 (0.38%) PMI Certification
13 15 (0.35%) AWS Certification
14 14 (0.33%) ITIL Certification
15 13 (0.31%) Numerate Degree
15 13 (0.31%) PRINCE2 Certification
16 12 (0.28%) MCT
17 11 (0.26%) PhD
18 10 (0.24%) ISTQB
18 10 (0.24%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 494 (11.66%) Data Quality
2 226 (5.34%) QA
3 140 (3.31%) GDPR
4 50 (1.18%) PMO
5 30 (0.71%) Solvency II
6 28 (0.66%) ISO/IEC 27001
7 26 (0.61%) SLA
8 20 (0.47%) IFRS
9 16 (0.38%) PCI DSS
10 9 (0.21%) COBIT
11 8 (0.19%) IFRS 9
12 6 (0.14%) MiFID
13 3 (0.071%) PA-DSS
14 2 (0.047%) P3O
14 2 (0.047%) Web Application Security Consortium
15 1 (0.024%) Dodd-Frank
15 1 (0.024%) FATCA
15 1 (0.024%) ISO 9001
System Software
1 70 (1.65%) Docker
2 56 (1.32%) HDFS
3 48 (1.13%) Active Directory
4 46 (1.09%) Apache Flume
5 39 (0.92%) VMware Infrastructure
6 19 (0.45%) Hyper-V
7 12 (0.28%) Virtual Machines
8 8 (0.19%) GPFS
9 7 (0.17%) Tivoli Workload Scheduler
9 7 (0.17%) Veritas Cluster Server
10 6 (0.14%) Apache ZooKeeper
10 6 (0.14%) Varnish
10 6 (0.14%) vSphere
11 3 (0.071%) Oracle RAC
12 1 (0.024%) Terminal Services
Systems Management
1 53 (1.25%) Kubernetes
2 43 (1.02%) Ansible
2 43 (1.02%) Opscode Chef
3 40 (0.94%) Puppet
4 33 (0.78%) Terraform
5 29 (0.68%) Control-M
6 27 (0.64%) Automic
7 25 (0.59%) Oracle RMAN
8 22 (0.52%) Hadoop YARN
9 16 (0.38%) Oozie
10 14 (0.33%) Tivoli
11 13 (0.31%) Mesos
12 9 (0.21%) Failover Clustering
12 9 (0.21%) Oracle Enterprise Manager
12 9 (0.21%) Perfmon
13 8 (0.19%) Nagios
13 8 (0.19%) Rundeck
14 7 (0.17%) Microsoft Clustering
14 7 (0.17%) Tivoli Storage Manager
15 6 (0.14%) Nessus
Vendors
1 1,498 (35.36%) Microsoft
2 724 (17.09%) Tableau
3 687 (16.22%) Oracle
4 295 (6.96%) SAP
5 263 (6.21%) Informatica
6 206 (4.86%) Cognos
7 176 (4.15%) Google
8 162 (3.82%) IBM
9 130 (3.07%) Teradata
10 106 (2.50%) Talend
11 88 (2.08%) Cloudera
12 65 (1.53%) VMware
13 60 (1.42%) Ab Initio
14 58 (1.37%) Red Hat
15 54 (1.27%) Hortonworks
16 50 (1.18%) MicroStrategy
17 49 (1.16%) Databricks
18 41 (0.97%) Alteryx
19 39 (0.92%) Netezza
20 38 (0.90%) MapR