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

Location
3 months to
19 Sep 2014
Same period 2013 Same period 2012
Dimensional Modeling
Rank 285 277 282
Rank change year-on-year
-8 +5
Permanent jobs citing Dimensional Modelling 35 49 55
As % of all permanent IT jobs located in the City of London 0.30% 0.41% 0.44%
As % of the Processes & Methodologies category 0.37% 0.50% 0.54%
Number of salaries quoted 26 45 53
Average salary £55,000 £62,500 £60,000
Average salary % change year-on-year
-12.00% +4.16%
90% offered a salary of more than £44,500 £50,000 £45,500
10% offered a salary of more than £63,500 £72,500 £77,500
UK excluding London average salary £50,000 £42,500 £50,000
% change year-on-year
+17.64% -15.00%
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
9438 9707 10189
As % of all permanent IT jobs located in the City of London 81.96% 82.09% 80.84%
Number of salaries quoted 7873 8476 9301
Average salary £55,000 £55,000 £55,000
90% offered a salary of more than £37,500 £37,500 £35,500
10% offered a salary of more than £80,000 £80,000 £80,000
UK excluding London average salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 September 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 September 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 74 (89.16%) SQL
1 74 (89.16%) SQL Server
2 67 (80.72%) ETL
2 67 (80.72%) SQL Server Integration Services
3 64 (77.11%) Business Intelligence
4 57 (68.67%) Data Warehouse
5 53 (63.86%) T-SQL
6 50 (60.24%) Agile Software Development
7 46 (55.42%) SQL Server 2008
8 42 (50.60%) Microsoft
9 38 (45.78%) Finance
10 37 (44.58%) Kimball Methodology
11 33 (39.76%) Business Objects
12 30 (36.14%) Change Management
12 30 (36.14%) SQL Server Analysis Services
13 28 (33.73%) Cognos
14 27 (32.53%) Oracle
15 25 (30.12%) C#
16 23 (27.71%) Visual Studio
16 23 (27.71%) MS Excel
16 23 (27.71%) Clustering
16 23 (27.71%) Team Foundation Server
17 22 (26.51%) Performance Tuning
18 20 (24.10%) IBM
18 20 (24.10%) QlikView
19 19 (22.89%) Data Modelling
19 19 (22.89%) Analytics
20 18 (21.69%) Mentoring
20 18 (21.69%) Analytical Skills
20 18 (21.69%) Scrum

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

