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 29 January 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
29 Jan 2015
Same period 2014 Same period 2013
Dimensional Modeling
Rank 237 287 290
Rank change year-on-year
+50 +3
Permanent jobs citing Dimensional Modelling 67 26 25
As % of all permanent IT jobs located in the City of London 0.66% 0.25% 0.23%
As % of the Processes & Methodologies category 0.81% 0.30% 0.29%
Number of salaries quoted 65 22 23
Average salary £60,000 £60,000 £48,500
Average salary % change year-on-year
- +23.71%
90% offered a salary of more than £45,000 £55,000 £43,500
10% offered a salary of more than £72,100 £97,500 £59,600
UK excluding London average salary £43,750 £45,000 £43,000
% change year-on-year
-2.77% +4.65%
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
8278 8754 8759
As % of all permanent IT jobs located in the City of London 81.77% 83.20% 80.17%
Number of salaries quoted 7145 7423 7857
Average salary £57,500 £57,500 £55,000
Average salary % change year-on-year
- +4.54%
90% offered a salary of more than £39,500 £37,500 £36,000
10% offered a salary of more than £82,500 £79,400 £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 29 January 2015.

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 29 January 2015, 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 96 (84.96%) ETL
2 81 (71.68%) Business Intelligence
3 76 (67.26%) Data Warehouse
3 76 (67.26%) SQL
4 57 (50.44%) SQL Server
5 55 (48.67%) Oracle
6 47 (41.59%) SQL Server Integration Services
7 45 (39.82%) Informatica
8 41 (36.28%) T-SQL
9 37 (32.74%) Ab Initio
10 34 (30.09%) DataStage
11 31 (27.43%) Microsoft
12 29 (25.66%) SQL Server Reporting Services
12 29 (25.66%) SQL Server 2008
13 28 (24.78%) Data Modelling
14 26 (23.01%) Reference Data
15 23 (20.35%) SQL Server 2005
16 22 (19.47%) Cognos
17 21 (18.58%) Clustering
17 21 (18.58%) Change Management
17 21 (18.58%) Agile Software Development
17 21 (18.58%) Kimball Methodology
18 18 (15.93%) Finance
19 17 (15.04%) SQL Server Analysis Services
20 16 (14.16%) QlikView
21 14 (12.39%) SAP
22 13 (11.50%) Performance Tuning
22 13 (11.50%) Line Management
23 12 (10.62%) Business Objects
23 12 (10.62%) MS Excel

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

