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

Location
3 months to
5 Feb 2016
Same period 2015 Same period 2014
Dimensional Modeling
Rank 242 253 298
Rank change year-on-year
+11 +45
Permanent jobs citing Dimensional Modelling 19 65 23
As % of all permanent IT jobs located in the City of London 0.28% 0.64% 0.22%
As % of the Processes & Methodologies category 0.32% 0.75% 0.26%
Number of salaries quoted 17 63 20
Average salary £62,500 £57,500 £58,750
Average salary % change year-on-year
+8.69% -2.12%
90% offered a salary of more than £55,000 £45,000 £54,750
10% offered a salary of more than £80,000 £72,300 £97,500
UK excluding London average salary £45,000 £43,750 £42,500
% change year-on-year
+2.85% +2.94%
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
5889 8631 8804
As % of all permanent IT jobs located in the City of London 87.99% 84.63% 85.75%
Number of salaries quoted 5269 7432 7470
Average salary £60,000 £57,500 £57,500
Average salary % change year-on-year
+4.34% -
90% offered a salary of more than £42,500 £40,000 £38,500
10% offered a salary of more than £85,000 £82,500 £82,500
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -

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 5 February 2016.

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 5 February 2016, 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 35 (89.74%) Business Intelligence
2 30 (76.92%) ETL
3 29 (74.36%) SQL Server Integration Services
4 28 (71.79%) SQL
5 23 (58.97%) Data Warehouse
5 23 (58.97%) SQL Server Reporting Services
6 22 (56.41%) SQL Server Analysis Services
6 22 (56.41%) Finance
7 20 (51.28%) SQL Server
8 16 (41.03%) Data Modelling
9 15 (38.46%) Microsoft
10 13 (33.33%) Oracle
10 13 (33.33%) Data Management
11 12 (30.77%) Kimball Methodology
11 12 (30.77%) T-SQL
11 12 (30.77%) Agile Software Development
12 10 (25.64%) Informatica
12 10 (25.64%) Tableau
12 10 (25.64%) Visualisation
12 10 (25.64%) Analytics
13 9 (23.08%) Data Integration
13 9 (23.08%) MDX
13 9 (23.08%) OLAP
14 8 (20.51%) PL/SQL
14 8 (20.51%) Oracle Database 11g
14 8 (20.51%) Oracle BI EE
14 8 (20.51%) Oracle Database
14 8 (20.51%) Relational Database
15 7 (17.95%) Change Data Capture
15 7 (17.95%) Data Architecture

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

