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

Data Warehousing
England > London
6 months to
6 Dec 2019
Same period 2018 Same period 2017
Rank 86 87 104
Rank change year-on-year +1 +17 -15
Permanent jobs citing Data Warehouse 2,020 2,404 2,361
As % of all permanent IT jobs advertised in London 3.73% 3.58% 3.16%
As % of the Database & Business Intelligence category 13.29% 11.97% 10.69%
Number of salaries quoted 1,666 1,979 1,710
London median annual salary £65,000 £62,500 £60,000
Median salary % change year-on-year +4.00% +4.17% -
10th Percentile £42,500 £41,202 £40,000
90th Percentile £92,500 £88,750 £87,500
England median annual salary £57,275 £55,000 £52,500
% change year-on-year +4.14% +4.76% -4.55%

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 15,204 20,077 22,087
As % of all permanent IT jobs advertised in London 28.06% 29.89% 29.54%
Number of salaries quoted 12,622 16,497 17,759
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 £36,250
90th Percentile £100,000 £95,000 £88,750
England median annual salary £52,500 £52,500 £50,000
% 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 6 December 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 6 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
Central London +46 571 £65,000 +4.00% 88
West London +2 83 £60,000 +20.00% 27
South London -7 45 £62,500 +13.64% 7
East London +32 30 £45,000 -26.53% 10
North London +7 15 £60,000 +6.67% 2
Data Warehouse
England

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

