Period
to 22 November 2017

The following table provides summary statistics for permanent job vacancies advertised in the City of 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 22 November 2017 with a comparison to the same period in the previous 2 years.

Data Warehousing
Central London > City of London
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 83 73 65
Rank change year-on-year -10 -8 +4
Permanent jobs citing Data Warehouse 373 475 704
As % of all permanent IT jobs advertised in the City of London 3.64% 4.06% 4.17%
As % of the Database & Business Intelligence category 11.63% 13.46% 14.10%
Number of salaries quoted 343 433 618
City of London median annual salary £60,000 £62,500 £57,500
Median salary % change year-on-year -4.00% +8.70% -4.17%
10th Percentile £42,600 £32,500 £42,500
90th Percentile £78,750 £82,500 £86,250
Central London median annual salary £60,000 £62,500 £60,000
% change year-on-year -4.00% +4.17% -

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 the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Permanent vacancies with a requirement for database or business intelligence skills 3206 3528 4992
As % of all permanent IT jobs advertised in the City of London 31.31% 30.18% 29.60%
Number of salaries quoted 2927 3240 4339
City of London median annual salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.35% - +4.55%
10th Percentile £41,250 £36,250 £36,250
90th Percentile £87,500 £86,250 £85,000
Central London median annual salary £59,500 £55,000 £57,000
% change year-on-year +8.18% -3.51% +3.64%

Data Warehouse
Job Vacancy Trend in the City of London

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

Job vacancy trend for Data Warehouse in the City of London

Data Warehouse
Salary Trend in the City of London

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

Salary trend for Data Warehouse in the City of London

Data Warehouse
Salary Histogram in the City of London

The salary distribution of IT jobs citing Data Warehouse in the City of London over the 6 months to 22 November 2017.

Salary histogram for Data Warehouse in the City of London

Data Warehouse
Job Locations in the City of 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 City of London region over the 6 months to 22 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
Moorgate - 1 £42,500 -
Data Warehouse
Central London

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

1 281 (75.34%) Business Intelligence
2 278 (74.53%) SQL
3 243 (65.15%) SQL Server
4 208 (55.76%) ETL
5 191 (51.21%) Microsoft
6 166 (44.50%) SQL Server Integration Services
7 154 (41.29%) Finance
8 145 (38.87%) SQL Server Reporting Services
9 130 (34.85%) T-SQL
10 114 (30.56%) SQL Server Analysis Services
11 107 (28.69%) Data Modelling
12 99 (26.54%) Agile Software Development
13 94 (25.20%) Visualisation
14 89 (23.86%) Analytics
15 84 (22.52%) Tableau
16 72 (19.30%) Microsoft Azure
17 71 (19.03%) C#
18 65 (17.43%) .NET
19 64 (17.16%) Power BI
20 63 (16.89%) Big Data
21 61 (16.35%) Python
22 57 (15.28%) Data Visualisation
23 55 (14.75%) Analytical Skills
24 52 (13.94%) Amazon AWS
25 51 (13.67%) QlikView
26 44 (11.80%) Degree
26 44 (11.80%) SQL Server 2012
26 44 (11.80%) Management Information System
27 42 (11.26%) R
28 41 (10.99%) Dimensional Modelling