For the 6 months to 5 February 2016, 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 (12.82%) SAS
2 3 (7.69%) SharePoint
Applications
1 2 (5.13%) MS Excel
1 2 (5.13%) PowerPivot
Cloud Services
1 3 (7.69%) Microsoft Azure
Communications & Networking
1 1 (2.56%) FTP
Database & Business Intelligence
1 29 (74.36%) SQL Server Integration Services
2 23 (58.97%) Data Warehouse
2 23 (58.97%) SQL Server Reporting Services
3 22 (56.41%) SQL Server Analysis Services
4 20 (51.28%) SQL Server
5 9 (23.08%) OLAP
6 8 (20.51%) Oracle BI EE
6 8 (20.51%) Oracle Database
6 8 (20.51%) Oracle Database 11g
6 8 (20.51%) Relational Database
7 7 (17.95%) PowerCenter
8 6 (15.38%) QlikView
9 4 (10.26%) Hadoop
9 4 (10.26%) Power BI
9 4 (10.26%) SQL Server 2008
9 4 (10.26%) SQL Server 2014
10 3 (7.69%) MongoDB
10 3 (7.69%) RDBMS
10 3 (7.69%) SQL Server 2012
11 2 (5.13%) BusinessObjects
Development Applications
1 2 (5.13%) Talend Open Studio
1 2 (5.13%) Team Foundation Server
2 1 (2.56%) Subversion
General
1 22 (56.41%) Finance
2 5 (12.82%) Law
3 4 (10.26%) Banking
4 2 (5.13%) Marketing
5 1 (2.56%) Advertising
5 1 (2.56%) Front Office
5 1 (2.56%) Legal
5 1 (2.56%) Retail
Job Titles
1 29 (74.36%) Developer
2 22 (56.41%) Business Intelligence Developer
3 8 (20.51%) Business Developer
4 7 (17.95%) OBIEE Developer
5 6 (15.38%) Architect
5 6 (15.38%) Data Architect
5 6 (15.38%) Informatica Developer
5 6 (15.38%) SQL Developer
6 5 (12.82%) Data Warehouse Developer
6 5 (12.82%) Senior Business Intelligence Developer
6 5 (12.82%) Senior Developer
7 4 (10.26%) Analyst
7 4 (10.26%) Data Integration Architect
7 4 (10.26%) Integration Architect
7 4 (10.26%) SQL BI Developer
8 3 (7.69%) Business Intelligence Analyst
8 3 (7.69%) ETL Architect
8 3 (7.69%) SQL Server BI Developer
8 3 (7.69%) SQL Server Developer
9 2 (5.13%) Business Intelligence Business Analyst
Libraries, Frameworks & Software Standards
1 9 (23.08%) MDX
Miscellaneous
1 10 (25.64%) Visualisation
2 9 (23.08%) Data Integration
3 4 (10.26%) Computer Science
3 4 (10.26%) Data Structures
4 2 (5.13%) Data Extraction
4 2 (5.13%) Derivative
4 2 (5.13%) Foreign Exchange (FX)
4 2 (5.13%) Management Information System
4 2 (5.13%) Mathematics
5 1 (2.56%) Analytical Skills
5 1 (2.56%) Spread Betting
Operating Systems
1 2 (5.13%) Linux
1 2 (5.13%) Unix
Processes & Methodologies
1 35 (89.74%) Business Intelligence
2 30 (76.92%) ETL
3 16 (41.03%) Data Modelling
4 13 (33.33%) Data Management
5 12 (30.77%) Agile Software Development
5 12 (30.77%) Kimball Methodology
6 10 (25.64%) Analytics
7 7 (17.95%) Change Data Capture
7 7 (17.95%) Data Architecture
8 6 (15.38%) Data Analysis
8 6 (15.38%) TOGAF
9 5 (12.82%) Data Analytics
10 4 (10.26%) Benchmarking
10 4 (10.26%) Data Transformation
10 4 (10.26%) Zachman Framework
11 3 (7.69%) Data Protection
11 3 (7.69%) SDLC
12 2 (5.13%) Complex ETL
12 2 (5.13%) Data Stewardship
12 2 (5.13%) Open Source
Programming Languages
1 28 (71.79%) SQL
2 12 (30.77%) T-SQL
3 8 (20.51%) PL/SQL
4 4 (10.26%) Python
5 2 (5.13%) Data Analysis Expressions (DAX)
6 1 (2.56%) C#
6 1 (2.56%) C++
6 1 (2.56%) JavaScript
6 1 (2.56%) PowerShell
6 1 (2.56%) R
6 1 (2.56%) SAS Macro
6 1 (2.56%) VB
6 1 (2.56%) VBA
Qualifications
1 5 (12.82%) Degree
2 2 (5.13%) ISEB
Quality Assurance & Compliance
1 3 (7.69%) Data Quality
1 3 (7.69%) QA
Vendors
1 15 (38.46%) Microsoft
2 13 (33.33%) Oracle
3 10 (25.64%) Informatica
3 10 (25.64%) Tableau
4 5 (12.82%) Alteryx
5 4 (10.26%) DataFlux
5 4 (10.26%) Trillium
6 3 (7.69%) Teradata
7 2 (5.13%) Ab Initio
7 2 (5.13%) IBM
7 2 (5.13%) MapR
7 2 (5.13%) MicroStrategy
7 2 (5.13%) Talend
8 1 (2.56%) Netezza
8 1 (2.56%) Sybase
City of London
Capita Resourcing Ltd
Salary: £50000 - £60000 per annum + Benefits
Posted: 5 days ago
City, London
Royal Mail Group
Salary: Excellent Salary & Benefits
Posted: 13 days ago
City of London
Talent Point
Salary: £50000.00 - £60000.00 per annum
Posted: 24 days ago