Period
to 21 January 2018

The following table provides summary statistics for permanent job vacancies advertised in Chester 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 21 January 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
Cheshire > Chester
6 months to
21 Jan 2018
Same period 2017 Same period 2016
Rank 38 24 30
Rank change year-on-year -14 +6 -15
Permanent jobs citing Data Warehouse 22 19 27
As % of all permanent IT jobs advertised in Chester 5.31% 7.14% 7.14%
As % of the Database & Business Intelligence category 11.96% 18.81% 15.79%
Number of salaries quoted 19 16 27
Chester median annual salary £32,500 £41,250 £50,000
Median salary % change year-on-year -21.21% -17.50% +2.56%
10th Percentile £19,750 £31,250 £30,000
90th Percentile £51,250 £83,750 £52,500
Cheshire median annual salary £45,000 £40,000 £40,000
% change year-on-year +12.50% - -15.79%

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

All Database and Business Intelligence Skills
Chester
Permanent vacancies with a requirement for database or business intelligence skills 184 101 171
As % of all permanent IT jobs advertised in Chester 44.44% 37.97% 45.24%
Number of salaries quoted 161 86 159
Chester median annual salary £42,500 £40,000 £45,000
Median salary % change year-on-year +6.25% -11.11% +20.00%
10th Percentile £26,250 £26,250 £25,000
90th Percentile £55,000 £58,125 £60,750
Cheshire median annual salary £42,500 £37,500 £40,000
% change year-on-year +13.33% -6.25% -

Data Warehouse
Job Vacancy Trend in Chester

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

Job vacancy trend for Data Warehouse in Chester

Data Warehouse
Salary Trend in Chester

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

Salary trend for Data Warehouse in Chester

Data Warehouse
Salary Histogram in Chester

The salary distribution of IT jobs citing Data Warehouse in Chester over the 6 months to 21 January 2018.

Salary histogram for Data Warehouse in Chester

For the 6 months to 21 January 2018, 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 Chester region with a requirement for Data Warehouse.

1 18 (81.82%) Data Analysis
2 17 (77.27%) SQL
3 16 (72.73%) Business Intelligence
4 14 (63.64%) Visualisation
5 12 (54.55%) Data Visualisation
5 12 (54.55%) Stakeholder Engagement
5 12 (54.55%) Python
6 9 (40.91%) Analytics
7 8 (36.36%) Big Data
7 8 (36.36%) ETL
7 8 (36.36%) Google
8 7 (31.82%) SQL Server
8 7 (31.82%) VLDB
8 7 (31.82%) Web Development
8 7 (31.82%) Computer Science
8 7 (31.82%) QlikView
8 7 (31.82%) Power BI
8 7 (31.82%) SQL Server 2016
9 6 (27.27%) SQL Server Analysis Services
9 6 (27.27%) SQL Server Reporting Services
9 6 (27.27%) SQL Server Integration Services
9 6 (27.27%) Finance
10 5 (22.73%) Migration
10 5 (22.73%) Salesforce.com
10 5 (22.73%) Snowflake Schema
10 5 (22.73%) Data Mining
10 5 (22.73%) Google Analytics
10 5 (22.73%) Data Migration
10 5 (22.73%) Degree
10 5 (22.73%) Tableau

Data Warehouse
Co-occurring IT Skills in Chester 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 2 (9.09%) Apache Spark
Applications
1 1 (4.55%) Microsoft Excel
Cloud Services
1 5 (22.73%) Google Analytics
2 2 (9.09%) Amazon AWS
2 2 (9.09%) GitHub
Communications & Networking
1 2 (9.09%) Internet
Database & Business Intelligence
1 8 (36.36%) Big Data
2 7 (31.82%) Power BI
2 7 (31.82%) QlikView
2 7 (31.82%) SQL Server
2 7 (31.82%) SQL Server 2016
2 7 (31.82%) VLDB
3 6 (27.27%) SQL Server Analysis Services
3 6 (27.27%) SQL Server Integration Services
3 6 (27.27%) SQL Server Reporting Services
4 5 (22.73%) Data Mining
4 5 (22.73%) Qlik Sense
4 5 (22.73%) Snowflake Schema
5 2 (9.09%) Apache Hive
5 2 (9.09%) NoSQL
Development Applications
1 2 (9.09%) Git (software)
General
1 6 (27.27%) Finance
2 1 (4.55%) Retail
Job Titles
1 12 (54.55%) Analyst
1 12 (54.55%) Data Analyst
2 6 (27.27%) Business Intelligence Developer
2 6 (27.27%) Developer
3 4 (18.18%) Business Intelligence Lead
3 4 (18.18%) Lead Developer
4 2 (9.09%) Big Data Engineer
4 2 (9.09%) Data Engineer
5 1 (4.55%) Business Analyst
5 1 (4.55%) Business Data Analyst
5 1 (4.55%) Data Business Analyst
5 1 (4.55%) SQL Analyst
5 1 (4.55%) SQL BI Developer
5 1 (4.55%) SQL Data Analyst
5 1 (4.55%) SQL Developer
5 1 (4.55%) Systems Analyst
Libraries, Frameworks & Software Standards
1 2 (9.09%) Web Services
Miscellaneous
1 7 (31.82%) Computer Science
2 4 (18.18%) Analytical Skills
3 2 (9.09%) Internet of Things
Processes & Methodologies
1 18 (81.82%) Data Analysis
2 16 (72.73%) Business Intelligence
3 14 (63.64%) Visualisation
4 12 (54.55%) Data Visualisation
4 12 (54.55%) Stakeholder Engagement
5 9 (40.91%) Analytics
6 8 (36.36%) ETL
7 7 (31.82%) Web Development
8 5 (22.73%) Data Migration
8 5 (22.73%) Migration
9 3 (13.64%) Machine Learning
9 3 (13.64%) Mathematics
9 3 (13.64%) Statistical Modelling
10 2 (9.09%) Data Analytics
10 2 (9.09%) Data Extraction
11 1 (4.55%) Customer Engagement
11 1 (4.55%) Data Cleansing
11 1 (4.55%) Data Protection
11 1 (4.55%) Use Case
11 1 (4.55%) User Stories
Programming Languages
1 17 (77.27%) SQL
2 12 (54.55%) Python
3 2 (9.09%) Java
3 2 (9.09%) R
4 1 (4.55%) T-SQL
4 1 (4.55%) VBA
Qualifications
1 5 (22.73%) Degree
Quality Assurance & Compliance
1 1 (4.55%) Data Quality
1 1 (4.55%) GDPR
Vendors
1 8 (36.36%) Google
2 5 (22.73%) Salesforce.com
2 5 (22.73%) Tableau
3 2 (9.09%) Talend
3 2 (9.09%) Twitter
3 2 (9.09%) Vertica
4 1 (4.55%) Microsoft