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

Data Warehousing
UK
6 months to
22 Aug 2017
Same period 2016 Same period 2015
Rank 112 95 86
Rank change year-on-year -17 -9 +1
Permanent jobs citing Data Warehouse 5023 5820 7132
As % of all permanent IT jobs advertised in the UK 2.85% 2.95% 3.27%
As % of the Database & Business Intelligence category 9.29% 9.84% 10.29%
Number of salaries quoted 4085 4869 5900
UK median annual salary £50,000 £52,500 £50,000
Median salary % change year-on-year -4.76% +5.00% -4.76%
10th Percentile £32,500 £33,500 £33,000
90th Percentile £78,750 £79,000 £81,250
UK excluding London median annual salary £45,000 £45,000 £45,000

Data Warehouse is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 54097 59129 69289
As % of all permanent IT job vacancies advertised in the UK 30.73% 30.01% 31.77%
Number of salaries quoted 44898 50490 58447
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £28,750 £27,500
90th Percentile £77,500 £75,000 £72,500
UK excluding London median annual salary £42,500 £41,000 £40,000
% change year-on-year +3.66% +2.50% -

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 22 August 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 22 August 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 -16 4731 £50,000 -4.76% 283
UK excluding London -5 2501 £45,000 - 189
London -16 2427 £60,000 - 117
North of England +32 883 £42,500 - 71
South East -6 550 £50,000 - 42
Yorkshire +40 462 £45,000 +0.00% 28
Midlands +4 417 £45,000 - 18
North West +1 408 £40,000 -6.98% 41
West Midlands -3 255 £45,000 +4.65% 15
South West +2 242 £42,000 +2.44% 19
East of England -63 194 £50,000 +5.26% 16
Scotland +4 189 £45,000 -14.29% 21
East Midlands +10 151 £45,000 - 3
Wales -40 25 £40,000 +6.67% 2
North East 0 13 £45,000 +12.50% 2
Isle of Man -1 2 £50,000 -50.00% 1
Northern Ireland -14 2 £35,000 -12.50%

