Period
to 20 January 2020

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

Data Warehousing
UK
6 months to
20 Jan 2020
Same period 2019 Same period 2018
Rank 115 122 124
Rank change year-on-year +7 +2 -16
Permanent jobs citing Data Warehouse 3,484 4,196 4,668
As % of all permanent IT jobs advertised in the UK 2.78% 2.81% 2.70%
As % of the Database & Business Intelligence category 10.36% 9.79% 8.83%
Number of salaries quoted 2,850 3,469 3,733
UK median annual salary £57,500 £55,000 £50,000
Median salary % change year-on-year +4.55% +10.00% -7.41%
10th Percentile £36,250 £35,641 £32,500
90th Percentile £87,500 £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 33,619 42,843 52,894
As % of all permanent IT jobs advertised in the UK 26.81% 28.64% 30.55%
Number of salaries quoted 27,603 35,189 43,854
UK median annual salary £52,500 £52,500 £48,000
Median salary % change year-on-year - +9.38% +1.05%
10th Percentile £32,000 £31,250 £30,000
90th Percentile £88,750 £85,000 £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 20 January 2020.

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 2020. 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 +5 3,279 £58,000 +5.45% 572
London -2 1,783 £65,000 +6.43% 259
UK excluding London +10 1,656 £47,500 - 350
North of England +46 514 £47,500 +5.56% 103
South East -39 343 £50,000 -1.48% 75
North West +71 334 £47,500 +5.56% 63
Midlands +31 282 £45,000 - 50
West Midlands +67 228 £45,000 -5.26% 27
East of England +43 172 £52,500 +16.67% 39
South West -18 168 £45,000 -14.29% 46
Yorkshire -11 131 £47,500 - 27
Scotland -21 94 £43,250 -13.50% 18
Wales +13 70 £42,500 - 18
East Midlands -57 54 £45,000 +5.88% 23
North East +14 50 £40,177 -33.04% 13
Northern Ireland +13 12 £45,000 - 1
Channel Islands - 1 £60,000 -
Isle of Man - 1 £37,500 -

