Period
to 20 November 2017

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 20 November 2017 with a comparison to the same period in the previous 2 years.

Data Warehousing
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 66 95 111
Rank change year-on-year +29 +16 -32
Permanent jobs citing Data Warehouse 192 149 178
As % of all permanent IT jobs advertised in Leeds 3.89% 2.78% 2.56%
As % of the Database & Business Intelligence category 13.36% 8.98% 7.64%
Number of salaries quoted 170 119 149
Leeds median annual salary £45,000 £45,000 £45,000
10th Percentile £31,250 £35,000 £28,450
90th Percentile £67,500 £55,250 £60,000
West Yorkshire median annual salary £45,000 £47,500 £42,500
% change year-on-year -5.26% +11.76% -5.56%

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 1437 1659 2329
As % of all permanent IT jobs advertised in Leeds 29.09% 30.95% 33.47%
Number of salaries quoted 1272 1501 1874
Leeds median annual salary £45,000 £41,500 £42,500
Median salary % change year-on-year +8.43% -2.35% +6.25%
10th Percentile £30,000 £28,250 £28,500
90th Percentile £61,250 £57,500 £60,875
West Yorkshire median annual salary £44,471 £40,000 £40,000
% change year-on-year +11.18% - +3.90%

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 20 November 2017.

Salary histogram for Data Warehouse in Leeds

For the 6 months to 20 November 2017, IT 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 job ads across the Leeds region with a requirement for Data Warehouse.

