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

Data Warehousing
UK
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 120 104 79
Rank change year-on-year -16 -25 +19
Permanent jobs citing Data Warehouse 4,668 5,024 7,248
As % of all permanent IT jobs advertised in the UK 2.70% 2.84% 3.47%
As % of the Database & Business Intelligence category 8.83% 9.50% 10.99%
Number of salaries quoted 3,733 4,328 6,059
UK median annual salary £50,000 £54,000 £50,000
Median salary % change year-on-year -7.41% +8.00% -4.76%
10th Percentile £32,500 £33,000 £32,500
90th Percentile £77,500 £82,500 £78,750
UK excluding London median annual salary £45,000 £47,500 £45,000
% change year-on-year -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 52,890 52,873 65,970
As % of all permanent IT jobs advertised in the UK 30.55% 29.87% 31.62%
Number of salaries quoted 43,850 45,259 55,738
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% +1.12%
10th Percentile £30,000 £29,375 £28,750
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,500
% change year-on-year - +4.94% +1.25%

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

Salary histogram for Data Warehouse in the UK

Data Warehouse
Top 18 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 20 January 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 -17 4,387 £51,000 -7.27% 574
UK excluding London -7 2,374 £45,000 -5.26% 353
London -16 2,193 £59,250 -1.25% 263
North of England +7 700 £45,000 +5.88% 100
South East -31 560 £48,000 -8.57% 71
Midlands -3 409 £47,000 +4.44% 66
North West -2 367 £45,000 +12.50% 58
Yorkshire +18 303 £45,750 +7.65% 36
South West +73 291 £41,500 -7.78% 39
West Midlands +15 289 £50,000 +17.65% 35
East of England -24 222 £55,000 +4.76% 33
Scotland -35 147 £45,000 -10.00% 27
East Midlands -18 118 £42,500 -5.56% 31
Wales -2 37 £35,000 -12.50% 15
North East -10 30 £35,250 -4.73% 6
Channel Islands +3 4 £60,000 -
Isle of Man -3 4 £50,000 -50.00%
Northern Ireland -23 3 £40,000 - 2

For the 6 months to 20 January 2018, IT jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for Data Warehouse.

