Period
to 11 December 2019

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 11 December 2019 with a comparison to the same period in the previous 2 years.

Data Warehousing
Central London > City of London
6 months to
11 Dec 2019
Same period 2018 Same period 2017
Rank 51 86 92
Rank change year-on-year +35 +6 -22
Permanent jobs citing Data Warehouse 475 386 342
As % of all permanent IT jobs advertised in the City of London 4.82% 3.62% 3.30%
As % of the Database & Business Intelligence category 16.96% 11.86% 10.67%
Number of salaries quoted 413 370 303
City of London median annual salary £65,000 £62,000 £60,000
Median salary % change year-on-year +4.84% +3.33% -4.00%
10th Percentile £46,396 £41,250 £43,000
90th Percentile £85,000 £88,750 £78,750
Central London median annual salary £65,000 £62,500 £59,000
% change year-on-year +4.00% +5.93% -5.60%

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 2,800 3,255 3,204
As % of all permanent IT jobs advertised in the City of London 28.43% 30.51% 30.89%
Number of salaries quoted 2,468 2,952 2,924
City of London median annual salary £70,000 £65,000 £60,000
Median salary % change year-on-year +7.69% +8.33% +4.35%
10th Percentile £42,500 £41,250 £41,250
90th Percentile £101,250 £95,000 £89,625
Central London median annual salary £67,500 £65,000 £60,000
% change year-on-year +3.85% +8.33% +4.35%

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 11 December 2019.

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 11 December 2019. 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 Bridge -5 8 £65,000 +44.44%
Data Warehouse
Central London

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