1 145 (75.52%) SQL
2 125 (65.10%) Business Intelligence
3 118 (61.46%) SQL Server
4 107 (55.73%) SQL Server Integration Services
5 91 (47.40%) ETL
6 84 (43.75%) SQL Server Reporting Services
7 83 (43.23%) SQL Server Analysis Services
8 73 (38.02%) Data Modelling
9 65 (33.85%) Microsoft
10 62 (32.29%) T-SQL
11 55 (28.65%) SQL Server 2012
12 50 (26.04%) Analytics
13 42 (21.88%) Finance
14 39 (20.31%) Migration
15 37 (19.27%) Analytical Skills
16 35 (18.23%) SQL Server 2014
16 35 (18.23%) Data Visualisation
16 35 (18.23%) Visualisation
17 32 (16.67%) Oracle
18 30 (15.63%) Data Mining
19 28 (14.58%) Agile Software Development
19 28 (14.58%) Data Analysis
20 26 (13.54%) Tableau
20 26 (13.54%) SQL Server 2016
21 22 (11.46%) Data Management
22 21 (10.94%) Data Integration
23 20 (10.42%) Advertising
23 20 (10.42%) Microsoft Excel
24 19 (9.90%) Linux
24 19 (9.90%) VBA

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 19 (9.90%) SAS
2 6 (3.13%) SharePoint
3 1 (0.52%) Oracle SOA Suite
Applications
1 20 (10.42%) Microsoft Excel
2 8 (4.17%) SPSS
3 7 (3.65%) Microsoft Office
Business Applications
1 2 (1.04%) Dynamics CRM
Cloud Services
1 5 (2.60%) Microsoft Azure
2 4 (2.08%) Google Analytics
2 4 (2.08%) Google Tag Manager
3 2 (1.04%) Cortana Intelligence Suite
4 1 (0.52%) Amazon AWS
Database & Business Intelligence
1 118 (61.46%) SQL Server
2 107 (55.73%) SQL Server Integration Services
3 84 (43.75%) SQL Server Reporting Services
4 83 (43.23%) SQL Server Analysis Services
5 55 (28.65%) SQL Server 2012
6 35 (18.23%) SQL Server 2014
7 30 (15.63%) Data Mining
8 26 (13.54%) SQL Server 2016
9 17 (8.85%) DataStage
9 17 (8.85%) IBM InfoSphere
9 17 (8.85%) SQL Server 2008
10 15 (7.81%) MS Access
11 14 (7.29%) Big Data
12 11 (5.73%) MySQL
12 11 (5.73%) Relational Database
13 9 (4.69%) Power BI
13 9 (4.69%) SAP Data Services
14 8 (4.17%) Enterprise Data Warehouse
14 8 (4.17%) Microsoft Analysis Services
14 8 (4.17%) QlikView
Development Applications
1 13 (6.77%) Team Foundation Server
2 11 (5.73%) Visual Studio
3 8 (4.17%) Talend Open Studio
4 5 (2.60%) SQL Server Management Studio (SSMS)
5 1 (0.52%) Oracle APEX
General
1 42 (21.88%) Finance
2 20 (10.42%) Advertising
3 11 (5.73%) Games
4 6 (3.13%) Marketing
5 4 (2.08%) Military
6 3 (1.56%) Legal
7 1 (0.52%) Retail
Job Titles
1 83 (43.23%) Developer
2 50 (26.04%) Business Intelligence Developer
3 36 (18.75%) SQL Developer
3 36 (18.75%) SSIS Developer
4 29 (15.10%) SQL BI Developer
5 26 (13.54%) ETL Developer
6 25 (13.02%) Analyst
7 23 (11.98%) T-SQL Developer
8 22 (11.46%) Data Warehouse Developer
9 21 (10.94%) DBA
10 17 (8.85%) Administrator
11 14 (7.29%) SQL DBA
12 12 (6.25%) Architect
13 11 (5.73%) Senior DBA
13 11 (5.73%) Trainer
14 10 (5.21%) Data Analyst
14 10 (5.21%) Data Scientist
15 7 (3.65%) SQL Server Developer
16 6 (3.13%) Business Intelligence Analyst
16 6 (3.13%) Senior SQL DBA
Libraries, Frameworks & Software Standards
1 8 (4.17%) .NET
2 4 (2.08%) AngularJS
2 4 (2.08%) RabbitMQ
3 1 (0.52%) COM
3 1 (0.52%) CSS
3 1 (0.52%) HTML
3 1 (0.52%) MDX
Miscellaneous
1 37 (19.27%) Analytical Skills
2 11 (5.73%) Replication
3 8 (4.17%) Data Structures
3 8 (4.17%) Management Information System
4 4 (2.08%) BBC
4 4 (2.08%) Computer Science
4 4 (2.08%) Digital Media
4 4 (2.08%) NHS
4 4 (2.08%) Social Media
4 4 (2.08%) User Experience
5 2 (1.04%) Algorithms
5 2 (1.04%) Greenfield Project
6 1 (0.52%) Clustering
6 1 (0.52%) N-Tier
Operating Systems
1 19 (9.90%) Linux
2 4 (2.08%) Unix
3 2 (1.04%) Windows
Processes & Methodologies
1 125 (65.10%) Business Intelligence
2 91 (47.40%) ETL
3 73 (38.02%) Data Modelling
4 50 (26.04%) Analytics
5 39 (20.31%) Migration
6 35 (18.23%) Data Visualisation
6 35 (18.23%) Visualisation
7 28 (14.58%) Agile Software Development
7 28 (14.58%) Data Analysis
8 22 (11.46%) Data Management
9 21 (10.94%) Data Integration
10 18 (9.38%) Data Cleansing
10 18 (9.38%) Data Migration
11 15 (7.81%) Performance Tuning
12 14 (7.29%) Database Security
12 14 (7.29%) Kimball Methodology
12 14 (7.29%) Stakeholder Engagement
13 13 (6.77%) ETL Development
13 13 (6.77%) OpenUP
13 13 (6.77%) Predictive Analytics
Programming Languages
1 145 (75.52%) SQL
2 62 (32.29%) T-SQL
3 19 (9.90%) VBA
4 17 (8.85%) C#
5 16 (8.33%) Shell Script
6 15 (7.81%) Bash Shell
7 10 (5.21%) Java
7 10 (5.21%) VB
8 7 (3.65%) PL/SQL
9 4 (2.08%) C
10 3 (1.56%) FoxPro (VFP)
10 3 (1.56%) Python
10 3 (1.56%) VB6
11 2 (1.04%) VBScript
12 1 (0.52%) Data Analysis Expressions (DAX)
12 1 (0.52%) JavaScript
12 1 (0.52%) PowerShell
Qualifications
1 14 (7.29%) Degree
2 5 (2.60%) Microsoft Certification
3 4 (2.08%) Computer Science Degree
4 3 (1.56%) MCP
4 3 (1.56%) MCSA
5 2 (1.04%) SC Cleared
5 2 (1.04%) Security Cleared
6 1 (0.52%) Chartered Engineer
6 1 (0.52%) ISEB
6 1 (0.52%) MBCS
Quality Assurance & Compliance
1 17 (8.85%) QA
2 11 (5.73%) Data Quality
3 6 (3.13%) GDPR
4 2 (1.04%) SLA
5 1 (0.52%) ISO 9001
System Software
1 1 (0.52%) VMware Infrastructure
Systems Management
1 2 (1.04%) Failover Clustering
Vendors
1 65 (33.85%) Microsoft
2 32 (16.67%) Oracle
3 26 (13.54%) Tableau
4 17 (8.85%) IBM
5 15 (7.81%) Netezza
6 14 (7.29%) Cognos
7 9 (4.69%) SAP
8 8 (4.17%) Google
8 8 (4.17%) Talend
9 4 (2.08%) Apple
9 4 (2.08%) Facebook
9 4 (2.08%) RedGate
9 4 (2.08%) Sony
9 4 (2.08%) Xerox
9 4 (2.08%) Yahoo!
10 3 (1.56%) BT
10 3 (1.56%) Progress
11 1 (0.52%) Capita
11 1 (0.52%) Sybase
11 1 (0.52%) VMware