Period
to 20 May 2018

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

Data Warehousing
UK > England
6 months to
20 May 2018
Same period 2017 Same period 2016
Rank 122 105 83
Rank change year-on-year -17 -22 +17
Permanent jobs citing Data Warehouse 4,444 4,534 6,242
As % of all permanent IT jobs advertised in England 2.76% 2.82% 3.30%
As % of the Database & Business Intelligence category 8.99% 9.20% 10.64%
Number of salaries quoted 3,636 3,953 5,172
England median annual salary £52,500 £51,500 £52,500
Median salary % change year-on-year +1.94% -1.90% +0.96%
10th Percentile £33,750 £32,500 £32,500
90th Percentile £82,500 £80,000 £80,000
UK median annual salary £52,500 £50,000 £52,500
% change year-on-year +5.00% -4.76% +5.00%

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 49,438 49,284 58,690
As % of all permanent IT jobs advertised in England 30.72% 30.67% 31.05%
Number of salaries quoted 40,837 42,283 50,573
England median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £30,000 £29,000
90th Percentile £81,250 £77,500 £75,000
UK median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +5.56%

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 20 May 2018.

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 20 May 2018. 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 -2 2,246 £60,000 - 253
North of England -15 691 £45,000 +5.88% 71
South East -3 553 £50,000 - 89
Midlands -10 417 £45,000 - 54
North West -25 345 £45,000 +12.50% 41
Yorkshire -13 294 £45,000 +5.88% 27
East of England +17 274 £50,000 - 22
West Midlands -2 244 £47,000 +10.59% 27
South West +20 240 £41,500 -2.35% 31
East Midlands -12 173 £42,500 -5.56% 26
North East +17 52 £37,375 -15.06% 3
Data Warehouse
UK

