Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies advertised in York 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 51 63 61
Rank change year-on-year +12 -2 +16
Permanent jobs citing Data Warehouse 23 7 20
As % of all permanent IT jobs advertised in York 3.42% 1.11% 3.48%
As % of the Database & Business Intelligence category 10.04% 3.24% 7.52%
Number of salaries quoted 22 6 14
York median annual salary £42,500 £45,000 £40,000
Median salary % change year-on-year -5.56% +12.50% -8.57%
10th Percentile £33,750 £34,375 £24,500
90th Percentile £56,400 £75,000 £50,250
North Yorkshire median annual salary £42,500 £40,000 £35,000
% change year-on-year +6.25% +14.29% -15.66%

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

All Database and Business Intelligence Skills
York
Permanent vacancies with a requirement for database or business intelligence skills 229 216 266
As % of all permanent IT jobs advertised in York 34.08% 34.34% 46.34%
Number of salaries quoted 188 182 236
York median annual salary £40,000 £40,000 £40,000
10th Percentile £26,000 £27,500 £26,500
90th Percentile £53,750 £51,250 £51,750
North Yorkshire median annual salary £40,000 £40,000 £40,000

Data Warehouse
Job Vacancy Trend in York

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

Job vacancy trend for Data Warehouse in York

Data Warehouse
Salary Trend in York

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

Salary trend for Data Warehouse in York

Data Warehouse
Salary Histogram in York

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

Salary histogram for Data Warehouse in York

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 York region with a requirement for Data Warehouse.

1 20 (86.96%) SQL
1 20 (86.96%) Business Intelligence
2 19 (82.61%) SQL Server
2 19 (82.61%) SQL Server Integration Services
2 19 (82.61%) SQL Server Analysis Services
3 18 (78.26%) SQL Server Reporting Services
4 14 (60.87%) .NET
5 13 (56.52%) C#
6 12 (52.17%) Power BI
7 10 (43.48%) Data Strategy
7 10 (43.48%) T-SQL
7 10 (43.48%) Data Modelling
7 10 (43.48%) Data Management
8 9 (39.13%) CRM
9 8 (34.78%) SDLC
10 7 (30.43%) Microsoft
10 7 (30.43%) SQL Server 2016
11 6 (26.09%) Management Information System
12 5 (21.74%) Document Management
12 5 (21.74%) Data Protection
13 4 (17.39%) ASP.NET
14 3 (13.04%) Dynamics CRM
14 3 (13.04%) VSS/SourceSafe
14 3 (13.04%) SharePoint
14 3 (13.04%) VB
14 3 (13.04%) MVC
14 3 (13.04%) Migration
14 3 (13.04%) Microsoft Excel
14 3 (13.04%) ETL
14 3 (13.04%) BizTalk Server

Data Warehouse
Co-occurring IT Skills in York 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 3 (13.04%) BizTalk Server
1 3 (13.04%) SharePoint
2 1 (4.35%) CMS
Applications
1 3 (13.04%) Microsoft Excel
Business Applications
1 3 (13.04%) Dynamics CRM
2 1 (4.35%) Visualfiles
Cloud Services
1 1 (4.35%) Amazon AWS
Database & Business Intelligence
1 19 (82.61%) SQL Server
1 19 (82.61%) SQL Server Analysis Services
1 19 (82.61%) SQL Server Integration Services
2 18 (78.26%) SQL Server Reporting Services
3 12 (52.17%) Power BI
4 7 (30.43%) SQL Server 2016
5 3 (13.04%) SQL Server 2008
6 2 (8.70%) SQL Server 2014
7 1 (4.35%) OLAP
7 1 (4.35%) OLAP Cube
7 1 (4.35%) SQL Server 2012
Development Applications
1 3 (13.04%) Team Foundation Server
1 3 (13.04%) VSS/SourceSafe
General
1 2 (8.70%) Marketing
2 1 (4.35%) Finance
2 1 (4.35%) Legal
2 1 (4.35%) Retail
Job Titles
1 20 (86.96%) Developer
2 15 (65.22%) Business Intelligence Developer
3 8 (34.78%) Business Developer
4 6 (26.09%) SQL Developer
5 4 (17.39%) .NET Developer
5 4 (17.39%) C# .NET Developer
5 4 (17.39%) C# Developer
5 4 (17.39%) SQL BI Developer
5 4 (17.39%) SSIS Developer
6 3 (13.04%) SSAS Developer
6 3 (13.04%) SSRS Developer
6 3 (13.04%) T-SQL Developer
7 2 (8.70%) Development Manager
7 2 (8.70%) SQL Server BI Developer
7 2 (8.70%) SQL Server Developer
8 1 (4.35%) AWS Architect
8 1 (4.35%) CRM Developer
8 1 (4.35%) Database Manager
8 1 (4.35%) Senior SQL Developer
8 1 (4.35%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 14 (60.87%) .NET
2 4 (17.39%) ASP.NET
3 1 (4.35%) Velocity
3 1 (4.35%) Web Services
Miscellaneous
1 6 (26.09%) Management Information System
2 3 (13.04%) Analytical Skills
3 2 (8.70%) Clustering
4 1 (4.35%) EPoS
4 1 (4.35%) Greenfield Project
4 1 (4.35%) N-Tier
Operating Systems
1 1 (4.35%) Unix
Processes & Methodologies
1 20 (86.96%) Business Intelligence
2 10 (43.48%) Data Management
2 10 (43.48%) Data Modelling
2 10 (43.48%) Data Strategy
3 9 (39.13%) CRM
4 8 (34.78%) SDLC
5 5 (21.74%) Data Protection
5 5 (21.74%) Document Management
6 3 (13.04%) ERD
6 3 (13.04%) ETL
6 3 (13.04%) Migration
6 3 (13.04%) MVC
7 1 (4.35%) Agile Software Development
7 1 (4.35%) API Design
7 1 (4.35%) Case Management
7 1 (4.35%) DevOps
7 1 (4.35%) Microservices
7 1 (4.35%) SOA
Programming Languages
1 20 (86.96%) SQL
2 13 (56.52%) C#
3 10 (43.48%) T-SQL
4 3 (13.04%) VB
5 1 (4.35%) Java
5 1 (4.35%) VB.NET
Qualifications
1 3 (13.04%) Degree
Vendors
1 7 (30.43%) Microsoft