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

Location
3 months to
19 Dec 2014
Same period 2013 Same period 2012
Dimensional Modeling
Rank 238 294 303
Rank change year-on-year
+56 +9
Permanent jobs citing Dimensional Modelling 68 43 22
As % of all permanent IT jobs located in the City of London 0.62% 0.36% 0.19%
As % of the Processes & Methodologies category 0.77% 0.44% 0.23%
Number of salaries quoted 61 37 22
Average salary £60,000 £60,000 £52,000
Average salary % change year-on-year
- +15.38%
90% offered a salary of more than £45,000 £55,000 £43,650
10% offered a salary of more than £77,500 £84,000 £65,000
UK excluding London average salary £47,500 £45,000 £42,750
% change year-on-year
+5.55% +5.26%
Dimensional Modelling
London

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

Processes & Methodologies Category
City of London
Permanent IT job ads with a match in the
Processes & Methodologies category
8861 9822 9383
As % of all permanent IT jobs located in the City of London 81.26% 82.89% 80.10%
Number of salaries quoted 7700 8365 8464
Average salary £57,500 £57,500 £55,000
Average salary % change year-on-year
- +4.54%
90% offered a salary of more than £39,000 £37,500 £36,000
10% offered a salary of more than £80,000 £80,000 £82,500
UK excluding London average salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

Dimensional Modelling
Jobs Demand Trend in the City of London

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

Dimensional Modelling Jobs Demand Trend in the City of London

Dimensional Modelling
Salary Trend in the City of London

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

Dimensional Modelling Salary Trend in the City of London

Dimensional Modelling
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing Dimensional Modelling across the City of London region over the 3 months to 19 December 2014.

Dimensional Modelling Salary Histogram in the City of London

Dimensional Modelling
Top 30 Related IT Skills in the City of London

For the 6 months to 19 December 2014, IT jobs across the City of London 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 86 (83.50%) ETL
2 74 (71.84%) SQL
3 71 (68.93%) Business Intelligence
4 65 (63.11%) Data Warehouse
5 59 (57.28%) SQL Server
6 51 (49.51%) Oracle
7 45 (43.69%) SQL Server Integration Services
8 37 (35.92%) Informatica
9 36 (34.95%) T-SQL
10 33 (32.04%) Microsoft
11 30 (29.13%) Ab Initio
11 30 (29.13%) SQL Server 2008
12 28 (27.18%) DataStage
13 27 (26.21%) SQL Server Reporting Services
13 27 (26.21%) Data Modelling
14 26 (25.24%) Cognos
14 26 (25.24%) Reference Data
15 24 (23.30%) Finance
16 22 (21.36%) Kimball Methodology
17 21 (20.39%) Agile Software Development
18 19 (18.45%) Change Management
18 19 (18.45%) SQL Server Analysis Services
18 19 (18.45%) Clustering
19 18 (17.48%) QlikView
20 17 (16.50%) SQL Server 2005
20 17 (16.50%) SAP
20 17 (16.50%) Business Objects
21 13 (12.62%) MS Excel
21 13 (12.62%) Analytics
21 13 (12.62%) Performance Tuning

Dimensional Modelling
Top Related IT Skills in the City of London by Category

