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

Data Warehousing
England > London
6 months to
20 Jan 2019
Same period 2018 Same period 2017
Rank 89 102 85
Rank change year-on-year +13 -17 -13
Permanent jobs citing Data Warehouse 2,221 2,193 2,440
As % of all permanent IT jobs advertised in London 3.57% 3.14% 3.45%
As % of the Database & Business Intelligence category 12.12% 10.40% 11.58%
Number of salaries quoted 1,804 1,652 2,172
London median annual salary £61,075 £59,250 £60,000
Median salary % change year-on-year +3.08% -1.25% +4.35%
10th Percentile £41,084 £40,000 £39,750
90th Percentile £87,500 £87,500 £92,500
England median annual salary £55,000 £51,000 £55,000
% change year-on-year +7.84% -7.27% +10.00%

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 18,319 21,082 21,063
As % of all permanent IT jobs advertised in London 29.46% 30.15% 29.76%
Number of salaries quoted 15,127 17,212 18,422
London median annual salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.17% +4.35% +4.55%
10th Percentile £37,500 £36,250 £35,000
90th Percentile £95,000 £88,750 £87,500
England median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% +2.70%

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 20 January 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 20 January 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 -8 386 £60,750 +5.65% 92
West London +9 86 £52,500 - 61
South London -6 39 £55,000 +37.50% 3
East London +27 26 £61,250 +4.26% 11
North London +9 10 £56,250 +32.35% 4
Data Warehouse
England

