Period
to 16 September 2019

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

Data Warehousing
UK
6 months to
16 Sep 2019
Same period 2018 Same period 2017
Rank 102 110 115
Rank change year-on-year +8 +5 -11
Permanent jobs citing Data Warehouse 4,361 4,771 5,053
As % of all permanent IT jobs advertised in the UK 3.10% 2.88% 2.86%
As % of the Database & Business Intelligence category 11.43% 9.67% 9.36%
Number of salaries quoted 3,630 3,918 4,019
UK median annual salary £55,000 £55,000 £50,000
Median salary % change year-on-year - +10.00% -4.76%
10th Percentile £36,401 £35,000 £32,500
90th Percentile £83,750 £85,000 £78,750
UK excluding London median annual salary £47,500 £47,500 £45,000
% change year-on-year - +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 38,155 49,326 53,963
As % of all permanent IT jobs advertised in the UK 27.08% 29.77% 30.60%
Number of salaries quoted 31,168 40,199 44,447
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £31,250 £30,000
90th Percentile £85,000 £82,500 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% +2.41%

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 16 September 2019.

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 16 September 2019. 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 +10 4,110 £55,000 - 510
London +16 2,326 £62,500 +1.63% 191
UK excluding London -2 1,961 £47,500 - 368
North of England +2 584 £45,412 +0.92% 121
South East -14 457 £50,000 -4.76% 71
North West +16 337 £47,500 +5.56% 75
Midlands +6 325 £45,000 +1.69% 54
South West +33 262 £52,500 +22.09% 41
Yorkshire -22 207 £45,000 -5.26% 42
West Midlands +42 205 £47,500 +5.56% 41
East of England -10 140 £47,500 -5.00% 32
Scotland +15 138 £45,500 -4.21% 33
East Midlands -23 120 £44,750 +2.87% 13
Wales -5 44 £41,000 -3.53% 16
North East +1 41 £50,000 +11.11% 4
Northern Ireland -6 10 £45,000 +50.00%
Channel Islands +6 2 £50,000 +11.11%

