Period
to 22 January 2020

The following table provides summary statistics for permanent job vacancies advertised in England 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 22 January 2020 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK > England
6 months to
22 Jan 2020
Same period 2019 Same period 2018
Rank 114 118 125
Rank change year-on-year +4 +7 -17
Permanent jobs citing Data Warehouse 3,290 4,011 4,384
As % of all permanent IT jobs advertised in England 2.82% 2.84% 2.70%
As % of the Database & Business Intelligence category 10.53% 9.96% 8.82%
Number of salaries quoted 2,699 3,326 3,547
England median annual salary £59,000 £55,000 £51,000
Median salary % change year-on-year +7.27% +7.84% -7.27%
10th Percentile £36,401 £36,250 £32,500
90th Percentile £87,500 £85,000 £77,500
UK median annual salary £57,500 £55,000 £50,000
% change year-on-year +4.55% +10.00% -7.41%

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 advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 31,247 40,288 49,729
As % of all permanent IT jobs advertised in England 26.81% 28.54% 30.62%
Number of salaries quoted 25,857 33,349 41,662
England median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% +5.26%
10th Percentile £32,500 £31,250 £30,500
90th Percentile £90,000 £85,000 £77,500
UK median annual salary £52,500 £52,500 £48,000
% change year-on-year - +9.38% +1.05%

Data Warehouse
Job Vacancy Trend in England

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in England.

Job vacancy trend for Data Warehouse in England

Data Warehouse
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Warehouse in England.

Salary trend for Data Warehouse in England

Data Warehouse
Salary Histogram in England

The salary distribution of IT jobs citing Data Warehouse in England over the 6 months to 22 January 2020.

Salary histogram for Data Warehouse in England

Data Warehouse
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the England region over the 6 months to 22 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
London -4 1,789 £65,000 +8.33% 264
North of England +46 513 £47,500 +5.56% 110
South East -43 352 £50,000 -3.38% 82
North West +71 335 £47,500 +5.56% 68
Midlands +28 283 £45,000 - 64
West Midlands +65 228 £45,000 -5.26% 38
East of England +39 170 £52,500 +12.30% 39
South West -26 166 £45,000 -14.29% 52
Yorkshire -9 129 £47,500 - 28
East Midlands -51 55 £45,000 +5.88% 25
North East +18 50 £40,177 -33.04% 14
Data Warehouse
UK

For the 6 months to 22 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 across the England region with a requirement for Data Warehouse.

1 2,173 (66.05%) SQL
2 2,052 (62.37%) Business Intelligence
3 1,531 (46.53%) ETL
4 1,415 (43.01%) SQL Server
5 1,110 (33.74%) SQL Server Integration Services
6 1,067 (32.43%) Analytics
7 1,057 (32.13%) Power BI
7 1,057 (32.13%) Power Platform
8 1,003 (30.49%) Azure
9 978 (29.73%) Microsoft
10 898 (27.29%) Agile Software Development
11 897 (27.26%) Data Modelling
12 829 (25.20%) SQL Server Reporting Services
13 747 (22.71%) SQL Server Analysis Services
14 746 (22.67%) Finance
15 676 (20.55%) Python
16 599 (18.21%) T-SQL
17 588 (17.87%) Big Data
18 564 (17.14%) Analytical Skills
19 560 (17.02%) AWS
20 534 (16.23%) Visualisation
21 523 (15.90%) Tableau
22 430 (13.07%) Oracle
23 401 (12.19%) Migration
24 396 (12.04%) Data Lake
25 383 (11.64%) Data Management
26 380 (11.55%) Data Quality
27 354 (10.76%) Problem-Solving
28 352 (10.70%) Data Science
29 317 (9.64%) DevOps

