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

Data Warehousing
UK
6 months to
25 Apr 2018
Same period 2017 Same period 2016
Rank 121 108 83
Rank change year-on-year -13 -25 +16
Permanent jobs citing Data Warehouse 4,828 4,847 6,881
As % of all permanent IT jobs advertised in the UK 2.73% 2.85% 3.36%
As % of the Database & Business Intelligence category 8.92% 9.28% 10.71%
Number of salaries quoted 3,927 4,194 5,645
UK median annual salary £52,500 £51,816 £50,500
Median salary % change year-on-year +1.32% +2.61% -1.94%
10th Percentile £33,000 £32,500 £32,500
90th Percentile £80,000 £80,000 £80,000
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 54,138 52,218 64,236
As % of all permanent IT jobs advertised in the UK 30.60% 30.69% 31.38%
Number of salaries quoted 45,100 44,518 54,622
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £30,500 £29,750 £28,750
90th Percentile £80,000 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £42,000
% change year-on-year - +1.19% +5.00%

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 25 April 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 25 April 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 -11 4,554 £52,500 - 495
UK excluding London -11 2,491 £45,000 - 295
London -5 2,240 £60,000 - 232
North of England -12 754 £45,000 +5.88% 68
South East -20 565 £50,000 - 64
Midlands -14 443 £45,000 - 66
North West -15 382 £45,000 +12.50% 32
Yorkshire -12 321 £45,000 +5.88% 29
West Midlands +9 279 £47,500 +11.76% 37
East of England +2 271 £50,000 - 32
South West +30 261 £42,500 - 33
East Midlands -19 164 £42,500 -5.56% 29
Scotland -50 147 £45,500 -6.67% 22
Wales +10 54 £35,000 -12.50% 4
North East +15 51 £37,375 -12.06% 7
Channel Islands - 5 £60,000 - 2
Northern Ireland 0 2 £37,500 - 4

