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

Data Warehousing
UK
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 116 106 81
Rank change year-on-year -10 -25 +12
Permanent jobs citing Data Warehouse 4974 5396 7416
As % of all permanent IT jobs advertised in the UK 2.78% 2.84% 3.39%
As % of the Database & Business Intelligence category 9.19% 9.59% 10.75%
Number of salaries quoted 3924 4635 6104
UK median annual salary £51,000 £53,500 £50,000
Median salary % change year-on-year -4.67% +7.00% -4.76%
10th Percentile £32,500 £33,500 £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 54109 56256 68994
As % of all permanent IT jobs advertised in the UK 30.24% 29.63% 31.50%
Number of salaries quoted 44517 48077 58103
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +1.12%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £76,750 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

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 18 November 2017.

Salary histogram for Data Warehouse in the UK

Data Warehouse
Top 18 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 18 November 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 -5 4678 £52,500 -4.55% 172
UK excluding London 0 2455 £45,000 -5.26% 111
London -16 2426 £60,000 - 78
North of England +15 769 £45,000 +2.86% 43
South East -21 579 £50,000 -4.76% 19
Midlands +20 418 £47,500 +8.57% 12
North West -6 399 £42,500 - 19
Yorkshire +40 351 £45,000 - 19
South West +42 288 £42,500 - 9
West Midlands +23 280 £47,500 +11.76% 8
East of England -60 187 £52,500 +5.00% 11
Scotland -3 185 £45,000 -10.00% 14
East Midlands +13 129 £45,000 - 4
Wales -32 23 £35,000 -6.67% 3
North East 0 19 £40,000 +6.67% 5
Isle of Man -7 4 £50,000 -50.00%
Channel Islands +1 3 £60,000 -
Northern Ireland -25 3 £40,000 -

