Period
to 27 May 2018

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

Data Warehousing
6 months to
27 May 2018
Same period 2017 Same period 2016
Rank 82 59 49
Rank change year-on-year -23 -10 +43
Permanent jobs citing Data Warehouse 155 239 330
As % of all permanent IT jobs advertised in Leeds 3.27% 4.70% 5.20%
As % of the Database & Business Intelligence category 12.22% 15.06% 14.67%
Number of salaries quoted 110 219 241
Leeds median annual salary £45,000 £42,500 £45,000
Median salary % change year-on-year +5.88% -5.56% +12.50%
10th Percentile £31,250 £32,500 £31,250
90th Percentile £63,000 £62,500 £77,500
West Yorkshire median annual salary £45,000 £45,000 £45,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 Leeds with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Leeds
Permanent vacancies with a requirement for database or business intelligence skills 1,268 1,587 2,249
As % of all permanent IT jobs advertised in Leeds 26.76% 31.22% 35.43%
Number of salaries quoted 1,088 1,411 1,788
Leeds median annual salary £45,000 £42,500 £40,000
Median salary % change year-on-year +5.88% +6.25% -
10th Percentile £31,250 £28,000 £27,500
90th Percentile £62,500 £60,000 £62,000
West Yorkshire median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% -

Data Warehouse
Job Vacancy Trend in Leeds

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

Job vacancy trend for Data Warehouse in Leeds

Data Warehouse
Salary Trend in Leeds

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

Salary trend for Data Warehouse in Leeds

Data Warehouse
Salary Histogram in Leeds

The salary distribution of IT jobs citing Data Warehouse in Leeds over the 6 months to 27 May 2018.

Salary histogram for Data Warehouse in Leeds

For the 6 months to 27 May 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 Leeds region with a requirement for Data Warehouse.

1 117 (75.48%) Business Intelligence
2 99 (63.87%) SQL
3 89 (57.42%) SQL Server Reporting Services
4 88 (56.77%) SQL Server
5 86 (55.48%) SQL Server Integration Services
6 76 (49.03%) SQL Server Analysis Services
7 55 (35.48%) Microsoft
7 55 (35.48%) ETL
8 50 (32.26%) T-SQL
9 45 (29.03%) Finance
10 41 (26.45%) Data Modelling
11 40 (25.81%) Tableau
12 36 (23.23%) Agile Software Development
13 32 (20.65%) Analytics
14 27 (17.42%) SQL Server Management Studio (SSMS)
15 23 (14.84%) Oracle
16 19 (12.26%) Microsoft Excel
17 18 (11.61%) SQL Server 2012
17 18 (11.61%) Analytical Skills
18 17 (10.97%) E-Commerce
18 17 (10.97%) Microsoft Office
19 14 (9.03%) Retail
19 14 (9.03%) Power BI
20 13 (8.39%) Big Data
20 13 (8.39%) Oracle Database
20 13 (8.39%) Linux
21 12 (7.74%) Windows
21 12 (7.74%) Software Testing
21 12 (7.74%) TOGAF
21 12 (7.74%) Data Integration

