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

Data Warehousing
UK > England
6 months to
21 Oct 2018
Same period 2017 Same period 2016
Rank 108 117 104
Rank change year-on-year +9 -13 -20
Permanent jobs citing Data Warehouse 4,413 4,620 5,159
As % of all permanent IT jobs advertised in England 2.90% 2.83% 2.86%
As % of the Database & Business Intelligence category 9.82% 9.32% 9.67%
Number of salaries quoted 3,625 3,684 4,436
England median annual salary £55,000 £51,277 £55,000
Median salary % change year-on-year +7.26% -6.77% +10.00%
10th Percentile £35,000 £33,000 £33,750
90th Percentile £85,000 £78,750 £82,500
UK median annual salary £52,750 £50,000 £54,000
% change year-on-year +5.50% -7.41% +8.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 44,954 49,589 53,349
As % of all permanent IT jobs advertised in England 29.49% 30.34% 29.59%
Number of salaries quoted 36,843 41,131 45,940
England median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £83,750 £77,500 £76,750
UK median annual salary £50,000 £48,000 £47,500
% change year-on-year +4.17% +1.05% +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 21 October 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 21 October 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 +7 2,361 £60,000 - 273
South East +32 632 £52,500 +5.00% 78
North of England -20 584 £45,000 +5.88% 129
Midlands -15 329 £45,000 - 52
North West -22 321 £45,000 +12.50% 62
East of England +70 274 £50,000 - 43
Yorkshire -30 223 £47,500 +5.56% 50
South West -15 214 £45,000 +5.88% 55
East Midlands +24 171 £43,500 -3.33% 25
West Midlands -28 157 £45,000 - 27
North East +34 56 £55,000 +37.50% 17
Data Warehouse
UK

