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

Data Warehousing
UK
6 months to
17 Jul 2018
Same period 2017 Same period 2016
Rank 114 110 92
Rank change year-on-year -4 -18 -1
Permanent jobs citing Data Warehouse 4,986 5,105 6,163
As % of all permanent IT jobs advertised in the UK 2.84% 2.87% 3.03%
As % of the Database & Business Intelligence category 9.32% 9.36% 10.01%
Number of salaries quoted 4,029 4,245 5,098
UK median annual salary £52,500 £50,000 £52,500
Median salary % change year-on-year +5.00% -4.76% +5.00%
10th Percentile £34,471 £32,500 £33,125
90th Percentile £85,000 £78,750 £78,750
UK excluding London median annual salary £45,000 £45,000 £45,000

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 53,483 54,545 61,541
As % of all permanent IT jobs advertised in the UK 30.42% 30.71% 30.27%
Number of salaries quoted 43,592 45,819 52,460
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £29,500 £28,750
90th Percentile £81,250 £77,500 £75,000
UK excluding London median annual salary £45,000 £42,500 £41,000
% change year-on-year +5.88% +3.66% +2.50%

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 17 July 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 17 July 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 -1 4,740 £52,500 +5.00% 603
UK excluding London -4 2,446 £45,000 - 349
London +9 2,443 £62,500 +4.17% 288
North of England -26 695 £45,000 +5.88% 105
South East +12 634 £52,500 +5.00% 76
Midlands +5 423 £43,500 -3.33% 62
North West -15 365 £45,000 +12.50% 52
Yorkshire -26 282 £45,000 - 45
East of England +39 269 £50,000 +5.26% 28
South West +10 250 £42,500 +1.19% 42
West Midlands -6 220 £45,000 +4.65% 31
East Midlands +18 203 £42,500 -5.56% 31
Scotland -59 131 £45,000 - 17
Wales +32 63 £43,750 +9.38% 15
North East +15 48 £41,500 -7.78% 8
Northern Ireland +3 3 £30,000 -14.29% 3
Channel Islands - 3 £45,000 - 1

