Period
to 17 December 2018

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

Data Warehousing
North West > Cheshire
6 months to
17 Dec 2018
Same period 2017 Same period 2016
Rank 76 89 94
Rank change year-on-year +13 +5 -51
Permanent jobs citing Data Warehouse 73 93 55
As % of all permanent IT jobs advertised in Cheshire 3.07% 2.99% 2.40%
As % of the Database & Business Intelligence category 10.49% 9.74% 7.06%
Number of salaries quoted 85 86 48
Cheshire median annual salary £45,000 £45,000 £41,250
Median salary % change year-on-year - +9.09% +3.13%
10th Percentile £33,500 £27,500 £30,750
90th Percentile £72,500 £58,750 £77,625
North West median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +6.25%

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

All Database and Business Intelligence Skills
Cheshire
Permanent vacancies with a requirement for database or business intelligence skills 696 955 779
As % of all permanent IT jobs advertised in Cheshire 29.29% 30.75% 33.93%
Number of salaries quoted 545 793 685
Cheshire median annual salary £45,000 £42,500 £36,500
Median salary % change year-on-year +5.88% +16.44% -8.75%
10th Percentile £28,750 £27,500 £25,750
90th Percentile £65,000 £60,000 £54,500
North West median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -

Data Warehouse
Job Vacancy Trend in Cheshire

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

Job vacancy trend for Data Warehouse in Cheshire

Data Warehouse
Salary Trend in Cheshire

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

Salary trend for Data Warehouse in Cheshire

Data Warehouse
Salary Histogram in Cheshire

The salary distribution of IT jobs citing Data Warehouse in Cheshire over the 6 months to 17 December 2018.

Salary histogram for Data Warehouse in Cheshire

Data Warehouse
Job Locations in Cheshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Cheshire region over the 6 months to 17 December 2018. 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
Chester +25 32 £70,000 +133.33% 6
Warrington +6 23 £42,000 -6.67% 7
Runcorn - 4 £42,500 - 1
Crewe +9 3 £42,500 -8.11%
Knutsford +16 1 - -
Ellesmere Port - 1 £52,500 -
Data Warehouse
North West

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

1 53 (72.60%) SQL
1 53 (72.60%) Business Intelligence
2 47 (64.38%) SQL Server
3 45 (61.64%) SQL Server Integration Services
4 38 (52.05%) ETL
5 35 (47.95%) SQL Server Analysis Services
5 35 (47.95%) SQL Server Reporting Services
6 30 (41.10%) T-SQL
7 26 (35.62%) Data Analysis
8 20 (27.40%) Microsoft
9 17 (23.29%) Agile Software Development
10 14 (19.18%) Data Modelling
10 14 (19.18%) Problem-Solving
11 12 (16.44%) Coaching
12 11 (15.07%) Analytics
12 11 (15.07%) Finance
13 10 (13.70%) Configuration Management
13 10 (13.70%) .NET
13 10 (13.70%) OLAP
13 10 (13.70%) OLAP Cube
14 9 (12.33%) Jenkins
15 8 (10.96%) Atlassian Bamboo
15 8 (10.96%) TeamCity
15 8 (10.96%) Git (software)
15 8 (10.96%) IaaS
15 8 (10.96%) Data Analytics
15 8 (10.96%) PaaS
15 8 (10.96%) Puppet
15 8 (10.96%) Presales
15 8 (10.96%) Analytical Skills

