Period
to 12 November 2018

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 12 November 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > London
6 months to
12 Nov 2018
Same period 2017 Same period 2016
Rank 88 97 88
Rank change year-on-year +9 -9 -12
Permanent jobs citing Data Warehouse 2,368 2,439 2,702
As % of all permanent IT jobs advertised in London 3.54% 3.26% 3.55%
As % of the Database & Business Intelligence category 11.74% 11.08% 12.11%
Number of salaries quoted 1,946 1,765 2,419
London median annual salary £61,500 £60,000 £60,000
Median salary % change year-on-year +2.50% - -
10th Percentile £40,000 £40,000 £40,000
90th Percentile £87,500 £87,500 £87,500
England median annual salary £55,000 £52,500 £55,000
% change year-on-year +4.76% -4.55% +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 20,166 22,010 22,318
As % of all permanent IT jobs advertised in London 30.18% 29.41% 29.36%
Number of salaries quoted 16,452 17,633 19,415
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 £51,000 £50,000 £47,500
% change year-on-year +2.00% +5.26% +5.56%

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 12 November 2018.

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 12 November 2018. 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 -5 481 £63,500 +5.83% 109
West London +47 111 £51,552 -1.81% 52
South London +16 60 £55,000 +37.50% 4
East London +7 34 £60,000 +26.32% 13
North London +5 7 £56,250 -3.85% 2
Data Warehouse
England