For the 6 months to 22 August 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 3492 (69.52%) SQL
2 3328 (66.26%) Business Intelligence
3 2590 (51.56%) SQL Server
4 2130 (42.40%) SQL Server Integration Services
5 2098 (41.77%) ETL
6 1742 (34.68%) SQL Server Reporting Services
7 1650 (32.85%) Microsoft
8 1571 (31.28%) Finance
9 1471 (29.29%) SQL Server Analysis Services
10 1435 (28.57%) Agile Software Development
11 1372 (27.31%) T-SQL
12 1190 (23.69%) Analytics
13 1119 (22.28%) Data Modelling
14 1048 (20.86%) Oracle
15 881 (17.54%) Big Data
16 793 (15.79%) Power BI
17 742 (14.77%) Analytical Skills
18 693 (13.80%) Tableau
19 635 (12.64%) Microsoft Azure
20 602 (11.98%) Retail
21 589 (11.73%) Visualisation
22 562 (11.19%) Degree
23 555 (11.05%) Relational Database
24 525 (10.45%) Python
25 516 (10.27%) Data Quality
26 510 (10.15%) Data Management
27 498 (9.91%) Java
28 489 (9.74%) BusinessObjects
29 486 (9.68%) Banking
30 482 (9.60%) 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 217 (4.32%) SAS
2 202 (4.02%) Apache Spark
3 176 (3.50%) SharePoint
4 65 (1.29%) Tomcat
5 61 (1.21%) JBoss
6 32 (0.64%) CMS
7 29 (0.58%) Elasticsearch
8 28 (0.56%) IIS
9 27 (0.54%) Oracle SOA Suite
10 21 (0.42%) Apache
11 19 (0.38%) Apache Solr
11 19 (0.38%) Confluence
11 19 (0.38%) SharePoint 2013
12 14 (0.28%) Sitecore CMS
13 13 (0.26%) Apache Airflow
14 12 (0.24%) nginx
15 10 (0.20%) Apache Pig
15 10 (0.20%) Luigi
15 10 (0.20%) MS Exchange
16 9 (0.18%) OpenEdge
Applications
1 411 (8.18%) Microsoft Excel
2 86 (1.71%) Microsoft Office
3 78 (1.55%) SPSS
4 76 (1.51%) Microsoft PowerPoint
5 39 (0.78%) MS Visio
6 15 (0.30%) Spreadsheet
7 8 (0.16%) Microsoft Project
8 2 (0.040%) Mingle
8 2 (0.040%) SPSS Modeler
9 1 (0.020%) Adobe Illustrator
9 1 (0.020%) Mathematica
9 1 (0.020%) Photoshop
9 1 (0.020%) Stata
9 1 (0.020%) Weka
Business Applications
1 67 (1.33%) Cognos Business Intelligence
2 53 (1.06%) Dynamics CRM
3 24 (0.48%) Dynamics NAV
4 23 (0.46%) Salesforce.com CRM
5 22 (0.44%) Dynamics AX
5 22 (0.44%) HFM
5 22 (0.44%) SAP BPC
6 19 (0.38%) Oracle ERP
7 18 (0.36%) Hyperion Enterprise
7 18 (0.36%) Oracle EBS
8 17 (0.34%) Cognos TM1
9 13 (0.26%) SAP ERP
10 12 (0.24%) Dynamics GP
10 12 (0.24%) Hyperion Planning
11 11 (0.22%) SAP CO
11 11 (0.22%) SAP FI
11 11 (0.22%) SAP FI/CO
12 9 (0.18%) Oracle Applications
13 8 (0.16%) Maximo
13 8 (0.16%) SAP MM
Cloud Services
1 635 (12.64%) Microsoft Azure
2 284 (5.65%) Amazon AWS
3 84 (1.67%) Azure Machine Learning
4 78 (1.55%) Google Cloud Platform
5 59 (1.17%) Azure Data Factory
6 48 (0.96%) SaaS
7 36 (0.72%) Google Analytics
8 33 (0.66%) PaaS
9 25 (0.50%) Office 365
10 24 (0.48%) Cloud Computing
11 22 (0.44%) Cortana Intelligence Suite
12 18 (0.36%) Dynamics 365
13 17 (0.34%) Google Play
14 15 (0.30%) IaaS
15 12 (0.24%) Amazon EC2
16 9 (0.18%) Amazon EMR
16 9 (0.18%) Amazon S3
17 7 (0.14%) GitHub
18 6 (0.12%) Amazon Kinesis
18 6 (0.12%) Data Lake Analytics
Communications & Networking
1 69 (1.37%) Internet
2 45 (0.90%) HTTP
3 44 (0.88%) SSL
4 41 (0.82%) TCP/IP
5 32 (0.64%) Intranet
6 11 (0.22%) DNS
6 11 (0.22%) Firewall
6 11 (0.22%) Kerberos
6 11 (0.22%) VLAN
7 10 (0.20%) Cisco ASA
7 10 (0.20%) Extranet
7 10 (0.20%) FTP
7 10 (0.20%) VPN
8 9 (0.18%) SAN
9 8 (0.16%) IPsec
9 8 (0.16%) LDAP
9 8 (0.16%) Skype
9 8 (0.16%) Wireless
10 6 (0.12%) NAS
10 6 (0.12%) SMS
Database & Business Intelligence
1 2590 (51.56%) SQL Server
2 2130 (42.40%) SQL Server Integration Services
3 1742 (34.68%) SQL Server Reporting Services
4 1471 (29.29%) SQL Server Analysis Services
5 881 (17.54%) Big Data
6 793 (15.79%) Power BI
7 555 (11.05%) Relational Database
8 489 (9.74%) BusinessObjects
9 482 (9.60%) OLAP
10 458 (9.12%) SQL Server 2016
11 441 (8.78%) SQL Server 2014
12 437 (8.70%) QlikView
13 435 (8.66%) SQL Server 2012
14 357 (7.11%) Hadoop
15 352 (7.01%) SQL Server 2008
16 271 (5.40%) Oracle Database
17 262 (5.22%) Microsoft Analysis Services
18 238 (4.74%) NoSQL
19 197 (3.92%) RDBMS
20 192 (3.82%) MySQL
Development Applications
1 154 (3.07%) Visual Studio
2 138 (2.75%) Team Foundation Server
3 115 (2.29%) JIRA
4 111 (2.21%) Talend Open Studio
5 89 (1.77%) SQL Server Management Studio (SSMS)
6 84 (1.67%) Git (software)
7 73 (1.45%) Maven
8 71 (1.41%) TeamCity
9 64 (1.27%) Selenium
9 64 (1.27%) Subversion
10 62 (1.23%) JUnit
11 52 (1.04%) Sonatype Nexus
12 51 (1.02%) Mockito
13 47 (0.94%) Jenkins
14 28 (0.56%) ERwin
15 26 (0.52%) Toad
16 25 (0.50%) HP UFT
17 24 (0.48%) Rational Functional Tester
18 21 (0.42%) PowerDesigner
19 19 (0.38%) Oracle Forms
General
1 1571 (31.28%) Finance
2 602 (11.98%) Retail
3 486 (9.68%) Banking
4 373 (7.43%) Marketing
5 264 (5.26%) Investment Banking
6 249 (4.96%) Retail Banking
7 178 (3.54%) Advertising
8 131 (2.61%) Games
9 125 (2.49%) Legal
10 111 (2.21%) Publishing
11 106 (2.11%) Telecoms
12 86 (1.71%) Manufacturing
13 77 (1.53%) Electronics
14 46 (0.92%) Back Office
15 44 (0.88%) Law
16 34 (0.68%) Front Office
17 26 (0.52%) Pharmaceutical
18 20 (0.40%) Polish Language
19 17 (0.34%) Billing
20 14 (0.28%) Local Government
Job Titles
1 2260 (44.99%) Developer
2 1070 (21.30%) Business Intelligence Developer
3 917 (18.26%) SQL Developer
4 799 (15.91%) Analyst
5 488 (9.72%) Data Warehouse Developer
6 443 (8.82%) Architect
7 425 (8.46%) SQL BI Developer
8 348 (6.93%) Senior Developer
9 347 (6.91%) DBA
10 337 (6.71%) SQL Server Developer
11 328 (6.53%) SSIS Developer
12 296 (5.89%) Consultant
13 279 (5.55%) Business Intelligence Analyst
14 266 (5.30%) SQL DBA
15 259 (5.16%) Data Architect
16 239 (4.76%) SSRS Developer
17 221 (4.40%) ETL Developer
18 209 (4.16%) Business Developer
18 209 (4.16%) Oracle Developer
19 199 (3.96%) SQL Analyst
Libraries, Frameworks & Software Standards
1 479 (9.54%) .NET
2 251 (5.00%) MDX
3 200 (3.98%) XML
4 180 (3.58%) Web Services
5 167 (3.32%) HTML
6 142 (2.83%) CSS
7 134 (2.67%) ASP.NET
8 105 (2.09%) RESTful
9 95 (1.89%) JSON
10 93 (1.85%) AngularJS
11 83 (1.65%) Spring
12 75 (1.49%) J2EE
13 72 (1.43%) HTML5
14 69 (1.37%) ASP.NET MVC
15 66 (1.31%) Middleware
16 62 (1.23%) Oracle GoldenGate
17 60 (1.19%) JMS
17 60 (1.19%) Kafka
18 59 (1.17%) JDBC
19 56 (1.11%) .NET Framework
Miscellaneous
1 742 (14.77%) Analytical Skills
2 297 (5.91%) Computer Science
3 277 (5.51%) Management Information System
4 197 (3.92%) Data Structures
5 165 (3.28%) Replication
6 125 (2.49%) Enterprise Software
6 125 (2.49%) Greenfield Project
7 94 (1.87%) Clustering
8 92 (1.83%) User Experience
9 83 (1.65%) Algorithms
10 71 (1.41%) Fintech
11 52 (1.04%) Reference Data
12 41 (0.82%) Hedge funds
13 38 (0.76%) iPad
14 37 (0.74%) NHS
15 36 (0.72%) Credit Risk
16 33 (0.66%) Data Centre
17 31 (0.62%) BBC
18 30 (0.60%) Mobile App
19 29 (0.58%) Social Media
Operating Systems
1 266 (5.30%) Unix
2 261 (5.20%) Linux
3 166 (3.30%) Windows
4 64 (1.27%) Windows Server
5 53 (1.06%) Android
6 28 (0.56%) Apple iOS
7 23 (0.46%) Windows Server 2008
8 18 (0.36%) Red Hat Enterprise Linux
8 18 (0.36%) Windows Server 2012
9 14 (0.28%) Solaris
10 13 (0.26%) AIX
11 4 (0.080%) Windows 10
12 3 (0.060%) CentOS
13 1 (0.020%) Oracle Linux
13 1 (0.020%) Tru64
13 1 (0.020%) Windows 7
13 1 (0.020%) Windows Server 2003
Processes & Methodologies
1 3328 (66.26%) Business Intelligence
2 2098 (41.77%) ETL
3 1435 (28.57%) Agile Software Development
4 1190 (23.69%) Analytics
5 1119 (22.28%) Data Modelling
6 589 (11.73%) Visualisation
7 510 (10.15%) Data Management
8 437 (8.70%) Kimball Methodology
9 428 (8.52%) Data Analysis
10 415 (8.26%) Data Integration
11 410 (8.16%) Data Visualisation
12 407 (8.10%) Migration
13 382 (7.61%) Performance Tuning
14 376 (7.49%) Data Analytics
15 370 (7.37%) Scrum
16 323 (6.43%) Stakeholder Management
17 317 (6.31%) Asset Management
17 317 (6.31%) CRM
18 286 (5.69%) Dimensional Modelling
19 269 (5.36%) SDLC
Programming Languages
1 3492 (69.52%) SQL
2 1372 (27.31%) T-SQL
3 525 (10.45%) Python
4 498 (9.91%) Java
5 477 (9.50%) PL/SQL
6 426 (8.48%) C#
7 296 (5.89%) R
8 183 (3.64%) JavaScript
9 145 (2.89%) Perl
10 121 (2.41%) Shell Script
11 120 (2.39%) VBA
12 116 (2.31%) PowerShell
13 97 (1.93%) Bash Shell
14 92 (1.83%) Scala
15 91 (1.81%) Data Analysis Expressions (DAX)
16 90 (1.79%) VB
17 82 (1.63%) VB.NET
18 81 (1.61%) C++
19 76 (1.51%) C
20 52 (1.04%) Ruby
Qualifications
1 562 (11.19%) Degree
2 122 (2.43%) Computer Science Degree
3 108 (2.15%) Microsoft Certification
4 72 (1.43%) Security Cleared
5 66 (1.31%) ISEB
6 55 (1.09%) SC Cleared
7 52 (1.04%) Numerate Degree
8 34 (0.68%) ISTQB
9 30 (0.60%) PMP
10 27 (0.54%) MCSA
10 27 (0.54%) MCSE
11 26 (0.52%) PMI Certification
12 21 (0.42%) Master's Degree
12 21 (0.42%) PhD
13 16 (0.32%) ITIL Foundation Certificate
14 14 (0.28%) Six Sigma Black Belt
14 14 (0.28%) Six Sigma Green Belt
15 13 (0.26%) ACCA
16 12 (0.24%) ITIL Certification
16 12 (0.24%) MCITP
Quality Assurance & Compliance
1 516 (10.27%) Data Quality
2 278 (5.53%) QA
3 42 (0.84%) GDPR
4 36 (0.72%) SLA
5 15 (0.30%) GCP
6 11 (0.22%) Basel III
6 11 (0.22%) PCI DSS
6 11 (0.22%) Solvency II
7 10 (0.20%) ISO/IEC 27001
8 7 (0.14%) MiFID
8 7 (0.14%) PMO
9 5 (0.100%) IFRS
9 5 (0.100%) IFRS 9
10 4 (0.080%) Basel II
10 4 (0.080%) ISO 9001
10 4 (0.080%) Sarbanes-Oxley
11 3 (0.060%) IAS 39
12 2 (0.040%) Actionable Recommendations
12 2 (0.040%) COBIT
13 1 (0.020%) NEBOSH
System Software
1 29 (0.58%) Active Directory
1 29 (0.58%) VMware Infrastructure
2 26 (0.52%) Docker
3 22 (0.44%) HDFS
4 17 (0.34%) Hyper-V
5 12 (0.24%) Oracle RAC
6 10 (0.20%) Virtual Machines
7 9 (0.18%) KVM
8 8 (0.16%) Apache Flume
8 8 (0.16%) VMware ESXi
9 3 (0.060%) Firmware
9 3 (0.060%) Microsoft Virtual Server
9 3 (0.060%) Virtual Servers
10 1 (0.020%) Cronacle
10 1 (0.020%) NFS
10 1 (0.020%) PowerHA
10 1 (0.020%) Veritas Volume Manager
10 1 (0.020%) vSphere
Systems Management
1 33 (0.66%) Failover Clustering
2 31 (0.62%) Oozie
3 18 (0.36%) Tivoli
4 17 (0.34%) Ansible
5 16 (0.32%) Control-M
6 15 (0.30%) Puppet
7 14 (0.28%) Kibana
8 13 (0.26%) Terraform
9 12 (0.24%) Mesos
10 11 (0.22%) Opscode Chef
11 9 (0.18%) Microsoft Clustering
12 8 (0.16%) HP Quality Center
12 8 (0.16%) SCCM
13 7 (0.14%) Hadoop YARN
14 6 (0.12%) Data Guard
14 6 (0.12%) Perfmon
15 5 (0.100%) Oracle RMAN
16 3 (0.060%) Nagios
16 3 (0.060%) Oracle Enterprise Manager
16 3 (0.060%) SCOM
Vendors
1 1650 (32.85%) Microsoft
2 1048 (20.86%) Oracle
3 693 (13.80%) Tableau
4 370 (7.37%) SAP
5 250 (4.98%) Cognos
6 229 (4.56%) Informatica
7 138 (2.75%) Google
7 138 (2.75%) MicroStrategy
8 134 (2.67%) IBM
9 111 (2.21%) Talend
10 106 (2.11%) Teradata
11 70 (1.39%) TIBCO
12 69 (1.37%) Salesforce.com
13 65 (1.29%) Netezza
14 62 (1.23%) Alteryx
15 57 (1.13%) Hyperion
16 50 (1.00%) Facebook
17 49 (0.98%) VMware
18 41 (0.82%) Sybase
19 37 (0.74%) Apple