Period
to 13 November 2019

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

Data Warehousing
UK
6 months to
13 Nov 2019
Same period 2018 Same period 2017
Rank 114 117 119
Rank change year-on-year +3 +2 -8
Permanent jobs citing Data Warehouse 3,976 4,683 5,005
As % of all permanent IT jobs advertised in the UK 2.89% 2.88% 2.79%
As % of the Database & Business Intelligence category 10.74% 9.86% 9.19%
Number of salaries quoted 3,307 3,865 3,944
UK median annual salary £55,000 £55,000 £51,000
Median salary % change year-on-year - +7.84% -5.56%
10th Percentile £36,250 £35,000 £32,500
90th Percentile £83,750 £85,000 £77,500
UK excluding London median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% -5.26%

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 37,021 47,512 54,438
As % of all permanent IT jobs advertised in the UK 26.91% 29.17% 30.32%
Number of salaries quoted 30,494 39,098 44,822
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,500 £31,250 £30,000
90th Percentile £86,250 £83,750 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -

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 13 November 2019.

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 13 November 2019. 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 +3 3,726 £55,000 - 527
London +7 2,113 £64,345 +4.63% 200
UK excluding London -4 1,808 £47,500 - 361
North of England +10 531 £45,000 - 117
South East -51 386 £50,000 -4.76% 72
North West +36 317 £47,500 +5.56% 76
Midlands +23 303 £45,000 - 76
South West -8 218 £50,000 - 34
West Midlands +52 217 £47,500 +5.56% 57
Yorkshire -25 170 £45,000 - 32
East of England +1 161 £47,500 - 28
Scotland +10 137 £45,500 -9.00% 16
East Midlands -33 86 £45,000 +3.45% 18
Wales +5 62 £41,000 -3.53% 15
North East +9 45 £45,000 -20.00% 9
Northern Ireland +4 9 £45,000 - 2
Channel Islands +10 1 £60,000 +33.33% 1
Isle of Man - 1 £37,500 -

