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

Data Warehousing
England > London
6 months to
26 Apr 2018
Same period 2017 Same period 2016
Rank 98 94 73
Rank change year-on-year -4 -21 -3
Permanent jobs citing Data Warehouse 2,243 2,176 3,508
As % of all permanent IT jobs advertised in London 3.21% 3.20% 4.18%
As % of the Database & Business Intelligence category 10.42% 10.60% 13.38%
Number of salaries quoted 1,801 1,889 2,945
London median annual salary £60,000 £60,000 £57,500
Median salary % change year-on-year - +4.35% -4.17%
10th Percentile £40,000 £37,894 £40,000
90th Percentile £90,000 £90,000 £85,000
England median annual salary £52,500 £52,500 £52,500

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 21,529 20,519 26,228
As % of all permanent IT jobs advertised in London 30.81% 30.14% 31.23%
Number of salaries quoted 17,637 17,850 22,851
London median annual salary £60,000 £60,000 £55,000
Median salary % change year-on-year - +9.09% -
10th Percentile £37,500 £35,250 £36,250
90th Percentile £92,500 £88,750 £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 26 April 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 26 April 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 -8 598 £62,500 +8.70% 75
West London +16 95 £55,000 - 32
South London +16 58 £49,500 -26.67% 9
East London +13 18 £70,000 - 11
North London +12 14 £42,500 -43.33% 5
Data Warehouse
England