For the 6 months to 21 October 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,957 (67.01%) SQL
2 2,803 (63.52%) Business Intelligence
3 2,229 (50.51%) SQL Server
4 1,996 (45.23%) SQL Server Integration Services
5 1,927 (43.67%) ETL
6 1,643 (37.23%) Microsoft
7 1,614 (36.57%) SQL Server Reporting Services
8 1,376 (31.18%) Agile Software Development
9 1,264 (28.64%) Finance
10 1,256 (28.46%) SQL Server Analysis Services
11 1,173 (26.58%) T-SQL
12 1,134 (25.70%) Analytics
13 1,047 (23.73%) Power BI
14 874 (19.81%) Data Modelling
15 793 (17.97%) Microsoft Azure
16 733 (16.61%) Oracle
17 715 (16.20%) Big Data
18 653 (14.80%) Tableau
19 635 (14.39%) Analytical Skills
20 557 (12.62%) .NET
21 549 (12.44%) Visualisation
22 516 (11.69%) C#
23 482 (10.92%) Python
24 475 (10.76%) Degree
25 460 (10.42%) Relational Database
26 452 (10.24%) Data Analysis
27 439 (9.95%) Amazon AWS
28 435 (9.86%) Data Quality
29 424 (9.61%) Problem-Solving
30 418 (9.47%) Data Management

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 238 (5.39%) Apache Spark
2 156 (3.54%) SAS
3 130 (2.95%) SharePoint
4 86 (1.95%) Apache
5 63 (1.43%) IIS
6 43 (0.97%) Oracle SOA Suite
7 37 (0.84%) Elasticsearch
8 36 (0.82%) BizTalk Server
9 34 (0.77%) Apache Pig
10 31 (0.70%) Confluence
11 26 (0.59%) CMS
12 21 (0.48%) Apache Solr
13 14 (0.32%) Hyperledger
14 13 (0.29%) Skype for Business
15 12 (0.27%) Apache Airflow
15 12 (0.27%) MS Exchange
16 11 (0.25%) WebLogic
17 10 (0.23%) JBoss
18 8 (0.18%) nginx
18 8 (0.18%) Oracle Application Server
Applications
1 384 (8.70%) Microsoft Excel
2 99 (2.24%) Microsoft Office
3 44 (1.00%) MS Visio
4 35 (0.79%) Microsoft PowerPoint
5 16 (0.36%) SPSS
6 11 (0.25%) Microsoft Project
7 7 (0.16%) Spreadsheet
8 3 (0.068%) Stata
9 2 (0.045%) Adobe Illustrator
9 2 (0.045%) InfoPath
9 2 (0.045%) Photoshop
10 1 (0.023%) Adobe After Effects
10 1 (0.023%) Chatbot
10 1 (0.023%) CPLEX
10 1 (0.023%) EViews
Business Applications
1 60 (1.36%) Cognos TM1
1 60 (1.36%) Dynamics CRM
2 56 (1.27%) Cognos Business Intelligence
3 37 (0.84%) Dynamics AX
4 21 (0.48%) Dynamics NAV
5 19 (0.43%) Oracle EBS
6 18 (0.41%) Markit EDM
7 15 (0.34%) NetSuite
8 13 (0.29%) SAP BPC
8 13 (0.29%) SAP CO
8 13 (0.29%) SAP FI
8 13 (0.29%) SAP FI/CO
9 12 (0.27%) SAP S/4HANA
10 9 (0.20%) FastStats
11 8 (0.18%) Remedy ITSM
11 8 (0.18%) SAP MDM
12 7 (0.16%) Oracle Payables
12 7 (0.16%) Oracle Subledger Accounting
12 7 (0.16%) SAP Bank Analyzer
12 7 (0.16%) SAP FS
Cloud Services
1 793 (17.97%) Microsoft Azure
2 439 (9.95%) Amazon AWS
3 164 (3.72%) Azure Data Factory
4 119 (2.70%) PaaS
5 105 (2.38%) Google Cloud Platform
6 67 (1.52%) SaaS
7 63 (1.43%) Serverless
8 61 (1.38%) Cloud Computing
9 56 (1.27%) IaaS
10 54 (1.22%) Office 365
11 51 (1.16%) Data Lake Analytics
12 36 (0.82%) Amazon S3
13 31 (0.70%) Cortana Intelligence Suite
14 29 (0.66%) Azure Functions
15 28 (0.63%) Amazon EC2
15 28 (0.63%) Azure Machine Learning
16 26 (0.59%) Dynamics 365
17 25 (0.57%) Amazon Kinesis
18 23 (0.52%) GitHub
19 22 (0.50%) AWS Lambda
Communications & Networking
1 63 (1.43%) Internet
2 33 (0.75%) SAN
3 24 (0.54%) WAN
4 22 (0.50%) DNS
5 20 (0.45%) Firewall
5 20 (0.45%) LAN
6 19 (0.43%) HTTP
7 12 (0.27%) DHCP
8 11 (0.25%) Network Security
8 11 (0.25%) VoIP
9 10 (0.23%) SMS
9 10 (0.23%) SSL
10 9 (0.20%) FTP
11 8 (0.18%) TCP/IP
12 7 (0.16%) Intranet
13 6 (0.14%) SSH
14 5 (0.11%) BGP
14 5 (0.11%) MPLS
14 5 (0.11%) OSPF
14 5 (0.11%) VLAN
Database & Business Intelligence
1 2,229 (50.51%) SQL Server
2 1,996 (45.23%) SQL Server Integration Services
3 1,614 (36.57%) SQL Server Reporting Services
4 1,256 (28.46%) SQL Server Analysis Services
5 1,047 (23.73%) Power BI
6 715 (16.20%) Big Data
7 460 (10.42%) Relational Database
8 415 (9.40%) Hadoop
9 373 (8.45%) Data Lake
10 345 (7.82%) BusinessObjects
11 297 (6.73%) OLAP
12 287 (6.50%) SQL Server 2012
13 273 (6.19%) SQL Server 2008
14 254 (5.76%) NoSQL
15 247 (5.60%) SQL Server 2016
16 243 (5.51%) QlikView
17 222 (5.03%) Microsoft Analysis Services
18 204 (4.62%) Azure SQL Data Warehouse
19 193 (4.37%) SQL Server 2014
20 184 (4.17%) MySQL
Development Applications
1 213 (4.83%) Team Foundation Server
2 182 (4.12%) Visual Studio
3 147 (3.33%) Git (software)
4 110 (2.49%) Jenkins
5 97 (2.20%) JIRA
6 89 (2.02%) SQL Server Management Studio (SSMS)
7 61 (1.38%) TeamCity
8 58 (1.31%) Visual Studio Team System
9 54 (1.22%) Octopus Deploy
10 52 (1.18%) ERwin
11 40 (0.91%) Oracle APEX
12 31 (0.70%) SoapUI
13 29 (0.66%) Eclipse
14 28 (0.63%) Subversion
15 25 (0.57%) Selenium
15 25 (0.57%) Toad
16 22 (0.50%) Bitbucket
17 18 (0.41%) Atlassian Bamboo
18 16 (0.36%) SpecFlow
19 15 (0.34%) Cucumber
General
1 1,264 (28.64%) Finance
2 335 (7.59%) Retail
3 300 (6.80%) Banking
4 219 (4.96%) Marketing
5 180 (4.08%) Advertising
6 72 (1.63%) Investment Banking
7 67 (1.52%) Legal
8 62 (1.40%) Games
9 41 (0.93%) Manufacturing
10 37 (0.84%) Telecoms
11 36 (0.82%) Publishing
12 29 (0.66%) Corporate Banking
13 28 (0.63%) Back Office
14 26 (0.59%) General Ledger
14 26 (0.59%) Law
15 20 (0.45%) Front Office
16 19 (0.43%) Automotive
16 19 (0.43%) Pharmaceutical
17 14 (0.32%) Electronics
18 11 (0.25%) Local Government
Job Titles
1 1,808 (40.97%) Developer
2 860 (19.49%) Business Intelligence Developer
3 744 (16.86%) Analyst
4 685 (15.52%) SQL Developer
5 579 (13.12%) Architect
6 370 (8.38%) Data Architect
7 335 (7.59%) Data Warehouse Developer
8 327 (7.41%) SSIS Developer
9 285 (6.46%) SQL BI Developer
10 267 (6.05%) Business Intelligence Analyst
11 243 (5.51%) Consultant
12 238 (5.39%) Data Analyst
13 234 (5.30%) SQL Server Developer
14 232 (5.26%) Data Engineer
14 232 (5.26%) Senior Developer
15 230 (5.21%) SSRS Developer
16 213 (4.83%) DBA
17 186 (4.21%) ETL Developer
18 174 (3.94%) SSAS Developer
19 173 (3.92%) Business Developer
Libraries, Frameworks & Software Standards
1 557 (12.62%) .NET
2 340 (7.70%) Web Services
3 234 (5.30%) XML
4 198 (4.49%) MDX
5 196 (4.44%) Kafka
6 178 (4.03%) HTML
7 141 (3.20%) JSON
8 122 (2.76%) .NET Framework
9 104 (2.36%) Middleware
10 100 (2.27%) CSS
11 98 (2.22%) REST
12 92 (2.08%) ASP.NET
13 84 (1.90%) Entity Framework
14 78 (1.77%) SOAP
15 66 (1.50%) AngularJS
16 54 (1.22%) RESTful
17 40 (0.91%) React
18 38 (0.86%) ASP.NET MVC
19 37 (0.84%) WCF
20 35 (0.79%) jQuery
Miscellaneous
1 635 (14.39%) Analytical Skills
2 202 (4.58%) Greenfield Project
3 198 (4.49%) Computer Science
4 184 (4.17%) Management Information System
5 170 (3.85%) Data Structures
6 133 (3.01%) Replication
7 102 (2.31%) NHS
8 91 (2.06%) User Experience
9 82 (1.86%) Algorithms
10 69 (1.56%) Fintech
11 67 (1.52%) Self-Motivation
12 64 (1.45%) Reinsurance
13 62 (1.40%) Clustering
14 58 (1.31%) Enterprise Software
14 58 (1.31%) Reference Data
15 45 (1.02%) Equities
16 44 (1.00%) Credit Risk
17 34 (0.77%) Hedge funds
18 30 (0.68%) Foreign Exchange (FX)
19 29 (0.66%) Derivative
Operating Systems
1 252 (5.71%) Linux
2 250 (5.67%) Windows
3 224 (5.08%) Unix
4 84 (1.90%) Windows Server
5 46 (1.04%) Red Hat Enterprise Linux
6 39 (0.88%) AIX
7 37 (0.84%) Solaris
8 26 (0.59%) Windows Server 2008
9 25 (0.57%) Windows Server 2012
10 24 (0.54%) HPUX
11 14 (0.32%) Apple iOS
12 10 (0.23%) CentOS
13 7 (0.16%) Ubuntu
14 4 (0.091%) Kali Linux
15 3 (0.068%) Android
15 3 (0.068%) Windows 7
15 3 (0.068%) zOS
16 2 (0.045%) Mac OS X
16 2 (0.045%) VMS
16 2 (0.045%) Windows XP
Processes & Methodologies
1 2,803 (63.52%) Business Intelligence
2 1,927 (43.67%) ETL
3 1,376 (31.18%) Agile Software Development
4 1,134 (25.70%) Analytics
5 874 (19.81%) Data Modelling
6 549 (12.44%) Visualisation
7 452 (10.24%) Data Analysis
8 424 (9.61%) Problem-Solving
9 418 (9.47%) Data Management
10 408 (9.25%) Data Integration
11 400 (9.06%) Scrum
12 376 (8.52%) Migration
13 375 (8.50%) Kimball Methodology
14 347 (7.86%) Performance Tuning
15 344 (7.80%) Data Architecture
16 315 (7.14%) SDLC
17 308 (6.98%) Data Analytics
18 307 (6.96%) Dimensional Modelling
19 306 (6.93%) Project Management
20 284 (6.44%) Data Science
Programming Languages
1 2,957 (67.01%) SQL
2 1,173 (26.58%) T-SQL
3 516 (11.69%) C#
4 482 (10.92%) Python
5 343 (7.77%) Java
6 304 (6.89%) PL/SQL
7 232 (5.26%) JavaScript
8 201 (4.55%) PowerShell
9 151 (3.42%) R
10 138 (3.13%) Data Analysis Expressions (DAX)
11 128 (2.90%) VBA
12 110 (2.49%) Scala
13 104 (2.36%) Shell Script
14 63 (1.43%) PHP
15 61 (1.38%) Go
16 60 (1.36%) VB
17 54 (1.22%) VB.NET
18 36 (0.82%) Perl
19 35 (0.79%) U-SQL
20 34 (0.77%) C
Qualifications
1 475 (10.76%) Degree
2 88 (1.99%) Microsoft Certification
3 86 (1.95%) Computer Science Degree
4 71 (1.61%) Security Cleared
5 51 (1.16%) ISEB
6 39 (0.88%) SC Cleared
7 38 (0.86%) Master's Degree
8 27 (0.61%) MCSE
9 25 (0.57%) MCITP
10 23 (0.52%) PMP
11 22 (0.50%) ITIL Certification
11 22 (0.50%) MCSA
12 20 (0.45%) PMI Certification
13 17 (0.39%) ITIL Foundation Certificate
13 17 (0.39%) VMware Certified Professional (VCP)
14 16 (0.36%) TOGAF Certification
15 15 (0.34%) PRINCE2 Certification
16 14 (0.32%) Postgraduate
17 11 (0.25%) ACCA
18 10 (0.23%) Numerate Degree
Quality Assurance & Compliance
1 435 (9.86%) Data Quality
2 217 (4.92%) QA
3 97 (2.20%) GDPR
4 69 (1.56%) PMO
5 29 (0.66%) SLA
6 16 (0.36%) ISO/IEC 27001
7 14 (0.32%) IFRS
8 11 (0.25%) Solvency II
9 10 (0.23%) Sarbanes-Oxley
10 8 (0.18%) MiFID
11 7 (0.16%) PCI DSS
12 6 (0.14%) IFRS 9
13 2 (0.045%) GAAP
13 2 (0.045%) ISO 9001
13 2 (0.045%) ISO/IEC 20000
13 2 (0.045%) P3O
13 2 (0.045%) PSD2
13 2 (0.045%) TickIT
13 2 (0.045%) Web Application Security Consortium
14 1 (0.023%) EMIR
System Software
1 59 (1.34%) Apache Flume
2 58 (1.31%) Docker
3 54 (1.22%) Active Directory
3 54 (1.22%) HDFS
4 31 (0.70%) VMware Infrastructure
5 18 (0.41%) vSphere
6 17 (0.39%) Hyper-V
7 14 (0.32%) Oracle RAC
8 11 (0.25%) Virtual Machines
9 10 (0.23%) Veritas Cluster Server
10 9 (0.20%) Apache ZooKeeper
11 5 (0.11%) VMware Workstation
12 3 (0.068%) GPFS
12 3 (0.068%) Varnish
13 1 (0.023%) Microsoft App-V
13 1 (0.023%) Terminal Services
13 1 (0.023%) VMware ESXi
Systems Management
1 41 (0.93%) Opscode Chef
2 39 (0.88%) Puppet
3 34 (0.77%) Hadoop YARN
3 34 (0.77%) Kubernetes
4 33 (0.75%) Automic
5 32 (0.73%) Terraform
6 26 (0.59%) Ansible
7 25 (0.57%) Oozie
8 23 (0.52%) Oracle Enterprise Manager
9 21 (0.48%) Oracle RMAN
10 20 (0.45%) Control-M
11 19 (0.43%) Mesos
12 15 (0.34%) Dollar Universe
13 14 (0.32%) Data Guard
13 14 (0.32%) Kibana
14 13 (0.29%) Systems Management Server (SMS)
15 11 (0.25%) Tivoli
16 10 (0.23%) Tivoli Storage Manager
17 9 (0.20%) Backup Exec
18 8 (0.18%) Rundeck
Vendors
1 1,643 (37.23%) Microsoft
2 733 (16.61%) Oracle
3 653 (14.80%) Tableau
4 286 (6.48%) Informatica
5 251 (5.69%) SAP
6 220 (4.99%) Cognos
7 157 (3.56%) Google
8 152 (3.44%) IBM
9 129 (2.92%) Talend
10 95 (2.15%) Teradata
11 88 (1.99%) Cloudera
12 72 (1.63%) VMware
13 66 (1.50%) MicroStrategy
14 59 (1.34%) Hortonworks
15 50 (1.13%) Salesforce.com
16 49 (1.11%) Red Hat
17 47 (1.07%) Ab Initio
18 46 (1.04%) Alteryx
19 45 (1.02%) MapR
20 44 (1.00%) Netezza