Period
to 21 November 2018

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

Data Warehousing
London > Central London
6 months to
21 Nov 2018
Same period 2017 Same period 2016
Rank 92 91 84
Rank change year-on-year -1 -7 -10
Permanent jobs citing Data Warehouse 478 482 546
As % of all permanent IT jobs advertised in Central London 3.40% 3.45% 3.83%
As % of the Database & Business Intelligence category 11.37% 11.07% 12.51%
Number of salaries quoted 445 440 505
Central London median annual salary £62,500 £60,000 £62,500
Median salary % change year-on-year +4.17% -4.00% +4.17%
10th Percentile £41,250 £42,500 £32,600
90th Percentile £88,750 £80,000 £82,500
London median annual salary £62,500 £60,000 £60,000
% change year-on-year +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 Central London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Central London
Permanent vacancies with a requirement for database or business intelligence skills 4,203 4,355 4,366
As % of all permanent IT jobs advertised in Central London 29.90% 31.22% 30.61%
Number of salaries quoted 3,823 3,942 4,022
Central London median annual salary £65,000 £59,500 £55,000
Median salary % change year-on-year +9.24% +8.18% -3.51%
10th Percentile £40,000 £38,525 £35,000
90th Percentile £93,750 £87,500 £85,000
London median annual salary £62,500 £60,000 £57,500
% change year-on-year +4.17% +4.35% +4.55%

Data Warehouse
Job Vacancy Trend in Central London

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

Job vacancy trend for Data Warehouse in Central London

Data Warehouse
Salary Trend in Central London

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

Salary trend for Data Warehouse in Central London

Data Warehouse
Salary Histogram in Central London

The salary distribution of IT jobs citing Data Warehouse in Central London over the 6 months to 21 November 2018.

Salary histogram for Data Warehouse in Central London

Data Warehouse
Job Locations in Central 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 Central London region over the 6 months to 21 November 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
City of London -4 419 £62,500 +4.17% 88
City of Westminster - 8 £83,750 -
Southwark +64 7 £45,000 -14.29%
West End of London -33 5 £85,000 +47.83% 11
Camden +7 3 £55,000 +10.00%
Kensington and Chelsea -2 3 - -
Data Warehouse
London

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

1 365 (76.36%) SQL
2 322 (67.36%) Business Intelligence
3 229 (47.91%) SQL Server
3 229 (47.91%) SQL Server Integration Services
4 220 (46.03%) ETL
5 195 (40.79%) Microsoft
6 182 (38.08%) SQL Server Reporting Services
7 175 (36.61%) Finance
8 167 (34.94%) Power BI
9 146 (30.54%) T-SQL
10 145 (30.33%) Agile Software Development
11 139 (29.08%) Analytics
12 131 (27.41%) SQL Server Analysis Services
13 115 (24.06%) Tableau
14 101 (21.13%) Microsoft Azure
15 90 (18.83%) C#
16 89 (18.62%) Data Modelling
17 84 (17.57%) Big Data
18 77 (16.11%) .NET
19 75 (15.69%) Analytical Skills
20 71 (14.85%) Data Management
21 68 (14.23%) Visualisation
22 67 (14.02%) Python
23 66 (13.81%) Scrum
24 61 (12.76%) SDLC
25 59 (12.34%) Microsoft Excel
26 56 (11.72%) Data Quality
26 56 (11.72%) Data Lake
26 56 (11.72%) Kimball Methodology
27 55 (11.51%) BusinessObjects

