Period
to 23 September 2018

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 23 September 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK
6 months to
23 Sep 2018
Same period 2017 Same period 2016
Rank 111 115 104
Rank change year-on-year +4 -11 -20
Permanent jobs citing Data Warehouse 4,761 5,004 5,615
As % of all permanent IT jobs advertised in the UK 2.88% 2.85% 2.89%
As % of the Database & Business Intelligence category 9.70% 9.32% 9.73%
Number of salaries quoted 3,921 3,973 4,693
UK median annual salary £53,500 £50,000 £52,500
Median salary % change year-on-year +7.00% -4.76% +5.00%
10th Percentile £35,000 £32,500 £33,750
90th Percentile £85,000 £77,900 £81,250
UK excluding London median annual salary £47,500 £45,000 £46,000
% change year-on-year +5.56% -2.17% +2.22%

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 49,107 53,690 57,713
As % of all permanent IT jobs advertised in the UK 29.71% 30.56% 29.74%
Number of salaries quoted 40,030 44,214 49,173
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £82,500 £77,500 £75,000
UK excluding London median annual salary £45,000 £42,500 £41,500
% change year-on-year +5.88% +2.41% +3.75%

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 23 September 2018.

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 23 September 2018. 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 +7 4,505 £55,000 +10.00% 639
London +11 2,420 £60,000 - 285
UK excluding London +3 2,249 £47,500 +5.56% 395
North of England -24 619 £45,000 +5.88% 112
South East +17 602 £52,500 +5.00% 90
Midlands -1 362 £43,500 -3.33% 69
North West -8 338 £45,000 +12.50% 66
East of England +77 280 £50,000 - 36
Yorkshire -35 240 £47,500 +5.56% 30
South West -24 203 £44,000 +3.53% 48
East Midlands +30 188 £42,500 -5.56% 40
West Midlands -28 173 £45,000 - 29
Scotland -30 142 £47,500 +5.56% 24
Wales +41 58 £42,500 +6.25% 15
North East +27 57 £47,500 -9.52% 16
Northern Ireland +2 2 - - 2
Channel Islands - 2 £45,000 -