For the 6 months to 17 July 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,273 (65.64%) SQL
2 3,192 (64.02%) Business Intelligence
3 2,614 (52.43%) SQL Server
4 2,258 (45.29%) SQL Server Integration Services
5 2,151 (43.14%) ETL
6 1,864 (37.38%) SQL Server Reporting Services
7 1,740 (34.90%) Microsoft
8 1,556 (31.21%) SQL Server Analysis Services
9 1,480 (29.68%) Agile Software Development
10 1,359 (27.26%) T-SQL
11 1,349 (27.06%) Finance
12 1,198 (24.03%) Analytics
13 1,050 (21.06%) Power BI
14 1,025 (20.56%) Data Modelling
15 904 (18.13%) Oracle
16 848 (17.01%) Big Data
17 770 (15.44%) Microsoft Azure
18 713 (14.30%) Analytical Skills
19 646 (12.96%) Tableau
20 586 (11.75%) .NET
21 563 (11.29%) Visualisation
22 527 (10.57%) Relational Database
23 526 (10.55%) Degree
24 524 (10.51%) Problem-Solving
25 511 (10.25%) Data Quality
26 506 (10.15%) Python
27 502 (10.07%) Data Analysis
28 473 (9.49%) Java
29 469 (9.41%) C#
30 452 (9.07%) Hadoop

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 257 (5.15%) Apache Spark
2 222 (4.45%) SAS
3 115 (2.31%) SharePoint
4 68 (1.36%) Apache
5 55 (1.10%) IIS
6 45 (0.90%) BizTalk Server
7 44 (0.88%) Confluence
8 41 (0.82%) Oracle SOA Suite
9 30 (0.60%) Elasticsearch
10 26 (0.52%) Apache Pig
11 23 (0.46%) CMS
12 20 (0.40%) Apache Solr
13 16 (0.32%) WebLogic
14 15 (0.30%) WebSphere
15 12 (0.24%) Hyperledger
15 12 (0.24%) Oracle Application Server
16 11 (0.22%) Skype for Business
17 10 (0.20%) Documentum
17 10 (0.20%) FileNet
17 10 (0.20%) MS Exchange
Applications
1 369 (7.40%) Microsoft Excel
2 99 (1.99%) Microsoft Office
3 76 (1.52%) MS Visio
4 37 (0.74%) Microsoft PowerPoint
5 25 (0.50%) Microsoft Project
6 19 (0.38%) Spreadsheet
7 9 (0.18%) SPSS
8 3 (0.060%) Stata
9 2 (0.040%) Photoshop
10 1 (0.020%) Adobe Illustrator
10 1 (0.020%) Chatbot
10 1 (0.020%) CPLEX
10 1 (0.020%) EViews
10 1 (0.020%) Weka
Business Applications
1 50 (1.00%) Cognos Business Intelligence
2 49 (0.98%) Dynamics CRM
2 49 (0.98%) Markit EDM
3 39 (0.78%) Cognos TM1
4 33 (0.66%) NetSuite
5 26 (0.52%) Dynamics AX
6 19 (0.38%) Oracle EBS
7 17 (0.34%) SAP S/4HANA
8 13 (0.26%) Salesforce.com CRM
9 12 (0.24%) Remedy ITSM
10 11 (0.22%) Dynamics NAV
10 11 (0.22%) Oracle EBS R12
11 9 (0.18%) MetaTrader
12 8 (0.16%) FastStats
12 8 (0.16%) SAP ERP
13 6 (0.12%) SAP BPC
13 6 (0.12%) SAP CO
13 6 (0.12%) SAP FI
13 6 (0.12%) SAP FI/CO
14 4 (0.080%) JDE EnterpriseOne
Cloud Services
1 770 (15.44%) Microsoft Azure
2 435 (8.72%) Amazon AWS
3 147 (2.95%) Azure Data Factory
4 72 (1.44%) Cloud Computing
5 66 (1.32%) Google Cloud Platform
6 64 (1.28%) SaaS
7 61 (1.22%) Office 365
8 58 (1.16%) PaaS
9 39 (0.78%) Amazon S3
10 35 (0.70%) Amazon EMR
11 33 (0.66%) Serverless
12 29 (0.58%) Amazon Kinesis
12 29 (0.58%) Cortana Intelligence Suite
13 26 (0.52%) Dynamics 365
14 25 (0.50%) Amazon EC2
14 25 (0.50%) IaaS
15 23 (0.46%) Data Lake Analytics
16 22 (0.44%) Amazon ElastiCache
16 22 (0.44%) AWS Lambda
17 18 (0.36%) Google Analytics
Communications & Networking
1 60 (1.20%) Internet
2 34 (0.68%) Firewall
3 33 (0.66%) DNS
4 29 (0.58%) HTTP
5 25 (0.50%) SAN
6 24 (0.48%) LAN
7 23 (0.46%) DHCP
7 23 (0.46%) SSL
8 22 (0.44%) WAN
9 21 (0.42%) TCP/IP
10 18 (0.36%) SMS
11 17 (0.34%) Wireless
12 15 (0.30%) Network Security
13 12 (0.24%) Intranet
14 11 (0.22%) Skype
15 9 (0.18%) ICMP
15 9 (0.18%) OSPF
15 9 (0.18%) SNMP
15 9 (0.18%) VoIP
16 8 (0.16%) FTP
Database & Business Intelligence
1 2,614 (52.43%) SQL Server
2 2,258 (45.29%) SQL Server Integration Services
3 1,864 (37.38%) SQL Server Reporting Services
4 1,556 (31.21%) SQL Server Analysis Services
5 1,050 (21.06%) Power BI
6 848 (17.01%) Big Data
7 527 (10.57%) Relational Database
8 452 (9.07%) Hadoop
9 340 (6.82%) BusinessObjects
10 331 (6.64%) OLAP
11 326 (6.54%) SQL Server 2016
12 319 (6.40%) QlikView
13 318 (6.38%) SQL Server 2012
14 298 (5.98%) Data Lake
15 288 (5.78%) Microsoft Analysis Services
16 279 (5.60%) SQL Server 2014
17 247 (4.95%) SQL Server 2008
18 241 (4.83%) NoSQL
19 228 (4.57%) MySQL
20 208 (4.17%) Apache Hive
Development Applications
1 189 (3.79%) Team Foundation Server
2 147 (2.95%) Visual Studio
3 130 (2.61%) JIRA
4 113 (2.27%) SQL Server Management Studio (SSMS)
5 111 (2.23%) Git (software)
6 110 (2.21%) Jenkins
7 87 (1.74%) TeamCity
8 70 (1.40%) ERwin
9 40 (0.80%) Selenium
10 35 (0.70%) Oracle Forms
11 32 (0.64%) Subversion
11 32 (0.64%) Toad
12 28 (0.56%) Visual Studio Team System
13 25 (0.50%) Oracle APEX
14 22 (0.44%) JUnit
15 20 (0.40%) Octopus Deploy
16 19 (0.38%) Eclipse
16 19 (0.38%) SoapUI
17 17 (0.34%) Bitbucket
18 16 (0.32%) RStudio
General
1 1,349 (27.06%) Finance
2 402 (8.06%) Retail
3 282 (5.66%) Banking
4 271 (5.44%) Advertising
5 257 (5.15%) Marketing
6 73 (1.46%) Games
7 63 (1.26%) Legal
8 61 (1.22%) Manufacturing
9 51 (1.02%) Investment Banking
10 39 (0.78%) Telecoms
11 37 (0.74%) Publishing
12 34 (0.68%) Law
13 29 (0.58%) Back Office
14 26 (0.52%) Electronics
15 25 (0.50%) Front Office
16 23 (0.46%) Financial Institution
17 22 (0.44%) Pharmaceutical
18 20 (0.40%) Automotive
19 19 (0.38%) Local Government
20 18 (0.36%) Billing
Job Titles
1 2,108 (42.28%) Developer
2 1,049 (21.04%) Business Intelligence Developer
3 787 (15.78%) Analyst
3 787 (15.78%) SQL Developer
4 572 (11.47%) Architect
5 385 (7.72%) Data Warehouse Developer
6 371 (7.44%) SSIS Developer
7 360 (7.22%) Data Architect
8 347 (6.96%) SQL BI Developer
9 328 (6.58%) Consultant
10 287 (5.76%) SSRS Developer
11 279 (5.60%) Business Intelligence Analyst
12 277 (5.56%) SQL Server Developer
13 271 (5.44%) DBA
14 255 (5.11%) Data Engineer
15 229 (4.59%) Data Analyst
15 229 (4.59%) Senior Developer
16 210 (4.21%) Business Developer
17 198 (3.97%) ETL Developer
18 186 (3.73%) SQL DBA
Libraries, Frameworks & Software Standards
1 586 (11.75%) .NET
2 353 (7.08%) Web Services
3 280 (5.62%) XML
4 217 (4.35%) HTML
5 190 (3.81%) MDX
6 187 (3.75%) Kafka
7 148 (2.97%) JSON
8 135 (2.71%) .NET Framework
9 118 (2.37%) SOAP
10 113 (2.27%) CSS
11 112 (2.25%) REST
12 94 (1.89%) Entity Framework
13 88 (1.76%) RESTful
14 83 (1.66%) Middleware
15 65 (1.30%) ASP.NET
16 56 (1.12%) AngularJS
17 53 (1.06%) TensorFlow
18 50 (1.00%) jQuery
19 48 (0.96%) HTML5
20 43 (0.86%) MLlib
Miscellaneous
1 713 (14.30%) Analytical Skills
2 250 (5.01%) Computer Science
3 221 (4.43%) Greenfield Project
4 206 (4.13%) Management Information System
5 136 (2.73%) Replication
6 133 (2.67%) Data Structures
7 129 (2.59%) User Experience
8 118 (2.37%) NHS
9 112 (2.25%) Algorithms
10 105 (2.11%) Self-Motivation
11 103 (2.07%) Fintech
12 99 (1.99%) Enterprise Software
13 64 (1.28%) Clustering
14 48 (0.96%) Credit Risk
15 46 (0.92%) Virtual Team
16 44 (0.88%) Hedge funds
17 43 (0.86%) Data Centre
18 42 (0.84%) Equities
19 41 (0.82%) Reinsurance
20 33 (0.66%) Market Risk
Operating Systems
1 314 (6.30%) Linux
2 272 (5.46%) Windows
3 228 (4.57%) Unix
4 82 (1.64%) Windows Server
5 51 (1.02%) AIX
6 41 (0.82%) Solaris
7 31 (0.62%) HPUX
7 31 (0.62%) Windows Server 2008
8 23 (0.46%) Windows Server 2012
9 17 (0.34%) Red Hat Enterprise Linux
10 9 (0.18%) Android
10 9 (0.18%) Windows 8
10 9 (0.18%) Windows XP
11 8 (0.16%) Windows Server 2003
12 7 (0.14%) Apple iOS
13 6 (0.12%) CentOS
14 5 (0.10%) zOS
15 4 (0.080%) Mac OS X
15 4 (0.080%) Oracle Linux
15 4 (0.080%) Windows Vista
Processes & Methodologies
1 3,192 (64.02%) Business Intelligence
2 2,151 (43.14%) ETL
3 1,480 (29.68%) Agile Software Development
4 1,198 (24.03%) Analytics
5 1,025 (20.56%) Data Modelling
6 563 (11.29%) Visualisation
7 524 (10.51%) Problem-Solving
8 502 (10.07%) Data Analysis
9 439 (8.80%) Data Integration
10 434 (8.70%) Kimball Methodology
11 428 (8.58%) Scrum
12 415 (8.32%) Migration
12 415 (8.32%) Performance Tuning
13 413 (8.28%) Data Management
14 402 (8.06%) Data Architecture
15 373 (7.48%) SDLC
16 326 (6.54%) Data Science
17 316 (6.34%) Data Analytics
18 304 (6.10%) Project Management
19 288 (5.78%) Data Visualisation
Programming Languages
1 3,273 (65.64%) SQL
2 1,359 (27.26%) T-SQL
3 506 (10.15%) Python
4 473 (9.49%) Java
5 469 (9.41%) C#
6 323 (6.48%) PL/SQL
7 260 (5.21%) JavaScript
8 207 (4.15%) PowerShell
9 191 (3.83%) R
10 169 (3.39%) Scala
11 143 (2.87%) Data Analysis Expressions (DAX)
12 127 (2.55%) Shell Script
13 126 (2.53%) VBA
14 82 (1.64%) Go
15 78 (1.56%) PHP
16 58 (1.16%) C++
17 53 (1.06%) VB
18 52 (1.04%) VB.NET
19 46 (0.92%) Perl
20 45 (0.90%) C
Qualifications
1 526 (10.55%) Degree
2 131 (2.63%) Microsoft Certification
3 87 (1.74%) Security Cleared
4 81 (1.62%) Computer Science Degree
5 70 (1.40%) ISEB
6 55 (1.10%) SC Cleared
7 49 (0.98%) MCSE
8 47 (0.94%) ITIL Certification
9 44 (0.88%) Master's Degree
10 39 (0.78%) MCSA
11 29 (0.58%) Numerate Degree
12 27 (0.54%) TOGAF Certification
13 26 (0.52%) PMI Certification
13 26 (0.52%) PMP
13 26 (0.52%) Postgraduate
14 24 (0.48%) MCITP
15 22 (0.44%) ISTQB
16 15 (0.30%) ITIL Foundation Certificate
16 15 (0.30%) Microsoft Certified Architect
17 13 (0.26%) MCP
Quality Assurance & Compliance
1 511 (10.25%) Data Quality
2 248 (4.97%) QA
3 103 (2.07%) GDPR
4 78 (1.56%) PMO
5 40 (0.80%) SLA
6 13 (0.26%) Sarbanes-Oxley
7 9 (0.18%) IFRS
7 9 (0.18%) Solvency II
8 8 (0.16%) GCP
8 8 (0.16%) IFRS 9
8 8 (0.16%) MiFID
9 7 (0.14%) PCI DSS
10 5 (0.10%) GAAP
10 5 (0.10%) ISO/IEC 20000
10 5 (0.10%) Web Application Security Consortium
11 3 (0.060%) HL7
11 3 (0.060%) ISO/IEC 27001
12 2 (0.040%) COBIT
12 2 (0.040%) PSD2
12 2 (0.040%) TickIT
System Software
1 97 (1.95%) HDFS
2 83 (1.66%) Apache Flume
3 66 (1.32%) Active Directory
4 50 (1.00%) VMware Infrastructure
5 46 (0.92%) Docker
6 13 (0.26%) Oracle RAC
6 13 (0.26%) vSphere
7 12 (0.24%) Apache ZooKeeper
8 11 (0.22%) Hyper-V
9 8 (0.16%) XenApp
10 5 (0.10%) VMware Workstation
11 4 (0.080%) Virtual Machines
11 4 (0.080%) Xen
12 3 (0.060%) Veritas Cluster Server
13 2 (0.040%) VMware ESXi
14 1 (0.020%) Microsoft App-V
Systems Management
1 61 (1.22%) Hadoop YARN
2 37 (0.74%) Oozie
3 26 (0.52%) Systems Management Server (SMS)
4 23 (0.46%) Kibana
5 21 (0.42%) Puppet
6 20 (0.40%) Mesos
6 20 (0.40%) Oracle Enterprise Manager
7 19 (0.38%) Terraform
8 18 (0.36%) Ansible
8 18 (0.36%) Data Guard
8 18 (0.36%) Opscode Chef
9 17 (0.34%) Automic
9 17 (0.34%) Control-M
9 17 (0.34%) Failover Clustering
10 16 (0.32%) Dollar Universe
10 16 (0.32%) Kubernetes
11 15 (0.30%) Ambari
12 12 (0.24%) Oracle RMAN
13 10 (0.20%) Backup Exec
13 10 (0.20%) SCCM
Vendors
1 1,740 (34.90%) Microsoft
2 904 (18.13%) Oracle
3 646 (12.96%) Tableau
4 288 (5.78%) Informatica
5 260 (5.21%) SAP
6 206 (4.13%) Cognos
7 150 (3.01%) IBM
8 149 (2.99%) Talend
9 111 (2.23%) Google
10 100 (2.01%) Cloudera
11 93 (1.87%) MicroStrategy
12 74 (1.48%) VMware
13 72 (1.44%) Salesforce.com
14 71 (1.42%) Teradata
15 54 (1.08%) Hortonworks
16 46 (0.92%) HP
17 40 (0.80%) Netezza
18 39 (0.78%) Alteryx
18 39 (0.78%) Cognizant
18 39 (0.78%) RedGate