Data Warehouse
Co-occurring IT Skills in Central 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 28 (5.86%) SAS
2 24 (5.02%) Apache Spark
3 15 (3.14%) SharePoint
4 7 (1.46%) IIS
5 4 (0.84%) Apache
5 4 (0.84%) Apache Pig
5 4 (0.84%) Elasticsearch
6 2 (0.42%) IBM Notes
6 2 (0.42%) Oracle SOA Suite
7 1 (0.21%) Apache Airflow
7 1 (0.21%) CMS
7 1 (0.21%) Luigi
7 1 (0.21%) MS Exchange
7 1 (0.21%) OpenStack
Applications
1 59 (12.34%) Microsoft Excel
2 16 (3.35%) Microsoft Office
3 8 (1.67%) MS Visio
4 7 (1.46%) Microsoft PowerPoint
5 2 (0.42%) Spreadsheet
6 1 (0.21%) GNU Octave
Business Applications
1 9 (1.88%) FastStats
2 1 (0.21%) Cognos TM1
2 1 (0.21%) Magento
2 1 (0.21%) MetaTrader
Cloud Services
1 101 (21.13%) Microsoft Azure
2 42 (8.79%) Amazon AWS
3 28 (5.86%) Azure Data Factory
4 13 (2.72%) Serverless
5 10 (2.09%) Data Lake Analytics
6 8 (1.67%) Azure Functions
7 7 (1.46%) Amazon S3
8 6 (1.26%) Amazon EC2
8 6 (1.26%) AWS Lambda
9 4 (0.84%) Azure Machine Learning
9 4 (0.84%) Cortana Intelligence Suite
9 4 (0.84%) GitHub
10 3 (0.63%) Amazon SQS
10 3 (0.63%) PaaS
11 2 (0.42%) Amazon CloudWatch
11 2 (0.42%) Boomi
11 2 (0.42%) Cloud Computing
11 2 (0.42%) Google Analytics
11 2 (0.42%) IaaS
11 2 (0.42%) Virtual Private Cloud
Communications & Networking
1 4 (0.84%) SSH
2 2 (0.42%) LAN
2 2 (0.42%) VoIP
2 2 (0.42%) WAN
3 1 (0.21%) Firewall
3 1 (0.21%) Internet
3 1 (0.21%) Intranet
3 1 (0.21%) NAS
3 1 (0.21%) PABX
3 1 (0.21%) SAN
3 1 (0.21%) VPN
Database & Business Intelligence
1 229 (47.91%) SQL Server
1 229 (47.91%) SQL Server Integration Services
2 182 (38.08%) SQL Server Reporting Services
3 167 (34.94%) Power BI
4 131 (27.41%) SQL Server Analysis Services
5 84 (17.57%) Big Data
6 56 (11.72%) Data Lake
7 55 (11.51%) BusinessObjects
8 48 (10.04%) SQL Server 2016
9 44 (9.21%) Hadoop
10 38 (7.95%) Relational Database
11 30 (6.28%) SQL Server 2008
12 29 (6.07%) Amazon Redshift
12 29 (6.07%) SQL Server 2012
13 28 (5.86%) QlikView
14 26 (5.44%) Microsoft Analysis Services
15 23 (4.81%) Azure SQL Data Warehouse
15 23 (4.81%) NoSQL
16 21 (4.39%) OLAP
17 20 (4.18%) Enterprise Data Warehouse
Development Applications
1 36 (7.53%) Team Foundation Server
2 26 (5.44%) Visual Studio
3 22 (4.60%) Jenkins
4 18 (3.77%) Subversion
5 17 (3.56%) Git (software)
6 13 (2.72%) Eclipse
7 12 (2.51%) TeamCity
8 10 (2.09%) JIRA
8 10 (2.09%) Selenium
9 9 (1.88%) Octopus Deploy
9 9 (1.88%) tSQLt
10 8 (1.67%) SQL Server Management Studio (SSMS)
10 8 (1.67%) Visual Studio Team System
11 6 (1.26%) Maven
11 6 (1.26%) SpecFlow
12 4 (0.84%) Oracle APEX
13 3 (0.63%) Atlassian Bamboo
13 3 (0.63%) ER Studio
13 3 (0.63%) ERwin
13 3 (0.63%) RStudio
General
1 175 (36.61%) Finance
2 35 (7.32%) Retail
3 34 (7.11%) Banking
4 21 (4.39%) Advertising
5 16 (3.35%) Marketing
6 14 (2.93%) Back Office
7 8 (1.67%) Law
8 7 (1.46%) Games
9 4 (0.84%) General Ledger
9 4 (0.84%) Legal
10 3 (0.63%) Financial Institution
10 3 (0.63%) International Banking
11 2 (0.42%) Investment Banking
11 2 (0.42%) Pharmaceutical
11 2 (0.42%) Retail Banking
12 1 (0.21%) Billing
12 1 (0.21%) Dutch Language
12 1 (0.21%) French Language
12 1 (0.21%) Social Science
12 1 (0.21%) Spanish Language
Job Titles
1 205 (42.89%) Developer
2 101 (21.13%) Analyst
3 97 (20.29%) Business Intelligence Developer
4 78 (16.32%) SQL Developer
5 58 (12.13%) Architect
6 45 (9.41%) Data Engineer
7 41 (8.58%) SQL BI Developer
8 35 (7.32%) SSIS Developer
9 34 (7.11%) Business Intelligence Analyst
10 33 (6.90%) SQL Server Developer
11 27 (5.65%) Data Analyst
11 27 (5.65%) Solutions Architect
12 25 (5.23%) Data Warehouse Developer
13 24 (5.02%) Business Developer
13 24 (5.02%) Senior Developer
14 22 (4.60%) SSAS Developer
14 22 (4.60%) SSRS Developer
15 21 (4.39%) Data Architect
15 21 (4.39%) ETL Developer
16 20 (4.18%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 77 (16.11%) .NET
2 54 (11.30%) XML
3 36 (7.53%) Web Services
4 31 (6.49%) HTML
5 25 (5.23%) JSON
6 24 (5.02%) MDX
7 22 (4.60%) CSS
7 22 (4.60%) REST
8 19 (3.97%) .NET Framework
9 13 (2.72%) Entity Framework
10 12 (2.51%) XSD
11 11 (2.30%) ASP.NET
12 10 (2.09%) Kafka
13 6 (1.26%) jQuery
13 6 (1.26%) NHibernate
14 5 (1.05%) Middleware
14 5 (1.05%) RESTful
14 5 (1.05%) Velocity
15 4 (0.84%) HTML5
15 4 (0.84%) Node.js
Miscellaneous
1 75 (15.69%) Analytical Skills
2 44 (9.21%) Reinsurance
3 38 (7.95%) Data Structures
4 28 (5.86%) Computer Science
5 23 (4.81%) Management Information System
6 21 (4.39%) Fintech
7 16 (3.35%) Self-Motivation
7 16 (3.35%) User Experience
8 9 (1.88%) Reference Data
8 9 (1.88%) Replication
8 9 (1.88%) Virtual Team
9 7 (1.46%) Algorithms
9 7 (1.46%) Analytical Mindset
9 7 (1.46%) Greenfield Project
9 7 (1.46%) Market Risk
9 7 (1.46%) Tandem
10 6 (1.26%) Credit Risk
11 4 (0.84%) Data Centre
11 4 (0.84%) Enterprise Software
11 4 (0.84%) Mobile App
Operating Systems
1 27 (5.65%) Windows
2 25 (5.23%) Unix
3 16 (3.35%) Linux
4 8 (1.67%) Red Hat Enterprise Linux
5 6 (1.26%) HPUX
5 6 (1.26%) Solaris
6 5 (1.05%) AIX
6 5 (1.05%) Windows Server
7 4 (0.84%) Windows Server 2012
8 1 (0.21%) CentOS
8 1 (0.21%) VMS
8 1 (0.21%) zOS
Processes & Methodologies
1 322 (67.36%) Business Intelligence
2 220 (46.03%) ETL
3 145 (30.33%) Agile Software Development
4 139 (29.08%) Analytics
5 89 (18.62%) Data Modelling
6 71 (14.85%) Data Management
7 68 (14.23%) Visualisation
8 66 (13.81%) Scrum
9 61 (12.76%) SDLC
10 56 (11.72%) Kimball Methodology
11 51 (10.67%) Machine Learning
12 50 (10.46%) Problem-Solving
13 49 (10.25%) Waterfall
14 47 (9.83%) Migration
15 45 (9.41%) Data Integration
16 38 (7.95%) Data Analysis
17 35 (7.32%) Data Science
18 33 (6.90%) DevOps
18 33 (6.90%) E-Commerce
19 32 (6.69%) Test Automation
Programming Languages
1 365 (76.36%) SQL
2 146 (30.54%) T-SQL
3 90 (18.83%) C#
4 67 (14.02%) Python
5 43 (9.00%) JavaScript
6 35 (7.32%) Java
7 28 (5.86%) R
8 27 (5.65%) Data Analysis Expressions (DAX)
8 27 (5.65%) VBA
9 24 (5.02%) PowerShell
10 18 (3.77%) PL/SQL
10 18 (3.77%) Shell Script
11 14 (2.93%) C
12 8 (1.67%) Perl
13 7 (1.46%) Scala
13 7 (1.46%) U-SQL
14 6 (1.26%) PHP
14 6 (1.26%) VB
15 4 (0.84%) C++
16 3 (0.63%) MATLAB
Qualifications
1 35 (7.32%) Degree
2 13 (2.72%) Microsoft Certification
3 9 (1.88%) Computer Science Degree
4 6 (1.26%) Numerate Degree
5 5 (1.05%) PhD
5 5 (1.05%) PRINCE2 Certification
6 4 (0.84%) ITIL Foundation Certificate
7 3 (0.63%) Master's Degree
7 3 (0.63%) MCSA
7 3 (0.63%) Security Cleared
8 2 (0.42%) ACCA
8 2 (0.42%) ISTQB
8 2 (0.42%) PMI Certification
8 2 (0.42%) PMP
9 1 (0.21%) CBAP
9 1 (0.21%) CIMA
9 1 (0.21%) IIBA
9 1 (0.21%) ISEB
9 1 (0.21%) MCITP
9 1 (0.21%) Microsoft Certified Architect
Quality Assurance & Compliance
1 56 (11.72%) Data Quality
2 25 (5.23%) QA
3 6 (1.26%) GDPR
4 5 (1.05%) Solvency II
5 2 (0.42%) ISO/IEC 27001
5 2 (0.42%) MiFID
6 1 (0.21%) GAAP
6 1 (0.21%) IFRS
6 1 (0.21%) PCI DSS
System Software
1 7 (1.46%) Docker
2 4 (0.84%) HDFS
3 3 (0.63%) Apache Flume
4 2 (0.42%) Hyper-V
4 2 (0.42%) VMware Infrastructure
5 1 (0.21%) Active Directory
5 1 (0.21%) Virtual Machines
Systems Management
1 4 (0.84%) Ansible
2 3 (0.63%) Docker Swarm
2 3 (0.63%) Mesos
2 3 (0.63%) Oozie
2 3 (0.63%) Opscode Chef
2 3 (0.63%) Puppet
3 2 (0.42%) Automic
3 2 (0.42%) Control-M
3 2 (0.42%) Rundeck
4 1 (0.21%) Grafana
4 1 (0.21%) Oracle Enterprise Manager
4 1 (0.21%) Oracle RMAN
4 1 (0.21%) Terraform
Vendors
1 195 (40.79%) Microsoft
2 115 (24.06%) Tableau
3 52 (10.88%) Oracle
4 21 (4.39%) Informatica
5 19 (3.97%) Talend
6 17 (3.56%) Cognos
6 17 (3.56%) SAP
7 14 (2.93%) MicroStrategy
8 8 (1.67%) IBM
8 8 (1.67%) Red Hat
9 7 (1.46%) Sybase
10 5 (1.05%) Salesforce.com
11 4 (0.84%) Birst
11 4 (0.84%) SnapLogic
11 4 (0.84%) Teradata
12 3 (0.63%) iManage
12 3 (0.63%) Perforce
12 3 (0.63%) Sun
13 2 (0.42%) Dell
13 2 (0.42%) Lotus