Data Warehouse
Co-occurring IT Skills in Leeds 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 11 (7.10%) SAS
Applications
1 19 (12.26%) Microsoft Excel
2 17 (10.97%) Microsoft Office
3 1 (0.65%) Microsoft PowerPoint
3 1 (0.65%) MS Visio
Cloud Services
1 12 (7.74%) Microsoft Azure
2 1 (0.65%) Amazon AWS
2 1 (0.65%) Azure Data Factory
Database & Business Intelligence
1 89 (57.42%) SQL Server Reporting Services
2 88 (56.77%) SQL Server
3 86 (55.48%) SQL Server Integration Services
4 76 (49.03%) SQL Server Analysis Services
5 18 (11.61%) SQL Server 2012
6 14 (9.03%) Power BI
7 13 (8.39%) Big Data
7 13 (8.39%) Oracle Database
8 10 (6.45%) BusinessObjects
9 7 (4.52%) Hadoop
9 7 (4.52%) Relational Database
10 6 (3.87%) Apache Hive
10 6 (3.87%) Data Lake
10 6 (3.87%) HBase
10 6 (3.87%) Impala
10 6 (3.87%) MOLAP
10 6 (3.87%) OLAP
10 6 (3.87%) ROLAP
10 6 (3.87%) SQL Server 2016
10 6 (3.87%) Sqoop
Development Applications
1 27 (17.42%) SQL Server Management Studio (SSMS)
2 10 (6.45%) Visual Studio
3 4 (2.58%) Team Foundation Server
General
1 45 (29.03%) Finance
2 14 (9.03%) Retail
3 11 (7.10%) Marketing
4 9 (5.81%) Advertising
5 2 (1.29%) Legal
6 1 (0.65%) Banking
6 1 (0.65%) Games
6 1 (0.65%) Law
6 1 (0.65%) Pharmaceutical
Job Titles
1 56 (36.13%) Developer
2 51 (32.90%) Business Intelligence Developer
3 31 (20.00%) Business Developer
4 23 (14.84%) DBA
5 21 (13.55%) SQL DBA
6 19 (12.26%) ETL Developer
7 18 (11.61%) Analyst
7 18 (11.61%) Architect
7 18 (11.61%) SSIS Developer
8 13 (8.39%) SSRS Developer
9 12 (7.74%) Data Architect
9 12 (7.74%) Software Tester
9 12 (7.74%) Tester
10 11 (7.10%) Data Warehouse Developer
10 11 (7.10%) Microsoft BI Developer
10 11 (7.10%) Microsoft Developer
10 11 (7.10%) SSAS Developer
11 10 (6.45%) Data Manager
11 10 (6.45%) Senior Business Intelligence Developer
11 10 (6.45%) Senior Developer
Libraries, Frameworks & Software Standards
1 6 (3.87%) JSON
1 6 (3.87%) Kafka
1 6 (3.87%) REST
1 6 (3.87%) SOAP
1 6 (3.87%) XML
1 6 (3.87%) XSD
2 1 (0.65%) .NET
Miscellaneous
1 18 (11.61%) Analytical Skills
2 7 (4.52%) Replication
3 6 (3.87%) Management Information System
3 6 (3.87%) Taxonomies
4 5 (3.23%) NHS
4 5 (3.23%) Self-Motivation
5 4 (2.58%) Greenfield Project
6 1 (0.65%) Algorithms
Operating Systems
1 13 (8.39%) Linux
2 12 (7.74%) Windows
3 2 (1.29%) Unix
Processes & Methodologies
1 117 (75.48%) Business Intelligence
2 55 (35.48%) ETL
3 41 (26.45%) Data Modelling
4 36 (23.23%) Agile Software Development
5 32 (20.65%) Analytics
6 17 (10.97%) E-Commerce
7 12 (7.74%) Data Analytics
7 12 (7.74%) Data Integration
7 12 (7.74%) Software Testing
7 12 (7.74%) Test Scripting
7 12 (7.74%) TOGAF
8 11 (7.10%) Business Analysis
8 11 (7.10%) CRM
8 11 (7.10%) Data Architecture
8 11 (7.10%) Digital Marketing
8 11 (7.10%) Enterprise Architecture
8 11 (7.10%) Performance Tuning
8 11 (7.10%) Visualisation
9 10 (6.45%) Change Management
9 10 (6.45%) High Availability
Programming Languages
1 99 (63.87%) SQL
2 50 (32.26%) T-SQL
3 9 (5.81%) C#
4 8 (5.16%) PowerShell
5 7 (4.52%) R
6 6 (3.87%) Scala
7 5 (3.23%) ABAP
8 2 (1.29%) VB
8 2 (1.29%) VBA
9 1 (0.65%) C
9 1 (0.65%) FoxPro (VFP)
9 1 (0.65%) Java
9 1 (0.65%) PL/SQL
9 1 (0.65%) VB6
Qualifications
1 8 (5.16%) MCSA
1 8 (5.16%) MCSE
1 8 (5.16%) Microsoft Certification
Quality Assurance & Compliance
1 10 (6.45%) Data Quality
1 10 (6.45%) GDPR
2 2 (1.29%) QA
System Software
1 6 (3.87%) Apache Flume
1 6 (3.87%) HDFS
Systems Management
1 9 (5.81%) Failover Clustering
2 6 (3.87%) Oozie
3 1 (0.65%) Data Guard
3 1 (0.65%) Enterprise Manager Cloud Control
3 1 (0.65%) Oracle RMAN
Vendors
1 55 (35.48%) Microsoft
2 40 (25.81%) Tableau
3 23 (14.84%) Oracle
4 10 (6.45%) Cognos
5 9 (5.81%) Alteryx
6 5 (3.23%) SAP
7 4 (2.58%) Capita
7 4 (2.58%) Talend
8 1 (0.65%) Automation Anywhere
8 1 (0.65%) Blue Prism
8 1 (0.65%) IBM
8 1 (0.65%) Sage