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

Data Warehousing
6 months to
19 Aug 2018
Same period 2017 Same period 2016
Rank 117 45 81
Rank change year-on-year -72 +36 +14
Permanent jobs citing Data Warehouse 98 281 199
As % of all permanent IT jobs advertised in Leeds 2.20% 5.66% 3.45%
As % of the Database & Business Intelligence category 8.89% 17.51% 10.89%
Number of salaries quoted 77 257 115
Leeds median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% +3.66%
10th Percentile £33,900 £32,500 £27,000
90th Percentile £72,500 £64,500 £58,250
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,102 1,605 1,827
As % of all permanent IT jobs advertised in Leeds 24.72% 32.33% 31.67%
Number of salaries quoted 914 1,413 1,497
Leeds median annual salary £45,000 £45,000 £40,000
Median salary % change year-on-year - +12.50% -
10th Percentile £31,250 £29,750 £27,500
90th Percentile £65,000 £62,500 £60,000
West Yorkshire median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -

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 19 August 2018.

Salary histogram for Data Warehouse in Leeds

For the 6 months to 19 August 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 76 (77.55%) Business Intelligence
2 71 (72.45%) SQL
3 55 (56.12%) SQL Server
4 51 (52.04%) SQL Server Integration Services
5 50 (51.02%) SQL Server Reporting Services
6 47 (47.96%) SQL Server Analysis Services
7 39 (39.80%) Microsoft
8 29 (29.59%) Finance
9 28 (28.57%) ETL
10 26 (26.53%) Tableau
11 25 (25.51%) Microsoft Excel
12 24 (24.49%) T-SQL
13 23 (23.47%) SQL Server Management Studio (SSMS)
14 20 (20.41%) Agile Software Development
15 16 (16.33%) Power BI
15 16 (16.33%) Analytics
16 15 (15.31%) Microsoft Office
17 14 (14.29%) Data Modelling
17 14 (14.29%) Software Testing
17 14 (14.29%) Test Scripting
18 12 (12.24%) Data Analytics
19 11 (11.22%) DevOps
19 11 (11.22%) Oracle
19 11 (11.22%) E-Commerce
19 11 (11.22%) Retail
20 10 (10.20%) Cognos
20 10 (10.20%) Windows
20 10 (10.20%) Linux
20 10 (10.20%) Alteryx
21 9 (9.18%) Microsoft Azure

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 7 (7.14%) SAS
2 3 (3.06%) SharePoint
2 3 (3.06%) Skype for Business
3 2 (2.04%) Oracle SOA Suite
4 1 (1.02%) Exchange Server 2007
4 1 (1.02%) IIS
4 1 (1.02%) MS Exchange
Applications
1 25 (25.51%) Microsoft Excel
2 15 (15.31%) Microsoft Office
Business Applications
1 4 (4.08%) Cognos TM1
Cloud Services
1 9 (9.18%) Microsoft Azure
2 4 (4.08%) IaaS
2 4 (4.08%) PaaS
3 2 (2.04%) Amazon AWS
Communications & Networking
1 2 (2.04%) Firewall
1 2 (2.04%) Wireshark
2 1 (1.02%) BGP
2 1 (1.02%) Cisco IOS
2 1 (1.02%) DHCP
2 1 (1.02%) DNS
2 1 (1.02%) MPLS
2 1 (1.02%) OSPF
2 1 (1.02%) Spanning Tree
2 1 (1.02%) VLAN
2 1 (1.02%) VoIP
2 1 (1.02%) WAN
Database & Business Intelligence
1 55 (56.12%) SQL Server
2 51 (52.04%) SQL Server Integration Services
3 50 (51.02%) SQL Server Reporting Services
4 47 (47.96%) SQL Server Analysis Services
5 16 (16.33%) Power BI
6 8 (8.16%) OLAP
6 8 (8.16%) Oracle Database
7 7 (7.14%) Relational Database
7 7 (7.14%) SQL Server 2012
8 6 (6.12%) Big Data
8 6 (6.12%) ROLAP
9 5 (5.10%) Hadoop
10 4 (4.08%) Apache Hive
10 4 (4.08%) Data Lake
10 4 (4.08%) HBase
10 4 (4.08%) Impala
10 4 (4.08%) MOLAP
10 4 (4.08%) Sqoop
11 3 (3.06%) BusinessObjects
11 3 (3.06%) Oracle Database 12c
Development Applications
1 23 (23.47%) SQL Server Management Studio (SSMS)
2 6 (6.12%) Visual Studio
3 4 (4.08%) Atlassian Bamboo
3 4 (4.08%) Git (software)
3 4 (4.08%) Jenkins
3 4 (4.08%) TeamCity
General
1 29 (29.59%) Finance
2 11 (11.22%) Retail
3 9 (9.18%) Marketing
4 2 (2.04%) Advertising
4 2 (2.04%) Legal
5 1 (1.02%) Banking
Job Titles
1 29 (29.59%) Developer
2 26 (26.53%) Business Intelligence Developer
3 14 (14.29%) DBA
3 14 (14.29%) Software Tester
3 14 (14.29%) Tester
4 13 (13.27%) Business Developer
4 13 (13.27%) SQL DBA
5 12 (12.24%) Senior Developer
6 11 (11.22%) Senior Business Intelligence Developer
7 8 (8.16%) Analyst
7 8 (8.16%) Architect
8 7 (7.14%) Applications Support
8 7 (7.14%) Senior Manager
9 6 (6.12%) Administrator
9 6 (6.12%) Data Manager
9 6 (6.12%) Microsoft Developer
9 6 (6.12%) Senior DBA
9 6 (6.12%) Senior SQL DBA
9 6 (6.12%) Senior SQL Server DBA
9 6 (6.12%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 4 (4.08%) JSON
1 4 (4.08%) Kafka
1 4 (4.08%) REST
1 4 (4.08%) SOAP
1 4 (4.08%) XML
1 4 (4.08%) XSD
2 1 (1.02%) .NET
Miscellaneous
1 9 (9.18%) Analytical Skills
2 6 (6.12%) Management Information System
2 6 (6.12%) NHS
3 4 (4.08%) Replication
3 4 (4.08%) Taxonomies
4 2 (2.04%) Algorithms
4 2 (2.04%) Computer Science
5 1 (1.02%) Data Centre
5 1 (1.02%) Self-Motivation
Operating Systems
1 10 (10.20%) Linux
1 10 (10.20%) Windows
2 3 (3.06%) Windows Server
3 2 (2.04%) Kali Linux
4 1 (1.02%) Unix
4 1 (1.02%) Windows Server 2012
Processes & Methodologies
1 76 (77.55%) Business Intelligence
2 28 (28.57%) ETL
3 20 (20.41%) Agile Software Development
4 16 (16.33%) Analytics
5 14 (14.29%) Data Modelling
5 14 (14.29%) Software Testing
5 14 (14.29%) Test Scripting
6 12 (12.24%) Data Analytics
7 11 (11.22%) DevOps
7 11 (11.22%) E-Commerce
8 8 (8.16%) CRM
8 8 (8.16%) Disaster Recovery
9 7 (7.14%) Digital Marketing
9 7 (7.14%) Performance Tuning
10 6 (6.12%) Data Architecture
10 6 (6.12%) Database Theory
10 6 (6.12%) Relational Database Theory
10 6 (6.12%) Statistical Analysis
10 6 (6.12%) Visualisation
10 6 (6.12%) Waterfall
Programming Languages
1 71 (72.45%) SQL
2 24 (24.49%) T-SQL
3 8 (8.16%) PowerShell
4 6 (6.12%) C#
4 6 (6.12%) R
5 4 (4.08%) Scala
5 4 (4.08%) Tcl
6 2 (2.04%) Python
6 2 (2.04%) VBA
7 1 (1.02%) PL/SQL
7 1 (1.02%) VB
Qualifications
1 6 (6.12%) MCSA
1 6 (6.12%) MCSE
1 6 (6.12%) Microsoft Certification
2 2 (2.04%) DBS Check
2 2 (2.04%) Degree
2 2 (2.04%) MBA
2 2 (2.04%) SC Cleared
2 2 (2.04%) Security Cleared
3 1 (1.02%) CCNA
3 1 (1.02%) CCNP
3 1 (1.02%) Cisco Certification
Quality Assurance & Compliance
1 8 (8.16%) Data Quality
2 3 (3.06%) PMO
3 2 (2.04%) ISO/IEC 27001
3 2 (2.04%) PCI DSS
3 2 (2.04%) QA
4 1 (1.02%) GDPR
System Software
1 4 (4.08%) Apache Flume
1 4 (4.08%) HDFS
2 3 (3.06%) Active Directory
3 1 (1.02%) Hyper-V
Systems Management
1 5 (5.10%) Failover Clustering
2 4 (4.08%) Ansible
2 4 (4.08%) Oozie
2 4 (4.08%) Opscode Chef
2 4 (4.08%) Puppet
3 2 (2.04%) Mesos
3 2 (2.04%) Nessus
4 1 (1.02%) Data Guard
4 1 (1.02%) Enterprise Manager Cloud Control
4 1 (1.02%) Oracle RMAN
Vendors
1 39 (39.80%) Microsoft
2 26 (26.53%) Tableau
3 11 (11.22%) Oracle
4 10 (10.20%) Alteryx
4 10 (10.20%) Cognos
5 4 (4.08%) IBM
5 4 (4.08%) SAP
6 3 (3.06%) Cisco
7 2 (2.04%) VMware
8 1 (1.02%) Automation Anywhere
8 1 (1.02%) Blue Prism
8 1 (1.02%) Sage
8 1 (1.02%) UiPath