Period
to 23 September 2018

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

Data Warehousing
London > Central London
6 months to
23 Sep 2018
Same period 2017 Same period 2016
Rank 80 81 91
Rank change year-on-year +1 +10 -14
Permanent jobs citing Data Warehouse 542 468 557
As % of all permanent IT jobs advertised in Central London 3.88% 3.78% 3.58%
As % of the Database & Business Intelligence category 12.81% 12.24% 12.09%
Number of salaries quoted 485 444 521
Central London median annual salary £65,000 £60,000 £62,500
Median salary % change year-on-year +8.33% -4.00% +4.17%
10th Percentile £42,000 £41,325 £37,500
90th Percentile £87,500 £80,000 £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 4,231 3,822 4,608
As % of all permanent IT jobs advertised in Central London 30.30% 30.88% 29.65%
Number of salaries quoted 3,862 3,480 4,198
Central London median annual salary £65,000 £60,000 £55,000
Median salary % change year-on-year +8.33% +9.09% -
10th Percentile £39,000 £38,750 £36,250
90th Percentile £93,750 £87,500 £85,000
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 23 September 2018.

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 23 September 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
City of London +5 478 £65,000 +8.33% 85
Southwark +3 16 £45,000 -25.00%
West End of London -22 6 £48,750 -7.14% 12
Camden +5 4 £52,500 +7.69%
City of Westminster - 3 £46,000 -
Data Warehouse
London

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

