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

Location
3 months to
29 Aug 2014
Same period 2013 Same period 2012
Dimensional Modeling
Rank 158 178 176
Rank change year-on-year
+20 -2
Permanent jobs citing Dimensional Modelling 55 24 18
As % of all permanent IT jobs located in the West Midlands 1.01% 0.44% 0.37%
As % of the Processes & Methodologies category 1.32% 0.57% 0.50%
Number of salaries quoted 19 24 2
Average salary £55,000 £55,000 £32,500
Average salary % change year-on-year
- +69.23%
UK excluding London average salary £48,000 £42,500 £50,000
% change year-on-year
+12.94% -15.00%
Dimensional Modelling
England

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the West Midlands region.

Processes & Methodologies Category
West Midlands
Permanent IT job ads with a match in the
Processes & Methodologies category
4179 4222 3575
As % of all permanent IT jobs located in the West Midlands 76.64% 77.37% 74.37%
Number of salaries quoted 3460 3577 3018
Average salary £41,500 £40,000 £40,000
Average salary % change year-on-year
+3.75% -
90% offered a salary of more than £28,000 £26,500 £27,500
10% offered a salary of more than £66,500 £65,000 £60,000
UK excluding London average salary £42,500 £41,000 £40,000
% change year-on-year
+3.65% +2.50%

Dimensional Modelling
Jobs Demand Trend in the West Midlands

This chart provides a 3-month moving total of permanent IT jobs citing Dimensional Modelling across the West Midlands region as a proportion of the total demand within the Processes & Methodologies category.

Dimensional Modelling Jobs Demand Trend in the West Midlands

Dimensional Modelling
Salary Trend in the West Midlands

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Dimensional Modelling across the West Midlands region.

Dimensional Modelling Salary Trend in the West Midlands

Dimensional Modelling
Salary Histogram in the West Midlands

This chart provides a salary histogram for IT jobs citing Dimensional Modelling across the West Midlands region over the 3 months to 29 August 2014.

Dimensional Modelling Salary Histogram in the West Midlands

Dimensional Modelling
Job Locations in the West Midlands

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Dimensional Modelling within the West Midlands region over the 3 months to 29 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
Staffordshire +19 40 £60,000 +79.10%
Warwickshire - 7 £38,500 -
Birmingham -3 5 £48,750 -35.00%
Solihull - 2 - -
Dimensional Modelling
England

Dimensional Modelling
Top 30 Related IT Skills in the West Midlands

For the 6 months to 29 August 2014, IT jobs across the West Midlands region citing Dimensional Modelling 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 Dimensional Modelling.

1 77 (77.00%) Data Warehouse
2 54 (54.00%) SQL
3 51 (51.00%) Business Intelligence
4 38 (38.00%) SQL Server
5 33 (33.00%) ETL
6 25 (25.00%) Kimball Methodology
7 22 (22.00%) Cognos Business Intelligence
7 22 (22.00%) T-SQL
7 22 (22.00%) Cognos
8 20 (20.00%) Finance
9 19 (19.00%) SQL Server Reporting Services
9 19 (19.00%) SQL Server Integration Services
10 15 (15.00%) Oracle
10 15 (15.00%) Inmon Methodology
11 13 (13.00%) Data Analysis
11 13 (13.00%) MS Excel
11 13 (13.00%) Management Information System
12 12 (12.00%) CRM
13 9 (9.00%) SQL Server Analysis Services
13 9 (9.00%) Data Management
13 9 (9.00%) UNIX
13 9 (9.00%) Microsoft
13 9 (9.00%) Shell Script
14 7 (7.00%) Informatica
14 7 (7.00%) Data Security
14 7 (7.00%) E-Commerce
14 7 (7.00%) Parallel Processing
14 7 (7.00%) Cognos Framework Manager
15 6 (6.00%) Cognos Report Studio
15 6 (6.00%) Change Control

Dimensional Modelling
Top Related IT Skills in the West Midlands by Category

For the 6 months to 29 August 2014, IT jobs across the West Midlands region citing Dimensional Modelling 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 Dimensional Modelling. Up to 20 skills are shown per category.