For the 6 months to 26 April 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,469 (65.49%) SQL
2 1,437 (64.07%) Business Intelligence
3 1,247 (55.60%) SQL Server
4 1,080 (48.15%) ETL
5 1,000 (44.58%) SQL Server Integration Services
6 791 (35.27%) Microsoft
7 738 (32.90%) SQL Server Reporting Services
8 708 (31.56%) Finance
9 683 (30.45%) SQL Server Analysis Services
10 647 (28.85%) Agile Software Development
11 594 (26.48%) Analytics
12 562 (25.06%) T-SQL
13 524 (23.36%) Data Modelling
14 456 (20.33%) Big Data
15 445 (19.84%) Power BI
16 422 (18.81%) Oracle
17 383 (17.08%) Microsoft Azure
18 340 (15.16%) Analytical Skills
19 293 (13.06%) Tableau
20 292 (13.02%) Python
21 289 (12.88%) .NET
22 281 (12.53%) Data Quality
23 266 (11.86%) Visualisation
24 259 (11.55%) Problem-Solving
25 254 (11.32%) Data Architecture
26 249 (11.10%) Data Management
27 246 (10.97%) Data Integration
28 242 (10.79%) Degree
29 238 (10.61%) Kimball Methodology
30 234 (10.43%) 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 184 (8.20%) Apache Spark
2 104 (4.64%) SAS
3 50 (2.23%) SharePoint
4 44 (1.96%) Confluence
5 35 (1.56%) Apache
6 26 (1.16%) Elasticsearch
7 22 (0.98%) IIS
8 19 (0.85%) Apache Solr
9 12 (0.53%) Apache Airflow
10 6 (0.27%) Oracle SOA Suite
10 6 (0.27%) WebLogic
10 6 (0.27%) WebSphere
11 5 (0.22%) Luigi
11 5 (0.22%) R Markdown
11 5 (0.22%) WebLogic Portal
12 4 (0.18%) Apache Pig
12 4 (0.18%) SharePoint Server
12 4 (0.18%) Tuxedo
13 3 (0.13%) NetWeaver
14 2 (0.089%) BizTalk Server
Applications
1 115 (5.13%) Microsoft Excel
2 47 (2.10%) MS Visio
3 29 (1.29%) Microsoft Office
4 11 (0.49%) SPSS
5 8 (0.36%) Microsoft PowerPoint
6 6 (0.27%) Microsoft Project
7 2 (0.089%) Spreadsheet
8 1 (0.045%) CPLEX
Business Applications
1 47 (2.10%) Markit EDM
2 26 (1.16%) NetSuite
3 20 (0.89%) Dynamics CRM
4 12 (0.53%) Salesforce.com CRM
5 9 (0.40%) Elite 3E
5 9 (0.40%) MetaTrader
6 8 (0.36%) Eagle PACE
7 7 (0.31%) Cognos TM1
7 7 (0.31%) Dynamics AX
8 6 (0.27%) HFM
8 6 (0.27%) Oracle EBS
8 6 (0.27%) Oracle Retail
8 6 (0.27%) SAP S/4HANA
9 5 (0.22%) Cognos Business Intelligence
10 3 (0.13%) Unit4 Business World
11 2 (0.089%) Dynamics NAV
11 2 (0.089%) SAP ERP
11 2 (0.089%) SAP MDG
12 1 (0.045%) thinkFolio
12 1 (0.045%) TIBCO BusinessEvents
Cloud Services
1 383 (17.08%) Microsoft Azure
2 220 (9.81%) Amazon AWS
3 70 (3.12%) Azure Data Factory
4 49 (2.18%) Google Cloud Platform
5 38 (1.69%) SaaS
6 30 (1.34%) PaaS
7 28 (1.25%) Cortana Intelligence Suite
8 27 (1.20%) Amazon EMR
9 25 (1.11%) Cloud Computing
10 22 (0.98%) Azure Machine Learning
11 21 (0.94%) Amazon Kinesis
12 18 (0.80%) IaaS
12 18 (0.80%) Office 365
13 17 (0.76%) Serverless
14 16 (0.71%) Amazon S3
14 16 (0.71%) AWS Lambda
15 10 (0.45%) Data Lake Analytics
16 9 (0.40%) Dynamics 365
17 6 (0.27%) Amazon EC2
17 6 (0.27%) IBM Blueworks
Communications & Networking
1 21 (0.94%) SSL
2 18 (0.80%) Internet
3 15 (0.67%) HTTP
4 7 (0.31%) SMS
5 5 (0.22%) Network Security
6 4 (0.18%) Firewall
7 3 (0.13%) DNS
8 2 (0.089%) DHCP
8 2 (0.089%) Intranet
8 2 (0.089%) SAN
9 1 (0.045%) Broadband
9 1 (0.045%) HTTPS
9 1 (0.045%) LAN
9 1 (0.045%) TCP/IP
9 1 (0.045%) VLAN
9 1 (0.045%) VPN
9 1 (0.045%) WAN
Database & Business Intelligence
1 1,247 (55.60%) SQL Server
2 1,000 (44.58%) SQL Server Integration Services
3 738 (32.90%) SQL Server Reporting Services
4 683 (30.45%) SQL Server Analysis Services
5 456 (20.33%) Big Data
6 445 (19.84%) Power BI
7 234 (10.43%) Hadoop
8 199 (8.87%) Relational Database
9 171 (7.62%) BusinessObjects
10 170 (7.58%) Data Lake
11 161 (7.18%) OLAP
12 151 (6.73%) SQL Server 2016
13 147 (6.55%) QlikView
14 138 (6.15%) MySQL
15 127 (5.66%) Microsoft Analysis Services
16 120 (5.35%) SQL Server 2014
17 116 (5.17%) SQL Server 2012
18 113 (5.04%) Star Schema
19 112 (4.99%) NoSQL
20 105 (4.68%) Amazon Redshift
Development Applications
1 104 (4.64%) JIRA
2 63 (2.81%) Team Foundation Server
3 45 (2.01%) Visual Studio
4 42 (1.87%) ERwin
5 40 (1.78%) Git (software)
5 40 (1.78%) SQL Server Management Studio (SSMS)
6 32 (1.43%) Jenkins
7 28 (1.25%) Selenium
8 23 (1.03%) Subversion
9 20 (0.89%) TeamCity
10 18 (0.80%) Eclipse
11 13 (0.58%) Cucumber
12 11 (0.49%) Bitbucket
12 11 (0.49%) Oracle Forms
13 9 (0.40%) Atlassian Bamboo
13 9 (0.40%) Maven
13 9 (0.40%) Oracle APEX
14 8 (0.36%) Toad
15 7 (0.31%) RStudio
16 6 (0.27%) Rational Functional Tester
General
1 708 (31.56%) Finance
2 163 (7.27%) Advertising
3 147 (6.55%) Banking
4 119 (5.31%) Retail
5 115 (5.13%) Marketing
6 44 (1.96%) Games
7 31 (1.38%) Financial Institution
8 28 (1.25%) Telecoms
9 27 (1.20%) Front Office
10 23 (1.03%) Investment Banking
10 23 (1.03%) Law
11 22 (0.98%) Legal
12 20 (0.89%) Pharmaceutical
13 18 (0.80%) Manufacturing
14 15 (0.67%) Publishing
15 13 (0.58%) Back Office
16 11 (0.49%) Polish Language
17 10 (0.45%) General Ledger
18 8 (0.36%) Electronics
19 7 (0.31%) Billing
Job Titles
1 930 (41.46%) Developer
2 463 (20.64%) Business Intelligence Developer
3 379 (16.90%) SQL Developer
4 363 (16.18%) Analyst
5 304 (13.55%) Architect
6 204 (9.09%) SSIS Developer
7 202 (9.01%) Data Architect
8 180 (8.02%) Consultant
9 174 (7.76%) SQL BI Developer
10 171 (7.62%) Data Warehouse Developer
11 154 (6.87%) SQL Server Developer
12 145 (6.46%) Business Analyst
13 134 (5.97%) SSRS Developer
14 133 (5.93%) Data Engineer
15 110 (4.90%) ETL Developer
16 100 (4.46%) Business Intelligence Analyst
16 100 (4.46%) SSAS Developer
17 95 (4.24%) Data Analyst
18 94 (4.19%) SQL Server BI Developer
19 77 (3.43%) Data Business Analyst
Libraries, Frameworks & Software Standards
1 289 (12.88%) .NET
2 170 (7.58%) Web Services
3 136 (6.06%) XML
4 104 (4.64%) Kafka
5 92 (4.10%) HTML
5 92 (4.10%) MDX
6 73 (3.25%) JSON
7 51 (2.27%) .NET Framework
8 42 (1.87%) AngularJS
9 41 (1.83%) ASP.NET
9 41 (1.83%) SOAP
10 40 (1.78%) CSS
11 34 (1.52%) Entity Framework
12 26 (1.16%) WSDL
13 25 (1.11%) React
14 23 (1.03%) Node.js
14 23 (1.03%) WPF
15 22 (0.98%) jQuery
16 18 (0.80%) Angular 2
17 17 (0.76%) Elastic Stack
Miscellaneous
1 340 (15.16%) Analytical Skills
2 139 (6.20%) Computer Science
3 101 (4.50%) Management Information System
4 88 (3.92%) Greenfield Project
5 79 (3.52%) Self-Motivation
6 72 (3.21%) Data Structures
7 66 (2.94%) Fintech
8 54 (2.41%) User Experience
9 49 (2.18%) Algorithms
10 45 (2.01%) Replication
11 43 (1.92%) Data Centre
12 34 (1.52%) Hedge funds
13 32 (1.43%) Credit Risk
13 32 (1.43%) Enterprise Software
14 30 (1.34%) Equities
15 28 (1.25%) Reinsurance
16 24 (1.07%) Clustering
16 24 (1.07%) Virtual Team
17 23 (1.03%) Life Science
17 23 (1.03%) Mobile App
Operating Systems
1 130 (5.80%) Linux
2 102 (4.55%) Unix
3 86 (3.83%) Windows
4 20 (0.89%) AIX
4 20 (0.89%) HPUX
4 20 (0.89%) Solaris
5 16 (0.71%) Windows Server
6 6 (0.27%) Windows Server 2008
7 5 (0.22%) Android
8 4 (0.18%) Apple iOS
8 4 (0.18%) Windows Server 2012
9 2 (0.089%) Mac OS X
10 1 (0.045%) Red Hat Enterprise Linux
Processes & Methodologies
1 1,437 (64.07%) Business Intelligence
2 1,080 (48.15%) ETL
3 647 (28.85%) Agile Software Development
4 594 (26.48%) Analytics
5 524 (23.36%) Data Modelling
6 266 (11.86%) Visualisation
7 259 (11.55%) Problem-Solving
8 254 (11.32%) Data Architecture
9 249 (11.10%) Data Management
10 246 (10.97%) Data Integration
11 238 (10.61%) Kimball Methodology
12 217 (9.67%) Data Analysis
13 192 (8.56%) SDLC
14 188 (8.38%) Data Governance
15 187 (8.34%) Scrum
16 179 (7.98%) Migration
17 176 (7.85%) Data Visualisation
18 174 (7.76%) Data Science
19 170 (7.58%) Performance Tuning
20 150 (6.69%) Data Analytics
Programming Languages
1 1,469 (65.49%) SQL
2 562 (25.06%) T-SQL
3 292 (13.02%) Python
4 224 (9.99%) C#
5 222 (9.90%) Java
6 119 (5.31%) R
7 110 (4.90%) JavaScript
8 105 (4.68%) PL/SQL
9 89 (3.97%) Scala
10 82 (3.66%) Data Analysis Expressions (DAX)
11 68 (3.03%) PowerShell
12 38 (1.69%) Shell Script
13 36 (1.60%) Perl
14 33 (1.47%) PHP
14 33 (1.47%) VBScript
15 30 (1.34%) VBA
16 29 (1.29%) C++
16 29 (1.29%) MATLAB
17 28 (1.25%) VB
18 21 (0.94%) VB.NET
Qualifications
1 242 (10.79%) Degree
2 52 (2.32%) Computer Science Degree
3 48 (2.14%) ISEB
4 40 (1.78%) ITIL Certification
5 26 (1.16%) TOGAF Certification
6 23 (1.03%) Microsoft Certification
7 21 (0.94%) Security Cleared
8 20 (0.89%) ISTQB
8 20 (0.89%) PMI Certification
9 14 (0.62%) Master's Degree
10 13 (0.58%) Microsoft Certified Architect
11 10 (0.45%) MBA
12 9 (0.40%) MCSD
13 8 (0.36%) Numerate Degree
13 8 (0.36%) PMP
14 6 (0.27%) MCITP
15 5 (0.22%) PhD
15 5 (0.22%) SC Cleared
16 4 (0.18%) ACCA
17 3 (0.13%) MCSA
Quality Assurance & Compliance
1 281 (12.53%) Data Quality
2 166 (7.40%) QA
3 32 (1.43%) GDPR
4 18 (0.80%) Solvency II
5 8 (0.36%) PMO
6 6 (0.27%) IFRS
6 6 (0.27%) IFRS 9
7 5 (0.22%) GCP
7 5 (0.22%) PCI DSS
8 4 (0.18%) SLA
9 3 (0.13%) MiFID
9 3 (0.13%) Sarbanes-Oxley
10 2 (0.089%) GAAP
10 2 (0.089%) HL7
11 1 (0.045%) Basel III
11 1 (0.045%) CRD IV
11 1 (0.045%) EMIR
System Software
1 45 (2.01%) HDFS
2 19 (0.85%) Docker
3 12 (0.53%) Apache Flume
4 11 (0.49%) Active Directory
5 7 (0.31%) Apache ZooKeeper
6 3 (0.13%) Hyper-V
7 2 (0.089%) Virtual Machines
7 2 (0.089%) VMware Infrastructure
8 1 (0.045%) vSphere
Systems Management
1 23 (1.03%) Mesos
2 20 (0.89%) Hadoop YARN
3 14 (0.62%) Ambari
4 11 (0.49%) Oozie
4 11 (0.49%) Opscode Chef
5 10 (0.45%) Puppet
6 8 (0.36%) Automic
6 8 (0.36%) Perfmon
6 8 (0.36%) Single Sign-On
7 7 (0.31%) Dollar Universe
8 6 (0.27%) Ansible
8 6 (0.27%) Control-M
8 6 (0.27%) SCCM
8 6 (0.27%) Terraform
9 5 (0.22%) Kubernetes
10 3 (0.13%) Oracle Enterprise Manager
11 2 (0.089%) Failover Clustering
11 2 (0.089%) Kibana
11 2 (0.089%) logstash
11 2 (0.089%) Rundeck
Vendors
1 791 (35.27%) Microsoft
2 422 (18.81%) Oracle
3 293 (13.06%) Tableau
4 151 (6.73%) Informatica
5 114 (5.08%) SAP
6 95 (4.24%) Talend
7 93 (4.15%) Cognos
8 71 (3.17%) Google
9 62 (2.76%) MicroStrategy
10 53 (2.36%) IBM
11 46 (2.05%) Cloudera
12 44 (1.96%) Salesforce.com
13 42 (1.87%) Teradata
14 38 (1.69%) Alteryx
15 27 (1.20%) Vermilion
16 26 (1.16%) Netezza
17 23 (1.03%) RedGate
17 23 (1.03%) TIBCO
18 22 (0.98%) Cisco
19 20 (0.89%) Cognizant