For the 6 months to 12 November 2018, 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,615 (68.20%) SQL
2 1,478 (62.42%) Business Intelligence
3 1,178 (49.75%) SQL Server
4 1,051 (44.38%) ETL
5 1,029 (43.45%) SQL Server Integration Services
6 868 (36.66%) Microsoft
7 776 (32.77%) SQL Server Reporting Services
8 756 (31.93%) Finance
9 699 (29.52%) Agile Software Development
10 674 (28.46%) Analytics
11 655 (27.66%) SQL Server Analysis Services
12 620 (26.18%) T-SQL
13 569 (24.03%) Power BI
14 507 (21.41%) Microsoft Azure
15 446 (18.83%) Data Modelling
16 423 (17.86%) Big Data
17 392 (16.55%) Oracle
18 376 (15.88%) Python
19 370 (15.63%) Tableau
20 341 (14.40%) .NET
21 336 (14.19%) C#
22 328 (13.85%) Visualisation
23 325 (13.72%) Analytical Skills
24 289 (12.20%) Amazon AWS
25 280 (11.82%) Data Management
26 274 (11.57%) Data Quality
27 269 (11.36%) Kimball Methodology
28 262 (11.06%) Hadoop
29 254 (10.73%) Degree
30 245 (10.35%) 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 144 (6.08%) Apache Spark
2 95 (4.01%) SAS
3 79 (3.34%) SharePoint
4 72 (3.04%) Apache
5 49 (2.07%) IIS
6 26 (1.10%) Elasticsearch
7 24 (1.01%) Apache Pig
8 21 (0.89%) CMS
9 18 (0.76%) Confluence
10 17 (0.72%) Oracle SOA Suite
11 12 (0.51%) Apache Solr
12 11 (0.46%) Apache Airflow
13 10 (0.42%) Hyperledger
14 8 (0.34%) MS Exchange
15 6 (0.25%) WebLogic
16 5 (0.21%) SharePoint 2010
16 5 (0.21%) SharePoint 2013
17 4 (0.17%) Exchange Server 2010
17 4 (0.17%) nginx
17 4 (0.17%) Skype for Business
Applications
1 204 (8.61%) Microsoft Excel
2 60 (2.53%) Microsoft Office
3 49 (2.07%) MS Visio
4 26 (1.10%) Microsoft PowerPoint
5 6 (0.25%) SPSS
6 4 (0.17%) Microsoft Project
7 3 (0.13%) Stata
8 2 (0.084%) Spreadsheet
9 1 (0.042%) CPLEX
9 1 (0.042%) GNU Octave
Business Applications
1 31 (1.31%) Dynamics CRM
2 22 (0.93%) Dynamics NAV
3 16 (0.68%) Cognos TM1
4 15 (0.63%) Markit EDM
5 13 (0.55%) Dynamics AX
6 11 (0.46%) Oracle EBS
7 10 (0.42%) FastStats
8 7 (0.30%) Remedy ITSM
9 6 (0.25%) Cognos Business Intelligence
9 6 (0.25%) Oracle Retail
10 5 (0.21%) NetSuite
10 5 (0.21%) SAP CO
10 5 (0.21%) SAP FI
10 5 (0.21%) SAP FI/CO
11 4 (0.17%) Misys Opics
11 4 (0.17%) SAP HR
11 4 (0.17%) Unit4 Business World
12 2 (0.084%) Cognos Controller
12 2 (0.084%) SAP BPC
12 2 (0.084%) SAP Business One
Cloud Services
1 507 (21.41%) Microsoft Azure
2 289 (12.20%) Amazon AWS
3 112 (4.73%) Azure Data Factory
4 82 (3.46%) PaaS
5 65 (2.74%) Google Cloud Platform
6 57 (2.41%) Serverless
7 49 (2.07%) SaaS
8 45 (1.90%) Data Lake Analytics
9 33 (1.39%) Cloud Computing
10 24 (1.01%) IaaS
11 23 (0.97%) AWS Lambda
11 23 (0.97%) Azure Machine Learning
12 22 (0.93%) Amazon S3
13 21 (0.89%) Azure Functions
13 21 (0.89%) Cortana Intelligence Suite
13 21 (0.89%) Dynamics 365
14 20 (0.84%) Amazon EC2
15 16 (0.68%) Office 365
16 11 (0.46%) Google Analytics
17 10 (0.42%) GitHub
Communications & Networking
1 21 (0.89%) SAN
2 19 (0.80%) Internet
3 9 (0.38%) VoIP
4 8 (0.34%) HTTP
4 8 (0.34%) LAN
4 8 (0.34%) WAN
5 6 (0.25%) Firewall
5 6 (0.25%) SSH
6 5 (0.21%) Intranet
7 4 (0.17%) NAS
7 4 (0.17%) PABX
7 4 (0.17%) Skype
7 4 (0.17%) VPN
8 3 (0.13%) DNS
8 3 (0.13%) SSL
9 2 (0.084%) HTTPS
9 2 (0.084%) SMTP
9 2 (0.084%) TCP/IP
9 2 (0.084%) Wi-Fi
10 1 (0.042%) DHCP
Database & Business Intelligence
1 1,178 (49.75%) SQL Server
2 1,029 (43.45%) SQL Server Integration Services
3 776 (32.77%) SQL Server Reporting Services
4 655 (27.66%) SQL Server Analysis Services
5 569 (24.03%) Power BI
6 423 (17.86%) Big Data
7 262 (11.06%) Hadoop
8 245 (10.35%) Relational Database
9 230 (9.71%) Data Lake
10 181 (7.64%) OLAP
11 171 (7.22%) BusinessObjects
12 162 (6.84%) SQL Server 2016
13 160 (6.76%) SQL Server 2012
14 151 (6.38%) NoSQL
15 143 (6.04%) Azure SQL Data Warehouse
16 141 (5.95%) SQL Server 2008
17 130 (5.49%) Microsoft Analysis Services
18 125 (5.28%) Azure SQL Database
19 116 (4.90%) QlikView
19 116 (4.90%) SQL Server 2014
Development Applications
1 135 (5.70%) Team Foundation Server
2 117 (4.94%) Visual Studio
3 95 (4.01%) Git (software)
4 71 (3.00%) Jenkins
5 59 (2.49%) Octopus Deploy
6 50 (2.11%) Visual Studio Team System
7 47 (1.98%) JIRA
8 38 (1.60%) SQL Server Management Studio (SSMS)
9 34 (1.44%) Oracle APEX
10 31 (1.31%) TeamCity
11 25 (1.06%) Eclipse
12 22 (0.93%) ER Studio
13 19 (0.80%) Subversion
14 18 (0.76%) tSQLt
15 17 (0.72%) ERwin
16 16 (0.68%) Selenium
17 14 (0.59%) Toad
18 11 (0.46%) Cucumber
18 11 (0.46%) RStudio
19 10 (0.42%) Bitbucket
General
1 756 (31.93%) Finance
2 213 (8.99%) Banking
3 170 (7.18%) Retail
4 124 (5.24%) Marketing
5 78 (3.29%) Advertising
6 75 (3.17%) Investment Banking
7 42 (1.77%) Games
8 36 (1.52%) Legal
9 29 (1.22%) Corporate Banking
10 25 (1.06%) Publishing
11 23 (0.97%) Front Office
12 21 (0.89%) Back Office
12 21 (0.89%) Telecoms
13 18 (0.76%) Law
14 16 (0.68%) General Ledger
15 12 (0.51%) Music Industry
15 12 (0.51%) Pharmaceutical
16 10 (0.42%) Financial Institution
17 9 (0.38%) Automotive
18 7 (0.30%) Manufacturing
Job Titles
1 949 (40.08%) Developer
2 416 (17.57%) Business Intelligence Developer
3 387 (16.34%) Analyst
4 369 (15.58%) SQL Developer
5 311 (13.13%) Architect
6 208 (8.78%) SSIS Developer
7 186 (7.85%) Data Architect
8 183 (7.73%) SQL BI Developer
9 181 (7.64%) Data Warehouse Developer
10 170 (7.18%) Data Engineer
11 148 (6.25%) Consultant
12 143 (6.04%) Data Analyst
12 143 (6.04%) SQL Server Developer
13 136 (5.74%) Senior Developer
14 132 (5.57%) Business Intelligence Analyst
15 131 (5.53%) ETL Developer
15 131 (5.53%) SSRS Developer
16 116 (4.90%) SSAS Developer
17 101 (4.27%) Solutions Architect
18 94 (3.97%) Business Analyst
Libraries, Frameworks & Software Standards
1 341 (14.40%) .NET
2 173 (7.31%) Web Services
3 136 (5.74%) MDX
4 130 (5.49%) Kafka
5 129 (5.45%) XML
6 94 (3.97%) HTML
7 79 (3.34%) JSON
8 73 (3.08%) .NET Framework
9 55 (2.32%) Middleware
10 50 (2.11%) Entity Framework
11 49 (2.07%) CSS
12 46 (1.94%) ASP.NET
13 41 (1.73%) REST
14 39 (1.65%) AngularJS
15 30 (1.27%) Spark Streaming
16 27 (1.14%) React
17 26 (1.10%) Oracle GoldenGate
18 25 (1.06%) ASP.NET Web API
19 22 (0.93%) SOAP
20 21 (0.89%) WCF
Miscellaneous
1 325 (13.72%) Analytical Skills
2 118 (4.98%) Data Structures
3 113 (4.77%) Computer Science
4 89 (3.76%) Greenfield Project
5 70 (2.96%) Replication
6 66 (2.79%) Algorithms
6 66 (2.79%) Management Information System
7 61 (2.58%) Fintech
8 52 (2.20%) Reinsurance
9 43 (1.82%) Equities
10 42 (1.77%) Credit Risk
10 42 (1.77%) Reference Data
11 40 (1.69%) Self-Motivation
12 36 (1.52%) NHS
13 32 (1.35%) User Experience
14 30 (1.27%) Hedge funds
15 28 (1.18%) Enterprise Software
16 26 (1.10%) Market Risk
17 24 (1.01%) Foreign Exchange (FX)
18 23 (0.97%) Derivative
Operating Systems
1 133 (5.62%) Unix
1 133 (5.62%) Windows
2 131 (5.53%) Linux
3 41 (1.73%) Windows Server
4 30 (1.27%) Solaris
5 23 (0.97%) Red Hat Enterprise Linux
6 22 (0.93%) HPUX
7 19 (0.80%) AIX
8 15 (0.63%) Windows Server 2008
9 10 (0.42%) Apple iOS
10 7 (0.30%) Windows Server 2012
11 4 (0.17%) Mac OS X
11 4 (0.17%) zOS
12 3 (0.13%) CentOS
13 2 (0.084%) VMS
13 2 (0.084%) Windows 10
14 1 (0.042%) DC/OS
14 1 (0.042%) Oracle Linux
Processes & Methodologies
1 1,478 (62.42%) Business Intelligence
2 1,051 (44.38%) ETL
3 699 (29.52%) Agile Software Development
4 674 (28.46%) Analytics
5 446 (18.83%) Data Modelling
6 328 (13.85%) Visualisation
7 280 (11.82%) Data Management
8 269 (11.36%) Kimball Methodology
9 229 (9.67%) Scrum
10 223 (9.42%) Performance Tuning
11 206 (8.70%) Data Integration
11 206 (8.70%) Problem-Solving
12 203 (8.57%) Machine Learning
13 200 (8.45%) SDLC
14 196 (8.28%) Data Science
15 194 (8.19%) Migration
16 191 (8.07%) Data Analysis
17 184 (7.77%) Dimensional Modelling
18 180 (7.60%) Data Architecture
19 170 (7.18%) Data Analytics
Programming Languages
1 1,615 (68.20%) SQL
2 620 (26.18%) T-SQL
3 376 (15.88%) Python
4 336 (14.19%) C#
5 199 (8.40%) Java
6 162 (6.84%) PL/SQL
7 123 (5.19%) R
8 116 (4.90%) PowerShell
9 110 (4.65%) JavaScript
10 104 (4.39%) Data Analysis Expressions (DAX)
11 68 (2.87%) VBA
12 61 (2.58%) Scala
13 51 (2.15%) Shell Script
14 42 (1.77%) VB
15 37 (1.56%) U-SQL
15 37 (1.56%) VB.NET
16 30 (1.27%) PHP
17 27 (1.14%) Perl
18 19 (0.80%) C
19 16 (0.68%) Go
Qualifications
1 254 (10.73%) Degree
2 71 (3.00%) Microsoft Certification
3 58 (2.45%) Computer Science Degree
4 29 (1.22%) Security Cleared
5 23 (0.97%) ISEB
6 22 (0.93%) PMP
7 20 (0.84%) MCSA
8 19 (0.80%) PMI Certification
9 16 (0.68%) PRINCE2 Certification
10 14 (0.59%) Master's Degree
10 14 (0.59%) MCSE
11 13 (0.55%) MCITP
12 10 (0.42%) Numerate Degree
12 10 (0.42%) SC Cleared
13 9 (0.38%) ITIL Certification
13 9 (0.38%) ITIL Foundation Certificate
13 9 (0.38%) PhD
14 8 (0.34%) TOGAF Certification
15 7 (0.30%) ACCA
15 7 (0.30%) VMware Certified Professional (VCP)
Quality Assurance & Compliance
1 274 (11.57%) Data Quality
2 134 (5.66%) QA
3 54 (2.28%) GDPR
4 17 (0.72%) Solvency II
5 13 (0.55%) PMO
6 8 (0.34%) MiFID
7 7 (0.30%) IFRS
7 7 (0.30%) SLA
8 5 (0.21%) IFRS 9
9 3 (0.13%) PCI DSS
10 2 (0.084%) ISO/IEC 27001
10 2 (0.084%) PSD2
11 1 (0.042%) Dodd-Frank
11 1 (0.042%) EMIR
11 1 (0.042%) FATCA
11 1 (0.042%) GAAP
11 1 (0.042%) Sarbanes-Oxley
System Software
1 49 (2.07%) Docker
2 32 (1.35%) HDFS
3 25 (1.06%) Apache Flume
4 19 (0.80%) Active Directory
5 11 (0.46%) VMware Infrastructure
6 10 (0.42%) Apache ZooKeeper
6 10 (0.42%) Hyper-V
6 10 (0.42%) Oracle RAC
7 8 (0.34%) Virtual Machines
8 7 (0.30%) vSphere
9 3 (0.13%) Varnish
10 1 (0.042%) Terminal Services
10 1 (0.042%) VMware ESXi
Systems Management
1 34 (1.44%) Automic
2 27 (1.14%) Kubernetes
3 25 (1.06%) Opscode Chef
4 24 (1.01%) Puppet
5 23 (0.97%) Control-M
5 23 (0.97%) Terraform
6 16 (0.68%) Oracle Enterprise Manager
6 16 (0.68%) Oracle RMAN
7 14 (0.59%) Ansible
7 14 (0.59%) Mesos
8 12 (0.51%) Dollar Universe
9 11 (0.46%) Oozie
10 10 (0.42%) Hadoop YARN
11 7 (0.30%) Oracle ZFS
12 5 (0.21%) Docker Swarm
12 5 (0.21%) Kibana
12 5 (0.21%) NetBackup
12 5 (0.21%) Unicenter
13 4 (0.17%) Rundeck
14 3 (0.13%) Data Guard
Vendors
1 868 (36.66%) Microsoft
2 392 (16.55%) Oracle
3 370 (15.63%) Tableau
4 148 (6.25%) Informatica
5 135 (5.70%) SAP
6 91 (3.84%) Google
7 89 (3.76%) Cognos
8 72 (3.04%) IBM
9 64 (2.70%) Talend
10 47 (1.98%) Cloudera
11 46 (1.94%) MicroStrategy
12 41 (1.73%) Teradata
13 33 (1.39%) Salesforce.com
14 32 (1.35%) Databricks
14 32 (1.35%) VMware
15 29 (1.22%) Red Hat
16 24 (1.01%) MapR
17 23 (0.97%) HP
18 22 (0.93%) Citrix
18 22 (0.93%) Vertica