Data Warehouse
Co-occurring IT Skills in England 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 246 (7.48%) Apache Spark
2 94 (2.86%) SAS
3 83 (2.52%) Apache
4 72 (2.19%) SharePoint
5 69 (2.10%) Apache Airflow
6 43 (1.31%) Confluence
7 30 (0.91%) IIS
8 17 (0.52%) Apache Pig
9 16 (0.49%) Elasticsearch
10 15 (0.46%) Oracle SOA Suite
11 11 (0.33%) BizTalk Server
12 10 (0.30%) PowerExchange
12 10 (0.30%) Tomcat
13 8 (0.24%) Luigi
14 7 (0.21%) MQSeries
14 7 (0.21%) MS Exchange
15 6 (0.18%) CMS
16 5 (0.15%) Apache Solr
17 4 (0.12%) nginx
17 4 (0.12%) Oracle Workflow
Applications
1 205 (6.23%) Microsoft Excel
2 69 (2.10%) Microsoft Office
3 18 (0.55%) MS Visio
4 17 (0.52%) Microsoft PowerPoint
5 15 (0.46%) Spreadsheet
6 4 (0.12%) SPSS
7 2 (0.061%) Microsoft Project
8 1 (0.030%) SPSS Modeler
Business Applications
1 47 (1.43%) Dynamics CRM
2 25 (0.76%) Cognos Business Intelligence
3 17 (0.52%) Dynamics GP
4 9 (0.27%) Dynamics AX
5 8 (0.24%) Markit EDM
6 6 (0.18%) OPENHousing
7 5 (0.15%) Dynamics NAV
7 5 (0.15%) RiskWrite
8 4 (0.12%) NetSuite
8 4 (0.12%) Oracle Financials
8 4 (0.12%) Oracle Receivables
8 4 (0.12%) Remedy ITSM
8 4 (0.12%) Sparx Enterprise Architect
9 3 (0.091%) Eagle PACE
9 3 (0.091%) FastStats
9 3 (0.091%) Hyperion Planning
9 3 (0.091%) Oracle Applications
9 3 (0.091%) Oracle EBS R12
10 2 (0.061%) Epicor Tropos
10 2 (0.061%) thinkFolio
Cloud Services
1 1,057 (32.13%) Power Platform
2 1,003 (30.49%) Azure
3 560 (17.02%) AWS
4 255 (7.75%) GCP
5 172 (5.23%) Azure Data Factory
6 98 (2.98%) PaaS
7 89 (2.71%) SaaS
8 64 (1.95%) Serverless
9 59 (1.79%) Amazon S3
10 57 (1.73%) Cloud Computing
11 42 (1.28%) IaaS
12 38 (1.16%) Office 365
13 36 (1.09%) Dynamics 365
14 35 (1.06%) Google Analytics
15 34 (1.03%) AWS Lambda
16 31 (0.94%) Data Lake Analytics
17 30 (0.91%) GitHub
18 25 (0.76%) Azure Functions
19 24 (0.73%) OpenShift
20 23 (0.70%) Amazon Kinesis
Communications & Networking
1 29 (0.88%) Internet
2 11 (0.33%) FTP
3 10 (0.30%) SAN
4 9 (0.27%) ZigBee
5 8 (0.24%) Wi-Fi
6 6 (0.18%) Intranet
7 5 (0.15%) ATM
7 5 (0.15%) Radio Access Network
7 5 (0.15%) SMS
8 4 (0.12%) Fibre Channel
9 3 (0.091%) HTTP
9 3 (0.091%) NAS
10 2 (0.061%) Broadband
10 2 (0.061%) DHCP
10 2 (0.061%) DNS
10 2 (0.061%) Firewall
10 2 (0.061%) Skype
10 2 (0.061%) SSL
10 2 (0.061%) TCP/IP
10 2 (0.061%) WLAN
Database & Business Intelligence
1 1,415 (43.01%) SQL Server
2 1,110 (33.74%) SQL Server Integration Services
3 1,057 (32.13%) Power BI
4 829 (25.20%) SQL Server Reporting Services
5 747 (22.71%) SQL Server Analysis Services
6 588 (17.87%) Big Data
7 396 (12.04%) Data Lake
8 308 (9.36%) Relational Database
9 297 (9.03%) Hadoop
10 246 (7.48%) Amazon Redshift
11 234 (7.11%) Azure SQL Data Warehouse
12 217 (6.60%) Snowflake Schema
13 216 (6.57%) NoSQL
14 213 (6.47%) Azure SQL Database
15 195 (5.93%) Microsoft Analysis Services
15 195 (5.93%) QlikView
16 161 (4.89%) BusinessObjects
17 160 (4.86%) PostgreSQL
18 148 (4.50%) BigQuery
19 130 (3.95%) OLAP
Development Applications
1 142 (4.32%) Git (software)
2 118 (3.59%) JIRA
3 70 (2.13%) Team Foundation Server
4 60 (1.82%) Visual Studio
5 41 (1.25%) SQL Server Management Studio (SSMS)
6 37 (1.12%) ERwin
7 36 (1.09%) Visual Studio Team System
8 28 (0.85%) Jenkins
9 19 (0.58%) Bitbucket
10 18 (0.55%) IBM UrbanCode
11 15 (0.46%) Oracle Forms
12 14 (0.43%) ProC
12 14 (0.43%) Subversion
13 13 (0.40%) Maven
14 12 (0.36%) SoapUI
14 12 (0.36%) TeamCity
15 11 (0.33%) Artifactory
16 10 (0.30%) Postman
16 10 (0.30%) Selenium
17 8 (0.24%) kappa
General
1 746 (22.67%) Finance
2 152 (4.62%) Retail
3 139 (4.22%) Marketing
4 132 (4.01%) Banking
5 73 (2.22%) Public Sector
6 68 (2.07%) Legal
7 41 (1.25%) Telecoms
8 39 (1.19%) Games
9 35 (1.06%) Advertising
10 34 (1.03%) Manufacturing
11 30 (0.91%) Publishing
12 29 (0.88%) Law
13 21 (0.64%) Automotive
14 19 (0.58%) Billing
15 17 (0.52%) Back Office
16 13 (0.40%) Electronics
16 13 (0.40%) Investment Banking
17 12 (0.36%) Pharmaceutical
18 11 (0.33%) Financial Institution
19 10 (0.30%) Aerospace
Job Titles
1 1,131 (34.38%) Developer
2 616 (18.72%) Business Intelligence Developer
3 539 (16.38%) Analyst
4 447 (13.59%) Architect
5 373 (11.34%) Data Engineer
6 328 (9.97%) SQL Developer
7 293 (8.91%) Data Architect
8 211 (6.41%) Business Intelligence Analyst
9 173 (5.26%) Senior Developer
10 151 (4.59%) Data Analyst
11 134 (4.07%) Business Developer
12 132 (4.01%) Data Warehouse Developer
13 128 (3.89%) Business Analyst
14 124 (3.77%) DBA
15 122 (3.71%) Consultant
16 113 (3.43%) ETL Developer
17 100 (3.04%) SQL BI Developer
18 99 (3.01%) Senior Business Intelligence Developer
19 94 (2.86%) Solutions Architect
20 85 (2.58%) SSIS Developer
Libraries, Frameworks & Software Standards
1 238 (7.23%) .NET
2 159 (4.83%) Web Services
3 147 (4.47%) Kafka
4 133 (4.04%) MDX
5 76 (2.31%) ASP.NET
6 75 (2.28%) XML
7 65 (1.98%) HTML
8 55 (1.67%) REST
9 52 (1.58%) JSON
10 38 (1.16%) AngularJS
10 38 (1.16%) React
11 37 (1.12%) .NET Framework
11 37 (1.12%) CSS
12 34 (1.03%) WCF
13 30 (0.91%) HTML5
14 27 (0.82%) Entity Framework
15 26 (0.79%) D3.js
16 24 (0.73%) WPF
17 21 (0.64%) Node.js
17 21 (0.64%) RESTful
Miscellaneous
1 564 (17.14%) Analytical Skills
2 191 (5.81%) Management Information System
3 163 (4.95%) Data Structures
4 96 (2.92%) Greenfield Project
5 69 (2.10%) Reinsurance
6 51 (1.55%) Self-Motivation
7 44 (1.34%) Algorithms
8 41 (1.25%) User Experience
9 37 (1.12%) Public Cloud
10 36 (1.09%) NHS
11 33 (1.00%) Replication
12 30 (0.91%) Virtual Team
13 28 (0.85%) Data Centre
14 24 (0.73%) Reference Data
14 24 (0.73%) Tandem
15 21 (0.64%) Private Cloud
16 18 (0.55%) Taxonomies
17 17 (0.52%) Clustering
18 16 (0.49%) FMCG
19 14 (0.43%) Linux Command Line
Operating Systems
1 159 (4.83%) Linux
2 141 (4.29%) Windows
3 100 (3.04%) Unix
4 52 (1.58%) Windows Server
5 20 (0.61%) Windows 7
6 13 (0.40%) Windows 10
7 11 (0.33%) Solaris
8 10 (0.30%) Windows Server 2012
9 9 (0.27%) Oracle Linux
10 8 (0.24%) Red Hat Enterprise Linux
10 8 (0.24%) Windows Server 2008
11 6 (0.18%) Windows XP
12 4 (0.12%) Android
12 4 (0.12%) Apple iOS
12 4 (0.12%) VME
12 4 (0.12%) Windows 2000
13 2 (0.061%) AIX
13 2 (0.061%) CentOS
13 2 (0.061%) VMS
13 2 (0.061%) Windows Server 2003
Processes & Methodologies
1 2,052 (62.37%) Business Intelligence
2 1,531 (46.53%) ETL
3 1,067 (32.43%) Analytics
4 898 (27.29%) Agile Software Development
5 897 (27.26%) Data Modelling
6 534 (16.23%) Visualisation
7 401 (12.19%) Migration
8 383 (11.64%) Data Management
9 354 (10.76%) Problem-Solving
10 352 (10.70%) Data Science
11 317 (9.64%) DevOps
12 315 (9.57%) Data Visualisation
13 313 (9.51%) Data Integration
14 312 (9.48%) Data Architecture
15 279 (8.48%) Data Analytics
16 269 (8.18%) Data Analysis
17 232 (7.05%) Kimball Methodology
18 224 (6.81%) Data Engineering
18 224 (6.81%) Decision-Making
19 216 (6.57%) Stakeholder Management
Programming Languages
1 2,173 (66.05%) SQL
2 676 (20.55%) Python
3 599 (18.21%) T-SQL
4 309 (9.39%) C#
5 272 (8.27%) Java
6 193 (5.87%) Data Analysis Expressions (DAX)
7 184 (5.59%) R
8 169 (5.14%) PL/SQL
9 104 (3.16%) JavaScript
10 96 (2.92%) Scala
11 94 (2.86%) VBA
12 78 (2.37%) PowerShell
13 53 (1.61%) Shell Script
14 51 (1.55%) VB
15 50 (1.52%) Bash Shell
16 37 (1.12%) VB.NET
17 36 (1.09%) Java 8
18 24 (0.73%) C
19 21 (0.64%) U-SQL
20 17 (0.52%) Perl
Qualifications
1 257 (7.81%) Degree
2 86 (2.61%) Computer Science Degree
3 41 (1.25%) Security Cleared
4 28 (0.85%) Microsoft Certification
5 25 (0.76%) ISTQB
6 17 (0.52%) Master's Degree
7 14 (0.43%) MCSA
8 13 (0.40%) MBA
9 12 (0.36%) SC Cleared
10 11 (0.33%) ITIL Foundation Certificate
10 11 (0.33%) PhD
11 9 (0.27%) ITIL Certification
12 7 (0.21%) AWS Certification
12 7 (0.21%) TOGAF Certification
13 6 (0.18%) Numerate Degree
14 5 (0.15%) ISTQB Foundation Certification
14 5 (0.15%) MCSE
14 5 (0.15%) PRINCE2 Practitioner
15 4 (0.12%) PMI Certification
15 4 (0.12%) Postgraduate
Quality Assurance & Compliance
1 380 (11.55%) Data Quality
2 172 (5.23%) QA
3 61 (1.85%) GDPR
4 45 (1.37%) SLA
5 17 (0.52%) Solvency II
6 13 (0.40%) ISO/IEC 27001
7 6 (0.18%) PMO
8 4 (0.12%) COBIT
9 2 (0.061%) Actionable Recommendations
9 2 (0.061%) HL7
9 2 (0.061%) PCI DSS
9 2 (0.061%) Sarbanes-Oxley
10 1 (0.030%) Basel III
10 1 (0.030%) GMP
10 1 (0.030%) IFRS
10 1 (0.030%) IFRS 9
10 1 (0.030%) ISO 9000
10 1 (0.030%) ISO 9001
10 1 (0.030%) NCSC
System Software
1 88 (2.67%) Docker
2 44 (1.34%) HDFS
3 35 (1.06%) Active Directory
4 30 (0.91%) Apache Flume
5 18 (0.55%) Tivoli Workload Scheduler
6 15 (0.46%) VMware Infrastructure
7 10 (0.30%) Hyper-V
8 9 (0.27%) Microsoft App-V
9 6 (0.18%) Oracle RAC
10 5 (0.15%) Apache ZooKeeper
11 4 (0.12%) NFS
11 4 (0.12%) Veritas Volume Manager
11 4 (0.12%) Virtual Machines
12 2 (0.061%) Oracle Clusterware
12 2 (0.061%) Varnish
13 1 (0.030%) Cronacle
13 1 (0.030%) vSphere
Systems Management
1 76 (2.31%) Kubernetes
2 31 (0.94%) Oozie
3 24 (0.73%) Control-M
3 24 (0.73%) Terraform
4 22 (0.67%) Ansible
5 18 (0.55%) Opscode Chef
5 18 (0.55%) Tivoli
6 17 (0.52%) Puppet
7 15 (0.46%) Foglight
7 15 (0.46%) LiteSpeed
8 10 (0.30%) SCOM
9 9 (0.27%) SCCM
10 8 (0.24%) Oracle RMAN
11 6 (0.18%) Oracle Enterprise Manager
12 5 (0.15%) BladeLogic
12 5 (0.15%) Hadoop YARN
13 4 (0.12%) Oracle ZFS
13 4 (0.12%) Simpana
14 3 (0.091%) Failover Clustering
14 3 (0.091%) HP ALM
Vendors
1 978 (29.73%) Microsoft
2 523 (15.90%) Tableau
3 430 (13.07%) Oracle
4 236 (7.17%) Google
5 222 (6.75%) Informatica
6 166 (5.05%) SAP
7 163 (4.95%) IBM
8 125 (3.80%) Databricks
9 123 (3.74%) Cognos
10 116 (3.53%) Teradata
11 87 (2.64%) Talend
12 84 (2.55%) Cloudera
13 48 (1.46%) Netezza
14 40 (1.22%) Alteryx
15 32 (0.97%) MicroStrategy
16 30 (0.91%) Salesforce.com
17 27 (0.82%) Hortonworks
18 24 (0.73%) Ab Initio
19 23 (0.70%) InterSystems
20 21 (0.64%) VMware