For the 6 months to 13 November 2019, 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 2,626 (66.05%) SQL
2 2,467 (62.05%) Business Intelligence
3 1,809 (45.50%) ETL
4 1,802 (45.32%) SQL Server
5 1,463 (36.80%) SQL Server Integration Services
6 1,314 (33.05%) Analytics
7 1,273 (32.02%) Power Platform
8 1,270 (31.94%) Power BI
9 1,200 (30.18%) Microsoft
10 1,161 (29.20%) Agile Software Development
11 1,126 (28.32%) SQL Server Reporting Services
12 1,116 (28.07%) Azure
13 1,006 (25.30%) SQL Server Analysis Services
14 1,005 (25.28%) Data Modelling
15 958 (24.09%) Finance
16 837 (21.05%) T-SQL
17 728 (18.31%) Python
18 690 (17.35%) Visualisation
19 671 (16.88%) Big Data
20 655 (16.47%) Analytical Skills
21 623 (15.67%) Tableau
22 600 (15.09%) AWS
23 554 (13.93%) Oracle
24 477 (12.00%) Data Lake
25 448 (11.27%) Data Management
26 436 (10.97%) C#
27 423 (10.64%) Problem-Solving
28 413 (10.39%) Data Quality
29 389 (9.78%) Relational Database
30 374 (9.41%) Data Architecture

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 268 (6.74%) Apache Spark
2 118 (2.97%) SAS
3 110 (2.77%) SharePoint
4 84 (2.11%) Apache
5 51 (1.28%) Apache Airflow
6 40 (1.01%) Confluence
7 31 (0.78%) Oracle SOA Suite
8 24 (0.60%) IIS
9 20 (0.50%) Apache Pig
10 12 (0.30%) Elasticsearch
10 12 (0.30%) Tomcat
11 11 (0.28%) BizTalk Server
12 10 (0.25%) PowerExchange
12 10 (0.25%) WordPress
13 8 (0.20%) CMS
13 8 (0.20%) MS Exchange
14 7 (0.18%) Oracle Workflow
15 6 (0.15%) Luigi
15 6 (0.15%) SharePoint 2013
16 5 (0.13%) MQSeries
Applications
1 281 (7.07%) Microsoft Excel
2 94 (2.36%) Microsoft Office
3 36 (0.91%) Spreadsheet
4 25 (0.63%) MS Visio
5 21 (0.53%) Microsoft PowerPoint
6 11 (0.28%) SPSS
7 6 (0.15%) Microsoft Project
8 4 (0.10%) InfoPath
9 1 (0.025%) Adobe Premiere
9 1 (0.025%) SPSS Modeler
Business Applications
1 54 (1.36%) Dynamics CRM
2 31 (0.78%) Cognos Business Intelligence
3 19 (0.48%) Dynamics NAV
4 17 (0.43%) SAP ERP
5 9 (0.23%) Dynamics GP
5 9 (0.23%) JDE OneWorld
5 9 (0.23%) Markit EDM
5 9 (0.23%) SAP Hybris
5 9 (0.23%) SAP Oil and Gas
6 8 (0.20%) Dynamics AX
7 6 (0.15%) FastStats
7 6 (0.15%) NetSuite
7 6 (0.15%) OPENHousing
7 6 (0.15%) Oracle EBS
8 5 (0.13%) Oracle ERP
9 4 (0.10%) Adobe Campaign
9 4 (0.10%) Hyperion Planning
9 4 (0.10%) Oracle Receivables
9 4 (0.10%) Remedy ITSM
9 4 (0.10%) SAP BPC
Cloud Services
1 1,273 (32.02%) Power Platform
2 1,116 (28.07%) Azure
3 600 (15.09%) AWS
4 256 (6.44%) GCP
5 208 (5.23%) Azure Data Factory
6 105 (2.64%) PaaS
7 98 (2.46%) SaaS
8 62 (1.56%) Cloud Computing
9 58 (1.46%) Serverless
10 57 (1.43%) Office 365
11 53 (1.33%) Google Analytics
12 52 (1.31%) Amazon S3
13 45 (1.13%) IaaS
14 36 (0.91%) PowerApps
15 28 (0.70%) Data Lake Analytics
16 25 (0.63%) Azure Functions
17 24 (0.60%) Amazon EMR
17 24 (0.60%) Dynamics 365
18 22 (0.55%) GitHub
19 18 (0.45%) AWS Lambda
Communications & Networking
1 26 (0.65%) Internet
2 18 (0.45%) SAN
3 17 (0.43%) FTP
4 14 (0.35%) DNS
5 8 (0.20%) Intranet
5 8 (0.20%) Wi-Fi
6 6 (0.15%) Network Security
7 5 (0.13%) ATM
7 5 (0.13%) DHCP
7 5 (0.13%) HTTP
8 4 (0.10%) Broadband
8 4 (0.10%) DSL
8 4 (0.10%) Fibre Channel
8 4 (0.10%) SMS
9 3 (0.075%) Firewall
9 3 (0.075%) NAS
10 2 (0.050%) HTTPS
10 2 (0.050%) Kerberos
10 2 (0.050%) TCP/IP
10 2 (0.050%) WLAN
Database & Business Intelligence
1 1,802 (45.32%) SQL Server
2 1,463 (36.80%) SQL Server Integration Services
3 1,270 (31.94%) Power BI
4 1,126 (28.32%) SQL Server Reporting Services
5 1,006 (25.30%) SQL Server Analysis Services
6 671 (16.88%) Big Data
7 477 (12.00%) Data Lake
8 389 (9.78%) Relational Database
9 368 (9.26%) Hadoop
10 260 (6.54%) Azure SQL Database
11 256 (6.44%) Azure SQL Data Warehouse
12 231 (5.81%) NoSQL
13 222 (5.58%) Amazon Redshift
14 216 (5.43%) QlikView
15 200 (5.03%) Microsoft Analysis Services
16 185 (4.65%) BusinessObjects
17 172 (4.33%) OLAP
18 164 (4.12%) PostgreSQL
19 162 (4.07%) Oracle Database
19 162 (4.07%) Snowflake Schema
Development Applications
1 187 (4.70%) Git (software)
2 133 (3.35%) JIRA
3 104 (2.62%) Visual Studio
4 91 (2.29%) Team Foundation Server
5 59 (1.48%) Jenkins
6 45 (1.13%) Bitbucket
7 36 (0.91%) SQL Server Management Studio (SSMS)
8 34 (0.86%) ERwin
9 33 (0.83%) Subversion
10 31 (0.78%) Selenium
11 28 (0.70%) Maven
12 27 (0.68%) Cucumber
13 23 (0.58%) Artifactory
14 21 (0.53%) IBM UrbanCode
14 21 (0.53%) Oracle Forms
15 20 (0.50%) Visual Studio Team System
16 17 (0.43%) Atlassian Bamboo
17 16 (0.40%) ER Studio
18 15 (0.38%) Oracle APEX
19 14 (0.35%) ProC
General
1 958 (24.09%) Finance
2 255 (6.41%) Retail
3 210 (5.28%) Banking
4 173 (4.35%) Marketing
5 96 (2.41%) Public Sector
6 85 (2.14%) Telecoms
7 64 (1.61%) Legal
8 60 (1.51%) Manufacturing
9 55 (1.38%) Games
10 39 (0.98%) Advertising
11 31 (0.78%) Billing
12 28 (0.70%) Law
13 25 (0.63%) Investment Banking
14 24 (0.60%) Electronics
15 20 (0.50%) Back Office
16 17 (0.43%) Automotive
16 17 (0.43%) Publishing
17 16 (0.40%) Financial Institution
18 15 (0.38%) Pharmaceutical
19 11 (0.28%) Aerospace
Job Titles
1 1,594 (40.09%) Developer
2 864 (21.73%) Business Intelligence Developer
3 604 (15.19%) Analyst
4 477 (12.00%) SQL Developer
5 441 (11.09%) Data Engineer
6 418 (10.51%) Architect
7 264 (6.64%) Data Architect
8 224 (5.63%) Senior Developer
9 223 (5.61%) Business Intelligence Analyst
10 184 (4.63%) SQL BI Developer
11 179 (4.50%) Data Warehouse Developer
12 174 (4.38%) Data Analyst
13 163 (4.10%) Business Developer
14 145 (3.65%) Consultant
15 134 (3.37%) DBA
16 128 (3.22%) Senior Business Intelligence Developer
17 121 (3.04%) ETL Developer
18 120 (3.02%) SSIS Developer
19 116 (2.92%) SSRS Developer
20 112 (2.82%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 330 (8.30%) .NET
2 189 (4.75%) Web Services
3 181 (4.55%) MDX
4 106 (2.67%) Kafka
5 93 (2.34%) ASP.NET
6 89 (2.24%) HTML
7 85 (2.14%) XML
8 67 (1.69%) .NET Framework
9 61 (1.53%) JSON
10 55 (1.38%) REST
11 49 (1.23%) WCF
12 45 (1.13%) CSS
13 42 (1.06%) HTML5
14 41 (1.03%) React
15 39 (0.98%) AngularJS
15 39 (0.98%) Entity Framework
16 35 (0.88%) RESTful
17 34 (0.86%) WPF
18 32 (0.80%) SOAP
19 31 (0.78%) Apache Flex
Miscellaneous
1 655 (16.47%) Analytical Skills
2 231 (5.81%) Management Information System
3 139 (3.50%) Data Structures
4 103 (2.59%) Greenfield Project
4 103 (2.59%) Self-Motivation
5 58 (1.46%) Data Centre
6 50 (1.26%) Algorithms
7 48 (1.21%) Reinsurance
8 46 (1.16%) NHS
9 42 (1.06%) User Experience
10 40 (1.01%) Public Cloud
11 36 (0.91%) Replication
12 32 (0.80%) Virtual Team
13 23 (0.58%) Clustering
13 23 (0.58%) Taxonomies
14 22 (0.55%) Private Cloud
15 21 (0.53%) Hedge funds
16 20 (0.50%) FMCG
17 19 (0.48%) Reference Data
18 18 (0.45%) Fixed Income
Operating Systems
1 163 (4.10%) Linux
2 162 (4.07%) Windows
3 147 (3.70%) Unix
4 70 (1.76%) Windows Server
5 17 (0.43%) Red Hat Enterprise Linux
6 12 (0.30%) Windows 10
7 11 (0.28%) Windows 7
8 10 (0.25%) Solaris
8 10 (0.25%) Windows Server 2012
9 9 (0.23%) Oracle Linux
10 8 (0.20%) Android
11 7 (0.18%) Apple iOS
11 7 (0.18%) Windows Server 2008
12 6 (0.15%) VME
13 5 (0.13%) Windows XP
14 4 (0.10%) AIX
14 4 (0.10%) Windows 8
15 2 (0.050%) Windows Server 2003
16 1 (0.025%) VMS
16 1 (0.025%) zOS
Processes & Methodologies
1 2,467 (62.05%) Business Intelligence
2 1,809 (45.50%) ETL
3 1,314 (33.05%) Analytics
4 1,161 (29.20%) Agile Software Development
5 1,005 (25.28%) Data Modelling
6 690 (17.35%) Visualisation
7 448 (11.27%) Data Management
8 423 (10.64%) Problem-Solving
9 374 (9.41%) Data Architecture
10 367 (9.23%) Migration
11 359 (9.03%) Data Science
11 359 (9.03%) Data Visualisation
12 350 (8.80%) Data Integration
13 345 (8.68%) DevOps
14 309 (7.77%) Data Analytics
15 306 (7.70%) Data Analysis
16 304 (7.65%) Kimball Methodology
17 300 (7.55%) Decision-Making
18 269 (6.77%) Scrum
19 233 (5.86%) Data Engineering
Programming Languages
1 2,626 (66.05%) SQL
2 837 (21.05%) T-SQL
3 728 (18.31%) Python
4 436 (10.97%) C#
5 317 (7.97%) Data Analysis Expressions (DAX)
6 303 (7.62%) Java
7 257 (6.46%) PL/SQL
8 255 (6.41%) R
9 136 (3.42%) VBA
10 126 (3.17%) JavaScript
11 113 (2.84%) Scala
12 108 (2.72%) PowerShell
13 66 (1.66%) VB
14 54 (1.36%) Bash Shell
15 51 (1.28%) Shell Script
16 39 (0.98%) VB.NET
17 34 (0.86%) Java 8
18 32 (0.80%) C
19 24 (0.60%) Perl
20 20 (0.50%) PHP
Qualifications
1 322 (8.10%) Degree
2 113 (2.84%) Computer Science Degree
3 48 (1.21%) Security Cleared
4 26 (0.65%) ISTQB
4 26 (0.65%) Microsoft Certification
5 17 (0.43%) ITIL Foundation Certificate
5 17 (0.43%) TOGAF Certification
6 13 (0.33%) MCSA
6 13 (0.33%) SC Cleared
7 12 (0.30%) ITIL Certification
7 12 (0.30%) Master's Degree
7 12 (0.30%) PhD
8 11 (0.28%) MBA
9 10 (0.25%) Numerate Degree
9 10 (0.25%) PMI Certification
10 8 (0.20%) ISTQB Foundation Certification
11 7 (0.18%) ISEB
12 6 (0.15%) DBS Check
12 6 (0.15%) PMP
13 4 (0.10%) MCSE
Quality Assurance & Compliance
1 413 (10.39%) Data Quality
2 164 (4.12%) QA
3 63 (1.58%) GDPR
4 44 (1.11%) SLA
5 20 (0.50%) ISO/IEC 27001
6 18 (0.45%) PMO
7 9 (0.23%) Solvency II
8 3 (0.075%) HL7
9 2 (0.050%) Actionable Recommendations
9 2 (0.050%) ISO 22301
10 1 (0.025%) Basel III
10 1 (0.025%) COBIT
10 1 (0.025%) EMIR
10 1 (0.025%) GMP
10 1 (0.025%) IFRS
10 1 (0.025%) IFRS 9
10 1 (0.025%) ISO 9000
10 1 (0.025%) JSP 440
10 1 (0.025%) NCSC
10 1 (0.025%) PCI DSS
System Software
1 94 (2.36%) Docker
2 46 (1.16%) HDFS
3 45 (1.13%) Active Directory
4 27 (0.68%) VMware Infrastructure
5 23 (0.58%) Tivoli Workload Scheduler
6 19 (0.48%) Apache Flume
7 15 (0.38%) Hyper-V
8 13 (0.33%) Veritas Volume Manager
9 10 (0.25%) Cronacle
10 9 (0.23%) Veritas File System
11 7 (0.18%) Oracle RAC
12 6 (0.15%) VMware Workstation
12 6 (0.15%) XenApp
13 5 (0.13%) Apache ZooKeeper
13 5 (0.13%) Citrix Hypervisor
13 5 (0.13%) XenDesktop
14 4 (0.10%) NFS
15 3 (0.075%) Oracle Clusterware
16 2 (0.050%) Firmware
16 2 (0.050%) Virtual Machines
Systems Management
1 46 (1.16%) Kubernetes
2 41 (1.03%) Ansible
3 35 (0.88%) Terraform
4 25 (0.63%) Puppet
5 23 (0.58%) Control-M
5 23 (0.58%) Tivoli
6 21 (0.53%) Oozie
7 20 (0.50%) Opscode Chef
8 15 (0.38%) Foglight
8 15 (0.38%) LiteSpeed
9 13 (0.33%) AirWatch
9 13 (0.33%) Netcool
9 13 (0.33%) SQL Sentry
10 12 (0.30%) Hadoop YARN
11 11 (0.28%) BMC PATROL
12 10 (0.25%) SCOM
13 9 (0.23%) Oracle RMAN
14 8 (0.20%) Failover Clustering
15 7 (0.18%) HP ALM
16 6 (0.15%) Oracle Enterprise Manager
Vendors
1 1,200 (30.18%) Microsoft
2 623 (15.67%) Tableau
3 554 (13.93%) Oracle
4 289 (7.27%) Informatica
5 250 (6.29%) Google
6 216 (5.43%) SAP
7 191 (4.80%) IBM
8 157 (3.95%) Cognos
9 155 (3.90%) Teradata
10 130 (3.27%) Databricks
11 117 (2.94%) Talend
12 80 (2.01%) Cloudera
13 51 (1.28%) Netezza
14 47 (1.18%) VMware
15 46 (1.16%) Salesforce.com
16 38 (0.96%) Alteryx
17 36 (0.91%) MicroStrategy
18 34 (0.86%) Ab Initio
19 28 (0.70%) Hortonworks
20 23 (0.58%) Citrix