For the 6 months to 18 November 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 3369 (67.73%) SQL
2 3317 (66.69%) Business Intelligence
3 2411 (48.47%) SQL Server
4 2124 (42.70%) ETL
5 1938 (38.96%) SQL Server Integration Services
6 1609 (32.35%) SQL Server Reporting Services
7 1596 (32.09%) Finance
8 1519 (30.54%) Microsoft
9 1418 (28.51%) Agile Software Development
10 1325 (26.64%) Analytics
11 1298 (26.10%) SQL Server Analysis Services
12 1266 (25.45%) T-SQL
13 1226 (24.65%) Data Modelling
14 1044 (20.99%) Oracle
15 855 (17.19%) Power BI
16 850 (17.09%) Analytical Skills
17 809 (16.26%) Tableau
18 800 (16.08%) Big Data
19 649 (13.05%) Visualisation
20 613 (12.32%) Microsoft Azure
21 612 (12.30%) Python
22 554 (11.14%) Data Management
23 543 (10.92%) Banking
24 536 (10.78%) Degree
25 523 (10.51%) QlikView
26 513 (10.31%) Java
27 509 (10.23%) BusinessObjects
28 498 (10.01%) Data Quality
29 478 (9.61%) Relational Database
30 464 (9.33%) PL/SQL

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 249 (5.01%) Apache Spark
2 201 (4.04%) SAS
3 173 (3.48%) SharePoint
4 55 (1.11%) Tomcat
5 52 (1.05%) JBoss
6 32 (0.64%) Confluence
7 28 (0.56%) Apache
8 26 (0.52%) CMS
9 25 (0.50%) IIS
10 22 (0.44%) Oracle SOA Suite
11 20 (0.40%) Apache Pig
12 18 (0.36%) Apache Airflow
13 17 (0.34%) BizTalk Server
14 15 (0.30%) SharePoint 2013
15 13 (0.26%) WebSphere
16 12 (0.24%) Apache Solr
17 11 (0.22%) MS Exchange
18 9 (0.18%) Elasticsearch
19 8 (0.16%) Drupal
19 8 (0.16%) nginx
Applications
1 417 (8.38%) Microsoft Excel
2 112 (2.25%) Microsoft PowerPoint
3 97 (1.95%) Microsoft Office
4 65 (1.31%) SPSS
5 40 (0.80%) MS Visio
6 16 (0.32%) Microsoft Project
7 10 (0.20%) Spreadsheet
8 4 (0.080%) Mingle
9 3 (0.060%) SPSS Modeler
10 1 (0.020%) Mathematica
10 1 (0.020%) S-PLUS
10 1 (0.020%) Stata
10 1 (0.020%) Weka
Business Applications
1 50 (1.01%) Cognos Business Intelligence
2 39 (0.78%) Dynamics CRM
3 25 (0.50%) Dynamics AX
4 21 (0.42%) Dynamics NAV
5 17 (0.34%) HFM
5 17 (0.34%) Oracle EBS
5 17 (0.34%) Salesforce.com CRM
6 16 (0.32%) SAP ERP
7 15 (0.30%) Oracle ERP
8 14 (0.28%) Cognos TM1
9 11 (0.22%) BusinessWorks
9 11 (0.22%) TIBCO BusinessEvents
10 10 (0.20%) Unit4 Business World
11 9 (0.18%) Hyperion Enterprise
11 9 (0.18%) SAP APO
12 8 (0.16%) Eikon
13 7 (0.14%) Oracle Financials
13 7 (0.14%) SAP Business ByDesign
13 7 (0.14%) SAP Business One
14 6 (0.12%) Maximo
Cloud Services
1 613 (12.32%) Microsoft Azure
2 326 (6.55%) Amazon AWS
3 91 (1.83%) Google Cloud Platform
4 86 (1.73%) Azure Data Factory
5 73 (1.47%) Azure Machine Learning
6 58 (1.17%) SaaS
7 52 (1.05%) PaaS
8 38 (0.76%) Cloud Computing
9 34 (0.68%) Office 365
10 33 (0.66%) Cortana Intelligence Suite
11 23 (0.46%) Google Analytics
11 23 (0.46%) IaaS
12 20 (0.40%) Dynamics 365
13 18 (0.36%) Amazon EMR
13 18 (0.36%) GitHub
14 17 (0.34%) Amazon S3
15 16 (0.32%) Amazon Kinesis
16 13 (0.26%) Amazon ElastiCache
17 8 (0.16%) Serverless
18 7 (0.14%) Google Tag Manager
Communications & Networking
1 67 (1.35%) Internet
2 65 (1.31%) HTTP
3 57 (1.15%) SSL
4 54 (1.09%) TCP/IP
5 30 (0.60%) Intranet
6 28 (0.56%) Firewall
7 25 (0.50%) DNS
8 12 (0.24%) SMS
9 9 (0.18%) VLAN
10 8 (0.16%) Cisco ASA
10 8 (0.16%) IPsec
10 8 (0.16%) VPN
11 7 (0.14%) FTP
11 7 (0.14%) LDAP
12 6 (0.12%) Kerberos
12 6 (0.12%) SAN
13 5 (0.10%) NAS
13 5 (0.10%) Skype
14 3 (0.060%) Extranet
15 2 (0.040%) MPLS
Database & Business Intelligence
1 2411 (48.47%) SQL Server
2 1938 (38.96%) SQL Server Integration Services
3 1609 (32.35%) SQL Server Reporting Services
4 1298 (26.10%) SQL Server Analysis Services
5 855 (17.19%) Power BI
6 800 (16.08%) Big Data
7 523 (10.51%) QlikView
8 509 (10.23%) BusinessObjects
9 478 (9.61%) Relational Database
10 450 (9.05%) OLAP
11 394 (7.92%) SQL Server 2016
12 391 (7.86%) Hadoop
13 388 (7.80%) SQL Server 2012
14 378 (7.60%) SQL Server 2014
15 287 (5.77%) SQL Server 2008
16 264 (5.31%) Microsoft Analysis Services
17 222 (4.46%) NoSQL
18 221 (4.44%) Oracle Database
19 201 (4.04%) Data Lake
20 185 (3.72%) MySQL
Development Applications
1 183 (3.68%) Team Foundation Server
2 161 (3.24%) Visual Studio
3 153 (3.08%) JIRA
4 124 (2.49%) Talend Open Studio
5 91 (1.83%) Git (software)
6 88 (1.77%) SQL Server Management Studio (SSMS)
7 71 (1.43%) Maven
8 67 (1.35%) Jenkins
9 62 (1.25%) Subversion
9 62 (1.25%) TeamCity
10 55 (1.11%) JUnit
11 51 (1.03%) Toad
12 49 (0.99%) Selenium
13 47 (0.94%) Mockito
13 47 (0.94%) Sonatype Nexus
14 43 (0.86%) ERwin
15 32 (0.64%) Atlassian Bamboo
15 32 (0.64%) Oracle Forms
16 31 (0.62%) Bitbucket
17 27 (0.54%) Eclipse
General
1 1596 (32.09%) Finance
2 543 (10.92%) Banking
3 344 (6.92%) Investment Banking
4 343 (6.90%) Retail Banking
5 333 (6.69%) Marketing
6 286 (5.75%) Retail
7 181 (3.64%) Advertising
8 122 (2.45%) Publishing
9 109 (2.19%) Manufacturing
10 103 (2.07%) Games
11 97 (1.95%) Telecoms
12 83 (1.67%) Electronics
13 72 (1.45%) Legal
14 42 (0.84%) Back Office
15 35 (0.70%) Law
16 32 (0.64%) Front Office
17 17 (0.34%) Polish Language
18 16 (0.32%) Financial Institution
18 16 (0.32%) Pharmaceutical
19 15 (0.30%) French Language
Job Titles
1 2244 (45.11%) Developer
2 1067 (21.45%) Business Intelligence Developer
3 872 (17.53%) SQL Developer
4 773 (15.54%) Analyst
5 481 (9.67%) Architect
6 457 (9.19%) Data Warehouse Developer
7 418 (8.40%) SQL BI Developer
8 318 (6.39%) Consultant
9 311 (6.25%) SQL Server Developer
10 308 (6.19%) SSIS Developer
11 302 (6.07%) Data Architect
12 279 (5.61%) DBA
13 272 (5.47%) Business Developer
14 262 (5.27%) Senior Developer
15 245 (4.93%) Business Intelligence Analyst
16 234 (4.70%) SSRS Developer
17 219 (4.40%) SQL DBA
18 205 (4.12%) ETL Developer
19 196 (3.94%) Data Analyst
20 187 (3.76%) Business Analyst
Libraries, Frameworks & Software Standards
1 397 (7.98%) .NET
2 241 (4.85%) Web Services
3 226 (4.54%) MDX
4 205 (4.12%) XML
5 177 (3.56%) HTML
6 139 (2.79%) CSS
7 124 (2.49%) JSON
8 117 (2.35%) ASP.NET
9 96 (1.93%) Middleware
9 96 (1.93%) Spring
10 92 (1.85%) RESTful
11 85 (1.71%) AngularJS
12 76 (1.53%) Kafka
13 70 (1.41%) J2EE
14 69 (1.39%) REST
15 67 (1.35%) Oracle GoldenGate
16 63 (1.27%) HTML5
17 59 (1.19%) SOAP
18 58 (1.17%) JDBC
19 55 (1.11%) JMS
Miscellaneous
1 850 (17.09%) Analytical Skills
2 263 (5.29%) Computer Science
3 249 (5.01%) Management Information System
4 200 (4.02%) Data Structures
5 181 (3.64%) Enterprise Software
6 137 (2.75%) Replication
7 106 (2.13%) Greenfield Project
7 106 (2.13%) User Experience
8 103 (2.07%) Algorithms
9 98 (1.97%) Clustering
10 79 (1.59%) Virtual Team
11 76 (1.53%) Fintech
12 59 (1.19%) Reference Data
13 50 (1.01%) NHS
14 40 (0.80%) Data Centre
15 36 (0.72%) Credit Risk
16 33 (0.66%) Hedge funds
17 29 (0.58%) Equities
18 26 (0.52%) PMI
19 23 (0.46%) iPad
Operating Systems
1 277 (5.57%) Unix
2 209 (4.20%) Linux
3 149 (3.00%) Windows
4 70 (1.41%) Windows Server
5 31 (0.62%) AIX
6 27 (0.54%) Android
7 23 (0.46%) Windows Server 2008
8 22 (0.44%) Windows Server 2012
9 19 (0.38%) Apple iOS
10 11 (0.22%) Red Hat Enterprise Linux
11 10 (0.20%) Solaris
12 3 (0.060%) Oracle Linux
13 2 (0.040%) Windows 10
13 2 (0.040%) Windows 7
14 1 (0.020%) Tru64
14 1 (0.020%) Ubuntu
Processes & Methodologies
1 3317 (66.69%) Business Intelligence
2 2124 (42.70%) ETL
3 1418 (28.51%) Agile Software Development
4 1325 (26.64%) Analytics
5 1226 (24.65%) Data Modelling
6 649 (13.05%) Visualisation
7 554 (11.14%) Data Management
8 443 (8.91%) Kimball Methodology
9 430 (8.64%) Asset Management
9 430 (8.64%) Data Analytics
10 421 (8.46%) Data Integration
11 391 (7.86%) Performance Tuning
12 389 (7.82%) Data Visualisation
13 383 (7.70%) Migration
14 381 (7.66%) Data Analysis
15 357 (7.18%) Scrum
15 357 (7.18%) Wealth Management
16 332 (6.67%) Stakeholder Management
17 312 (6.27%) Data Architecture
18 311 (6.25%) SDLC
Programming Languages
1 3369 (67.73%) SQL
2 1266 (25.45%) T-SQL
3 612 (12.30%) Python
4 513 (10.31%) Java
5 464 (9.33%) PL/SQL
6 412 (8.28%) C#
7 313 (6.29%) R
8 190 (3.82%) JavaScript
9 149 (3.00%) Perl
10 125 (2.51%) PowerShell
11 122 (2.45%) Scala
12 114 (2.29%) Shell Script
13 109 (2.19%) VBA
14 103 (2.07%) C++
15 82 (1.65%) Bash Shell
16 71 (1.43%) Data Analysis Expressions (DAX)
17 68 (1.37%) VB.NET
18 66 (1.33%) VB
19 56 (1.13%) C
20 55 (1.11%) PHP
Qualifications
1 536 (10.78%) Degree
2 117 (2.35%) Computer Science Degree
3 89 (1.79%) Microsoft Certification
4 62 (1.25%) Security Cleared
5 52 (1.05%) SC Cleared
6 42 (0.84%) Numerate Degree
7 39 (0.78%) MCSA
8 38 (0.76%) ISEB
9 36 (0.72%) MCSE
10 27 (0.54%) PMP
11 26 (0.52%) PhD
11 26 (0.52%) PMI Certification
11 26 (0.52%) Six Sigma Black Belt
11 26 (0.52%) Six Sigma Green Belt
12 22 (0.44%) Master's Degree
13 20 (0.40%) ISTQB
14 16 (0.32%) ITIL Foundation Certificate
15 12 (0.24%) ACCA
15 12 (0.24%) MBA
16 10 (0.20%) MCDBA
Quality Assurance & Compliance
1 498 (10.01%) Data Quality
2 292 (5.87%) QA
3 77 (1.55%) GDPR
4 26 (0.52%) GCP
5 25 (0.50%) SLA
6 18 (0.36%) PCI DSS
7 15 (0.30%) PMO
8 13 (0.26%) ISO/IEC 27001
9 7 (0.14%) Solvency II
10 5 (0.10%) NEBOSH
10 5 (0.10%) Web Application Security Consortium
11 3 (0.060%) Basel III
11 3 (0.060%) COBIT
11 3 (0.060%) IFRS
11 3 (0.060%) IFRS 9
12 2 (0.040%) Actionable Recommendations
12 2 (0.040%) ISO 9001
13 1 (0.020%) GAAP
13 1 (0.020%) Sarbanes-Oxley
13 1 (0.020%) UCITS
System Software
1 32 (0.64%) VMware Infrastructure
2 27 (0.54%) Active Directory
3 22 (0.44%) Docker
4 19 (0.38%) Oracle RAC
5 18 (0.36%) HDFS
6 15 (0.30%) Apache Flume
7 12 (0.24%) Hyper-V
8 9 (0.18%) Virtual Machines
9 8 (0.16%) VMware ESXi
10 5 (0.10%) Firmware
11 4 (0.080%) GPFS
12 2 (0.040%) KVM
12 2 (0.040%) Microsoft Virtual Server
12 2 (0.040%) Virtual Servers
13 1 (0.020%) Apache ZooKeeper
13 1 (0.020%) Cronacle
13 1 (0.020%) Microsoft App-V
13 1 (0.020%) PowerHA
Systems Management
1 33 (0.66%) Oozie
2 13 (0.26%) Microsoft Clustering
3 12 (0.24%) Failover Clustering
4 11 (0.22%) Control-M
4 11 (0.22%) SCCM
5 9 (0.18%) Ansible
5 9 (0.18%) Terraform
6 8 (0.16%) Mesos
6 8 (0.16%) Puppet
6 8 (0.16%) Systems Management Server (SMS)
7 7 (0.14%) Nagios
7 7 (0.14%) Tivoli
8 6 (0.12%) Kibana
8 6 (0.12%) Oracle Enterprise Manager
9 5 (0.10%) Oracle RMAN
9 5 (0.10%) Perfmon
9 5 (0.10%) SCOM
10 4 (0.080%) Data Guard
10 4 (0.080%) Hadoop YARN
10 4 (0.080%) Kubernetes
Vendors
1 1519 (30.54%) Microsoft
2 1044 (20.99%) Oracle
3 809 (16.26%) Tableau
4 377 (7.58%) SAP
5 300 (6.03%) Cognos
6 237 (4.76%) Informatica
7 180 (3.62%) IBM
8 145 (2.92%) MicroStrategy
9 126 (2.53%) Google
10 124 (2.49%) Talend
11 121 (2.43%) Teradata
12 77 (1.55%) TIBCO
13 64 (1.29%) Netezza
14 63 (1.27%) Alteryx
15 57 (1.15%) Salesforce.com
16 48 (0.97%) RedGate
17 47 (0.94%) Hyperion
18 44 (0.88%) GoldenSource
18 44 (0.88%) VMware
19 42 (0.84%) Cloudera