Application Platforms
1 6 (6.00%) SharePoint
1 6 (6.00%) SharePoint 2010
Applications
1 13 (13.00%) MS Excel
Business Applications
1 22 (22.00%) Cognos Business Intelligence
2 6 (6.00%) Cognos TM1
3 2 (2.00%) Oracle EBS
3 2 (2.00%) HFM
Database & Business Intelligence
1 77 (77.00%) Data Warehouse
2 38 (38.00%) SQL Server
3 19 (19.00%) SQL Server Reporting Services
3 19 (19.00%) SQL Server Integration Services
4 9 (9.00%) SQL Server Analysis Services
5 7 (7.00%) Cognos Framework Manager
6 6 (6.00%) Cognos Report Studio
6 6 (6.00%) Data Mart
6 6 (6.00%) SQL Server 2005
6 6 (6.00%) SQL Server 2008
7 5 (5.00%) Oracle BI EE
8 3 (3.00%) OLAP
8 3 (3.00%) Oracle BI Publisher
9 2 (2.00%) Oracle ODI
9 2 (2.00%) DB2
9 2 (2.00%) Essbase
10 1 (1.00%) Microsoft Analysis Services
10 1 (1.00%) Data Mining
10 1 (1.00%) RDBMS
10 1 (1.00%) ROLAP
Development Applications
1 1 (1.00%) ERwin
General
1 20 (20.00%) Finance
2 2 (2.00%) Retail
2 2 (2.00%) Telecoms
Job Titles
1 34 (34.00%) Developer
2 18 (18.00%) Business Intelligence Developer
2 18 (18.00%) MIS Manager
3 16 (16.00%) Team Leader
4 15 (15.00%) Data Warehouse Manager
4 15 (15.00%) Data Manager
5 13 (13.00%) MI Manager
6 11 (11.00%) SQL Developer
7 10 (10.00%) Cognos Developer
8 8 (8.00%) Business Developer
9 7 (7.00%) Senior Developer
9 7 (7.00%) SQL Server Developer
9 7 (7.00%) Cognos BI Developer
10 6 (6.00%) Consultant
10 6 (6.00%) Business Intelligence Consultant
11 4 (4.00%) Database Developer
11 4 (4.00%) SQL Database Developer
12 3 (3.00%) Oracle BI Developer
12 3 (3.00%) Development Team Leader
12 3 (3.00%) OBIEE Developer
Libraries, Frameworks & Software Standards
1 3 (3.00%) XML
1 3 (3.00%) XSLT
2 1 (1.00%) MDX
2 1 (1.00%) .NET
Miscellaneous
1 13 (13.00%) Management Information System
2 1 (1.00%) Clustering
Operating Systems
1 9 (9.00%) UNIX
2 4 (4.00%) Linux
Processes & Methodologies
1 51 (51.00%) Business Intelligence
2 33 (33.00%) ETL
3 25 (25.00%) Kimball Methodology
4 15 (15.00%) Inmon Methodology
5 13 (13.00%) Data Analysis
6 12 (12.00%) CRM
7 9 (9.00%) Data Management
8 7 (7.00%) Parallel Processing
8 7 (7.00%) E-Commerce
8 7 (7.00%) Data Security
9 6 (6.00%) Change Control
10 5 (5.00%) Scrum
10 5 (5.00%) Project Management
11 2 (2.00%) Data Modelling
11 2 (2.00%) RAD
12 1 (1.00%) Stakeholder Management
12 1 (1.00%) Agile Software Development
12 1 (1.00%) Business Analysis
12 1 (1.00%) Enterprise Data Management
12 1 (1.00%) MapReduce
Programming Languages
1 54 (54.00%) SQL
2 22 (22.00%) T-SQL
3 9 (9.00%) Shell Script
4 5 (5.00%) PL/SQL
Qualifications
1 3 (3.00%) Security Cleared
2 1 (1.00%) Degree
2 1 (1.00%) SC Cleared
Vendors
1 22 (22.00%) Cognos
2 15 (15.00%) Oracle
3 9 (9.00%) Microsoft
4 7 (7.00%) Informatica
5 6 (6.00%) IBM
5 6 (6.00%) Teradata
6 2 (2.00%) Netezza
6 2 (2.00%) Fujitsu
6 2 (2.00%) Business Objects
6 2 (2.00%) Hyperion
7 1 (1.00%) Ab Initio
7 1 (1.00%) Greenplum
7 1 (1.00%) Vertica
7 1 (1.00%) Kalido