Data Warehouse
Co-occurring IT Skills in Cheshire 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 (2.74%) Confluence
1 2 (2.74%) SharePoint
2 1 (1.37%) CICS
2 1 (1.37%) WebSphere
Applications
1 4 (5.48%) Microsoft Excel
2 2 (2.74%) Spreadsheet
3 1 (1.37%) Microsoft PowerPoint
3 1 (1.37%) MS Visio
Business Applications
1 1 (1.37%) Dynamics CRM
Cloud Services
1 8 (10.96%) IaaS
1 8 (10.96%) PaaS
2 4 (5.48%) Amazon AWS
3 2 (2.74%) Microsoft Azure
4 1 (1.37%) Dynamics 365
4 1 (1.37%) Google Analytics
4 1 (1.37%) Trello
Communications & Networking
1 2 (2.74%) Internet
2 1 (1.37%) FTP
Database & Business Intelligence
1 47 (64.38%) SQL Server
2 45 (61.64%) SQL Server Integration Services
3 35 (47.95%) SQL Server Analysis Services
3 35 (47.95%) SQL Server Reporting Services
4 10 (13.70%) OLAP
4 10 (13.70%) OLAP Cube
5 7 (9.59%) Power BI
6 6 (8.22%) SQL Server 2008
7 4 (5.48%) Microsoft Analysis Services
7 4 (5.48%) SQL Server 2012
8 3 (4.11%) Amazon Redshift
8 3 (4.11%) Data Mining
8 3 (4.11%) MS Access
8 3 (4.11%) MySQL
8 3 (4.11%) PostgreSQL
8 3 (4.11%) QlikView
8 3 (4.11%) SQL Server 2014
8 3 (4.11%) SQL Server 2016
9 2 (2.74%) Crystal Reports
10 1 (1.37%) DB2
Development Applications
1 9 (12.33%) Jenkins
2 8 (10.96%) Atlassian Bamboo
2 8 (10.96%) Git (software)
2 8 (10.96%) TeamCity
3 5 (6.85%) JIRA
4 2 (2.74%) Visual Studio
4 2 (2.74%) Zephyr
5 1 (1.37%) Bitbucket
5 1 (1.37%) Selenium
5 1 (1.37%) SoapUI
5 1 (1.37%) SOAtest
5 1 (1.37%) SQL Server Management Studio (SSMS)
5 1 (1.37%) Team Foundation Server
5 1 (1.37%) TestRail
General
1 11 (15.07%) Finance
2 5 (6.85%) Marketing
2 5 (6.85%) Retail
3 3 (4.11%) Banking
4 2 (2.74%) Manufacturing
5 1 (1.37%) Billing
5 1 (1.37%) Games
5 1 (1.37%) Investment Banking
5 1 (1.37%) Law
5 1 (1.37%) Retail Banking
Job Titles
1 38 (52.05%) Developer
2 28 (38.36%) Business Intelligence Developer
3 17 (23.29%) SQL Developer
4 13 (17.81%) Analyst
4 13 (17.81%) Business Developer
5 10 (13.70%) DBA
6 9 (12.33%) Architect
7 8 (10.96%) DevOps Architect
7 8 (10.96%) SQL BI Developer
7 8 (10.96%) SSIS Developer
8 6 (8.22%) SSAS Developer
9 5 (6.85%) Business Intelligence Analyst
9 5 (6.85%) SQL DBA
9 5 (6.85%) SSRS Developer
10 4 (5.48%) Administrator
10 4 (5.48%) Consultant
10 4 (5.48%) ERP Consultant
10 4 (5.48%) IT Consultant
10 4 (5.48%) Technology Consultant
11 3 (4.11%) Database Analyst
Libraries, Frameworks & Software Standards
1 10 (13.70%) .NET
2 2 (2.74%) MDX
2 2 (2.74%) Web Services
2 2 (2.74%) XML
3 1 (1.37%) .NET Framework
3 1 (1.37%) COM
3 1 (1.37%) J2EE
3 1 (1.37%) JSON
Miscellaneous
1 8 (10.96%) Analytical Skills
2 6 (8.22%) Driving Licence
3 5 (6.85%) NHS
4 3 (4.11%) Replication
5 1 (1.37%) Clustering
5 1 (1.37%) CMDB
5 1 (1.37%) Data Structures
5 1 (1.37%) Fintech
5 1 (1.37%) Foreign Exchange (FX)
5 1 (1.37%) Greenfield Project
5 1 (1.37%) Mainframe
5 1 (1.37%) Smart Meter
5 1 (1.37%) VSAM
Operating Systems
1 1 (1.37%) Unix
Processes & Methodologies
1 53 (72.60%) Business Intelligence
2 38 (52.05%) ETL
3 26 (35.62%) Data Analysis
4 17 (23.29%) Agile Software Development
5 14 (19.18%) Data Modelling
5 14 (19.18%) Problem-Solving
6 12 (16.44%) Coaching
7 11 (15.07%) Analytics
8 10 (13.70%) Configuration Management
9 8 (10.96%) Data Analytics
9 8 (10.96%) Decision-Making
9 8 (10.96%) DevOps
9 8 (10.96%) Performance Tuning
9 8 (10.96%) Presales
10 7 (9.59%) Data Management
11 6 (8.22%) High Availability
11 6 (8.22%) Visualisation
12 5 (6.85%) Analytical Thinking
12 5 (6.85%) Dimensional Modelling
12 5 (6.85%) Project Management
Programming Languages
1 53 (72.60%) SQL
2 30 (41.10%) T-SQL
3 5 (6.85%) C#
4 4 (5.48%) PowerShell
5 2 (2.74%) VBA
6 1 (1.37%) COBOL
6 1 (1.37%) Data Analysis Expressions (DAX)
6 1 (1.37%) Java
6 1 (1.37%) JCL
6 1 (1.37%) REXX
Qualifications
1 4 (5.48%) Degree
2 1 (1.37%) Microsoft Certification
Quality Assurance & Compliance
1 3 (4.11%) Data Quality
2 2 (2.74%) QA
3 1 (1.37%) GDPR
Systems Management
1 8 (10.96%) Ansible
1 8 (10.96%) Opscode Chef
1 8 (10.96%) Puppet
2 2 (2.74%) HP ALM
2 2 (2.74%) Mesos
3 1 (1.37%) HP Quality Center
Vendors
1 20 (27.40%) Microsoft
2 6 (8.22%) SAP
3 4 (5.48%) Oracle
3 4 (5.48%) Tableau
4 3 (4.11%) Cognos
4 3 (4.11%) HP
5 2 (2.74%) Google
5 2 (2.74%) Hyperion
6 1 (1.37%) Ab Initio
6 1 (1.37%) CA Agile Central
6 1 (1.37%) Informatica
6 1 (1.37%) ServiceNow