For the 6 months to 16 September 2019, 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,846 (65.26%) SQL
2 2,710 (62.14%) Business Intelligence
3 1,993 (45.70%) SQL Server
4 1,967 (45.10%) ETL
5 1,721 (39.46%) SQL Server Integration Services
6 1,434 (32.88%) Analytics
7 1,402 (32.15%) Agile Software Development
8 1,391 (31.90%) Power Platform
9 1,388 (31.83%) Power BI
10 1,360 (31.19%) SQL Server Reporting Services
11 1,342 (30.77%) Microsoft
12 1,257 (28.82%) Azure
13 1,214 (27.84%) SQL Server Analysis Services
14 1,145 (26.26%) Data Modelling
15 1,086 (24.90%) Finance
16 956 (21.92%) T-SQL
17 791 (18.14%) Python
18 773 (17.73%) Big Data
19 716 (16.42%) Visualisation
20 686 (15.73%) Tableau
21 671 (15.39%) Analytical Skills
22 624 (14.31%) Oracle
23 622 (14.26%) AWS
24 604 (13.85%) Data Lake
25 521 (11.95%) C#
26 464 (10.64%) Data Management
27 457 (10.48%) Hadoop
28 437 (10.02%) Relational Database
29 435 (9.97%) Problem-Solving
30 427 (9.79%) Data Architecture

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 311 (7.13%) Apache Spark
2 131 (3.00%) SAS
3 98 (2.25%) SharePoint
4 83 (1.90%) Apache
5 44 (1.01%) Apache Pig
6 40 (0.92%) Apache Airflow
7 29 (0.66%) Confluence
8 23 (0.53%) Oracle SOA Suite
9 17 (0.39%) Elasticsearch
10 16 (0.37%) Apache Solr
11 15 (0.34%) IIS
12 10 (0.23%) WordPress
13 8 (0.18%) BizTalk Server
13 8 (0.18%) CMS
13 8 (0.18%) Luigi
14 6 (0.14%) SharePoint 2013
15 5 (0.11%) Oracle Workflow
16 4 (0.092%) MS Exchange
16 4 (0.092%) Tomcat
17 3 (0.069%) ArcGIS
Applications
1 269 (6.17%) Microsoft Excel
2 103 (2.36%) Microsoft Office
3 35 (0.80%) Spreadsheet
4 22 (0.50%) MS Visio
5 21 (0.48%) SPSS
6 20 (0.46%) Microsoft PowerPoint
7 11 (0.25%) Microsoft Project
8 4 (0.092%) InfoPath
9 2 (0.046%) Chatbot
10 1 (0.023%) Adobe Premiere
10 1 (0.023%) SPSS Modeler
Business Applications
1 47 (1.08%) Dynamics CRM
2 29 (0.66%) Cognos Business Intelligence
3 20 (0.46%) Dynamics NAV
3 20 (0.46%) SAP ERP
4 9 (0.21%) JDE OneWorld
4 9 (0.21%) Markit EDM
4 9 (0.21%) SAP Hybris
4 9 (0.21%) SAP Oil and Gas
5 8 (0.18%) Dynamics AX
5 8 (0.18%) SAP BPC
6 7 (0.16%) FastStats
7 6 (0.14%) NetSuite
7 6 (0.14%) OPENHousing
8 4 (0.092%) Adobe Campaign
8 4 (0.092%) Infor SunSystems
8 4 (0.092%) Oracle EBS
8 4 (0.092%) Oracle ERP
8 4 (0.092%) Oracle Receivables
9 3 (0.069%) Cognos TM1
9 3 (0.069%) Maximo
Cloud Services
1 1,391 (31.90%) Power Platform
2 1,257 (28.82%) Azure
3 622 (14.26%) AWS
4 265 (6.08%) Azure Data Factory
5 244 (5.60%) GCP
6 103 (2.36%) PaaS
7 86 (1.97%) SaaS
8 77 (1.77%) Serverless
9 60 (1.38%) Amazon S3
10 56 (1.28%) Cloud Computing
11 49 (1.12%) PowerApps
12 42 (0.96%) IaaS
13 41 (0.94%) Office 365
14 40 (0.92%) Amazon EMR
15 38 (0.87%) Azure Machine Learning
15 38 (0.87%) Google Analytics
16 36 (0.83%) Data Lake Analytics
17 34 (0.78%) Azure Functions
18 28 (0.64%) Cortana Intelligence Suite
19 19 (0.44%) Dynamics 365
Communications & Networking
1 25 (0.57%) Broadband
2 23 (0.53%) Internet
3 15 (0.34%) DNS
3 15 (0.34%) SAN
4 14 (0.32%) FTP
5 10 (0.23%) Intranet
6 6 (0.14%) DHCP
6 6 (0.14%) Network Security
6 6 (0.14%) Wi-Fi
7 5 (0.11%) SMS
8 4 (0.092%) DSL
8 4 (0.092%) Fibre Channel
9 3 (0.069%) Firewall
9 3 (0.069%) MVNO
9 3 (0.069%) TCP/IP
10 2 (0.046%) HTTP
10 2 (0.046%) HTTPS
10 2 (0.046%) NAS
10 2 (0.046%) VoIP
10 2 (0.046%) WLAN
Database & Business Intelligence
1 1,993 (45.70%) SQL Server
2 1,721 (39.46%) SQL Server Integration Services
3 1,388 (31.83%) Power BI
4 1,360 (31.19%) SQL Server Reporting Services
5 1,214 (27.84%) SQL Server Analysis Services
6 773 (17.73%) Big Data
7 604 (13.85%) Data Lake
8 457 (10.48%) Hadoop
9 437 (10.02%) Relational Database
10 328 (7.52%) Azure SQL Database
11 307 (7.04%) Azure SQL Data Warehouse
12 291 (6.67%) QlikView
13 269 (6.17%) NoSQL
14 242 (5.55%) BusinessObjects
15 228 (5.23%) OLAP
16 219 (5.02%) SQL Server 2012
17 207 (4.75%) Microsoft Analysis Services
18 199 (4.56%) Amazon Redshift
19 198 (4.54%) SQL Server 2016
20 195 (4.47%) Apache Hive
Development Applications
1 209 (4.79%) Git (software)
2 125 (2.87%) Visual Studio
3 122 (2.80%) JIRA
4 119 (2.73%) Team Foundation Server
5 80 (1.83%) Jenkins
6 49 (1.12%) Bitbucket
7 45 (1.03%) Maven
8 42 (0.96%) Cucumber
9 40 (0.92%) Subversion
10 39 (0.89%) SQL Server Management Studio (SSMS)
11 38 (0.87%) Selenium
12 36 (0.83%) ERwin
13 30 (0.69%) IBM UrbanCode
14 27 (0.62%) Artifactory
15 24 (0.55%) Oracle Forms
16 22 (0.50%) ER Studio
17 21 (0.48%) Visual Studio Team System
18 20 (0.46%) Oracle APEX
18 20 (0.46%) ProC
18 20 (0.46%) TeamCity
General
1 1,086 (24.90%) Finance
2 327 (7.50%) Retail
3 273 (6.26%) Banking
4 191 (4.38%) Marketing
5 126 (2.89%) Public Sector
6 106 (2.43%) Telecoms
7 70 (1.61%) Manufacturing
8 65 (1.49%) Legal
9 40 (0.92%) Law
10 38 (0.87%) Investment Banking
11 37 (0.85%) Electronics
12 36 (0.83%) Advertising
13 34 (0.78%) Games
14 31 (0.71%) Billing
15 21 (0.48%) Financial Institution
16 19 (0.44%) Back Office
16 19 (0.44%) Housing Association
17 18 (0.41%) Local Government
17 18 (0.41%) Social Housing
18 16 (0.37%) Pharmaceutical
Job Titles
1 1,812 (41.55%) Developer
2 1,019 (23.37%) Business Intelligence Developer
3 598 (13.71%) Analyst
4 585 (13.41%) SQL Developer
5 477 (10.94%) Data Engineer
6 436 (10.00%) Architect
7 299 (6.86%) SQL BI Developer
8 273 (6.26%) Data Architect
9 247 (5.66%) Senior Developer
10 246 (5.64%) Business Intelligence Analyst
11 243 (5.57%) Data Warehouse Developer
12 191 (4.38%) Business Developer
13 178 (4.08%) SSIS Developer
14 171 (3.92%) Data Analyst
15 163 (3.74%) SSRS Developer
16 159 (3.65%) Senior Business Intelligence Developer
17 158 (3.62%) Consultant
18 135 (3.10%) Database Developer
19 131 (3.00%) SQL Server Developer
20 130 (2.98%) DBA
Libraries, Frameworks & Software Standards
1 392 (8.99%) .NET
2 241 (5.53%) MDX
3 184 (4.22%) Web Services
4 162 (3.71%) Kafka
5 95 (2.18%) XML
6 93 (2.13%) ASP.NET
7 86 (1.97%) HTML
8 74 (1.70%) .NET Framework
9 68 (1.56%) JSON
10 67 (1.54%) WCF
11 47 (1.08%) React
12 44 (1.01%) REST
13 43 (0.99%) CSS
13 43 (0.99%) WPF
14 39 (0.89%) AngularJS
14 39 (0.89%) Apache NiFi
15 33 (0.76%) Middleware
15 33 (0.76%) RESTful
16 32 (0.73%) HTML5
17 31 (0.71%) Entity Framework
Miscellaneous
1 671 (15.39%) Analytical Skills
2 215 (4.93%) Management Information System
3 132 (3.03%) Data Structures
4 124 (2.84%) Greenfield Project
5 103 (2.36%) Self-Motivation
6 95 (2.18%) Data Centre
7 58 (1.33%) Algorithms
8 57 (1.31%) NHS
9 49 (1.12%) Reinsurance
10 45 (1.03%) Replication
10 45 (1.03%) User Experience
11 33 (0.76%) Taxonomies
12 32 (0.73%) Clustering
12 32 (0.73%) Hedge funds
13 31 (0.71%) Public Cloud
14 30 (0.69%) Virtual Team
15 25 (0.57%) Enterprise Software
16 23 (0.53%) Reference Data
17 20 (0.46%) Fixed Income
18 19 (0.44%) FMCG
Operating Systems
1 152 (3.49%) Unix
2 136 (3.12%) Windows
3 129 (2.96%) Linux
4 49 (1.12%) Windows Server
5 14 (0.32%) Red Hat Enterprise Linux
6 13 (0.30%) Windows Server 2012
7 7 (0.16%) Solaris
8 6 (0.14%) Android
8 6 (0.14%) Windows 7
9 5 (0.11%) Apple iOS
9 5 (0.11%) Windows 10
9 5 (0.11%) Windows Server 2008
9 5 (0.11%) Windows XP
10 4 (0.092%) Oracle Linux
10 4 (0.092%) Windows 8
11 2 (0.046%) AIX
11 2 (0.046%) VME
Processes & Methodologies
1 2,710 (62.14%) Business Intelligence
2 1,967 (45.10%) ETL
3 1,434 (32.88%) Analytics
4 1,402 (32.15%) Agile Software Development
5 1,145 (26.26%) Data Modelling
6 716 (16.42%) Visualisation
7 464 (10.64%) Data Management
8 435 (9.97%) Problem-Solving
9 427 (9.79%) Data Architecture
10 424 (9.72%) Kimball Methodology
11 411 (9.42%) Data Science
12 400 (9.17%) Data Visualisation
13 399 (9.15%) DevOps
14 380 (8.71%) Scrum
15 378 (8.67%) Migration
16 360 (8.25%) Data Analytics
17 357 (8.19%) Data Integration
18 331 (7.59%) Data Analysis
19 324 (7.43%) Decision-Making
20 285 (6.54%) SDLC
Programming Languages
1 2,846 (65.26%) SQL
2 956 (21.92%) T-SQL
3 791 (18.14%) Python
4 521 (11.95%) C#
5 397 (9.10%) Data Analysis Expressions (DAX)
6 328 (7.52%) Java
7 314 (7.20%) R
8 258 (5.92%) PL/SQL
9 168 (3.85%) VBA
10 156 (3.58%) PowerShell
11 153 (3.51%) JavaScript
12 147 (3.37%) Scala
13 61 (1.40%) VB
14 58 (1.33%) VB.NET
15 41 (0.94%) Shell Script
16 37 (0.85%) C
17 34 (0.78%) Bash Shell
18 29 (0.66%) Java 8
19 27 (0.62%) HiveQL
19 27 (0.62%) PHP
Qualifications
1 379 (8.69%) Degree
2 110 (2.52%) Computer Science Degree
3 35 (0.80%) Security Cleared
4 34 (0.78%) ISTQB
4 34 (0.78%) Microsoft Certification
5 23 (0.53%) TOGAF Certification
6 22 (0.50%) Master's Degree
7 13 (0.30%) PhD
8 12 (0.28%) ISEB
8 12 (0.28%) ITIL Foundation Certificate
8 12 (0.28%) PMI Certification
9 11 (0.25%) Numerate Degree
10 9 (0.21%) ITIL Certification
10 9 (0.21%) PMP
10 9 (0.21%) SC Cleared
11 8 (0.18%) AWS Certification
11 8 (0.18%) DBS Check
11 8 (0.18%) MCSA
12 7 (0.16%) ISTQB Foundation Certification
12 7 (0.16%) MCSE
Quality Assurance & Compliance
1 402 (9.22%) Data Quality
2 169 (3.88%) QA
3 75 (1.72%) GDPR
4 45 (1.03%) SLA
5 23 (0.53%) PMO
6 17 (0.39%) ISO/IEC 27001
7 6 (0.14%) HIPAA
8 3 (0.069%) HL7
9 2 (0.046%) Actionable Recommendations
9 2 (0.046%) COBIT
9 2 (0.046%) ISO 9001
10 1 (0.023%) EMIR
10 1 (0.023%) GAAP
10 1 (0.023%) GMP
10 1 (0.023%) ISO 14001
10 1 (0.023%) ISO 22301
10 1 (0.023%) JSP 440
System Software
1 104 (2.38%) Docker
2 53 (1.22%) HDFS
3 39 (0.89%) Active Directory
4 32 (0.73%) Tivoli Workload Scheduler
5 29 (0.66%) Apache Flume
6 21 (0.48%) VMware Infrastructure
7 13 (0.30%) Veritas Volume Manager
8 9 (0.21%) Cronacle
8 9 (0.21%) Veritas File System
9 8 (0.18%) Apache ZooKeeper
9 8 (0.18%) Hyper-V
10 6 (0.14%) VMware Workstation
10 6 (0.14%) XenApp
11 5 (0.11%) Citrix Hypervisor
11 5 (0.11%) XenDesktop
12 4 (0.092%) NFS
13 3 (0.069%) Oracle RAC
14 2 (0.046%) Firmware
15 1 (0.023%) etcd
15 1 (0.023%) Oracle Clusterware
Systems Management
1 55 (1.26%) Terraform
2 47 (1.08%) Kubernetes
3 41 (0.94%) Ansible
4 34 (0.78%) Puppet
5 32 (0.73%) Tivoli
6 30 (0.69%) Hadoop YARN
7 29 (0.66%) Opscode Chef
8 23 (0.53%) Oozie
9 17 (0.39%) SQL Sentry
10 16 (0.37%) Control-M
11 14 (0.32%) Foglight
11 14 (0.32%) LiteSpeed
12 13 (0.30%) AirWatch
12 13 (0.30%) Netcool
13 9 (0.21%) Dollar Universe
13 9 (0.21%) SCOM
14 8 (0.18%) Ambari
14 8 (0.18%) Failover Clustering
15 7 (0.16%) BMC PATROL
16 6 (0.14%) Oracle RMAN
Vendors
1 1,342 (30.77%) Microsoft
2 686 (15.73%) Tableau
3 624 (14.31%) Oracle
4 357 (8.19%) Informatica
5 275 (6.31%) SAP
6 233 (5.34%) Google
7 206 (4.72%) IBM
8 195 (4.47%) Databricks
9 178 (4.08%) Teradata
10 143 (3.28%) Cognos
11 126 (2.89%) Talend
12 88 (2.02%) Cloudera
13 59 (1.35%) Salesforce.com
14 57 (1.31%) Netezza
15 50 (1.15%) Ab Initio
16 43 (0.99%) Hortonworks
17 41 (0.94%) VMware
18 36 (0.83%) MicroStrategy
19 30 (0.69%) Alteryx
20 23 (0.53%) Vertica