Period
to 23 February 2020

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 23 February 2020 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > London
6 months to
23 Feb 2020
Same period 2019 Same period 2018
Rank 93 89 109
Rank change year-on-year -4 +20 -20
Permanent jobs citing Data Warehouse 1,688 2,216 2,122
As % of all permanent IT jobs advertised in London 3.37% 3.55% 3.03%
As % of the Database & Business Intelligence category 12.18% 12.04% 9.97%
Number of salaries quoted 1,416 1,821 1,647
London median annual salary £67,500 £60,000 £60,000
Median salary % change year-on-year +12.50% - -
10th Percentile £45,000 £41,250 £40,400
90th Percentile £94,375 £87,500 £87,500
England median annual salary £60,000 £55,000 £52,000
% change year-on-year +9.09% +5.77% -2.35%

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 13,862 18,402 21,288
As % of all permanent IT jobs advertised in London 27.64% 29.51% 30.38%
Number of salaries quoted 11,399 15,233 17,595
London median annual salary £65,000 £62,500 £60,000
Median salary % change year-on-year +4.00% +4.17% +4.35%
10th Percentile £38,750 £37,500 £37,500
90th Percentile £105,000 £95,000 £90,000
England median annual salary £53,869 £52,500 £50,000
% change year-on-year +2.61% +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 23 February 2020.

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 23 February 2020. 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 +18 395 £70,000 +16.67% 98
West London -20 61 £65,000 +23.81% 28
South London +20 39 £62,500 +8.70% 4
North London -6 16 £60,000 +2.56% 4
East London -1 10 £57,500 -8.00% 2
Data Warehouse
England

