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

Data Warehousing
UK
6 months to
16 Jul 2020
Same period 2019 Same period 2018
Rank 107 107 116
Rank change year-on-year 0 +9 -3
Permanent jobs citing Data Warehouse 2,141 4,465 4,988
As % of all permanent jobs advertised in the UK 2.88% 3.06% 2.83%
As % of the Database & Business Intelligence category 10.61% 11.10% 9.31%
Number of salaries quoted 1,870 3,861 4,248
Median annual salary £60,000 £55,000 £52,500
Median salary % change year-on-year +9.09% +4.76% +5.00%
10th Percentile £36,250 £37,000 £33,750
90th Percentile £87,500 £83,750 £85,000
UK excluding London median annual salary £50,000 £48,000 £45,000
% change year-on-year +4.17% +6.67% -

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 20,180 40,226 53,555
As % of all permanent IT jobs advertised in the UK 27.13% 27.59% 30.43%
Number of salaries quoted 16,462 32,992 43,658
Median annual salary £55,000 £52,000 £50,000
Median salary % change year-on-year +5.77% +4.00% +5.26%
10th Percentile £32,500 £31,250 £31,250
90th Percentile £88,750 £85,000 £81,250
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

Data Warehouse
Job Vacancy Trend

Job postings citing Data Warehouse as a proportion of all IT jobs advertised.

Job vacancy trend for Data Warehouse in the UK

Data Warehouse
Salary Trend

3-month moving average salary quoted in jobs citing Data Warehouse.

Salary trend for Data Warehouse in the UK

Data Warehouse
Salary Histogram

Salary distribution for jobs citing Data Warehouse over the 6 months to 16 July 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 16 July 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 -1 2,010 £60,000 +9.09% 159
London -21 1,081 £70,000 +12.00% 64
UK excluding London +18 1,029 £50,000 +4.17% 112
North of England +23 269 £50,000 +5.26% 37
South East +5 241 £55,000 +4.76% 11
Midlands +32 202 £48,750 +8.33% 23
North West +29 172 £50,000 +7.53% 25
West Midlands +42 129 £51,000 +2.00% 20
Work from Home +26 117 £50,000 -9.09% 23
East of England +68 111 £60,000 +20.00% 14
South West -17 99 £47,500 -9.52% 10
Yorkshire +25 83 £50,000 +5.26% 11
East Midlands +22 71 £40,000 -10.11% 3
Scotland -3 47 £49,500 +8.79% 5
Wales +19 46 £45,000 +12.50% 7
North East +4 14 £42,750 -10.00% 1
Channel Islands +3 10 £55,000 +10.00% 1
Northern Ireland +19 4 £37,500 -16.67% 4

