Period
to 16 February 2019

The following table provides summary statistics for permanent job vacancies advertised in Central 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 February 2019 with a comparison to the same period in the previous 2 years.

Data Warehousing
London > Central London
6 months to
16 Feb 2019
Same period 2018 Same period 2017
Rank 105 88 67
Rank change year-on-year -17 -21 +7
Permanent jobs citing Data Warehouse 401 502 528
As % of all permanent IT jobs advertised in Central London 3.08% 3.35% 4.14%
As % of the Database & Business Intelligence category 10.42% 10.82% 13.31%
Number of salaries quoted 382 419 491
Central London median annual salary £60,000 £60,000 £60,000
10th Percentile £41,250 £42,500 £32,500
90th Percentile £86,250 £81,450 £82,500
London median annual salary £60,000 £60,000 £60,000

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 Central London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Central London
Permanent vacancies with a requirement for database or business intelligence skills 3,847 4,638 3,966
As % of all permanent IT jobs advertised in Central London 29.58% 30.98% 31.12%
Number of salaries quoted 3,488 4,124 3,688
Central London median annual salary £65,000 £60,000 £57,500
Median salary % change year-on-year +8.33% +4.35% -
10th Percentile £41,250 £38,750 £36,250
90th Percentile £95,000 £86,250 £86,250
London median annual salary £62,500 £60,000 £57,500
% change year-on-year +4.17% +4.35% +4.55%

Data Warehouse
Job Vacancy Trend in Central London

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in Central London.

Job vacancy trend for Data Warehouse in Central London

Data Warehouse
Salary Trend in Central London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Warehouse in Central London.

Salary trend for Data Warehouse in Central London

Data Warehouse
Salary Histogram in Central London

The salary distribution of IT jobs citing Data Warehouse in Central London over the 6 months to 16 February 2019.

Salary histogram for Data Warehouse in Central London

Data Warehouse
Job Locations in Central 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 Central London region over the 6 months to 16 February 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
City of London +2 343 £60,000 - 68
City of Westminster +2 9 £52,500 +1.43%
West End of London -17 7 £85,000 +17.24%
Kensington and Chelsea +1 3 - -
Camden +10 2 £57,500 +15.00%
Southwark +48 1 £70,000 +33.33%
Data Warehouse
London

For the 6 months to 16 February 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 Central London region with a requirement for Data Warehouse.

1 303 (75.56%) SQL
2 283 (70.57%) Business Intelligence
3 181 (45.14%) ETL
4 176 (43.89%) SQL Server Integration Services
5 174 (43.39%) SQL Server
6 162 (40.40%) Microsoft
7 141 (35.16%) Analytics
8 137 (34.16%) SQL Server Reporting Services
9 132 (32.92%) Power BI
10 124 (30.92%) Agile Software Development
11 119 (29.68%) Microsoft Azure
12 115 (28.68%) SQL Server Analysis Services
12 115 (28.68%) Finance
13 101 (25.19%) Tableau
14 96 (23.94%) T-SQL
15 88 (21.95%) Data Modelling
16 78 (19.45%) Analytical Skills
17 71 (17.71%) Visualisation
18 69 (17.21%) .NET
18 69 (17.21%) C#
19 64 (15.96%) Python
20 62 (15.46%) Scrum
21 60 (14.96%) Data Quality
22 54 (13.47%) Machine Learning
22 54 (13.47%) Kimball Methodology
23 52 (12.97%) XML
24 49 (12.22%) SDLC
25 48 (11.97%) Amazon AWS
26 47 (11.72%) Data Management
27 45 (11.22%) Microsoft Excel

