Period
to 23 October 2017

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

Data Warehousing
UK
6 months to
23 Oct 2017
Same period 2016 Same period 2015
Rank 115 104 82
Rank change year-on-year -11 -22 +6
Permanent jobs citing Data Warehouse 4938 5424 7289
As % of all permanent IT jobs advertised in the UK 2.81% 2.86% 3.33%
As % of the Database & Business Intelligence category 9.22% 9.65% 10.55%
Number of salaries quoted 3894 4620 6013
UK median annual salary £50,000 £54,000 £50,000
Median salary % change year-on-year -7.41% +8.00% -4.76%
10th Percentile £33,000 £33,250 £33,000
90th Percentile £77,500 £81,250 £80,000
UK excluding London median annual salary £45,000 £47,500 £45,000
% change year-on-year -5.26% +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 53569 56197 69091
As % of all permanent IT jobs advertised in the UK 30.52% 29.64% 31.59%
Number of salaries quoted 44034 47845 58259
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% -
10th Percentile £30,000 £28,750 £28,000
90th Percentile £77,500 £76,250 £73,750
UK excluding London median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% -

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 23 October 2017.

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 23 October 2017. 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 4662 £51,000 -7.27% 200
London -14 2465 £60,000 - 90
UK excluding London +5 2387 £45,000 -5.26% 121
North of England +26 780 £43,750 +1.74% 43
South East -25 550 £50,000 -4.76% 27
Midlands +20 416 £45,000 +2.27% 20
North West +5 399 £40,000 -5.88% 24
Yorkshire +44 368 £45,000 - 18
South West +56 266 £42,500 - 13
West Midlands +5 265 £45,000 +5.88% 13
Scotland -3 175 £45,000 -10.00% 8
East of England -72 174 £50,000 - 7
East Midlands +25 139 £45,000 - 7
Wales -34 24 £40,000 +6.67% 3
North East +4 13 £40,000 - 1
Isle of Man -2 4 £50,000 -50.00%
Northern Ireland -24 2 £35,000 -12.50%

For the 6 months to 23 October 2017, IT jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for Data Warehouse.