For the 6 months to 19 September 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 15 (18.07%) SAS
2 2 (2.41%) SharePoint 2010
2 2 (2.41%) SharePoint
Applications
1 23 (27.71%) MS Excel
2 8 (9.64%) SPSS
Business Applications
1 10 (12.05%) Cognos Business Intelligence
2 2 (2.41%) Cognos TM1
Database & Business Intelligence
1 74 (89.16%) SQL Server
2 67 (80.72%) SQL Server Integration Services
3 57 (68.67%) Data Warehouse
4 46 (55.42%) SQL Server 2008
5 30 (36.14%) SQL Server Analysis Services
6 20 (24.10%) QlikView
7 18 (21.69%) SQL Server Reporting Services
8 16 (19.28%) SQL Server 2005
9 15 (18.07%) SSDT
10 14 (16.87%) Relational Database
10 14 (16.87%) Big Data
11 13 (15.66%) Microsoft Analysis Services
12 11 (13.25%) OLAP
12 11 (13.25%) SQL Server 2012
13 10 (12.05%) SAP Data Services
14 8 (9.64%) Oracle Database
15 7 (8.43%) Hadoop
15 7 (8.43%) MongoDB
15 7 (8.43%) NoSQL
15 7 (8.43%) DataStage
Development Applications
1 23 (27.71%) Visual Studio
1 23 (27.71%) Team Foundation Server
2 18 (21.69%) ERwin
3 6 (7.23%) Talend Open Studio
General
1 38 (45.78%) Finance
2 10 (12.05%) Retail
3 8 (9.64%) Telecoms
3 8 (9.64%) Banking
4 4 (4.82%) Marketing
5 3 (3.61%) Advertising
6 1 (1.20%) Games
Job Titles
1 37 (44.58%) Developer
2 26 (31.33%) ETL Developer
3 22 (26.51%) DBA
4 15 (18.07%) Senior Developer
4 15 (18.07%) Administrator
4 15 (18.07%) Team Leader
4 15 (18.07%) Senior ETL Developer
5 13 (15.66%) SQL DBA
5 13 (15.66%) Consultant
6 8 (9.64%) Technology Consultant
7 7 (8.43%) Data Architect
7 7 (8.43%) Architect
8 5 (6.02%) SAP Developer
9 4 (4.82%) Development DBA
10 3 (3.61%) Business Intelligence Developer
10 3 (3.61%) QlikView Consultant
10 3 (3.61%) Business Developer
10 3 (3.61%) Data Warehouse Developer
11 2 (2.41%) Business Intelligence Consultant
11 2 (2.41%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 15 (18.07%) .NET
2 10 (12.05%) MDX
3 2 (2.41%) SAP XI
4 1 (1.20%) Web Services
4 1 (1.20%) XML
Miscellaneous
1 23 (27.71%) Clustering
2 18 (21.69%) Analytical Skills
3 16 (19.28%) Visualisation
4 8 (9.64%) Computer Science
5 6 (7.23%) Data Protection Act
6 2 (2.41%) Management Information System
6 2 (2.41%) Data Integration
7 1 (1.20%) Online Gambling
7 1 (1.20%) Reference Data
7 1 (1.20%) NHS
Processes & Methodologies
1 67 (80.72%) ETL
2 64 (77.11%) Business Intelligence
3 50 (60.24%) Agile Software Development
4 37 (44.58%) Kimball Methodology
5 30 (36.14%) Change Management
6 22 (26.51%) Performance Tuning
7 19 (22.89%) Analytics
7 19 (22.89%) Data Modelling
8 18 (21.69%) Scrum
8 18 (21.69%) Mentoring
9 15 (18.07%) Line Management
10 14 (16.87%) Predictive Analytics
11 11 (13.25%) Refactoring
12 10 (12.05%) Data Mapping
12 10 (12.05%) Project Management
13 8 (9.64%) Risk Management
13 8 (9.64%) Data Analytics
13 8 (9.64%) Performance Improvement
14 7 (8.43%) Master Data Management
14 7 (8.43%) Data Management
Programming Languages
1 74 (89.16%) SQL
2 53 (63.86%) T-SQL
3 25 (30.12%) C#
4 16 (19.28%) VB.NET
5 14 (16.87%) Java
6 10 (12.05%) PL/SQL
7 9 (10.84%) R
8 8 (9.64%) MATLAB
8 8 (9.64%) JavaScript
9 6 (7.23%) C++
10 1 (1.20%) Python
10 1 (1.20%) Data Mining Extensions (DMX)
Qualifications
1 8 (9.64%) Degree
Quality Assurance & Compliance
1 10 (12.05%) QA
2 1 (1.20%) ISO 9000
Vendors
1 42 (50.60%) Microsoft
2 33 (39.76%) Business Objects
3 28 (33.73%) Cognos
4 27 (32.53%) Oracle
5 20 (24.10%) IBM
6 15 (18.07%) Informatica
6 15 (18.07%) Ab Initio
6 15 (18.07%) Tableau
7 12 (14.46%) SAP
8 8 (9.64%) PeopleSoft
8 8 (9.64%) Red Gate
9 6 (7.23%) Adobe
9 6 (7.23%) Talend
9 6 (7.23%) Teradata
10 1 (1.20%) MicroStrategy
10 1 (1.20%) Birst
10 1 (1.20%) Vertica
10 1 (1.20%) CA
City, London
Bridge Noble
Salary: £75 - £75000 per annum
Posted: 4 days ago
City of London
Real Staffing
Salary: £40000 - £50000 per annum + competitive
Posted: 11 days ago
City of London
Computer Futures
Salary: £55000 - £60000 per annum + competitive
Posted: 16 days ago
City of London
Bridge Noble
Salary: £50000 - £70000 per annum + Benefits
Posted: 18 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £65000 - £70000 per annum + Benefits Package
Posted: 24 days ago