For the 6 months to 16 July 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 1,463 (68.33%) SQL
2 1,320 (61.65%) Business Intelligence
3 976 (45.59%) SQL Server
4 855 (39.93%) ETL
5 806 (37.65%) Power Platform
6 797 (37.23%) Power BI
7 792 (36.99%) Azure
8 717 (33.49%) SQL Server Integration Services
9 670 (31.29%) Agile Software Development
10 669 (31.25%) Analytics
11 651 (30.41%) Microsoft
12 627 (29.29%) Finance
13 580 (27.09%) Data Modelling
14 570 (26.62%) Python
15 557 (26.02%) SQL Server Reporting Services
16 454 (21.21%) AWS
17 452 (21.11%) SQL Server Analysis Services
18 410 (19.15%) Data Lake
19 376 (17.56%) Analytical Skills
20 359 (16.77%) Visualisation
21 350 (16.35%) Tableau
22 338 (15.79%) Big Data
23 332 (15.51%) T-SQL
24 292 (13.64%) Oracle
25 275 (12.84%) DevOps
26 251 (11.72%) Java
27 230 (10.74%) Migration
27 230 (10.74%) Azure Data Factory
28 227 (10.60%) Azure SQL Database
29 225 (10.51%) Degree

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 168 (7.85%) Apache Spark
2 102 (4.76%) Apache
3 43 (2.01%) SharePoint
4 37 (1.73%) Apache Airflow
5 22 (1.03%) SAS
6 20 (0.93%) Confluence
7 19 (0.89%) Luigi
8 18 (0.84%) Elasticsearch
9 11 (0.51%) Apache Pig
9 11 (0.51%) Tomcat
10 8 (0.37%) Apache Synapse
10 8 (0.37%) Oracle Workflow
11 7 (0.33%) MQSeries
11 7 (0.33%) Oracle SOA Suite
12 6 (0.28%) CMS
12 6 (0.28%) Jupyter
12 6 (0.28%) SharePoint 2010
12 6 (0.28%) SharePoint 2013
13 5 (0.23%) BizTalk Server
13 5 (0.23%) IIS
Applications
1 127 (5.93%) Microsoft Excel
2 34 (1.59%) Microsoft Office
3 17 (0.79%) Microsoft PowerPoint
4 10 (0.47%) SPSS
5 8 (0.37%) MS Visio
6 2 (0.093%) Chatbot
6 2 (0.093%) InfoPath
6 2 (0.093%) S-PLUS
7 1 (0.047%) Spreadsheet
Business Applications
1 15 (0.70%) Dynamics CRM
2 12 (0.56%) SAP BPC
3 9 (0.42%) Markit EDM
4 7 (0.33%) Cognos Business Intelligence
5 6 (0.28%) Maximo
6 4 (0.19%) Dynamics AX
6 4 (0.19%) Dynamics GP
6 4 (0.19%) Eikon
6 4 (0.19%) NetSuite
6 4 (0.19%) Oracle EBS
6 4 (0.19%) Raiser's Edge
6 4 (0.19%) SAP IS-U
7 3 (0.14%) Oracle General Ledger
7 3 (0.14%) Oracle Internet Expenses
7 3 (0.14%) Oracle iProcurement
7 3 (0.14%) Oracle Procure-to-Pay
7 3 (0.14%) SAP ERP
7 3 (0.14%) Teamcenter
8 2 (0.093%) SAP IBP
9 1 (0.047%) FLEXCUBE
Cloud Services
1 806 (37.65%) Power Platform
2 792 (36.99%) Azure
3 454 (21.21%) AWS
4 230 (10.74%) Azure Data Factory
5 212 (9.90%) GCP
6 98 (4.58%) Serverless
7 87 (4.06%) SaaS
8 76 (3.55%) AWS Lambda
9 70 (3.27%) PaaS
10 58 (2.71%) Amazon ECS
11 52 (2.43%) Amazon S3
12 33 (1.54%) IaaS
13 30 (1.40%) Amazon EC2
13 30 (1.40%) Apigee
14 28 (1.31%) Azure Stack
15 27 (1.26%) Amazon EMR
15 27 (1.26%) Azure Machine Learning
16 22 (1.03%) Amazon Kinesis
16 22 (1.03%) Data Lake Analytics
16 22 (1.03%) Dynamics 365
Communications & Networking
1 21 (0.98%) Internet
2 9 (0.42%) Broadband
3 8 (0.37%) Skype
3 8 (0.37%) WebEx
4 5 (0.23%) Firewall
4 5 (0.23%) Intranet
5 4 (0.19%) SSH
6 3 (0.14%) Extranet
7 2 (0.093%) DNS
7 2 (0.093%) Network Security
7 2 (0.093%) Software-Defined Networking
7 2 (0.093%) SSL
7 2 (0.093%) VoIP
8 1 (0.047%) MPLS
8 1 (0.047%) Wi-Fi
8 1 (0.047%) ZigBee
Database & Business Intelligence
1 976 (45.59%) SQL Server
2 797 (37.23%) Power BI
3 717 (33.49%) SQL Server Integration Services
4 557 (26.02%) SQL Server Reporting Services
5 452 (21.11%) SQL Server Analysis Services
6 410 (19.15%) Data Lake
7 338 (15.79%) Big Data
8 227 (10.60%) Azure SQL Database
9 206 (9.62%) Amazon Redshift
10 198 (9.25%) Snowflake Schema
11 189 (8.83%) Azure SQL Data Warehouse
12 180 (8.41%) NoSQL
13 172 (8.03%) Relational Database
14 160 (7.47%) Hadoop
15 138 (6.45%) Microsoft Analysis Services
16 130 (6.07%) PostgreSQL
17 117 (5.46%) MySQL
18 111 (5.18%) OLAP
19 104 (4.86%) BigQuery
20 97 (4.53%) QlikView
Development Applications
1 76 (3.55%) JIRA
2 67 (3.13%) Git (software)
2 67 (3.13%) Jenkins
3 52 (2.43%) Visual Studio
4 40 (1.87%) ERwin
5 35 (1.63%) GitLab
6 30 (1.40%) Artifactory
7 26 (1.21%) SQL Server Management Studio (SSMS)
8 21 (0.98%) Cucumber
8 21 (0.98%) PowerDesigner
9 20 (0.93%) Team Foundation Server
9 20 (0.93%) Visual Studio Team System
10 18 (0.84%) Selenium
11 13 (0.61%) ER Studio
11 13 (0.61%) TeamCity
12 12 (0.56%) Maven
13 9 (0.42%) Eclipse
13 9 (0.42%) Octopus Deploy
14 7 (0.33%) SoapUI
14 7 (0.33%) WebDriver
General
1 627 (29.29%) Finance
2 140 (6.54%) Banking
3 114 (5.32%) Marketing
4 86 (4.02%) Retail
5 82 (3.83%) Back Office
6 42 (1.96%) Advertising
7 31 (1.45%) Law
8 22 (1.03%) Games
9 21 (0.98%) Legal
10 15 (0.70%) Financial Institution
10 15 (0.70%) Public Sector
11 13 (0.61%) Investment Banking
11 13 (0.61%) Manufacturing
12 11 (0.51%) Front Office
12 11 (0.51%) Pharmaceutical
13 7 (0.33%) Police
14 6 (0.28%) Telecoms
15 4 (0.19%) Publishing
16 3 (0.14%) General Ledger
16 3 (0.14%) Local Government
Job Titles
1 747 (34.89%) Developer
2 366 (17.09%) Business Intelligence Developer
3 353 (16.49%) Data Engineer
4 338 (15.79%) Analyst
5 269 (12.56%) Architect
6 222 (10.37%) SQL Developer
7 196 (9.15%) Data Architect
8 188 (8.78%) Data Warehouse Developer
9 104 (4.86%) Data Analyst
9 104 (4.86%) Senior Developer
10 100 (4.67%) Business Intelligence Analyst
11 96 (4.48%) SSIS Developer
12 87 (4.06%) SQL BI Developer
13 81 (3.78%) Consultant
14 80 (3.74%) Azure Engineer
15 76 (3.55%) Solutions Architect
16 75 (3.50%) DBA
16 75 (3.50%) ETL Developer
17 74 (3.46%) Business Analyst
18 64 (2.99%) Business Developer
Libraries, Frameworks & Software Standards
1 147 (6.87%) .NET
2 145 (6.77%) Kafka
3 133 (6.21%) Web Services
4 75 (3.50%) MDX
5 58 (2.71%) REST
6 56 (2.62%) XML
7 52 (2.43%) gRPC
8 51 (2.38%) JSON
9 41 (1.91%) ASP.NET
9 41 (1.91%) HTML
10 35 (1.63%) AngularJS
11 34 (1.59%) CSS
11 34 (1.59%) OAuth
12 32 (1.49%) PySpark
13 30 (1.40%) Swagger
14 27 (1.26%) HTML5
15 25 (1.17%) SOAP
16 23 (1.07%) Middleware
17 20 (0.93%) React
17 20 (0.93%) RESTful
Miscellaneous
1 376 (17.56%) Analytical Skills
2 159 (7.43%) Management Information System
3 145 (6.77%) Data Structures
4 112 (5.23%) Greenfield Project
5 59 (2.76%) Hedge funds
6 44 (2.06%) Self-Motivation
7 35 (1.63%) User Experience
8 29 (1.35%) Clustering
9 26 (1.21%) Reinsurance
10 24 (1.12%) Foreign Exchange (FX)
11 23 (1.07%) Derivative
11 23 (1.07%) Enterprise Software
12 21 (0.98%) Data Centre
12 21 (0.98%) Reference Data
13 20 (0.93%) Algorithms
14 17 (0.79%) FMCG
14 17 (0.79%) Replication
15 15 (0.70%) Cloud Native
16 14 (0.65%) NHS
16 14 (0.65%) Online Games
Operating Systems
1 83 (3.88%) Windows
2 65 (3.04%) Unix
3 54 (2.52%) Linux
4 36 (1.68%) Windows Server
5 7 (0.33%) AIX
6 6 (0.28%) Windows 2000
6 6 (0.28%) Windows XP
7 4 (0.19%) Windows 10
8 3 (0.14%) Android
8 3 (0.14%) Apple iOS
9 2 (0.093%) Red Hat Enterprise Linux
9 2 (0.093%) Solaris
10 1 (0.047%) MVS
Processes & Methodologies
1 1,320 (61.65%) Business Intelligence
2 855 (39.93%) ETL
3 670 (31.29%) Agile Software Development
4 669 (31.25%) Analytics
5 580 (27.09%) Data Modelling
6 359 (16.77%) Visualisation
7 275 (12.84%) DevOps
8 230 (10.74%) Migration
9 225 (10.51%) Problem-Solving
10 224 (10.46%) Data Visualisation
11 217 (10.14%) Data Architecture
12 213 (9.95%) Data Engineering
13 212 (9.90%) Data Analytics
14 210 (9.81%) Data Science
15 189 (8.83%) Data Management
15 189 (8.83%) Stakeholder Management
16 181 (8.45%) Data Analysis
17 155 (7.24%) Data Integration
18 143 (6.68%) Decision-Making
19 134 (6.26%) Kimball Methodology
Programming Languages
1 1,463 (68.33%) SQL
2 570 (26.62%) Python
3 332 (15.51%) T-SQL
4 251 (11.72%) Java
5 180 (8.41%) C#
6 119 (5.56%) R
7 116 (5.42%) Data Analysis Expressions (DAX)
8 102 (4.76%) Scala
9 91 (4.25%) PL/SQL
10 71 (3.32%) JavaScript
11 65 (3.04%) PowerShell
12 47 (2.20%) VBA
13 44 (2.06%) VB.NET
14 33 (1.54%) C
14 33 (1.54%) C++
15 28 (1.31%) Shell Script
16 22 (1.03%) Java 8
17 20 (0.93%) U-SQL
18 16 (0.75%) Ruby
19 14 (0.65%) VB
Qualifications
1 225 (10.51%) Degree
2 95 (4.44%) Computer Science Degree
3 33 (1.54%) Microsoft Certification
4 30 (1.40%) Master's Degree
4 30 (1.40%) Sun Certification
5 24 (1.12%) AWS Certification
6 23 (1.07%) Security Cleared
7 16 (0.75%) SC Cleared
8 13 (0.61%) ISTQB
9 10 (0.47%) ISEB
10 9 (0.42%) PhD
11 7 (0.33%) TOGAF Certification
12 6 (0.28%) MCPD
12 6 (0.28%) MCSA
12 6 (0.28%) Numerate Degree
12 6 (0.28%) PRINCE2 Practitioner
13 5 (0.23%) CFA
13 5 (0.23%) DV Cleared
14 4 (0.19%) A+ Certification
15 3 (0.14%) MBA
Quality Assurance & Compliance
1 145 (6.77%) Data Quality
2 109 (5.09%) QA
3 39 (1.82%) GDPR
4 16 (0.75%) Sarbanes-Oxley
5 15 (0.70%) Actionable Recommendations
6 14 (0.65%) SLA
7 9 (0.42%) PMO
8 7 (0.33%) Solvency II
9 6 (0.28%) UCITS
10 3 (0.14%) COBIT
11 2 (0.093%) EMIR
11 2 (0.093%) ISO/IEC 27001
11 2 (0.093%) MiFID
12 1 (0.047%) IFRS
System Software
1 82 (3.83%) Docker
2 19 (0.89%) Active Directory
3 15 (0.70%) Apache Flume
3 15 (0.70%) Virtual Machines
4 11 (0.51%) HDFS
4 11 (0.51%) Hyper-V
5 5 (0.23%) Tivoli Workload Scheduler
5 5 (0.23%) VMware Infrastructure
6 4 (0.19%) Varnish
7 2 (0.093%) Apache ZooKeeper
7 2 (0.093%) Terminal Services
7 2 (0.093%) vSphere
8 1 (0.047%) Oracle RAC
8 1 (0.047%) Postfix
8 1 (0.047%) zsh
Systems Management
1 99 (4.62%) Kubernetes
2 25 (1.17%) Terraform
3 19 (0.89%) Control-M
4 17 (0.79%) Oozie
4 17 (0.79%) Opscode Chef
5 15 (0.70%) Puppet
6 14 (0.65%) Ansible
7 11 (0.51%) SCVMM
8 8 (0.37%) Hadoop YARN
8 8 (0.37%) HP Quality Center
9 7 (0.33%) Single Sign-On
10 6 (0.28%) Kibana
11 5 (0.23%) Salt
11 5 (0.23%) Tivoli
12 3 (0.14%) Argo
13 2 (0.093%) Oracle Enterprise Manager
14 1 (0.047%) Data Guard
14 1 (0.047%) Fluentd
14 1 (0.047%) Mesos
14 1 (0.047%) Oracle RMAN
Vendors
1 651 (30.41%) Microsoft
2 350 (16.35%) Tableau
3 292 (13.64%) Oracle
4 177 (8.27%) Databricks
5 165 (7.71%) Google
6 113 (5.28%) Informatica
7 85 (3.97%) SAP
8 50 (2.34%) Teradata
9 46 (2.15%) Cognos
10 44 (2.06%) Talend
11 43 (2.01%) IBM
12 38 (1.77%) Salesforce.com
13 27 (1.26%) MicroStrategy
14 26 (1.21%) Alteryx
15 24 (1.12%) Netezza
16 23 (1.07%) Hortonworks
17 18 (0.84%) Guidewire
18 17 (0.79%) Sun
19 16 (0.75%) Cloudera
19 16 (0.75%) Sybase