Period
to 18 July 2018

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

Data Warehousing
6 months to
18 Jul 2018
Same period 2017 Same period 2016
Rank 58 44 75
Rank change year-on-year -14 +31 -14
Permanent jobs citing Data Warehouse 32 28 17
As % of all permanent IT jobs advertised in York 4.55% 3.91% 2.20%
As % of the Database & Business Intelligence category 14.04% 12.67% 6.01%
Number of salaries quoted 31 25 16
York median annual salary £45,000 £42,500 £40,250
Median salary % change year-on-year +5.88% +5.59% +14.18%
10th Percentile £37,500 £31,250 £31,250
90th Percentile £61,500 £47,500 £47,500
North Yorkshire median annual salary £45,000 £42,500 £40,250
% change year-on-year +5.88% +5.59% +5.92%

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 228 221 283
As % of all permanent IT jobs advertised in York 32.39% 30.82% 36.56%
Number of salaries quoted 218 184 245
York median annual salary £45,000 £38,000 £42,500
Median salary % change year-on-year +18.42% -10.59% +8.28%
10th Percentile £32,500 £27,500 £30,000
90th Percentile £58,000 £49,625 £52,500
North Yorkshire median annual salary £45,000 £40,000 £42,500
% change year-on-year +12.50% -5.88% +6.25%

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 18 July 2018.

Salary histogram for Data Warehouse in York

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

1 24 (75.00%) SQL Server
2 23 (71.88%) SQL
2 23 (71.88%) Business Intelligence
3 21 (65.63%) Data Modelling
4 18 (56.25%) Finance
5 16 (50.00%) Tableau
6 15 (46.88%) T-SQL
7 14 (43.75%) Agile Software Development
7 14 (43.75%) Visualisation
8 13 (40.63%) ETL
9 12 (37.50%) Decision-Making
10 11 (34.38%) SQL Server Analysis Services
10 11 (34.38%) SQL Server Integration Services
11 9 (28.13%) Microsoft Azure
11 9 (28.13%) Waterfall
12 8 (25.00%) Amazon AWS
13 7 (21.88%) ERwin
13 7 (21.88%) Migration
14 6 (18.75%) Power BI
14 6 (18.75%) Microsoft
15 5 (15.63%) Business Analysis
15 5 (15.63%) SQL Server Reporting Services
15 5 (15.63%) Dashboard Development
15 5 (15.63%) Data Visualisation
16 4 (12.50%) Data Reconciliation
16 4 (12.50%) Self-Motivation
16 4 (12.50%) Commercial Awareness
16 4 (12.50%) Data Analysis
16 4 (12.50%) Data Validation
16 4 (12.50%) QlikView

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 1 (3.13%) Confluence
Business Applications
1 1 (3.13%) Oracle EBS
Cloud Services
1 9 (28.13%) Microsoft Azure
2 8 (25.00%) Amazon AWS
3 1 (3.13%) Azure Data Factory
3 1 (3.13%) Cloud Computing
Communications & Networking
1 1 (3.13%) DNS
Database & Business Intelligence
1 24 (75.00%) SQL Server
2 11 (34.38%) SQL Server Analysis Services
2 11 (34.38%) SQL Server Integration Services
3 6 (18.75%) Power BI
4 5 (15.63%) SQL Server Reporting Services
5 4 (12.50%) QlikView
6 2 (6.25%) Azure SQL Data Warehouse
6 2 (6.25%) MySQL
7 1 (3.13%) Amazon Redshift
7 1 (3.13%) Microsoft Analysis Services
7 1 (3.13%) PowerCenter
7 1 (3.13%) SQL Server 2016
Development Applications
1 7 (21.88%) ERwin
2 1 (3.13%) Bitbucket
2 1 (3.13%) Git (software)
2 1 (3.13%) Jenkins
2 1 (3.13%) JIRA
General
1 18 (56.25%) Finance
2 1 (3.13%) Banking
2 1 (3.13%) Retail
Job Titles
1 13 (40.63%) Analyst
2 12 (37.50%) Developer
3 11 (34.38%) Data Warehouse Analyst
4 9 (28.13%) Business Analyst
5 8 (25.00%) Business Intelligence Developer
6 7 (21.88%) Data Warehouse Business Analyst
7 6 (18.75%) Business Intelligence Analyst
7 6 (18.75%) Business Intelligence Business Analyst
8 5 (15.63%) Data Business Analyst
9 4 (12.50%) Business Developer
9 4 (12.50%) Data Analyst
9 4 (12.50%) Data Warehouse Test Analyst
9 4 (12.50%) Test Analyst
9 4 (12.50%) Tester
10 3 (9.38%) Azure Developer
10 3 (9.38%) Consultant
10 3 (9.38%) ETL Developer
10 3 (9.38%) SSAS Developer
10 3 (9.38%) Technical Leader
10 3 (9.38%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 1 (3.13%) .NET
1 1 (3.13%) .NET Framework
1 1 (3.13%) AngularJS
1 1 (3.13%) ASP.NET
1 1 (3.13%) ASP.NET MVC
1 1 (3.13%) Entity Framework
1 1 (3.13%) HTML
1 1 (3.13%) HTML5
1 1 (3.13%) jQuery
1 1 (3.13%) Twitter Bootstrap
1 1 (3.13%) Web Services
Miscellaneous
1 4 (12.50%) Self-Motivation
2 1 (3.13%) Enterprise Software
Operating Systems
1 2 (6.25%) Windows
1 2 (6.25%) Windows Server
Processes & Methodologies
1 23 (71.88%) Business Intelligence
2 21 (65.63%) Data Modelling
3 14 (43.75%) Agile Software Development
3 14 (43.75%) Visualisation
4 13 (40.63%) ETL
5 12 (37.50%) Decision-Making
6 9 (28.13%) Waterfall
7 7 (21.88%) Migration
8 5 (15.63%) Business Analysis
8 5 (15.63%) Dashboard Development
8 5 (15.63%) Data Visualisation
9 4 (12.50%) Commercial Awareness
9 4 (12.50%) Data Analysis
9 4 (12.50%) Data Reconciliation
9 4 (12.50%) Data Validation
9 4 (12.50%) Validation
10 3 (9.38%) Data Architecture
11 1 (3.13%) DevOps
11 1 (3.13%) Mentoring
11 1 (3.13%) Test Automation
Programming Languages
1 23 (71.88%) SQL
2 15 (46.88%) T-SQL
3 1 (3.13%) C#
3 1 (3.13%) PowerShell
3 1 (3.13%) R
Quality Assurance & Compliance
1 1 (3.13%) QA
System Software
1 2 (6.25%) Active Directory
Systems Management
1 1 (3.13%) Packer
1 1 (3.13%) Puppet
1 1 (3.13%) Terraform
Vendors
1 16 (50.00%) Tableau
2 6 (18.75%) Microsoft
3 4 (12.50%) Informatica
4 3 (9.38%) Oracle
5 1 (3.13%) Atlassian
5 1 (3.13%) Cognos