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

Data Warehousing
England > London
6 months to
16 Jul 2018
Same period 2017 Same period 2016
Rank 91 98 78
Rank change year-on-year +7 -20 -6
Permanent jobs citing Data Warehouse 2,442 2,385 3,207
As % of all permanent IT jobs advertised in London 3.41% 3.27% 3.86%
As % of the Database & Business Intelligence category 10.82% 10.97% 12.76%
Number of salaries quoted 1,995 1,910 2,754
London median annual salary £62,500 £60,000 £60,000
Median salary % change year-on-year +4.17% - -
10th Percentile £41,250 £40,000 £41,250
90th Percentile £90,000 £87,500 £85,000
England median annual salary £52,500 £50,000 £52,500
% change year-on-year +5.00% -4.76% +1.94%

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 22,579 21,745 25,143
As % of all permanent IT jobs advertised in London 31.54% 29.77% 30.24%
Number of salaries quoted 17,795 18,158 21,945
London median annual salary £62,500 £60,000 £55,500
Median salary % change year-on-year +4.17% +8.11% +0.91%
10th Percentile £37,500 £36,250 £35,500
90th Percentile £92,500 £90,000 £85,000
England median annual salary £50,000 £47,500 £47,500
% change year-on-year +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 16 July 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 16 July 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 -7 631 £65,000 +8.33% 98
West London +86 126 £55,000 +4.76% 27
South London +47 83 £51,000 +7.37% 10
East London +7 32 £67,500 +42.11% 17
North London +6 4 £47,500 -36.67% 4
Data Warehouse
England

