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

Data Warehousing
England > London
6 months to
23 Sep 2019
Same period 2018 Same period 2017
Rank 71 89 100
Rank change year-on-year +18 +11 -15
Permanent jobs citing Data Warehouse 2,290 2,420 2,454
As % of all permanent IT jobs advertised in London 4.13% 3.56% 3.29%
As % of the Database & Business Intelligence category 14.56% 11.43% 11.18%
Number of salaries quoted 1,911 2,006 1,799
London median annual salary £62,500 £60,000 £60,000
Median salary % change year-on-year +4.17% - -
10th Percentile £42,500 £40,000 £40,000
90th Percentile £88,750 £88,125 £87,500
England median annual salary £55,000 £55,000 £50,000
% change year-on-year - +10.00% -9.09%

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,728 21,175 21,952
As % of all permanent IT jobs advertised in London 28.34% 31.15% 29.46%
Number of salaries quoted 13,043 16,823 17,645
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,500 £37,500 £36,250
90th Percentile £97,500 £93,750 £90,000
England median annual salary £52,500 £50,000 £49,000
% change year-on-year +5.00% +2.04% +3.16%

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 September 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 23 September 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 +38 708 £62,500 -3.85% 71
West London +7 108 £60,000 +9.09% 23
South London -56 38 £52,500 +2.94% 3
East London +17 32 £41,000 -31.67% 11
North London +5 8 £60,000 +9.09% 7
Data Warehouse
England