Data Warehouse
Co-occurring IT Skills in Central 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 21 (5.24%) Apache Spark
2 10 (2.49%) SAS
2 10 (2.49%) SharePoint
3 8 (2.00%) Elasticsearch
4 4 (1.00%) Apache Airflow
4 4 (1.00%) CMS
5 2 (0.50%) Apache
5 2 (0.50%) IBM Notes
5 2 (0.50%) IIS
5 2 (0.50%) Oracle SOA Suite
6 1 (0.25%) Apache Pig
6 1 (0.25%) JBoss
6 1 (0.25%) Luigi
6 1 (0.25%) OpenStack
6 1 (0.25%) WebLogic
6 1 (0.25%) WebSphere
6 1 (0.25%) WildFly
Applications
1 45 (11.22%) Microsoft Excel
2 14 (3.49%) Microsoft Office
3 8 (2.00%) MS Visio
4 3 (0.75%) Microsoft PowerPoint
4 3 (0.75%) Microsoft Project
5 1 (0.25%) GNU Octave
Business Applications
1 9 (2.24%) FastStats
2 1 (0.25%) Cognos TM1
2 1 (0.25%) Dynamics AX
2 1 (0.25%) Dynamics CRM
2 1 (0.25%) Dynamics NAV
2 1 (0.25%) Markit EDM
Cloud Services
1 119 (29.68%) Microsoft Azure
2 48 (11.97%) Amazon AWS
3 37 (9.23%) Azure Data Factory
4 18 (4.49%) Serverless
5 13 (3.24%) Azure Functions
6 11 (2.74%) Data Lake Analytics
7 9 (2.24%) Azure Machine Learning
8 7 (1.75%) Google Cloud Platform
9 5 (1.25%) Amazon S3
10 4 (1.00%) AWS Lambda
11 3 (0.75%) SaaS
12 2 (0.50%) Amazon EC2
12 2 (0.50%) Amazon Kinesis
12 2 (0.50%) Boomi
12 2 (0.50%) Dynamics 365
13 1 (0.25%) Amazon CloudWatch
13 1 (0.25%) Cortana Intelligence Suite
13 1 (0.25%) npm
13 1 (0.25%) Salesforce Service Cloud
13 1 (0.25%) Yarn
Communications & Networking
1 2 (0.50%) Extranet
1 2 (0.50%) Internet
1 2 (0.50%) SSH
2 1 (0.25%) Kerberos
Database & Business Intelligence
1 176 (43.89%) SQL Server Integration Services
2 174 (43.39%) SQL Server
3 137 (34.16%) SQL Server Reporting Services
4 132 (32.92%) Power BI
5 115 (28.68%) SQL Server Analysis Services
6 42 (10.47%) Big Data
6 42 (10.47%) SQL Server 2016
7 39 (9.73%) Data Lake
8 38 (9.48%) BusinessObjects
8 38 (9.48%) Relational Database
9 37 (9.23%) QlikView
10 34 (8.48%) Azure SQL Data Warehouse
11 31 (7.73%) Amazon Redshift
12 29 (7.23%) Hadoop
13 20 (4.99%) SQL Server 2012
14 18 (4.49%) RDBMS
15 17 (4.24%) SQL Server 2008
16 16 (3.99%) Microsoft Analysis Services
16 16 (3.99%) NoSQL
16 16 (3.99%) PostgreSQL
Development Applications
1 19 (4.74%) Jenkins
1 19 (4.74%) Team Foundation Server
2 16 (3.99%) Git (software)
2 16 (3.99%) Subversion
3 14 (3.49%) Octopus Deploy
4 13 (3.24%) Eclipse
4 13 (3.24%) tSQLt
5 11 (2.74%) TeamCity
6 10 (2.49%) Selenium
6 10 (2.49%) Visual Studio
7 7 (1.75%) JIRA
7 7 (1.75%) SQL Server Management Studio (SSMS)
8 6 (1.50%) SpecFlow
9 5 (1.25%) Visual Studio Team System
10 4 (1.00%) Maven
10 4 (1.00%) Oracle APEX
11 3 (0.75%) Hudson
12 2 (0.50%) ERwin
12 2 (0.50%) RStudio
13 1 (0.25%) GitLab
General
1 115 (28.68%) Finance
2 39 (9.73%) Retail
3 36 (8.98%) Banking
4 14 (3.49%) Advertising
5 13 (3.24%) Back Office
6 9 (2.24%) Legal
7 8 (2.00%) Law
8 6 (1.50%) Marketing
9 4 (1.00%) General Ledger
10 3 (0.75%) Financial Institution
10 3 (0.75%) Games
10 3 (0.75%) German Language
10 3 (0.75%) International Banking
10 3 (0.75%) Spanish Language
11 2 (0.50%) Automotive
11 2 (0.50%) Pharmaceutical
11 2 (0.50%) Retail Banking
12 1 (0.25%) Front Office
12 1 (0.25%) Publishing
12 1 (0.25%) Telecoms
Job Titles
1 142 (35.41%) Developer
2 82 (20.45%) Analyst
3 64 (15.96%) Business Intelligence Developer
4 54 (13.47%) Architect
5 49 (12.22%) Data Engineer
6 45 (11.22%) SQL Developer
7 30 (7.48%) Solutions Architect
8 26 (6.48%) Data Warehouse Developer
9 24 (5.99%) SQL BI Developer
10 22 (5.49%) .NET Architect
10 22 (5.49%) .NET Solutions Architect
10 22 (5.49%) Business Intelligence Analyst
11 20 (4.99%) Data Analyst
11 20 (4.99%) ETL Developer
11 20 (4.99%) SSIS Developer
12 19 (4.74%) Senior Developer
13 18 (4.49%) Business Analyst
13 18 (4.49%) Business Intelligence Manager
14 16 (3.99%) Consultant
15 15 (3.74%) Applications Support
Libraries, Frameworks & Software Standards
1 69 (17.21%) .NET
2 52 (12.97%) XML
3 31 (7.73%) HTML
4 30 (7.48%) JSON
5 29 (7.23%) Web Services
6 25 (6.23%) REST
7 24 (5.99%) CSS
8 16 (3.99%) MDX
9 10 (2.49%) Kafka
10 9 (2.24%) XSD
11 6 (1.50%) ASP.NET
12 5 (1.25%) AngularJS
12 5 (1.25%) Apache NiFi
12 5 (1.25%) Velocity
13 4 (1.00%) Pandas
14 3 (0.75%) jQuery
14 3 (0.75%) NHibernate
14 3 (0.75%) React
14 3 (0.75%) RESTful
14 3 (0.75%) Vue.js
Miscellaneous
1 78 (19.45%) Analytical Skills
2 30 (7.48%) Data Structures
3 25 (6.23%) Reinsurance
4 15 (3.74%) Fintech
5 12 (2.99%) Management Information System
6 11 (2.74%) Mobile App
7 8 (2.00%) Algorithms
7 8 (2.00%) Self-Motivation
7 8 (2.00%) Virtual Team
8 5 (1.25%) Data Centre
9 4 (1.00%) Reference Data
10 3 (0.75%) Enterprise Software
10 3 (0.75%) Greenfield Project
10 3 (0.75%) Hedge funds
10 3 (0.75%) Market Risk
10 3 (0.75%) Robotics
10 3 (0.75%) Taxonomies
10 3 (0.75%) User Experience
11 2 (0.50%) Analytical Mindset
11 2 (0.50%) Embedded Systems
Operating Systems
1 26 (6.48%) Linux
2 23 (5.74%) Windows
3 14 (3.49%) Unix
4 13 (3.24%) Red Hat Enterprise Linux
5 6 (1.50%) Apple iOS
6 2 (0.50%) VMS
7 1 (0.25%) AIX
7 1 (0.25%) HPUX
7 1 (0.25%) Solaris
Processes & Methodologies
1 283 (70.57%) Business Intelligence
2 181 (45.14%) ETL
3 141 (35.16%) Analytics
4 124 (30.92%) Agile Software Development
5 88 (21.95%) Data Modelling
6 71 (17.71%) Visualisation
7 62 (15.46%) Scrum
8 54 (13.47%) Kimball Methodology
8 54 (13.47%) Machine Learning
9 49 (12.22%) SDLC
10 47 (11.72%) Data Management
11 44 (10.97%) E-Commerce
12 43 (10.72%) Problem-Solving
13 42 (10.47%) Migration
14 38 (9.48%) Artificial Intelligence
15 35 (8.73%) DevOps
16 32 (7.98%) Data Analytics
16 32 (7.98%) Data Science
17 30 (7.48%) Waterfall
18 28 (6.98%) Business Analytics
Programming Languages
1 303 (75.56%) SQL
2 96 (23.94%) T-SQL
3 69 (17.21%) C#
4 64 (15.96%) Python
5 40 (9.98%) Java
6 37 (9.23%) JavaScript
7 32 (7.98%) VBA
8 20 (4.99%) Data Analysis Expressions (DAX)
9 16 (3.99%) PowerShell
9 16 (3.99%) R
10 15 (3.74%) C
11 14 (3.49%) PL/SQL
12 11 (2.74%) Scala
13 8 (2.00%) Shell Script
14 6 (1.50%) C++
14 6 (1.50%) Go
15 5 (1.25%) U-SQL
16 3 (0.75%) Perl
17 2 (0.50%) PHP
17 2 (0.50%) VB
Qualifications
1 22 (5.49%) Degree
2 9 (2.24%) Computer Science Degree
3 6 (1.50%) Microsoft Certification
4 5 (1.25%) MCSA
5 2 (0.50%) ITIL Foundation Certificate
6 1 (0.25%) ISEB
6 1 (0.25%) ISTQB
6 1 (0.25%) Numerate Degree
6 1 (0.25%) PRINCE2 Certification
Quality Assurance & Compliance
1 60 (14.96%) Data Quality
2 27 (6.73%) QA
3 10 (2.49%) Solvency II
4 2 (0.50%) IFRS
5 1 (0.25%) GDPR
5 1 (0.25%) PMO
5 1 (0.25%) SLA
System Software
1 4 (1.00%) Docker
1 4 (1.00%) HDFS
2 2 (0.50%) Hyper-V
2 2 (0.50%) VMware Infrastructure
3 1 (0.25%) Apache Flume
3 1 (0.25%) Apache ZooKeeper
3 1 (0.25%) Virtual Machines
Systems Management
1 3 (0.75%) Kubernetes
1 3 (0.75%) Terraform
2 2 (0.50%) Automic
2 2 (0.50%) Control-M
3 1 (0.25%) Ansible
3 1 (0.25%) Grafana
3 1 (0.25%) HP Quality Center
3 1 (0.25%) Oracle Enterprise Manager
3 1 (0.25%) Oracle RMAN
Vendors
1 162 (40.40%) Microsoft
2 101 (25.19%) Tableau
3 41 (10.22%) Oracle
4 19 (4.74%) SAP
5 15 (3.74%) Talend
6 13 (3.24%) Red Hat
7 9 (2.24%) Informatica
8 8 (2.00%) Google
9 6 (1.50%) MicroStrategy
9 6 (1.50%) Teradata
10 5 (1.25%) SnapLogic
11 4 (1.00%) Birst
11 4 (1.00%) Cognos
11 4 (1.00%) IBM
11 4 (1.00%) Sybase
12 3 (0.75%) Hyperion
12 3 (0.75%) Perforce
12 3 (0.75%) RedGate
13 2 (0.50%) Sun
13 2 (0.50%) VMware