Job Vacancy Trend Salary Trend Salary Histogram Job Locations Skill Sets
Period
to 10 May 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 10 May 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK
6 months to
10 May 2021		 Same period 2020 Same period 2019
Rank 111 112 113
Rank change year-on-year +1 +1 +16
Permanent jobs citing Data Warehouse 2,629 2,802 4,276
As % of all permanent jobs advertised in the UK 3.00% 2.80% 2.91%
As % of the Database & Business Intelligence category 11.29% 10.40% 10.31%
Number of salaries quoted 2,143 2,352 3,504
10th Percentile £36,250 £36,250 £36,750
25th Percentile £45,000 £43,750 £42,750
Median annual salary (50th Percentile) £60,000 £60,000 £55,000
Median % change year-on-year - +9.09% +4.76%
75th Percentile £77,500 £75,000 £72,500
90th Percentile £91,250 £87,500 £85,000
UK excluding London median annual salary £50,000 £50,000 £48,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 23,284 26,946 41,460
As % of all permanent IT jobs advertised in the UK 26.54% 26.93% 28.25%
Number of salaries quoted 18,184 22,190 34,088
10th Percentile £33,750 £32,500 £31,250
25th Percentile £41,250 £40,000 £37,500
Median annual salary (50th Percentile) £55,000 £52,500 £52,500
Median % change year-on-year +4.76% - +5.00%
75th Percentile £73,750 £72,500 £70,000
90th Percentile £88,750 £90,000 £85,000
UK excluding London median annual salary £47,500 £46,000 £45,000
% change year-on-year +3.26% +2.22% +3.45%

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 10 May 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 10 May 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 +1 2,416 £60,000 - 403
UK excluding London +2 1,263 £50,000 - 235
London +11 1,198 £72,000 +6.67% 186
North of England +37 459 £50,000 -4.76% 64
Work from Home +26 458 £60,000 +9.09% 73
North West +12 224 £52,500 +5.00% 34
South East -20 219 £50,000 -9.09% 38
Midlands -15 217 £49,750 +10.56% 65
Yorkshire +51 201 £50,000 -13.04% 27
West Midlands -4 168 £52,000 +5.34% 50
South West +8 152 £45,000 -2.17% 22
East of England -1 108 £57,500 -2.54% 24
Scotland +35 92 £52,500 +6.06% 17
East Midlands -6 49 £41,250 +3.13% 15
North East +12 34 £41,695 -0.73% 3
Wales -30 9 £42,626 +0.30% 3
Northern Ireland +3 8 £40,000 -11.11% 2