1 3,124 (66.92%) Business Intelligence
2 3,102 (66.45%) SQL
3 2,286 (48.97%) SQL Server
4 2,058 (44.09%) ETL
5 1,818 (38.95%) SQL Server Integration Services
6 1,553 (33.27%) SQL Server Reporting Services
7 1,403 (30.06%) Microsoft
8 1,351 (28.94%) Finance
9 1,294 (27.72%) SQL Server Analysis Services
10 1,213 (25.99%) Analytics
11 1,203 (25.77%) Agile Software Development
12 1,181 (25.30%) T-SQL
13 1,146 (24.55%) Data Modelling
14 881 (18.87%) Oracle
15 869 (18.62%) Power BI
16 826 (17.69%) Analytical Skills
17 791 (16.95%) Tableau
18 712 (15.25%) Big Data
19 672 (14.40%) Visualisation
20 581 (12.45%) Microsoft Azure
21 549 (11.76%) Data Management
22 543 (11.63%) Python
23 488 (10.45%) QlikView
24 484 (10.37%) BusinessObjects
25 476 (10.20%) Degree
26 423 (9.06%) Relational Database
27 422 (9.04%) Data Quality
28 417 (8.93%) Hadoop
29 407 (8.72%) Kimball Methodology
29 407 (8.72%) 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 241 (5.16%) Apache Spark
2 198 (4.24%) SAS
3 143 (3.06%) SharePoint
4 32 (0.69%) Apache
4 32 (0.69%) Apache Pig
5 31 (0.66%) Confluence
6 26 (0.56%) CMS
7 24 (0.51%) IIS
8 23 (0.49%) Oracle SOA Suite
9 21 (0.45%) Elasticsearch
10 20 (0.43%) Apache Airflow
10 20 (0.43%) Apache Solr
10 20 (0.43%) JBoss
11 19 (0.41%) Tomcat
12 16 (0.34%) WebSphere
13 14 (0.30%) BizTalk Server
14 11 (0.24%) Drupal
15 10 (0.21%) MS Exchange
15 10 (0.21%) nginx
15 10 (0.21%) SharePoint 2010
Applications
1 382 (8.18%) Microsoft Excel
2 90 (1.93%) Microsoft Office
3 86 (1.84%) Microsoft PowerPoint
4 51 (1.09%) MS Visio
5 38 (0.81%) SPSS
6 19 (0.41%) Microsoft Project
7 5 (0.11%) Mingle
7 5 (0.11%) Spreadsheet
8 1 (0.021%) InfoPath
8 1 (0.021%) S-PLUS
8 1 (0.021%) SPSS Modeler
8 1 (0.021%) Weka
Business Applications
1 35 (0.75%) Cognos Business Intelligence
2 30 (0.64%) Dynamics CRM
3 28 (0.60%) Dynamics AX
4 15 (0.32%) Cognos TM1
5 14 (0.30%) JDE EnterpriseOne
6 13 (0.28%) HFM
7 12 (0.26%) Dynamics NAV
7 12 (0.26%) Markit EDM
7 12 (0.26%) Oracle EBS
7 12 (0.26%) SAP ERP
8 9 (0.19%) BusinessWorks
8 9 (0.19%) Salesforce.com CRM
8 9 (0.19%) TIBCO BusinessEvents
9 8 (0.17%) NetSuite
9 8 (0.17%) Oracle ERP
9 8 (0.17%) Unit4 Business World
10 7 (0.15%) Eikon
10 7 (0.15%) MetaTrader
10 7 (0.15%) Oracle EBS R12
10 7 (0.15%) SAP Business ByDesign
Cloud Services
1 581 (12.45%) Microsoft Azure
2 342 (7.33%) Amazon AWS
3 101 (2.16%) Azure Data Factory
4 90 (1.93%) Google Cloud Platform
5 54 (1.16%) PaaS
5 54 (1.16%) SaaS
6 49 (1.05%) Azure Machine Learning
7 47 (1.01%) Cloud Computing
8 35 (0.75%) Cortana Intelligence Suite
9 34 (0.73%) Office 365
10 24 (0.51%) Amazon Kinesis
11 23 (0.49%) IaaS
12 19 (0.41%) Amazon ElastiCache
12 19 (0.41%) Amazon EMR
13 18 (0.39%) Amazon S3
13 18 (0.39%) GitHub
14 15 (0.32%) Dynamics 365
15 13 (0.28%) Google Analytics
16 12 (0.26%) Serverless
17 8 (0.17%) Data Lake Analytics
Communications & Networking
1 60 (1.29%) Internet
2 58 (1.24%) HTTP
3 50 (1.07%) SSL
4 39 (0.84%) TCP/IP
5 34 (0.73%) Firewall
6 30 (0.64%) DNS
7 21 (0.45%) SMS
8 14 (0.30%) LAN
8 14 (0.30%) SAN
9 13 (0.28%) Intranet
9 13 (0.28%) WAN
10 11 (0.24%) VLAN
11 9 (0.19%) DHCP
12 5 (0.11%) NAS
13 4 (0.086%) Wireless
14 3 (0.064%) Cisco ASA
14 3 (0.064%) IPsec
14 3 (0.064%) Remote Desktop
14 3 (0.064%) VPN
15 2 (0.043%) SNMP
Database & Business Intelligence
1 2,286 (48.97%) SQL Server
2 1,818 (38.95%) SQL Server Integration Services
3 1,553 (33.27%) SQL Server Reporting Services
4 1,294 (27.72%) SQL Server Analysis Services
5 869 (18.62%) Power BI
6 712 (15.25%) Big Data
7 488 (10.45%) QlikView
8 484 (10.37%) BusinessObjects
9 423 (9.06%) Relational Database
10 417 (8.93%) Hadoop
11 378 (8.10%) SQL Server 2016
12 361 (7.73%) OLAP
13 349 (7.48%) SQL Server 2014
14 321 (6.88%) SQL Server 2012
15 264 (5.66%) Microsoft Analysis Services
16 221 (4.73%) NoSQL
17 217 (4.65%) SQL Server 2008
18 206 (4.41%) MySQL
19 187 (4.01%) Data Lake
20 175 (3.75%) Enterprise Data Warehouse
Development Applications
1 203 (4.35%) Team Foundation Server
2 149 (3.19%) JIRA
3 134 (2.87%) Visual Studio
4 101 (2.16%) SQL Server Management Studio (SSMS)
5 97 (2.08%) Git (software)
6 64 (1.37%) ERwin
7 57 (1.22%) Jenkins
8 52 (1.11%) Toad
9 50 (1.07%) Subversion
10 44 (0.94%) TeamCity
11 36 (0.77%) Selenium
12 31 (0.66%) Eclipse
12 31 (0.66%) Oracle Forms
13 30 (0.64%) Atlassian Bamboo
13 30 (0.64%) Bitbucket
14 25 (0.54%) Maven
15 21 (0.45%) Oracle APEX
16 18 (0.39%) JUnit
17 15 (0.32%) PowerBuilder
18 13 (0.28%) HP UFT
General
1 1,351 (28.94%) Finance
2 357 (7.65%) Banking
3 253 (5.42%) Retail
4 244 (5.23%) Marketing
5 217 (4.65%) Advertising
6 203 (4.35%) Investment Banking
7 198 (4.24%) Retail Banking
8 94 (2.01%) Manufacturing
9 90 (1.93%) Publishing
10 81 (1.74%) Games
11 61 (1.31%) Legal
11 61 (1.31%) Telecoms
12 49 (1.05%) Electronics
13 40 (0.86%) Law
14 25 (0.54%) Automotive
14 25 (0.54%) Back Office
15 23 (0.49%) Front Office
16 21 (0.45%) Financial Institution
17 14 (0.30%) Pharmaceutical
18 12 (0.26%) Polish Language
Job Titles
1 2,024 (43.36%) Developer
2 1,016 (21.77%) Business Intelligence Developer
3 771 (16.52%) Analyst
4 714 (15.30%) SQL Developer
5 528 (11.31%) Architect
6 398 (8.53%) Data Warehouse Developer
7 349 (7.48%) SQL BI Developer
8 342 (7.33%) Data Architect
9 319 (6.83%) Consultant
10 277 (5.93%) SSIS Developer
11 266 (5.70%) Business Developer
12 263 (5.63%) Business Intelligence Analyst
13 255 (5.46%) SQL Server Developer
14 231 (4.95%) DBA
15 220 (4.71%) Data Analyst
16 216 (4.63%) SSRS Developer
17 205 (4.39%) Business Analyst
18 191 (4.09%) ETL Developer
18 191 (4.09%) SQL DBA
19 189 (4.05%) Senior Developer
Libraries, Frameworks & Software Standards
1 354 (7.58%) .NET
2 276 (5.91%) Web Services
3 211 (4.52%) MDX
4 194 (4.16%) XML
5 177 (3.79%) HTML
6 134 (2.87%) JSON
7 130 (2.78%) CSS
8 92 (1.97%) ASP.NET
8 92 (1.97%) Kafka
9 81 (1.74%) AngularJS
10 75 (1.61%) SOAP
11 71 (1.52%) Middleware
12 67 (1.44%) REST
13 62 (1.33%) Spring
14 60 (1.29%) jQuery
15 57 (1.22%) HTML5
16 52 (1.11%) .NET Framework
17 51 (1.09%) Oracle GoldenGate
17 51 (1.09%) RESTful
18 44 (0.94%) J2EE
Miscellaneous
1 826 (17.69%) Analytical Skills
2 228 (4.88%) Computer Science
3 210 (4.50%) Management Information System
4 181 (3.88%) Data Structures
5 143 (3.06%) Enterprise Software
6 113 (2.42%) Greenfield Project
7 107 (2.29%) Replication
8 97 (2.08%) Algorithms
9 96 (2.06%) Clustering
10 90 (1.93%) User Experience
11 88 (1.89%) Fintech
12 86 (1.84%) Virtual Team
13 65 (1.39%) NHS
14 50 (1.07%) Data Centre
15 38 (0.81%) Reference Data
16 37 (0.79%) Mobile App
17 31 (0.66%) Credit Risk
18 29 (0.62%) PMI
19 28 (0.60%) Equities
20 27 (0.58%) N-Tier
Operating Systems
1 208 (4.46%) Unix
2 196 (4.20%) Linux
3 162 (3.47%) Windows
4 69 (1.48%) Windows Server
5 29 (0.62%) Windows Server 2012
6 28 (0.60%) AIX
6 28 (0.60%) Windows Server 2008
7 18 (0.39%) Android
7 18 (0.39%) Apple iOS
8 7 (0.15%) Red Hat Enterprise Linux
9 5 (0.11%) Solaris
10 4 (0.086%) zOS
11 3 (0.064%) Oracle Linux
11 3 (0.064%) Windows 7
11 3 (0.064%) Windows Server 2003
11 3 (0.064%) Windows XP
12 2 (0.043%) Windows 10
12 2 (0.043%) Windows 8
13 1 (0.021%) CentOS
13 1 (0.021%) Ubuntu
Processes & Methodologies
1 3,124 (66.92%) Business Intelligence
2 2,058 (44.09%) ETL
3 1,213 (25.99%) Analytics
4 1,203 (25.77%) Agile Software Development
5 1,146 (24.55%) Data Modelling
6 672 (14.40%) Visualisation
7 549 (11.76%) Data Management
8 407 (8.72%) Data Integration
8 407 (8.72%) Kimball Methodology
9 392 (8.40%) Data Visualisation
10 388 (8.31%) Data Architecture
11 386 (8.27%) Data Analysis
12 377 (8.08%) Performance Tuning
13 356 (7.63%) Migration
14 351 (7.52%) Data Analytics
15 322 (6.90%) SDLC
16 316 (6.77%) Scrum
17 309 (6.62%) Dimensional Modelling
18 295 (6.32%) Stakeholder Management
19 293 (6.28%) Asset Management
Programming Languages
1 3,102 (66.45%) SQL
2 1,181 (25.30%) T-SQL
3 543 (11.63%) Python
4 406 (8.70%) Java
5 349 (7.48%) C#
6 331 (7.09%) PL/SQL
7 244 (5.23%) R
8 191 (4.09%) JavaScript
9 122 (2.61%) Scala
10 119 (2.55%) PowerShell
11 105 (2.25%) VBA
12 89 (1.91%) Shell Script
13 82 (1.76%) Data Analysis Expressions (DAX)
13 82 (1.76%) Perl
14 68 (1.46%) C++
14 68 (1.46%) PHP
15 57 (1.22%) VB
15 57 (1.22%) VB.NET
16 56 (1.20%) C
17 37 (0.79%) Ruby
Qualifications
1 476 (10.20%) Degree
2 109 (2.34%) Computer Science Degree
3 75 (1.61%) Microsoft Certification
4 60 (1.29%) Security Cleared
5 46 (0.99%) ISEB
6 41 (0.88%) Numerate Degree
7 39 (0.84%) SC Cleared
8 37 (0.79%) MCSA
9 33 (0.71%) PMI Certification
10 32 (0.69%) MCSE
11 26 (0.56%) ISTQB
12 25 (0.54%) Master's Degree
13 21 (0.45%) PMP
14 20 (0.43%) ITIL Certification
15 19 (0.41%) MBA
16 16 (0.34%) PhD
17 14 (0.30%) Six Sigma Black Belt
17 14 (0.30%) Six Sigma Green Belt
18 10 (0.21%) MCDBA
19 8 (0.17%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 422 (9.04%) Data Quality
2 277 (5.93%) QA
3 85 (1.82%) GDPR
4 31 (0.66%) PMO
5 21 (0.45%) SLA
6 20 (0.43%) GCP
7 15 (0.32%) PCI DSS
7 15 (0.32%) Solvency II
8 11 (0.24%) ISO/IEC 27001
9 10 (0.21%) Web Application Security Consortium
10 5 (0.11%) NEBOSH
11 2 (0.043%) COBIT
11 2 (0.043%) IFRS
11 2 (0.043%) IFRS 9
11 2 (0.043%) TickIT
12 1 (0.021%) Basel III
12 1 (0.021%) BS7666
12 1 (0.021%) GAAP
12 1 (0.021%) ISO/IEC 20000
12 1 (0.021%) Sarbanes-Oxley
System Software
1 43 (0.92%) Active Directory
2 34 (0.73%) HDFS
2 34 (0.73%) VMware Infrastructure
3 32 (0.69%) Docker
4 28 (0.60%) Apache Flume
5 14 (0.30%) Oracle RAC
6 8 (0.17%) Hyper-V
7 6 (0.13%) Virtual Machines
8 4 (0.086%) GPFS
9 3 (0.064%) Firmware
9 3 (0.064%) VMware ESXi
9 3 (0.064%) XenApp
10 2 (0.043%) Apache ZooKeeper
11 1 (0.021%) Microsoft App-V
11 1 (0.021%) Microsoft Virtual Server
11 1 (0.021%) PowerHA
11 1 (0.021%) Virtual Servers
Systems Management
1 22 (0.47%) Oozie
2 12 (0.26%) Hadoop YARN
2 12 (0.26%) Systems Management Server (SMS)
3 11 (0.24%) SCCM
4 10 (0.21%) Mesos
5 7 (0.15%) FortiGate
5 7 (0.15%) Kubernetes
5 7 (0.15%) Microsoft Clustering
6 6 (0.13%) Ansible
6 6 (0.13%) Nagios
6 6 (0.13%) Perfmon
6 6 (0.13%) Puppet
6 6 (0.13%) Terraform
7 5 (0.11%) Failover Clustering
7 5 (0.11%) Kibana
7 5 (0.11%) Opscode Chef
7 5 (0.11%) Tivoli
8 4 (0.086%) HP Quality Center
8 4 (0.086%) Oracle Enterprise Manager
9 3 (0.064%) OpenView
Vendors
1 1,403 (30.06%) Microsoft
2 881 (18.87%) Oracle
3 791 (16.95%) Tableau
4 361 (7.73%) SAP
5 244 (5.23%) Cognos
6 237 (5.08%) Informatica
7 148 (3.17%) IBM
7 148 (3.17%) Talend
8 140 (3.00%) Google
8 140 (3.00%) Teradata
9 124 (2.66%) MicroStrategy
10 68 (1.46%) Cloudera
11 63 (1.35%) Netezza
12 60 (1.29%) Alteryx
12 60 (1.29%) Salesforce.com
13 44 (0.94%) RedGate
14 43 (0.92%) Hortonworks
15 42 (0.90%) TIBCO
16 37 (0.79%) Hyperion
17 35 (0.75%) VMware