For the 6 months to 20 January 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,471 (66.23%) SQL
2 1,374 (61.86%) Business Intelligence
3 1,025 (46.15%) SQL Server
4 947 (42.64%) ETL
5 906 (40.79%) SQL Server Integration Services
6 798 (35.93%) Microsoft
7 705 (31.74%) Analytics
8 694 (31.25%) Finance
9 680 (30.62%) Agile Software Development
10 663 (29.85%) SQL Server Reporting Services
11 579 (26.07%) SQL Server Analysis Services
12 572 (25.75%) Microsoft Azure
13 545 (24.54%) Power BI
14 543 (24.45%) T-SQL
15 460 (20.71%) Data Modelling
16 432 (19.45%) Python
17 406 (18.28%) Tableau
18 379 (17.06%) Big Data
19 358 (16.12%) Analytical Skills
20 355 (15.98%) Oracle
21 339 (15.26%) Visualisation
22 331 (14.90%) Amazon AWS
22 331 (14.90%) C#
23 287 (12.92%) Data Quality
24 285 (12.83%) .NET
25 263 (11.84%) Data Management
26 252 (11.35%) Kimball Methodology
27 250 (11.26%) Hadoop
28 232 (10.45%) Problem-Solving
29 227 (10.22%) Relational Database

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 154 (6.93%) Apache Spark
2 85 (3.83%) SharePoint
3 73 (3.29%) Apache
3 73 (3.29%) SAS
4 38 (1.71%) Elasticsearch
5 25 (1.13%) IIS
6 24 (1.08%) Confluence
7 20 (0.90%) Oracle SOA Suite
8 18 (0.81%) Apache Solr
9 17 (0.77%) Apache Pig
10 14 (0.63%) Apache Airflow
11 13 (0.59%) CMS
12 8 (0.36%) MS Exchange
13 7 (0.32%) nginx
13 7 (0.32%) WebLogic
14 4 (0.18%) Drupal
14 4 (0.18%) Exchange Server 2010
14 4 (0.18%) Moodle
14 4 (0.18%) SharePoint 2013
14 4 (0.18%) SharePoint Server
Applications
1 193 (8.69%) Microsoft Excel
2 63 (2.84%) MS Visio
3 50 (2.25%) Microsoft Office
4 18 (0.81%) Microsoft PowerPoint
5 4 (0.18%) Microsoft Project
5 4 (0.18%) SPSS
6 2 (0.090%) GNU Octave
6 2 (0.090%) Mingle
7 1 (0.045%) CPLEX
7 1 (0.045%) Spreadsheet
Business Applications
1 30 (1.35%) Dynamics CRM
2 20 (0.90%) Dynamics NAV
3 17 (0.77%) Cognos TM1
4 11 (0.50%) Oracle EBS
5 10 (0.45%) FastStats
6 8 (0.36%) Dynamics AX
7 7 (0.32%) Cognos Business Intelligence
8 6 (0.27%) Markit EDM
8 6 (0.27%) Oracle Retail
8 6 (0.27%) SAP HR
9 5 (0.23%) Misys Opics
10 4 (0.18%) NetSuite
10 4 (0.18%) Oracle Applications
10 4 (0.18%) SAP BPC
10 4 (0.18%) Unit4 Business World
11 3 (0.14%) Infor SunSystems
11 3 (0.14%) SAP CO
11 3 (0.14%) SAP FI
11 3 (0.14%) SAP FI/CO
12 2 (0.090%) Maximo
Cloud Services
1 572 (25.75%) Microsoft Azure
2 331 (14.90%) Amazon AWS
3 135 (6.08%) Azure Data Factory
4 93 (4.19%) PaaS
5 92 (4.14%) Google Cloud Platform
6 69 (3.11%) SaaS
7 61 (2.75%) Serverless
8 49 (2.21%) Data Lake Analytics
9 34 (1.53%) Cloud Computing
10 27 (1.22%) Azure Machine Learning
11 26 (1.17%) Amazon S3
12 25 (1.13%) Azure Functions
13 24 (1.08%) Cortana Intelligence Suite
14 22 (0.99%) AWS Lambda
14 22 (0.99%) IaaS
15 18 (0.81%) Dynamics 365
16 15 (0.68%) Amazon EMR
17 14 (0.63%) Amazon EC2
17 14 (0.63%) Office 365
18 11 (0.50%) GitHub
Communications & Networking
1 19 (0.86%) SAN
2 14 (0.63%) HTTP
3 13 (0.59%) Internet
4 9 (0.41%) VoIP
5 7 (0.32%) LAN
5 7 (0.32%) WAN
6 5 (0.23%) Firewall
6 5 (0.23%) FTP
6 5 (0.23%) SSH
7 4 (0.18%) Intranet
7 4 (0.18%) NAS
7 4 (0.18%) PABX
7 4 (0.18%) Skype
7 4 (0.18%) VPN
8 2 (0.090%) DNS
8 2 (0.090%) SMTP
8 2 (0.090%) SSL
9 1 (0.045%) DHCP
9 1 (0.045%) HTTPS
9 1 (0.045%) TCP/IP
Database & Business Intelligence
1 1,025 (46.15%) SQL Server
2 906 (40.79%) SQL Server Integration Services
3 663 (29.85%) SQL Server Reporting Services
4 579 (26.07%) SQL Server Analysis Services
5 545 (24.54%) Power BI
6 379 (17.06%) Big Data
7 250 (11.26%) Hadoop
8 227 (10.22%) Relational Database
9 225 (10.13%) Data Lake
10 163 (7.34%) NoSQL
11 156 (7.02%) OLAP
12 153 (6.89%) BusinessObjects
13 152 (6.84%) Azure SQL Data Warehouse
13 152 (6.84%) Azure SQL Database
14 142 (6.39%) SQL Server 2016
15 132 (5.94%) SQL Server 2012
16 131 (5.90%) QlikView
17 121 (5.45%) Amazon Redshift
18 105 (4.73%) Microsoft Analysis Services
19 104 (4.68%) Oracle Database
Development Applications
1 107 (4.82%) Git (software)
2 92 (4.14%) Visual Studio
3 82 (3.69%) Team Foundation Server
4 55 (2.48%) Jenkins
5 49 (2.21%) Octopus Deploy
6 46 (2.07%) JIRA
6 46 (2.07%) Visual Studio Team System
7 32 (1.44%) ERwin
7 32 (1.44%) SQL Server Management Studio (SSMS)
8 31 (1.40%) ER Studio
9 29 (1.31%) Oracle APEX
10 26 (1.17%) TeamCity
11 19 (0.86%) Eclipse
11 19 (0.86%) Subversion
12 18 (0.81%) tSQLt
13 13 (0.59%) Selenium
14 12 (0.54%) Cucumber
15 10 (0.45%) Mocha
16 9 (0.41%) Atlassian Bamboo
16 9 (0.41%) Maven
General
1 694 (31.25%) Finance
2 215 (9.68%) Banking
3 182 (8.19%) Retail
4 105 (4.73%) Marketing
5 74 (3.33%) Investment Banking
6 61 (2.75%) Advertising
7 33 (1.49%) Legal
8 31 (1.40%) Games
9 30 (1.35%) Law
10 26 (1.17%) Corporate Banking
11 24 (1.08%) Telecoms
12 21 (0.95%) Back Office
12 21 (0.95%) Front Office
13 18 (0.81%) Publishing
14 12 (0.54%) Financial Institution
14 12 (0.54%) General Ledger
15 11 (0.50%) Automotive
15 11 (0.50%) Pharmaceutical
16 8 (0.36%) Manufacturing
17 7 (0.32%) Music Industry
Job Titles
1 789 (35.52%) Developer
2 395 (17.78%) Analyst
3 322 (14.50%) Business Intelligence Developer
4 315 (14.18%) Architect
5 304 (13.69%) SQL Developer
6 203 (9.14%) Data Engineer
7 201 (9.05%) Data Architect
8 144 (6.48%) Data Warehouse Developer
9 140 (6.30%) Data Analyst
9 140 (6.30%) SQL BI Developer
10 132 (5.94%) SSIS Developer
11 131 (5.90%) Consultant
12 123 (5.54%) Business Intelligence Analyst
13 118 (5.31%) Senior Developer
14 116 (5.22%) ETL Developer
15 111 (5.00%) Business Analyst
16 98 (4.41%) SQL Server Developer
17 97 (4.37%) Solutions Architect
18 72 (3.24%) SSRS Developer
19 63 (2.84%) DBA
Libraries, Frameworks & Software Standards
1 285 (12.83%) .NET
2 137 (6.17%) Kafka
3 136 (6.12%) Web Services
4 107 (4.82%) XML
5 102 (4.59%) MDX
6 72 (3.24%) JSON
7 64 (2.88%) HTML
8 53 (2.39%) Middleware
9 47 (2.12%) CSS
9 47 (2.12%) REST
10 42 (1.89%) AngularJS
10 42 (1.89%) ASP.NET
11 26 (1.17%) Spark Streaming
12 24 (1.08%) ASP.NET Web API
12 24 (1.08%) React
13 23 (1.04%) Apache NiFi
14 22 (0.99%) .NET Framework
14 22 (0.99%) Redux
14 22 (0.99%) WCF
15 20 (0.90%) SOAP
Miscellaneous
1 358 (16.12%) Analytical Skills
2 154 (6.93%) Data Structures
3 72 (3.24%) Fintech
4 69 (3.11%) Greenfield Project
5 55 (2.48%) Management Information System
5 55 (2.48%) Replication
6 43 (1.94%) Reinsurance
7 42 (1.89%) Self-Motivation
8 41 (1.85%) Algorithms
8 41 (1.85%) Credit Risk
9 36 (1.62%) Reference Data
10 30 (1.35%) Hedge funds
11 29 (1.31%) Virtual Team
12 26 (1.17%) Enterprise Software
12 26 (1.17%) Equities
13 25 (1.13%) Market Risk
13 25 (1.13%) Mobile App
14 24 (1.08%) NHS
15 22 (0.99%) Clustering
16 21 (0.95%) Life Science
Operating Systems
1 145 (6.53%) Linux
2 123 (5.54%) Unix
3 119 (5.36%) Windows
4 26 (1.17%) Windows Server
5 23 (1.04%) Red Hat Enterprise Linux
6 17 (0.77%) Apple iOS
7 13 (0.59%) HPUX
7 13 (0.59%) Solaris
8 10 (0.45%) AIX
8 10 (0.45%) Windows Server 2008
9 4 (0.18%) CentOS
9 4 (0.18%) Mac OS X
9 4 (0.18%) zOS
10 3 (0.14%) Oracle Linux
10 3 (0.14%) Ubuntu
11 2 (0.090%) VMS
11 2 (0.090%) Windows 10
12 1 (0.045%) DC/OS
12 1 (0.045%) Windows Server 2012
Processes & Methodologies
1 1,374 (61.86%) Business Intelligence
2 947 (42.64%) ETL
3 705 (31.74%) Analytics
4 680 (30.62%) Agile Software Development
5 460 (20.71%) Data Modelling
6 339 (15.26%) Visualisation
7 263 (11.84%) Data Management
8 252 (11.35%) Kimball Methodology
9 232 (10.45%) Problem-Solving
10 227 (10.22%) Migration
11 219 (9.86%) Machine Learning
12 215 (9.68%) Performance Tuning
13 213 (9.59%) Data Science
14 211 (9.50%) Scrum
15 194 (8.73%) SDLC
16 188 (8.46%) Data Analysis
16 188 (8.46%) Data Integration
17 178 (8.01%) Data Architecture
18 176 (7.92%) Data Analytics
19 175 (7.88%) Dimensional Modelling
Programming Languages
1 1,471 (66.23%) SQL
2 543 (24.45%) T-SQL
3 432 (19.45%) Python
4 331 (14.90%) C#
5 189 (8.51%) Java
6 138 (6.21%) R
7 131 (5.90%) PL/SQL
8 97 (4.37%) JavaScript
9 91 (4.10%) PowerShell
10 84 (3.78%) Data Analysis Expressions (DAX)
11 76 (3.42%) VBA
12 70 (3.15%) Scala
13 47 (2.12%) Shell Script
14 42 (1.89%) VB
15 36 (1.62%) PHP
16 33 (1.49%) U-SQL
17 32 (1.44%) VB.NET
18 25 (1.13%) C
19 14 (0.63%) MATLAB
19 14 (0.63%) Perl
Qualifications
1 221 (9.95%) Degree
2 72 (3.24%) Microsoft Certification
3 53 (2.39%) Computer Science Degree
4 39 (1.76%) Security Cleared
5 36 (1.62%) MCSA
6 18 (0.81%) PMP
7 15 (0.68%) MCSE
7 15 (0.68%) PMI Certification
7 15 (0.68%) SC Cleared
8 13 (0.59%) PRINCE2 Certification
9 12 (0.54%) MCT
9 12 (0.54%) TOGAF Certification
10 11 (0.50%) ISEB
11 10 (0.45%) ITIL Foundation Certificate
11 10 (0.45%) Numerate Degree
12 9 (0.41%) PhD
13 7 (0.32%) Master's Degree
14 6 (0.27%) MCDBA
15 5 (0.23%) ITIL Certification
16 4 (0.18%) MCAD
Quality Assurance & Compliance
1 287 (12.92%) Data Quality
2 136 (6.12%) QA
3 77 (3.47%) GDPR
4 30 (1.35%) Solvency II
5 11 (0.50%) PMO
6 9 (0.41%) SLA
7 8 (0.36%) IFRS
8 6 (0.27%) MiFID
9 5 (0.23%) ISO/IEC 27001
9 5 (0.23%) PCI DSS
10 4 (0.18%) IFRS 9
11 1 (0.045%) COBIT
11 1 (0.045%) Dodd-Frank
11 1 (0.045%) FATCA
System Software
1 58 (2.61%) Docker
2 40 (1.80%) HDFS
3 35 (1.58%) Apache Flume
4 16 (0.72%) VMware Infrastructure
5 10 (0.45%) Active Directory
5 10 (0.45%) Hyper-V
6 8 (0.36%) Virtual Machines
7 6 (0.27%) Apache ZooKeeper
7 6 (0.27%) Varnish
8 1 (0.045%) Oracle RAC
8 1 (0.045%) Terminal Services
8 1 (0.045%) VMware ESXi
8 1 (0.045%) vSphere
Systems Management
1 44 (1.98%) Kubernetes
2 29 (1.31%) Terraform
3 27 (1.22%) Automic
3 27 (1.22%) Opscode Chef
4 25 (1.13%) Puppet
5 23 (1.04%) Control-M
6 20 (0.90%) Hadoop YARN
7 19 (0.86%) Ansible
8 14 (0.63%) Oracle RMAN
9 11 (0.50%) Mesos
10 9 (0.41%) Failover Clustering
10 9 (0.41%) Oracle Enterprise Manager
10 9 (0.41%) Perfmon
11 7 (0.32%) Oozie
12 4 (0.18%) Data Guard
12 4 (0.18%) Dollar Universe
13 3 (0.14%) Docker Swarm
13 3 (0.14%) Grafana
13 3 (0.14%) Rundeck
14 2 (0.090%) Kibana
Vendors
1 798 (35.93%) Microsoft
2 406 (18.28%) Tableau
3 355 (15.98%) Oracle
4 148 (6.66%) SAP
5 137 (6.17%) Informatica
6 107 (4.82%) Google
7 73 (3.29%) IBM
8 69 (3.11%) Cognos
9 68 (3.06%) Talend
10 60 (2.70%) Cloudera
11 47 (2.12%) Teradata
12 39 (1.76%) Databricks
13 34 (1.53%) MicroStrategy
14 28 (1.26%) VMware
15 24 (1.08%) Red Hat
16 22 (0.99%) Cadence
16 22 (0.99%) Hortonworks
16 22 (0.99%) MapR
17 21 (0.95%) Alteryx
17 21 (0.95%) HP