The first table below looks at the demand for Dimensional Modelling skills in IT jobs advertised for the Hertfordshire region. Included is a guide to the average salaries offered in IT jobs that have cited Dimensional Modelling over the 3 months to 23 May 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Processes & Methodologies category for the Hertfordshire region.

Location
3 months to
23 May 2013
Same period 2012 Same period 2011
Dimensional Modeling
Rank 100 133 166
Rank change year-on-year
+33 +33
Permanent jobs citing Dimensional Modelling 42 12 1
As % of all permanent IT jobs located in Hertfordshire 1.718% 0.474% 0.029%
As % of the Processes & Methodologies category 2.242% 0.648% 0.038%
Number of salaries quoted 10 3 1
Average salary £75,000 £40,000 £60,000
Average salary % change year-on-year
+87.50% -33.33%
UK excluding London average salary £43,000 £47,500 £52,500
% change year-on-year
-9.47% -9.52%
All Processes & Methodologies
Hertfordshire
Permanent IT job ads with a match in the
Processes & Methodologies category
1873 1851 2620
As % of all permanent IT jobs located in Hertfordshire 76.61% 73.08% 76.70%
Number of salaries quoted 1483 1493 2116
Average salary £45,000 £47,500 £45,000
Average salary % change year-on-year
-5.26% +5.55%
90% offered a salary of more than £31,500 £31,500 £32,500
10% offered a salary of more than £65,000 £67,500 £65,000
UK excluding London average salary £40,000 £41,000 £40,000
% change year-on-year
-2.43% +2.50%
Dimensional Modelling
East of England

Dimensional Modelling
Jobs Demand Trend

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

Hertfordshire Dimensional Modelling Jobs Demand Trend

Dimensional Modelling
Salary Trend

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

Hertfordshire Dimensional Modelling Salary Trend

Dimensional Modelling
Salary Histogram

This chart provides a salary histogram for IT jobs citing Dimensional Modelling across the Hertfordshire region over the 3 months to 23 May 2013.

Hertfordshire Dimensional Modelling Salary Histogram

Dimensional Modelling
Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Dimensional Modelling within the Hertfordshire region over the 3 months to 23 May 2013. 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
(Click each for more statistics)
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
St Albans +21 34 £36,250 -
Dimensional Modelling
East of England

Dimensional Modelling
Top 30 Related IT Skills

For the 6 months to 23 May 2013, IT jobs across the Hertfordshire 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 53 (76.81%) Business Intelligence
2 44 (63.77%) SQL Server
3 41 (59.42%) SQL Server Reporting Services
3 41 (59.42%) SQL Server Analysis Services
4 39 (56.52%) SQL
5 33 (47.83%) Microsoft
6 32 (46.38%) T-SQL
7 31 (44.93%) MDX
7 31 (44.93%) Marketing
7 31 (44.93%) PowerPivot
8 30 (43.48%) Broadband
9 28 (40.58%) ETL
10 27 (39.13%) OLAP
10 27 (39.13%) Microsoft Analysis Services
11 26 (37.68%) SharePoint
12 24 (34.78%) Unit Testing
13 23 (33.33%) MS Excel
14 21 (30.43%) Data Warehouse
15 17 (24.64%) Oracle
15 17 (24.64%) SQL Server 2005
15 17 (24.64%) SQL Server 2008
16 16 (23.19%) PerformancePoint
16 16 (23.19%) Validation
17 15 (21.74%) Data Modelling
18 14 (20.29%) RDBMS
19 13 (18.84%) Shell Script
19 13 (18.84%) UNIX
19 13 (18.84%) Linux
19 13 (18.84%) Ab Initio
19 13 (18.84%) Korn

Dimensional Modelling
Top Related IT Skills by Category

