Period
to 18 September 2018

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

Data Warehousing
North West > Lancashire
6 months to
18 Sep 2018
Same period 2017 Same period 2016
Rank 32 60 75
Rank change year-on-year +28 +15 -16
Permanent jobs citing Data Warehouse 42 26 9
As % of all permanent IT jobs advertised in Lancashire 5.32% 2.99% 1.07%
As % of the Database & Business Intelligence category 16.41% 7.26% 3.00%
Number of salaries quoted 39 12 9
Lancashire median annual salary £42,000 £40,000 £40,000
Median salary % change year-on-year +5.00% - +29.16%
10th Percentile £31,250 £36,375 £33,250
90th Percentile £80,250 £51,250 £42,500
North West median annual salary £45,000 £40,000 £42,750
% change year-on-year +12.50% -6.43% +6.88%

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

All Database and Business Intelligence Skills
Lancashire
Permanent vacancies with a requirement for database or business intelligence skills 256 358 300
As % of all permanent IT jobs advertised in Lancashire 32.45% 41.20% 35.71%
Number of salaries quoted 236 322 245
Lancashire median annual salary £35,000 £35,000 £35,000
10th Percentile £27,500 £27,500 £23,750
90th Percentile £51,250 £47,500 £43,750
North West median annual salary £43,500 £40,000 £40,000
% change year-on-year +8.75% - -

Data Warehouse
Job Vacancy Trend in Lancashire

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

Job vacancy trend for Data Warehouse in Lancashire

Data Warehouse
Salary Trend in Lancashire

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

Salary trend for Data Warehouse in Lancashire

Data Warehouse
Salary Histogram in Lancashire

The salary distribution of IT jobs citing Data Warehouse in Lancashire over the 6 months to 18 September 2018.

Salary histogram for Data Warehouse in Lancashire

Data Warehouse
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Lancashire region over the 6 months to 18 September 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
Preston +27 15 £40,000 +14.29% 3
Blackburn +2 4 £42,500 -10.53%
Chorley -1 1 £50,000 +25.00% 1
Blackpool -10 1 - -
Data Warehouse
North West

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

1 30 (71.43%) SQL
2 28 (66.67%) SQL Server Integration Services
3 27 (64.29%) SQL Server Reporting Services
4 23 (54.76%) Business Intelligence
5 21 (50.00%) Analytical Skills
6 18 (42.86%) SQL Server
7 17 (40.48%) Data Modelling
8 16 (38.10%) Microsoft
9 14 (33.33%) ETL
10 13 (30.95%) MySQL
11 12 (28.57%) Migration
12 11 (26.19%) Change Management
12 11 (26.19%) OLAP
12 11 (26.19%) Master Data Management
13 10 (23.81%) Data Analysis
13 10 (23.81%) Agile Software Development
13 10 (23.81%) Digital Transformation Programme
14 9 (21.43%) Data Strategy
14 9 (21.43%) Logical Data Model
14 9 (21.43%) Physical Data Model
14 9 (21.43%) Hybrid Cloud
14 9 (21.43%) ERwin
14 9 (21.43%) Data Security
14 9 (21.43%) C
14 9 (21.43%) OLTP
14 9 (21.43%) Data Governance
14 9 (21.43%) Metadata Management
14 9 (21.43%) Data Integration
14 9 (21.43%) Data Architecture
14 9 (21.43%) Information Architecture

Data Warehouse
Co-occurring IT Skills in Lancashire 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:

Applications
1 8 (19.05%) Microsoft Excel
2 3 (7.14%) Microsoft Office
2 3 (7.14%) Microsoft Project
2 3 (7.14%) MS Visio
3 1 (2.38%) Microsoft PowerPoint
Business Applications
1 4 (9.52%) Cognos TM1
2 2 (4.76%) Cognos Business Intelligence
Cloud Services
1 3 (7.14%) Google Analytics
Database & Business Intelligence
1 28 (66.67%) SQL Server Integration Services
2 27 (64.29%) SQL Server Reporting Services
3 18 (42.86%) SQL Server
4 13 (30.95%) MySQL
5 11 (26.19%) OLAP
6 9 (21.43%) OLTP
7 7 (16.67%) BusinessObjects
7 7 (16.67%) SQL Server 2008
7 7 (16.67%) SQL Server 2016
8 6 (14.29%) SQL Server Analysis Services
9 5 (11.90%) Power BI
10 3 (7.14%) MS Access
10 3 (7.14%) QlikView
11 2 (4.76%) Cognos Framework Manager
11 2 (4.76%) Crystal Reports
12 1 (2.38%) OLAP Cube
12 1 (2.38%) Oracle Reports
12 1 (2.38%) PowerPivot
12 1 (2.38%) SQL Server 2012
Development Applications
1 9 (21.43%) ERwin
2 1 (2.38%) Axure RP
General
1 3 (7.14%) Marketing
2 2 (4.76%) Legal
3 1 (2.38%) Advertising
3 1 (2.38%) Billing
3 1 (2.38%) Finance
3 1 (2.38%) Retail
Job Titles
1 21 (50.00%) Developer
2 10 (23.81%) Architect
2 10 (23.81%) Business Intelligence Developer
3 9 (21.43%) Data Architect
3 9 (21.43%) SQL Developer
4 4 (9.52%) Business Developer
5 3 (7.14%) Access Developer
5 3 (7.14%) Access VBA Developer
5 3 (7.14%) Analyst
5 3 (7.14%) Data Analyst
5 3 (7.14%) Excel Developer
5 3 (7.14%) Excel VBA Developer
5 3 (7.14%) Insight Manager
5 3 (7.14%) Microsoft Developer
5 3 (7.14%) Product Manager
5 3 (7.14%) SQL BI Developer
5 3 (7.14%) VBA Developer
6 2 (4.76%) MIS Developer
6 2 (4.76%) SSIS Developer
6 2 (4.76%) Systems Developer
Libraries, Frameworks & Software Standards
1 4 (9.52%) jQuery
2 3 (7.14%) .NET
3 1 (2.38%) MDX
Miscellaneous
1 21 (50.00%) Analytical Skills
2 9 (21.43%) Hybrid Cloud
3 6 (14.29%) Management Information System
4 1 (2.38%) Data Structures
4 1 (2.38%) Self-Motivation
Operating Systems
1 4 (9.52%) Linux
1 4 (9.52%) Windows
Processes & Methodologies
1 23 (54.76%) Business Intelligence
2 17 (40.48%) Data Modelling
3 14 (33.33%) ETL
4 12 (28.57%) Migration
5 11 (26.19%) Change Management
5 11 (26.19%) Master Data Management
6 10 (23.81%) Agile Software Development
6 10 (23.81%) Data Analysis
6 10 (23.81%) Digital Transformation Programme
7 9 (21.43%) Data Architecture
7 9 (21.43%) Data Governance
7 9 (21.43%) Data Integration
7 9 (21.43%) Data Security
7 9 (21.43%) Data Strategy
7 9 (21.43%) Information Architecture
7 9 (21.43%) Logical Data Model
7 9 (21.43%) Metadata Management
7 9 (21.43%) Physical Data Model
8 7 (16.67%) Data Extraction
8 7 (16.67%) Problem-Solving
Programming Languages
1 30 (71.43%) SQL
2 9 (21.43%) C
3 7 (16.67%) T-SQL
4 4 (9.52%) Java
4 4 (9.52%) JavaScript
4 4 (9.52%) PHP
4 4 (9.52%) VBA
5 1 (2.38%) Data Analysis Expressions (DAX)
5 1 (2.38%) PowerShell
Qualifications
1 3 (7.14%) SC Cleared
1 3 (7.14%) Security Cleared
System Software
1 4 (9.52%) Active Directory
Vendors
1 16 (38.10%) Microsoft
2 4 (9.52%) Cisco
2 4 (9.52%) Cognos
2 4 (9.52%) IBM
2 4 (9.52%) VMware
3 3 (7.14%) Google
3 3 (7.14%) Tealeaf
4 2 (4.76%) Tableau
4 2 (4.76%) TIBCO
5 1 (2.38%) Capita
5 1 (2.38%) Oracle
5 1 (2.38%) Sage
5 1 (2.38%) Twitter