1 3374 (68.33%) SQL
2 3260 (66.02%) Business Intelligence
3 2396 (48.52%) SQL Server
4 2069 (41.90%) ETL
5 1957 (39.63%) SQL Server Integration Services
6 1596 (32.32%) SQL Server Reporting Services
7 1578 (31.96%) Finance
8 1529 (30.96%) Microsoft
9 1425 (28.86%) Agile Software Development
10 1316 (26.65%) Analytics
11 1304 (26.41%) SQL Server Analysis Services
12 1255 (25.42%) T-SQL
13 1208 (24.46%) Data Modelling
14 1062 (21.51%) Oracle
15 844 (17.09%) Big Data
16 843 (17.07%) Power BI
17 805 (16.30%) Analytical Skills
18 779 (15.78%) Tableau
19 644 (13.04%) Visualisation
20 621 (12.58%) Microsoft Azure
21 588 (11.91%) Python
22 562 (11.38%) Banking
23 544 (11.02%) Degree
24 535 (10.83%) Data Management
25 514 (10.41%) Java
26 507 (10.27%) Data Quality
27 505 (10.23%) Relational Database
28 499 (10.11%) QlikView
29 496 (10.04%) BusinessObjects
30 487 (9.86%) OLAP

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 242 (4.90%) Apache Spark
2 206 (4.17%) SAS
3 186 (3.77%) SharePoint
4 61 (1.24%) Tomcat
5 54 (1.09%) JBoss
6 39 (0.79%) CMS
7 30 (0.61%) Apache
8 28 (0.57%) IIS
9 27 (0.55%) Confluence
10 24 (0.49%) Oracle SOA Suite
11 19 (0.38%) Apache Pig
12 18 (0.36%) BizTalk Server
13 16 (0.32%) Apache Airflow
13 16 (0.32%) SharePoint 2013
14 14 (0.28%) Sitecore CMS
15 11 (0.22%) OpenROAD
16 10 (0.20%) MS Exchange
16 10 (0.20%) nginx
16 10 (0.20%) WebSphere
17 9 (0.18%) Apache Solr
Applications
1 406 (8.22%) Microsoft Excel
2 102 (2.07%) Microsoft PowerPoint
3 92 (1.86%) Microsoft Office
4 76 (1.54%) SPSS
5 46 (0.93%) MS Visio
6 12 (0.24%) Spreadsheet
7 6 (0.12%) Microsoft Project
8 4 (0.081%) Mingle
9 3 (0.061%) SPSS Modeler
10 2 (0.041%) Weka
11 1 (0.020%) Adobe Illustrator
11 1 (0.020%) Mathematica
11 1 (0.020%) Photoshop
11 1 (0.020%) S-PLUS
11 1 (0.020%) Stata
Business Applications
1 57 (1.15%) Cognos Business Intelligence
2 48 (0.97%) Dynamics CRM
3 27 (0.55%) Dynamics NAV
4 26 (0.53%) Salesforce.com CRM
5 24 (0.49%) Dynamics AX
6 20 (0.41%) HFM
7 17 (0.34%) Oracle EBS
8 16 (0.32%) Oracle ERP
8 16 (0.32%) SAP ERP
9 13 (0.26%) Cognos TM1
9 13 (0.26%) Hyperion Enterprise
10 12 (0.24%) Dynamics GP
11 10 (0.20%) Unit4 Business World
12 9 (0.18%) BusinessWorks
12 9 (0.18%) SAP APO
12 9 (0.18%) SAP BPC
12 9 (0.18%) TIBCO BusinessEvents
13 8 (0.16%) Eikon
13 8 (0.16%) Maximo
14 7 (0.14%) Oracle Financials
Cloud Services
1 621 (12.58%) Microsoft Azure
2 310 (6.28%) Amazon AWS
3 86 (1.74%) Google Cloud Platform
4 79 (1.60%) Azure Data Factory
4 79 (1.60%) Azure Machine Learning
5 53 (1.07%) SaaS
6 44 (0.89%) PaaS
7 32 (0.65%) Cortana Intelligence Suite
7 32 (0.65%) Google Analytics
8 31 (0.63%) Cloud Computing
9 29 (0.59%) Office 365
10 21 (0.43%) Dynamics 365
10 21 (0.43%) IaaS
11 15 (0.30%) Amazon EMR
12 14 (0.28%) GitHub
13 11 (0.22%) Amazon Kinesis
13 11 (0.22%) Amazon S3
14 10 (0.20%) Amazon ElastiCache
15 7 (0.14%) Amazon EC2
15 7 (0.14%) Google Tag Manager
Communications & Networking
1 62 (1.26%) HTTP
1 62 (1.26%) Internet
2 56 (1.13%) SSL
3 54 (1.09%) TCP/IP
4 34 (0.69%) Intranet
5 26 (0.53%) Firewall
6 23 (0.47%) DNS
7 10 (0.20%) Kerberos
7 10 (0.20%) SMS
7 10 (0.20%) VLAN
8 9 (0.18%) Cisco ASA
8 9 (0.18%) LDAP
8 9 (0.18%) VPN
9 8 (0.16%) FTP
9 8 (0.16%) IPsec
10 7 (0.14%) SAN
11 5 (0.10%) NAS
11 5 (0.10%) Skype
12 4 (0.081%) Extranet
12 4 (0.081%) Wireless
Database & Business Intelligence
1 2396 (48.52%) SQL Server
2 1957 (39.63%) SQL Server Integration Services
3 1596 (32.32%) SQL Server Reporting Services
4 1304 (26.41%) SQL Server Analysis Services
5 844 (17.09%) Big Data
6 843 (17.07%) Power BI
7 505 (10.23%) Relational Database
8 499 (10.11%) QlikView
9 496 (10.04%) BusinessObjects
10 487 (9.86%) OLAP
11 409 (8.28%) SQL Server 2012
12 392 (7.94%) SQL Server 2016
13 384 (7.78%) Hadoop
14 371 (7.51%) SQL Server 2014
15 296 (5.99%) SQL Server 2008
16 258 (5.22%) Microsoft Analysis Services
17 239 (4.84%) Oracle Database
18 228 (4.62%) NoSQL
19 187 (3.79%) Data Mining
20 184 (3.73%) Data Lake
Development Applications
1 172 (3.48%) Team Foundation Server
2 158 (3.20%) Visual Studio
3 133 (2.69%) JIRA
4 106 (2.15%) Talend Open Studio
5 86 (1.74%) SQL Server Management Studio (SSMS)
6 84 (1.70%) Git (software)
7 76 (1.54%) Maven
8 72 (1.46%) TeamCity
9 70 (1.42%) Subversion
10 62 (1.26%) JUnit
11 61 (1.24%) Jenkins
12 54 (1.09%) Selenium
13 52 (1.05%) Sonatype Nexus
14 51 (1.03%) Mockito
15 50 (1.01%) Toad
16 34 (0.69%) ERwin
16 34 (0.69%) Oracle Forms
17 27 (0.55%) Bitbucket
18 26 (0.53%) Atlassian Bamboo
19 24 (0.49%) HP UFT
General
1 1578 (31.96%) Finance
2 562 (11.38%) Banking
3 356 (7.21%) Marketing
4 345 (6.99%) Retail Banking
5 344 (6.97%) Investment Banking
6 316 (6.40%) Retail
7 151 (3.06%) Advertising
8 125 (2.53%) Publishing
9 114 (2.31%) Games
10 97 (1.96%) Manufacturing
11 96 (1.94%) Telecoms
12 91 (1.84%) Legal
13 82 (1.66%) Electronics
14 47 (0.95%) Back Office
15 36 (0.73%) Law
16 35 (0.71%) Front Office
17 19 (0.38%) Polish Language
18 18 (0.36%) Pharmaceutical
19 15 (0.30%) Financial Institution
20 14 (0.28%) French Language
Job Titles
1 2253 (45.63%) Developer
2 1062 (21.51%) Business Intelligence Developer
3 881 (17.84%) SQL Developer
4 775 (15.69%) Analyst
5 481 (9.74%) Data Warehouse Developer
6 446 (9.03%) Architect
7 411 (8.32%) SQL BI Developer
8 312 (6.32%) Senior Developer
9 310 (6.28%) SQL Server Developer
10 308 (6.24%) SSIS Developer
11 297 (6.01%) Consultant
12 290 (5.87%) DBA
13 272 (5.51%) Data Architect
14 257 (5.20%) Business Developer
15 247 (5.00%) Business Intelligence Analyst
16 224 (4.54%) SQL DBA
16 224 (4.54%) SSRS Developer
17 209 (4.23%) ETL Developer
18 196 (3.97%) Oracle Developer
19 176 (3.56%) Data Analyst
Libraries, Frameworks & Software Standards
1 425 (8.61%) .NET
2 233 (4.72%) MDX
3 218 (4.41%) Web Services
4 212 (4.29%) XML
5 178 (3.60%) HTML
6 141 (2.86%) CSS
7 125 (2.53%) ASP.NET
8 119 (2.41%) JSON
9 98 (1.98%) RESTful
10 93 (1.88%) Spring
11 85 (1.72%) AngularJS
11 85 (1.72%) Middleware
12 74 (1.50%) Kafka
13 72 (1.46%) Oracle GoldenGate
14 71 (1.44%) J2EE
15 69 (1.40%) HTML5
16 61 (1.24%) JDBC
17 60 (1.22%) REST
17 60 (1.22%) SOAP
18 59 (1.19%) JMS
Miscellaneous
1 805 (16.30%) Analytical Skills
2 271 (5.49%) Computer Science
3 265 (5.37%) Management Information System
4 210 (4.25%) Data Structures
5 176 (3.56%) Enterprise Software
6 144 (2.92%) Replication
7 102 (2.07%) User Experience
8 99 (2.00%) Greenfield Project
9 97 (1.96%) Algorithms
10 92 (1.86%) Clustering
11 79 (1.60%) Fintech
12 65 (1.32%) Reference Data
13 44 (0.89%) NHS
14 38 (0.77%) Virtual Team
15 36 (0.73%) Data Centre
16 35 (0.71%) Hedge funds
17 33 (0.67%) Credit Risk
18 30 (0.61%) iPad
19 24 (0.49%) PMI
19 24 (0.49%) Social Media
Operating Systems
1 288 (5.83%) Unix
2 229 (4.64%) Linux
3 157 (3.18%) Windows
4 69 (1.40%) Windows Server
5 33 (0.67%) Android
6 29 (0.59%) AIX
6 29 (0.59%) Windows Server 2008
7 27 (0.55%) Windows Server 2012
8 23 (0.47%) Apple iOS
9 15 (0.30%) Red Hat Enterprise Linux
10 14 (0.28%) Solaris
11 3 (0.061%) Oracle Linux
12 2 (0.041%) Windows 10
12 2 (0.041%) Windows 7
13 1 (0.020%) Tru64
13 1 (0.020%) Ubuntu
Processes & Methodologies
1 3260 (66.02%) Business Intelligence
2 2069 (41.90%) ETL
3 1425 (28.86%) Agile Software Development
4 1316 (26.65%) Analytics
5 1208 (24.46%) Data Modelling
6 644 (13.04%) Visualisation
7 535 (10.83%) Data Management
8 449 (9.09%) Kimball Methodology
9 425 (8.61%) Asset Management
10 416 (8.42%) Data Integration
11 414 (8.38%) Data Analytics
12 396 (8.02%) Data Visualisation
13 390 (7.90%) Migration
14 379 (7.68%) Performance Tuning
15 372 (7.53%) Data Analysis
16 364 (7.37%) Scrum
17 354 (7.17%) Wealth Management
18 327 (6.62%) Stakeholder Management
19 302 (6.12%) Dimensional Modelling
20 301 (6.10%) Data Architecture
Programming Languages
1 3374 (68.33%) SQL
2 1255 (25.42%) T-SQL
3 588 (11.91%) Python
4 514 (10.41%) Java
5 477 (9.66%) PL/SQL
6 407 (8.24%) C#
7 320 (6.48%) R
8 187 (3.79%) JavaScript
9 153 (3.10%) Perl
10 127 (2.57%) PowerShell
11 121 (2.45%) Scala
11 121 (2.45%) Shell Script
12 118 (2.39%) VBA
13 103 (2.09%) C++
14 82 (1.66%) Bash Shell
15 79 (1.60%) Data Analysis Expressions (DAX)
16 77 (1.56%) VB
17 76 (1.54%) VB.NET
18 68 (1.38%) C
19 43 (0.87%) PHP
Qualifications
1 544 (11.02%) Degree
2 120 (2.43%) Computer Science Degree
3 97 (1.96%) Microsoft Certification
4 66 (1.34%) Security Cleared
5 58 (1.17%) SC Cleared
6 45 (0.91%) Numerate Degree
7 39 (0.79%) MCSA
8 37 (0.75%) ISEB
9 34 (0.69%) MCSE
10 28 (0.57%) PMP
11 26 (0.53%) Six Sigma Black Belt
11 26 (0.53%) Six Sigma Green Belt
12 24 (0.49%) PMI Certification
13 22 (0.45%) PhD
14 21 (0.43%) Master's Degree
15 20 (0.41%) ISTQB
16 13 (0.26%) ITIL Foundation Certificate
17 12 (0.24%) ACCA
18 9 (0.18%) CIMA
18 9 (0.18%) MCITP
Quality Assurance & Compliance
1 507 (10.27%) Data Quality
2 287 (5.81%) QA
3 70 (1.42%) GDPR
4 28 (0.57%) SLA
5 23 (0.47%) GCP
6 14 (0.28%) PCI DSS
6 14 (0.28%) PMO
7 10 (0.20%) ISO/IEC 27001
8 9 (0.18%) Solvency II
9 5 (0.10%) NEBOSH
10 4 (0.081%) Basel III
11 3 (0.061%) COBIT
11 3 (0.061%) IFRS
11 3 (0.061%) IFRS 9
11 3 (0.061%) MiFID
11 3 (0.061%) Web Application Security Consortium
12 2 (0.041%) Actionable Recommendations
12 2 (0.041%) ISO 9001
13 1 (0.020%) Sarbanes-Oxley
13 1 (0.020%) UCITS
System Software
1 34 (0.69%) VMware Infrastructure
2 27 (0.55%) Active Directory
3 23 (0.47%) Docker
4 20 (0.41%) Oracle RAC
5 19 (0.38%) HDFS
6 16 (0.32%) Apache Flume
7 13 (0.26%) Hyper-V
8 8 (0.16%) Virtual Machines
8 8 (0.16%) VMware ESXi
9 5 (0.10%) Firmware
10 4 (0.081%) GPFS
10 4 (0.081%) KVM
11 3 (0.061%) Microsoft Virtual Server
11 3 (0.061%) Virtual Servers
12 1 (0.020%) Apache ZooKeeper
12 1 (0.020%) Cronacle
12 1 (0.020%) Microsoft App-V
12 1 (0.020%) NFS
12 1 (0.020%) PowerHA
12 1 (0.020%) Veritas Volume Manager
Systems Management
1 35 (0.71%) Oozie
2 17 (0.34%) Failover Clustering
3 13 (0.26%) Microsoft Clustering
4 12 (0.24%) Ansible
4 12 (0.24%) Control-M
5 11 (0.22%) SCCM
6 10 (0.20%) Mesos
6 10 (0.20%) Terraform
7 9 (0.18%) Puppet
7 9 (0.18%) Tivoli
8 7 (0.14%) Kibana
8 7 (0.14%) Nagios
9 6 (0.12%) Data Guard
9 6 (0.12%) Oracle RMAN
9 6 (0.12%) Systems Management Server (SMS)
10 5 (0.10%) HP Quality Center
10 5 (0.10%) Oracle Enterprise Manager
10 5 (0.10%) Perfmon
10 5 (0.10%) SCOM
11 4 (0.081%) Opscode Chef
Vendors
1 1529 (30.96%) Microsoft
2 1062 (21.51%) Oracle
3 779 (15.78%) Tableau
4 389 (7.88%) SAP
5 262 (5.31%) Cognos
6 211 (4.27%) Informatica
7 171 (3.46%) IBM
8 150 (3.04%) MicroStrategy
9 124 (2.51%) Google
10 119 (2.41%) Teradata
11 106 (2.15%) Talend
12 80 (1.62%) TIBCO
13 68 (1.38%) Alteryx
14 67 (1.36%) Netezza
15 59 (1.19%) Salesforce.com
16 53 (1.07%) Hyperion
17 49 (0.99%) VMware
18 45 (0.91%) RedGate
19 44 (0.89%) GoldenSource
20 41 (0.83%) Cloudera