For the 6 months to 19 December 2014, IT jobs across the City of London 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 5 (4.85%) SAS
2 2 (1.94%) SharePoint 2010
2 2 (1.94%) SharePoint
3 1 (0.97%) Apache Spark
Applications
1 13 (12.62%) MS Excel
2 2 (1.94%) PowerPivot
3 1 (0.97%) SPSS
Business Applications
1 1 (0.97%) Cognos TM1
1 1 (0.97%) Cognos Business Intelligence
Cloud Services
1 4 (3.88%) SaaS
Database & Business Intelligence
1 65 (63.11%) Data Warehouse
2 59 (57.28%) SQL Server
3 45 (43.69%) SQL Server Integration Services
4 30 (29.13%) SQL Server 2008
5 28 (27.18%) DataStage
6 27 (26.21%) SQL Server Reporting Services
7 19 (18.45%) SQL Server Analysis Services
8 18 (17.48%) QlikView
9 17 (16.50%) SQL Server 2005
10 12 (11.65%) SAP Data Services
11 10 (9.71%) Hadoop
12 9 (8.74%) OLAP
12 9 (8.74%) Big Data
13 8 (7.77%) Relational Database
14 6 (5.83%) IBM InfoSphere
15 5 (4.85%) Oracle ODI
15 5 (4.85%) Oracle Database
15 5 (4.85%) SSDT
15 5 (4.85%) NoSQL
15 5 (4.85%) Star Schema
Development Applications
1 6 (5.83%) Visual Studio
1 6 (5.83%) ERwin
1 6 (5.83%) Team Foundation Server
2 3 (2.91%) Talend Open Studio
General
1 24 (23.30%) Finance
2 3 (2.91%) Advertising
2 3 (2.91%) Banking
3 2 (1.94%) Pharmaceutical
3 2 (1.94%) Marketing
4 1 (0.97%) Retail
4 1 (0.97%) Games
Job Titles
1 46 (44.66%) Developer
2 22 (21.36%) Project Manager
3 18 (17.48%) ETL Developer
4 9 (8.74%) DBA
5 8 (7.77%) Consultant
5 8 (7.77%) SAP Developer
6 7 (6.80%) Business Intelligence Developer
6 7 (6.80%) SQL DBA
6 7 (6.80%) Architect
7 6 (5.83%) QlikView Consultant
8 5 (4.85%) Senior ETL Developer
8 5 (4.85%) Data Architect
8 5 (4.85%) Senior Developer
8 5 (4.85%) Team Leader
9 4 (3.88%) Administrator
9 4 (3.88%) Development DBA
10 3 (2.91%) Microstrategy Developer
10 3 (2.91%) Head of Business Intelligence
10 3 (2.91%) Business Developer
10 3 (2.91%) Analyst
Libraries, Frameworks & Software Standards
1 6 (5.83%) .NET
2 4 (3.88%) MDX
3 2 (1.94%) SAP XI
Miscellaneous
1 26 (25.24%) Reference Data
2 19 (18.45%) Clustering
3 6 (5.83%) Visualisation
4 5 (4.85%) Analytical Skills
4 5 (4.85%) Computer Science
5 4 (3.88%) Data Integration
5 4 (3.88%) Data Structures
6 3 (2.91%) Data Protection Act
6 3 (2.91%) Management Information System
7 2 (1.94%) Taxonomies
7 2 (1.94%) Ontologies
8 1 (0.97%) NHS
8 1 (0.97%) Online Gambling
8 1 (0.97%) Oracle Exalytics
Operating Systems
1 5 (4.85%) UNIX
2 1 (0.97%) Linux
Processes & Methodologies
1 86 (83.50%) ETL
2 71 (68.93%) Business Intelligence
3 27 (26.21%) Data Modelling
4 22 (21.36%) Kimball Methodology
5 21 (20.39%) Agile Software Development
6 19 (18.45%) Change Management
7 13 (12.62%) Analytics
7 13 (12.62%) Performance Tuning
8 11 (10.68%) Scrum
8 11 (10.68%) Data Architecture
9 10 (9.71%) Data Mapping
9 10 (9.71%) Data Analysis
10 9 (8.74%) Mentoring
11 8 (7.77%) Line Management
11 8 (7.77%) Data Analytics
12 7 (6.80%) Unit Testing
12 7 (6.80%) Continuous Improvement
12 7 (6.80%) Data Governance
13 6 (5.83%) Data Management
13 6 (5.83%) Migration
Programming Languages
1 74 (71.84%) SQL
2 36 (34.95%) T-SQL
3 7 (6.80%) C#
3 7 (6.80%) PL/SQL
4 5 (4.85%) VB.NET
5 4 (3.88%) Java
6 3 (2.91%) C++
7 2 (1.94%) R
8 1 (0.97%) Data Mining Extensions (DMX)
8 1 (0.97%) C
8 1 (0.97%) Python
Qualifications
1 6 (5.83%) Degree
2 1 (0.97%) Security Cleared
Quality Assurance & Compliance
1 10 (9.71%) QA
2 5 (4.85%) Data Quality
System Software
1 1 (0.97%) Apache Flume
1 1 (0.97%) HDFS
Vendors
1 51 (49.51%) Oracle
2 37 (35.92%) Informatica
3 33 (32.04%) Microsoft
4 30 (29.13%) Ab Initio
5 26 (25.24%) Cognos
6 17 (16.50%) Business Objects
6 17 (16.50%) SAP
7 10 (9.71%) PeopleSoft
7 10 (9.71%) IBM
8 9 (8.74%) Teradata
9 6 (5.83%) Tableau
10 5 (4.85%) Birst
11 4 (3.88%) Netezza
11 4 (3.88%) Red Gate
11 4 (3.88%) MicroStrategy
12 3 (2.91%) Adobe
12 3 (2.91%) Talend
13 1 (0.97%) Hortonworks
13 1 (0.97%) Cloudera
13 1 (0.97%) MapR
City, London
Engage PSG
Salary: £55000 - £60000 per annum + standard big company benefits
Posted: Yesterday
City of London
Nigel Frank International Limited - Newcastle
Salary: £60000 - £70000 per annum
Posted: Yesterday
City, London
Connectus
Salary: £65000 - £80000 per annum + benefits
Posted: 2 days ago
City, London
Connectus
Salary: £65000 - £80000 per annum + benefits
Posted: 2 days ago
City of London
Progressive Recruitment
Salary: £58000 - £75000 per annum + COMPETIVE BENEFITS
Posted: 9 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £40000 - £45000 per annum + Package & Bonus
Posted: 11 days ago