Period
to 2 March 2021

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

Data Warehousing
UK
6 months to
2 Mar 2021
Same period 2020 Same period 2019
Rank 106 118 120
Rank change year-on-year +12 +2 +7
Permanent jobs citing Data Warehouse 2,218 3,264 4,213
As % of all permanent jobs advertised in the UK 2.94% 2.69% 2.80%
As % of the Database & Business Intelligence category 10.97% 9.96% 9.74%
Number of salaries quoted 2,080 2,854 3,686
Median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% +6.80%
10th Percentile £36,750 £36,250 £35,375
90th Percentile £91,250 £87,500 £85,000
UK excluding London median annual salary £50,377 £47,500 £47,500
% change year-on-year +6.06% - +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 20,227 32,785 43,276
As % of all permanent IT jobs advertised in the UK 26.83% 27.04% 28.78%
Number of salaries quoted 16,661 27,063 35,983
Median annual salary £55,000 £52,500 £52,500
Median salary % change year-on-year +4.76% - +5.00%
10th Percentile £33,750 £32,500 £31,250
90th Percentile £87,500 £88,750 £85,000
UK excluding London median annual salary £48,500 £45,000 £45,000
% change year-on-year +7.78% - +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 2 March 2021.

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 2 March 2021. 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 +15 2,063 £60,000 - 332
London +15 1,083 £67,500 - 140
UK excluding London +10 1,033 £50,377 +6.06% 209
North of England +24 384 £51,439 +8.29% 65
Work from Home +2 327 £60,000 +4.35% 67
North West +10 201 £55,000 +14.58% 39
South East +5 190 £50,000 -9.09% 25
Midlands +4 155 £52,500 +15.38% 50
Yorkshire +60 154 £50,000 +5.26% 22
South West +16 124 £42,500 -5.56% 26
West Midlands -27 97 £52,500 +10.53% 43
East of England +5 81 £60,000 -4.00% 23
Scotland +21 75 £52,500 +16.67% 16
East Midlands +44 58 £52,500 +20.00% 7
North East -3 29 £42,500 +5.78% 4
Wales -27 15 £40,253 -5.29% 2
Northern Ireland +11 9 £45,000 - 2