For the 6 months to 23 September 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,492 (65.15%) SQL
2 1,391 (60.74%) Business Intelligence
3 1,041 (45.46%) SQL Server
4 984 (42.97%) ETL
5 955 (41.70%) SQL Server Integration Services
6 763 (33.32%) SQL Server Analysis Services
7 759 (33.14%) Analytics
8 729 (31.83%) Power BI
8 729 (31.83%) Power Platform
9 716 (31.27%) SQL Server Reporting Services
10 697 (30.44%) Azure
11 692 (30.22%) Microsoft
12 673 (29.39%) Finance
13 670 (29.26%) Agile Software Development
14 594 (25.94%) Data Modelling
15 502 (21.92%) T-SQL
16 487 (21.27%) Python
17 431 (18.82%) Big Data
18 383 (16.72%) Visualisation
19 348 (15.20%) AWS
19 348 (15.20%) Tableau
20 347 (15.15%) C#
21 323 (14.10%) Oracle
22 304 (13.28%) Data Lake
23 303 (13.23%) Data Management
24 288 (12.58%) Analytical Skills
25 270 (11.79%) Data Analysis Expressions (DAX)
26 254 (11.09%) .NET
27 250 (10.92%) Data Science
28 247 (10.79%) 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 157 (6.86%) Apache Spark
2 55 (2.40%) SAS
3 47 (2.05%) Apache
4 46 (2.01%) SharePoint
5 36 (1.57%) Apache Airflow
6 31 (1.35%) Apache Pig
7 19 (0.83%) Oracle SOA Suite
8 18 (0.79%) Confluence
9 13 (0.57%) IIS
10 12 (0.52%) Apache Solr
11 11 (0.48%) Elasticsearch
12 8 (0.35%) BizTalk Server
13 6 (0.26%) Luigi
14 5 (0.22%) MS Exchange
15 4 (0.17%) SharePoint 2013
16 3 (0.13%) ArcGIS
16 3 (0.13%) Cloud Foundry
16 3 (0.13%) Oracle Workflow
17 1 (0.044%) EPiServer
17 1 (0.044%) IBM HTTP Server
Applications
1 154 (6.72%) Microsoft Excel
2 51 (2.23%) Microsoft Office
3 10 (0.44%) Microsoft Project
3 10 (0.44%) MS Visio
3 10 (0.44%) SPSS
4 8 (0.35%) Microsoft PowerPoint
5 7 (0.31%) Spreadsheet
6 1 (0.044%) Adobe Premiere
6 1 (0.044%) Chatbot
6 1 (0.044%) SPSS Modeler
Business Applications
1 29 (1.27%) Dynamics CRM
2 17 (0.74%) Cognos Business Intelligence
3 8 (0.35%) Markit EDM
4 7 (0.31%) FastStats
5 5 (0.22%) Dynamics NAV
6 4 (0.17%) Infor SunSystems
7 3 (0.13%) Adobe Campaign
7 3 (0.13%) Dynamics AX
7 3 (0.13%) Maximo
8 2 (0.087%) Cognos TM1
8 2 (0.087%) Eagle PACE
8 2 (0.087%) Hyperion Planning
8 2 (0.087%) Oracle EBS
8 2 (0.087%) Oracle ERP
8 2 (0.087%) Remedy ITSM
8 2 (0.087%) Siebel CRM
9 1 (0.044%) FastStats PeopleStage
9 1 (0.044%) Oracle BPM
9 1 (0.044%) Oracle Retail
9 1 (0.044%) Sparx Enterprise Architect
Cloud Services
1 729 (31.83%) Power Platform
2 697 (30.44%) Azure
3 348 (15.20%) AWS
4 140 (6.11%) Azure Data Factory
5 138 (6.03%) GCP
6 60 (2.62%) PaaS
7 50 (2.18%) SaaS
8 41 (1.79%) Serverless
9 33 (1.44%) Amazon S3
9 33 (1.44%) Data Lake Analytics
9 33 (1.44%) Google Analytics
10 32 (1.40%) Cloud Computing
11 29 (1.27%) PowerApps
12 27 (1.18%) Azure Machine Learning
13 26 (1.14%) Azure Functions
14 22 (0.96%) Amazon EMR
15 19 (0.83%) IaaS
16 17 (0.74%) Cortana Intelligence Suite
17 12 (0.52%) GitHub
18 11 (0.48%) Office 365
Communications & Networking
1 13 (0.57%) DNS
2 11 (0.48%) FTP
3 10 (0.44%) SAN
4 6 (0.26%) Network Security
5 5 (0.22%) Internet
6 4 (0.17%) DHCP
6 4 (0.17%) DSL
6 4 (0.17%) Wi-Fi
7 3 (0.13%) Firewall
7 3 (0.13%) TCP/IP
8 2 (0.087%) Kerberos
8 2 (0.087%) VoIP
8 2 (0.087%) WLAN
9 1 (0.044%) Broadband
9 1 (0.044%) iSCSI
9 1 (0.044%) NAS
9 1 (0.044%) Skype
Database & Business Intelligence
1 1,041 (45.46%) SQL Server
2 955 (41.70%) SQL Server Integration Services
3 763 (33.32%) SQL Server Analysis Services
4 729 (31.83%) Power BI
5 716 (31.27%) SQL Server Reporting Services
6 431 (18.82%) Big Data
7 304 (13.28%) Data Lake
8 227 (9.91%) Relational Database
9 212 (9.26%) Hadoop
10 208 (9.08%) Azure SQL Database
11 148 (6.46%) NoSQL
12 145 (6.33%) Microsoft Analysis Services
13 135 (5.90%) Azure SQL Data Warehouse
14 120 (5.24%) OLAP
14 120 (5.24%) SQL Server 2012
15 118 (5.15%) Amazon Redshift
16 111 (4.85%) QlikView
17 109 (4.76%) SQL Server 2016
18 105 (4.59%) Apache Hive
19 97 (4.24%) BusinessObjects
Development Applications
1 121 (5.28%) Git (software)
2 73 (3.19%) Visual Studio
3 62 (2.71%) JIRA
4 55 (2.40%) Team Foundation Server
5 35 (1.53%) Bitbucket
6 32 (1.40%) Jenkins
7 31 (1.35%) Subversion
8 21 (0.92%) ERwin
9 19 (0.83%) Atlassian Bamboo
9 19 (0.83%) Maven
9 19 (0.83%) Oracle APEX
9 19 (0.83%) Selenium
10 18 (0.79%) ER Studio
10 18 (0.79%) Oracle Forms
10 18 (0.79%) PowerDesigner
10 18 (0.79%) ProC
11 16 (0.70%) Visual Studio Team System
12 14 (0.61%) Artifactory
13 12 (0.52%) SQL Server Management Studio (SSMS)
14 10 (0.44%) Cucumber
General
1 673 (29.39%) Finance
2 168 (7.34%) Banking
3 139 (6.07%) Retail
4 88 (3.84%) Marketing
5 45 (1.97%) Legal
6 32 (1.40%) Advertising
6 32 (1.40%) Law
6 32 (1.40%) Public Sector
7 31 (1.35%) Games
8 30 (1.31%) Telecoms
9 29 (1.27%) Investment Banking
10 15 (0.66%) Financial Institution
11 14 (0.61%) Back Office
12 7 (0.31%) Automotive
13 6 (0.26%) Pharmaceutical
13 6 (0.26%) Publishing
14 4 (0.17%) French Language
14 4 (0.17%) Front Office
15 3 (0.13%) Environmental Health
15 3 (0.13%) Local Government
Job Titles
1 981 (42.84%) Developer
2 511 (22.31%) Business Intelligence Developer
3 371 (16.20%) Analyst
4 362 (15.81%) SQL Developer
5 263 (11.48%) Data Engineer
6 237 (10.35%) Architect
7 180 (7.86%) SQL BI Developer
8 168 (7.34%) Data Warehouse Developer
9 153 (6.68%) Senior Developer
10 148 (6.46%) Business Intelligence Analyst
11 145 (6.33%) Data Architect
12 119 (5.20%) Data Analyst
13 114 (4.98%) SSIS Developer
14 110 (4.80%) SSRS Developer
15 103 (4.50%) Database Developer
15 103 (4.50%) SQL Server Developer
16 84 (3.67%) Senior Business Intelligence Developer
17 82 (3.58%) Consultant
18 77 (3.36%) SQL Analyst
19 72 (3.14%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 254 (11.09%) .NET
2 165 (7.21%) MDX
3 104 (4.54%) Web Services
4 103 (4.50%) Kafka
5 52 (2.27%) XML
6 47 (2.05%) .NET Framework
7 45 (1.97%) HTML
8 36 (1.57%) ASP.NET
9 35 (1.53%) JSON
10 30 (1.31%) REST
11 29 (1.27%) React
12 26 (1.14%) RESTful
13 24 (1.05%) AngularJS
13 24 (1.05%) WCF
14 21 (0.92%) WinForms
15 20 (0.87%) Entity Framework
16 18 (0.79%) D3.js
17 17 (0.74%) ASP.NET Web API
17 17 (0.74%) Middleware
18 16 (0.70%) CSS
Miscellaneous
1 288 (12.58%) Analytical Skills
2 108 (4.72%) Management Information System
3 86 (3.76%) Greenfield Project
4 80 (3.49%) Data Structures
5 75 (3.28%) Data Centre
6 56 (2.45%) Self-Motivation
7 42 (1.83%) Reinsurance
8 40 (1.75%) Algorithms
9 31 (1.35%) Hedge funds
9 31 (1.35%) Public Cloud
10 25 (1.09%) User Experience
11 21 (0.92%) Clustering
11 21 (0.92%) Taxonomies
12 19 (0.83%) Fixed Income
13 18 (0.79%) Derivative
13 18 (0.79%) Private Cloud
14 17 (0.74%) Reference Data
14 17 (0.74%) Virtual Team
15 14 (0.61%) NHS
16 13 (0.57%) AS400
Operating Systems
1 101 (4.41%) Windows
2 81 (3.54%) Unix
3 54 (2.36%) Linux
4 43 (1.88%) Windows Server
5 9 (0.39%) Red Hat Enterprise Linux
6 8 (0.35%) Windows Server 2012
7 6 (0.26%) Windows 7
8 5 (0.22%) Windows 10
9 4 (0.17%) Android
10 3 (0.13%) Apple iOS
10 3 (0.13%) Windows XP
11 2 (0.087%) Windows 8
11 2 (0.087%) Windows Server 2008
12 1 (0.044%) Solaris
Processes & Methodologies
1 1,391 (60.74%) Business Intelligence
2 984 (42.97%) ETL
3 759 (33.14%) Analytics
4 670 (29.26%) Agile Software Development
5 594 (25.94%) Data Modelling
6 383 (16.72%) Visualisation
7 303 (13.23%) Data Management
8 250 (10.92%) Data Science
9 247 (10.79%) Problem-Solving
10 245 (10.70%) Kimball Methodology
11 242 (10.57%) Migration
12 239 (10.44%) DevOps
13 219 (9.56%) Data Analytics
13 219 (9.56%) Data Architecture
14 206 (9.00%) Data Visualisation
15 182 (7.95%) Decision-Making
16 176 (7.69%) Scrum
17 162 (7.07%) Data Analysis
18 159 (6.94%) Data Integration
19 149 (6.51%) Computer Science
Programming Languages
1 1,492 (65.15%) SQL
2 502 (21.92%) T-SQL
3 487 (21.27%) Python
4 347 (15.15%) C#
5 270 (11.79%) Data Analysis Expressions (DAX)
6 219 (9.56%) Java
7 182 (7.95%) PL/SQL
8 176 (7.69%) R
9 98 (4.28%) PowerShell
10 80 (3.49%) VBA
11 70 (3.06%) JavaScript
12 68 (2.97%) Scala
13 53 (2.31%) VB
14 30 (1.31%) Java 8
15 29 (1.27%) VB.NET
16 27 (1.18%) Shell Script
17 22 (0.96%) C
18 18 (0.79%) MATLAB
19 17 (0.74%) Go
20 13 (0.57%) TypeScript
Qualifications
1 231 (10.09%) Degree
2 95 (4.15%) Computer Science Degree
3 19 (0.83%) Microsoft Certification
4 18 (0.79%) Security Cleared
5 16 (0.70%) TOGAF Certification
6 14 (0.61%) Master's Degree
7 13 (0.57%) PhD
8 10 (0.44%) ITIL Foundation Certificate
9 9 (0.39%) Numerate Degree
10 7 (0.31%) PMP
11 6 (0.26%) MCSA
11 6 (0.26%) PMI Certification
12 5 (0.22%) ITIL Certification
13 4 (0.17%) DBS Check
13 4 (0.17%) ISTQB
13 4 (0.17%) MCSE
13 4 (0.17%) PRINCE2 Certification
14 3 (0.13%) CCNA
14 3 (0.13%) Cisco Certification
14 3 (0.13%) MBA
Quality Assurance & Compliance
1 233 (10.17%) Data Quality
2 76 (3.32%) QA
3 37 (1.62%) GDPR
4 6 (0.26%) HIPAA
4 6 (0.26%) ISO/IEC 27001
4 6 (0.26%) SLA
5 3 (0.13%) HL7
5 3 (0.13%) PMO
6 2 (0.087%) Actionable Recommendations
7 1 (0.044%) EMIR
System Software
1 60 (2.62%) Docker
2 38 (1.66%) HDFS
3 25 (1.09%) Active Directory
4 17 (0.74%) Apache Flume
5 9 (0.39%) Cronacle
5 9 (0.39%) Veritas File System
5 9 (0.39%) Veritas Volume Manager
5 9 (0.39%) VMware Infrastructure
6 6 (0.26%) Hyper-V
6 6 (0.26%) VMware Workstation
6 6 (0.26%) XenApp
7 5 (0.22%) Apache ZooKeeper
8 1 (0.044%) Oracle Clusterware
8 1 (0.044%) Oracle RAC
Systems Management
1 33 (1.44%) Kubernetes
2 28 (1.22%) Ansible
2 28 (1.22%) Terraform
3 20 (0.87%) Puppet
4 18 (0.79%) Control-M
4 18 (0.79%) Opscode Chef
5 17 (0.74%) Oozie
6 15 (0.66%) Hadoop YARN
6 15 (0.66%) SQL Sentry
7 9 (0.39%) Dollar Universe
8 8 (0.35%) Failover Clustering
9 4 (0.17%) Mesos
10 3 (0.13%) Ambari
11 2 (0.087%) Automic
11 2 (0.087%) Kibana
11 2 (0.087%) Perfmon
12 1 (0.044%) Grafana
12 1 (0.044%) Kubeflow
12 1 (0.044%) Matomo
12 1 (0.044%) Microsoft Clustering
Vendors
1 692 (30.22%) Microsoft
2 348 (15.20%) Tableau
3 323 (14.10%) Oracle
4 163 (7.12%) Informatica
5 156 (6.81%) Google
6 115 (5.02%) Databricks
7 114 (4.98%) SAP
8 103 (4.50%) IBM
9 69 (3.01%) Talend
10 60 (2.62%) Teradata
11 47 (2.05%) Cloudera
12 37 (1.62%) Cognos
13 30 (1.31%) Salesforce.com
14 28 (1.22%) MicroStrategy
14 28 (1.22%) VMware
15 22 (0.96%) Hortonworks
16 19 (0.83%) Atlassian
16 19 (0.83%) MuleSoft
17 17 (0.74%) Veeam
18 16 (0.70%) Citrix