1 409 (75.46%) SQL
2 348 (64.21%) Business Intelligence
3 305 (56.27%) SQL Server Integration Services
4 299 (55.17%) SQL Server
5 258 (47.60%) ETL
6 246 (45.39%) SQL Server Reporting Services
7 241 (44.46%) Finance
8 228 (42.07%) Microsoft
9 184 (33.95%) T-SQL
10 177 (32.66%) Power BI
11 173 (31.92%) Agile Software Development
12 167 (30.81%) SQL Server Analysis Services
13 126 (23.25%) Analytics
14 114 (21.03%) Big Data
14 114 (21.03%) Tableau
15 93 (17.16%) .NET
16 89 (16.42%) C#
16 89 (16.42%) Data Modelling
17 78 (14.39%) Microsoft Azure
17 78 (14.39%) SDLC
18 76 (14.02%) Data Management
19 75 (13.84%) Scrum
20 68 (12.55%) Analytical Skills
21 63 (11.62%) Data Lake
22 62 (11.44%) Data Integration
23 61 (11.25%) Visualisation
24 58 (10.70%) BusinessObjects
25 57 (10.52%) Microsoft Excel
26 56 (10.33%) Oracle
26 56 (10.33%) Degree

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 31 (5.72%) SAS
2 19 (3.51%) SharePoint
3 18 (3.32%) Apache Spark
4 6 (1.11%) IIS
5 4 (0.74%) Oracle SOA Suite
6 3 (0.55%) Apache Pig
7 2 (0.37%) Apache
7 2 (0.37%) Elasticsearch
7 2 (0.37%) IBM Notes
8 1 (0.18%) CMS
8 1 (0.18%) Confluence
8 1 (0.18%) IBM HTTP Server
8 1 (0.18%) MS Exchange
8 1 (0.18%) OpenStack
Applications
1 57 (10.52%) Microsoft Excel
2 15 (2.77%) Microsoft Office
3 6 (1.11%) Microsoft PowerPoint
4 5 (0.92%) MS Visio
5 2 (0.37%) Spreadsheet
6 1 (0.18%) EViews
6 1 (0.18%) SPSS
Business Applications
1 6 (1.11%) FastStats
2 4 (0.74%) Dynamics CRM
3 3 (0.55%) Dynamics AX
3 3 (0.55%) Dynamics NAV
3 3 (0.55%) NetSuite
4 2 (0.37%) MetaTrader
4 2 (0.37%) Salesforce.com CRM
5 1 (0.18%) Cognos Business Intelligence
5 1 (0.18%) Cognos TM1
5 1 (0.18%) Magento
5 1 (0.18%) Markit EDM
5 1 (0.18%) thinkFolio
Cloud Services
1 78 (14.39%) Microsoft Azure
2 44 (8.12%) Amazon AWS
3 19 (3.51%) Azure Data Factory
4 11 (2.03%) Data Lake Analytics
5 7 (1.29%) PaaS
6 6 (1.11%) Amazon EC2
6 6 (1.11%) Amazon S3
6 6 (1.11%) AWS Lambda
6 6 (1.11%) Serverless
7 5 (0.92%) Cloud Computing
7 5 (0.92%) Cortana Intelligence Suite
8 4 (0.74%) GitHub
8 4 (0.74%) SaaS
9 3 (0.55%) Amazon SQS
9 3 (0.55%) Azure Machine Learning
10 2 (0.37%) Azure Functions
10 2 (0.37%) Boomi
10 2 (0.37%) IaaS
10 2 (0.37%) Office 365
10 2 (0.37%) Virtual Private Cloud
Communications & Networking
1 3 (0.55%) SSH
2 2 (0.37%) LAN
2 2 (0.37%) VoIP
2 2 (0.37%) WAN
3 1 (0.18%) Firewall
3 1 (0.18%) Internet
3 1 (0.18%) Intranet
3 1 (0.18%) NAS
3 1 (0.18%) PABX
3 1 (0.18%) SAN
3 1 (0.18%) VPN
Database & Business Intelligence
1 305 (56.27%) SQL Server Integration Services
2 299 (55.17%) SQL Server
3 246 (45.39%) SQL Server Reporting Services
4 177 (32.66%) Power BI
5 167 (30.81%) SQL Server Analysis Services
6 114 (21.03%) Big Data
7 63 (11.62%) Data Lake
8 58 (10.70%) BusinessObjects
9 53 (9.78%) SQL Server 2016
10 45 (8.30%) SQL Server 2012
11 43 (7.93%) Relational Database
12 42 (7.75%) SQL Server 2008
13 41 (7.56%) Hadoop
14 39 (7.20%) NoSQL
15 35 (6.46%) QlikView
15 35 (6.46%) SQL Server 2014
16 27 (4.98%) Microsoft Analysis Services
16 27 (4.98%) OLAP
17 24 (4.43%) Amazon Redshift
17 24 (4.43%) Apache Hive
Development Applications
1 43 (7.93%) Team Foundation Server
2 25 (4.61%) Visual Studio
3 13 (2.40%) SQL Server Management Studio (SSMS)
4 12 (2.21%) Jenkins
5 10 (1.85%) Eclipse
5 10 (1.85%) Git (software)
6 9 (1.66%) JIRA
6 9 (1.66%) Subversion
7 8 (1.48%) TeamCity
8 7 (1.29%) Selenium
9 6 (1.11%) Visual Studio Team System
10 5 (0.92%) ERwin
10 5 (0.92%) tSQLt
11 4 (0.74%) ER Studio
11 4 (0.74%) Maven
12 3 (0.55%) Atlassian Bamboo
12 3 (0.55%) SpecFlow
13 2 (0.37%) CA Release Automation
13 2 (0.37%) Octopus Deploy
13 2 (0.37%) RStudio
General
1 241 (44.46%) Finance
2 40 (7.38%) Banking
3 31 (5.72%) Retail
4 30 (5.54%) Marketing
5 24 (4.43%) Advertising
5 24 (4.43%) Back Office
6 9 (1.66%) Games
7 7 (1.29%) General Ledger
8 6 (1.11%) Law
9 3 (0.55%) International Banking
9 3 (0.55%) Legal
10 2 (0.37%) Financial Institution
10 2 (0.37%) French Language
10 2 (0.37%) Investment Banking
10 2 (0.37%) Pharmaceutical
10 2 (0.37%) Spanish Language
11 1 (0.18%) Billing
11 1 (0.18%) Dutch Language
11 1 (0.18%) Front Office
11 1 (0.18%) Retail Banking
Job Titles
1 259 (47.79%) Developer
2 134 (24.72%) Business Intelligence Developer
3 113 (20.85%) SQL Developer
4 98 (18.08%) Analyst
5 62 (11.44%) Architect
6 56 (10.33%) SSIS Developer
7 50 (9.23%) SQL BI Developer
8 48 (8.86%) Data Warehouse Developer
9 47 (8.67%) Data Engineer
9 47 (8.67%) SSRS Developer
10 36 (6.64%) Business Intelligence Analyst
10 36 (6.64%) SQL Server Developer
11 33 (6.09%) Data Analyst
12 31 (5.72%) T-SQL Developer
13 30 (5.54%) Business Developer
13 30 (5.54%) ETL Developer
14 29 (5.35%) SSAS Developer
15 27 (4.98%) Microsoft Developer
16 25 (4.61%) Power BI Developer
17 24 (4.43%) Consultant
Libraries, Frameworks & Software Standards
1 93 (17.16%) .NET
2 45 (8.30%) XML
3 33 (6.09%) Web Services
4 25 (4.61%) .NET Framework
5 24 (4.43%) HTML
6 21 (3.87%) MDX
7 19 (3.51%) Entity Framework
8 18 (3.32%) CSS
8 18 (3.32%) JSON
9 16 (2.95%) REST
10 13 (2.40%) ASP.NET
11 9 (1.66%) XSD
12 6 (1.11%) Kafka
12 6 (1.11%) NHibernate
13 5 (0.92%) jQuery
13 5 (0.92%) RESTful
13 5 (0.92%) WPF
14 4 (0.74%) ASP.NET Web Forms
14 4 (0.74%) Middleware
14 4 (0.74%) Razor View Engine
Miscellaneous
1 68 (12.55%) Analytical Skills
2 35 (6.46%) Data Structures
2 35 (6.46%) Reinsurance
3 27 (4.98%) Computer Science
4 25 (4.61%) Management Information System
5 24 (4.43%) Self-Motivation
6 23 (4.24%) Greenfield Project
7 21 (3.87%) Fintech
7 21 (3.87%) User Experience
8 17 (3.14%) Replication
9 16 (2.95%) Tandem
10 12 (2.21%) Reference Data
10 12 (2.21%) Virtual Team
11 11 (2.03%) Analytical Mindset
12 7 (1.29%) Market Risk
13 6 (1.11%) Credit Risk
13 6 (1.11%) Derivative
14 4 (0.74%) NHS
15 3 (0.55%) Algorithms
15 3 (0.55%) PMI
Operating Systems
1 22 (4.06%) Windows
2 20 (3.69%) Unix
3 9 (1.66%) Linux
4 7 (1.29%) HPUX
4 7 (1.29%) Solaris
5 6 (1.11%) AIX
6 5 (0.92%) Windows Server
6 5 (0.92%) Windows Server 2012
7 4 (0.74%) Red Hat Enterprise Linux
8 1 (0.18%) CentOS
8 1 (0.18%) Windows Server 2008
8 1 (0.18%) zOS
Processes & Methodologies
1 348 (64.21%) Business Intelligence
2 258 (47.60%) ETL
3 173 (31.92%) Agile Software Development
4 126 (23.25%) Analytics
5 89 (16.42%) Data Modelling
6 78 (14.39%) SDLC
7 76 (14.02%) Data Management
8 75 (13.84%) Scrum
9 62 (11.44%) Data Integration
10 61 (11.25%) Visualisation
11 54 (9.96%) Problem-Solving
11 54 (9.96%) Waterfall
12 53 (9.78%) Kimball Methodology
13 52 (9.59%) Data Analysis
14 50 (9.23%) Mathematics
14 50 (9.23%) Migration
15 48 (8.86%) Machine Learning
16 37 (6.83%) ETL Development
17 36 (6.64%) Test Automation
18 34 (6.27%) Continuous Integration
Programming Languages
1 409 (75.46%) SQL
2 184 (33.95%) T-SQL
3 89 (16.42%) C#
4 53 (9.78%) Python
5 44 (8.12%) JavaScript
6 35 (6.46%) R
7 30 (5.54%) Java
8 24 (4.43%) VBA
9 23 (4.24%) PowerShell
10 20 (3.69%) Data Analysis Expressions (DAX)
11 16 (2.95%) Shell Script
12 15 (2.77%) PL/SQL
13 10 (1.85%) C
13 10 (1.85%) Scala
14 8 (1.48%) VB
15 7 (1.29%) Perl
16 6 (1.11%) PHP
17 4 (0.74%) Ruby
17 4 (0.74%) U-SQL
18 3 (0.55%) VBScript
Qualifications
1 56 (10.33%) Degree
2 18 (3.32%) Microsoft Certification
3 9 (1.66%) MCITP
3 9 (1.66%) Microsoft Certified Architect
4 7 (1.29%) Numerate Degree
4 7 (1.29%) PRINCE2 Certification
5 5 (0.92%) Master's Degree
5 5 (0.92%) PhD
6 4 (0.74%) ACCA
6 4 (0.74%) Computer Science Degree
7 3 (0.55%) ITIL Foundation Certificate
7 3 (0.55%) PMI Certification
7 3 (0.55%) Security Cleared
8 2 (0.37%) ISTQB
8 2 (0.37%) PMP
9 1 (0.18%) CBAP
9 1 (0.18%) CIMA
9 1 (0.18%) IIBA
9 1 (0.18%) ISEB
Quality Assurance & Compliance
1 55 (10.15%) Data Quality
2 17 (3.14%) QA
3 6 (1.11%) GDPR
4 2 (0.37%) ISO/IEC 27001
4 2 (0.37%) MiFID
5 1 (0.18%) GAAP
5 1 (0.18%) IFRS
5 1 (0.18%) PCI DSS
5 1 (0.18%) PMO
5 1 (0.18%) SLA
5 1 (0.18%) Solvency II
System Software
1 7 (1.29%) Docker
2 5 (0.92%) HDFS
3 3 (0.55%) Apache Flume
4 1 (0.18%) Active Directory
Systems Management
1 6 (1.11%) Oozie
2 4 (0.74%) Mesos
3 3 (0.55%) Ansible
3 3 (0.55%) Docker Swarm
3 3 (0.55%) Opscode Chef
3 3 (0.55%) Puppet
4 2 (0.37%) Rundeck
5 1 (0.18%) Hadoop YARN
5 1 (0.18%) Kubernetes
5 1 (0.18%) Oracle Enterprise Manager
5 1 (0.18%) Oracle RMAN
Vendors
1 228 (42.07%) Microsoft
2 114 (21.03%) Tableau
3 56 (10.33%) Oracle
4 33 (6.09%) Cognos
5 29 (5.35%) Informatica
6 20 (3.69%) SAP
7 19 (3.51%) MicroStrategy
8 16 (2.95%) Talend
9 12 (2.21%) Salesforce.com
10 10 (1.85%) IBM
11 6 (1.11%) Birst
11 6 (1.11%) Sybase
12 5 (0.92%) Sun
13 4 (0.74%) Red Hat
13 4 (0.74%) Teradata
14 3 (0.55%) Alteryx
14 3 (0.55%) Bloomberg
14 3 (0.55%) JD Edwards
15 2 (0.37%) MuleSoft
15 2 (0.37%) SnapLogic