1 1,333 (65.99%) SQL
2 1,197 (59.26%) Business Intelligence
3 917 (45.40%) ETL
4 869 (43.02%) SQL Server
5 706 (34.95%) SQL Server Integration Services
6 685 (33.91%) Analytics
7 617 (30.54%) Azure
8 599 (29.65%) Power BI
8 599 (29.65%) Power Platform
9 572 (28.32%) Agile Software Development
10 571 (28.27%) Microsoft
11 540 (26.73%) SQL Server Analysis Services
12 534 (26.44%) Finance
13 528 (26.14%) Data Modelling
14 489 (24.21%) SQL Server Reporting Services
15 460 (22.77%) Python
16 437 (21.63%) Big Data
17 398 (19.70%) T-SQL
18 383 (18.96%) Visualisation
19 352 (17.43%) AWS
20 318 (15.74%) Tableau
21 286 (14.16%) Oracle
22 284 (14.06%) Analytical Skills
23 279 (13.81%) Data Management
24 275 (13.61%) C#
25 262 (12.97%) Data Lake
26 260 (12.87%) Data Quality
27 256 (12.67%) Migration
28 239 (11.83%) Data Science
29 226 (11.19%) DevOps

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 169 (8.37%) Apache Spark
2 63 (3.12%) Apache
3 58 (2.87%) Apache Airflow
4 51 (2.52%) SAS
5 43 (2.13%) SharePoint
6 24 (1.19%) Confluence
7 22 (1.09%) Oracle SOA Suite
8 18 (0.89%) IIS
9 16 (0.79%) Apache Pig
10 10 (0.50%) Elasticsearch
11 6 (0.30%) Apache Solr
11 6 (0.30%) Luigi
12 5 (0.25%) MQSeries
12 5 (0.25%) MS Exchange
12 5 (0.25%) Oracle Workflow
13 4 (0.20%) SharePoint 2013
14 3 (0.15%) ArcGIS
14 3 (0.15%) PowerExchange
14 3 (0.15%) Tomcat
15 2 (0.099%) SugarCRM
Applications
1 158 (7.82%) Microsoft Excel
2 44 (2.18%) Microsoft Office
3 11 (0.54%) MS Visio
4 10 (0.50%) Microsoft PowerPoint
5 5 (0.25%) Spreadsheet
6 4 (0.20%) Microsoft Project
7 2 (0.099%) SPSS
8 1 (0.050%) Adobe Premiere
8 1 (0.050%) SPSS Modeler
Business Applications
1 32 (1.58%) Dynamics CRM
2 12 (0.59%) Cognos Business Intelligence
3 8 (0.40%) Markit EDM
4 5 (0.25%) Dynamics NAV
4 5 (0.25%) FastStats
5 4 (0.20%) Hyperion Planning
5 4 (0.20%) Oracle ERP
5 4 (0.20%) Sparx Enterprise Architect
6 3 (0.15%) Adobe Campaign
6 3 (0.15%) Dynamics AX
6 3 (0.15%) Eagle PACE
6 3 (0.15%) Oracle EBS
7 2 (0.099%) Eikon
7 2 (0.099%) Oracle Applications
7 2 (0.099%) Oracle EBS R12
7 2 (0.099%) Oracle Financials
7 2 (0.099%) Remedy ITSM
7 2 (0.099%) RiskWrite
7 2 (0.099%) SAP MDG
7 2 (0.099%) thinkFolio
Cloud Services
1 617 (30.54%) Azure
2 599 (29.65%) Power Platform
3 352 (17.43%) AWS
4 157 (7.77%) GCP
5 114 (5.64%) Azure Data Factory
6 59 (2.92%) PaaS
7 51 (2.52%) Amazon S3
7 51 (2.52%) SaaS
8 50 (2.48%) Serverless
9 41 (2.03%) Google Analytics
10 29 (1.44%) Data Lake Analytics
10 29 (1.44%) GitHub
11 28 (1.39%) Azure Functions
11 28 (1.39%) Cloud Computing
12 23 (1.14%) AWS Lambda
13 16 (0.79%) IaaS
14 14 (0.69%) Azure Machine Learning
15 13 (0.64%) Office 365
16 12 (0.59%) Dynamics 365
17 11 (0.54%) Azure Stack
Communications & Networking
1 11 (0.54%) FTP
2 6 (0.30%) DNS
2 6 (0.30%) Network Security
3 5 (0.25%) SAN
4 4 (0.20%) DSL
4 4 (0.20%) Radio Access Network
5 3 (0.15%) DHCP
5 3 (0.15%) Firewall
5 3 (0.15%) TCP/IP
6 2 (0.099%) Internet
6 2 (0.099%) Kerberos
6 2 (0.099%) WLAN
7 1 (0.050%) Broadband
7 1 (0.050%) DMZ
7 1 (0.050%) iSCSI
7 1 (0.050%) NAS
7 1 (0.050%) Skype
7 1 (0.050%) VLAN
7 1 (0.050%) WAN
7 1 (0.050%) Wi-Fi
Database & Business Intelligence
1 869 (43.02%) SQL Server
2 706 (34.95%) SQL Server Integration Services
3 599 (29.65%) Power BI
4 540 (26.73%) SQL Server Analysis Services
5 489 (24.21%) SQL Server Reporting Services
6 437 (21.63%) Big Data
7 262 (12.97%) Data Lake
8 191 (9.46%) Relational Database
9 188 (9.31%) Hadoop
10 158 (7.82%) Azure SQL Database
11 154 (7.62%) Amazon Redshift
12 141 (6.98%) Microsoft Analysis Services
12 141 (6.98%) NoSQL
13 121 (5.99%) Azure SQL Data Warehouse
14 112 (5.54%) Snowflake Schema
15 100 (4.95%) Looker
16 97 (4.80%) PostgreSQL
17 96 (4.75%) OLAP
18 86 (4.26%) Apache Hive
19 84 (4.16%) QlikView
Development Applications
1 114 (5.64%) Git (software)
2 63 (3.12%) JIRA
3 59 (2.92%) Visual Studio
4 44 (2.18%) Team Foundation Server
5 32 (1.58%) Jenkins
6 25 (1.24%) Bitbucket
7 19 (0.94%) ERwin
8 18 (0.89%) Subversion
9 15 (0.74%) Atlassian Bamboo
9 15 (0.74%) ER Studio
9 15 (0.74%) Visual Studio Team System
10 14 (0.69%) Maven
10 14 (0.69%) PowerDesigner
11 13 (0.64%) Artifactory
11 13 (0.64%) Oracle APEX
11 13 (0.64%) Oracle Forms
11 13 (0.64%) ProC
11 13 (0.64%) Selenium
11 13 (0.64%) SQL Server Management Studio (SSMS)
12 10 (0.50%) TeamCity
General
1 534 (26.44%) Finance
2 105 (5.20%) Banking
3 100 (4.95%) Retail
4 86 (4.26%) Marketing
5 45 (2.23%) Games
6 38 (1.88%) Advertising
7 37 (1.83%) Telecoms
8 33 (1.63%) Legal
9 22 (1.09%) Public Sector
10 19 (0.94%) Law
11 18 (0.89%) Publishing
12 15 (0.74%) Investment Banking
13 14 (0.69%) Back Office
14 12 (0.59%) Financial Institution
15 7 (0.35%) Automotive
15 7 (0.35%) Pharmaceutical
16 6 (0.30%) iGaming
17 4 (0.20%) Front Office
18 3 (0.15%) Billing
19 2 (0.099%) French Language
Job Titles
1 756 (37.43%) Developer
2 336 (16.63%) Business Intelligence Developer
3 322 (15.94%) Analyst
4 275 (13.61%) SQL Developer
5 269 (13.32%) Data Engineer
6 252 (12.48%) Architect
7 171 (8.47%) Data Architect
8 127 (6.29%) Senior Developer
9 123 (6.09%) Data Analyst
10 120 (5.94%) Business Intelligence Analyst
11 104 (5.15%) Data Warehouse Developer
12 84 (4.16%) SQL BI Developer
12 84 (4.16%) SQL Server Developer
13 79 (3.91%) Consultant
14 73 (3.61%) Business Analyst
15 69 (3.42%) Database Developer
16 66 (3.27%) SSIS Developer
17 63 (3.12%) Senior SQL Developer
18 61 (3.02%) SSRS Developer
19 60 (2.97%) ETL Developer
Libraries, Frameworks & Software Standards
1 205 (10.15%) .NET
2 106 (5.25%) MDX
2 106 (5.25%) Web Services
3 81 (4.01%) Kafka
4 46 (2.28%) ASP.NET
4 46 (2.28%) XML
5 43 (2.13%) HTML
6 38 (1.88%) .NET Framework
6 38 (1.88%) REST
7 34 (1.68%) JSON
8 30 (1.49%) React
9 25 (1.24%) D3.js
10 23 (1.14%) AngularJS
11 19 (0.94%) Vue.js
12 17 (0.84%) Entity Framework
13 15 (0.74%) CSS
13 15 (0.74%) RESTful
14 14 (0.69%) Node.js
15 13 (0.64%) HTML5
16 12 (0.59%) WinForms
Miscellaneous
1 284 (14.06%) Analytical Skills
2 106 (5.25%) Management Information System
3 103 (5.10%) Data Structures
4 69 (3.42%) Greenfield Project
5 48 (2.38%) Reinsurance
6 45 (2.23%) Public Cloud
7 41 (2.03%) Self-Motivation
8 35 (1.73%) Algorithms
9 28 (1.39%) Data Centre
10 25 (1.24%) User Experience
11 21 (1.04%) Taxonomies
12 20 (0.99%) Private Cloud
13 17 (0.84%) Virtual Team
14 14 (0.69%) Derivative
15 13 (0.64%) NHS
16 12 (0.59%) Fixed Income
16 12 (0.59%) Hedge funds
17 11 (0.54%) AS400
17 11 (0.54%) iSeries
17 11 (0.54%) Reference Data
Operating Systems
1 102 (5.05%) Windows
2 61 (3.02%) Linux
3 59 (2.92%) Unix
4 54 (2.67%) Windows Server
5 10 (0.50%) Windows 7
6 9 (0.45%) Windows 10
7 7 (0.35%) Windows Server 2012
8 5 (0.25%) Windows Server 2008
9 4 (0.20%) Android
9 4 (0.20%) Solaris
10 3 (0.15%) Apple iOS
10 3 (0.15%) Oracle Linux
10 3 (0.15%) Red Hat Enterprise Linux
10 3 (0.15%) Windows XP
11 2 (0.099%) CentOS
11 2 (0.099%) Windows 8
Processes & Methodologies
1 1,197 (59.26%) Business Intelligence
2 917 (45.40%) ETL
3 685 (33.91%) Analytics
4 572 (28.32%) Agile Software Development
5 528 (26.14%) Data Modelling
6 383 (18.96%) Visualisation
7 279 (13.81%) Data Management
8 256 (12.67%) Migration
9 239 (11.83%) Data Science
10 226 (11.19%) DevOps
11 223 (11.04%) Problem-Solving
12 210 (10.40%) Data Visualisation
13 206 (10.20%) Data Architecture
14 185 (9.16%) Decision-Making
15 171 (8.47%) Data Integration
16 165 (8.17%) Data Analytics
17 141 (6.98%) Computer Science
18 139 (6.88%) Master Data Management
19 138 (6.83%) Data Analysis
20 126 (6.24%) Kimball Methodology
Programming Languages
1 1,333 (65.99%) SQL
2 460 (22.77%) Python
3 398 (19.70%) T-SQL
4 275 (13.61%) C#
5 222 (10.99%) Java
6 160 (7.92%) Data Analysis Expressions (DAX)
7 148 (7.33%) R
8 147 (7.28%) PL/SQL
9 68 (3.37%) VBA
10 67 (3.32%) Scala
11 53 (2.62%) PowerShell
12 50 (2.48%) VB
13 47 (2.33%) JavaScript
14 40 (1.98%) Java 8
15 34 (1.68%) Shell Script
16 18 (0.89%) C
17 15 (0.74%) VB.NET
18 14 (0.69%) U-SQL
19 13 (0.64%) Bash Shell
19 13 (0.64%) TypeScript
Qualifications
1 189 (9.36%) Degree
2 91 (4.50%) Computer Science Degree
3 16 (0.79%) Microsoft Certification
4 14 (0.69%) ITIL Foundation Certificate
5 13 (0.64%) Security Cleared
6 10 (0.50%) MBA
6 10 (0.50%) PhD
7 9 (0.45%) ISTQB
8 8 (0.40%) Master's Degree
9 7 (0.35%) Numerate Degree
10 6 (0.30%) MCSA
10 6 (0.30%) TOGAF Certification
11 4 (0.20%) ITIL Certification
12 3 (0.15%) DBS Check
12 3 (0.15%) PMI Certification
12 3 (0.15%) PMP
12 3 (0.15%) Postgraduate
12 3 (0.15%) PRINCE2 Practitioner
13 2 (0.099%) Cisco Certification
13 2 (0.099%) MCITP
Quality Assurance & Compliance
1 260 (12.87%) Data Quality
2 87 (4.31%) QA
3 26 (1.29%) GDPR
4 7 (0.35%) ISO/IEC 27001
5 4 (0.20%) SLA
6 3 (0.15%) HL7
6 3 (0.15%) PMO
7 2 (0.099%) Actionable Recommendations
8 1 (0.050%) Basel III
8 1 (0.050%) EMIR
8 1 (0.050%) IFRS
8 1 (0.050%) IFRS 9
System Software
1 55 (2.72%) Docker
2 28 (1.39%) HDFS
3 18 (0.89%) Active Directory
4 10 (0.50%) Apache Flume
5 8 (0.40%) VMware Infrastructure
6 6 (0.30%) Hyper-V
6 6 (0.30%) VMware Workstation
6 6 (0.30%) XenApp
7 4 (0.20%) Apache ZooKeeper
7 4 (0.20%) Cronacle
8 3 (0.15%) Veritas File System
8 3 (0.15%) Veritas Volume Manager
9 2 (0.099%) Varnish
10 1 (0.050%) Oracle Clusterware
10 1 (0.050%) Oracle RAC
Systems Management
1 41 (2.03%) Kubernetes
2 24 (1.19%) Ansible
2 24 (1.19%) Terraform
3 22 (1.09%) Control-M
4 17 (0.84%) Opscode Chef
5 15 (0.74%) Puppet
6 14 (0.69%) Oozie
7 9 (0.45%) SQL Sentry
8 6 (0.30%) Failover Clustering
9 5 (0.25%) BladeLogic
10 4 (0.20%) Dollar Universe
11 2 (0.099%) Automic
11 2 (0.099%) Data Guard
11 2 (0.099%) Perfmon
12 1 (0.050%) Grafana
12 1 (0.050%) HP Quality Center
12 1 (0.050%) Kubeflow
12 1 (0.050%) Matomo
12 1 (0.050%) Microsoft Clustering
12 1 (0.050%) Oracle RMAN
Vendors
1 571 (28.27%) Microsoft
2 318 (15.74%) Tableau
3 286 (14.16%) Oracle
4 177 (8.76%) Google
5 133 (6.58%) Informatica
6 84 (4.16%) SAP
7 80 (3.96%) Databricks
8 73 (3.61%) Teradata
9 72 (3.56%) IBM
10 54 (2.67%) Talend
11 42 (2.08%) Cloudera
12 39 (1.93%) Cognos
13 33 (1.63%) MicroStrategy
14 28 (1.39%) Salesforce.com
15 22 (1.09%) Alteryx
15 22 (1.09%) Hortonworks
16 21 (1.04%) VMware
17 19 (0.94%) Netezza
18 17 (0.84%) Veeam
19 16 (0.79%) Citrix