Period
to 21 May 2019

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

Data Warehousing
England > London
6 months to
21 May 2019
Same period 2018 Same period 2017
Rank 79 97 95
Rank change year-on-year +18 -2 -23
Permanent jobs citing Data Warehouse 2,233 2,251 2,193
As % of all permanent IT jobs advertised in London 3.83% 3.27% 3.22%
As % of the Database & Business Intelligence category 13.26% 10.44% 10.58%
Number of salaries quoted 1,846 1,836 1,872
London median annual salary £62,500 £60,000 £60,000
Median salary % change year-on-year +4.17% - +4.35%
10th Percentile £42,500 £40,125 £38,750
90th Percentile £88,750 £88,750 £90,000
England median annual salary £55,000 £52,500 £51,500
% change year-on-year +4.76% +1.94% -1.90%

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 16,845 21,569 20,726
As % of all permanent IT jobs advertised in London 28.88% 31.32% 30.43%
Number of salaries quoted 13,996 17,245 17,826
London median annual salary £65,000 £60,000 £60,000
Median salary % change year-on-year +8.33% - +9.09%
10th Percentile £38,750 £37,500 £36,250
90th Percentile £95,000 £92,500 £90,000
England median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% -

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 21 May 2019.

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 21 May 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
Central London +1 512 £62,500 -3.85% 63
West London +32 109 £52,500 -4.55% 8
South London -19 26 £52,500 +2.94% 1
East London +19 19 £45,000 -33.33% 3
North London +9 5 £65,000 +52.94% 1
Data Warehouse
England

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