1 294 (61.89%) SQL
2 270 (56.84%) Business Intelligence
3 236 (49.68%) SQL Server
4 221 (46.53%) SQL Server Integration Services
5 215 (45.26%) Power BI
5 215 (45.26%) Power Platform
6 197 (41.47%) SQL Server Analysis Services
7 194 (40.84%) ETL
8 170 (35.79%) Azure
9 159 (33.47%) Analytics
10 157 (33.05%) Microsoft
11 151 (31.79%) SQL Server Reporting Services
12 145 (30.53%) Finance
13 143 (30.11%) Agile Software Development
14 117 (24.63%) Visualisation
15 113 (23.79%) Data Modelling
16 103 (21.68%) Python
17 87 (18.32%) Big Data
18 86 (18.11%) T-SQL
19 82 (17.26%) Microsoft Analysis Services
20 78 (16.42%) AWS
21 71 (14.95%) Data Management
22 70 (14.74%) Decision-Making
23 68 (14.32%) Data Analysis Expressions (DAX)
23 68 (14.32%) Analytical Skills
24 66 (13.89%) Problem-Solving
25 65 (13.68%) Java
26 61 (12.84%) C#
27 60 (12.63%) Tableau
28 56 (11.79%) Data Architecture

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 37 (7.79%) Apache Spark
2 25 (5.26%) SharePoint
3 16 (3.37%) SAS
4 7 (1.47%) Apache
5 6 (1.26%) Confluence
6 4 (0.84%) Apache Airflow
6 4 (0.84%) SharePoint 2013
7 3 (0.63%) Apache Pig
8 1 (0.21%) IBM HTTP Server
Applications
1 37 (7.79%) Microsoft Excel
2 11 (2.32%) Microsoft Office
3 3 (0.63%) Microsoft Project
4 1 (0.21%) Microsoft PowerPoint
Business Applications
1 7 (1.47%) Dynamics CRM
2 5 (1.05%) Markit EDM
3 4 (0.84%) Cognos Business Intelligence
3 4 (0.84%) FastStats
4 2 (0.42%) Eagle PACE
5 1 (0.21%) Dynamics NAV
5 1 (0.21%) HFM
5 1 (0.21%) Hyperion Planning
5 1 (0.21%) PolarLake
5 1 (0.21%) Salesforce.com CRM
5 1 (0.21%) Sparx Enterprise Architect
5 1 (0.21%) thinkFolio
Cloud Services
1 215 (45.26%) Power Platform
2 170 (35.79%) Azure
3 78 (16.42%) AWS
4 41 (8.63%) Azure Data Factory
5 23 (4.84%) GCP
6 7 (1.47%) GitHub
7 6 (1.26%) AWS CloudFormation
8 5 (1.05%) Amazon EMR
8 5 (1.05%) Amazon S3
8 5 (1.05%) Data Lake Analytics
8 5 (1.05%) Office 365
9 4 (0.84%) Cloud Computing
9 4 (0.84%) Google Analytics
9 4 (0.84%) Mimecast
9 4 (0.84%) PowerApps
9 4 (0.84%) SaaS
10 3 (0.63%) Azure Functions
10 3 (0.63%) Heroku
10 3 (0.63%) PaaS
10 3 (0.63%) Serverless
Communications & Networking
1 6 (1.26%) Network Security
2 1 (0.21%) Broadband
2 1 (0.21%) DNS
2 1 (0.21%) SAN
Database & Business Intelligence
1 236 (49.68%) SQL Server
2 221 (46.53%) SQL Server Integration Services
3 215 (45.26%) Power BI
4 197 (41.47%) SQL Server Analysis Services
5 151 (31.79%) SQL Server Reporting Services
6 87 (18.32%) Big Data
7 82 (17.26%) Microsoft Analysis Services
8 52 (10.95%) Data Lake
9 49 (10.32%) PostgreSQL
10 44 (9.26%) Relational Database
11 41 (8.63%) Hadoop
12 30 (6.32%) SQL Server 2016
13 29 (6.11%) Apache Hive
14 26 (5.47%) OLAP
15 24 (5.05%) Azure SQL Database
15 24 (5.05%) Pentaho
16 23 (4.84%) Looker
17 22 (4.63%) Enterprise Data Warehouse
18 20 (4.21%) NoSQL
19 18 (3.79%) Data Mining
Development Applications
1 20 (4.21%) Git (software)
2 16 (3.37%) JIRA
3 14 (2.95%) Team Foundation Server
4 11 (2.32%) ERwin
4 11 (2.32%) PowerDesigner
5 10 (2.11%) Bitbucket
5 10 (2.11%) ER Studio
6 9 (1.89%) Visual Studio
7 8 (1.68%) Atlassian Bamboo
8 6 (1.26%) Jenkins
8 6 (1.26%) Visual Studio Team System
9 5 (1.05%) SQL Server Management Studio (SSMS)
9 5 (1.05%) Subversion
10 4 (0.84%) Selenium
11 3 (0.63%) Oracle APEX
12 2 (0.42%) Artifactory
12 2 (0.42%) Maven
13 1 (0.21%) Jasmine
13 1 (0.21%) Karma Test Runner
13 1 (0.21%) NUnit
General
1 145 (30.53%) Finance
2 25 (5.26%) Telecoms
3 18 (3.79%) Banking
4 17 (3.58%) Marketing
5 15 (3.16%) Retail
6 12 (2.53%) Advertising
7 4 (0.84%) Legal
7 4 (0.84%) Public Sector
8 3 (0.63%) Billing
8 3 (0.63%) Law
9 2 (0.42%) Back Office
9 2 (0.42%) Publishing
10 1 (0.21%) Environmental Health
10 1 (0.21%) Investment Banking
10 1 (0.21%) Polish Language
Job Titles
1 185 (38.95%) Developer
2 133 (28.00%) Business Intelligence Developer
3 55 (11.58%) SQL Developer
4 54 (11.37%) Architect
5 47 (9.89%) Data Engineer
6 45 (9.47%) Analyst
7 43 (9.05%) SQL BI Developer
8 30 (6.32%) Data Architect
9 28 (5.89%) DBA
9 28 (5.89%) SQL DBA
10 27 (5.68%) Senior Developer
11 26 (5.47%) Power BI Developer
11 26 (5.47%) Senior Business Intelligence Developer
12 25 (5.26%) SSRS Developer
13 21 (4.42%) Business Intelligence Lead
13 21 (4.42%) Lead Developer
13 21 (4.42%) SSAS Developer
14 20 (4.21%) Data Warehouse Developer
14 20 (4.21%) ETL Developer
15 19 (4.00%) Administrator
Libraries, Frameworks & Software Standards
1 43 (9.05%) MDX
2 40 (8.42%) .NET
3 23 (4.84%) ASP.NET
4 19 (4.00%) D3.js
4 19 (4.00%) Kafka
4 19 (4.00%) Vue.js
5 15 (3.16%) XML
6 12 (2.53%) .NET Framework
7 8 (1.68%) RESTful
8 7 (1.47%) GraphQL
8 7 (1.47%) HTML
8 7 (1.47%) JSON
8 7 (1.47%) SOAP
8 7 (1.47%) Web Services
9 6 (1.26%) Node.js
9 6 (1.26%) Twitter Bootstrap
10 5 (1.05%) CSS
10 5 (1.05%) HTML5
11 4 (0.84%) AngularJS
11 4 (0.84%) XSD
Miscellaneous
1 68 (14.32%) Analytical Skills
2 56 (11.79%) Management Information System
3 26 (5.47%) Self-Motivation
4 18 (3.79%) Public Cloud
4 18 (3.79%) Reinsurance
5 17 (3.58%) Data Centre
5 17 (3.58%) Greenfield Project
6 15 (3.16%) Private Cloud
7 11 (2.32%) Data Structures
7 11 (2.32%) User Experience
8 5 (1.05%) Reference Data
8 5 (1.05%) Taxonomies
9 4 (0.84%) FMCG
10 3 (0.63%) Client/Server
10 3 (0.63%) Equities
10 3 (0.63%) Foreign Exchange (FX)
10 3 (0.63%) N-Tier
11 2 (0.42%) Derivative
11 2 (0.42%) Fixed Income
11 2 (0.42%) Semantic Web
Operating Systems
1 44 (9.26%) Windows
2 36 (7.58%) Windows Server
3 12 (2.53%) Unix
4 3 (0.63%) Linux
5 1 (0.21%) Red Hat Enterprise Linux
5 1 (0.21%) Windows Server 2012
Processes & Methodologies
1 270 (56.84%) Business Intelligence
2 194 (40.84%) ETL
3 159 (33.47%) Analytics
4 143 (30.11%) Agile Software Development
5 117 (24.63%) Visualisation
6 113 (23.79%) Data Modelling
7 71 (14.95%) Data Management
8 70 (14.74%) Decision-Making
9 66 (13.89%) Problem-Solving
10 56 (11.79%) Data Architecture
11 54 (11.37%) Data Visualisation
12 53 (11.16%) DevOps
13 50 (10.53%) Data Science
13 50 (10.53%) ITIL
13 50 (10.53%) Master Data Management
14 49 (10.32%) Change Management
15 45 (9.47%) Data Analysis
16 42 (8.84%) User Acceptance Testing
17 41 (8.63%) Data Analytics
17 41 (8.63%) Kimball Methodology
Programming Languages
1 294 (61.89%) SQL
2 103 (21.68%) Python
3 86 (18.11%) T-SQL
4 68 (14.32%) Data Analysis Expressions (DAX)
5 65 (13.68%) Java
6 61 (12.84%) C#
7 30 (6.32%) VBA
8 24 (5.05%) PL/SQL
9 23 (4.84%) R
10 22 (4.63%) VB
11 17 (3.58%) PowerShell
12 8 (1.68%) JavaScript
13 6 (1.26%) Bash Shell
14 4 (0.84%) Scala
14 4 (0.84%) TypeScript
15 3 (0.63%) Apex Code
16 2 (0.42%) Go
16 2 (0.42%) HiveQL
17 1 (0.21%) C
17 1 (0.21%) Java 8
Qualifications
1 23 (4.84%) Degree
2 14 (2.95%) ITIL Foundation Certificate
3 8 (1.68%) Computer Science Degree
4 7 (1.47%) Security Cleared
5 4 (0.84%) TOGAF Certification
6 3 (0.63%) Master's Degree
7 2 (0.42%) AWS Certification
7 2 (0.42%) Numerate Degree
7 2 (0.42%) PhD
7 2 (0.42%) Postgraduate
8 1 (0.21%) APMP
8 1 (0.21%) ISEB
8 1 (0.21%) ITIL Certification
8 1 (0.21%) Microsoft Certification
8 1 (0.21%) Six Sigma Black Belt
Quality Assurance & Compliance
1 53 (11.16%) Data Quality
2 17 (3.58%) QA
3 11 (2.32%) GDPR
4 3 (0.63%) SLA
5 1 (0.21%) Basel III
5 1 (0.21%) EMIR
5 1 (0.21%) IFRS
5 1 (0.21%) IFRS 9
System Software
1 13 (2.74%) Docker
2 7 (1.47%) Active Directory
3 6 (1.26%) Hyper-V
3 6 (1.26%) VMware Infrastructure
3 6 (1.26%) VMware Workstation
3 6 (1.26%) XenApp
4 4 (0.84%) Apache Flume
5 2 (0.42%) Apache ZooKeeper
6 1 (0.21%) Cronacle
6 1 (0.21%) Veritas File System
6 1 (0.21%) Veritas Volume Manager
Systems Management
1 14 (2.95%) Kubernetes
2 13 (2.74%) Control-M
3 9 (1.89%) Ansible
4 8 (1.68%) Terraform
5 6 (1.26%) Opscode Chef
5 6 (1.26%) Puppet
6 4 (0.84%) Oozie
7 3 (0.63%) Dollar Universe
7 3 (0.63%) Failover Clustering
8 1 (0.21%) Automic
8 1 (0.21%) Hadoop YARN
Vendors
1 157 (33.05%) Microsoft
2 60 (12.63%) Tableau
3 46 (9.68%) Oracle
4 45 (9.47%) Informatica
5 36 (7.58%) Google
6 25 (5.26%) Databricks
7 21 (4.42%) Talend
7 21 (4.42%) Teradata
8 20 (4.21%) IBM
9 16 (3.37%) VMware
10 15 (3.16%) Veeam
11 14 (2.95%) SAP
12 13 (2.74%) Cognos
13 11 (2.32%) Salesforce.com
14 9 (1.89%) Atlassian
15 6 (1.26%) Citrix
16 5 (1.05%) Cloudera
17 4 (0.84%) Alteryx
17 4 (0.84%) Netezza
17 4 (0.84%) RedGate