For the 6 months to 2 March 2021, 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,451 (65.42%) SQL
2 1,434 (64.65%) Business Intelligence
3 1,009 (45.49%) ETL
4 952 (42.92%) Azure
5 825 (37.20%) Analytics
6 824 (37.15%) Power Platform
7 796 (35.89%) Power BI
8 783 (35.30%) SQL Server
9 718 (32.37%) SQL Server Integration Services
10 675 (30.43%) Agile Software Development
11 652 (29.40%) Python
12 629 (28.36%) Microsoft
13 628 (28.31%) AWS
14 607 (27.37%) Data Modelling
15 593 (26.74%) SQL Server Reporting Services
16 566 (25.52%) Finance
17 452 (20.38%) SQL Server Analysis Services
18 437 (19.70%) Data Lake
19 404 (18.21%) Visualisation
20 325 (14.65%) Analytical Skills
21 317 (14.29%) DevOps
22 315 (14.20%) Tableau
23 309 (13.93%) T-SQL
24 306 (13.80%) Big Data
25 290 (13.07%) Data Engineering
26 276 (12.44%) Azure Data Factory
27 264 (11.90%) Migration
28 263 (11.86%) Data Science
29 262 (11.81%) Data Architecture
30 259 (11.68%) GCP

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 180 (8.12%) Apache Spark
2 72 (3.25%) Apache
3 60 (2.71%) Apache Airflow
4 41 (1.85%) SharePoint
5 37 (1.67%) SAS
6 22 (0.99%) Elasticsearch
7 12 (0.54%) Apache Synapse
7 12 (0.54%) Luigi
8 9 (0.41%) Confluence
9 8 (0.36%) Jupyter
9 8 (0.36%) Oracle Workflow
10 4 (0.18%) Mule
10 4 (0.18%) Mule ESB
10 4 (0.18%) nginx
11 3 (0.14%) CMS
11 3 (0.14%) OpenStack
11 3 (0.14%) SharePoint 2010
11 3 (0.14%) SharePoint 2013
11 3 (0.14%) Tomcat
12 2 (0.090%) ArcGIS
Applications
1 141 (6.36%) Microsoft Excel
2 22 (0.99%) Microsoft Office
3 9 (0.41%) Microsoft PowerPoint
4 6 (0.27%) Spreadsheet
5 3 (0.14%) Microsoft Project
5 3 (0.14%) MS Visio
6 2 (0.090%) SPSS
7 1 (0.045%) Chatbot
Business Applications
1 31 (1.40%) Dynamics AX
2 17 (0.77%) Dynamics CRM
3 8 (0.36%) SAP CRM
4 5 (0.23%) NetSuite
4 5 (0.23%) Sentinel
5 4 (0.18%) Shopify
6 3 (0.14%) Cognos Business Intelligence
6 3 (0.14%) Dynamics NAV
6 3 (0.14%) Maximo
6 3 (0.14%) Oracle EBS
6 3 (0.14%) SAP IS-U
6 3 (0.14%) Sparx Enterprise Architect
7 2 (0.090%) Retail-J
7 2 (0.090%) Sage X3
7 2 (0.090%) SAP APO
7 2 (0.090%) SAP SCM
7 2 (0.090%) SystmOne
8 1 (0.045%) Salesforce.com CRM
8 1 (0.045%) SAP ERP
8 1 (0.045%) SAP S/4HANA
Cloud Services
1 952 (42.92%) Azure
2 824 (37.15%) Power Platform
3 628 (28.31%) AWS
4 276 (12.44%) Azure Data Factory
5 259 (11.68%) GCP
6 83 (3.74%) Serverless
7 74 (3.34%) Amazon S3
8 67 (3.02%) AWS Lambda
9 60 (2.71%) PaaS
10 55 (2.48%) Dynamics 365
11 38 (1.71%) SaaS
12 37 (1.67%) Amazon EC2
13 36 (1.62%) Amazon Kinesis
13 36 (1.62%) IaaS
13 36 (1.62%) PowerApps
14 33 (1.49%) Azure Stack
15 32 (1.44%) Amazon EMR
16 30 (1.35%) Logic Apps
17 25 (1.13%) Amazon ECS
18 24 (1.08%) Cloud Computing
Communications & Networking
1 20 (0.90%) SSH
2 8 (0.36%) Firewall
3 7 (0.32%) DNS
4 6 (0.27%) Internet
5 4 (0.18%) Broadband
5 4 (0.18%) OpenVPN
5 4 (0.18%) SSL
6 3 (0.14%) Software-Defined Networking
6 3 (0.14%) VPN
7 2 (0.090%) Ethernet
7 2 (0.090%) FTP
7 2 (0.090%) Kerberos
7 2 (0.090%) MQTT
7 2 (0.090%) SAN
8 1 (0.045%) HTTP
8 1 (0.045%) LAN
8 1 (0.045%) Network Security
8 1 (0.045%) Reverse Proxy
8 1 (0.045%) VLAN
8 1 (0.045%) WAN
Database & Business Intelligence
1 796 (35.89%) Power BI
2 783 (35.30%) SQL Server
3 718 (32.37%) SQL Server Integration Services
4 593 (26.74%) SQL Server Reporting Services
5 452 (20.38%) SQL Server Analysis Services
6 437 (19.70%) Data Lake
7 315 (14.20%) Tableau
8 306 (13.80%) Big Data
9 255 (11.50%) Snowflake Schema
10 242 (10.91%) Amazon Redshift
11 231 (10.41%) Azure SQL Data Warehouse
12 209 (9.42%) Azure SQL Database
13 199 (8.97%) Relational Database
14 196 (8.84%) NoSQL
15 147 (6.63%) Hadoop
16 114 (5.14%) Microsoft Analysis Services
17 111 (5.00%) Enterprise Data Warehouse
18 105 (4.73%) BigQuery
19 97 (4.37%) Looker
20 90 (4.06%) PostgreSQL
Development Applications
1 105 (4.73%) Git (software)
2 58 (2.61%) JIRA
3 50 (2.25%) Jenkins
4 46 (2.07%) Team Foundation Server
5 34 (1.53%) Visual Studio
6 27 (1.22%) SQL Server Management Studio (SSMS)
7 19 (0.86%) ERwin
8 18 (0.81%) TeamCity
9 13 (0.59%) Cucumber
10 12 (0.54%) Artifactory
10 12 (0.54%) GitLab
10 12 (0.54%) Octopus Deploy
11 10 (0.45%) Oracle APEX
12 9 (0.41%) Selenium
13 7 (0.32%) Bitbucket
14 6 (0.27%) ER Studio
14 6 (0.27%) Sonatype Nexus
15 5 (0.23%) Cypress.io
16 4 (0.18%) CircleCI
17 3 (0.14%) CA Release Automation
General
1 566 (25.52%) Finance
2 120 (5.41%) Banking
3 100 (4.51%) Marketing
4 98 (4.42%) Retail
5 72 (3.25%) Public Sector
6 57 (2.57%) Back Office
7 48 (2.16%) Law
8 45 (2.03%) Legal
9 24 (1.08%) Manufacturing
10 22 (0.99%) Games
11 20 (0.90%) Front Office
12 15 (0.68%) Advertising
13 14 (0.63%) Telecoms
14 13 (0.59%) Digital Economy
14 13 (0.59%) Financial Institution
15 10 (0.45%) Pharmaceutical
16 8 (0.36%) Local Government
17 7 (0.32%) Electronics
18 6 (0.27%) Billing
19 5 (0.23%) Publishing
Job Titles
1 611 (27.55%) Developer
2 462 (20.83%) Data Engineer
3 356 (16.05%) Business Intelligence Developer
4 318 (14.34%) Analyst
5 254 (11.45%) Architect
6 196 (8.84%) Data Architect
7 133 (6.00%) Data Analyst
8 114 (5.14%) Consultant
9 107 (4.82%) SQL Developer
10 90 (4.06%) Business Intelligence Analyst
11 86 (3.88%) Data Warehouse Developer
12 80 (3.61%) Power BI Developer
13 76 (3.43%) Senior Developer
14 72 (3.25%) Data Consultant
15 70 (3.16%) Data Manager
16 69 (3.11%) AWS Architect
17 67 (3.02%) Azure Engineer
18 66 (2.98%) Business Developer
19 59 (2.66%) Azure Architect
20 55 (2.48%) Business Analyst
Libraries, Frameworks & Software Standards
1 122 (5.50%) .NET
2 121 (5.46%) Kafka
3 82 (3.70%) Web Services
4 57 (2.57%) REST
5 52 (2.34%) XML
6 41 (1.85%) JSON
7 40 (1.80%) HTML
8 35 (1.58%) MDX
9 33 (1.49%) Node.js
10 32 (1.44%) PySpark
11 24 (1.08%) SOAP
12 22 (0.99%) CSS
13 21 (0.95%) AngularJS
13 21 (0.95%) Apache NiFi
14 20 (0.90%) React
15 19 (0.86%) RESTful
16 14 (0.63%) Express
17 13 (0.59%) .NET Core
18 12 (0.54%) Spring Boot
18 12 (0.54%) Underscore.js
Miscellaneous
1 325 (14.65%) Analytical Skills
2 100 (4.51%) Management Information System
3 87 (3.92%) Data Structures
4 64 (2.89%) Greenfield Project
5 54 (2.43%) User Experience
6 39 (1.76%) Algorithms
7 36 (1.62%) Hedge funds
8 31 (1.40%) NHS
9 27 (1.22%) Self-Motivation
10 26 (1.17%) Enterprise Software
11 24 (1.08%) Clustering
11 24 (1.08%) Taxonomies
12 23 (1.04%) Mobile App
12 23 (1.04%) Online Banking
12 23 (1.04%) Reference Data
13 18 (0.81%) Mobile Banking
13 18 (0.81%) Virtual Team
14 17 (0.77%) SWIFT
15 16 (0.72%) Cloud Native
15 16 (0.72%) Data Centre
Operating Systems
1 93 (4.19%) Linux
2 65 (2.93%) Windows
3 54 (2.43%) Unix
4 34 (1.53%) Red Hat Enterprise Linux
5 9 (0.41%) Windows Server
6 7 (0.32%) Windows Server 2016
7 5 (0.23%) Windows Server 2019
8 3 (0.14%) Android
8 3 (0.14%) Apple iOS
9 1 (0.045%) CentOS
9 1 (0.045%) SUSE
9 1 (0.045%) Ubuntu
9 1 (0.045%) Windows 10
Processes & Methodologies
1 1,434 (64.65%) Business Intelligence
2 1,009 (45.49%) ETL
3 825 (37.20%) Analytics
4 675 (30.43%) Agile Software Development
5 607 (27.37%) Data Modelling
6 404 (18.21%) Visualisation
7 317 (14.29%) DevOps
8 290 (13.07%) Data Engineering
9 264 (11.90%) Migration
10 263 (11.86%) Data Science
11 262 (11.81%) Data Architecture
12 258 (11.63%) Data Management
13 209 (9.42%) Data Visualisation
14 205 (9.24%) Stakeholder Management
15 201 (9.06%) Data Integration
15 201 (9.06%) Problem-Solving
16 198 (8.93%) Data Analytics
17 182 (8.21%) Data Analysis
18 169 (7.62%) Decision-Making
19 165 (7.44%) Data Governance
Programming Languages
1 1,451 (65.42%) SQL
2 652 (29.40%) Python
3 309 (13.93%) T-SQL
4 163 (7.35%) R
5 153 (6.90%) Java
6 115 (5.18%) C#
7 113 (5.09%) Data Analysis Expressions (DAX)
8 66 (2.98%) Scala
9 46 (2.07%) JavaScript
10 39 (1.76%) PL/SQL
11 35 (1.58%) PowerShell
12 30 (1.35%) C
13 27 (1.22%) Shell Script
14 19 (0.86%) Bash Shell
14 19 (0.86%) C++
15 18 (0.81%) VBA
16 16 (0.72%) Go
17 13 (0.59%) Perl
17 13 (0.59%) PHP
17 13 (0.59%) Ruby
Qualifications
1 182 (8.21%) Degree
2 45 (2.03%) Microsoft Certification
3 40 (1.80%) Security Cleared
4 31 (1.40%) SC Cleared
5 21 (0.95%) Computer Science Degree
6 13 (0.59%) Master's Degree
7 12 (0.54%) Sun Certification
8 11 (0.50%) DBS Check
9 10 (0.45%) ISEB
10 7 (0.32%) AWS Certification
10 7 (0.32%) PhD
11 5 (0.23%) Numerate Degree
12 4 (0.18%) TOGAF Certification
13 3 (0.14%) DV Cleared
13 3 (0.14%) ISTQB
13 3 (0.14%) ISTQB Foundation Certification
13 3 (0.14%) MBCS
13 3 (0.14%) MCPD
14 2 (0.090%) IIBA
14 2 (0.090%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 246 (11.09%) Data Quality
2 66 (2.98%) GDPR
3 65 (2.93%) QA
4 9 (0.41%) SLA
5 6 (0.27%) COBIT
5 6 (0.27%) PMO
6 2 (0.090%) DICOM
6 2 (0.090%) ISO/IEC 20000
6 2 (0.090%) ISO/IEC 27001
7 1 (0.045%) HIPAA
7 1 (0.045%) HL7
7 1 (0.045%) NIST
System Software
1 91 (4.10%) Docker
2 15 (0.68%) Active Directory
3 7 (0.32%) Hyper-V
4 3 (0.14%) Apache Flume
4 3 (0.14%) HDFS
4 3 (0.14%) Varnish
5 2 (0.090%) VMware Infrastructure
6 1 (0.045%) Oracle RAC
6 1 (0.045%) Virtual Desktop
6 1 (0.045%) Virtual Machines
Systems Management
1 72 (3.25%) Kubernetes
2 33 (1.49%) Terraform
3 11 (0.50%) Ansible
4 9 (0.41%) Opscode Chef
4 9 (0.41%) Puppet
5 8 (0.36%) Failover Clustering
6 3 (0.14%) Grafana
6 3 (0.14%) Microsoft Clustering
6 3 (0.14%) Prometheus
7 2 (0.090%) Kibana
7 2 (0.090%) Oozie
7 2 (0.090%) Oracle RMAN
8 1 (0.045%) Data Guard
8 1 (0.045%) Enterprise Manager Cloud Control
8 1 (0.045%) Foglight
8 1 (0.045%) Oracle Enterprise Manager
8 1 (0.045%) Oracle Identity Management
8 1 (0.045%) Oracle Identity Manager
8 1 (0.045%) vCenter Server
Vendors
1 629 (28.36%) Microsoft
2 211 (9.51%) Databricks
3 189 (8.52%) Google
4 149 (6.72%) Oracle
5 107 (4.82%) Informatica
6 94 (4.24%) SAP
7 73 (3.29%) Talend
8 56 (2.52%) Teradata
9 52 (2.34%) Cognos
10 49 (2.21%) Salesforce.com
11 35 (1.58%) Red Hat
12 33 (1.49%) IBM
13 28 (1.26%) Alteryx
14 26 (1.17%) Splunk
15 17 (0.77%) TIBCO
16 14 (0.63%) MuleSoft
17 11 (0.50%) Ab Initio
18 10 (0.45%) Cloudera
19 9 (0.41%) Netezza
19 9 (0.41%) Sage