For the 6 months to 23 September 2018, 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 3,162 (66.41%) SQL
2 3,008 (63.18%) Business Intelligence
3 2,418 (50.79%) SQL Server
4 2,141 (44.97%) SQL Server Integration Services
5 2,064 (43.35%) ETL
6 1,743 (36.61%) SQL Server Reporting Services
7 1,728 (36.29%) Microsoft
8 1,462 (30.71%) Agile Software Development
9 1,379 (28.96%) SQL Server Analysis Services
10 1,369 (28.75%) Finance
11 1,246 (26.17%) T-SQL
12 1,195 (25.10%) Analytics
13 1,061 (22.29%) Power BI
14 937 (19.68%) Data Modelling
15 822 (17.27%) Oracle
16 817 (17.16%) Microsoft Azure
17 771 (16.19%) Big Data
18 679 (14.26%) Analytical Skills
19 674 (14.16%) Tableau
20 596 (12.52%) .NET
21 582 (12.22%) Visualisation
22 525 (11.03%) Degree
23 514 (10.80%) Data Analysis
24 507 (10.65%) Relational Database
25 506 (10.63%) C#
26 498 (10.46%) Python
27 494 (10.38%) Problem-Solving
28 486 (10.21%) Data Quality
29 450 (9.45%) Amazon AWS
30 435 (9.14%) Data Integration

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 229 (4.81%) Apache Spark
2 216 (4.54%) SAS
3 127 (2.67%) SharePoint
4 87 (1.83%) Apache
5 67 (1.41%) IIS
6 43 (0.90%) Oracle SOA Suite
7 37 (0.78%) BizTalk Server
8 32 (0.67%) Confluence
9 30 (0.63%) Apache Pig
10 26 (0.55%) Elasticsearch
11 20 (0.42%) CMS
12 16 (0.34%) Apache Solr
13 15 (0.32%) Skype for Business
14 14 (0.29%) Hyperledger
15 13 (0.27%) JBoss
15 13 (0.27%) WebLogic
16 11 (0.23%) Apache Airflow
16 11 (0.23%) FileNet
16 11 (0.23%) MS Exchange
16 11 (0.23%) Oracle Application Server
Applications
1 388 (8.15%) Microsoft Excel
2 102 (2.14%) Microsoft Office
3 54 (1.13%) MS Visio
4 38 (0.80%) Microsoft PowerPoint
5 17 (0.36%) SPSS
6 16 (0.34%) Microsoft Project
7 11 (0.23%) Spreadsheet
8 3 (0.063%) Stata
9 2 (0.042%) CPLEX
9 2 (0.042%) InfoPath
9 2 (0.042%) Photoshop
10 1 (0.021%) Adobe Illustrator
10 1 (0.021%) Chatbot
10 1 (0.021%) EViews
Business Applications
1 60 (1.26%) Cognos Business Intelligence
1 60 (1.26%) Cognos TM1
2 52 (1.09%) Dynamics CRM
3 41 (0.86%) Dynamics AX
4 28 (0.59%) Markit EDM
5 26 (0.55%) NetSuite
6 23 (0.48%) Oracle EBS
7 18 (0.38%) Dynamics NAV
8 15 (0.32%) SAP S/4HANA
9 11 (0.23%) SAP BPC
10 9 (0.19%) Oracle EBS R12
10 9 (0.19%) SAP ERP
11 8 (0.17%) FastStats
11 8 (0.17%) Remedy ITSM
11 8 (0.17%) SAP CO
11 8 (0.17%) SAP FI
11 8 (0.17%) SAP FI/CO
12 6 (0.13%) Oracle Retail
13 5 (0.11%) MetaTrader
13 5 (0.11%) Salesforce.com CRM
Cloud Services
1 817 (17.16%) Microsoft Azure
2 450 (9.45%) Amazon AWS
3 166 (3.49%) Azure Data Factory
4 109 (2.29%) PaaS
5 82 (1.72%) Google Cloud Platform
6 61 (1.28%) Cloud Computing
7 60 (1.26%) SaaS
8 59 (1.24%) Serverless
9 53 (1.11%) IaaS
10 50 (1.05%) Office 365
11 42 (0.88%) Data Lake Analytics
12 41 (0.86%) Amazon S3
13 32 (0.67%) Cortana Intelligence Suite
14 27 (0.57%) Amazon EC2
15 26 (0.55%) Amazon Kinesis
15 26 (0.55%) AWS Lambda
16 24 (0.50%) Google Analytics
17 23 (0.48%) Dynamics 365
18 22 (0.46%) Azure Functions
19 21 (0.44%) Azure Machine Learning
Communications & Networking
1 60 (1.26%) Internet
2 27 (0.57%) SAN
3 24 (0.50%) DNS
4 23 (0.48%) Firewall
5 21 (0.44%) WAN
6 19 (0.40%) HTTP
7 18 (0.38%) LAN
8 16 (0.34%) SSL
9 14 (0.29%) DHCP
10 13 (0.27%) FTP
11 12 (0.25%) SMS
12 11 (0.23%) Network Security
13 9 (0.19%) TCP/IP
13 9 (0.19%) VoIP
14 7 (0.15%) HTTPS
15 6 (0.13%) Intranet
16 5 (0.11%) BGP
16 5 (0.11%) Cisco IOS
16 5 (0.11%) MPLS
16 5 (0.11%) OSPF
Database & Business Intelligence
1 2,418 (50.79%) SQL Server
2 2,141 (44.97%) SQL Server Integration Services
3 1,743 (36.61%) SQL Server Reporting Services
4 1,379 (28.96%) SQL Server Analysis Services
5 1,061 (22.29%) Power BI
6 771 (16.19%) Big Data
7 507 (10.65%) Relational Database
8 427 (8.97%) Hadoop
9 347 (7.29%) BusinessObjects
10 334 (7.02%) Data Lake
11 321 (6.74%) SQL Server 2012
12 316 (6.64%) OLAP
13 274 (5.76%) SQL Server 2008
14 272 (5.71%) QlikView
15 270 (5.67%) SQL Server 2016
16 239 (5.02%) NoSQL
17 229 (4.81%) Microsoft Analysis Services
18 216 (4.54%) SQL Server 2014
19 214 (4.49%) Azure SQL Data Warehouse
20 202 (4.24%) MySQL
Development Applications
1 215 (4.52%) Team Foundation Server
2 177 (3.72%) Visual Studio
3 139 (2.92%) Git (software)
4 108 (2.27%) Jenkins
5 101 (2.12%) JIRA
6 96 (2.02%) SQL Server Management Studio (SSMS)
7 66 (1.39%) TeamCity
8 51 (1.07%) ERwin
9 48 (1.01%) Visual Studio Team System
10 45 (0.95%) Octopus Deploy
11 38 (0.80%) Oracle APEX
12 32 (0.67%) SoapUI
12 32 (0.67%) Toad
13 29 (0.61%) Oracle Forms
14 28 (0.59%) Selenium
15 22 (0.46%) Eclipse
16 21 (0.44%) Subversion
17 20 (0.42%) Bitbucket
18 17 (0.36%) ER Studio
19 16 (0.34%) Cucumber
General
1 1,369 (28.75%) Finance
2 347 (7.29%) Retail
3 324 (6.81%) Banking
4 235 (4.94%) Marketing
5 217 (4.56%) Advertising
6 74 (1.55%) Investment Banking
7 68 (1.43%) Legal
8 66 (1.39%) Games
9 53 (1.11%) Manufacturing
10 35 (0.74%) Publishing
11 34 (0.71%) Telecoms
12 32 (0.67%) Back Office
13 29 (0.61%) Corporate Banking
14 26 (0.55%) Law
15 23 (0.48%) General Ledger
16 22 (0.46%) Electronics
16 22 (0.46%) Front Office
17 20 (0.42%) Pharmaceutical
18 19 (0.40%) Local Government
19 17 (0.36%) Financial Institution
Job Titles
1 1,930 (40.54%) Developer
2 922 (19.37%) Business Intelligence Developer
3 808 (16.97%) Analyst
4 733 (15.40%) SQL Developer
5 569 (11.95%) Architect
6 362 (7.60%) Data Architect
7 352 (7.39%) Data Warehouse Developer
8 340 (7.14%) SSIS Developer
9 320 (6.72%) Consultant
10 302 (6.34%) SQL BI Developer
11 263 (5.52%) SSRS Developer
12 260 (5.46%) Business Intelligence Analyst
13 257 (5.40%) Data Engineer
14 251 (5.27%) Data Analyst
14 251 (5.27%) SQL Server Developer
15 238 (5.00%) Senior Developer
16 230 (4.83%) DBA
17 192 (4.03%) Business Developer
17 192 (4.03%) ETL Developer
18 180 (3.78%) SSAS Developer
Libraries, Frameworks & Software Standards
1 596 (12.52%) .NET
2 374 (7.86%) Web Services
3 260 (5.46%) XML
4 201 (4.22%) HTML
5 200 (4.20%) Kafka
6 191 (4.01%) MDX
7 144 (3.02%) JSON
8 136 (2.86%) .NET Framework
9 102 (2.14%) REST
10 100 (2.10%) CSS
11 99 (2.08%) Middleware
12 93 (1.95%) Entity Framework
13 92 (1.93%) SOAP
14 85 (1.79%) ASP.NET
15 63 (1.32%) RESTful
16 61 (1.28%) AngularJS
17 45 (0.95%) HTML5
18 39 (0.82%) J2EE
19 37 (0.78%) ASP.NET MVC
19 37 (0.78%) TensorFlow
Miscellaneous
1 679 (14.26%) Analytical Skills
2 226 (4.75%) Computer Science
3 208 (4.37%) Greenfield Project
4 183 (3.84%) Management Information System
5 172 (3.61%) Data Structures
6 136 (2.86%) Replication
7 113 (2.37%) User Experience
8 106 (2.23%) NHS
9 105 (2.21%) Algorithms
10 78 (1.64%) Enterprise Software
11 75 (1.58%) Fintech
12 64 (1.34%) Self-Motivation
13 61 (1.28%) Reinsurance
14 58 (1.22%) Clustering
15 55 (1.16%) Credit Risk
16 54 (1.13%) Equities
16 54 (1.13%) Reference Data
17 39 (0.82%) Hedge funds
18 37 (0.78%) Derivative
18 37 (0.78%) Market Risk
Operating Systems
1 269 (5.65%) Linux
2 267 (5.61%) Windows
3 252 (5.29%) Unix
4 78 (1.64%) Windows Server
5 59 (1.24%) AIX
6 47 (0.99%) Solaris
7 41 (0.86%) Red Hat Enterprise Linux
8 34 (0.71%) HPUX
9 29 (0.61%) Windows Server 2008
10 27 (0.57%) Windows Server 2012
11 13 (0.27%) Apple iOS
12 8 (0.17%) Android
13 7 (0.15%) CentOS
14 4 (0.084%) Kali Linux
14 4 (0.084%) Ubuntu
15 3 (0.063%) Windows 7
15 3 (0.063%) zOS
16 2 (0.042%) Mac OS X
16 2 (0.042%) Tru64
16 2 (0.042%) Windows XP
Processes & Methodologies
1 3,008 (63.18%) Business Intelligence
2 2,064 (43.35%) ETL
3 1,462 (30.71%) Agile Software Development
4 1,195 (25.10%) Analytics
5 937 (19.68%) Data Modelling
6 582 (12.22%) Visualisation
7 514 (10.80%) Data Analysis
8 494 (10.38%) Problem-Solving
9 435 (9.14%) Data Integration
10 432 (9.07%) Scrum
11 421 (8.84%) Data Management
12 409 (8.59%) Kimball Methodology
13 401 (8.42%) Migration
14 390 (8.19%) Data Architecture
15 372 (7.81%) Performance Tuning
16 357 (7.50%) SDLC
17 341 (7.16%) Data Analytics
18 323 (6.78%) Project Management
19 307 (6.45%) Data Science
20 299 (6.28%) Dimensional Modelling
Programming Languages
1 3,162 (66.41%) SQL
2 1,246 (26.17%) T-SQL
3 506 (10.63%) C#
4 498 (10.46%) Python
5 405 (8.51%) Java
6 323 (6.78%) PL/SQL
7 255 (5.36%) JavaScript
8 207 (4.35%) PowerShell
9 171 (3.59%) R
10 161 (3.38%) Data Analysis Expressions (DAX)
11 145 (3.05%) Scala
12 132 (2.77%) VBA
13 116 (2.44%) Shell Script
14 74 (1.55%) PHP
15 69 (1.45%) Go
16 50 (1.05%) VB.NET
17 49 (1.03%) VB
18 47 (0.99%) Perl
19 41 (0.86%) C
20 36 (0.76%) C++
Qualifications
1 525 (11.03%) Degree
2 111 (2.33%) Microsoft Certification
3 85 (1.79%) Computer Science Degree
4 81 (1.70%) Security Cleared
5 58 (1.22%) ISEB
6 50 (1.05%) SC Cleared
7 42 (0.88%) Master's Degree
8 31 (0.65%) MCSE
9 29 (0.61%) MCITP
10 28 (0.59%) MCSA
11 25 (0.53%) ITIL Certification
12 23 (0.48%) PMP
13 21 (0.44%) PMI Certification
13 21 (0.44%) TOGAF Certification
14 17 (0.36%) ITIL Foundation Certificate
14 17 (0.36%) Postgraduate
15 16 (0.34%) VMware Certified Professional (VCP)
16 14 (0.29%) ACCA
16 14 (0.29%) PRINCE2 Certification
17 12 (0.25%) Microsoft Certified Architect
Quality Assurance & Compliance
1 486 (10.21%) Data Quality
2 219 (4.60%) QA
3 105 (2.21%) GDPR
4 78 (1.64%) PMO
5 31 (0.65%) SLA
6 15 (0.32%) ISO/IEC 27001
7 11 (0.23%) Sarbanes-Oxley
8 10 (0.21%) IFRS
8 10 (0.21%) MiFID
8 10 (0.21%) Solvency II
9 9 (0.19%) PCI DSS
10 6 (0.13%) IFRS 9
11 5 (0.11%) GAAP
12 3 (0.063%) ISO 9001
13 2 (0.042%) ISO/IEC 20000
13 2 (0.042%) PSD2
13 2 (0.042%) TickIT
13 2 (0.042%) Web Application Security Consortium
14 1 (0.021%) CRD IV
14 1 (0.021%) EMIR
System Software
1 67 (1.41%) Apache Flume
1 67 (1.41%) HDFS
2 57 (1.20%) Active Directory
3 54 (1.13%) Docker
4 28 (0.59%) VMware Infrastructure
5 17 (0.36%) vSphere
6 16 (0.34%) Oracle RAC
7 9 (0.19%) Hyper-V
8 8 (0.17%) Apache ZooKeeper
9 7 (0.15%) Veritas Cluster Server
10 6 (0.13%) Virtual Machines
11 5 (0.11%) Tivoli Workload Scheduler
11 5 (0.11%) VMware Workstation
12 3 (0.063%) GPFS
13 1 (0.021%) Microsoft App-V
13 1 (0.021%) Terminal Services
13 1 (0.021%) VMware ESXi
13 1 (0.021%) Xen
Systems Management
1 40 (0.84%) Hadoop YARN
2 31 (0.65%) Automic
2 31 (0.65%) Opscode Chef
3 30 (0.63%) Puppet
4 29 (0.61%) Oozie
5 26 (0.55%) Ansible
5 26 (0.55%) Kubernetes
5 26 (0.55%) Oracle RMAN
5 26 (0.55%) Terraform
6 23 (0.48%) Oracle Enterprise Manager
7 20 (0.42%) Mesos
8 19 (0.40%) Kibana
9 18 (0.38%) Dollar Universe
9 18 (0.38%) Systems Management Server (SMS)
10 17 (0.36%) Data Guard
11 16 (0.34%) Control-M
12 13 (0.27%) Tivoli
13 10 (0.21%) Failover Clustering
14 9 (0.19%) Backup Exec
15 8 (0.17%) SCCM
Vendors
1 1,728 (36.29%) Microsoft
2 822 (17.27%) Oracle
3 674 (14.16%) Tableau
4 295 (6.20%) Informatica
5 254 (5.34%) Cognos
6 246 (5.17%) SAP
7 157 (3.30%) IBM
8 143 (3.00%) Google
9 129 (2.71%) Talend
10 86 (1.81%) MicroStrategy
11 81 (1.70%) Cloudera
12 75 (1.58%) Teradata
13 66 (1.39%) VMware
14 58 (1.22%) Salesforce.com
15 50 (1.05%) Hortonworks
16 44 (0.92%) Red Hat
17 42 (0.88%) Alteryx
18 39 (0.82%) MapR
19 38 (0.80%) Netezza
20 36 (0.76%) Databricks