1 1,396 (62.52%) SQL
2 1,336 (59.83%) Business Intelligence
3 978 (43.80%) ETL
4 924 (41.38%) SQL Server
5 891 (39.90%) SQL Server Integration Services
6 800 (35.83%) Agile Software Development
7 770 (34.48%) Analytics
8 709 (31.75%) SQL Server Reporting Services
9 678 (30.36%) SQL Server Analysis Services
10 663 (29.69%) Microsoft Azure
10 663 (29.69%) Microsoft
11 633 (28.35%) Finance
12 594 (26.60%) Power BI
12 594 (26.60%) Power Platform
13 559 (25.03%) Data Modelling
14 473 (21.18%) T-SQL
15 469 (21.00%) Python
16 420 (18.81%) Big Data
17 410 (18.36%) Tableau
18 344 (15.41%) Visualisation
19 343 (15.36%) Oracle
20 334 (14.96%) Amazon AWS
21 307 (13.75%) Analytical Skills
22 300 (13.43%) Kimball Methodology
23 281 (12.58%) C#
23 281 (12.58%) Scrum
24 270 (12.09%) Hadoop
25 268 (12.00%) Java
26 265 (11.87%) Data Lake
27 254 (11.37%) Problem-Solving

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 170 (7.61%) Apache Spark
2 58 (2.60%) SharePoint
3 53 (2.37%) SAS
4 51 (2.28%) Apache
5 46 (2.06%) Apache Pig
6 42 (1.88%) Elasticsearch
7 20 (0.90%) Apache Solr
8 17 (0.76%) Confluence
9 13 (0.58%) Oracle SOA Suite
10 12 (0.54%) Apache Airflow
11 6 (0.27%) BizTalk Server
11 6 (0.27%) IIS
12 5 (0.22%) CMS
12 5 (0.22%) WebLogic
13 3 (0.13%) Oracle Service Bus
14 2 (0.090%) ArcGIS
14 2 (0.090%) Luigi
14 2 (0.090%) MS Exchange
15 1 (0.045%) Tomcat
15 1 (0.045%) WildFly
Applications
1 115 (5.15%) Microsoft Excel
2 46 (2.06%) Microsoft Office
3 30 (1.34%) MS Visio
4 14 (0.63%) Microsoft Project
5 12 (0.54%) Microsoft PowerPoint
6 11 (0.49%) SPSS
7 5 (0.22%) Spreadsheet
8 2 (0.090%) Mingle
9 1 (0.045%) Chatbot
9 1 (0.045%) GNU Octave
Business Applications
1 19 (0.85%) Dynamics CRM
2 11 (0.49%) Infor SunSystems
3 8 (0.36%) FastStats
3 8 (0.36%) Markit EDM
4 6 (0.27%) Maximo
5 5 (0.22%) Cognos TM1
6 4 (0.18%) Cognos Business Intelligence
6 4 (0.18%) SAP BPC
7 3 (0.13%) Oracle Applications
7 3 (0.13%) SAP ERP
8 2 (0.090%) Adobe Campaign
8 2 (0.090%) Orchestrade
8 2 (0.090%) SAP S/4HANA
9 1 (0.045%) MIS ActiveH
9 1 (0.045%) Oracle Payables
9 1 (0.045%) Oracle Procure-to-Pay
9 1 (0.045%) Oracle Receivables
9 1 (0.045%) Raiser's Edge
9 1 (0.045%) Salesforce.com CRM
9 1 (0.045%) Siebel CRM
Cloud Services
1 663 (29.69%) Microsoft Azure
2 594 (26.60%) Power Platform
3 334 (14.96%) Amazon AWS
4 139 (6.22%) Azure Data Factory
5 130 (5.82%) Google Cloud Platform
6 75 (3.36%) SaaS
7 63 (2.82%) PaaS
8 40 (1.79%) Data Lake Analytics
8 40 (1.79%) Serverless
9 33 (1.48%) Cloud Computing
10 30 (1.34%) Amazon S3
11 28 (1.25%) Amazon EMR
12 27 (1.21%) Azure Machine Learning
13 26 (1.16%) Cortana Intelligence Suite
14 24 (1.07%) Azure Stack
15 21 (0.94%) GitHub
16 20 (0.90%) Azure Functions
17 18 (0.81%) PowerApps
18 17 (0.76%) IaaS
19 16 (0.72%) AWS Lambda
Communications & Networking
1 13 (0.58%) Internet
2 11 (0.49%) FTP
3 7 (0.31%) Wi-Fi
4 5 (0.22%) DNS
4 5 (0.22%) HTTP
5 4 (0.18%) VoIP
6 3 (0.13%) SAN
7 2 (0.090%) DHCP
7 2 (0.090%) Extranet
7 2 (0.090%) TCP/IP
8 1 (0.045%) Kerberos
Database & Business Intelligence
1 924 (41.38%) SQL Server
2 891 (39.90%) SQL Server Integration Services
3 709 (31.75%) SQL Server Reporting Services
4 678 (30.36%) SQL Server Analysis Services
5 594 (26.60%) Power BI
6 420 (18.81%) Big Data
7 270 (12.09%) Hadoop
8 265 (11.87%) Data Lake
9 228 (10.21%) Relational Database
10 201 (9.00%) NoSQL
11 190 (8.51%) Azure SQL Database
12 157 (7.03%) BusinessObjects
13 146 (6.54%) QlikView
14 136 (6.09%) Azure SQL Data Warehouse
15 133 (5.96%) Amazon Redshift
16 131 (5.87%) SQL Server 2012
17 122 (5.46%) Apache Hive
18 121 (5.42%) SQL Server 2016
19 118 (5.28%) OLAP
20 112 (5.02%) Microsoft Analysis Services
Development Applications
1 74 (3.31%) Git (software)
2 54 (2.42%) JIRA
2 54 (2.42%) Visual Studio
3 49 (2.19%) Team Foundation Server
4 30 (1.34%) Jenkins
5 20 (0.90%) Selenium
6 19 (0.85%) Subversion
7 18 (0.81%) ERwin
7 18 (0.81%) ProC
7 18 (0.81%) SQL Server Management Studio (SSMS)
7 18 (0.81%) Visual Studio Team System
8 15 (0.67%) ER Studio
8 15 (0.67%) TeamCity
9 14 (0.63%) Cucumber
9 14 (0.63%) Octopus Deploy
9 14 (0.63%) Oracle Forms
10 12 (0.54%) Bitbucket
10 12 (0.54%) Maven
11 8 (0.36%) Hudson
12 7 (0.31%) Balsamiq
General
1 633 (28.35%) Finance
2 216 (9.67%) Banking
3 199 (8.91%) Retail
4 94 (4.21%) Marketing
5 68 (3.05%) Investment Banking
6 44 (1.97%) Legal
7 43 (1.93%) Law
8 32 (1.43%) Advertising
9 19 (0.85%) Telecoms
10 18 (0.81%) Financial Institution
11 13 (0.58%) Back Office
11 13 (0.58%) Front Office
12 11 (0.49%) Games
13 10 (0.45%) General Ledger
14 8 (0.36%) Manufacturing
15 6 (0.27%) Corporate Banking
16 5 (0.22%) Electronics
17 4 (0.18%) French Language
17 4 (0.18%) Publishing
17 4 (0.18%) Retail Banking
Job Titles
1 894 (40.04%) Developer
2 444 (19.88%) Business Intelligence Developer
3 348 (15.58%) SQL Developer
4 323 (14.46%) Analyst
5 279 (12.49%) Architect
6 240 (10.75%) Data Engineer
7 187 (8.37%) SQL BI Developer
8 168 (7.52%) Data Warehouse Developer
9 167 (7.48%) Data Architect
10 146 (6.54%) Senior Developer
11 119 (5.33%) Business Intelligence Analyst
12 107 (4.79%) Data Analyst
13 101 (4.52%) SSRS Developer
14 95 (4.25%) SQL Server Developer
14 95 (4.25%) SSIS Developer
15 94 (4.21%) ETL Developer
16 89 (3.99%) Consultant
17 88 (3.94%) Solutions Architect
18 81 (3.63%) Senior Business Intelligence Developer
19 76 (3.40%) Project Manager
Libraries, Frameworks & Software Standards
1 220 (9.85%) .NET
2 156 (6.99%) Kafka
3 123 (5.51%) MDX
4 103 (4.61%) Web Services
5 63 (2.82%) XML
6 54 (2.42%) HTML
7 47 (2.10%) JSON
8 45 (2.02%) REST
9 37 (1.66%) CSS
10 33 (1.48%) AngularJS
11 26 (1.16%) RESTful
12 25 (1.12%) Middleware
13 24 (1.07%) React
13 24 (1.07%) WCF
14 21 (0.94%) .NET Framework
15 19 (0.85%) ASP.NET Web API
15 19 (0.85%) Spark Streaming
16 16 (0.72%) ASP.NET
16 16 (0.72%) Entity Framework
16 16 (0.72%) WinForms
Miscellaneous
1 307 (13.75%) Analytical Skills
2 102 (4.57%) Data Structures
3 88 (3.94%) Fintech
4 73 (3.27%) Greenfield Project
5 68 (3.05%) Management Information System
6 66 (2.96%) Self-Motivation
7 49 (2.19%) Data Centre
8 41 (1.84%) Clustering
9 39 (1.75%) Replication
10 35 (1.57%) Reinsurance
11 32 (1.43%) Algorithms
12 27 (1.21%) Hedge funds
13 26 (1.16%) Credit Risk
13 26 (1.16%) Market Risk
14 24 (1.07%) Virtual Team
15 23 (1.03%) User Experience
16 22 (0.99%) Enterprise Software
16 22 (0.99%) Reference Data
17 14 (0.63%) Mobile App
17 14 (0.63%) NHS
Operating Systems
1 114 (5.11%) Unix
2 103 (4.61%) Linux
3 70 (3.13%) Windows
4 19 (0.85%) Red Hat Enterprise Linux
5 12 (0.54%) Apple iOS
6 10 (0.45%) Windows Server
7 7 (0.31%) Windows Server 2012
8 6 (0.27%) CentOS
8 6 (0.27%) Ubuntu
9 5 (0.22%) Mac OS X
10 4 (0.18%) Oracle Linux
11 3 (0.13%) Solaris
11 3 (0.13%) Windows 7
12 2 (0.090%) Windows 10
13 1 (0.045%) VMS
13 1 (0.045%) Windows Server 2008
13 1 (0.045%) Windows XP
Processes & Methodologies
1 1,336 (59.83%) Business Intelligence
2 978 (43.80%) ETL
3 800 (35.83%) Agile Software Development
4 770 (34.48%) Analytics
5 559 (25.03%) Data Modelling
6 344 (15.41%) Visualisation
7 300 (13.43%) Kimball Methodology
8 281 (12.58%) Scrum
9 254 (11.37%) Problem-Solving
10 249 (11.15%) Data Management
11 241 (10.79%) Data Analytics
12 224 (10.03%) Migration
13 223 (9.99%) Data Science
14 202 (9.05%) Data Architecture
14 202 (9.05%) Data Visualisation
15 196 (8.78%) Data Analysis
16 190 (8.51%) SDLC
17 181 (8.11%) DevOps
18 178 (7.97%) Machine Learning
19 163 (7.30%) Data Integration
Programming Languages
1 1,396 (62.52%) SQL
2 473 (21.18%) T-SQL
3 469 (21.00%) Python
4 281 (12.58%) C#
5 268 (12.00%) Java
6 156 (6.99%) PL/SQL
7 155 (6.94%) Data Analysis Expressions (DAX)
8 145 (6.49%) R
9 105 (4.70%) Scala
10 98 (4.39%) JavaScript
11 70 (3.13%) PowerShell
12 65 (2.91%) VBA
13 42 (1.88%) C
14 36 (1.61%) Shell Script
15 30 (1.34%) VB
16 29 (1.30%) PHP
17 24 (1.07%) Go
17 24 (1.07%) VB.NET
18 20 (0.90%) MATLAB
19 14 (0.63%) Korn
Qualifications
1 203 (9.09%) Degree
2 61 (2.73%) Microsoft Certification
3 58 (2.60%) Computer Science Degree
4 45 (2.02%) Security Cleared
5 32 (1.43%) MCSA
6 18 (0.81%) Master's Degree
6 18 (0.81%) TOGAF Certification
7 16 (0.72%) MCSE
8 11 (0.49%) SC Cleared
9 10 (0.45%) MCT
9 10 (0.45%) Numerate Degree
9 10 (0.45%) PMP
10 9 (0.40%) PMI Certification
10 9 (0.40%) PRINCE2 Certification
11 6 (0.27%) ITIL Certification
11 6 (0.27%) MCP
12 5 (0.22%) AWS Certification
12 5 (0.22%) MCDBA
13 4 (0.18%) PhD
14 3 (0.13%) ISEB
Quality Assurance & Compliance
1 234 (10.48%) Data Quality
2 93 (4.16%) QA
3 74 (3.31%) GDPR
4 15 (0.67%) Solvency II
5 8 (0.36%) SLA
6 7 (0.31%) HIPAA
6 7 (0.31%) MiFID
7 6 (0.27%) IFRS
7 6 (0.27%) ISO/IEC 27001
8 5 (0.22%) PCI DSS
8 5 (0.22%) PMO
9 1 (0.045%) COBIT
9 1 (0.045%) FedRAMP
9 1 (0.045%) NIST 800
System Software
1 53 (2.37%) HDFS
2 48 (2.15%) Docker
3 47 (2.10%) Apache Flume
4 25 (1.12%) VMware Infrastructure
5 13 (0.58%) Active Directory
6 6 (0.27%) Oracle RAC
7 5 (0.22%) Apache ZooKeeper
8 3 (0.13%) Cronacle
8 3 (0.13%) etcd
8 3 (0.13%) Veritas File System
8 3 (0.13%) Veritas Volume Manager
9 2 (0.090%) Virtual Machines
10 1 (0.045%) Varnish
Systems Management
1 38 (1.70%) Hadoop YARN
2 36 (1.61%) Kubernetes
3 32 (1.43%) Terraform
4 26 (1.16%) Oozie
5 25 (1.12%) Ambari
6 23 (1.03%) Failover Clustering
7 21 (0.94%) Perfmon
8 14 (0.63%) Ansible
9 13 (0.58%) Control-M
9 13 (0.58%) Opscode Chef
10 11 (0.49%) Puppet
11 5 (0.22%) logstash
12 4 (0.18%) Data Guard
12 4 (0.18%) Dollar Universe
12 4 (0.18%) Grafana
12 4 (0.18%) HP Quality Center
12 4 (0.18%) Oracle Enterprise Manager
12 4 (0.18%) Oracle RMAN
13 3 (0.13%) Consul
13 3 (0.13%) SQL Sentry
Vendors
1 663 (29.69%) Microsoft
2 410 (18.36%) Tableau
3 343 (15.36%) Oracle
4 186 (8.33%) Informatica
5 166 (7.43%) SAP
6 117 (5.24%) Google
7 106 (4.75%) Databricks
8 102 (4.57%) IBM
9 100 (4.48%) Talend
10 65 (2.91%) Cloudera
11 54 (2.42%) Teradata
12 49 (2.19%) Cognos
13 38 (1.70%) Hortonworks
14 29 (1.30%) MicroStrategy
15 28 (1.25%) VMware
16 26 (1.16%) Greenplum
16 26 (1.16%) MapR
16 26 (1.16%) RedGate
17 25 (1.12%) HP
18 22 (0.99%) Red Hat