The table below looks at the statistics for Data Warehouse skills in IT contracts advertised for the Lancashire region. Included is a guide to the average contractor rates offered in IT contracts that have cited Data Warehouse over the 3 months to 13 February 2016 with a comparison to the same period in the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

Location
3 months to
13 Feb 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 39 21 26
Rank change year-on-year
-18 +5
Contract jobs citing Data Warehouse 9 25 7
As % of all contract IT jobs located in Lancashire 2.28% 5.88% 2.83%
As % of the Database & Business Intelligence category 8.11% 18.80% 14.29%
Number of daily rates quoted 7 18 7
Average daily rate £500 £400 £275
Average daily rate % change year-on-year
+25.00% +45.45%
90% offered a daily rate of more than £450 £300 £188
10% offered a daily rate of more than £670 £549 £335
UK excluding London average daily rate £400 £400 £400
Number of hourly rates quoted 1 1 0
Average hourly rate £62.50 £70.00 -
Average hourly rate % change year-on-year
-10.71% -
UK excluding London average hourly rate £62.50 £36.00 £31.50
% change year-on-year
+73.61% +14.28%
Data Warehouse
North West

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in contract jobs advertised in the Lancashire region.

Database & Business Intelligence Category
Lancashire
Contract IT job ads with a match in the
Database & Business Intelligence category
111 133 49
As % of all contract IT jobs located in Lancashire 28.10% 31.29% 19.84%
Number of daily rates quoted 83 92 31
Average daily rate £375 £378 £275
Average daily rate % change year-on-year
-0.66% +37.27%
90% offered a daily rate of more than £210 £200 £200
10% offered a daily rate of more than £500 £500 £425
UK excluding London average daily rate £375 £373 £350
% change year-on-year
+0.67% +6.42%
Number of hourly rates quoted 20 4 0
Average hourly rate £41.50 £37.00 -
Average hourly rate % change year-on-year
+12.16% -
UK excluding London average hourly rate £32.50 £32.50 £29.00
% change year-on-year
- +12.06%

Data Warehouse
Jobs Demand Trend in Lancashire

This chart provides a 3-month moving total of IT contractor jobs citing Data Warehouse across the Lancashire region as a proportion of the total demand within the Database & Business Intelligence category.

Data Warehouse Jobs Demand Trend in Lancashire

Data Warehouse
Daily Rate Trend in Lancashire

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Data Warehouse across the Lancashire region.

Data Warehouse Daily Rate Trend in Lancashire

Data Warehouse
Daily Rate Histogram in Lancashire

This chart provides a histogram of daily rates quoted in contract IT jobs citing Data Warehouse across the Lancashire region over the 3 months to 13 February 2016.

Data Warehouse Daily Rate Histogram in Lancashire

Data Warehouse
Hourly Rate Trend in Lancashire

This chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing Data Warehouse across the Lancashire region.

Data Warehouse Hourly Rate Trend in Lancashire

Data Warehouse
Contract Job Locations in Lancashire

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing Data Warehouse within the Lancashire region over the 3 months to 13 February 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Average
Daily Rate
Last 3 Months
Average Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Blackpool -8 6 £475 -11.62%
Preston -5 1 - - 1
Lancaster - 1 £500 -
Data Warehouse
North West

Data Warehouse
Top 30 Related IT Skills in Lancashire

For the 6 months to 13 February 2016, IT contractor jobs across the Lancashire region citing Data Warehouse also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Data Warehouse.

1 22 (57.89%) SQL
2 21 (55.26%) SQL Server
3 20 (52.63%) T-SQL
4 19 (50.00%) Business Intelligence
4 19 (50.00%) SQL Server Reporting Services
4 19 (50.00%) SQL Server Integration Services
5 17 (44.74%) Security Cleared
6 16 (42.11%) Data Modelling
7 15 (39.47%) SC Cleared
7 15 (39.47%) SQL Server Analysis Services
8 14 (36.84%) OLAP
9 13 (34.21%) Kimball Methodology
9 13 (34.21%) OLAP Cube
10 12 (31.58%) SQL Server 2008
11 11 (28.95%) Dimensional Modelling
11 11 (28.95%) Team Foundation Server
11 11 (28.95%) Performance Analysis
11 11 (28.95%) SQL Server 2005
12 10 (26.32%) Visual Studio
12 10 (26.32%) SQL Server Management Studio (SSMS)
13 9 (23.68%) OLTP
14 8 (21.05%) Oracle
15 7 (18.42%) ETL
15 7 (18.42%) Data Analysis
16 5 (13.16%) Statistics
16 5 (13.16%) Informatica
16 5 (13.16%) Microsoft
16 5 (13.16%) PL/SQL
17 4 (10.53%) JavaScript
17 4 (10.53%) C++

Data Warehouse
Top Related IT Skills in Lancashire by Category

For the 6 months to 13 February 2016, IT contractor jobs across the Lancashire region citing Data Warehouse also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Data Warehouse. Up to 20 skills are shown per category.

