Period
to 23 September 2018

The following table provides summary statistics for permanent job vacancies advertised in London 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 23 September 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > London
6 months to
23 Sep 2018
Same period 2017 Same period 2016
Rank 88 99 83
Rank change year-on-year +11 -16 -8
Permanent jobs citing Data Warehouse 2,420 2,454 2,872
As % of all permanent IT jobs advertised in London 3.56% 3.29% 3.64%
As % of the Database & Business Intelligence category 11.44% 11.18% 12.29%
Number of salaries quoted 2,006 1,799 2,509
London median annual salary £60,000 £60,000 £60,000
10th Percentile £40,000 £40,000 £41,000
90th Percentile £88,125 £87,500 £87,500
England median annual salary £55,000 £50,000 £55,000
% change year-on-year +10.00% -9.09% +10.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 London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 21,153 21,950 23,368
As % of all permanent IT jobs advertised in London 31.12% 29.46% 29.61%
Number of salaries quoted 16,801 17,643 20,351
London median annual salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.17% +4.35% +4.55%
10th Percentile £37,500 £36,250 £35,000
90th Percentile £93,750 £90,000 £87,500
England median annual salary £50,000 £49,000 £47,500
% change year-on-year +2.04% +3.16% +5.56%

Data Warehouse
Job Vacancy Trend in London

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in London.

Job vacancy trend for Data Warehouse in London

Data Warehouse
Salary Trend in London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Warehouse in London.

Salary trend for Data Warehouse in London

Data Warehouse
Salary Histogram in London

The salary distribution of IT jobs citing Data Warehouse in London over the 6 months to 23 September 2018.

Salary histogram for Data Warehouse in London

Data Warehouse
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the London region over the 6 months to 23 September 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
Central London +1 542 £65,000 +8.33% 97
West London +79 135 £55,000 +15.79% 41
South London +47 89 £51,000 +27.50% 11
East London +17 41 £60,000 +26.32% 12
North London +8 2 £55,000 -5.98% 3
Data Warehouse
England

For the 6 months to 23 September 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 London region with a requirement for Data Warehouse.

1 1,661 (68.64%) SQL
2 1,491 (61.61%) Business Intelligence
3 1,274 (52.64%) SQL Server
4 1,107 (45.74%) SQL Server Integration Services
5 1,076 (44.46%) ETL
6 872 (36.03%) Microsoft
7 865 (35.74%) SQL Server Reporting Services
8 799 (33.02%) Finance
9 709 (29.30%) SQL Server Analysis Services
10 697 (28.80%) Agile Software Development
11 634 (26.20%) T-SQL
12 627 (25.91%) Analytics
13 562 (23.22%) Power BI
14 471 (19.46%) Big Data
15 451 (18.64%) Microsoft Azure
16 446 (18.43%) Oracle
17 415 (17.15%) Data Modelling
18 401 (16.57%) .NET
19 329 (13.60%) Tableau
20 317 (13.10%) Python
21 304 (12.56%) C#
22 299 (12.36%) Analytical Skills
23 284 (11.74%) Visualisation
24 274 (11.32%) Data Management
24 274 (11.32%) Data Quality
25 266 (10.99%) Kimball Methodology
26 263 (10.87%) Degree
27 261 (10.79%) Hadoop
28 254 (10.50%) Amazon AWS
29 233 (9.63%) Relational Database

