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

Data Warehousing
UK
6 months to
20 Nov 2018
Same period 2017 Same period 2016
Rank 114 117 109
Rank change year-on-year +3 -8 -26
Permanent jobs citing Data Warehouse 4,697 4,984 5,312
As % of all permanent IT jobs advertised in the UK 2.88% 2.77% 2.84%
As % of the Database & Business Intelligence category 9.89% 9.16% 9.58%
Number of salaries quoted 3,894 3,934 4,565
UK median annual salary £55,000 £50,001 £54,000
Median salary % change year-on-year +10.00% -7.41% +8.00%
10th Percentile £35,000 £32,500 £33,750
90th Percentile £85,000 £77,500 £81,750
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 47,487 54,413 55,467
As % of all permanent IT jobs advertised in the UK 29.11% 30.24% 29.65%
Number of salaries quoted 39,061 44,798 47,411
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 £29,000
90th Percentile £83,750 £77,500 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +6.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 November 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 20 November 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 +6 4,431 £55,000 +6.80% 666
London +14 2,403 £62,500 +4.17% 310
UK excluding London +5 2,219 £47,500 +5.56% 403
South East +31 619 £52,000 +4.00% 82
North of England -13 586 £45,000 - 114
Midlands -15 323 £45,000 -3.74% 58
North West -16 316 £45,000 +5.88% 67
East of England +64 245 £47,500 -9.52% 49
South West -9 235 £50,000 +17.65% 55
Yorkshire -30 235 £46,250 +2.78% 29
East Midlands +35 166 £43,000 -4.44% 25
West Midlands -42 156 £45,000 -5.26% 33
Scotland -11 155 £50,000 +11.11% 34
Wales +52 66 £42,500 +21.43% 12
North East +33 51 £56,250 +40.63% 18
Northern Ireland +3 5 - - 1
Channel Islands -10 1 £45,000 -25.00%