Application Platforms
1 3 (7.89%) Node.js
2 2 (5.26%) SharePoint
3 1 (2.63%) SAS
Business Applications
1 1 (2.63%) Cognos Business Intelligence
1 1 (2.63%) Cognos TM1
Cloud Services
1 4 (10.53%) Cloud Computing
2 3 (7.89%) Amazon AWS
2 3 (7.89%) IaaS
Communications & Networking
1 3 (7.89%) Internet
Database & Business Intelligence
1 21 (55.26%) SQL Server
2 19 (50.00%) SQL Server Integration Services
2 19 (50.00%) SQL Server Reporting Services
3 15 (39.47%) SQL Server Analysis Services
4 14 (36.84%) OLAP
5 13 (34.21%) OLAP Cube
6 12 (31.58%) SQL Server 2008
7 11 (28.95%) SQL Server 2005
8 9 (23.68%) OLTP
9 4 (10.53%) Big Data
10 3 (7.89%) Apache Cassandra
10 3 (7.89%) GIS
10 3 (7.89%) Hadoop
10 3 (7.89%) MongoDB
11 2 (5.26%) BusinessObjects
12 1 (2.63%) Base SAS
12 1 (2.63%) Relational Database
12 1 (2.63%) SAS Data Integration Studio
12 1 (2.63%) SAS Enterprise Guide
12 1 (2.63%) SQL Server 2012
Development Applications
1 11 (28.95%) Team Foundation Server
2 10 (26.32%) SQL Server Management Studio (SSMS)
2 10 (26.32%) Visual Studio
3 4 (10.53%) ERwin
General
1 1 (2.63%) Back Office
Job Titles
1 25 (65.79%) Developer
2 15 (39.47%) Business Intelligence Developer
3 7 (18.42%) Analyst
3 7 (18.42%) Business Analyst
3 7 (18.42%) Business Developer
4 5 (13.16%) Architect
4 5 (13.16%) ETL Developer
5 4 (10.53%) SQL Developer
5 4 (10.53%) Technical Architect
6 3 (7.89%) Data Business Analyst
7 2 (5.26%) Database Developer
7 2 (5.26%) DBA
7 2 (5.26%) NHS BI Developer
7 2 (5.26%) SQL BI Developer
7 2 (5.26%) SQL DBA
7 2 (5.26%) SQL Server Developer
8 1 (2.63%) .NET Developer
8 1 (2.63%) Informatica Developer
8 1 (2.63%) SAS Developer
8 1 (2.63%) Senior Technical Architect
Libraries, Frameworks & Software Standards
1 4 (10.53%) .NET
1 4 (10.53%) Velocity
2 3 (7.89%) AngularJS
2 3 (7.89%) Twitter Bootstrap
3 2 (5.26%) .NET Framework
4 1 (2.63%) Web Services
Miscellaneous
1 5 (13.16%) Statistics
2 4 (10.53%) Algorithms
2 4 (10.53%) Analytical Skills
3 3 (7.89%) Visualisation
4 2 (5.26%) NHS
5 1 (2.63%) Data Extraction
5 1 (2.63%) Management Information System
5 1 (2.63%) Replication
5 1 (2.63%) Social Media
5 1 (2.63%) User Experience
Operating Systems
1 4 (10.53%) Unix
2 3 (7.89%) Linux
Processes & Methodologies
1 19 (50.00%) Business Intelligence
2 16 (42.11%) Data Modelling
3 13 (34.21%) Kimball Methodology
4 11 (28.95%) Dimensional Modelling
4 11 (28.95%) Performance Analysis
5 7 (18.42%) Data Analysis
5 7 (18.42%) ETL
6 4 (10.53%) Data Management
6 4 (10.53%) Data Security
6 4 (10.53%) Unit Testing
7 3 (7.89%) GAP Analysis
7 3 (7.89%) Machine Learning
7 3 (7.89%) Web Accessibility
8 2 (5.26%) Agile Software Development
9 1 (2.63%) Analytics
9 1 (2.63%) Data Architecture
9 1 (2.63%) Database Tuning
9 1 (2.63%) Inmon Methodology
9 1 (2.63%) Migration
9 1 (2.63%) SDLC
Programming Languages
1 22 (57.89%) SQL
2 20 (52.63%) T-SQL
3 5 (13.16%) PL/SQL
4 4 (10.53%) C++
4 4 (10.53%) JavaScript
5 3 (7.89%) Java
5 3 (7.89%) Python
5 3 (7.89%) R
Qualifications
1 17 (44.74%) Security Cleared
2 15 (39.47%) SC Cleared
3 1 (2.63%) BPSS Clearance
3 1 (2.63%) SAS Certification
Quality Assurance & Compliance
1 1 (2.63%) Disclosure Scotland
Systems Management
1 3 (7.89%) Opscode Chef
1 3 (7.89%) StatsD
Vendors
1 8 (21.05%) Oracle
2 5 (13.16%) Informatica
2 5 (13.16%) Microsoft
3 3 (7.89%) Apigee
3 3 (7.89%) Citrix
3 3 (7.89%) Mashery
3 3 (7.89%) Tableau
3 3 (7.89%) Teradata
4 1 (2.63%) Cognos