Period
to 16 February 2019

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 16 February 2019 with a comparison to the same period in the previous 2 years.

Data Warehousing
6 months to
16 Feb 2019
Same period 2018 Same period 2017
Rank 40 69 65
Rank change year-on-year +29 -4 -12
Permanent jobs citing Data Warehouse 32 9 16
As % of all permanent IT jobs advertised in York 5.77% 1.29% 2.51%
As % of the Database & Business Intelligence category 16.00% 4.57% 7.08%
Number of salaries quoted 30 9 14
York median annual salary £50,000 £42,000 £45,000
Median salary % change year-on-year +19.05% -6.67% +12.50%
10th Percentile £41,250 £35,950 £28,750
90th Percentile £67,875 £49,500 £66,750
North Yorkshire median annual salary £50,000 £42,000 £40,000
% change year-on-year +19.05% +5.00% +14.29%

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 200 197 226
As % of all permanent IT jobs advertised in York 36.04% 28.18% 35.42%
Number of salaries quoted 179 181 191
York median annual salary £45,000 £42,500 £40,000
Median salary % change year-on-year +5.88% +6.25% -
10th Percentile £30,000 £27,000 £27,500
90th Percentile £57,500 £56,250 £51,250
North Yorkshire median annual salary £43,000 £42,500 £40,000
% change year-on-year +1.18% +6.25% +6.67%

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 16 February 2019.

Salary histogram for Data Warehouse in York

For the 6 months to 16 February 2019, 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 31 (96.88%) SQL
2 30 (93.75%) SQL Server
3 24 (75.00%) Business Intelligence
4 23 (71.88%) Data Modelling
5 20 (62.50%) Finance
6 17 (53.13%) Tableau
7 15 (46.88%) Agile Software Development
7 15 (46.88%) Decision-Making
8 14 (43.75%) ETL
8 14 (43.75%) ERwin
8 14 (43.75%) Waterfall
9 13 (40.63%) SQL Server Integration Services
10 11 (34.38%) Enterprise Data Warehouse
11 10 (31.25%) SQL Server Analysis Services
12 7 (21.88%) Visualisation
12 7 (21.88%) Performance Tuning
13 6 (18.75%) SQL Server Reporting Services
13 6 (18.75%) PostgreSQL
13 6 (18.75%) Microsoft
14 5 (15.63%) Migration
14 5 (15.63%) Business Analysis
15 4 (12.50%) SQL Server 2012
15 4 (12.50%) Kimball Methodology
15 4 (12.50%) NoSQL
15 4 (12.50%) Talend
15 4 (12.50%) Stakeholder Management
15 4 (12.50%) T-SQL
16 3 (9.38%) Power BI
17 2 (6.25%) Greenfield Project
17 2 (6.25%) PL/SQL

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:

Cloud Services
1 1 (3.13%) Amazon AWS
Database & Business Intelligence
1 30 (93.75%) SQL Server
2 13 (40.63%) SQL Server Integration Services
3 11 (34.38%) Enterprise Data Warehouse
4 10 (31.25%) SQL Server Analysis Services
5 6 (18.75%) PostgreSQL
5 6 (18.75%) SQL Server Reporting Services
6 4 (12.50%) NoSQL
6 4 (12.50%) SQL Server 2012
7 3 (9.38%) Power BI
8 2 (6.25%) BODI
8 2 (6.25%) BusinessObjects
8 2 (6.25%) OLAP
8 2 (6.25%) OLAP Cube
9 1 (3.13%) Amazon Redshift
9 1 (3.13%) Cognos Framework Manager
9 1 (3.13%) MySQL
9 1 (3.13%) Oracle OLAP
9 1 (3.13%) Relational Database
Development Applications
1 14 (43.75%) ERwin
General
1 20 (62.50%) Finance
2 1 (3.13%) Retail
Job Titles
1 14 (43.75%) Analyst
1 14 (43.75%) Business Analyst
1 14 (43.75%) Business Intelligence Analyst
1 14 (43.75%) Business Intelligence Business Analyst
1 14 (43.75%) Developer
2 9 (28.13%) Data Warehouse Developer
3 5 (15.63%) Business Intelligence Developer
3 5 (15.63%) Data Business Analyst
3 5 (15.63%) Data Warehouse Analyst
3 5 (15.63%) Data Warehouse Business Analyst
4 3 (9.38%) Administrator
4 3 (9.38%) DBA
4 3 (9.38%) Lead Developer
4 3 (9.38%) SQL DBA
4 3 (9.38%) SQL Server DBA
5 2 (6.25%) Senior Business Intelligence Developer
5 2 (6.25%) Senior Developer
6 1 (3.13%) Business Developer
6 1 (3.13%) Microsoft BI Developer
6 1 (3.13%) Microsoft Developer
Libraries, Frameworks & Software Standards
1 1 (3.13%) Web Services
Miscellaneous
1 2 (6.25%) Greenfield Project
2 1 (3.13%) Analytical Skills
Processes & Methodologies
1 24 (75.00%) Business Intelligence
2 23 (71.88%) Data Modelling
3 15 (46.88%) Agile Software Development
3 15 (46.88%) Decision-Making
4 14 (43.75%) ETL
4 14 (43.75%) Waterfall
5 7 (21.88%) Performance Tuning
5 7 (21.88%) Visualisation
6 5 (15.63%) Business Analysis
6 5 (15.63%) Migration
7 4 (12.50%) Kimball Methodology
7 4 (12.50%) Stakeholder Management
8 2 (6.25%) Analytics
9 1 (3.13%) Business Analytics
9 1 (3.13%) Dashboard Development
9 1 (3.13%) Data Analysis
9 1 (3.13%) Data Analytics
9 1 (3.13%) Data Development
9 1 (3.13%) DevOps
Programming Languages
1 31 (96.88%) SQL
2 4 (12.50%) T-SQL
3 2 (6.25%) PL/SQL
4 1 (3.13%) Python
4 1 (3.13%) R
Quality Assurance & Compliance
1 1 (3.13%) QA
Vendors
1 17 (53.13%) Tableau
2 6 (18.75%) Microsoft
3 4 (12.50%) Talend
4 1 (3.13%) Cognos
4 1 (3.13%) IBM
4 1 (3.13%) Oracle