Data Warehouse
Co-occurring IT Skills in the City of 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 21 (5.63%) SharePoint
2 17 (4.56%) SAS
3 4 (1.07%) Apache Spark
3 4 (1.07%) IIS
4 2 (0.54%) Confluence
4 2 (0.54%) SharePoint 2013
5 1 (0.27%) Apache
5 1 (0.27%) Apache Pig
5 1 (0.27%) OpenStack
5 1 (0.27%) WebSphere
Applications
1 37 (9.92%) Microsoft Excel
2 5 (1.34%) MS Visio
3 4 (1.07%) Microsoft Office
4 3 (0.80%) SPSS
Business Applications
1 3 (0.80%) Cognos Business Intelligence
1 3 (0.80%) HFM
1 3 (0.80%) Hyperion Enterprise
2 2 (0.54%) Adobe Campaign
2 2 (0.54%) Unica
3 1 (0.27%) FastStats
3 1 (0.27%) FastStats PeopleStage
3 1 (0.27%) Markit EDM
3 1 (0.27%) Oracle Applications
3 1 (0.27%) Salesforce.com CRM
Cloud Services
1 72 (19.30%) Microsoft Azure
2 52 (13.94%) Amazon AWS
3 19 (5.09%) Azure Machine Learning
4 18 (4.83%) Google Cloud Platform
5 3 (0.80%) Azure Data Factory
5 3 (0.80%) Cortana Intelligence Suite
5 3 (0.80%) PaaS
6 2 (0.54%) Amazon S3
6 2 (0.54%) AWS Lambda
6 2 (0.54%) Cloud Computing
6 2 (0.54%) SaaS
6 2 (0.54%) Serverless
7 1 (0.27%) Adobe Analytics
7 1 (0.27%) BlueKai
7 1 (0.27%) Boomi
7 1 (0.27%) Google Analytics
7 1 (0.27%) Office 365
Communications & Networking
1 16 (4.29%) Intranet
2 1 (0.27%) Internet
2 1 (0.27%) LAN
2 1 (0.27%) WAN
Database & Business Intelligence
1 243 (65.15%) SQL Server
2 166 (44.50%) SQL Server Integration Services
3 145 (38.87%) SQL Server Reporting Services
4 114 (30.56%) SQL Server Analysis Services
5 64 (17.16%) Power BI
6 63 (16.89%) Big Data
7 51 (13.67%) QlikView
8 44 (11.80%) SQL Server 2012
9 30 (8.04%) Amazon Redshift
10 29 (7.77%) BusinessObjects
11 27 (7.24%) SQL Server 2008
12 24 (6.43%) OLAP
13 23 (6.17%) Amazon RDS
13 23 (6.17%) NoSQL
14 21 (5.63%) SQL Server 2016
15 18 (4.83%) Data Mining
15 18 (4.83%) SQL Server 2014
16 17 (4.56%) OLAP Cube
17 15 (4.02%) BigQuery
18 14 (3.75%) Lumira
Development Applications
1 29 (7.77%) Visual Studio
2 16 (4.29%) JIRA
3 11 (2.95%) Jenkins
3 11 (2.95%) Talend Open Studio
3 11 (2.95%) Team Foundation Server
3 11 (2.95%) TeamCity
4 9 (2.41%) ERwin
5 7 (1.88%) Eclipse
6 4 (1.07%) PowerDesigner
7 3 (0.80%) Git (software)
7 3 (0.80%) VSS/SourceSafe
8 1 (0.27%) Bitbucket
8 1 (0.27%) Bugzilla
8 1 (0.27%) TestRail
8 1 (0.27%) Toad
General
1 154 (41.29%) Finance
2 29 (7.77%) Banking
3 23 (6.17%) Retail
4 18 (4.83%) Advertising
4 18 (4.83%) Legal
5 16 (4.29%) Marketing
6 13 (3.49%) Law
7 12 (3.22%) Publishing
8 11 (2.95%) Retail Banking
9 9 (2.41%) Games
10 8 (2.14%) Front Office
11 4 (1.07%) Back Office
12 2 (0.54%) Pharmaceutical
13 1 (0.27%) Electronics
13 1 (0.27%) Financial Institution
13 1 (0.27%) International Banking
Job Titles
1 163 (43.70%) Developer
2 92 (24.66%) Business Intelligence Developer
3 88 (23.59%) Analyst
4 79 (21.18%) SQL Developer
5 39 (10.46%) SQL BI Developer
6 37 (9.92%) SSIS Developer
7 35 (9.38%) Business Analyst
8 34 (9.12%) Business Intelligence Lead
9 32 (8.58%) SSAS Developer
10 31 (8.31%) Consultant
11 29 (7.77%) C# Developer
12 28 (7.51%) ETL Developer
13 26 (6.97%) SSRS Developer
14 24 (6.43%) .NET Developer
15 23 (6.17%) C# .NET Developer
15 23 (6.17%) SQL Server Developer
16 22 (5.90%) Architect
16 22 (5.90%) Business Developer
17 21 (5.63%) Insurance Business Analyst
17 21 (5.63%) Report Analyst
Libraries, Frameworks & Software Standards
1 65 (17.43%) .NET
2 36 (9.65%) ASP.NET
3 21 (5.63%) Web Services
4 17 (4.56%) XML
5 16 (4.29%) ASP.NET MVC
6 13 (3.49%) MDX
6 13 (3.49%) RESTful
7 11 (2.95%) JSON
7 11 (2.95%) LINQ
7 11 (2.95%) WSDL
7 11 (2.95%) XSD
8 8 (2.14%) Lucene
9 4 (1.07%) .NET Framework
9 4 (1.07%) AngularJS
9 4 (1.07%) ASP.NET Web API
9 4 (1.07%) Entity Framework
9 4 (1.07%) HTML
9 4 (1.07%) jQuery
9 4 (1.07%) Kafka
9 4 (1.07%) Twitter Bootstrap
Miscellaneous
1 55 (14.75%) Analytical Skills
2 44 (11.80%) Management Information System
3 13 (3.49%) Computer Science
3 13 (3.49%) Reinsurance
4 12 (3.22%) Virtual Team
5 11 (2.95%) Data Structures
6 9 (2.41%) Algorithms
6 9 (2.41%) Semantic Web
7 8 (2.14%) Greenfield Project
7 8 (2.14%) Replication
8 6 (1.61%) Clustering
9 5 (1.34%) Data Centre
10 4 (1.07%) Fintech
10 4 (1.07%) Linux Command Line
11 2 (0.54%) Enterprise Software
11 2 (0.54%) Hedge funds
11 2 (0.54%) Mainframe
12 1 (0.27%) Market Risk
12 1 (0.27%) Reference Data
12 1 (0.27%) Social Media
Operating Systems
1 8 (2.14%) Unix
2 7 (1.88%) Linux
3 5 (1.34%) Windows
4 3 (0.80%) Windows Server 2008
4 3 (0.80%) Windows Server 2012
Processes & Methodologies
1 281 (75.34%) Business Intelligence
2 208 (55.76%) ETL
3 107 (28.69%) Data Modelling
4 99 (26.54%) Agile Software Development
5 94 (25.20%) Visualisation
6 89 (23.86%) Analytics
7 57 (15.28%) Data Visualisation
8 41 (10.99%) Dimensional Modelling
9 37 (9.92%) Kimball Methodology
10 34 (9.12%) Data Analysis
10 34 (9.12%) Data Management
11 32 (8.58%) Data Architecture
12 25 (6.70%) Master Data Management
12 25 (6.70%) Mentoring
12 25 (6.70%) Scrum
12 25 (6.70%) SDLC
13 24 (6.43%) Data Analytics
13 24 (6.43%) Validation
14 23 (6.17%) Test Automation
15 22 (5.90%) Data Integration
Programming Languages
1 278 (74.53%) SQL
2 130 (34.85%) T-SQL
3 71 (19.03%) C#
4 61 (16.35%) Python
5 42 (11.26%) R
6 20 (5.36%) Java
7 16 (4.29%) Shell Script
8 15 (4.02%) VBA
9 14 (3.75%) PL/SQL
10 13 (3.49%) PowerShell
11 11 (2.95%) JavaScript
12 7 (1.88%) Data Analysis Expressions (DAX)
12 7 (1.88%) VB
13 6 (1.61%) Scala
14 2 (0.54%) C
15 1 (0.27%) Bash Shell
15 1 (0.27%) MATLAB
15 1 (0.27%) PHP
15 1 (0.27%) Ruby
15 1 (0.27%) SAS Macro
Qualifications
1 44 (11.80%) Degree
2 6 (1.61%) ISEB
3 4 (1.07%) ITIL Foundation Certificate
4 3 (0.80%) ACCA
4 3 (0.80%) Computer Science Degree
4 3 (0.80%) Microsoft Certification
4 3 (0.80%) Oracle Certification
5 2 (0.54%) ISTQB
5 2 (0.54%) Master's Degree
6 1 (0.27%) ISTQB Foundation Certification
6 1 (0.27%) MCSE
6 1 (0.27%) OCP
6 1 (0.27%) SC Cleared
6 1 (0.27%) Security Cleared
Quality Assurance & Compliance
1 27 (7.24%) Data Quality
2 25 (6.70%) QA
3 3 (0.80%) GCP
4 2 (0.54%) PMO
4 2 (0.54%) SLA
4 2 (0.54%) Solvency II
5 1 (0.27%) MiFID
5 1 (0.27%) UCITS
System Software
1 2 (0.54%) Microsoft Virtual Server
1 2 (0.54%) Virtual Servers
2 1 (0.27%) Active Directory
2 1 (0.27%) Hyper-V
2 1 (0.27%) VMware Infrastructure
Systems Management
1 2 (0.54%) Control-M
2 1 (0.27%) HP Quality Center
Vendors
1 191 (51.21%) Microsoft
2 84 (22.52%) Tableau
3 37 (9.92%) Oracle
4 22 (5.90%) Alteryx
4 22 (5.90%) SAP
5 19 (5.09%) MicroStrategy
6 18 (4.83%) Cognos
7 16 (4.29%) Google
8 11 (2.95%) Talend
9 10 (2.68%) Informatica
9 10 (2.68%) Teradata
10 7 (1.88%) Salesforce.com
11 6 (1.61%) Adobe
11 6 (1.61%) IBM
12 5 (1.34%) Hyperion
12 5 (1.34%) Sybase
13 4 (1.07%) EXASOL
13 4 (1.07%) Netezza
13 4 (1.07%) Twitter
14 3 (0.80%) Cisco