The table below looks at the statistics for Data Warehouse skills in IT jobs advertised for the Staffordshire region. Included is a guide to the average salaries offered in IT jobs that have cited Data Warehouse over the 3 months to 27 August 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
27 Aug 2014
Same period 2013 Same period 2012
Data Warehousing
Rank 22 49 28
Rank change year-on-year
+27 -21
Permanent jobs citing Data Warehouse 72 21 31
As % of all permanent IT jobs located in Staffordshire 10.18% 3.10% 5.98%
As % of the Database & Business Intelligence category 18.14% 6.82% 12.86%
Number of salaries quoted 38 18 29
Average salary £48,750 £37,500 £42,500
Average salary % change year-on-year
+30.00% -11.76%
90% offered a salary of more than £32,500 £32,500 £37,500
10% offered a salary of more than £70,000 £45,000 £45,000
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -
Data Warehouse
West Midlands

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

Database & Business Intelligence Category
Staffordshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
397 308 241
As % of all permanent IT jobs located in Staffordshire 56.15% 45.49% 46.53%
Number of salaries quoted 294 269 211
Average salary £35,000 £36,000 £40,000
Average salary % change year-on-year
-2.77% -10.00%
90% offered a salary of more than £27,500 £22,500 £27,500
10% offered a salary of more than £47,500 £55,000 £52,500
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%

Data Warehouse
Jobs Demand Trend in Staffordshire

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

Data Warehouse Jobs Demand Trend in Staffordshire

Data Warehouse
Salary Trend in Staffordshire

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

Data Warehouse Salary Trend in Staffordshire

Data Warehouse
Salary Histogram in Staffordshire

This chart provides a salary histogram for IT jobs citing Data Warehouse across the Staffordshire region over the 3 months to 27 August 2014.

Data Warehouse Salary Histogram in Staffordshire

Data Warehouse
Job Locations in Staffordshire

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Data Warehouse within the Staffordshire region over the 3 months to 27 August 2014. 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
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Stoke-on-Trent - 34 £55,000 -
Burton-upon-Trent -9 5 £40,000 -11.11%
Stafford - 3 £32,500 -
Cannock -4 1 £39,500 +49.05%
Lichfield -6 1 - - 1
Data Warehouse
West Midlands

Data Warehouse
Top 30 Related IT Skills in Staffordshire

For the 6 months to 27 August 2014, IT jobs across the Staffordshire 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 IT job ads sampled that cited Data Warehouse.

1 88 (69.84%) SQL
2 67 (53.17%) SQL Server
3 63 (50.00%) Business Intelligence
4 40 (31.75%) ETL
5 36 (28.57%) OLAP
6 34 (26.98%) Dimensional Modelling
7 28 (22.22%) SQL Server Integration Services
8 26 (20.63%) SQL Server Reporting Services
9 24 (19.05%) Data Modelling
10 22 (17.46%) Microsoft
11 21 (16.67%) T-SQL
12 20 (15.87%) MicroStrategy
13 16 (12.70%) MS Excel
14 14 (11.11%) SQL Server Analysis Services
15 13 (10.32%) Project Management
16 12 (9.52%) Shell Script
16 12 (9.52%) UNIX
16 12 (9.52%) Data Architecture
17 11 (8.73%) Degree
17 11 (8.73%) ITIL
17 11 (8.73%) Database Security
18 10 (7.94%) Disaster Recovery
18 10 (7.94%) ITIL Certification
18 10 (7.94%) CRM
18 10 (7.94%) DTS
18 10 (7.94%) MDX
18 10 (7.94%) SQL Server 2008
19 9 (7.14%) Change Management
20 8 (6.35%) Data Analysis
20 8 (6.35%) .NET

Data Warehouse
Top Related IT Skills in Staffordshire by Category

For the 6 months to 27 August 2014, IT jobs across the Staffordshire 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 IT job ads sampled that cited Data Warehouse. Up to 20 skills are shown per category.