For the 6 months to 23 May 2013, IT jobs across the Hertfordshire 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 Development
1 31 (44.93%) MDX
2 3 (4.348%) .NET
2 3 (4.348%) ASP.NET
2 3 (4.348%) XML
Application Platforms
1 26 (37.68%) SharePoint
Applications
1 31 (44.93%) PowerPivot
2 23 (33.33%) MS Excel
3 7 (10.14%) MS Visio
4 5 (7.246%) MS PowerPoint
Business Applications
1 9 (13.04%) Oracle EBS
2 6 (8.696%) HFM
Communications & Networking
1 30 (43.48%) Broadband
Database & Business Intelligence
1 44 (63.77%) SQL Server
2 41 (59.42%) SQL Server Reporting Services
2 41 (59.42%) SQL Server Analysis Services
3 27 (39.13%) OLAP
3 27 (39.13%) Microsoft Analysis Services
4 21 (30.43%) Data Warehouse
5 17 (24.64%) SQL Server 2005
5 17 (24.64%) SQL Server 2008
6 16 (23.19%) PerformancePoint
7 14 (20.29%) RDBMS
8 10 (14.49%) SQL Server Integration Services
9 9 (13.04%) Oracle 11g
9 9 (13.04%) Oracle BI EE
10 5 (7.246%) DB2
11 3 (4.348%) Oracle OLAP
11 3 (4.348%) DTS
11 3 (4.348%) SQL Server 2012
11 3 (4.348%) NoSQL
12 2 (2.899%) SAP BW
12 2 (2.899%) BusinessObjects
General
1 31 (44.93%) Marketing
2 4 (5.797%) Finance
3 2 (2.899%) Advertising
4 1 (1.449%) Games
Job Titles
1 47 (68.12%) Developer
2 31 (44.93%) Business Intelligence Developer
3 25 (36.23%) Microsoft Developer
4 17 (24.64%) Report Developer
5 7 (10.14%) Microsoft Solutions Architect
5 7 (10.14%) Architect
5 7 (10.14%) Consultant
5 7 (10.14%) Business Intelligence Consultant
5 7 (10.14%) Solutions Architect
5 7 (10.14%) Business Consultant
5 7 (10.14%) Ab Initio Developer
6 6 (8.696%) Oracle Consultant
6 6 (8.696%) Oracle BI Consultant
7 4 (5.797%) Business Intelligence Specialist
7 4 (5.797%) Senior Business Intelligence Specialist
8 3 (4.348%) SQL Developer
9 1 (1.449%) Senior Business Consultant
9 1 (1.449%) Senior Business Intelligence Consultant
9 1 (1.449%) Senior Consultant
9 1 (1.449%) Business Objects Specialist
Miscellaneous
1 10 (14.49%) Data Integration
2 5 (7.246%) Enterprise Software
3 3 (4.348%) Mathematics
3 3 (4.348%) Physics
3 3 (4.348%) Computer Science
3 3 (4.348%) SaaS
4 2 (2.899%) FMCG
5 1 (1.449%) Management Information System
Operating Systems
1 13 (18.84%) UNIX
1 13 (18.84%) Linux
Processes & Methodologies
1 53 (76.81%) Business Intelligence
2 28 (40.58%) ETL
3 24 (34.78%) Unit Testing
4 16 (23.19%) Validation
5 15 (21.74%) Data Modelling
6 13 (18.84%) System Testing
6 13 (18.84%) User Acceptance Testing
7 6 (8.696%) Risk Assessment
7 6 (8.696%) Kimball Methodology
7 6 (8.696%) Inmon Methodology
8 3 (4.348%) Software Engineering
8 3 (4.348%) Data Transformation
8 3 (4.348%) Analytics
9 1 (1.449%) Information Management
9 1 (1.449%) Continuous Improvement
Programming Languages
1 39 (56.52%) SQL
2 32 (46.38%) T-SQL
3 13 (18.84%) Shell Script
3 13 (18.84%) Korn
3 13 (18.84%) Bash shell
4 3 (4.348%) C#
4 3 (4.348%) JavaScript
4 3 (4.348%) PHP
4 3 (4.348%) VB
4 3 (4.348%) ABAP
Qualifications
1 10 (14.49%) Degree
2 6 (8.696%) Security Cleared
Quality Assurance & Compliance
1 1 (1.449%) SLA
Vendors
1 33 (47.83%) Microsoft
2 17 (24.64%) Oracle
3 13 (18.84%) Ab Initio
4 9 (13.04%) Informatica
5 6 (8.696%) Business Objects
6 5 (7.246%) SAP
Hertfordshire
You must be familiar with the Microsoft Business Intelligence stack, and have experience of using it in an operational environment and be proficient with SSMS, T-SQL, BIDS (...
PNG Recruitment Solutions
Salary: £35,000 per annum
Posted: 17 May 2013
Hertfordshire, South East
Job Title - Microsoft Solution ArchitectLocation - St AlbansWe are currently looking for a Microsoft Solution Architect to join our Change & Delivery team in St Albans. The role will take...
SkyIQ
Posted: 23 May 2013
Hertfordshire
Strong knowledge of SSAS / SSIS / SSRS / SQL Server / Sharepoint is essential, and knowledge of Powerpivot will be an advantage Must demonstrate excellent written and verbal communication... Preferably educated...
Sky
Posted: 15 May 2013