For the 6 months to 25 April 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,194 (66.16%) Business Intelligence
2 3,153 (65.31%) SQL
3 2,608 (54.02%) SQL Server
4 2,148 (44.49%) ETL
5 2,138 (44.28%) SQL Server Integration Services
6 1,788 (37.03%) SQL Server Reporting Services
7 1,610 (33.35%) Microsoft
8 1,534 (31.77%) SQL Server Analysis Services
9 1,327 (27.49%) T-SQL
10 1,268 (26.26%) Finance
11 1,249 (25.87%) Agile Software Development
12 1,152 (23.86%) Analytics
13 1,071 (22.18%) Data Modelling
14 960 (19.88%) Power BI
15 825 (17.09%) Oracle
16 789 (16.34%) Big Data
17 772 (15.99%) Analytical Skills
18 696 (14.42%) Microsoft Azure
19 684 (14.17%) Tableau
20 604 (12.51%) Visualisation
21 528 (10.94%) Problem-Solving
22 515 (10.67%) Python
23 489 (10.13%) Degree
24 474 (9.82%) Relational Database
25 467 (9.67%) Data Analysis
26 461 (9.55%) .NET
27 456 (9.44%) Hadoop
28 443 (9.18%) Data Quality
29 424 (8.78%) Data Architecture
30 420 (8.70%) 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 262 (5.43%) Apache Spark
2 206 (4.27%) SAS
3 121 (2.51%) SharePoint
4 50 (1.04%) Confluence
5 42 (0.87%) Apache
6 35 (0.72%) Elasticsearch
7 32 (0.66%) Oracle SOA Suite
8 31 (0.64%) IIS
9 24 (0.50%) Apache Solr
10 22 (0.46%) Apache Pig
11 19 (0.39%) BizTalk Server
12 18 (0.37%) WebSphere
13 17 (0.35%) MS Exchange
13 17 (0.35%) WebLogic
14 14 (0.29%) Apache Airflow
14 14 (0.29%) CMS
15 10 (0.21%) SharePoint 2010
15 10 (0.21%) Skype for Business
16 8 (0.17%) nginx
16 8 (0.17%) SharePoint Server
Applications
1 366 (7.58%) Microsoft Excel
2 94 (1.95%) Microsoft Office
3 74 (1.53%) MS Visio
4 50 (1.04%) Microsoft PowerPoint
5 32 (0.66%) Microsoft Project
6 16 (0.33%) Spreadsheet
7 13 (0.27%) SPSS
8 1 (0.021%) CPLEX
8 1 (0.021%) InfoPath
8 1 (0.021%) Mingle
8 1 (0.021%) Weka
Business Applications
1 46 (0.95%) Markit EDM
2 32 (0.66%) NetSuite
3 27 (0.56%) Dynamics CRM
4 24 (0.50%) Cognos Business Intelligence
4 24 (0.50%) Dynamics AX
5 22 (0.46%) Oracle EBS
6 18 (0.37%) Cognos TM1
6 18 (0.37%) JDE EnterpriseOne
7 16 (0.33%) Oracle EBS R12
8 13 (0.27%) Salesforce.com CRM
9 9 (0.19%) Elite 3E
9 9 (0.19%) MetaTrader
9 9 (0.19%) SAP S/4HANA
10 8 (0.17%) Eagle PACE
11 7 (0.14%) SAP ERP
12 6 (0.12%) HFM
12 6 (0.12%) Oracle Retail
12 6 (0.12%) Remedy ITSM
13 5 (0.10%) Oracle 11i
14 4 (0.083%) Oracle Payables
Cloud Services
1 696 (14.42%) Microsoft Azure
2 396 (8.20%) Amazon AWS
3 123 (2.55%) Azure Data Factory
4 73 (1.51%) Google Cloud Platform
5 66 (1.37%) Cloud Computing
6 65 (1.35%) SaaS
7 57 (1.18%) PaaS
8 45 (0.93%) Office 365
9 38 (0.79%) Amazon EMR
10 28 (0.58%) Amazon S3
10 28 (0.58%) Cortana Intelligence Suite
11 27 (0.56%) Amazon Kinesis
12 25 (0.52%) Azure Machine Learning
13 24 (0.50%) IaaS
14 23 (0.48%) Amazon ElastiCache
14 23 (0.48%) Serverless
15 17 (0.35%) AWS Lambda
16 15 (0.31%) Dynamics 365
17 13 (0.27%) GitHub
18 12 (0.25%) Data Lake Analytics
Communications & Networking
1 61 (1.26%) Internet
2 42 (0.87%) Firewall
3 37 (0.77%) DNS
3 37 (0.77%) HTTP
4 29 (0.60%) LAN
5 28 (0.58%) DHCP
5 28 (0.58%) SSL
5 28 (0.58%) WAN
6 23 (0.48%) SMS
7 22 (0.46%) TCP/IP
8 21 (0.43%) Wireless
9 17 (0.35%) SAN
10 11 (0.23%) ICMP
10 11 (0.23%) Intranet
10 11 (0.23%) Network Security
10 11 (0.23%) OSPF
10 11 (0.23%) Remote Desktop
10 11 (0.23%) SNMP
10 11 (0.23%) VLAN
10 11 (0.23%) VoIP
Database & Business Intelligence
1 2,608 (54.02%) SQL Server
2 2,138 (44.28%) SQL Server Integration Services
3 1,788 (37.03%) SQL Server Reporting Services
4 1,534 (31.77%) SQL Server Analysis Services
5 960 (19.88%) Power BI
6 789 (16.34%) Big Data
7 474 (9.82%) Relational Database
8 456 (9.44%) Hadoop
9 398 (8.24%) QlikView
10 397 (8.22%) SQL Server 2016
11 394 (8.16%) BusinessObjects
12 323 (6.69%) SQL Server 2014
13 303 (6.28%) Microsoft Analysis Services
14 294 (6.09%) OLAP
15 290 (6.01%) SQL Server 2012
16 254 (5.26%) MySQL
17 238 (4.93%) Data Lake
18 219 (4.54%) NoSQL
19 197 (4.08%) SQL Server 2008
20 187 (3.87%) Star Schema
Development Applications
1 165 (3.42%) Team Foundation Server
2 149 (3.09%) JIRA
3 123 (2.55%) Visual Studio
4 121 (2.51%) SQL Server Management Studio (SSMS)
5 109 (2.26%) Git (software)
6 88 (1.82%) Jenkins
7 79 (1.64%) ERwin
8 66 (1.37%) TeamCity
9 40 (0.83%) Selenium
10 39 (0.81%) Subversion
11 31 (0.64%) Oracle Forms
12 23 (0.48%) Eclipse
12 23 (0.48%) Toad
13 22 (0.46%) Oracle APEX
14 15 (0.31%) Cucumber
15 14 (0.29%) Bitbucket
15 14 (0.29%) JUnit
16 11 (0.23%) Visual Studio Team System
17 10 (0.21%) Atlassian Bamboo
18 9 (0.19%) Maven
General
1 1,268 (26.26%) Finance
2 366 (7.58%) Retail
3 311 (6.44%) Advertising
4 218 (4.52%) Marketing
5 209 (4.33%) Banking
6 77 (1.59%) Manufacturing
7 61 (1.26%) Games
8 55 (1.14%) Legal
9 48 (0.99%) Publishing
10 45 (0.93%) Law
10 45 (0.93%) Telecoms
11 36 (0.75%) Automotive
12 32 (0.66%) Financial Institution
13 31 (0.64%) Investment Banking
14 27 (0.56%) Front Office
15 22 (0.46%) Back Office
15 22 (0.46%) Electronics
16 21 (0.43%) Pharmaceutical
17 20 (0.41%) Billing
18 18 (0.37%) Local Government
Job Titles
1 2,012 (41.67%) Developer
2 1,050 (21.75%) Business Intelligence Developer
3 799 (16.55%) Analyst
4 716 (14.83%) SQL Developer
5 558 (11.56%) Architect
6 365 (7.56%) Data Architect
7 354 (7.33%) Data Warehouse Developer
8 348 (7.21%) SQL BI Developer
9 347 (7.19%) Consultant
10 344 (7.13%) SSIS Developer
11 290 (6.01%) Business Intelligence Analyst
12 283 (5.86%) SQL Server Developer
13 257 (5.32%) DBA
14 255 (5.28%) SSRS Developer
15 224 (4.64%) Business Analyst
16 223 (4.62%) Data Analyst
17 214 (4.43%) Data Engineer
18 212 (4.39%) Business Developer
19 195 (4.04%) Senior Developer
19 195 (4.04%) SQL DBA
Libraries, Frameworks & Software Standards
1 461 (9.55%) .NET
2 293 (6.07%) Web Services
3 230 (4.76%) XML
4 187 (3.87%) HTML
5 183 (3.79%) MDX
6 154 (3.19%) Kafka
7 136 (2.82%) JSON
8 119 (2.46%) CSS
9 111 (2.30%) SOAP
10 94 (1.95%) REST
11 85 (1.76%) .NET Framework
12 76 (1.57%) ASP.NET
13 70 (1.45%) AngularJS
14 69 (1.43%) Middleware
15 64 (1.33%) RESTful
16 54 (1.12%) HTML5
17 50 (1.04%) jQuery
18 47 (0.97%) Entity Framework
19 44 (0.91%) Spring
20 39 (0.81%) CSS3
Miscellaneous
1 772 (15.99%) Analytical Skills
2 231 (4.78%) Computer Science
3 210 (4.35%) Management Information System
4 174 (3.60%) Greenfield Project
5 139 (2.88%) Self-Motivation
6 133 (2.75%) Data Structures
7 110 (2.28%) NHS
7 110 (2.28%) Replication
8 103 (2.13%) Fintech
9 102 (2.11%) User Experience
10 90 (1.86%) Algorithms
11 82 (1.70%) Virtual Team
12 81 (1.68%) Clustering
12 81 (1.68%) Enterprise Software
13 60 (1.24%) Data Centre
14 37 (0.77%) Mobile App
15 33 (0.68%) Credit Risk
15 33 (0.68%) Hedge funds
16 32 (0.66%) Reinsurance
17 30 (0.62%) Mainframe
Operating Systems
1 283 (5.86%) Linux
2 225 (4.66%) Windows
3 177 (3.67%) Unix
4 62 (1.28%) Windows Server
5 34 (0.70%) AIX
6 29 (0.60%) Windows Server 2008
7 20 (0.41%) HPUX
7 20 (0.41%) Solaris
7 20 (0.41%) Windows Server 2012
8 13 (0.27%) Android
9 12 (0.25%) Windows XP
10 11 (0.23%) Windows 8
10 11 (0.23%) Windows Server 2003
11 10 (0.21%) Apple iOS
12 5 (0.10%) CentOS
12 5 (0.10%) zOS
13 4 (0.083%) Mac OS X
13 4 (0.083%) Red Hat Enterprise Linux
13 4 (0.083%) Windows Vista
14 3 (0.062%) Oracle Linux
Processes & Methodologies
1 3,194 (66.16%) Business Intelligence
2 2,148 (44.49%) ETL
3 1,249 (25.87%) Agile Software Development
4 1,152 (23.86%) Analytics
5 1,071 (22.18%) Data Modelling
6 604 (12.51%) Visualisation
7 528 (10.94%) Problem-Solving
8 467 (9.67%) Data Analysis
9 424 (8.78%) Data Architecture
10 420 (8.70%) Data Integration
10 420 (8.70%) Kimball Methodology
11 406 (8.41%) Data Management
12 390 (8.08%) Performance Tuning
13 375 (7.77%) Migration
14 356 (7.37%) Data Visualisation
15 348 (7.21%) Scrum
16 343 (7.10%) SDLC
17 318 (6.59%) Data Analytics
18 296 (6.13%) Data Science
19 275 (5.70%) Data Governance
Programming Languages
1 3,153 (65.31%) SQL
2 1,327 (27.49%) T-SQL
3 515 (10.67%) Python
4 402 (8.33%) Java
5 388 (8.04%) C#
6 227 (4.70%) PL/SQL
7 225 (4.66%) JavaScript
8 186 (3.85%) R
9 165 (3.42%) PowerShell
10 152 (3.15%) Scala
11 130 (2.69%) Data Analysis Expressions (DAX)
12 120 (2.49%) VBA
13 101 (2.09%) Shell Script
14 81 (1.68%) PHP
15 56 (1.16%) Go
16 53 (1.10%) C
16 53 (1.10%) VB.NET
17 52 (1.08%) VB
18 51 (1.06%) C++
18 51 (1.06%) VBScript
Qualifications
1 489 (10.13%) Degree
2 95 (1.97%) Microsoft Certification
3 90 (1.86%) Computer Science Degree
4 78 (1.62%) Security Cleared
5 69 (1.43%) ISEB
6 54 (1.12%) ITIL Certification
7 42 (0.87%) SC Cleared
8 40 (0.83%) Numerate Degree
9 38 (0.79%) MCSE
10 37 (0.77%) ISTQB
11 35 (0.72%) MCSA
11 35 (0.72%) PMI Certification
12 34 (0.70%) Master's Degree
12 34 (0.70%) TOGAF Certification
13 21 (0.43%) PMP
14 19 (0.39%) MBA
15 16 (0.33%) Postgraduate
16 13 (0.27%) MCDBA
16 13 (0.27%) Microsoft Certified Architect
17 11 (0.23%) DBS Check
Quality Assurance & Compliance
1 443 (9.18%) Data Quality
2 276 (5.72%) QA
3 87 (1.80%) GDPR
4 67 (1.39%) PMO
5 28 (0.58%) SLA
6 19 (0.39%) Solvency II
7 12 (0.25%) Web Application Security Consortium
8 11 (0.23%) GCP
9 9 (0.19%) PCI DSS
10 7 (0.14%) ISO/IEC 27001
11 6 (0.12%) IFRS
11 6 (0.12%) IFRS 9
12 3 (0.062%) HL7
12 3 (0.062%) ISO/IEC 20000
12 3 (0.062%) MiFID
12 3 (0.062%) Sarbanes-Oxley
13 2 (0.041%) COBIT
13 2 (0.041%) GAAP
13 2 (0.041%) TickIT
14 1 (0.021%) SNOMED CT
System Software
1 87 (1.80%) HDFS
2 72 (1.49%) Active Directory
3 64 (1.33%) Apache Flume
4 50 (1.04%) Docker
5 44 (0.91%) VMware Infrastructure
6 12 (0.25%) Hyper-V
7 11 (0.23%) XenApp
8 7 (0.14%) Apache ZooKeeper
9 5 (0.10%) Virtual Machines
10 4 (0.083%) Xen
11 2 (0.041%) VMware ESXi
12 1 (0.021%) Oracle RAC
12 1 (0.021%) vSphere
Systems Management
1 49 (1.01%) Hadoop YARN
2 26 (0.54%) Oozie
3 25 (0.52%) Mesos
4 19 (0.39%) Systems Management Server (SMS)
5 15 (0.31%) Ansible
5 15 (0.31%) Puppet
6 14 (0.29%) Kubernetes
7 13 (0.27%) Ambari
7 13 (0.27%) Failover Clustering
7 13 (0.27%) Opscode Chef
8 11 (0.23%) Kibana
8 11 (0.23%) Terraform
9 10 (0.21%) Nagios
10 9 (0.19%) SCCM
10 9 (0.19%) Single Sign-On
11 8 (0.17%) Automic
11 8 (0.17%) FortiGate
11 8 (0.17%) Perfmon
12 7 (0.14%) Control-M
12 7 (0.14%) Dollar Universe
Vendors
1 1,610 (33.35%) Microsoft
2 825 (17.09%) Oracle
3 684 (14.17%) Tableau
4 284 (5.88%) SAP
5 269 (5.57%) Informatica
6 217 (4.49%) Cognos
7 151 (3.13%) Talend
8 136 (2.82%) Google
9 131 (2.71%) IBM
10 110 (2.28%) Teradata
11 97 (2.01%) MicroStrategy
12 95 (1.97%) Cloudera
13 62 (1.28%) Salesforce.com
14 56 (1.16%) Hortonworks
15 55 (1.14%) HP
16 51 (1.06%) Netezza
17 49 (1.01%) Alteryx
18 48 (0.99%) VMware
19 39 (0.81%) RedGate
20 33 (0.68%) Facebook