For the 6 months to 20 January 2020, 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,291 (65.76%) SQL
2 2,158 (61.94%) Business Intelligence
3 1,608 (46.15%) ETL
4 1,502 (43.11%) SQL Server
5 1,169 (33.55%) SQL Server Integration Services
6 1,139 (32.69%) Analytics
7 1,094 (31.40%) Power BI
7 1,094 (31.40%) Power Platform
8 1,034 (29.68%) Azure
9 1,027 (29.48%) Microsoft
10 954 (27.38%) Agile Software Development
11 930 (26.69%) Data Modelling
12 892 (25.60%) SQL Server Reporting Services
13 804 (23.08%) Finance
14 785 (22.53%) SQL Server Analysis Services
15 685 (19.66%) Python
16 640 (18.37%) T-SQL
17 605 (17.37%) Big Data
18 603 (17.31%) Analytical Skills
19 579 (16.62%) AWS
20 562 (16.13%) Visualisation
21 547 (15.70%) Tableau
22 465 (13.35%) Oracle
23 412 (11.83%) Data Management
24 410 (11.77%) Migration
25 398 (11.42%) Data Lake
26 394 (11.31%) Problem-Solving
27 390 (11.19%) Data Quality
28 354 (10.16%) Data Science
29 330 (9.47%) 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 243 (6.97%) Apache Spark
2 108 (3.10%) SAS
3 83 (2.38%) Apache
4 75 (2.15%) SharePoint
5 69 (1.98%) Apache Airflow
6 47 (1.35%) Confluence
7 32 (0.92%) IIS
8 17 (0.49%) Apache Pig
8 17 (0.49%) Elasticsearch
9 16 (0.46%) Oracle SOA Suite
9 16 (0.46%) Tomcat
10 11 (0.32%) BizTalk Server
11 10 (0.29%) PowerExchange
12 8 (0.23%) Luigi
13 7 (0.20%) MQSeries
13 7 (0.20%) MS Exchange
14 6 (0.17%) CMS
15 5 (0.14%) Apache Solr
16 4 (0.11%) nginx
17 3 (0.086%) Oracle Workflow
Applications
1 231 (6.63%) Microsoft Excel
2 68 (1.95%) Microsoft Office
3 23 (0.66%) Microsoft PowerPoint
4 18 (0.52%) MS Visio
5 17 (0.49%) Spreadsheet
6 8 (0.23%) SPSS
7 2 (0.057%) Microsoft Project
8 1 (0.029%) SPSS Modeler
Business Applications
1 49 (1.41%) Dynamics CRM
2 25 (0.72%) Cognos Business Intelligence
3 16 (0.46%) Dynamics GP
4 10 (0.29%) Dynamics AX
5 9 (0.26%) Markit EDM
6 6 (0.17%) OPENHousing
7 5 (0.14%) Dynamics NAV
7 5 (0.14%) NetSuite
7 5 (0.14%) RiskWrite
8 4 (0.11%) Oracle EBS
8 4 (0.11%) Oracle Financials
8 4 (0.11%) Oracle Receivables
8 4 (0.11%) Remedy ITSM
8 4 (0.11%) SAP ERP
8 4 (0.11%) Sparx Enterprise Architect
9 3 (0.086%) Eagle PACE
9 3 (0.086%) FastStats
9 3 (0.086%) Hyperion Planning
9 3 (0.086%) Oracle Applications
9 3 (0.086%) Oracle EBS R12
Cloud Services
1 1,094 (31.40%) Power Platform
2 1,034 (29.68%) Azure
3 579 (16.62%) AWS
4 264 (7.58%) GCP
5 174 (4.99%) Azure Data Factory
6 104 (2.99%) PaaS
7 93 (2.67%) SaaS
8 65 (1.87%) Serverless
9 60 (1.72%) Amazon S3
10 57 (1.64%) Cloud Computing
11 50 (1.44%) Google Analytics
12 48 (1.38%) IaaS
13 43 (1.23%) Office 365
14 37 (1.06%) Dynamics 365
15 35 (1.00%) AWS Lambda
16 31 (0.89%) Data Lake Analytics
17 30 (0.86%) GitHub
18 25 (0.72%) Azure Functions
19 24 (0.69%) OpenShift
20 22 (0.63%) Amazon Kinesis
Communications & Networking
1 31 (0.89%) Internet
2 12 (0.34%) FTP
3 10 (0.29%) SAN
4 9 (0.26%) ZigBee
5 8 (0.23%) Wi-Fi
6 6 (0.17%) Intranet
7 5 (0.14%) ATM
7 5 (0.14%) Radio Access Network
7 5 (0.14%) SMS
8 4 (0.11%) Fibre Channel
9 3 (0.086%) Broadband
9 3 (0.086%) HTTP
9 3 (0.086%) NAS
10 2 (0.057%) DHCP
10 2 (0.057%) DNS
10 2 (0.057%) Firewall
10 2 (0.057%) Kerberos
10 2 (0.057%) SSL
10 2 (0.057%) TCP/IP
10 2 (0.057%) WLAN
Database & Business Intelligence
1 1,502 (43.11%) SQL Server
2 1,169 (33.55%) SQL Server Integration Services
3 1,094 (31.40%) Power BI
4 892 (25.60%) SQL Server Reporting Services
5 785 (22.53%) SQL Server Analysis Services
6 605 (17.37%) Big Data
7 398 (11.42%) Data Lake
8 320 (9.18%) Relational Database
9 302 (8.67%) Hadoop
10 253 (7.26%) Amazon Redshift
11 235 (6.75%) Azure SQL Data Warehouse
12 226 (6.49%) Snowflake Schema
13 223 (6.40%) NoSQL
14 219 (6.29%) Azure SQL Database
15 200 (5.74%) QlikView
16 195 (5.60%) Microsoft Analysis Services
17 162 (4.65%) BusinessObjects
17 162 (4.65%) PostgreSQL
18 151 (4.33%) BigQuery
19 139 (3.99%) OLAP
Development Applications
1 141 (4.05%) Git (software)
2 126 (3.62%) JIRA
3 74 (2.12%) Team Foundation Server
4 64 (1.84%) Visual Studio
5 46 (1.32%) SQL Server Management Studio (SSMS)
6 39 (1.12%) Visual Studio Team System
7 36 (1.03%) ERwin
8 30 (0.86%) Jenkins
9 19 (0.55%) Bitbucket
10 18 (0.52%) IBM UrbanCode
11 16 (0.46%) Oracle Forms
12 14 (0.40%) ProC
12 14 (0.40%) Subversion
13 13 (0.37%) SoapUI
14 12 (0.34%) Maven
14 12 (0.34%) Selenium
14 12 (0.34%) TeamCity
15 11 (0.32%) Artifactory
15 11 (0.32%) Postman
16 8 (0.23%) kappa
General
1 804 (23.08%) Finance
2 154 (4.42%) Retail
3 148 (4.25%) Marketing
4 139 (3.99%) Banking
5 88 (2.53%) Public Sector
6 70 (2.01%) Legal
7 49 (1.41%) Games
8 44 (1.26%) Telecoms
9 36 (1.03%) Advertising
10 34 (0.98%) Manufacturing
11 31 (0.89%) Publishing
12 30 (0.86%) Law
13 21 (0.60%) Automotive
13 21 (0.60%) Billing
14 18 (0.52%) Back Office
15 15 (0.43%) Financial Institution
15 15 (0.43%) Investment Banking
16 13 (0.37%) Electronics
17 10 (0.29%) Pharmaceutical
18 9 (0.26%) Aerospace
Job Titles
1 1,218 (34.96%) Developer
2 654 (18.77%) Business Intelligence Developer
3 573 (16.45%) Analyst
4 461 (13.23%) Architect
5 391 (11.22%) Data Engineer
6 344 (9.87%) SQL Developer
7 302 (8.67%) Data Architect
8 222 (6.37%) Business Intelligence Analyst
9 179 (5.14%) Senior Developer
10 150 (4.31%) Data Analyst
11 138 (3.96%) Business Developer
12 137 (3.93%) Data Warehouse Developer
13 131 (3.76%) Consultant
14 130 (3.73%) DBA
15 126 (3.62%) Business Analyst
16 122 (3.50%) ETL Developer
17 105 (3.01%) Senior Business Intelligence Developer
17 105 (3.01%) SQL BI Developer
18 104 (2.99%) Solutions Architect
19 87 (2.50%) SSIS Developer
Libraries, Frameworks & Software Standards
1 243 (6.97%) .NET
2 170 (4.88%) Web Services
3 146 (4.19%) Kafka
4 133 (3.82%) MDX
5 82 (2.35%) XML
6 75 (2.15%) ASP.NET
7 73 (2.10%) HTML
8 53 (1.52%) REST
9 51 (1.46%) JSON
10 44 (1.26%) AngularJS
11 40 (1.15%) React
12 39 (1.12%) .NET Framework
13 38 (1.09%) HTML5
14 37 (1.06%) CSS
15 34 (0.98%) WCF
16 26 (0.75%) D3.js
16 26 (0.75%) Entity Framework
17 25 (0.72%) WPF
18 24 (0.69%) Apache Flex
18 24 (0.69%) RESTful
Miscellaneous
1 603 (17.31%) Analytical Skills
2 205 (5.88%) Management Information System
3 165 (4.74%) Data Structures
4 99 (2.84%) Greenfield Project
5 81 (2.32%) Self-Motivation
6 67 (1.92%) Reinsurance
7 44 (1.26%) Algorithms
8 41 (1.18%) User Experience
9 37 (1.06%) Public Cloud
10 35 (1.00%) NHS
11 33 (0.95%) Replication
12 29 (0.83%) Virtual Team
13 28 (0.80%) Data Centre
14 25 (0.72%) Reference Data
15 22 (0.63%) Tandem
16 21 (0.60%) Private Cloud
17 18 (0.52%) Taxonomies
18 17 (0.49%) Social Media
19 16 (0.46%) Clustering
19 16 (0.46%) FMCG
Operating Systems
1 165 (4.74%) Linux
2 142 (4.08%) Windows
3 109 (3.13%) Unix
4 53 (1.52%) Windows Server
5 20 (0.57%) Windows 7
6 13 (0.37%) Windows 10
7 11 (0.32%) Solaris
8 10 (0.29%) Windows Server 2012
9 9 (0.26%) Oracle Linux
10 8 (0.23%) Red Hat Enterprise Linux
10 8 (0.23%) Windows Server 2008
11 6 (0.17%) Windows XP
12 5 (0.14%) Android
12 5 (0.14%) Apple iOS
13 4 (0.11%) VME
13 4 (0.11%) Windows 2000
14 2 (0.057%) AIX
14 2 (0.057%) CentOS
14 2 (0.057%) VMS
14 2 (0.057%) Windows Server 2003
Processes & Methodologies
1 2,158 (61.94%) Business Intelligence
2 1,608 (46.15%) ETL
3 1,139 (32.69%) Analytics
4 954 (27.38%) Agile Software Development
5 930 (26.69%) Data Modelling
6 562 (16.13%) Visualisation
7 412 (11.83%) Data Management
8 410 (11.77%) Migration
9 394 (11.31%) Problem-Solving
10 354 (10.16%) Data Science
11 330 (9.47%) Data Architecture
11 330 (9.47%) Data Integration
12 329 (9.44%) DevOps
13 323 (9.27%) Data Visualisation
14 289 (8.30%) Data Analytics
15 281 (8.07%) Data Analysis
16 256 (7.35%) Kimball Methodology
17 247 (7.09%) Decision-Making
18 236 (6.77%) Data Engineering
19 232 (6.66%) Stakeholder Management
Programming Languages
1 2,291 (65.76%) SQL
2 685 (19.66%) Python
3 640 (18.37%) T-SQL
4 316 (9.07%) C#
5 285 (8.18%) Java
6 196 (5.63%) Data Analysis Expressions (DAX)
7 190 (5.45%) R
8 185 (5.31%) PL/SQL
9 104 (2.99%) JavaScript
10 96 (2.76%) Scala
10 96 (2.76%) VBA
11 80 (2.30%) PowerShell
12 60 (1.72%) VB
13 55 (1.58%) Shell Script
14 51 (1.46%) Bash Shell
15 37 (1.06%) VB.NET
16 36 (1.03%) Java 8
17 24 (0.69%) C
18 21 (0.60%) U-SQL
19 19 (0.55%) Perl
Qualifications
1 272 (7.81%) Degree
2 94 (2.70%) Computer Science Degree
3 43 (1.23%) Security Cleared
4 28 (0.80%) Microsoft Certification
5 27 (0.77%) ISTQB
6 16 (0.46%) Master's Degree
7 14 (0.40%) MBA
7 14 (0.40%) MCSA
8 13 (0.37%) ITIL Foundation Certificate
8 13 (0.37%) SC Cleared
9 11 (0.32%) ITIL Certification
9 11 (0.32%) Numerate Degree
10 8 (0.23%) ISTQB Foundation Certification
10 8 (0.23%) PhD
11 7 (0.20%) AWS Certification
11 7 (0.20%) TOGAF Certification
12 6 (0.17%) ISEB
12 6 (0.17%) PMI Certification
13 5 (0.14%) MCSE
13 5 (0.14%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 390 (11.19%) Data Quality
2 177 (5.08%) QA
3 61 (1.75%) GDPR
4 46 (1.32%) SLA
5 18 (0.52%) Solvency II
6 15 (0.43%) ISO/IEC 27001
7 7 (0.20%) PMO
8 4 (0.11%) Sarbanes-Oxley
9 3 (0.086%) COBIT
10 2 (0.057%) Actionable Recommendations
10 2 (0.057%) HL7
10 2 (0.057%) ISO 22301
10 2 (0.057%) PCI DSS
11 1 (0.029%) Basel III
11 1 (0.029%) GMP
11 1 (0.029%) IFRS
11 1 (0.029%) IFRS 9
11 1 (0.029%) ISO 9000
11 1 (0.029%) ISO 9001
11 1 (0.029%) NCSC
System Software
1 89 (2.55%) Docker
2 44 (1.26%) HDFS
3 36 (1.03%) Active Directory
4 30 (0.86%) Apache Flume
5 18 (0.52%) Tivoli Workload Scheduler
6 14 (0.40%) VMware Infrastructure
7 10 (0.29%) Hyper-V
8 9 (0.26%) Microsoft App-V
9 7 (0.20%) Oracle RAC
10 5 (0.14%) Apache ZooKeeper
11 4 (0.11%) NFS
11 4 (0.11%) Veritas Volume Manager
11 4 (0.11%) Virtual Machines
12 3 (0.086%) Oracle Clusterware
13 2 (0.057%) Varnish
14 1 (0.029%) Cronacle
14 1 (0.029%) Firmware
Systems Management
1 74 (2.12%) Kubernetes
2 30 (0.86%) Oozie
3 25 (0.72%) Control-M
4 24 (0.69%) Terraform
5 22 (0.63%) Ansible
6 18 (0.52%) Opscode Chef
6 18 (0.52%) Tivoli
7 17 (0.49%) Puppet
8 15 (0.43%) Foglight
8 15 (0.43%) LiteSpeed
9 10 (0.29%) SCOM
10 9 (0.26%) Oracle RMAN
10 9 (0.26%) SCCM
11 6 (0.17%) BMC PATROL
11 6 (0.17%) Oracle Enterprise Manager
12 5 (0.14%) BladeLogic
13 4 (0.11%) Data Guard
13 4 (0.11%) Hadoop YARN
13 4 (0.11%) Netcool
13 4 (0.11%) Simpana
Vendors
1 1,027 (29.48%) Microsoft
2 547 (15.70%) Tableau
3 465 (13.35%) Oracle
4 251 (7.20%) Google
5 228 (6.54%) Informatica
6 176 (5.05%) SAP
7 172 (4.94%) IBM
8 142 (4.08%) Cognos
9 123 (3.53%) Databricks
10 121 (3.47%) Teradata
11 86 (2.47%) Cloudera
12 85 (2.44%) Talend
13 49 (1.41%) Netezza
14 39 (1.12%) Alteryx
15 37 (1.06%) Salesforce.com
16 33 (0.95%) MicroStrategy
17 27 (0.77%) Ab Initio
17 27 (0.77%) Hortonworks
18 26 (0.75%) Sybase
19 23 (0.66%) InterSystems