For the 6 months to 23 February 2020, 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,177 (69.73%) SQL
2 978 (57.94%) Business Intelligence
3 795 (47.10%) ETL
4 731 (43.31%) SQL Server
5 598 (35.43%) Azure
6 594 (35.19%) Analytics
7 518 (30.69%) SQL Server Integration Services
8 517 (30.63%) Power Platform
9 513 (30.39%) Power BI
10 511 (30.27%) Python
11 494 (29.27%) Agile Software Development
12 471 (27.90%) Microsoft
13 447 (26.48%) Data Modelling
14 434 (25.71%) Finance
15 363 (21.50%) SQL Server Analysis Services
16 358 (21.21%) Big Data
17 330 (19.55%) AWS
18 303 (17.95%) SQL Server Reporting Services
19 299 (17.71%) Tableau
20 289 (17.12%) Visualisation
21 287 (17.00%) Data Lake
22 268 (15.88%) Analytical Skills
23 257 (15.23%) Migration
23 257 (15.23%) Oracle
24 250 (14.81%) T-SQL
25 229 (13.57%) Data Science
26 210 (12.44%) C#
27 209 (12.38%) Java
28 199 (11.79%) Data Management
29 197 (11.67%) Data Quality

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 184 (10.90%) Apache Spark
2 73 (4.32%) Apache Airflow
3 66 (3.91%) Apache
4 26 (1.54%) SAS
5 24 (1.42%) Confluence
6 19 (1.13%) SharePoint
7 14 (0.83%) Apache Pig
8 12 (0.71%) IIS
9 11 (0.65%) Elasticsearch
10 9 (0.53%) Luigi
10 9 (0.53%) MQSeries
10 9 (0.53%) Oracle SOA Suite
11 7 (0.41%) Oracle Workflow
12 4 (0.24%) MS Exchange
12 4 (0.24%) Tomcat
13 3 (0.18%) Apache Solr
13 3 (0.18%) IBM HTTP Server
13 3 (0.18%) PowerExchange
14 2 (0.12%) BizTalk Server
14 2 (0.12%) nginx
Applications
1 97 (5.75%) Microsoft Excel
2 37 (2.19%) Microsoft Office
3 13 (0.77%) Microsoft PowerPoint
4 4 (0.24%) MS Visio
5 3 (0.18%) Spreadsheet
6 2 (0.12%) SPSS
7 1 (0.059%) InfoPath
7 1 (0.059%) SPSS Modeler
Business Applications
1 19 (1.13%) Dynamics CRM
2 15 (0.89%) Cognos Business Intelligence
3 7 (0.41%) Markit EDM
4 5 (0.30%) RiskWrite
5 4 (0.24%) Sparx Enterprise Architect
6 3 (0.18%) Hyperion Planning
6 3 (0.18%) Oracle EBS R12
7 2 (0.12%) Eagle PACE
7 2 (0.12%) Eikon
7 2 (0.12%) FastStats
7 2 (0.12%) NetSuite
7 2 (0.12%) Oracle Applications
7 2 (0.12%) Oracle ERP
7 2 (0.12%) Oracle Financials
7 2 (0.12%) Remedy ITSM
7 2 (0.12%) SAP MDG
7 2 (0.12%) SimCorp Dimension
7 2 (0.12%) thinkFolio
8 1 (0.059%) PolarLake
8 1 (0.059%) SAP FI
Cloud Services
1 598 (35.43%) Azure
2 517 (30.63%) Power Platform
3 330 (19.55%) AWS
4 155 (9.18%) GCP
5 126 (7.46%) Azure Data Factory
6 70 (4.15%) PaaS
7 56 (3.32%) Amazon S3
8 54 (3.20%) Serverless
9 47 (2.78%) SaaS
10 30 (1.78%) Data Lake Analytics
11 29 (1.72%) AWS Lambda
11 29 (1.72%) GitHub
12 27 (1.60%) Google Analytics
13 24 (1.42%) Cloud Computing
14 23 (1.36%) IaaS
15 21 (1.24%) Azure Stack
16 20 (1.18%) Azure Functions
17 19 (1.13%) Amazon EC2
18 17 (1.01%) Amazon Kinesis
19 16 (0.95%) Amazon EMR
Communications & Networking
1 11 (0.65%) FTP
1 11 (0.65%) Internet
2 4 (0.24%) Radio Access Network
3 2 (0.12%) Extranet
3 2 (0.12%) Intranet
3 2 (0.12%) SAN
3 2 (0.12%) Skype
4 1 (0.059%) DMZ
4 1 (0.059%) iSCSI
4 1 (0.059%) LAN
4 1 (0.059%) NAS
4 1 (0.059%) TCP/IP
4 1 (0.059%) VLAN
4 1 (0.059%) VoIP
4 1 (0.059%) WAN
4 1 (0.059%) Wi-Fi
Database & Business Intelligence
1 731 (43.31%) SQL Server
2 518 (30.69%) SQL Server Integration Services
3 513 (30.39%) Power BI
4 363 (21.50%) SQL Server Analysis Services
5 358 (21.21%) Big Data
6 303 (17.95%) SQL Server Reporting Services
7 287 (17.00%) Data Lake
8 182 (10.78%) Amazon Redshift
9 175 (10.37%) Relational Database
10 166 (9.83%) Azure SQL Database
11 163 (9.66%) Hadoop
12 161 (9.54%) Snowflake Schema
13 148 (8.77%) NoSQL
14 133 (7.88%) Microsoft Analysis Services
15 125 (7.41%) Azure SQL Data Warehouse
16 90 (5.33%) BigQuery
17 77 (4.56%) Looker
17 77 (4.56%) QlikView
18 75 (4.44%) Apache Hive
19 72 (4.27%) PostgreSQL
Development Applications
1 76 (4.50%) Git (software)
2 55 (3.26%) JIRA
3 42 (2.49%) Visual Studio
4 38 (2.25%) Team Foundation Server
5 36 (2.13%) Visual Studio Team System
6 20 (1.18%) SQL Server Management Studio (SSMS)
7 19 (1.13%) Jenkins
8 12 (0.71%) ProC
8 12 (0.71%) TeamCity
9 11 (0.65%) ERwin
10 9 (0.53%) Subversion
11 8 (0.47%) kappa
12 7 (0.41%) PowerDesigner
13 6 (0.36%) Oracle Forms
14 5 (0.30%) Bitbucket
14 5 (0.30%) Eclipse
14 5 (0.30%) JUnit
15 4 (0.24%) GoCD
15 4 (0.24%) PyCharm
16 3 (0.18%) Octopus Deploy
General
1 434 (25.71%) Finance
2 81 (4.80%) Marketing
3 69 (4.09%) Banking
4 67 (3.97%) Retail
5 42 (2.49%) Games
6 39 (2.31%) Legal
7 26 (1.54%) Publishing
8 25 (1.48%) Advertising
9 18 (1.07%) Law
10 15 (0.89%) Public Sector
10 15 (0.89%) Telecoms
11 14 (0.83%) Financial Institution
11 14 (0.83%) Front Office
12 9 (0.53%) Investment Banking
13 6 (0.36%) iGaming
14 4 (0.24%) Automotive
14 4 (0.24%) Pharmaceutical
14 4 (0.24%) Police
15 3 (0.18%) Back Office
15 3 (0.18%) Billing
Job Titles
1 564 (33.41%) Developer
2 282 (16.71%) Data Engineer
3 254 (15.05%) Analyst
4 250 (14.81%) Architect
5 231 (13.68%) Business Intelligence Developer
6 194 (11.49%) SQL Developer
7 173 (10.25%) Data Architect
8 101 (5.98%) Business Intelligence Analyst
9 100 (5.92%) Senior Developer
10 98 (5.81%) Data Warehouse Developer
11 82 (4.86%) Data Analyst
12 76 (4.50%) Azure Engineer
13 75 (4.44%) ETL Developer
14 74 (4.38%) Consultant
15 72 (4.27%) Business Analyst
16 64 (3.79%) Data Warehouse Architect
17 60 (3.55%) SQL Server Developer
18 58 (3.44%) SSIS Developer
19 51 (3.02%) DBA
20 48 (2.84%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 143 (8.47%) .NET
2 106 (6.28%) Kafka
3 90 (5.33%) Web Services
4 66 (3.91%) MDX
5 52 (3.08%) XML
6 40 (2.37%) HTML
7 39 (2.31%) JSON
8 32 (1.90%) REST
9 29 (1.72%) ASP.NET
10 27 (1.60%) React
11 23 (1.36%) AngularJS
12 17 (1.01%) D3.js
13 16 (0.95%) .NET Framework
14 15 (0.89%) Vue.js
15 14 (0.83%) CSS
15 14 (0.83%) RESTful
16 13 (0.77%) RabbitMQ
16 13 (0.77%) SOAP
17 12 (0.71%) Apache NiFi
18 11 (0.65%) Pandas
Miscellaneous
1 268 (15.88%) Analytical Skills
2 97 (5.75%) Data Structures
3 87 (5.15%) Management Information System
4 79 (4.68%) Greenfield Project
5 38 (2.25%) Reinsurance
6 37 (2.19%) Algorithms
7 28 (1.66%) Self-Motivation
8 24 (1.42%) Public Cloud
9 19 (1.13%) User Experience
9 19 (1.13%) Virtual Team
10 17 (1.01%) Foreign Exchange (FX)
11 11 (0.65%) NHS
11 11 (0.65%) Online Games
11 11 (0.65%) Reference Data
12 9 (0.53%) Private Cloud
12 9 (0.53%) Taxonomies
13 8 (0.47%) AS400
13 8 (0.47%) Fixed Income
13 8 (0.47%) FMCG
13 8 (0.47%) iSeries
Operating Systems
1 61 (3.61%) Windows
2 53 (3.14%) Linux
3 34 (2.01%) Unix
4 33 (1.95%) Windows Server
5 10 (0.59%) Windows 10
5 10 (0.59%) Windows 7
6 6 (0.36%) Windows 2000
6 6 (0.36%) Windows XP
7 4 (0.24%) Solaris
8 3 (0.18%) Android
8 3 (0.18%) Apple iOS
8 3 (0.18%) Oracle Linux
8 3 (0.18%) Windows Server 2008
8 3 (0.18%) Windows Server 2012
9 2 (0.12%) CentOS
10 1 (0.059%) AIX
Processes & Methodologies
1 978 (57.94%) Business Intelligence
2 795 (47.10%) ETL
3 594 (35.19%) Analytics
4 494 (29.27%) Agile Software Development
5 447 (26.48%) Data Modelling
6 289 (17.12%) Visualisation
7 257 (15.23%) Migration
8 229 (13.57%) Data Science
9 199 (11.79%) Data Management
10 187 (11.08%) DevOps
11 184 (10.90%) Problem-Solving
12 183 (10.84%) Data Visualisation
13 171 (10.13%) Data Architecture
14 150 (8.89%) Data Engineering
15 143 (8.47%) Data Integration
16 130 (7.70%) Data Analytics
17 127 (7.52%) Machine Learning
18 124 (7.35%) Decision-Making
19 122 (7.23%) Computer Science
20 121 (7.17%) Data Analysis
Programming Languages
1 1,177 (69.73%) SQL
2 511 (30.27%) Python
3 250 (14.81%) T-SQL
4 210 (12.44%) C#
5 209 (12.38%) Java
6 143 (8.47%) R
7 110 (6.52%) PL/SQL
8 102 (6.04%) Data Analysis Expressions (DAX)
9 93 (5.51%) Scala
10 43 (2.55%) PowerShell
11 40 (2.37%) JavaScript
11 40 (2.37%) VBA
12 34 (2.01%) Shell Script
13 30 (1.78%) Java 8
14 29 (1.72%) VB
15 24 (1.42%) U-SQL
16 23 (1.36%) C
17 20 (1.18%) VB.NET
18 11 (0.65%) PHP
18 11 (0.65%) TypeScript
Qualifications
1 166 (9.83%) Degree
2 92 (5.45%) Computer Science Degree
3 16 (0.95%) Master's Degree
3 16 (0.95%) MBA
4 13 (0.77%) Microsoft Certification
5 9 (0.53%) TOGAF Certification
6 8 (0.47%) ITIL Foundation Certificate
7 7 (0.41%) AWS Certification
7 7 (0.41%) PRINCE2 Practitioner
7 7 (0.41%) Security Cleared
8 6 (0.36%) Numerate Degree
8 6 (0.36%) PhD
9 5 (0.30%) ISTQB
9 5 (0.30%) Postgraduate
10 3 (0.18%) SC Cleared
11 2 (0.12%) MCITP
11 2 (0.12%) MCSA
12 1 (0.059%) ITIL Certification
12 1 (0.059%) PMI Certification
12 1 (0.059%) PMP
Quality Assurance & Compliance
1 197 (11.67%) Data Quality
2 87 (5.15%) QA
3 21 (1.24%) GDPR
4 7 (0.41%) Actionable Recommendations
5 3 (0.18%) ISO/IEC 27001
5 3 (0.18%) PMO
5 3 (0.18%) UCITS
6 2 (0.12%) EMIR
6 2 (0.12%) MiFID
7 1 (0.059%) Basel III
7 1 (0.059%) HL7
7 1 (0.059%) IFRS
7 1 (0.059%) IFRS 9
System Software
1 41 (2.43%) Docker
2 23 (1.36%) HDFS
3 10 (0.59%) Apache Flume
4 5 (0.30%) Active Directory
5 4 (0.24%) Virtual Machines
6 3 (0.18%) VMware Infrastructure
7 2 (0.12%) Apache ZooKeeper
7 2 (0.12%) Varnish
8 1 (0.059%) Cronacle
8 1 (0.059%) Postfix
8 1 (0.059%) vSphere
Systems Management
1 42 (2.49%) Kubernetes
2 24 (1.42%) Control-M
3 18 (1.07%) Opscode Chef
4 15 (0.89%) Ansible
5 14 (0.83%) Puppet
5 14 (0.83%) Terraform
6 12 (0.71%) Oozie
7 9 (0.53%) Hadoop YARN
8 5 (0.30%) BladeLogic
9 3 (0.18%) Salt
10 2 (0.12%) Failover Clustering
10 2 (0.12%) Perfmon
11 1 (0.059%) Data Guard
11 1 (0.059%) HP Quality Center
11 1 (0.059%) Kibana
11 1 (0.059%) Kubeflow
11 1 (0.059%) Matomo
11 1 (0.059%) Mesos
11 1 (0.059%) Microsoft Clustering
Vendors
1 471 (27.90%) Microsoft
2 299 (17.71%) Tableau
3 257 (15.23%) Oracle
4 150 (8.89%) Google
5 124 (7.35%) Informatica
6 103 (6.10%) Databricks
7 69 (4.09%) Teradata
8 65 (3.85%) SAP
9 55 (3.26%) Talend
10 51 (3.02%) IBM
11 41 (2.43%) Cognos
12 30 (1.78%) MicroStrategy
13 26 (1.54%) Salesforce.com
14 25 (1.48%) Alteryx
15 24 (1.42%) Netezza
16 22 (1.30%) Hortonworks
17 21 (1.24%) Cloudera
18 19 (1.13%) Sybase
19 18 (1.07%) RedGate
20 15 (0.89%) Guidewire