Period
to 18 November 2017

The following table provides summary statistics for contract job vacancies advertised in London with a requirement for Data Warehouse skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Warehouse over the 6 months to 18 November 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Data Warehousing
England > London
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 114 92 61
Rank change year-on-year -22 -31 +5
Contract jobs citing Data Warehouse 1071 1287 1631
As % of all contract IT jobs advertised in London 2.30% 2.85% 3.46%
As % of the Database & Business Intelligence category 9.69% 12.23% 14.35%
Number of daily rates quoted 788 924 1221
London median daily rate £475 £475 £450
Median daily rate % change year-on-year - +5.56% -
10th Percentile £355 £350 £320
90th Percentile £638 £638 £623
England median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% -
Number of hourly rates quoted 5 5 5
London median hourly rate £22.50 £42.00 £23.00
Median hourly rate % change year-on-year -46.43% +82.61% -84.41%
10th Percentile £17.95 £21.69 £18.27
90th Percentile £27.50 £44.20 £33.21
England median hourly rate £27.50 £42.00 £26.47
% change year-on-year -34.52% +58.67% -53.36%

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 contract job vacancies advertised in London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Contract vacancies with a requirement for database or business intelligence skills 11052 10525 11362
As % of all contract IT jobs advertised in London 23.75% 23.27% 24.09%
Number of daily rates quoted 8198 7480 8089
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% +5.88%
10th Percentile £353 £320 £300
90th Percentile £660 £638 £625
England median daily rate £455 £425 £413
% change year-on-year +7.06% +3.03% +3.13%
Number of hourly rates quoted 59 38 77
London median hourly rate £26.61 £30.94 £22.50
Median hourly rate % change year-on-year -14.01% +37.51% -14.29%
10th Percentile £18.20 £15.25 £14.90
90th Percentile £58.75 £86.23 £88.00
England median hourly rate £31.50 £28.00 £28.00
% change year-on-year +12.50% - +16.67%

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
Contractor Daily Rate Trend in London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Data Warehouse in London.

Contractor daily rate trend for Data Warehouse in London

Data Warehouse
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing Data Warehouse in London over the 6 months to 18 November 2017.

Contractor daily rate histogram for Data Warehouse in London

Data Warehouse
Contractor Hourly Rate Trend in London

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Data Warehouse in London.

Contractor hourly rate trend for Data Warehouse in London

Data Warehouse
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Data Warehouse within the London region over the 6 months to 18 November 2017. 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London -26 239 £475 +5.56% 22
West London -9 28 £388 -7.19% 5
South London -22 25 £480 +18.52% 1
East London -12 16 £520 +12.43% 2
North London -14 2 £338 -21.51% 3
Data Warehouse
England

For the 6 months to 18 November 2017, IT contractor jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the London region with a requirement for Data Warehouse.