Application Platforms
1 4 (3.17%) SharePoint
1 4 (3.17%) SharePoint Server
Applications
1 16 (12.70%) MS Excel
2 7 (5.56%) S-PLUS
3 4 (3.17%) MS Office
Business Applications
1 4 (3.17%) Dynamics CRM
1 4 (3.17%) Line 500
Database & Business Intelligence
1 67 (53.17%) SQL Server
2 36 (28.57%) OLAP
3 28 (22.22%) SQL Server Integration Services
4 26 (20.63%) SQL Server Reporting Services
5 14 (11.11%) SQL Server Analysis Services
6 10 (7.94%) DTS
6 10 (7.94%) SQL Server 2008
7 8 (6.35%) Big Data
8 5 (3.97%) QlikView
8 5 (3.97%) Microsoft Analysis Services
9 4 (3.17%) SQL Server 2005
9 4 (3.17%) Data Mining
10 3 (2.38%) OLTP
11 2 (1.59%) DB2
11 2 (1.59%) SQL Server 2012
12 1 (0.79%) Oracle ODI
12 1 (0.79%) Oracle Reports
12 1 (0.79%) MS Access
12 1 (0.79%) ROLAP
12 1 (0.79%) Star Schema
Development Applications
1 4 (3.17%) Visual Studio
1 4 (3.17%) Visual Studio Team System
General
1 6 (4.76%) Finance
2 4 (3.17%) Billing
3 1 (0.79%) Pharmaceutical
3 1 (0.79%) Retail
Job Titles
1 36 (28.57%) Team Leader
2 30 (23.81%) Developer
3 20 (15.87%) Data Manager
3 20 (15.87%) Data Warehouse Manager
4 18 (14.29%) MIS Manager
5 15 (11.90%) Analyst
6 14 (11.11%) Business Analyst
7 12 (9.52%) Senior Developer
8 11 (8.73%) Senior Business Analyst
8 11 (8.73%) DBA
8 11 (8.73%) Business Intelligence Analyst
8 11 (8.73%) Senior Analyst
8 11 (8.73%) SQL DBA
9 10 (7.94%) SQL Server DBA
9 10 (7.94%) Business Intelligence Developer
10 9 (7.14%) Senior Business Intelligence Analyst
10 9 (7.14%) SQL Developer
11 8 (6.35%) Business Developer
12 7 (5.56%) Lead Developer
13 6 (4.76%) Development Team Leader
Libraries, Frameworks & Software Standards
1 10 (7.94%) MDX
2 8 (6.35%) .NET
3 4 (3.17%) ASP.NET
3 4 (3.17%) XML
3 4 (3.17%) HTML
4 1 (0.79%) .NET Framework
Miscellaneous
1 2 (1.59%) Management Information System
2 1 (0.79%) Data Integration
2 1 (0.79%) NHS
Operating Systems
1 12 (9.52%) UNIX
2 6 (4.76%) Linux
Processes & Methodologies
1 63 (50.00%) Business Intelligence
2 40 (31.75%) ETL
3 34 (26.98%) Dimensional Modelling
4 24 (19.05%) Data Modelling
5 13 (10.32%) Project Management
6 12 (9.52%) Data Architecture
7 11 (8.73%) Database Security
7 11 (8.73%) ITIL
8 10 (7.94%) CRM
8 10 (7.94%) Disaster Recovery
9 9 (7.14%) Change Management
10 8 (6.35%) Data Analysis
11 7 (5.56%) Parallel Processing
11 7 (5.56%) Kimball Methodology
12 5 (3.97%) Migration
12 5 (3.97%) Scrum
12 5 (3.97%) E-Commerce
13 4 (3.17%) Multidimensional Analysis
13 4 (3.17%) Business Analysis
14 3 (2.38%) Continuous Improvement
Programming Languages
1 88 (69.84%) SQL
2 21 (16.67%) T-SQL
3 12 (9.52%) Shell Script
4 4 (3.17%) VBA
4 4 (3.17%) JavaScript
5 3 (2.38%) PL/SQL
6 1 (0.79%) VB.NET
Qualifications
1 11 (8.73%) Degree
2 10 (7.94%) ITIL Certification
Quality Assurance & Compliance
1 1 (0.79%) ISO/IEC 27001
Vendors
1 22 (17.46%) Microsoft
2 20 (15.87%) MicroStrategy
3 6 (4.76%) Teradata
4 5 (3.97%) Oracle
5 4 (3.17%) Sage
5 4 (3.17%) Logi Analytics
6 2 (1.59%) Cognos
7 1 (0.79%) Vertica
7 1 (0.79%) Netezza
7 1 (0.79%) Greenplum
7 1 (0.79%) Business Objects
7 1 (0.79%) Informatica