For the 6 months to 16 July 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,619 (66.30%) SQL
2 1,526 (62.49%) Business Intelligence
3 1,316 (53.89%) SQL Server
4 1,145 (46.89%) SQL Server Integration Services
5 1,113 (45.58%) ETL
6 877 (35.91%) SQL Server Reporting Services
7 863 (35.34%) Microsoft
8 764 (31.29%) SQL Server Analysis Services
9 752 (30.79%) Finance
10 728 (29.81%) Agile Software Development
11 653 (26.74%) T-SQL
12 616 (25.23%) Analytics
13 535 (21.91%) Power BI
14 502 (20.56%) Big Data
15 497 (20.35%) Data Modelling
16 474 (19.41%) Oracle
17 407 (16.67%) Microsoft Azure
18 397 (16.26%) .NET
19 312 (12.78%) Data Quality
20 307 (12.57%) Analytical Skills
21 305 (12.49%) Tableau
22 284 (11.63%) Python
23 282 (11.55%) C#
24 277 (11.34%) Data Management
25 266 (10.89%) Kimball Methodology
26 263 (10.77%) Visualisation
27 260 (10.65%) Degree
28 251 (10.28%) Data Integration
29 248 (10.16%) Problem-Solving
30 247 (10.11%) Hadoop

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 161 (6.59%) Apache Spark
2 110 (4.50%) SAS
3 56 (2.29%) Apache
4 48 (1.97%) IIS
4 48 (1.97%) SharePoint
5 37 (1.52%) Confluence
6 20 (0.82%) Elasticsearch
7 18 (0.74%) Apache Pig
8 13 (0.53%) Apache Solr
9 12 (0.49%) CMS
10 8 (0.33%) Hyperledger
10 8 (0.33%) WebLogic
10 8 (0.33%) WebLogic Portal
11 7 (0.29%) Oracle SOA Suite
12 6 (0.25%) Apache Airflow
13 5 (0.20%) R Markdown
14 4 (0.16%) Tuxedo
14 4 (0.16%) WebSphere
15 3 (0.12%) SharePoint 2010
16 2 (0.082%) Sitecore CMS
Applications
1 128 (5.24%) Microsoft Excel
2 45 (1.84%) MS Visio
3 35 (1.43%) Microsoft Office
4 15 (0.61%) Microsoft PowerPoint
5 6 (0.25%) Microsoft Project
5 6 (0.25%) SPSS
6 3 (0.12%) Spreadsheet
6 3 (0.12%) Stata
7 1 (0.041%) CPLEX
7 1 (0.041%) EViews
Business Applications
1 50 (2.05%) Markit EDM
2 25 (1.02%) Dynamics CRM
2 25 (1.02%) NetSuite
3 11 (0.45%) Salesforce.com CRM
4 10 (0.41%) Dynamics AX
5 9 (0.37%) MetaTrader
6 7 (0.29%) Dynamics NAV
6 7 (0.29%) Remedy ITSM
7 6 (0.25%) Cognos Business Intelligence
8 5 (0.20%) FastStats
8 5 (0.20%) Oracle EBS
8 5 (0.20%) SAP S/4HANA
9 4 (0.16%) Eagle PACE
9 4 (0.16%) Oracle Retail
10 3 (0.12%) Cognos TM1
10 3 (0.12%) Elite 3E
11 2 (0.082%) SAP CO
11 2 (0.082%) SAP FI
11 2 (0.082%) SAP FI/CO
11 2 (0.082%) SAP MDG
Cloud Services
1 407 (16.67%) Microsoft Azure
2 216 (8.85%) Amazon AWS
3 86 (3.52%) Azure Data Factory
4 37 (1.52%) PaaS
4 37 (1.52%) SaaS
5 35 (1.43%) Google Cloud Platform
6 29 (1.19%) Cloud Computing
7 25 (1.02%) Cortana Intelligence Suite
7 25 (1.02%) Serverless
8 24 (0.98%) Amazon EMR
9 21 (0.86%) Amazon S3
9 21 (0.86%) Data Lake Analytics
10 19 (0.78%) AWS Lambda
11 18 (0.74%) IaaS
12 16 (0.66%) Amazon EC2
12 16 (0.66%) Office 365
13 13 (0.53%) Amazon Kinesis
14 12 (0.49%) Azure Machine Learning
14 12 (0.49%) Dynamics 365
15 8 (0.33%) Google Analytics
Communications & Networking
1 27 (1.11%) Internet
2 16 (0.66%) SSL
3 12 (0.49%) HTTP
4 5 (0.20%) DNS
4 5 (0.20%) Network Security
5 4 (0.16%) Firewall
5 4 (0.16%) SAN
6 3 (0.12%) HTTPS
6 3 (0.12%) LAN
6 3 (0.12%) SMS
6 3 (0.12%) TCP/IP
6 3 (0.12%) WAN
7 2 (0.082%) DHCP
7 2 (0.082%) Wi-Fi
8 1 (0.041%) 3G
8 1 (0.041%) 4G
8 1 (0.041%) Intranet
8 1 (0.041%) SSH
8 1 (0.041%) VLAN
8 1 (0.041%) VPN
Database & Business Intelligence
1 1,316 (53.89%) SQL Server
2 1,145 (46.89%) SQL Server Integration Services
3 877 (35.91%) SQL Server Reporting Services
4 764 (31.29%) SQL Server Analysis Services
5 535 (21.91%) Power BI
6 502 (20.56%) Big Data
7 247 (10.11%) Hadoop
8 242 (9.91%) Relational Database
9 207 (8.48%) Data Lake
10 186 (7.62%) OLAP
11 160 (6.55%) SQL Server 2016
12 155 (6.35%) BusinessObjects
13 153 (6.27%) SQL Server 2014
14 148 (6.06%) Microsoft Analysis Services
15 142 (5.81%) SQL Server 2012
16 138 (5.65%) SQL Server 2008
17 130 (5.32%) NoSQL
18 117 (4.79%) Apache Hive
19 112 (4.59%) QlikView
20 106 (4.34%) MySQL
Development Applications
1 119 (4.87%) Team Foundation Server
2 87 (3.56%) JIRA
3 78 (3.19%) Visual Studio
4 40 (1.64%) Jenkins
5 33 (1.35%) Git (software)
6 31 (1.27%) SQL Server Management Studio (SSMS)
7 30 (1.23%) ERwin
8 28 (1.15%) TeamCity
9 26 (1.06%) Selenium
10 18 (0.74%) Octopus Deploy
11 16 (0.66%) Subversion
12 14 (0.57%) Eclipse
12 14 (0.57%) Oracle Forms
13 13 (0.53%) Visual Studio Team System
14 12 (0.49%) RStudio
14 12 (0.49%) Toad
15 11 (0.45%) ER Studio
15 11 (0.45%) Oracle APEX
16 10 (0.41%) Bitbucket
16 10 (0.41%) Cucumber
General
1 752 (30.79%) Finance
2 196 (8.03%) Banking
3 154 (6.31%) Retail
4 138 (5.65%) Advertising
5 116 (4.75%) Marketing
6 48 (1.97%) Games
7 45 (1.84%) Investment Banking
8 25 (1.02%) Financial Institution
9 24 (0.98%) Back Office
9 24 (0.98%) Front Office
10 23 (0.94%) Legal
11 20 (0.82%) Publishing
12 18 (0.74%) Law
13 16 (0.66%) Pharmaceutical
13 16 (0.66%) Telecoms
14 14 (0.57%) General Ledger
15 10 (0.41%) Local Government
16 8 (0.33%) Billing
16 8 (0.33%) Manufacturing
16 8 (0.33%) Music Industry
Job Titles
1 1,075 (44.02%) Developer
2 531 (21.74%) Business Intelligence Developer
3 467 (19.12%) SQL Developer
4 374 (15.32%) Analyst
5 315 (12.90%) Architect
6 250 (10.24%) SSIS Developer
7 219 (8.97%) SQL BI Developer
8 199 (8.15%) Data Warehouse Developer
9 196 (8.03%) Data Architect
10 190 (7.78%) SQL Server Developer
11 186 (7.62%) SSRS Developer
12 174 (7.13%) Consultant
13 151 (6.18%) Data Engineer
14 146 (5.98%) SSAS Developer
15 115 (4.71%) Business Intelligence Analyst
15 115 (4.71%) ETL Developer
16 113 (4.63%) Data Analyst
17 111 (4.55%) Business Analyst
18 110 (4.50%) SQL Server BI Developer
19 93 (3.81%) Senior Developer
Libraries, Frameworks & Software Standards
1 397 (16.26%) .NET
2 190 (7.78%) Web Services
3 165 (6.76%) XML
4 123 (5.04%) MDX
5 110 (4.50%) Kafka
6 109 (4.46%) .NET Framework
6 109 (4.46%) HTML
7 83 (3.40%) Entity Framework
8 76 (3.11%) JSON
9 46 (1.88%) CSS
10 41 (1.68%) SOAP
11 35 (1.43%) ASP.NET
12 31 (1.27%) REST
13 28 (1.15%) WPF
14 27 (1.11%) RESTful
15 25 (1.02%) JSP
16 24 (0.98%) WSDL
17 23 (0.94%) WCF
18 20 (0.82%) AngularJS
19 18 (0.74%) Oracle GoldenGate
Miscellaneous
1 307 (12.57%) Analytical Skills
2 133 (5.45%) Computer Science
3 117 (4.79%) Greenfield Project
4 109 (4.46%) Management Information System
5 82 (3.36%) Algorithms
6 77 (3.15%) Data Structures
7 72 (2.95%) Replication
8 63 (2.58%) Fintech
9 62 (2.54%) Self-Motivation
10 53 (2.17%) User Experience
11 45 (1.84%) Credit Risk
12 44 (1.80%) Hedge funds
13 39 (1.60%) Equities
14 35 (1.43%) Reinsurance
15 33 (1.35%) Enterprise Software
15 33 (1.35%) Market Risk
16 31 (1.27%) Derivative
17 28 (1.15%) Data Centre
18 27 (1.11%) Foreign Exchange (FX)
19 25 (1.02%) Fixed Income
Operating Systems
1 129 (5.28%) Unix
2 127 (5.20%) Linux
3 111 (4.55%) Windows
4 39 (1.60%) Solaris
5 31 (1.27%) AIX
5 31 (1.27%) HPUX
6 23 (0.94%) Windows Server
7 11 (0.45%) Red Hat Enterprise Linux
7 11 (0.45%) Windows Server 2008
8 9 (0.37%) Windows Server 2012
9 2 (0.082%) Android
9 2 (0.082%) Apple iOS
9 2 (0.082%) CentOS
9 2 (0.082%) Mac OS X
10 1 (0.041%) Oracle Linux
Processes & Methodologies
1 1,526 (62.49%) Business Intelligence
2 1,113 (45.58%) ETL
3 728 (29.81%) Agile Software Development
4 616 (25.23%) Analytics
5 497 (20.35%) Data Modelling
6 277 (11.34%) Data Management
7 266 (10.89%) Kimball Methodology
8 263 (10.77%) Visualisation
9 251 (10.28%) Data Integration
10 248 (10.16%) Problem-Solving
11 239 (9.79%) Data Architecture
12 237 (9.71%) Data Analysis
13 228 (9.34%) Scrum
14 210 (8.60%) Migration
15 208 (8.52%) SDLC
16 194 (7.94%) Performance Tuning
17 178 (7.29%) Data Science
18 158 (6.47%) Data Analytics
19 155 (6.35%) Data Governance
20 145 (5.94%) Data Visualisation
Programming Languages
1 1,619 (66.30%) SQL
2 653 (26.74%) T-SQL
3 284 (11.63%) Python
4 282 (11.55%) C#
5 243 (9.95%) Java
6 148 (6.06%) PL/SQL
7 123 (5.04%) JavaScript
8 115 (4.71%) R
9 97 (3.97%) PowerShell
10 92 (3.77%) Data Analysis Expressions (DAX)
11 86 (3.52%) Scala
12 47 (1.92%) Shell Script
13 42 (1.72%) VBA
14 41 (1.68%) Perl
15 31 (1.27%) VB.NET
16 30 (1.23%) C++
17 24 (0.98%) PHP
17 24 (0.98%) VB
17 24 (0.98%) VBScript
18 21 (0.86%) MATLAB
Qualifications
1 260 (10.65%) Degree
2 55 (2.25%) Microsoft Certification
3 53 (2.17%) Computer Science Degree
4 40 (1.64%) ISEB
5 30 (1.23%) ITIL Certification
6 25 (1.02%) Master's Degree
7 22 (0.90%) Security Cleared
8 17 (0.70%) MCITP
9 16 (0.66%) TOGAF Certification
10 15 (0.61%) Microsoft Certified Architect
11 13 (0.53%) ISTQB
11 13 (0.53%) PMI Certification
12 12 (0.49%) PMP
13 11 (0.45%) MCSE
14 10 (0.41%) Numerate Degree
15 9 (0.37%) ACCA
15 9 (0.37%) SC Cleared
16 8 (0.33%) MBA
17 6 (0.25%) MCSA
17 6 (0.25%) PRINCE2 Certification
Quality Assurance & Compliance
1 312 (12.78%) Data Quality
2 136 (5.57%) QA
3 41 (1.68%) GDPR
4 11 (0.45%) PMO
5 9 (0.37%) IFRS
5 9 (0.37%) Solvency II
6 8 (0.33%) IFRS 9
7 7 (0.29%) MiFID
8 6 (0.25%) PCI DSS
9 4 (0.16%) Sarbanes-Oxley
9 4 (0.16%) SLA
10 3 (0.12%) GAAP
10 3 (0.12%) GCP
11 2 (0.082%) EMIR
11 2 (0.082%) HL7
11 2 (0.082%) PSD2
12 1 (0.041%) Basel III
12 1 (0.041%) CRD IV
System Software
1 52 (2.13%) HDFS
2 26 (1.06%) Docker
3 22 (0.90%) Apache Flume
4 11 (0.45%) Active Directory
4 11 (0.45%) Apache ZooKeeper
5 9 (0.37%) Oracle RAC
6 6 (0.25%) VMware Infrastructure
6 6 (0.25%) vSphere
7 2 (0.082%) Hyper-V
8 1 (0.041%) Virtual Machines
Systems Management
1 20 (0.82%) Mesos
1 20 (0.82%) Oozie
2 17 (0.70%) Automic
2 17 (0.70%) Hadoop YARN
3 16 (0.66%) Dollar Universe
4 15 (0.61%) Ambari
4 15 (0.61%) Control-M
5 14 (0.57%) Puppet
6 13 (0.53%) Opscode Chef
6 13 (0.53%) Oracle Enterprise Manager
7 9 (0.37%) Kibana
7 9 (0.37%) Terraform
8 8 (0.33%) Kubernetes
9 7 (0.29%) Ansible
9 7 (0.29%) Oracle ZFS
10 5 (0.20%) Failover Clustering
10 5 (0.20%) NetBackup
10 5 (0.20%) Oracle RMAN
10 5 (0.20%) Unicenter
11 4 (0.16%) HP Quality Center
Vendors
1 863 (35.34%) Microsoft
2 474 (19.41%) Oracle
3 305 (12.49%) Tableau
4 139 (5.69%) Informatica
5 115 (4.71%) SAP
6 97 (3.97%) Cognos
7 78 (3.19%) Talend
8 72 (2.95%) IBM
9 67 (2.74%) MicroStrategy
10 56 (2.29%) Salesforce.com
11 53 (2.17%) Google
12 44 (1.80%) Cloudera
13 31 (1.27%) Cognizant
14 28 (1.15%) Teradata
15 27 (1.11%) RedGate
16 24 (0.98%) Vermilion
17 21 (0.86%) TIBCO
18 20 (0.82%) Infor
19 19 (0.78%) Alteryx
19 19 (0.78%) Epicor