Period
to 24 November 2017

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

Data Warehousing
UK > England
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 115 108 82
Rank change year-on-year -7 -26 +8
Permanent jobs citing Data Warehouse 4682 5076 7033
As % of all permanent IT jobs advertised in England 2.77% 2.84% 3.42%
As % of the Database & Business Intelligence category 9.20% 9.60% 10.82%
Number of salaries quoted 3738 4391 5820
England median annual salary £52,500 £55,000 £50,000
Median salary % change year-on-year -4.55% +10.00% -6.47%
10th Percentile £32,500 £33,750 £33,541
90th Percentile £77,500 £82,500 £80,000
UK median annual salary £50,982 £53,500 £50,000
% change year-on-year -4.71% +7.00% -4.76%

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 50907 52874 65019
As % of all permanent IT jobs advertised in England 30.16% 29.61% 31.60%
Number of salaries quoted 42290 45640 55287
England median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £30,000 £29,000 £28,500
90th Percentile £77,500 £77,500 £75,000
UK median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% +2.27%

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

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 24 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
London -14 2405 £60,000 - 104
North of England +22 781 £45,000 +2.27% 55
South East -11 588 £50,000 -4.76% 41
Midlands +11 415 £47,500 +9.83% 16
North West -4 408 £42,500 - 25
Yorkshire +40 350 £45,000 - 22
South West +60 290 £42,500 - 16
West Midlands +21 280 £47,500 +11.76% 13
East of England -51 193 £55,000 +10.00% 19
East Midlands -1 126 £45,000 - 3
North East -1 23 £40,000 +6.67% 8
Data Warehouse
UK

For the 6 months to 24 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 across the England region with a requirement for Data Warehouse.