For the 6 months to 29 January 2015, 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 4 (3.54%) SAS
2 2 (1.77%) SharePoint 2010
2 2 (1.77%) SharePoint
3 1 (0.88%) Apache Spark
Applications
1 12 (10.62%) MS Excel
2 3 (2.65%) PowerPivot
3 2 (1.77%) SPSS
Business Applications
1 1 (0.88%) Cognos TM1
1 1 (0.88%) Cognos Business Intelligence
Cloud Services
1 4 (3.54%) SaaS
Database & Business Intelligence
1 76 (67.26%) Data Warehouse
2 57 (50.44%) SQL Server
3 47 (41.59%) SQL Server Integration Services
4 34 (30.09%) DataStage
5 29 (25.66%) SQL Server Reporting Services
5 29 (25.66%) SQL Server 2008
6 23 (20.35%) SQL Server 2005
7 17 (15.04%) SQL Server Analysis Services
8 16 (14.16%) QlikView
9 11 (9.73%) OLAP
10 10 (8.85%) SAP Data Services
10 10 (8.85%) Hadoop
11 9 (7.96%) Big Data
12 8 (7.08%) Relational Database
13 6 (5.31%) NoSQL
13 6 (5.31%) Oracle ODI
13 6 (5.31%) SSDT
14 5 (4.42%) BODI
14 5 (4.42%) IBM InfoSphere
14 5 (4.42%) Apache Cassandra
Development Applications
1 7 (6.19%) Visual Studio
1 7 (6.19%) Team Foundation Server
2 3 (2.65%) ERwin
3 2 (1.77%) PowerDesigner
4 1 (0.88%) Talend Open Studio
General
1 18 (15.93%) Finance
2 2 (1.77%) Pharmaceutical
2 2 (1.77%) Games
2 2 (1.77%) Marketing
3 1 (0.88%) Music Industry
3 1 (0.88%) Advertising
3 1 (0.88%) Banking
3 1 (0.88%) Retail
Job Titles
1 47 (41.59%) Developer
2 29 (25.66%) Project Manager
3 12 (10.62%) ETL Developer
4 9 (7.96%) Business Intelligence Developer
4 9 (7.96%) Consultant
5 8 (7.08%) DBA
5 8 (7.08%) Architect
5 8 (7.08%) Senior Project Manager
5 8 (7.08%) SQL DBA
5 8 (7.08%) Senior Manager
6 7 (6.19%) SAP Developer
6 7 (6.19%) QlikView Consultant
7 6 (5.31%) Senior Developer
8 4 (3.54%) Microstrategy Developer
8 4 (3.54%) Development DBA
9 3 (2.65%) Business Intelligence Manager
9 3 (2.65%) SQL Server Developer
9 3 (2.65%) Enterprise Architect
9 3 (2.65%) SQL Developer
9 3 (2.65%) Data Architect
Libraries, Frameworks & Software Standards
1 3 (2.65%) MDX
1 3 (2.65%) .NET
2 2 (1.77%) SAP XI
Miscellaneous
1 26 (23.01%) Reference Data
2 21 (18.58%) Clustering
3 7 (6.19%) Data Integration
4 6 (5.31%) Analytical Skills
5 5 (4.42%) Visualisation
6 3 (2.65%) Computer Science
6 3 (2.65%) Data Structures
7 2 (1.77%) Management Information System
7 2 (1.77%) Taxonomies
7 2 (1.77%) Ontologies
8 1 (0.88%) Data Protection Act
8 1 (0.88%) Online Games
8 1 (0.88%) Online Gambling
8 1 (0.88%) NHS
8 1 (0.88%) Oracle Exalytics
Operating Systems
1 7 (6.19%) UNIX
2 2 (1.77%) Linux
Processes & Methodologies
1 96 (84.96%) ETL
2 81 (71.68%) Business Intelligence
3 28 (24.78%) Data Modelling
4 21 (18.58%) Change Management
4 21 (18.58%) Agile Software Development
4 21 (18.58%) Kimball Methodology
5 13 (11.50%) Performance Tuning
5 13 (11.50%) Line Management
6 11 (9.73%) Data Architecture
7 10 (8.85%) Analytics
7 10 (8.85%) Scrum
8 9 (7.96%) Waterfall
9 8 (7.08%) Data Mapping
9 8 (7.08%) Data Analysis
10 7 (6.19%) Data Management
10 7 (6.19%) Information Management
10 7 (6.19%) Continuous Improvement
10 7 (6.19%) Unit Testing
11 6 (5.31%) Data Analytics
12 5 (4.42%) Migration
Programming Languages
1 76 (67.26%) SQL
2 41 (36.28%) T-SQL
3 8 (7.08%) PL/SQL
4 4 (3.54%) C#
5 3 (2.65%) Java
5 3 (2.65%) R
6 2 (1.77%) VB.NET
6 2 (1.77%) C
7 1 (0.88%) Python
7 1 (0.88%) C++
7 1 (0.88%) Data Mining Extensions (DMX)
7 1 (0.88%) Data Analysis Expressions (DAX)
Qualifications
1 5 (4.42%) Degree
2 2 (1.77%) Security Cleared
Quality Assurance & Compliance
1 8 (7.08%) QA
2 7 (6.19%) Data Quality
System Software
1 2 (1.77%) HDFS
2 1 (0.88%) Apache Flume
Vendors
1 55 (48.67%) Oracle
2 45 (39.82%) Informatica
3 37 (32.74%) Ab Initio
4 31 (27.43%) Microsoft
5 22 (19.47%) Cognos
6 14 (12.39%) SAP
7 12 (10.62%) Business Objects
8 8 (7.08%) IBM
8 8 (7.08%) PeopleSoft
8 8 (7.08%) Teradata
9 5 (4.42%) Netezza
9 5 (4.42%) MicroStrategy
9 5 (4.42%) Tableau
10 4 (3.54%) Birst
10 4 (3.54%) Red Gate
11 1 (0.88%) CA
11 1 (0.88%) Adobe
11 1 (0.88%) Talend
11 1 (0.88%) Hortonworks
11 1 (0.88%) Cloudera
City of London
Real Staffing
Salary: £55000 - £70000 per annum + competitive
Posted: 2 days ago
City of London
Progressive Recruitment
Salary: £70000 - £73000 per annum + Car Allowance + Pension + Healthcare
Posted: 6 days ago