For the 6 months to 20 November 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,122 (66.47%) SQL
2 2,993 (63.72%) Business Intelligence
3 2,293 (48.82%) SQL Server
4 2,093 (44.56%) ETL
5 2,037 (43.37%) SQL Server Integration Services
6 1,715 (36.51%) Microsoft
7 1,610 (34.28%) SQL Server Reporting Services
8 1,428 (30.40%) Agile Software Development
9 1,310 (27.89%) Finance
10 1,271 (27.06%) SQL Server Analysis Services
11 1,265 (26.93%) Analytics
12 1,215 (25.87%) T-SQL
13 1,133 (24.12%) Power BI
14 1,003 (21.35%) Data Modelling
15 892 (18.99%) Microsoft Azure
16 757 (16.12%) Oracle
17 735 (15.65%) Big Data
18 729 (15.52%) Analytical Skills
19 727 (15.48%) Tableau
20 662 (14.09%) Visualisation
21 570 (12.14%) Python
22 539 (11.48%) C#
23 521 (11.09%) .NET
24 505 (10.75%) Amazon AWS
24 505 (10.75%) Relational Database
25 497 (10.58%) Degree
26 494 (10.52%) Data Analysis
27 486 (10.35%) Data Quality
28 457 (9.73%) Data Management
29 440 (9.37%) Problem-Solving

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.13%) Apache Spark
2 185 (3.94%) SAS
3 148 (3.15%) SharePoint
4 87 (1.85%) Apache
5 57 (1.21%) IIS
6 43 (0.92%) Oracle SOA Suite
7 36 (0.77%) Elasticsearch
8 34 (0.72%) Confluence
9 33 (0.70%) Apache Pig
10 25 (0.53%) CMS
11 24 (0.51%) BizTalk Server
12 19 (0.40%) Apache Solr
13 17 (0.36%) MS Exchange
13 17 (0.36%) Skype for Business
14 16 (0.34%) WebLogic
15 14 (0.30%) Apache Airflow
15 14 (0.30%) Hyperledger
15 14 (0.30%) JBoss
16 10 (0.21%) Documentum
16 10 (0.21%) FileNet
Applications
1 414 (8.81%) Microsoft Excel
2 112 (2.38%) Microsoft Office
3 71 (1.51%) MS Visio
4 44 (0.94%) Microsoft PowerPoint
5 17 (0.36%) SPSS
6 13 (0.28%) Microsoft Project
7 10 (0.21%) Spreadsheet
8 3 (0.064%) InfoPath
8 3 (0.064%) Stata
9 2 (0.043%) Adobe After Effects
9 2 (0.043%) Adobe Illustrator
10 1 (0.021%) Chatbot
10 1 (0.021%) CPLEX
10 1 (0.021%) GNU Octave
10 1 (0.021%) Photoshop
Business Applications
1 61 (1.30%) Dynamics CRM
2 57 (1.21%) Cognos Business Intelligence
2 57 (1.21%) Cognos TM1
3 36 (0.77%) Dynamics AX
4 24 (0.51%) Dynamics NAV
5 19 (0.40%) Oracle EBS
6 14 (0.30%) Markit EDM
7 13 (0.28%) NetSuite
7 13 (0.28%) SAP S/4HANA
8 12 (0.26%) SAP CO
8 12 (0.26%) SAP FI
8 12 (0.26%) SAP FI/CO
9 10 (0.21%) FastStats
9 10 (0.21%) SAP BPC
10 9 (0.19%) Oracle Payables
10 9 (0.19%) SAP MDM
11 8 (0.17%) Oracle Subledger Accounting
11 8 (0.17%) Remedy ITSM
11 8 (0.17%) SAP Bank Analyzer
11 8 (0.17%) SAP FS
Cloud Services
1 892 (18.99%) Microsoft Azure
2 505 (10.75%) Amazon AWS
3 188 (4.00%) Azure Data Factory
4 128 (2.73%) PaaS
5 112 (2.38%) Google Cloud Platform
6 80 (1.70%) SaaS
7 73 (1.55%) Serverless
8 58 (1.23%) Cloud Computing
8 58 (1.23%) Office 365
9 56 (1.19%) IaaS
10 52 (1.11%) Data Lake Analytics
11 38 (0.81%) Amazon S3
12 37 (0.79%) Dynamics 365
13 32 (0.68%) Azure Machine Learning
14 31 (0.66%) Azure Functions
15 29 (0.62%) Amazon EC2
15 29 (0.62%) Cortana Intelligence Suite
16 27 (0.57%) AWS Lambda
17 23 (0.49%) Amazon Kinesis
18 22 (0.47%) Google Analytics
Communications & Networking
1 58 (1.23%) Internet
2 34 (0.72%) SAN
3 27 (0.57%) HTTP
3 27 (0.57%) WAN
4 23 (0.49%) LAN
5 22 (0.47%) Firewall
6 21 (0.45%) DNS
7 14 (0.30%) VoIP
8 12 (0.26%) DHCP
8 12 (0.26%) FTP
9 11 (0.23%) Network Security
10 8 (0.17%) TCP/IP
11 7 (0.15%) HTTPS
11 7 (0.15%) Intranet
11 7 (0.15%) SMS
11 7 (0.15%) SSL
12 6 (0.13%) PABX
12 6 (0.13%) SSH
13 5 (0.11%) Skype
13 5 (0.11%) Spanning Tree
Database & Business Intelligence
1 2,293 (48.82%) SQL Server
2 2,037 (43.37%) SQL Server Integration Services
3 1,610 (34.28%) SQL Server Reporting Services
4 1,271 (27.06%) SQL Server Analysis Services
5 1,133 (24.12%) Power BI
6 735 (15.65%) Big Data
7 505 (10.75%) Relational Database
8 418 (8.90%) Hadoop
9 404 (8.60%) Data Lake
10 354 (7.54%) BusinessObjects
11 297 (6.32%) OLAP
12 286 (6.09%) QlikView
13 282 (6.00%) SQL Server 2012
14 261 (5.56%) SQL Server 2008
15 251 (5.34%) SQL Server 2016
16 246 (5.24%) NoSQL
17 233 (4.96%) Microsoft Analysis Services
18 227 (4.83%) Azure SQL Data Warehouse
19 196 (4.17%) Azure SQL Database
19 196 (4.17%) MySQL
Development Applications
1 199 (4.24%) Team Foundation Server
2 187 (3.98%) Visual Studio
3 164 (3.49%) Git (software)
4 121 (2.58%) Jenkins
5 98 (2.09%) JIRA
6 77 (1.64%) SQL Server Management Studio (SSMS)
7 72 (1.53%) ERwin
8 65 (1.38%) Visual Studio Team System
9 64 (1.36%) Octopus Deploy
10 54 (1.15%) TeamCity
11 36 (0.77%) Oracle APEX
12 34 (0.72%) Subversion
13 33 (0.70%) SoapUI
14 30 (0.64%) Eclipse
15 29 (0.62%) ER Studio
16 22 (0.47%) Selenium
16 22 (0.47%) Toad
17 19 (0.40%) Atlassian Bamboo
17 19 (0.40%) Bitbucket
17 19 (0.40%) tSQLt
General
1 1,310 (27.89%) Finance
2 359 (7.64%) Retail
3 302 (6.43%) Banking
4 234 (4.98%) Marketing
5 153 (3.26%) Advertising
6 87 (1.85%) Investment Banking
7 68 (1.45%) Legal
8 55 (1.17%) Games
8 55 (1.17%) Manufacturing
9 46 (0.98%) Telecoms
10 41 (0.87%) Publishing
11 29 (0.62%) Corporate Banking
12 28 (0.60%) Law
13 27 (0.57%) General Ledger
14 25 (0.53%) Back Office
15 22 (0.47%) Front Office
16 19 (0.40%) Pharmaceutical
17 18 (0.38%) Automotive
18 17 (0.36%) Electronics
19 12 (0.26%) Financial Institution
Job Titles
1 1,844 (39.26%) Developer
2 860 (18.31%) Business Intelligence Developer
3 827 (17.61%) Analyst
4 657 (13.99%) SQL Developer
5 597 (12.71%) Architect
6 383 (8.15%) Data Architect
7 311 (6.62%) SSIS Developer
8 310 (6.60%) Data Warehouse Developer
9 291 (6.20%) Consultant
10 287 (6.11%) SQL BI Developer
11 284 (6.05%) Business Intelligence Analyst
12 267 (5.68%) Data Engineer
13 255 (5.43%) Data Analyst
14 254 (5.41%) Senior Developer
15 207 (4.41%) SQL Server Developer
16 204 (4.34%) SSRS Developer
17 202 (4.30%) ETL Developer
18 200 (4.26%) DBA
19 178 (3.79%) Business Analyst
20 172 (3.66%) Business Developer
Libraries, Frameworks & Software Standards
1 521 (11.09%) .NET
2 332 (7.07%) Web Services
3 232 (4.94%) XML
4 206 (4.39%) MDX
5 194 (4.13%) HTML
6 190 (4.05%) Kafka
7 138 (2.94%) JSON
8 106 (2.26%) CSS
9 105 (2.24%) Middleware
10 93 (1.98%) .NET Framework
10 93 (1.98%) ASP.NET
11 84 (1.79%) REST
12 67 (1.43%) SOAP
13 65 (1.38%) AngularJS
14 60 (1.28%) Entity Framework
15 46 (0.98%) HTML5
16 44 (0.94%) RESTful
17 40 (0.85%) WCF
18 38 (0.81%) ASP.NET MVC
18 38 (0.81%) J2EE
Miscellaneous
1 729 (15.52%) Analytical Skills
2 204 (4.34%) Computer Science
3 198 (4.22%) Data Structures
4 188 (4.00%) Greenfield Project
5 174 (3.70%) Management Information System
6 121 (2.58%) Replication
7 97 (2.07%) NHS
8 91 (1.94%) Algorithms
9 80 (1.70%) User Experience
10 76 (1.62%) Fintech
11 74 (1.58%) Self-Motivation
12 73 (1.55%) Reinsurance
13 71 (1.51%) Enterprise Software
14 63 (1.34%) Reference Data
15 60 (1.28%) Clustering
16 50 (1.06%) Credit Risk
17 43 (0.92%) Equities
18 31 (0.66%) Market Risk
19 30 (0.64%) Hedge funds
20 28 (0.60%) Social Network
Operating Systems
1 275 (5.85%) Linux
2 267 (5.68%) Windows
3 244 (5.19%) Unix
4 90 (1.92%) Windows Server
5 61 (1.30%) Red Hat Enterprise Linux
6 37 (0.79%) AIX
7 36 (0.77%) Solaris
8 24 (0.51%) Windows Server 2008
9 22 (0.47%) HPUX
10 21 (0.45%) Windows Server 2012
11 16 (0.34%) Apple iOS
12 12 (0.26%) CentOS
13 9 (0.19%) Ubuntu
14 5 (0.11%) Kali Linux
15 4 (0.085%) Mac OS X
15 4 (0.085%) zOS
16 3 (0.064%) Windows 10
16 3 (0.064%) Windows 7
17 2 (0.043%) Tru64
17 2 (0.043%) Windows XP
Processes & Methodologies
1 2,993 (63.72%) Business Intelligence
2 2,093 (44.56%) ETL
3 1,428 (30.40%) Agile Software Development
4 1,265 (26.93%) Analytics
5 1,003 (21.35%) Data Modelling
6 662 (14.09%) Visualisation
7 494 (10.52%) Data Analysis
8 457 (9.73%) Data Management
9 440 (9.37%) Problem-Solving
10 430 (9.15%) Scrum
11 412 (8.77%) Data Integration
12 399 (8.49%) Migration
13 389 (8.28%) Kimball Methodology
14 384 (8.18%) Data Architecture
15 361 (7.69%) Dimensional Modelling
16 358 (7.62%) SDLC
17 343 (7.30%) Performance Tuning
18 325 (6.92%) Data Analytics
19 320 (6.81%) Project Management
20 315 (6.71%) Data Visualisation
Programming Languages
1 3,122 (66.47%) SQL
2 1,215 (25.87%) T-SQL
3 570 (12.14%) Python
4 539 (11.48%) C#
5 338 (7.20%) Java
6 293 (6.24%) PL/SQL
7 242 (5.15%) JavaScript
8 204 (4.34%) PowerShell
9 183 (3.90%) R
10 156 (3.32%) Data Analysis Expressions (DAX)
11 139 (2.96%) VBA
12 122 (2.60%) Scala
13 106 (2.26%) Shell Script
14 67 (1.43%) VB
15 64 (1.36%) PHP
16 57 (1.21%) VB.NET
17 50 (1.06%) Go
18 43 (0.92%) U-SQL
19 37 (0.79%) C
20 36 (0.77%) Bash Shell
Qualifications
1 497 (10.58%) Degree
2 111 (2.36%) Microsoft Certification
3 85 (1.81%) Computer Science Degree
4 72 (1.53%) Security Cleared
5 58 (1.23%) ISEB
6 40 (0.85%) SC Cleared
7 34 (0.72%) Master's Degree
8 31 (0.66%) MCSA
9 27 (0.57%) MCSE
10 23 (0.49%) MCITP
11 22 (0.47%) PMP
12 21 (0.45%) ITIL Certification
13 20 (0.43%) PMI Certification
14 18 (0.38%) VMware Certified Professional (VCP)
15 16 (0.34%) ITIL Foundation Certificate
16 14 (0.30%) Numerate Degree
16 14 (0.30%) PRINCE2 Certification
17 13 (0.28%) TOGAF Certification
18 12 (0.26%) Postgraduate
19 11 (0.23%) PhD
Quality Assurance & Compliance
1 486 (10.35%) Data Quality
2 244 (5.19%) QA
3 116 (2.47%) GDPR
4 62 (1.32%) PMO
5 29 (0.62%) SLA
6 22 (0.47%) ISO/IEC 27001
7 19 (0.40%) Solvency II
8 18 (0.38%) IFRS
9 12 (0.26%) PCI DSS
10 8 (0.17%) IFRS 9
10 8 (0.17%) MiFID
11 6 (0.13%) Sarbanes-Oxley
12 3 (0.064%) ISO 9001
13 2 (0.043%) GAAP
13 2 (0.043%) ISO/IEC 20000
13 2 (0.043%) P3O
13 2 (0.043%) PSD2
13 2 (0.043%) TickIT
13 2 (0.043%) Web Application Security Consortium
14 1 (0.021%) EMIR
System Software
1 64 (1.36%) Docker
2 60 (1.28%) Active Directory
3 54 (1.15%) HDFS
4 48 (1.02%) Apache Flume
5 31 (0.66%) VMware Infrastructure
6 19 (0.40%) Hyper-V
7 18 (0.38%) vSphere
8 14 (0.30%) Oracle RAC
9 12 (0.26%) Virtual Machines
10 10 (0.21%) Apache ZooKeeper
10 10 (0.21%) Veritas Cluster Server
11 7 (0.15%) Tivoli Workload Scheduler
12 5 (0.11%) Varnish
13 3 (0.064%) GPFS
13 3 (0.064%) VMware Workstation
14 1 (0.021%) Microsoft App-V
14 1 (0.021%) Terminal Services
14 1 (0.021%) VMware ESXi
Systems Management
1 46 (0.98%) Opscode Chef
2 44 (0.94%) Puppet
3 40 (0.85%) Kubernetes
4 39 (0.83%) Ansible
5 33 (0.70%) Automic
5 33 (0.70%) Terraform
6 27 (0.57%) Control-M
7 22 (0.47%) Hadoop YARN
8 21 (0.45%) Oozie
8 21 (0.45%) Oracle Enterprise Manager
8 21 (0.45%) Oracle RMAN
9 18 (0.38%) Tivoli
10 16 (0.34%) Mesos
11 12 (0.26%) Systems Management Server (SMS)
12 11 (0.23%) Dollar Universe
12 11 (0.23%) Kibana
13 10 (0.21%) Data Guard
13 10 (0.21%) Tivoli Storage Manager
14 9 (0.19%) Rundeck
15 8 (0.17%) Oracle ZFS
Vendors
1 1,715 (36.51%) Microsoft
2 757 (16.12%) Oracle
3 727 (15.48%) Tableau
4 311 (6.62%) Informatica
5 257 (5.47%) SAP
6 246 (5.24%) Cognos
7 174 (3.70%) Google
7 174 (3.70%) IBM
8 123 (2.62%) Teradata
9 113 (2.41%) Talend
10 82 (1.75%) Cloudera
11 76 (1.62%) VMware
12 67 (1.43%) MicroStrategy
13 64 (1.36%) Red Hat
14 63 (1.34%) Ab Initio
15 57 (1.21%) Hortonworks
16 52 (1.11%) Salesforce.com
17 50 (1.06%) Databricks
18 49 (1.04%) Netezza
19 43 (0.92%) MapR