Period
to 18 November 2017

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

Data Warehousing
England > Yorkshire
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 68 108 77
Rank change year-on-year +40 -31 +5
Permanent jobs citing Data Warehouse 351 288 456
As % of all permanent IT jobs advertised in Yorkshire 3.61% 2.58% 3.44%
As % of the Database & Business Intelligence category 12.22% 8.72% 10.25%
Number of salaries quoted 307 235 368
Yorkshire median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -5.56%
10th Percentile £31,250 £32,000 £29,250
90th Percentile £61,250 £72,500 £58,750
England median annual salary £52,500 £55,000 £50,000
% change year-on-year -4.55% +10.00% -4.76%

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

All Database and Business Intelligence Skills
Yorkshire
Permanent vacancies with a requirement for database or business intelligence skills 2872 3303 4449
As % of all permanent IT jobs advertised in Yorkshire 29.53% 29.57% 33.57%
Number of salaries quoted 2487 2875 3700
Yorkshire median annual salary £42,500 £40,000 £40,000
Median salary % change year-on-year +6.25% - +6.67%
10th Percentile £27,000 £27,000 £26,250
90th Percentile £60,000 £57,500 £58,775
England median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

Data Warehouse
Job Vacancy Trend in Yorkshire

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

Job vacancy trend for Data Warehouse in Yorkshire

Data Warehouse
Salary Trend in Yorkshire

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

Salary trend for Data Warehouse in Yorkshire

Data Warehouse
Salary Histogram in Yorkshire

The salary distribution of IT jobs citing Data Warehouse in Yorkshire over the 6 months to 18 November 2017.

Salary histogram for Data Warehouse in Yorkshire

Data Warehouse
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Yorkshire region over the 6 months to 18 November 2017. 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
West Yorkshire +29 264 £45,000 -5.26% 17
South Yorkshire +26 32 £35,500 -2.74%
North Yorkshire +12 24 £42,500 +6.25% 1
East Yorkshire +14 22 £45,000 +2.86% 1
Data Warehouse
England

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

1 267 (76.07%) SQL
2 247 (70.37%) Business Intelligence
3 233 (66.38%) SQL Server
4 204 (58.12%) SQL Server Integration Services
5 182 (51.85%) ETL
6 171 (48.72%) SQL Server Reporting Services
7 157 (44.73%) SQL Server Analysis Services
8 138 (39.32%) T-SQL
9 136 (38.75%) Microsoft
10 129 (36.75%) Data Modelling
11 81 (23.08%) Finance
12 74 (21.08%) Agile Software Development
13 70 (19.94%) SQL Server 2012
14 69 (19.66%) Analytics
15 59 (16.81%) Analytical Skills
16 57 (16.24%) Visualisation
16 57 (16.24%) Migration
16 57 (16.24%) Oracle
17 53 (15.10%) Data Visualisation
18 52 (14.81%) Power BI
19 45 (12.82%) Performance Tuning
19 45 (12.82%) Data Management
20 43 (12.25%) C#
21 42 (11.97%) Tableau
21 42 (11.97%) SQL Server 2014
21 42 (11.97%) SQL Server 2016
22 38 (10.83%) Data Analysis
23 35 (9.97%) SAP
23 35 (9.97%) Data Integration
24 34 (9.69%) Data Quality