1 669 (62.46%) SQL
2 612 (57.14%) Business Intelligence
3 500 (46.69%) ETL
4 374 (34.92%) SQL Server
5 319 (29.79%) SQL Server Integration Services
6 313 (29.23%) Finance
7 309 (28.85%) Agile Software Development
8 285 (26.61%) Data Modelling
9 243 (22.69%) SQL Server Reporting Services
10 226 (21.10%) Microsoft
11 199 (18.58%) SQL Server Analysis Services
12 194 (18.11%) Analytics
13 170 (15.87%) Oracle
14 163 (15.22%) T-SQL
15 158 (14.75%) Big Data
16 148 (13.82%) Power BI
17 145 (13.54%) Banking
18 138 (12.89%) Analytical Skills
19 129 (12.04%) Python
20 126 (11.76%) Hadoop
21 123 (11.48%) Kimball Methodology
22 122 (11.39%) Data Analysis
23 121 (11.30%) Scrum
23 121 (11.30%) Microsoft Azure
24 120 (11.20%) Tableau
25 118 (11.02%) Java
26 116 (10.83%) Visualisation
27 105 (9.80%) Relational Database
27 105 (9.80%) Migration
28 96 (8.96%) Data Quality

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 92 (8.59%) Apache Spark
2 39 (3.64%) SAS
3 18 (1.68%) Apache
3 18 (1.68%) SharePoint
4 15 (1.40%) Apache Airflow
4 15 (1.40%) Apache Pig
5 10 (0.93%) Apache Solr
6 9 (0.84%) Confluence
7 8 (0.75%) Oracle SOA Suite
8 5 (0.47%) Oracle Workflow
9 4 (0.37%) Elasticsearch
9 4 (0.37%) IIS
9 4 (0.37%) JBoss
9 4 (0.37%) Luigi
9 4 (0.37%) WildFly
10 3 (0.28%) GemFire
10 3 (0.28%) Oracle Coherence
10 3 (0.28%) WebLogic
11 2 (0.19%) CMS
11 2 (0.19%) Tomcat
Applications
1 74 (6.91%) Microsoft Excel
2 20 (1.87%) MS Visio
3 17 (1.59%) Microsoft Office
4 8 (0.75%) Microsoft PowerPoint
5 4 (0.37%) Microsoft Project
5 4 (0.37%) Spreadsheet
6 2 (0.19%) SPSS
7 1 (0.093%) Stata
Business Applications
1 18 (1.68%) Markit EDM
2 12 (1.12%) Dynamics CRM
3 6 (0.56%) Cognos TM1
4 5 (0.47%) Dynamics AX
5 4 (0.37%) Cognos Business Intelligence
6 3 (0.28%) Dynamics NAV
6 3 (0.28%) Endur
6 3 (0.28%) Siebel CRM
6 3 (0.28%) SystmOne
7 2 (0.19%) Eagle PACE
7 2 (0.19%) Oracle Retail
7 2 (0.19%) thinkFolio
8 1 (0.093%) Hyperion Planning
8 1 (0.093%) Magento
8 1 (0.093%) MoSes
8 1 (0.093%) Oracle EBS
8 1 (0.093%) SAP CRM
8 1 (0.093%) SAP FI-GL
8 1 (0.093%) SAP IS-U
8 1 (0.093%) Unit4 Business World
Cloud Services
1 121 (11.30%) Microsoft Azure
2 95 (8.87%) Amazon AWS
3 29 (2.71%) Google Cloud Platform
4 24 (2.24%) Amazon EMR
5 22 (2.05%) Amazon S3
6 15 (1.40%) Amazon EC2
7 14 (1.31%) Amazon Kinesis
8 13 (1.21%) SaaS
9 10 (0.93%) IaaS
9 10 (0.93%) Office 365
9 10 (0.93%) PaaS
10 8 (0.75%) GitHub
11 5 (0.47%) Cloud Computing
11 5 (0.47%) Data Lake Analytics
11 5 (0.47%) Google Analytics
12 4 (0.37%) AWS CloudFormation
12 4 (0.37%) AWS Lambda
12 4 (0.37%) Azure Data Factory
12 4 (0.37%) Serverless
13 3 (0.28%) AWS Data Pipeline
Communications & Networking
1 6 (0.56%) Firewall
2 4 (0.37%) Internet
2 4 (0.37%) Intranet
2 4 (0.37%) LDAP
3 3 (0.28%) Kerberos
3 3 (0.28%) VLAN
4 2 (0.19%) TCP/IP
4 2 (0.19%) Wireshark
5 1 (0.093%) SAN
5 1 (0.093%) SMS
5 1 (0.093%) SSL
Database & Business Intelligence
1 374 (34.92%) SQL Server
2 319 (29.79%) SQL Server Integration Services
3 243 (22.69%) SQL Server Reporting Services
4 199 (18.58%) SQL Server Analysis Services
5 158 (14.75%) Big Data
6 148 (13.82%) Power BI
7 126 (11.76%) Hadoop
8 105 (9.80%) Relational Database
9 85 (7.94%) QlikView
10 63 (5.88%) BusinessObjects
11 62 (5.79%) NoSQL
11 62 (5.79%) OLAP
11 62 (5.79%) SQL Server 2012
12 56 (5.23%) SQL Server 2016
13 54 (5.04%) Apache Hive
14 51 (4.76%) RDBMS
15 49 (4.58%) Enterprise Data Warehouse
16 46 (4.30%) Oracle Database
16 46 (4.30%) SQL Server 2008
17 44 (4.11%) SQL Server 2014
Development Applications
1 42 (3.92%) Team Foundation Server
2 37 (3.45%) JIRA
3 29 (2.71%) Jenkins
4 25 (2.33%) Visual Studio
5 21 (1.96%) Git (software)
5 21 (1.96%) Talend Open Studio
6 19 (1.77%) Subversion
7 17 (1.59%) Eclipse
8 16 (1.49%) ERwin
8 16 (1.49%) Maven
9 12 (1.12%) JUnit
10 8 (0.75%) Octopus Deploy
11 7 (0.65%) Mockito
12 6 (0.56%) Cucumber
12 6 (0.56%) TeamCity
13 5 (0.47%) Ant
13 5 (0.47%) MSTest
13 5 (0.47%) NUnit
13 5 (0.47%) PowerDesigner
14 4 (0.37%) HP UFT
General
1 313 (29.23%) Finance
2 145 (13.54%) Banking
3 59 (5.51%) Marketing
4 40 (3.73%) Retail
5 30 (2.80%) Investment Banking
5 30 (2.80%) Legal
6 18 (1.68%) Retail Banking
6 18 (1.68%) Telecoms
7 14 (1.31%) Front Office
7 14 (1.31%) Publishing
8 13 (1.21%) Back Office
8 13 (1.21%) Financial Institution
9 12 (1.12%) Games
9 12 (1.12%) Manufacturing
10 11 (1.03%) Advertising
11 10 (0.93%) Pharmaceutical
12 8 (0.75%) Law
13 7 (0.65%) Electronics
14 5 (0.47%) Private Banking
15 3 (0.28%) Dutch Language
Job Titles
1 394 (36.79%) Developer
2 237 (22.13%) Analyst
3 165 (15.41%) Business Intelligence Developer
4 127 (11.86%) Architect
5 121 (11.30%) SQL Developer
6 95 (8.87%) Business Analyst
7 94 (8.78%) Data Architect
8 90 (8.40%) Data Analyst
9 78 (7.28%) Business Intelligence Analyst
10 70 (6.54%) Data Engineer
11 69 (6.44%) SSIS Developer
12 59 (5.51%) Project Manager
13 58 (5.42%) Data Warehouse Developer
14 53 (4.95%) Business Developer
15 51 (4.76%) Consultant
16 50 (4.67%) ETL Developer
17 47 (4.39%) SQL BI Developer
18 45 (4.20%) SSAS Developer
19 43 (4.01%) SQL Analyst
20 42 (3.92%) SSRS Developer
Libraries, Frameworks & Software Standards
1 83 (7.75%) MDX
2 66 (6.16%) .NET
3 53 (4.95%) XML
4 51 (4.76%) Kafka
5 46 (4.30%) Web Services
6 28 (2.61%) Spring
7 22 (2.05%) JMS
7 22 (2.05%) PySpark
8 21 (1.96%) HTML
9 20 (1.87%) AngularJS
9 20 (1.87%) REST
10 19 (1.77%) JSON
11 18 (1.68%) .NET Framework
11 18 (1.68%) Hibernate
12 15 (1.40%) ASP.NET
12 15 (1.40%) CSS
13 14 (1.31%) COM
14 12 (1.12%) J2EE
14 12 (1.12%) jQuery
15 11 (1.03%) Entity Framework
Miscellaneous
1 138 (12.89%) Analytical Skills
2 42 (3.92%) Greenfield Project
3 40 (3.73%) Computer Science
4 30 (2.80%) Fixed Income
5 29 (2.71%) Equities
6 25 (2.33%) Algorithms
6 25 (2.33%) Management Information System
7 24 (2.24%) Data Structures
8 21 (1.96%) Credit Risk
9 20 (1.87%) Derivative
10 17 (1.59%) Data Centre
11 16 (1.49%) Reinsurance
12 15 (1.40%) Replication
13 14 (1.31%) User Experience
14 13 (1.21%) NHS
15 11 (1.03%) Fintech
16 9 (0.84%) Market Risk
17 6 (0.56%) Foreign Exchange (FX)
17 6 (0.56%) Private Cloud
17 6 (0.56%) Social Media
Operating Systems
1 65 (6.07%) Linux
2 42 (3.92%) Unix
2 42 (3.92%) Windows
3 10 (0.93%) Red Hat Enterprise Linux
4 9 (0.84%) CentOS
5 8 (0.75%) Windows Server
6 2 (0.19%) Oracle Linux
7 1 (0.093%) VMS
7 1 (0.093%) Windows Server 2008
7 1 (0.093%) Windows Server 2012
Processes & Methodologies
1 612 (57.14%) Business Intelligence
2 500 (46.69%) ETL
3 309 (28.85%) Agile Software Development
4 285 (26.61%) Data Modelling
5 194 (18.11%) Analytics
6 123 (11.48%) Kimball Methodology
7 122 (11.39%) Data Analysis
8 121 (11.30%) Scrum
9 116 (10.83%) Visualisation
10 105 (9.80%) Migration
11 82 (7.66%) Dimensional Modelling
12 81 (7.56%) Data Integration
13 72 (6.72%) Data Migration
13 72 (6.72%) Stakeholder Management
14 70 (6.54%) Data Management
15 67 (6.26%) ETL Development
16 62 (5.79%) Data Visualisation
17 60 (5.60%) Performance Tuning
18 59 (5.51%) Business Analysis
18 59 (5.51%) Data Analytics
Programming Languages
1 669 (62.46%) SQL
2 163 (15.22%) T-SQL
3 129 (12.04%) Python
4 118 (11.02%) Java
5 74 (6.91%) C#
6 62 (5.79%) PL/SQL
7 46 (4.30%) Data Analysis Expressions (DAX)
7 46 (4.30%) JavaScript
8 42 (3.92%) R
9 39 (3.64%) PowerShell
10 32 (2.99%) Scala
11 28 (2.61%) Shell Script
12 20 (1.87%) VBA
13 18 (1.68%) Bash Shell
13 18 (1.68%) VBScript
14 16 (1.49%) SAS Macro
15 14 (1.31%) AWK
15 14 (1.31%) sed
16 12 (1.12%) PHP
17 11 (1.03%) Perl
Qualifications
1 61 (5.70%) Degree
2 25 (2.33%) Security Cleared
3 24 (2.24%) ISEB
4 21 (1.96%) SC Cleared
5 13 (1.21%) ISTQB
6 12 (1.12%) Computer Science Degree
7 10 (0.93%) MCITP
7 10 (0.93%) Microsoft Certification
8 7 (0.65%) CFA
9 6 (0.56%) MCSE
9 6 (0.56%) PMI Certification
10 5 (0.47%) PMP
11 4 (0.37%) Master's Degree
11 4 (0.37%) MCTS
12 3 (0.28%) ISTQB Foundation Certification
12 3 (0.28%) ITIL Certification
12 3 (0.28%) PRINCE2 Certification
12 3 (0.28%) PRINCE2 Practitioner
13 2 (0.19%) DV Cleared
13 2 (0.19%) Numerate Degree
Quality Assurance & Compliance
1 96 (8.96%) Data Quality
2 48 (4.48%) QA
3 24 (2.24%) GDPR
4 20 (1.87%) MiFID
5 10 (0.93%) Solvency II
6 9 (0.84%) EMIR
7 8 (0.75%) Actionable Recommendations
8 5 (0.47%) GAAP
9 2 (0.19%) Dodd-Frank
9 2 (0.19%) GCP
9 2 (0.19%) IFRS
9 2 (0.19%) ISO 20022
9 2 (0.19%) SLA
9 2 (0.19%) WCAG
10 1 (0.093%) AIFMD
10 1 (0.093%) IFRS 9
10 1 (0.093%) ISO/IEC 27001
System Software
1 23 (2.15%) Apache Flume
1 23 (2.15%) HDFS
2 10 (0.93%) Docker
3 5 (0.47%) Virtual Machines
3 5 (0.47%) VMware Infrastructure
4 4 (0.37%) Active Directory
4 4 (0.37%) Oracle RAC
5 3 (0.28%) Cronacle
6 1 (0.093%) VMware Server
6 1 (0.093%) XenApp
6 1 (0.093%) XenDesktop
Systems Management
1 31 (2.89%) Oozie
2 15 (1.40%) Ambari
3 11 (1.03%) Hadoop YARN
4 10 (0.93%) Control-M
5 9 (0.84%) Ansible
6 8 (0.75%) Puppet
7 7 (0.65%) Terraform
8 5 (0.47%) Opscode Chef
8 5 (0.47%) Systems Management Server (SMS)
9 3 (0.28%) Data Guard
9 3 (0.28%) Rundeck
10 2 (0.19%) Kubernetes
10 2 (0.19%) Packer
11 1 (0.093%) Enterprise Manager Cloud Control
11 1 (0.093%) Oracle Enterprise Manager
11 1 (0.093%) vCenter Server
Vendors
1 226 (21.10%) Microsoft
2 170 (15.87%) Oracle
3 120 (11.20%) Tableau
4 70 (6.54%) Informatica
5 42 (3.92%) IBM
6 35 (3.27%) Teradata
7 34 (3.17%) SAP
8 33 (3.08%) Salesforce.com
9 24 (2.24%) Google
9 24 (2.24%) Netezza
10 23 (2.15%) Cognos
11 21 (1.96%) Talend
12 20 (1.87%) Greenplum
13 16 (1.49%) MicroStrategy
14 15 (1.40%) Sybase
15 13 (1.21%) Hortonworks
15 13 (1.21%) Vertica
16 12 (1.12%) TIBCO
17 11 (1.03%) Cloudera
17 11 (1.03%) RedGate