Data Warehouse
Co-occurring IT Skills in London 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 139 (5.74%) Apache Spark
2 114 (4.71%) SAS
3 79 (3.26%) Apache
4 60 (2.48%) IIS
5 57 (2.36%) SharePoint
6 25 (1.03%) Apache Pig
7 22 (0.91%) Elasticsearch
8 19 (0.79%) Oracle SOA Suite
9 18 (0.74%) Confluence
10 15 (0.62%) CMS
11 12 (0.50%) Apache Solr
12 10 (0.41%) Hyperledger
13 9 (0.37%) Apache Airflow
14 7 (0.29%) WebLogic
15 4 (0.17%) WebLogic Portal
16 3 (0.12%) MS Exchange
16 3 (0.12%) Oracle Workflow
17 2 (0.083%) IBM HTTP Server
17 2 (0.083%) SharePoint 2010
17 2 (0.083%) Sitecore CMS
Applications
1 169 (6.98%) Microsoft Excel
2 54 (2.23%) Microsoft Office
3 36 (1.49%) MS Visio
4 26 (1.07%) Microsoft PowerPoint
5 7 (0.29%) SPSS
6 4 (0.17%) Microsoft Project
7 3 (0.12%) Stata
8 2 (0.083%) CPLEX
8 2 (0.083%) Spreadsheet
9 1 (0.041%) EViews
Business Applications
1 28 (1.16%) Markit EDM
2 25 (1.03%) Dynamics CRM
3 17 (0.70%) NetSuite
4 15 (0.62%) Dynamics AX
5 13 (0.54%) Dynamics NAV
6 12 (0.50%) Cognos TM1
7 11 (0.45%) Oracle EBS
8 8 (0.33%) FastStats
9 7 (0.29%) Cognos Business Intelligence
9 7 (0.29%) Remedy ITSM
10 6 (0.25%) Oracle Retail
11 5 (0.21%) MetaTrader
12 4 (0.17%) Salesforce.com CRM
13 2 (0.083%) Eloqua
13 2 (0.083%) SAP BPC
13 2 (0.083%) SAP ERP
13 2 (0.083%) SAP MDG
13 2 (0.083%) SAP S/4HANA
13 2 (0.083%) Temenos T24
13 2 (0.083%) thinkFolio
Cloud Services
1 451 (18.64%) Microsoft Azure
2 254 (10.50%) Amazon AWS
3 96 (3.97%) Azure Data Factory
4 71 (2.93%) PaaS
5 45 (1.86%) Serverless
6 41 (1.69%) Google Cloud Platform
7 40 (1.65%) Data Lake Analytics
8 39 (1.61%) SaaS
9 37 (1.53%) Cloud Computing
10 28 (1.16%) IaaS
11 27 (1.12%) Cortana Intelligence Suite
12 24 (0.99%) AWS Lambda
13 22 (0.91%) Amazon EC2
13 22 (0.91%) Amazon S3
14 14 (0.58%) Azure Machine Learning
14 14 (0.58%) Office 365
15 13 (0.54%) Azure Functions
16 11 (0.45%) Amazon EMR
16 11 (0.45%) Google Analytics
17 9 (0.37%) GitHub
Communications & Networking
1 21 (0.87%) Internet
2 13 (0.54%) SAN
3 10 (0.41%) SSL
4 9 (0.37%) LAN
4 9 (0.37%) WAN
5 8 (0.33%) Firewall
6 6 (0.25%) DNS
7 5 (0.21%) SSH
8 4 (0.17%) HTTP
8 4 (0.17%) HTTPS
8 4 (0.17%) TCP/IP
8 4 (0.17%) VoIP
9 3 (0.12%) NAS
9 3 (0.12%) PABX
9 3 (0.12%) VPN
10 2 (0.083%) DHCP
10 2 (0.083%) Intranet
10 2 (0.083%) SMS
10 2 (0.083%) Wi-Fi
11 1 (0.041%) SMTP
Database & Business Intelligence
1 1,274 (52.64%) SQL Server
2 1,107 (45.74%) SQL Server Integration Services
3 865 (35.74%) SQL Server Reporting Services
4 709 (29.30%) SQL Server Analysis Services
5 562 (23.22%) Power BI
6 471 (19.46%) Big Data
7 261 (10.79%) Hadoop
8 233 (9.63%) Relational Database
9 217 (8.97%) Data Lake
10 177 (7.31%) BusinessObjects
11 170 (7.02%) SQL Server 2012
11 170 (7.02%) SQL Server 2016
12 168 (6.94%) OLAP
13 150 (6.20%) SQL Server 2008
14 140 (5.79%) SQL Server 2014
15 138 (5.70%) Azure SQL Data Warehouse
15 138 (5.70%) NoSQL
16 137 (5.66%) Microsoft Analysis Services
17 117 (4.83%) QlikView
18 113 (4.67%) Azure SQL Database
Development Applications
1 153 (6.32%) Team Foundation Server
2 120 (4.96%) Visual Studio
3 68 (2.81%) Git (software)
4 54 (2.23%) Jenkins
5 51 (2.11%) JIRA
6 42 (1.74%) Octopus Deploy
7 40 (1.65%) SQL Server Management Studio (SSMS)
8 34 (1.40%) Visual Studio Team System
9 28 (1.16%) Oracle APEX
10 25 (1.03%) TeamCity
11 20 (0.83%) Eclipse
12 16 (0.66%) Selenium
13 14 (0.58%) ER Studio
13 14 (0.58%) Toad
14 13 (0.54%) Subversion
15 12 (0.50%) tSQLt
16 11 (0.45%) Cucumber
17 10 (0.41%) ERwin
18 9 (0.37%) Bitbucket
19 8 (0.33%) Mocha
General
1 799 (33.02%) Finance
2 224 (9.26%) Banking
3 153 (6.32%) Retail
4 126 (5.21%) Marketing
5 114 (4.71%) Advertising
6 67 (2.77%) Investment Banking
7 45 (1.86%) Games
8 32 (1.32%) Back Office
9 29 (1.20%) Corporate Banking
10 28 (1.16%) Publishing
11 27 (1.12%) Legal
12 22 (0.91%) Front Office
13 19 (0.79%) General Ledger
14 17 (0.70%) Telecoms
15 16 (0.66%) Financial Institution
15 16 (0.66%) Law
16 15 (0.62%) Pharmaceutical
17 12 (0.50%) Music Industry
18 11 (0.45%) Local Government
19 9 (0.37%) Manufacturing
Job Titles
1 1,032 (42.64%) Developer
2 484 (20.00%) Business Intelligence Developer
3 436 (18.02%) SQL Developer
4 378 (15.62%) Analyst
5 282 (11.65%) Architect
6 245 (10.12%) SSIS Developer
7 204 (8.43%) SQL BI Developer
8 200 (8.26%) Data Warehouse Developer
9 187 (7.73%) SSRS Developer
10 176 (7.27%) Consultant
11 175 (7.23%) SQL Server Developer
12 171 (7.07%) Data Architect
13 169 (6.98%) Data Engineer
14 147 (6.07%) SSAS Developer
15 134 (5.54%) Data Analyst
16 127 (5.25%) Senior Developer
17 119 (4.92%) ETL Developer
18 118 (4.88%) Business Intelligence Analyst
19 102 (4.21%) SQL Server BI Developer
20 91 (3.76%) Business Analyst
Libraries, Frameworks & Software Standards
1 401 (16.57%) .NET
2 203 (8.39%) Web Services
3 142 (5.87%) XML
4 129 (5.33%) Kafka
5 123 (5.08%) MDX
6 112 (4.63%) .NET Framework
7 106 (4.38%) HTML
8 79 (3.26%) Entity Framework
9 69 (2.85%) JSON
10 47 (1.94%) ASP.NET
10 47 (1.94%) CSS
11 37 (1.53%) Middleware
12 34 (1.40%) REST
13 32 (1.32%) AngularJS
14 29 (1.20%) SOAP
15 25 (1.03%) JSP
15 25 (1.03%) RESTful
16 24 (0.99%) React
17 23 (0.95%) Spark Streaming
18 22 (0.91%) ASP.NET MVC
Miscellaneous
1 299 (12.36%) Analytical Skills
2 117 (4.83%) Computer Science
3 113 (4.67%) Greenfield Project
4 103 (4.26%) Data Structures
5 84 (3.47%) Algorithms
5 84 (3.47%) Replication
6 82 (3.39%) Management Information System
7 57 (2.36%) Fintech
8 52 (2.15%) Credit Risk
8 52 (2.15%) Equities
9 45 (1.86%) User Experience
10 44 (1.82%) Reinsurance
11 39 (1.61%) Hedge funds
12 38 (1.57%) Reference Data
13 35 (1.45%) Derivative
13 35 (1.45%) Self-Motivation
14 34 (1.40%) Foreign Exchange (FX)
15 33 (1.36%) Market Risk
15 33 (1.36%) NHS
16 28 (1.16%) Enterprise Software
Operating Systems
1 136 (5.62%) Unix
2 129 (5.33%) Windows
3 120 (4.96%) Linux
4 42 (1.74%) Solaris
5 34 (1.40%) HPUX
6 32 (1.32%) AIX
7 28 (1.16%) Windows Server
8 19 (0.79%) Red Hat Enterprise Linux
9 15 (0.62%) Windows Server 2008
10 8 (0.33%) Windows Server 2012
11 7 (0.29%) Apple iOS
12 3 (0.12%) CentOS
12 3 (0.12%) zOS
13 2 (0.083%) Mac OS X
14 1 (0.041%) Android
14 1 (0.041%) Oracle Linux
14 1 (0.041%) VMS
Processes & Methodologies
1 1,491 (61.61%) Business Intelligence
2 1,076 (44.46%) ETL
3 697 (28.80%) Agile Software Development
4 627 (25.91%) Analytics
5 415 (17.15%) Data Modelling
6 284 (11.74%) Visualisation
7 274 (11.32%) Data Management
8 266 (10.99%) Kimball Methodology
9 231 (9.55%) Scrum
10 224 (9.26%) Data Integration
10 224 (9.26%) Problem-Solving
11 218 (9.01%) Data Analysis
12 204 (8.43%) Performance Tuning
13 198 (8.18%) Data Architecture
14 196 (8.10%) SDLC
15 192 (7.93%) Migration
16 180 (7.44%) Data Science
17 177 (7.31%) Data Analytics
17 177 (7.31%) Machine Learning
18 158 (6.53%) Project Management
Programming Languages
1 1,661 (68.64%) SQL
2 634 (26.20%) T-SQL
3 317 (13.10%) Python
4 304 (12.56%) C#
5 209 (8.64%) Java
6 163 (6.74%) PL/SQL
7 125 (5.17%) JavaScript
8 116 (4.79%) R
9 109 (4.50%) PowerShell
10 108 (4.46%) Data Analysis Expressions (DAX)
11 74 (3.06%) Scala
12 59 (2.44%) VBA
13 47 (1.94%) Shell Script
14 38 (1.57%) Perl
15 31 (1.28%) VB.NET
16 29 (1.20%) PHP
16 29 (1.20%) VB
17 25 (1.03%) U-SQL
18 16 (0.66%) C
18 16 (0.66%) Go
Qualifications
1 263 (10.87%) Degree
2 69 (2.85%) Microsoft Certification
3 60 (2.48%) Computer Science Degree
4 32 (1.32%) ISEB
5 26 (1.07%) Security Cleared
6 22 (0.91%) Master's Degree
7 20 (0.83%) MCITP
8 17 (0.70%) PMP
9 14 (0.58%) ITIL Certification
9 14 (0.58%) MCSE
9 14 (0.58%) PMI Certification
10 13 (0.54%) SC Cleared
11 12 (0.50%) MCSA
11 12 (0.50%) Microsoft Certified Architect
12 11 (0.45%) ACCA
12 11 (0.45%) PRINCE2 Certification
13 10 (0.41%) TOGAF Certification
14 9 (0.37%) Numerate Degree
15 7 (0.29%) VMware Certified Professional (VCP)
16 6 (0.25%) PhD
Quality Assurance & Compliance
1 274 (11.32%) Data Quality
2 116 (4.79%) QA
3 46 (1.90%) GDPR
4 15 (0.62%) PMO
5 10 (0.41%) MiFID
5 10 (0.41%) Solvency II
6 8 (0.33%) SLA
7 5 (0.21%) IFRS
8 4 (0.17%) IFRS 9
8 4 (0.17%) PCI DSS
9 3 (0.12%) GAAP
10 2 (0.083%) ISO/IEC 27001
10 2 (0.083%) PSD2
10 2 (0.083%) Sarbanes-Oxley
11 1 (0.041%) Basel III
11 1 (0.041%) CRD IV
11 1 (0.041%) EMIR
System Software
1 43 (1.78%) Docker
2 35 (1.45%) HDFS
3 25 (1.03%) Apache Flume
4 17 (0.70%) Active Directory
5 10 (0.41%) Oracle RAC
6 8 (0.33%) Apache ZooKeeper
6 8 (0.33%) vSphere
7 7 (0.29%) VMware Infrastructure
8 4 (0.17%) Virtual Machines
9 2 (0.083%) Hyper-V
10 1 (0.041%) Terminal Services
10 1 (0.041%) VMware ESXi
Systems Management
1 31 (1.28%) Automic
2 21 (0.87%) Kubernetes
3 18 (0.74%) Dollar Universe
4 17 (0.70%) Mesos
4 17 (0.70%) Opscode Chef
4 17 (0.70%) Terraform
5 16 (0.66%) Oracle Enterprise Manager
5 16 (0.66%) Oracle RMAN
5 16 (0.66%) Puppet
6 15 (0.62%) Oozie
7 14 (0.58%) Control-M
8 13 (0.54%) Hadoop YARN
9 10 (0.41%) Kibana
10 7 (0.29%) Oracle ZFS
11 6 (0.25%) Ambari
12 5 (0.21%) Ansible
12 5 (0.21%) Failover Clustering
12 5 (0.21%) NetBackup
12 5 (0.21%) Unicenter
13 4 (0.17%) Docker Swarm
Vendors
1 872 (36.03%) Microsoft
2 446 (18.43%) Oracle
3 329 (13.60%) Tableau
4 137 (5.66%) Informatica
5 127 (5.25%) SAP
6 107 (4.42%) Cognos
7 69 (2.85%) Google
7 69 (2.85%) IBM
8 60 (2.48%) Talend
9 55 (2.27%) MicroStrategy
10 40 (1.65%) Salesforce.com
11 39 (1.61%) Teradata
12 37 (1.53%) Cloudera
13 25 (1.03%) Red Hat
14 24 (0.99%) Databricks
14 24 (0.99%) VMware
15 22 (0.91%) RedGate
16 21 (0.87%) MapR
17 20 (0.83%) Sybase
17 20 (0.83%) Vertica