Period
to 18 November 2017

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

Data Warehousing
England > London
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 101 85 75
Rank change year-on-year -16 -10 -8
Permanent jobs citing Data Warehouse 2426 2684 3434
As % of all permanent IT jobs advertised in London 3.23% 3.53% 3.85%
As % of the Database & Business Intelligence category 10.99% 12.01% 12.56%
Number of salaries quoted 1751 2396 2857
London median annual salary £60,000 £60,000 £60,000
10th Percentile £40,000 £40,000 £40,000
90th Percentile £87,500 £87,500 £87,500
England median annual salary £52,500 £55,000 £50,000
% change year-on-year -4.55% +10.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 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 22080 22349 27350
As % of all permanent IT jobs advertised in London 29.43% 29.42% 30.64%
Number of salaries quoted 17685 19438 23124
London median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% +4.76%
10th Percentile £36,250 £35,000 £35,000
90th Percentile £88,750 £87,500 £85,000
England median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +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 18 November 2017.

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 18 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
Central London -10 475 £60,000 -4.00% 24
West London -20 87 £52,500 +5.00% 5
South London +9 42 £40,000 -30.43% 1
East London +19 22 £47,500 - 2
North London +5 8 £55,500 -3.48% 3
Data Warehouse
England

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

1 1608 (66.28%) SQL
2 1449 (59.73%) Business Intelligence
3 1073 (44.23%) SQL Server
4 988 (40.73%) ETL
5 970 (39.98%) Finance
6 821 (33.84%) Agile Software Development
7 808 (33.31%) Analytics
8 729 (30.05%) SQL Server Integration Services
9 708 (29.18%) Microsoft
10 610 (25.14%) Data Modelling
11 588 (24.24%) SQL Server Reporting Services
12 576 (23.74%) Oracle
13 542 (22.34%) Big Data
14 495 (20.40%) SQL Server Analysis Services
15 489 (20.16%) T-SQL
16 474 (19.54%) Tableau
17 453 (18.67%) Banking
18 439 (18.10%) Analytical Skills
19 433 (17.85%) Python
20 383 (15.79%) Java
21 381 (15.70%) Asset Management
22 357 (14.72%) Visualisation
23 347 (14.30%) Microsoft Azure
24 343 (14.14%) Power BI
25 341 (14.06%) Wealth Management
26 339 (13.97%) Investment Banking
27 333 (13.73%) Retail Banking
28 315 (12.98%) Data Analytics
29 307 (12.65%) OLAP
30 300 (12.37%) PL/SQL

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 200 (8.24%) Apache Spark
2 84 (3.46%) SAS
3 76 (3.13%) SharePoint
4 54 (2.23%) Tomcat
5 47 (1.94%) JBoss
6 25 (1.03%) Apache
7 18 (0.74%) Apache Airflow
8 17 (0.70%) IIS
9 16 (0.66%) Confluence
10 13 (0.54%) Oracle SOA Suite
11 12 (0.49%) WebSphere
12 11 (0.45%) Apache Solr
13 10 (0.41%) CMS
14 9 (0.37%) Apache Pig
15 7 (0.29%) Elasticsearch
15 7 (0.29%) Sitecore CMS
16 6 (0.25%) BizTalk Server
17 4 (0.16%) Kentico
18 3 (0.12%) MS Exchange
18 3 (0.12%) SharePoint Server
Applications
1 190 (7.83%) Microsoft Excel
2 74 (3.05%) Microsoft PowerPoint
3 41 (1.69%) Microsoft Office
4 18 (0.74%) SPSS
5 10 (0.41%) MS Visio
6 7 (0.29%) Spreadsheet
7 1 (0.041%) Mathematica
7 1 (0.041%) Microsoft Project
7 1 (0.041%) SPSS Modeler
7 1 (0.041%) Stata
7 1 (0.041%) Weka
Business Applications
1 29 (1.20%) Dynamics CRM
2 17 (0.70%) HFM
3 14 (0.58%) Salesforce.com CRM
4 12 (0.49%) Cognos Business Intelligence
4 12 (0.49%) Oracle EBS
5 11 (0.45%) BusinessWorks
5 11 (0.45%) TIBCO BusinessEvents
6 10 (0.41%) Dynamics AX
6 10 (0.41%) Dynamics NAV
6 10 (0.41%) Unit4 Business World
7 9 (0.37%) Hyperion Enterprise
8 8 (0.33%) Eikon
9 6 (0.25%) Markit EDM
10 5 (0.21%) Cognos TM1
10 5 (0.21%) Oracle Financials
10 5 (0.21%) ReMetrica
11 4 (0.16%) Adobe Campaign
11 4 (0.16%) Siebel CRM
12 3 (0.12%) FastStats
12 3 (0.12%) Hyperion Planning
Cloud Services
1 347 (14.30%) Microsoft Azure
2 224 (9.23%) Amazon AWS
3 59 (2.43%) Google Cloud Platform
4 47 (1.94%) Azure Data Factory
5 46 (1.90%) Azure Machine Learning
6 29 (1.20%) PaaS
7 28 (1.15%) Cloud Computing
8 27 (1.11%) SaaS
9 24 (0.99%) Office 365
10 19 (0.78%) Cortana Intelligence Suite
11 16 (0.66%) Google Analytics
12 15 (0.62%) IaaS
13 14 (0.58%) Amazon Kinesis
14 12 (0.49%) Dynamics 365
15 10 (0.41%) Amazon S3
16 8 (0.33%) GitHub
17 7 (0.29%) Amazon EC2
17 7 (0.29%) Amazon EMR
18 6 (0.25%) Salesforce Service Cloud
18 6 (0.25%) Serverless
Communications & Networking
1 49 (2.02%) HTTP
1 49 (2.02%) SSL
2 45 (1.85%) TCP/IP
3 26 (1.07%) Intranet
4 18 (0.74%) Internet
5 7 (0.29%) FTP
5 7 (0.29%) LDAP
6 6 (0.25%) Kerberos
7 2 (0.082%) Firewall
7 2 (0.082%) MPLS
8 1 (0.041%) DHCP
8 1 (0.041%) DNS
8 1 (0.041%) LAN
8 1 (0.041%) Network Security
8 1 (0.041%) SMS
8 1 (0.041%) VLAN
8 1 (0.041%) WAN
Database & Business Intelligence
1 1073 (44.23%) SQL Server
2 729 (30.05%) SQL Server Integration Services
3 588 (24.24%) SQL Server Reporting Services
4 542 (22.34%) Big Data
5 495 (20.40%) SQL Server Analysis Services
6 343 (14.14%) Power BI
7 307 (12.65%) OLAP
8 267 (11.01%) Hadoop
9 255 (10.51%) Relational Database
10 248 (10.22%) QlikView
11 221 (9.11%) BusinessObjects
12 169 (6.97%) Oracle OLAP
13 143 (5.89%) SQL Server 2012
14 135 (5.56%) SQL Server 2016
15 131 (5.40%) SQL Server 2008
16 119 (4.91%) Amazon Redshift
17 117 (4.82%) NoSQL
18 108 (4.45%) Data Lake
19 105 (4.33%) SQL Server 2014
20 103 (4.25%) Microsoft Analysis Services
Development Applications
1 81 (3.34%) JIRA
2 79 (3.26%) Team Foundation Server
3 77 (3.17%) Talend Open Studio
4 66 (2.72%) Maven
5 63 (2.60%) Jenkins
6 62 (2.56%) Visual Studio
7 61 (2.51%) Git (software)
8 58 (2.39%) TeamCity
9 49 (2.02%) JUnit
10 47 (1.94%) Mockito
10 47 (1.94%) Sonatype Nexus
11 36 (1.48%) Selenium
12 32 (1.32%) Subversion
13 31 (1.28%) Atlassian Bamboo
14 27 (1.11%) Eclipse
15 26 (1.07%) Bitbucket
16 19 (0.78%) ERwin
17 18 (0.74%) HP UFT
17 18 (0.74%) Rational Functional Tester
17 18 (0.74%) SQL Server Management Studio (SSMS)
General
1 970 (39.98%) Finance
2 453 (18.67%) Banking
3 339 (13.97%) Investment Banking
4 333 (13.73%) Retail Banking
5 233 (9.60%) Marketing
6 121 (4.99%) Retail
7 111 (4.58%) Publishing
8 77 (3.17%) Advertising
9 62 (2.56%) Telecoms
10 60 (2.47%) Manufacturing
11 57 (2.35%) Games
12 50 (2.06%) Electronics
13 41 (1.69%) Legal
14 31 (1.28%) Law
15 30 (1.24%) Front Office
16 17 (0.70%) Polish Language
17 16 (0.66%) Back Office
17 16 (0.66%) Pharmaceutical
18 14 (0.58%) Financial Institution
19 6 (0.25%) French Language
Job Titles
1 1016 (41.88%) Developer
2 402 (16.57%) Business Intelligence Developer
3 377 (15.54%) Analyst
4 350 (14.43%) SQL Developer
5 272 (11.21%) Architect
6 200 (8.24%) Data Warehouse Developer
7 158 (6.51%) Consultant
8 145 (5.98%) SQL BI Developer
9 142 (5.85%) Data Architect
10 135 (5.56%) Senior Developer
11 130 (5.36%) SSIS Developer
12 129 (5.32%) Business Developer
13 122 (5.03%) SQL Server Developer
14 119 (4.91%) Business Analyst
15 113 (4.66%) Business Intelligence Analyst
16 109 (4.49%) Data Engineer
17 104 (4.29%) ETL Developer
18 101 (4.16%) Oracle Developer
19 97 (4.00%) SSRS Developer
20 91 (3.75%) Business Intelligence Lead
Libraries, Frameworks & Software Standards
1 207 (8.53%) .NET
2 149 (6.14%) Web Services
3 143 (5.89%) MDX
4 118 (4.86%) XML
5 84 (3.46%) JSON
6 74 (3.05%) RESTful
7 72 (2.97%) Kafka
8 67 (2.76%) Spring
9 61 (2.51%) HTML
10 58 (2.39%) ASP.NET
11 55 (2.27%) J2EE
12 51 (2.10%) Middleware
12 51 (2.10%) Oracle GoldenGate
13 48 (1.98%) JDBC
14 47 (1.94%) JMS
14 47 (1.94%) TIBCO EMS
15 40 (1.65%) AngularJS
15 40 (1.65%) CSS
16 36 (1.48%) jQuery
17 26 (1.07%) ASP.NET MVC
Miscellaneous
1 439 (18.10%) Analytical Skills
2 165 (6.80%) Computer Science
3 162 (6.68%) Enterprise Software
4 114 (4.70%) Management Information System
5 109 (4.49%) Data Structures
6 84 (3.46%) User Experience
7 67 (2.76%) Algorithms
8 64 (2.64%) Replication
9 54 (2.23%) Reference Data
10 53 (2.18%) Fintech
11 44 (1.81%) Greenfield Project
12 42 (1.73%) Clustering
13 30 (1.24%) Hedge funds
14 28 (1.15%) Equities
15 26 (1.07%) NHS
16 22 (0.91%) Data Centre
16 22 (0.91%) PMI
17 21 (0.87%) Virtual Team
18 17 (0.70%) Credit Risk
19 14 (0.58%) Reinsurance
Operating Systems
1 216 (8.90%) Unix
2 103 (4.25%) Linux
3 62 (2.56%) Windows
4 24 (0.99%) Windows Server
5 10 (0.41%) Windows Server 2008
5 10 (0.41%) Windows Server 2012
6 8 (0.33%) Android
7 6 (0.25%) AIX
8 2 (0.082%) Oracle Linux
9 1 (0.041%) Ubuntu
9 1 (0.041%) Windows 10
Processes & Methodologies
1 1449 (59.73%) Business Intelligence
2 988 (40.73%) ETL
3 821 (33.84%) Agile Software Development
4 808 (33.31%) Analytics
5 610 (25.14%) Data Modelling
6 381 (15.70%) Asset Management
7 357 (14.72%) Visualisation
8 341 (14.06%) Wealth Management
9 315 (12.98%) Data Analytics
10 276 (11.38%) Data Management
11 250 (10.31%) Kimball Methodology
12 241 (9.93%) Scrum
13 215 (8.86%) Data Visualisation
14 212 (8.74%) Data Integration
15 201 (8.29%) Dimensional Modelling
16 195 (8.04%) SDLC
17 177 (7.30%) Data Architecture
18 169 (6.97%) CRM
19 167 (6.88%) Performance Tuning
20 161 (6.64%) Migration
Programming Languages
1 1608 (66.28%) SQL
2 489 (20.16%) T-SQL
3 433 (17.85%) Python
4 383 (15.79%) Java
5 300 (12.37%) PL/SQL
6 229 (9.44%) C#
7 227 (9.36%) R
8 141 (5.81%) Perl
9 99 (4.08%) Scala
10 98 (4.04%) C++
11 91 (3.75%) JavaScript
12 61 (2.51%) Bash Shell
12 61 (2.51%) Shell Script
13 51 (2.10%) Data Analysis Expressions (DAX)
14 49 (2.02%) PowerShell
15 41 (1.69%) VBA
16 30 (1.24%) VB
17 25 (1.03%) PHP
17 25 (1.03%) VBScript
18 21 (0.87%) VB.NET
Qualifications
1 288 (11.87%) Degree
2 73 (3.01%) Computer Science Degree
3 34 (1.40%) Microsoft Certification
4 27 (1.11%) PMP
5 26 (1.07%) Six Sigma Black Belt
5 26 (1.07%) Six Sigma Green Belt
6 25 (1.03%) Numerate Degree
7 22 (0.91%) PMI Certification
8 19 (0.78%) ISEB
9 16 (0.66%) Master's Degree
10 14 (0.58%) MCSE
11 12 (0.49%) ACCA
11 12 (0.49%) PhD
11 12 (0.49%) Security Cleared
12 10 (0.41%) ITIL Foundation Certificate
13 9 (0.37%) MBA
13 9 (0.37%) MCITP
14 8 (0.33%) CIMA
14 8 (0.33%) SC Cleared
15 6 (0.25%) CTC Cleared
Quality Assurance & Compliance
1 245 (10.10%) Data Quality
2 165 (6.80%) QA
3 29 (1.20%) GDPR
4 15 (0.62%) GCP
5 10 (0.41%) SLA
6 8 (0.33%) PMO
7 5 (0.21%) NEBOSH
8 3 (0.12%) IFRS
8 3 (0.12%) IFRS 9
9 2 (0.082%) Solvency II
10 1 (0.041%) Actionable Recommendations
10 1 (0.041%) COBIT
10 1 (0.041%) GAAP
10 1 (0.041%) MiFID
10 1 (0.041%) UCITS
System Software
1 19 (0.78%) Docker
2 11 (0.45%) Active Directory
3 10 (0.41%) Apache Flume
3 10 (0.41%) HDFS
4 8 (0.33%) Virtual Machines
5 3 (0.12%) Hyper-V
6 2 (0.082%) Microsoft Virtual Server
6 2 (0.082%) Virtual Servers
7 1 (0.041%) Apache ZooKeeper
7 1 (0.041%) Cronacle
7 1 (0.041%) PowerHA
7 1 (0.041%) VMware Infrastructure
Systems Management
1 18 (0.74%) Oozie
2 11 (0.45%) Control-M
3 7 (0.29%) Ansible
4 6 (0.25%) Mesos
4 6 (0.25%) Puppet
4 6 (0.25%) Terraform
5 5 (0.21%) Microsoft Clustering
6 4 (0.16%) Failover Clustering
7 3 (0.12%) Data Guard
7 3 (0.12%) Hadoop YARN
7 3 (0.12%) Nagios
7 3 (0.12%) Oracle Enterprise Manager
7 3 (0.12%) Oracle RMAN
8 2 (0.082%) AirWatch
8 2 (0.082%) HP Quality Center
8 2 (0.082%) Kibana
8 2 (0.082%) Kubernetes
8 2 (0.082%) Opscode Chef
8 2 (0.082%) SCCM
8 2 (0.082%) Tivoli
Vendors
1 708 (29.18%) Microsoft
2 576 (23.74%) Oracle
3 474 (19.54%) Tableau
4 151 (6.22%) SAP
5 132 (5.44%) Informatica
6 92 (3.79%) MicroStrategy
7 84 (3.46%) Cognos
8 77 (3.17%) Talend
9 76 (3.13%) Google
10 75 (3.09%) Teradata
11 71 (2.93%) TIBCO
12 52 (2.14%) Alteryx
13 47 (1.94%) IBM
14 44 (1.81%) GoldenSource
14 44 (1.81%) Salesforce.com
15 33 (1.36%) RedGate
16 32 (1.32%) Hyperion
17 31 (1.28%) Cloudera
18 25 (1.03%) Birst
19 23 (0.95%) Netezza