For the 6 months to 20 May 2018, 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,905 (65.37%) SQL
2 2,890 (65.03%) Business Intelligence
3 2,405 (54.12%) SQL Server
4 2,002 (45.05%) SQL Server Integration Services
5 1,914 (43.07%) ETL
6 1,674 (37.67%) SQL Server Reporting Services
7 1,494 (33.62%) Microsoft
8 1,420 (31.95%) SQL Server Analysis Services
9 1,221 (27.48%) Agile Software Development
10 1,220 (27.45%) T-SQL
11 1,205 (27.12%) Finance
12 1,072 (24.12%) Analytics
13 991 (22.30%) Data Modelling
14 887 (19.96%) Power BI
15 774 (17.42%) Oracle
16 744 (16.74%) Big Data
17 696 (15.66%) Analytical Skills
18 651 (14.65%) Microsoft Azure
19 610 (13.73%) Tableau
20 513 (11.54%) Visualisation
21 500 (11.25%) .NET
22 487 (10.96%) Problem-Solving
23 463 (10.42%) Relational Database
24 462 (10.40%) Degree
25 447 (10.06%) Python
26 432 (9.72%) Hadoop
27 419 (9.43%) Data Quality
28 418 (9.41%) Data Integration
29 414 (9.32%) Data Analysis
30 401 (9.02%) Data Architecture

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 252 (5.67%) Apache Spark
2 181 (4.07%) SAS
3 103 (2.32%) SharePoint
4 49 (1.10%) Confluence
5 48 (1.08%) Apache
6 36 (0.81%) Elasticsearch
7 35 (0.79%) IIS
7 35 (0.79%) Oracle SOA Suite
8 30 (0.68%) BizTalk Server
9 24 (0.54%) Apache Solr
10 23 (0.52%) Apache Pig
11 17 (0.38%) CMS
12 16 (0.36%) MS Exchange
12 16 (0.36%) WebSphere
13 13 (0.29%) WebLogic
14 12 (0.27%) Apache Airflow
15 11 (0.25%) SharePoint 2010
15 11 (0.25%) Skype for Business
16 8 (0.18%) Drupal
16 8 (0.18%) Umbraco
Applications
1 340 (7.65%) Microsoft Excel
2 86 (1.94%) Microsoft Office
3 70 (1.58%) MS Visio
4 35 (0.79%) Microsoft PowerPoint
5 20 (0.45%) Microsoft Project
6 17 (0.38%) Spreadsheet
7 11 (0.25%) SPSS
8 1 (0.023%) Adobe Illustrator
8 1 (0.023%) CPLEX
8 1 (0.023%) EViews
8 1 (0.023%) InfoPath
8 1 (0.023%) Photoshop
8 1 (0.023%) Weka
Business Applications
1 48 (1.08%) Markit EDM
2 34 (0.77%) NetSuite
3 32 (0.72%) Cognos Business Intelligence
4 31 (0.70%) Dynamics CRM
5 28 (0.63%) Cognos TM1
6 24 (0.54%) Dynamics AX
7 22 (0.50%) Oracle EBS
8 15 (0.34%) JDE EnterpriseOne
8 15 (0.34%) Oracle EBS R12
9 14 (0.32%) Salesforce.com CRM
10 13 (0.29%) MetaTrader
11 8 (0.18%) Eagle PACE
11 8 (0.18%) SAP ERP
11 8 (0.18%) SAP S/4HANA
12 6 (0.14%) Dynamics NAV
12 6 (0.14%) Elite 3E
12 6 (0.14%) Remedy ITSM
12 6 (0.14%) SAP BPC
13 5 (0.11%) Oracle BPM
13 5 (0.11%) Oracle Retail
Cloud Services
1 651 (14.65%) Microsoft Azure
2 370 (8.33%) Amazon AWS
3 111 (2.50%) Azure Data Factory
4 69 (1.55%) Google Cloud Platform
5 59 (1.33%) SaaS
6 55 (1.24%) Cloud Computing
7 48 (1.08%) PaaS
8 47 (1.06%) Office 365
9 35 (0.79%) Amazon EMR
10 29 (0.65%) Amazon Kinesis
10 29 (0.65%) Cortana Intelligence Suite
11 28 (0.63%) Amazon S3
12 25 (0.56%) Serverless
13 23 (0.52%) Amazon ElastiCache
14 22 (0.50%) IaaS
15 18 (0.41%) Azure Machine Learning
16 17 (0.38%) Dynamics 365
17 15 (0.34%) AWS Lambda
17 15 (0.34%) Data Lake Analytics
18 13 (0.29%) IBM Cloud
Communications & Networking
1 54 (1.22%) Internet
2 41 (0.92%) Firewall
3 37 (0.83%) DNS
3 37 (0.83%) HTTP
4 32 (0.72%) LAN
5 31 (0.70%) WAN
6 29 (0.65%) SSL
7 28 (0.63%) DHCP
8 23 (0.52%) SMS
8 23 (0.52%) TCP/IP
9 21 (0.47%) Wireless
10 19 (0.43%) SAN
11 11 (0.25%) ICMP
11 11 (0.25%) Network Security
11 11 (0.25%) OSPF
11 11 (0.25%) Remote Desktop
11 11 (0.25%) Skype
11 11 (0.25%) SNMP
11 11 (0.25%) VLAN
11 11 (0.25%) VoIP
Database & Business Intelligence
1 2,405 (54.12%) SQL Server
2 2,002 (45.05%) SQL Server Integration Services
3 1,674 (37.67%) SQL Server Reporting Services
4 1,420 (31.95%) SQL Server Analysis Services
5 887 (19.96%) Power BI
6 744 (16.74%) Big Data
7 463 (10.42%) Relational Database
8 432 (9.72%) Hadoop
9 334 (7.52%) BusinessObjects
10 331 (7.45%) SQL Server 2016
11 317 (7.13%) QlikView
12 285 (6.41%) OLAP
13 272 (6.12%) Microsoft Analysis Services
14 271 (6.10%) SQL Server 2014
15 263 (5.92%) SQL Server 2012
16 236 (5.31%) Data Lake
17 229 (5.15%) MySQL
18 227 (5.11%) NoSQL
19 184 (4.14%) SQL Server 2008
20 179 (4.03%) Apache Hive
Development Applications
1 152 (3.42%) Team Foundation Server
2 140 (3.15%) JIRA
3 123 (2.77%) SQL Server Management Studio (SSMS)
4 115 (2.59%) Visual Studio
5 104 (2.34%) Git (software)
6 88 (1.98%) Jenkins
7 77 (1.73%) TeamCity
8 72 (1.62%) ERwin
9 44 (0.99%) Selenium
10 39 (0.88%) Subversion
11 31 (0.70%) Oracle Forms
12 24 (0.54%) Toad
13 23 (0.52%) Oracle APEX
14 17 (0.38%) JUnit
15 16 (0.36%) Cucumber
16 15 (0.34%) Eclipse
16 15 (0.34%) Visual Studio Team System
17 12 (0.27%) Bitbucket
18 10 (0.23%) SoapUI
19 9 (0.20%) SpecFlow
General
1 1,205 (27.12%) Finance
2 364 (8.19%) Retail
3 280 (6.30%) Advertising
4 227 (5.11%) Banking
5 217 (4.88%) Marketing
6 60 (1.35%) Games
7 57 (1.28%) Manufacturing
8 50 (1.13%) Legal
9 42 (0.95%) Law
9 42 (0.95%) Publishing
10 37 (0.83%) Automotive
11 31 (0.70%) Financial Institution
11 31 (0.70%) Investment Banking
11 31 (0.70%) Telecoms
12 26 (0.59%) Back Office
13 25 (0.56%) Front Office
14 21 (0.47%) Pharmaceutical
15 19 (0.43%) Billing
16 18 (0.41%) Electronics
16 18 (0.41%) Local Government
Job Titles
1 1,885 (42.42%) Developer
2 971 (21.85%) Business Intelligence Developer
3 746 (16.79%) Analyst
4 675 (15.19%) SQL Developer
5 526 (11.84%) Architect
6 342 (7.70%) Data Warehouse Developer
7 328 (7.38%) SSIS Developer
8 324 (7.29%) Data Architect
9 310 (6.98%) SQL BI Developer
10 273 (6.14%) Business Intelligence Analyst
11 270 (6.08%) Consultant
12 253 (5.69%) SQL Server Developer
13 244 (5.49%) SSRS Developer
14 228 (5.13%) DBA
15 223 (5.02%) Data Engineer
16 202 (4.55%) Data Analyst
17 197 (4.43%) Business Analyst
18 196 (4.41%) Senior Developer
19 191 (4.30%) Business Developer
20 178 (4.01%) ETL Developer
Libraries, Frameworks & Software Standards
1 500 (11.25%) .NET
2 298 (6.71%) Web Services
3 244 (5.49%) XML
4 187 (4.21%) HTML
5 163 (3.67%) Kafka
6 157 (3.53%) MDX
7 145 (3.26%) JSON
8 119 (2.68%) CSS
9 115 (2.59%) SOAP
10 104 (2.34%) .NET Framework
11 98 (2.21%) REST
12 74 (1.67%) ASP.NET
13 72 (1.62%) RESTful
14 63 (1.42%) AngularJS
15 60 (1.35%) Entity Framework
15 60 (1.35%) Middleware
16 53 (1.19%) HTML5
17 48 (1.08%) jQuery
18 41 (0.92%) Spring
19 35 (0.79%) CSS3
Miscellaneous
1 696 (15.66%) Analytical Skills
2 227 (5.11%) Computer Science
3 203 (4.57%) Management Information System
4 174 (3.92%) Greenfield Project
5 125 (2.81%) Self-Motivation
6 124 (2.79%) Data Structures
7 110 (2.48%) NHS
7 110 (2.48%) Replication
8 106 (2.39%) User Experience
9 97 (2.18%) Fintech
10 80 (1.80%) Algorithms
11 79 (1.78%) Enterprise Software
12 69 (1.55%) Clustering
13 54 (1.22%) Data Centre
14 48 (1.08%) Virtual Team
15 41 (0.92%) Hedge funds
16 37 (0.83%) Mobile App
17 33 (0.74%) Credit Risk
17 33 (0.74%) Reinsurance
18 29 (0.65%) Equities
Operating Systems
1 284 (6.39%) Linux
2 232 (5.22%) Windows
3 178 (4.01%) Unix
4 61 (1.37%) Windows Server
5 35 (0.79%) AIX
6 32 (0.72%) Windows Server 2008
7 23 (0.52%) Windows Server 2012
8 22 (0.50%) HPUX
8 22 (0.50%) Solaris
9 12 (0.27%) Android
9 12 (0.27%) Windows XP
10 11 (0.25%) Windows 8
10 11 (0.25%) Windows Server 2003
11 7 (0.16%) Apple iOS
12 5 (0.11%) CentOS
12 5 (0.11%) zOS
13 4 (0.090%) Mac OS X
13 4 (0.090%) Red Hat Enterprise Linux
13 4 (0.090%) Windows Vista
14 3 (0.068%) Oracle Linux
Processes & Methodologies
1 2,890 (65.03%) Business Intelligence
2 1,914 (43.07%) ETL
3 1,221 (27.48%) Agile Software Development
4 1,072 (24.12%) Analytics
5 991 (22.30%) Data Modelling
6 513 (11.54%) Visualisation
7 487 (10.96%) Problem-Solving
8 418 (9.41%) Data Integration
9 414 (9.32%) Data Analysis
10 401 (9.02%) Data Architecture
11 399 (8.98%) Kimball Methodology
12 398 (8.96%) Data Management
13 372 (8.37%) Migration
14 360 (8.10%) Performance Tuning
15 351 (7.90%) Scrum
16 322 (7.25%) SDLC
17 305 (6.86%) Data Visualisation
18 292 (6.57%) Data Analytics
19 279 (6.28%) Data Science
20 253 (5.69%) Data Governance
Programming Languages
1 2,905 (65.37%) SQL
2 1,220 (27.45%) T-SQL
3 447 (10.06%) Python
4 396 (8.91%) Java
5 387 (8.71%) C#
6 230 (5.18%) JavaScript
7 228 (5.13%) PL/SQL
8 168 (3.78%) PowerShell
9 151 (3.40%) Scala
10 150 (3.38%) R
11 128 (2.88%) Data Analysis Expressions (DAX)
12 117 (2.63%) VBA
13 103 (2.32%) Shell Script
14 74 (1.67%) PHP
15 60 (1.35%) Go
16 54 (1.22%) VB.NET
17 52 (1.17%) VB
18 51 (1.15%) C
19 49 (1.10%) C++
20 45 (1.01%) VBScript
Qualifications
1 462 (10.40%) Degree
2 100 (2.25%) Microsoft Certification
3 84 (1.89%) Computer Science Degree
4 71 (1.60%) ISEB
5 67 (1.51%) Security Cleared
6 52 (1.17%) ITIL Certification
7 39 (0.88%) MCSE
8 37 (0.83%) MCSA
8 37 (0.83%) TOGAF Certification
9 36 (0.81%) Master's Degree
9 36 (0.81%) SC Cleared
10 35 (0.79%) ISTQB
11 32 (0.72%) Numerate Degree
12 27 (0.61%) PMI Certification
13 18 (0.41%) PMP
14 17 (0.38%) Postgraduate
15 16 (0.36%) MBA
15 16 (0.36%) Microsoft Certified Architect
16 12 (0.27%) MCDBA
17 11 (0.25%) MCP
Quality Assurance & Compliance
1 419 (9.43%) Data Quality
2 265 (5.96%) QA
3 77 (1.73%) GDPR
3 77 (1.73%) PMO
4 27 (0.61%) SLA
5 18 (0.41%) Solvency II
6 10 (0.23%) Web Application Security Consortium
7 8 (0.18%) GCP
8 7 (0.16%) Sarbanes-Oxley
9 6 (0.14%) IFRS
9 6 (0.14%) IFRS 9
9 6 (0.14%) PCI DSS
10 5 (0.11%) ISO/IEC 27001
11 3 (0.068%) HL7
11 3 (0.068%) ISO/IEC 20000
11 3 (0.068%) MiFID
12 2 (0.045%) COBIT
12 2 (0.045%) GAAP
12 2 (0.045%) TickIT
13 1 (0.023%) SNOMED CT
System Software
1 96 (2.16%) HDFS
2 73 (1.64%) Active Directory
2 73 (1.64%) Apache Flume
3 48 (1.08%) Docker
3 48 (1.08%) VMware Infrastructure
4 11 (0.25%) Hyper-V
4 11 (0.25%) XenApp
5 8 (0.18%) Apache ZooKeeper
6 4 (0.090%) Xen
7 3 (0.068%) vSphere
8 2 (0.045%) Oracle RAC
8 2 (0.045%) Virtual Machines
8 2 (0.045%) VMware ESXi
8 2 (0.045%) VMware Workstation
Systems Management
1 58 (1.31%) Hadoop YARN
2 29 (0.65%) Oozie
3 26 (0.59%) Mesos
4 20 (0.45%) Systems Management Server (SMS)
5 17 (0.38%) Puppet
6 16 (0.36%) Opscode Chef
7 15 (0.34%) Ambari
8 14 (0.32%) Ansible
8 14 (0.32%) Kubernetes
9 13 (0.29%) Failover Clustering
10 12 (0.27%) Terraform
11 11 (0.25%) Automic
11 11 (0.25%) SCCM
12 10 (0.23%) Dollar Universe
12 10 (0.23%) Kibana
12 10 (0.23%) Nagios
13 9 (0.20%) Single Sign-On
14 8 (0.18%) Control-M
14 8 (0.18%) FortiGate
14 8 (0.18%) Perfmon
Vendors
1 1,494 (33.62%) Microsoft
2 774 (17.42%) Oracle
3 610 (13.73%) Tableau
4 275 (6.19%) SAP
5 229 (5.15%) Informatica
6 178 (4.01%) Cognos
7 139 (3.13%) Talend
8 108 (2.43%) Google
8 108 (2.43%) IBM
9 99 (2.23%) Cloudera
10 89 (2.00%) Teradata
11 85 (1.91%) MicroStrategy
12 60 (1.35%) Salesforce.com
13 58 (1.31%) HP
14 55 (1.24%) Hortonworks
14 55 (1.24%) VMware
15 45 (1.01%) RedGate
16 44 (0.99%) Alteryx
16 44 (0.99%) Netezza
17 34 (0.77%) Cisco