The following table provides summary statistics for permanent job vacancies advertised in London with a requirement for Dimensional Modelling skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Dimensional Modelling over the 3 months to 28 March 2017 with a comparison to the same period in the previous 2 years.

Dimensional Modelling
England / London
3 months to
28 Mar 2017
Same period 2016 Same period 2015
Rank 514 539 523
Rank change year-on-year +25 -16  
Permanent jobs citing Dimensional Modelling 63 116 140
As % of all permanent IT jobs advertised in London 0.19% 0.28% 0.33%
As % of the Processes & Methodologies category 0.21% 0.31% 0.37%
Number of salaries quoted 45 61 117
Median salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.34% +4.54%  
90% offered a salary of more than £47,500 £47,500 £41,500
10% offered a salary of more than £70,000 £75,000 £75,000
UK excluding London median salary £45,000 £45,000 £45,000

Dimensional Modelling is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in London with a requirement for process and methodology skills.

Process & Methodology Skills
London
Permanent job vacancies with a requirement for process and methodology skills 30441 37820 37607
As % of all permanent IT job vacancies advertised in London 90.25% 89.69% 87.66%
Number of salaries quoted 25539 32306 31364
Median salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.34% -  
90% offered a salary of more than £40,000 £38,695 £37,500
10% offered a salary of more than £85,000 £80,000 £85,000
UK excluding London median salary £45,000 £45,000 £43,000
% change year-on-year - +4.65%  

Dimensional Modelling
Job Vacancy Trend in London

The job posting trend of jobs advertised in London citing Dimensional Modelling as a proportion of all permanent or contract IT jobs with a match in the Processes & Methodologies category.

Job vacancy trend for Dimensional Modelling in London

Dimensional Modelling
Salary Trend in London

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

Salary trend for Dimensional Modelling in London

Dimensional Modelling
Salary Histogram in London

The salary distribution of IT jobs citing Dimensional Modelling in London over the 3 months to 28 March 2017.

Salary histogram for Dimensional Modelling in London

Dimensional Modelling
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Dimensional Modelling within the London region over the 3 months to 28 March 2017. 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 Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London +35 12 £67,500 +8.00% 2
Dimensional Modelling
England

For the 6 months to 28 March 2017, IT jobs citing Dimensional Modelling also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the London region with a requirement for Dimensional Modelling.

1 120 (80.54%) SQL
2 114 (76.51%) Business Intelligence
3 107 (71.81%) Data Warehouse
4 89 (59.73%) ETL
5 81 (54.36%) SQL Server
6 80 (53.69%) T-SQL
7 70 (46.98%) SQL Server Integration Services
8 69 (46.31%) Kimball Methodology
9 51 (34.23%) Agile Software Development
10 48 (32.21%) OLAP
11 46 (30.87%) SQL Server Reporting Services
12 45 (30.20%) Visualisation
13 40 (26.85%) SQL Server Analysis Services
14 38 (25.50%) Oracle
15 37 (24.83%) PL/SQL
16 36 (24.16%) Data Modelling
17 32 (21.48%) Microsoft
17 32 (21.48%) Finance
17 32 (21.48%) ETL Development
18 28 (18.79%) Analytics
18 28 (18.79%) MDX
19 27 (18.12%) Cognos
20 26 (17.45%) Cognos Analysis Studio
20 26 (17.45%) Cognos Report Studio
20 26 (17.45%) Cognos Framework Manager
20 26 (17.45%) Cognos Event Studio
21 25 (16.78%) Cognos Business Intelligence
22 24 (16.11%) Mentoring
23 22 (14.77%) MS Excel
23 22 (14.77%) Performance Tuning