Data Warehouse
Co-occurring IT Skills in Yorkshire 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 29 (8.26%) SAS
2 15 (4.27%) SharePoint
3 3 (0.85%) BizTalk Server
4 1 (0.28%) CMS
4 1 (0.28%) IBM Notes
4 1 (0.28%) Oracle SOA Suite
Applications
1 26 (7.41%) Microsoft Excel
2 15 (4.27%) SPSS
3 7 (1.99%) Microsoft Office
4 3 (0.85%) Microsoft Project
5 1 (0.28%) Microsoft PowerPoint
5 1 (0.28%) MS Visio
Business Applications
1 5 (1.42%) Dynamics CRM
1 5 (1.42%) SAP Hybris
2 3 (0.85%) Oracle ERP
3 2 (0.57%) Aareon QL
3 2 (0.57%) Kypera Housing
3 2 (0.57%) Northgate Housing
3 2 (0.57%) OPENHousing
4 1 (0.28%) Dynamics AX
4 1 (0.28%) Visualfiles
Cloud Services
1 15 (4.27%) Microsoft Azure
2 6 (1.71%) Amazon AWS
3 4 (1.14%) Google Analytics
3 4 (1.14%) Google Tag Manager
4 2 (0.57%) Cortana Intelligence Suite
5 1 (0.28%) GitHub
5 1 (0.28%) Office 365
5 1 (0.28%) Slack
Communications & Networking
1 2 (0.57%) SMS
Database & Business Intelligence
1 233 (66.38%) SQL Server
2 204 (58.12%) SQL Server Integration Services
3 171 (48.72%) SQL Server Reporting Services
4 157 (44.73%) SQL Server Analysis Services
5 70 (19.94%) SQL Server 2012
6 52 (14.81%) Power BI
7 42 (11.97%) SQL Server 2014
7 42 (11.97%) SQL Server 2016
8 29 (8.26%) Data Mining
8 29 (8.26%) SQL Server 2008
9 25 (7.12%) Relational Database
10 21 (5.98%) QlikView
11 20 (5.70%) BusinessObjects
11 20 (5.70%) SAP HANA
12 17 (4.84%) DataStage
12 17 (4.84%) IBM InfoSphere
13 15 (4.27%) Enterprise Data Warehouse
13 15 (4.27%) MS Access
13 15 (4.27%) SAP Data Services
13 15 (4.27%) Star Schema
Development Applications
1 24 (6.84%) SQL Server Management Studio (SSMS)
2 22 (6.27%) Team Foundation Server
2 22 (6.27%) Visual Studio
3 11 (3.13%) Talend Open Studio
4 7 (1.99%) Toad
5 5 (1.42%) Visual Studio Team System
6 4 (1.14%) Octopus Deploy
7 3 (0.85%) Oracle Forms
7 3 (0.85%) VSS/SourceSafe
8 2 (0.57%) Jenkins
9 1 (0.28%) Git (software)
9 1 (0.28%) Oracle APEX
General
1 81 (23.08%) Finance
2 29 (8.26%) Advertising
3 19 (5.41%) Retail
4 15 (4.27%) Marketing
5 11 (3.13%) Games
6 8 (2.28%) Manufacturing
7 5 (1.42%) Banking
7 5 (1.42%) Legal
8 4 (1.14%) Military
8 4 (1.14%) Telecoms
9 3 (0.85%) Retail Finance
10 1 (0.28%) Back Office
10 1 (0.28%) Law
10 1 (0.28%) Private Banking
10 1 (0.28%) Retail Banking
Job Titles
1 171 (48.72%) Developer
2 107 (30.48%) Business Intelligence Developer
3 63 (17.95%) SQL Developer
4 58 (16.52%) SSIS Developer
5 47 (13.39%) SQL BI Developer
6 45 (12.82%) DBA
7 44 (12.54%) Analyst
8 40 (11.40%) Senior Developer
9 38 (10.83%) Administrator
10 36 (10.26%) SQL DBA
11 34 (9.69%) Data Warehouse Developer
12 33 (9.40%) T-SQL Developer
13 32 (9.12%) Senior Business Intelligence Developer
14 31 (8.83%) ETL Developer
15 30 (8.55%) Senior DBA
16 27 (7.69%) Architect
17 25 (7.12%) Senior SQL DBA
18 23 (6.55%) Business Developer
19 20 (5.70%) Data Architect
20 18 (5.13%) Senior SQL Developer
Libraries, Frameworks & Software Standards
1 26 (7.41%) .NET
2 12 (3.42%) Middleware
3 5 (1.42%) AngularJS
3 5 (1.42%) ASP.NET
4 4 (1.14%) RabbitMQ
4 4 (1.14%) XML
5 1 (0.28%) .NET Framework
5 1 (0.28%) ASP.NET MVC
5 1 (0.28%) Aurelia
5 1 (0.28%) COM
5 1 (0.28%) CSS
5 1 (0.28%) D3.js
5 1 (0.28%) EDI
5 1 (0.28%) Entity Framework
5 1 (0.28%) HTML
5 1 (0.28%) jQuery
5 1 (0.28%) MDX
5 1 (0.28%) Velocity
5 1 (0.28%) Web Services
Miscellaneous
1 59 (16.81%) Analytical Skills
2 15 (4.27%) Management Information System
3 14 (3.99%) Data Structures
4 12 (3.42%) Replication
5 11 (3.13%) Computer Science
6 8 (2.28%) NHS
7 7 (1.99%) Credit Risk
8 4 (1.14%) BBC
8 4 (1.14%) Data Centre
8 4 (1.14%) Digital Media
8 4 (1.14%) Social Media
8 4 (1.14%) User Experience
9 3 (0.85%) Clustering
10 2 (0.57%) Algorithms
10 2 (0.57%) Greenfield Project
10 2 (0.57%) N-Tier
11 1 (0.28%) EPoS
Operating Systems
1 21 (5.98%) Linux
2 6 (1.71%) Unix
3 2 (0.57%) Windows
Processes & Methodologies
1 247 (70.37%) Business Intelligence
2 182 (51.85%) ETL
3 129 (36.75%) Data Modelling
4 74 (21.08%) Agile Software Development
5 69 (19.66%) Analytics
6 57 (16.24%) Migration
6 57 (16.24%) Visualisation
7 53 (15.10%) Data Visualisation
8 45 (12.82%) Data Management
8 45 (12.82%) Performance Tuning
9 38 (10.83%) Data Analysis
10 35 (9.97%) Data Integration
11 33 (9.40%) ETL Development
12 29 (8.26%) Disaster Recovery
13 28 (7.98%) Kimball Methodology
14 24 (6.84%) Data Migration
14 24 (6.84%) Data Strategy
15 23 (6.55%) Coaching
15 23 (6.55%) Data Cleansing
16 21 (5.98%) CRM
Programming Languages
1 267 (76.07%) SQL
2 138 (39.32%) T-SQL
3 43 (12.25%) C#
4 22 (6.27%) PowerShell
5 19 (5.41%) VBA
6 16 (4.56%) Shell Script
7 15 (4.27%) Bash Shell
8 14 (3.99%) VB
9 13 (3.70%) PL/SQL
10 12 (3.42%) Java
11 11 (3.13%) R
12 7 (1.99%) MATLAB
12 7 (1.99%) Python
13 4 (1.14%) C
14 3 (0.85%) ABAP
14 3 (0.85%) FoxPro (VFP)
14 3 (0.85%) VB6
15 2 (0.57%) VBScript
16 1 (0.28%) JavaScript
16 1 (0.28%) PHP
Qualifications
1 25 (7.12%) Degree
2 22 (6.27%) Microsoft Certification
3 20 (5.70%) MCSA
4 17 (4.84%) MCSE
5 6 (1.71%) Postgraduate
6 4 (1.14%) Computer Science Degree
7 3 (0.85%) MCP
8 2 (0.57%) SC Cleared
8 2 (0.57%) Security Cleared
9 1 (0.28%) Chartered Engineer
9 1 (0.28%) ISEB
9 1 (0.28%) MBCS
Quality Assurance & Compliance
1 34 (9.69%) Data Quality
2 18 (5.13%) QA
3 6 (1.71%) GDPR
4 3 (0.85%) SLA
5 2 (0.57%) ISO 9001
6 1 (0.28%) Actionable Recommendations
System Software
1 5 (1.42%) VMware Infrastructure
2 4 (1.14%) Active Directory
Systems Management
1 2 (0.57%) Failover Clustering
2 1 (0.28%) Puppet
Vendors
1 136 (38.75%) Microsoft
2 57 (16.24%) Oracle
3 42 (11.97%) Tableau
4 35 (9.97%) SAP
5 25 (7.12%) IBM
6 17 (4.84%) Cognos
7 15 (4.27%) Netezza
8 11 (3.13%) Talend
9 9 (2.56%) Alteryx
10 8 (2.28%) Google
10 8 (2.28%) RedGate
11 6 (1.71%) Sybase
12 5 (1.42%) hybris
12 5 (1.42%) VMware
13 4 (1.14%) Apple
13 4 (1.14%) Facebook
13 4 (1.14%) Sony
13 4 (1.14%) Xerox
13 4 (1.14%) Yahoo!
14 3 (0.85%) BT