For the 6 months to 10 May 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,700 (64.66%) Business Intelligence
2 1,684 (64.05%) SQL
3 1,137 (43.25%) ETL
4 1,095 (41.65%) Azure
5 1,052 (40.02%) Power Platform
6 1,015 (38.61%) Power BI
7 993 (37.77%) Analytics
8 877 (33.36%) SQL Server
9 812 (30.89%) SQL Server Integration Services
10 773 (29.40%) Python
11 737 (28.03%) Agile Software Development
12 721 (27.42%) Data Modelling
13 689 (26.21%) AWS
14 688 (26.17%) Microsoft
15 686 (26.09%) SQL Server Reporting Services
16 634 (24.12%) Finance
17 507 (19.28%) Visualisation
18 498 (18.94%) SQL Server Analysis Services
19 481 (18.30%) Data Lake
20 459 (17.46%) Social Skills
21 372 (14.15%) Tableau
22 371 (14.11%) Big Data
23 365 (13.88%) DevOps
24 357 (13.58%) Data Architecture
25 355 (13.50%) T-SQL
26 354 (13.47%) Analytical Skills
27 345 (13.12%) Azure Data Factory
28 335 (12.74%) Data Engineering
29 302 (11.49%) Data Science
30 301 (11.45%) Migration

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 197 (7.49%) Apache Spark
2 86 (3.27%) Apache Airflow
3 56 (2.13%) Apache
4 34 (1.29%) SAS
5 33 (1.26%) SharePoint
6 22 (0.84%) Confluence
7 16 (0.61%) Luigi
8 15 (0.57%) Elasticsearch
8 15 (0.57%) Oracle Workflow
9 7 (0.27%) Oracle Application Server
10 5 (0.19%) Apache Synapse
10 5 (0.19%) Gunicorn
10 5 (0.19%) IIS
10 5 (0.19%) NServiceBus
10 5 (0.19%) WebLogic
11 4 (0.15%) CMS
12 3 (0.11%) Mule
12 3 (0.11%) Mule ESB
13 2 (0.076%) ArcGIS
13 2 (0.076%) Jupyter
Applications
1 176 (6.69%) Microsoft Excel
2 25 (0.95%) Microsoft Office
3 13 (0.49%) Microsoft PowerPoint
3 13 (0.49%) Spreadsheet
4 9 (0.34%) MS Visio
5 7 (0.27%) Microsoft Project
6 1 (0.038%) Chatbot
6 1 (0.038%) SPSS
Business Applications
1 32 (1.22%) Dynamics AX
2 31 (1.18%) Dynamics CRM
3 14 (0.53%) Shopify
4 13 (0.49%) NetSuite
5 8 (0.30%) Oracle EBS
6 6 (0.23%) Dynamics NAV
6 6 (0.23%) Sentinel
7 5 (0.19%) Magento
7 5 (0.19%) SAP CRM
8 4 (0.15%) HFM
8 4 (0.15%) Hyperion Planning
8 4 (0.15%) Oracle Subledger Accounting
8 4 (0.15%) Sage 50
9 2 (0.076%) Adobe Campaign
9 2 (0.076%) Oracle Applications
9 2 (0.076%) Oracle EBS R12
9 2 (0.076%) Oracle Financials
9 2 (0.076%) Retail-J
9 2 (0.076%) Sage X3
10 1 (0.038%) Salesforce.com CRM
Cloud Services
1 1,095 (41.65%) Azure
2 1,052 (40.02%) Power Platform
3 689 (26.21%) AWS
4 345 (13.12%) Azure Data Factory
5 234 (8.90%) GCP
6 189 (7.19%) Azure Synapse Analytics
7 89 (3.39%) Amazon S3
8 85 (3.23%) Serverless
9 79 (3.00%) Dynamics 365
10 67 (2.55%) PaaS
11 57 (2.17%) Azure Stack
12 56 (2.13%) SaaS
13 54 (2.05%) PowerApps
14 48 (1.83%) Amazon EC2
15 47 (1.79%) AWS Lambda
16 46 (1.75%) Azure Cosmos DB
17 43 (1.64%) IaaS
18 42 (1.60%) Cloud Computing
18 42 (1.60%) Matillion
19 39 (1.48%) Amazon EMR
Communications & Networking
1 26 (0.99%) SSH
2 14 (0.53%) Internet
3 9 (0.34%) Firewall
4 8 (0.30%) FTP
4 8 (0.30%) VPN
5 7 (0.27%) DNS
6 6 (0.23%) Extranet
6 6 (0.23%) Intranet
6 6 (0.23%) Network Security
7 4 (0.15%) OpenVPN
7 4 (0.15%) SSL
8 3 (0.11%) Broadband
8 3 (0.11%) HTTP
8 3 (0.11%) Reverse Proxy
8 3 (0.11%) SAN
8 3 (0.11%) Software-Defined Networking
9 2 (0.076%) Ethernet
9 2 (0.076%) Kerberos
9 2 (0.076%) MQTT
10 1 (0.038%) LAN
Database & Business Intelligence
1 1,015 (38.61%) Power BI
2 877 (33.36%) SQL Server
3 812 (30.89%) SQL Server Integration Services
4 686 (26.09%) SQL Server Reporting Services
5 498 (18.94%) SQL Server Analysis Services
6 481 (18.30%) Data Lake
7 372 (14.15%) Tableau
8 371 (14.11%) Big Data
9 268 (10.19%) Snowflake Schema
10 245 (9.32%) Azure SQL Data Warehouse
11 230 (8.75%) Amazon Redshift
12 218 (8.29%) Relational Database
13 210 (7.99%) Azure SQL Database
14 189 (7.19%) NoSQL
15 143 (5.44%) Hadoop
16 139 (5.29%) Enterprise Data Warehouse
17 138 (5.25%) Microsoft Analysis Services
18 98 (3.73%) BigQuery
18 98 (3.73%) PostgreSQL
19 97 (3.69%) MySQL
Development Applications
1 98 (3.73%) Git (software)
2 64 (2.43%) JIRA
3 52 (1.98%) Team Foundation Server
4 47 (1.79%) Visual Studio
5 42 (1.60%) Jenkins
6 33 (1.26%) Oracle APEX
7 25 (0.95%) SQL Server Management Studio (SSMS)
8 24 (0.91%) Bitbucket
9 23 (0.87%) ERwin
10 14 (0.53%) TeamCity
11 10 (0.38%) ER Studio
11 10 (0.38%) Octopus Deploy
12 9 (0.34%) CircleCI
13 8 (0.30%) Sonatype Nexus
14 7 (0.27%) Jasmine
14 7 (0.27%) Selenium
15 6 (0.23%) Atlassian Bamboo
15 6 (0.23%) Cucumber
15 6 (0.23%) PowerDesigner
15 6 (0.23%) Spinnaker
General
1 634 (24.12%) Finance
2 459 (17.46%) Social Skills
3 354 (13.47%) Analytical Skills
4 110 (4.18%) Marketing
5 101 (3.84%) Banking
6 94 (3.58%) Retail
7 70 (2.66%) Back Office
8 67 (2.55%) Public Sector
9 66 (2.51%) Law
10 50 (1.90%) Presentation Skills
11 46 (1.75%) Legal
12 40 (1.52%) Manufacturing
13 35 (1.33%) Influencing Skills
14 22 (0.84%) Publishing
15 20 (0.76%) Investment Banking
15 20 (0.76%) Organisational Skills
16 19 (0.72%) Advertising
16 19 (0.72%) Games
17 15 (0.57%) Pharmaceutical
18 13 (0.49%) Billing
Job Titles
1 654 (24.88%) Developer
2 580 (22.06%) Data Engineer
3 397 (15.10%) Analyst
4 378 (14.38%) Business Intelligence Developer
5 347 (13.20%) Architect
6 270 (10.27%) Data Architect
7 148 (5.63%) Data Analyst
8 123 (4.68%) Azure Engineer
9 120 (4.56%) Business Intelligence Analyst
10 116 (4.41%) Consultant
11 106 (4.03%) Power BI Developer
12 99 (3.77%) Azure Architect
13 98 (3.73%) SQL Developer
14 95 (3.61%) Senior Data Engineer
15 91 (3.46%) Data Warehouse Developer
16 82 (3.12%) Business Developer
17 79 (3.00%) AWS Architect
18 67 (2.55%) Senior Developer
19 66 (2.51%) Applications Support
20 61 (2.32%) DBA
Libraries, Frameworks & Software Standards
1 163 (6.20%) .NET
2 135 (5.14%) Kafka
3 89 (3.39%) XML
4 85 (3.23%) Web Services
5 74 (2.81%) REST
6 60 (2.28%) HTML
7 52 (1.98%) JSON
8 48 (1.83%) MDX
9 37 (1.41%) PySpark
10 34 (1.29%) .NET Framework
11 31 (1.18%) Node.js
12 27 (1.03%) Middleware
13 26 (0.99%) .NET Core
13 26 (0.99%) RESTful
14 23 (0.87%) CSS
15 22 (0.84%) SOAP
16 21 (0.80%) AngularJS
17 20 (0.76%) React
18 18 (0.68%) jQuery
19 17 (0.65%) ASP.NET
Miscellaneous
1 127 (4.83%) Management Information System
2 122 (4.64%) Data Structures
3 64 (2.43%) User Experience
4 59 (2.24%) Greenfield Project
5 52 (1.98%) Algorithms
6 45 (1.71%) Self-Motivation
7 32 (1.22%) Enterprise Software
7 32 (1.22%) Life Science
8 29 (1.10%) SWIFT
8 29 (1.10%) Taxonomies
9 28 (1.07%) NHS
10 23 (0.87%) Video Conferencing
11 22 (0.84%) Hedge funds
12 20 (0.76%) Virtual Team
13 19 (0.72%) Reference Data
14 18 (0.68%) Cloud Native
15 16 (0.61%) Data Centre
15 16 (0.61%) Reinsurance
16 15 (0.57%) New Media
16 15 (0.57%) Video\Live Streaming
Operating Systems
1 150 (5.71%) Linux
2 106 (4.03%) Windows
3 70 (2.66%) Unix
4 55 (2.09%) Red Hat Enterprise Linux
5 13 (0.49%) Windows Server
6 12 (0.46%) Android
6 12 (0.46%) Apple iOS
7 10 (0.38%) Windows 10
8 5 (0.19%) SUSE
8 5 (0.19%) Windows 7
9 2 (0.076%) CentOS
9 2 (0.076%) Windows Server 2016
9 2 (0.076%) Windows Server 2019
10 1 (0.038%) Ubuntu
Processes & Methodologies
1 1,700 (64.66%) Business Intelligence
2 1,137 (43.25%) ETL
3 993 (37.77%) Analytics
4 737 (28.03%) Agile Software Development
5 721 (27.42%) Data Modelling
6 507 (19.28%) Visualisation
7 365 (13.88%) DevOps
8 357 (13.58%) Data Architecture
9 335 (12.74%) Data Engineering
10 302 (11.49%) Data Science
11 301 (11.45%) Migration
12 278 (10.57%) Problem-Solving
13 277 (10.54%) Data Pipeline
14 263 (10.00%) Data Management
15 257 (9.78%) Data Visualisation
16 248 (9.43%) Data Analytics
17 224 (8.52%) Data Analysis
18 216 (8.22%) Data Governance
18 216 (8.22%) Data Integration
19 204 (7.76%) Stakeholder Management
Programming Languages
1 1,684 (64.05%) SQL
2 773 (29.40%) Python
3 355 (13.50%) T-SQL
4 186 (7.07%) Java
5 153 (5.82%) R
6 145 (5.52%) C#
7 135 (5.14%) Data Analysis Expressions (DAX)
8 94 (3.58%) Scala
9 65 (2.47%) JavaScript
10 61 (2.32%) PowerShell
11 58 (2.21%) PL/SQL
12 41 (1.56%) Bash Shell
13 39 (1.48%) Shell Script
14 33 (1.26%) C++
15 31 (1.18%) C
16 27 (1.03%) Go
17 22 (0.84%) Perl
18 20 (0.76%) VBA
19 19 (0.72%) TypeScript
20 18 (0.68%) PHP
Qualifications
1 212 (8.06%) Degree
2 51 (1.94%) Microsoft Certification
2 51 (1.94%) Security Cleared
3 45 (1.71%) SC Cleared
4 36 (1.37%) Computer Science Degree
5 20 (0.76%) Master's Degree
6 13 (0.49%) PhD
7 11 (0.42%) DBS Check
8 10 (0.38%) Numerate Degree
9 7 (0.27%) AWS Certification
9 7 (0.27%) DV Cleared
9 7 (0.27%) ISEB
10 6 (0.23%) CISA
10 6 (0.23%) CISM
10 6 (0.23%) CISSP
10 6 (0.23%) ISSAP
10 6 (0.23%) ISSEP
10 6 (0.23%) PRINCE2 Practitioner
11 5 (0.19%) ITIL Foundation Certificate
11 5 (0.19%) TOGAF Certification
Quality Assurance & Compliance
1 269 (10.23%) Data Quality
2 93 (3.54%) QA
3 65 (2.47%) GDPR
4 11 (0.42%) COBIT
5 10 (0.38%) GRC
6 8 (0.30%) ISO/IEC 27001
7 7 (0.27%) NIST
7 7 (0.27%) SLA
8 4 (0.15%) Sarbanes-Oxley
9 3 (0.11%) SOC 2
10 2 (0.076%) HL7
10 2 (0.076%) PMO
11 1 (0.038%) HIPAA
11 1 (0.038%) NCSC
System Software
1 97 (3.69%) Docker
2 16 (0.61%) Active Directory
3 8 (0.30%) Virtual Machines
4 7 (0.27%) Hyper-V
5 5 (0.19%) Virtual Desktop
6 4 (0.15%) Apache Flume
7 3 (0.11%) Ceph
8 2 (0.076%) HDFS
8 2 (0.076%) VirtualBox
8 2 (0.076%) VMware Infrastructure
9 1 (0.038%) Apache ZooKeeper
Systems Management
1 85 (3.23%) Kubernetes
2 51 (1.94%) Terraform
3 24 (0.91%) Ansible
3 24 (0.91%) Puppet
4 15 (0.57%) Opscode Chef
5 9 (0.34%) Grafana
5 9 (0.34%) Prometheus
6 6 (0.23%) Failover Clustering
7 5 (0.19%) Oracle Enterprise Manager
7 5 (0.19%) Single Sign-On
8 4 (0.15%) Oozie
9 3 (0.11%) Data Guard
9 3 (0.11%) Galera Cluster
10 2 (0.076%) Docker Swarm
10 2 (0.076%) Kibana
10 2 (0.076%) Oracle RMAN
11 1 (0.038%) Control-M
11 1 (0.038%) Oracle Identity Management
11 1 (0.038%) Oracle Identity Manager
11 1 (0.038%) SCOM
Vendors
1 688 (26.17%) Microsoft
2 247 (9.40%) Databricks
3 234 (8.90%) Oracle
4 187 (7.11%) Google
5 131 (4.98%) Informatica
6 101 (3.84%) SAP
7 80 (3.04%) Talend
8 66 (2.51%) Salesforce.com
9 62 (2.36%) Teradata
10 52 (1.98%) Red Hat
11 48 (1.83%) Alteryx
12 45 (1.71%) Cognos
13 28 (1.07%) IBM
14 27 (1.03%) Splunk
15 22 (0.84%) MuleSoft
16 19 (0.72%) Cloudera
17 14 (0.53%) MicroStrategy
17 14 (0.53%) TIBCO
18 13 (0.49%) Atlassian
18 13 (0.49%) Sage
445 Data Warehouse job vacancies Nationwide