Dimensional Modelling
Co-occurring IT Skills in London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 13 (8.72%) SharePoint
2 2 (1.34%) SAS
3 1 (0.67%) Apache Spark
Applications
1 22 (14.77%) MS Excel
2 1 (0.67%) MS Office
Business Applications
1 25 (16.78%) Cognos Business Intelligence
2 16 (10.74%) Cognos Planning
3 1 (0.67%) Cognos TM1
3 1 (0.67%) SAP BPC
Cloud Services
1 13 (8.72%) Amazon AWS
2 7 (4.70%) Amazon EMR
3 6 (4.03%) Amazon S3
4 5 (3.36%) Microsoft Azure
5 4 (2.68%) Google Cloud Platform
6 1 (0.67%) Amazon EC2
6 1 (0.67%) AWS Lambda
Communications & Networking
1 6 (4.03%) Internet
Database & Business Intelligence
1 107 (71.81%) Data Warehouse
2 81 (54.36%) SQL Server
3 70 (46.98%) SQL Server Integration Services
4 48 (32.21%) OLAP
5 46 (30.87%) SQL Server Reporting Services
6 40 (26.85%) SQL Server Analysis Services
7 26 (17.45%) Cognos Analysis Studio
7 26 (17.45%) Cognos Event Studio
7 26 (17.45%) Cognos Framework Manager
7 26 (17.45%) Cognos Report Studio
8 22 (14.77%) Oracle OLAP
9 20 (13.42%) Power BI
10 17 (11.41%) Oracle ODI
10 17 (11.41%) SQL Server 2012
11 16 (10.74%) Big Data
12 14 (9.40%) Hadoop
13 13 (8.72%) MySQL
13 13 (8.72%) SQL Server 2008
14 12 (8.05%) BusinessObjects
14 12 (8.05%) OLAP Cube
Development Applications
1 16 (10.74%) SQL Server Management Studio (SSMS)
2 10 (6.71%) JIRA
3 7 (4.70%) MSBuild
4 6 (4.03%) Git (software)
5 3 (2.01%) ERwin
6 2 (1.34%) Team Foundation Server
General
1 32 (21.48%) Finance
2 15 (10.07%) Marketing
3 10 (6.71%) Games
3 10 (6.71%) Retail
4 7 (4.70%) Legal
5 5 (3.36%) Law
6 4 (2.68%) Publishing
7 3 (2.01%) Banking
8 2 (1.34%) Music Industry
8 2 (1.34%) Telecoms
9 1 (0.67%) Advertising
9 1 (0.67%) Front Office
Job Titles
1 69 (46.31%) Developer
2 43 (28.86%) Business Intelligence Developer
3 33 (22.15%) Analyst
4 32 (21.48%) SQL Developer
5 24 (16.11%) Business Intelligence Specialist
5 24 (16.11%) Cognos Specialist
6 21 (14.09%) Business Intelligence Analyst
7 19 (12.75%) Business Developer
8 17 (11.41%) SQL BI Developer
8 17 (11.41%) SSRS Developer
9 16 (10.74%) Data Warehouse Developer
10 15 (10.07%) SSAS Developer
11 14 (9.40%) SSIS Developer
12 13 (8.72%) Senior Developer
13 12 (8.05%) Business Analyst
13 12 (8.05%) SQL Server BI Developer
13 12 (8.05%) SQL Server Developer
14 11 (7.38%) Oracle Developer
15 10 (6.71%) PL/SQL Developer
15 10 (6.71%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 28 (18.79%) MDX
2 15 (10.07%) Oracle GoldenGate
3 10 (6.71%) Web Services
3 10 (6.71%) XML
4 7 (4.70%) Kafka
5 5 (3.36%) .NET
6 1 (0.67%) JMS
6 1 (0.67%) RabbitMQ
Miscellaneous
1 16 (10.74%) Fintech
2 10 (6.71%) Replication
3 8 (5.37%) Online Games
4 5 (3.36%) Computer Science
5 4 (2.68%) Analytical Skills
5 4 (2.68%) Management Information System
6 2 (1.34%) Data Structures
6 2 (1.34%) Enterprise Software
6 2 (1.34%) Social Media
6 2 (1.34%) SWIFT
7 1 (0.67%) Derivative
7 1 (0.67%) Hedge funds
Operating Systems
1 5 (3.36%) Linux
1 5 (3.36%) Windows
2 1 (0.67%) Unix
Processes & Methodologies
1 114 (76.51%) Business Intelligence
2 89 (59.73%) ETL
3 69 (46.31%) Kimball Methodology
4 51 (34.23%) Agile Software Development
5 45 (30.20%) Visualisation
6 36 (24.16%) Data Modelling
7 32 (21.48%) ETL Development
8 28 (18.79%) Analytics
9 24 (16.11%) Mentoring
10 22 (14.77%) Performance Tuning
11 20 (13.42%) Scrum
12 16 (10.74%) Technical Architecture
13 14 (9.40%) Statistics
14 13 (8.72%) Data Visualisation
14 13 (8.72%) E-Commerce
15 12 (8.05%) Kanban
16 11 (7.38%) Data Transformation
16 11 (7.38%) User Stories
17 10 (6.71%) Data Governance
18 9 (6.04%) Quantitative Analysis
Programming Languages
1 120 (80.54%) SQL
2 80 (53.69%) T-SQL
3 37 (24.83%) PL/SQL
4 15 (10.07%) R
5 14 (9.40%) C#
6 8 (5.37%) Java
7 6 (4.03%) Data Analysis Expressions (DAX)
8 5 (3.36%) VB
8 5 (3.36%) VB.NET
8 5 (3.36%) VBA
9 4 (2.68%) Python
10 2 (1.34%) JavaScript
10 2 (1.34%) Scala
11 1 (0.67%) Clojure
11 1 (0.67%) Ruby
Qualifications
1 16 (10.74%) Degree
2 2 (1.34%) Microsoft Certification
Quality Assurance & Compliance
1 16 (10.74%) Data Quality
1 16 (10.74%) QA
2 2 (1.34%) SEPA
2 2 (1.34%) TARGET2
3 1 (0.67%) Solvency II
Vendors
1 38 (25.50%) Oracle
2 32 (21.48%) Microsoft
3 27 (18.12%) Cognos
4 13 (8.72%) Tableau
5 9 (6.04%) SAP
6 7 (4.70%) MicroStrategy
7 6 (4.03%) Informatica
7 6 (4.03%) Netezza
8 5 (3.36%) Vertica
9 4 (2.68%) Google
10 3 (2.01%) Alteryx
11 2 (1.34%) IBM
11 2 (1.34%) Trillium
12 1 (0.67%) Ab Initio
12 1 (0.67%) Anaplan
12 1 (0.67%) CA
12 1 (0.67%) Hyperion
12 1 (0.67%) MapR
12 1 (0.67%) Sybase
12 1 (0.67%) Teradata
London
Burns Sheehan
Salary: £55000 - £70000 per annum
Posted: 4 hours ago
London
Square One Resources
Salary: Up to £100,000 per annum
Posted: 5 hours ago
West London
Data Idols
Salary: From £50,000 to £55,000 per annum + Bonus & Benefits
Posted: Yesterday
West London
Total Recruitment Specialists Limited / TRG / Total recruitment group
Salary: £50000 Per Annum Plus excellent benefits
Posted: 2 days ago
City, London
Venturi
Salary: £40000 - £45000.00 per annum + extensive benefits
Posted: 6 days ago
North West London
Hudson IT
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: 4 days ago
Central London / West End
The Workshop
Posted: 4 days ago
Central London / West End
The Workshop
Posted: 7 days ago
London
CPS Group Limited
Salary: car, pension, bonus
Posted: 21 days ago