1 3179 (67.90%) SQL
2 3154 (67.36%) Business Intelligence
3 2299 (49.10%) SQL Server
4 1995 (42.61%) ETL
5 1864 (39.81%) SQL Server Integration Services
6 1540 (32.89%) SQL Server Reporting Services
7 1511 (32.27%) Finance
8 1435 (30.65%) Microsoft
9 1308 (27.94%) Agile Software Development
10 1278 (27.30%) SQL Server Analysis Services
11 1265 (27.02%) Analytics
12 1233 (26.33%) T-SQL
13 1189 (25.40%) Data Modelling
14 965 (20.61%) Oracle
15 813 (17.36%) Power BI
16 803 (17.15%) Analytical Skills
17 777 (16.60%) Tableau
18 767 (16.38%) Big Data
19 627 (13.39%) Visualisation
20 584 (12.47%) Microsoft Azure
21 567 (12.11%) Python
22 523 (11.17%) Data Management
23 519 (11.09%) Banking
24 500 (10.68%) Degree
25 498 (10.64%) QlikView
26 486 (10.38%) Java
27 478 (10.21%) BusinessObjects
28 464 (9.91%) Data Quality
29 444 (9.48%) OLAP
30 435 (9.29%) Kimball Methodology

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 234 (5.00%) Apache Spark
2 180 (3.84%) SAS
3 164 (3.50%) SharePoint
4 51 (1.09%) Tomcat
5 50 (1.07%) JBoss
6 32 (0.68%) Confluence
7 27 (0.58%) CMS
8 25 (0.53%) Apache
9 24 (0.51%) IIS
10 22 (0.47%) Oracle SOA Suite
11 21 (0.45%) Apache Pig
12 18 (0.38%) Apache Airflow
13 17 (0.36%) BizTalk Server
14 15 (0.32%) SharePoint 2013
15 13 (0.28%) Apache Solr
15 13 (0.28%) WebSphere
16 11 (0.23%) MS Exchange
17 10 (0.21%) Elasticsearch
18 8 (0.17%) nginx
18 8 (0.17%) OpenROAD
Applications
1 396 (8.46%) Microsoft Excel
2 107 (2.29%) Microsoft PowerPoint
3 96 (2.05%) Microsoft Office
4 58 (1.24%) SPSS
5 30 (0.64%) MS Visio
6 16 (0.34%) Microsoft Project
7 8 (0.17%) Spreadsheet
8 3 (0.064%) SPSS Modeler
9 1 (0.021%) Mathematica
9 1 (0.021%) S-PLUS
9 1 (0.021%) Stata
9 1 (0.021%) Weka
Business Applications
1 40 (0.85%) Cognos Business Intelligence
2 39 (0.83%) Dynamics CRM
3 22 (0.47%) Dynamics AX
4 19 (0.41%) Dynamics NAV
5 16 (0.34%) SAP ERP
6 15 (0.32%) Cognos TM1
6 15 (0.32%) Oracle EBS
6 15 (0.32%) Oracle ERP
6 15 (0.32%) Salesforce.com CRM
7 14 (0.30%) HFM
8 11 (0.23%) BusinessWorks
8 11 (0.23%) TIBCO BusinessEvents
9 10 (0.21%) Unit4 Business World
10 9 (0.19%) SAP APO
11 8 (0.17%) Eikon
12 7 (0.15%) SAP Business ByDesign
12 7 (0.15%) SAP Business One
13 6 (0.13%) Hyperion Enterprise
13 6 (0.13%) Maximo
13 6 (0.13%) Oracle Financials
Cloud Services
1 584 (12.47%) Microsoft Azure
2 320 (6.83%) Amazon AWS
3 91 (1.94%) Google Cloud Platform
4 75 (1.60%) Azure Data Factory
5 69 (1.47%) Azure Machine Learning
6 56 (1.20%) SaaS
7 45 (0.96%) PaaS
8 41 (0.88%) Cloud Computing
9 32 (0.68%) Office 365
10 30 (0.64%) Cortana Intelligence Suite
11 21 (0.45%) IaaS
12 18 (0.38%) GitHub
13 17 (0.36%) Google Analytics
14 16 (0.34%) Amazon EMR
14 16 (0.34%) Dynamics 365
15 15 (0.32%) Amazon Kinesis
16 14 (0.30%) Amazon S3
17 13 (0.28%) Amazon ElastiCache
18 7 (0.15%) Google Tag Manager
19 6 (0.13%) Salesforce Service Cloud
Communications & Networking
1 65 (1.39%) Internet
2 63 (1.35%) HTTP
3 59 (1.26%) SSL
4 53 (1.13%) TCP/IP
5 29 (0.62%) Firewall
5 29 (0.62%) Intranet
6 25 (0.53%) DNS
7 14 (0.30%) SMS
8 9 (0.19%) VLAN
9 8 (0.17%) Cisco ASA
9 8 (0.17%) IPsec
9 8 (0.17%) VPN
10 6 (0.13%) FTP
10 6 (0.13%) Kerberos
10 6 (0.13%) LDAP
10 6 (0.13%) SAN
11 5 (0.11%) NAS
11 5 (0.11%) Skype
12 3 (0.064%) Extranet
13 2 (0.043%) MPLS
Database & Business Intelligence
1 2299 (49.10%) SQL Server
2 1864 (39.81%) SQL Server Integration Services
3 1540 (32.89%) SQL Server Reporting Services
4 1278 (27.30%) SQL Server Analysis Services
5 813 (17.36%) Power BI
6 767 (16.38%) Big Data
7 498 (10.64%) QlikView
8 478 (10.21%) BusinessObjects
9 444 (9.48%) OLAP
10 432 (9.23%) Relational Database
11 382 (8.16%) SQL Server 2016
12 380 (8.12%) Hadoop
13 374 (7.99%) SQL Server 2014
14 364 (7.77%) SQL Server 2012
15 278 (5.94%) SQL Server 2008
16 257 (5.49%) Microsoft Analysis Services
17 211 (4.51%) NoSQL
18 204 (4.36%) Oracle Database
19 188 (4.02%) Data Lake
20 186 (3.97%) MySQL
Development Applications
1 178 (3.80%) Team Foundation Server
2 161 (3.44%) Visual Studio
3 147 (3.14%) JIRA
4 123 (2.63%) Talend Open Studio
5 92 (1.96%) Git (software)
6 91 (1.94%) SQL Server Management Studio (SSMS)
7 64 (1.37%) Jenkins
8 62 (1.32%) Maven
9 57 (1.22%) TeamCity
10 55 (1.17%) Subversion
11 47 (1.00%) Toad
12 46 (0.98%) JUnit
13 45 (0.96%) ERwin
14 44 (0.94%) Mockito
14 44 (0.94%) Sonatype Nexus
15 40 (0.85%) Selenium
16 32 (0.68%) Atlassian Bamboo
16 32 (0.68%) Bitbucket
17 28 (0.60%) Eclipse
18 22 (0.47%) Oracle Forms
General
1 1511 (32.27%) Finance
2 519 (11.09%) Banking
3 331 (7.07%) Investment Banking
3 331 (7.07%) Retail Banking
4 315 (6.73%) Marketing
5 272 (5.81%) Retail
6 183 (3.91%) Advertising
7 122 (2.61%) Publishing
8 103 (2.20%) Games
9 102 (2.18%) Manufacturing
10 82 (1.75%) Telecoms
11 78 (1.67%) Electronics
12 71 (1.52%) Legal
13 35 (0.75%) Back Office
13 35 (0.75%) Law
14 29 (0.62%) Front Office
15 17 (0.36%) Polish Language
16 16 (0.34%) Pharmaceutical
17 15 (0.32%) French Language
18 14 (0.30%) Financial Institution
Job Titles
1 2134 (45.58%) Developer
2 1025 (21.89%) Business Intelligence Developer
3 821 (17.54%) SQL Developer
4 743 (15.87%) Analyst
5 476 (10.17%) Architect
6 442 (9.44%) Data Warehouse Developer
7 402 (8.59%) SQL BI Developer
8 301 (6.43%) SQL Server Developer
9 299 (6.39%) SSIS Developer
10 296 (6.32%) Data Architect
11 272 (5.81%) Business Developer
12 268 (5.72%) DBA
13 264 (5.64%) Consultant
14 249 (5.32%) Senior Developer
15 237 (5.06%) Business Intelligence Analyst
16 233 (4.98%) SSRS Developer
17 212 (4.53%) SQL DBA
18 192 (4.10%) Data Analyst
18 192 (4.10%) ETL Developer
19 180 (3.84%) Business Analyst
Libraries, Frameworks & Software Standards
1 377 (8.05%) .NET
2 243 (5.19%) Web Services
3 219 (4.68%) MDX
4 206 (4.40%) XML
5 172 (3.67%) HTML
6 136 (2.90%) CSS
7 127 (2.71%) JSON
8 110 (2.35%) ASP.NET
9 93 (1.99%) Spring
10 88 (1.88%) Middleware
11 87 (1.86%) RESTful
12 82 (1.75%) AngularJS
13 73 (1.56%) Kafka
14 68 (1.45%) REST
15 67 (1.43%) J2EE
15 67 (1.43%) Oracle GoldenGate
16 61 (1.30%) HTML5
16 61 (1.30%) SOAP
17 55 (1.17%) JDBC
17 55 (1.17%) jQuery
Miscellaneous
1 803 (17.15%) Analytical Skills
2 245 (5.23%) Computer Science
3 242 (5.17%) Management Information System
4 192 (4.10%) Data Structures
5 181 (3.87%) Enterprise Software
6 137 (2.93%) Replication
7 110 (2.35%) Greenfield Project
8 102 (2.18%) User Experience
9 98 (2.09%) Clustering
10 83 (1.77%) Algorithms
11 72 (1.54%) Fintech
12 63 (1.35%) Virtual Team
13 56 (1.20%) Reference Data
14 51 (1.09%) NHS
15 43 (0.92%) Data Centre
16 31 (0.66%) Credit Risk
17 30 (0.64%) Equities
17 30 (0.64%) Hedge funds
18 28 (0.60%) PMI
19 24 (0.51%) Mobile App
Operating Systems
1 256 (5.47%) Unix
2 196 (4.19%) Linux
3 144 (3.08%) Windows
4 69 (1.47%) Windows Server
5 30 (0.64%) AIX
6 26 (0.56%) Android
7 21 (0.45%) Windows Server 2008
7 21 (0.45%) Windows Server 2012
8 19 (0.41%) Apple iOS
9 11 (0.23%) Red Hat Enterprise Linux
10 10 (0.21%) Solaris
11 3 (0.064%) Oracle Linux
12 1 (0.021%) Ubuntu
12 1 (0.021%) Windows 10
12 1 (0.021%) Windows 7
Processes & Methodologies
1 3154 (67.36%) Business Intelligence
2 1995 (42.61%) ETL
3 1308 (27.94%) Agile Software Development
4 1265 (27.02%) Analytics
5 1189 (25.40%) Data Modelling
6 627 (13.39%) Visualisation
7 523 (11.17%) Data Management
8 435 (9.29%) Kimball Methodology
9 423 (9.03%) Asset Management
10 407 (8.69%) Data Analytics
11 394 (8.42%) Data Integration
12 380 (8.12%) Data Visualisation
13 379 (8.09%) Performance Tuning
14 376 (8.03%) Migration
15 368 (7.86%) Data Analysis
16 351 (7.50%) Wealth Management
17 335 (7.16%) Scrum
18 321 (6.86%) Data Architecture
19 303 (6.47%) Stakeholder Management
20 289 (6.17%) Dimensional Modelling
Programming Languages
1 3179 (67.90%) SQL
2 1233 (26.33%) T-SQL
3 567 (12.11%) Python
4 486 (10.38%) Java
5 426 (9.10%) PL/SQL
6 387 (8.27%) C#
7 289 (6.17%) R
8 184 (3.93%) JavaScript
9 139 (2.97%) Perl
10 121 (2.58%) PowerShell
11 114 (2.43%) Scala
12 109 (2.33%) Shell Script
13 106 (2.26%) VBA
14 98 (2.09%) C++
15 78 (1.67%) Bash Shell
16 66 (1.41%) Data Analysis Expressions (DAX)
17 65 (1.39%) VB.NET
18 60 (1.28%) VB
19 56 (1.20%) C
20 54 (1.15%) PHP
Qualifications
1 500 (10.68%) Degree
2 112 (2.39%) Computer Science Degree
3 84 (1.79%) Microsoft Certification
4 61 (1.30%) Security Cleared
5 52 (1.11%) SC Cleared
6 47 (1.00%) Numerate Degree
7 36 (0.77%) MCSA
7 36 (0.77%) MCSE
8 29 (0.62%) ISEB
8 29 (0.62%) PMI Certification
9 27 (0.58%) PMP
10 26 (0.56%) Six Sigma Black Belt
10 26 (0.56%) Six Sigma Green Belt
11 23 (0.49%) PhD
12 21 (0.45%) Master's Degree
13 17 (0.36%) ISTQB
14 16 (0.34%) ITIL Foundation Certificate
15 13 (0.28%) MBA
16 10 (0.21%) ACCA
16 10 (0.21%) MCDBA
Quality Assurance & Compliance
1 464 (9.91%) Data Quality
2 275 (5.87%) QA
3 74 (1.58%) GDPR
4 26 (0.56%) GCP
5 23 (0.49%) SLA
6 18 (0.38%) PCI DSS
7 15 (0.32%) PMO
8 13 (0.28%) ISO/IEC 27001
9 7 (0.15%) Solvency II
10 5 (0.11%) NEBOSH
10 5 (0.11%) Web Application Security Consortium
11 3 (0.064%) COBIT
11 3 (0.064%) IFRS
11 3 (0.064%) IFRS 9
12 2 (0.043%) Actionable Recommendations
13 1 (0.021%) GAAP
13 1 (0.021%) HL7
13 1 (0.021%) ISO 9001
13 1 (0.021%) ISO/IEC 20000
13 1 (0.021%) UCITS
System Software
1 32 (0.68%) VMware Infrastructure
2 27 (0.58%) Active Directory
3 21 (0.45%) Docker
4 18 (0.38%) Oracle RAC
5 17 (0.36%) HDFS
6 15 (0.32%) Apache Flume
7 11 (0.23%) Hyper-V
8 8 (0.17%) Virtual Machines
8 8 (0.17%) VMware ESXi
9 5 (0.11%) Firmware
10 4 (0.085%) GPFS
11 2 (0.043%) KVM
11 2 (0.043%) Microsoft Virtual Server
11 2 (0.043%) Virtual Servers
12 1 (0.021%) Apache ZooKeeper
12 1 (0.021%) Cronacle
12 1 (0.021%) Microsoft App-V
12 1 (0.021%) PowerHA
Systems Management
1 32 (0.68%) Oozie
2 13 (0.28%) Microsoft Clustering
3 12 (0.26%) SCCM
4 11 (0.23%) Control-M
4 11 (0.23%) Failover Clustering
5 9 (0.19%) Terraform
6 8 (0.17%) Ansible
6 8 (0.17%) Mesos
7 7 (0.15%) Systems Management Server (SMS)
8 6 (0.13%) Kibana
8 6 (0.13%) Nagios
8 6 (0.13%) Perfmon
8 6 (0.13%) Puppet
8 6 (0.13%) Tivoli
9 5 (0.11%) Oracle Enterprise Manager
9 5 (0.11%) SCOM
10 4 (0.085%) Hadoop YARN
10 4 (0.085%) Kubernetes
11 3 (0.064%) Data Guard
11 3 (0.064%) Packer
Vendors
1 1435 (30.65%) Microsoft
2 965 (20.61%) Oracle
3 777 (16.60%) Tableau
4 360 (7.69%) SAP
5 273 (5.83%) Cognos
6 205 (4.38%) Informatica
7 166 (3.55%) IBM
8 134 (2.86%) MicroStrategy
9 123 (2.63%) Talend
10 118 (2.52%) Google
11 113 (2.41%) Teradata
12 73 (1.56%) TIBCO
13 58 (1.24%) Alteryx
14 55 (1.17%) Salesforce.com
15 53 (1.13%) Netezza
16 49 (1.05%) RedGate
17 44 (0.94%) GoldenSource
18 43 (0.92%) Cloudera
18 43 (0.92%) Hyperion
18 43 (0.92%) VMware