Period
to 23 May 2018

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 6 months to 23 May 2018 with a comparison to the same period in the previous 2 years.

Dimensional Modelling
England > London
6 months to
23 May 2018
Same period 2017 Same period 2016
Rank 674 650 628
Rank change year-on-year -24 -22 +8
Permanent jobs citing Dimensional Modelling 152 171 255
As % of all permanent IT jobs advertised in London 0.22% 0.25% 0.31%
As % of the Processes & Methodologies category 0.24% 0.27% 0.34%
Number of salaries quoted 91 114 129
London median annual salary £65,000 £60,000 £57,500
Median salary % change year-on-year +8.33% +4.35% -
10th Percentile £41,250 £46,250 £46,250
90th Percentile £85,000 £74,925 £75,000
England median annual salary £50,000 £52,500 £52,250
% change year-on-year -4.76% +0.48% -

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

All Process and Methodology Skills
London
Permanent vacancies with a requirement for process or methodology skills 63,314 62,438 74,949
As % of all permanent IT jobs advertised in London 91.73% 91.44% 91.14%
Number of salaries quoted 51,197 51,794 64,361
London median annual salary £60,000 £60,000 £55,000
Median salary % change year-on-year - +9.09% -
10th Percentile £35,750 £34,500 £33,250
90th Percentile £93,750 £90,000 £86,250
England median annual salary £50,000 £50,000 £48,000
% change year-on-year - +4.17% +1.05%

Dimensional Modelling
Job Vacancy Trend in London

Job postings citing Dimensional Modelling as a percentage of all IT jobs advertised in London.

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 6 months to 23 May 2018.

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 6 months to 23 May 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London -12 24 £72,500 +20.83% 6
North London - 6 £42,500 -
West London +25 4 £55,000 -24.14% 3
South London -5 3 £47,500 -29.63%
Dimensional Modelling
England

For the 6 months to 23 May 2018, IT jobs citing Dimensional Modelling also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the London region with a requirement for Dimensional Modelling.

1 119 (78.29%) SQL
2 111 (73.03%) Business Intelligence
3 105 (69.08%) Data Warehouse
4 92 (60.53%) SQL Server
5 82 (53.95%) Data Modelling
6 80 (52.63%) Agile Software Development
7 69 (45.39%) ETL
7 69 (45.39%) SQL Server Integration Services
8 65 (42.76%) Kimball Methodology
9 56 (36.84%) Analytics
10 49 (32.24%) Microsoft
11 48 (31.58%) Degree
12 46 (30.26%) SQL Server Reporting Services
13 44 (28.95%) Oracle
14 43 (28.29%) SQL Server Analysis Services
15 42 (27.63%) Data Governance
16 38 (25.00%) OLAP
17 35 (23.03%) T-SQL
18 33 (21.71%) Finance
18 33 (21.71%) Visualisation
19 32 (21.05%) Data Analytics
20 31 (20.39%) Analytical Skills
20 31 (20.39%) Power BI
21 30 (19.74%) Problem-Solving
22 29 (19.08%) Performance Tuning
22 29 (19.08%) Marketing
22 29 (19.08%) Computer Science
22 29 (19.08%) Microsoft Excel
23 26 (17.11%) MDX
23 26 (17.11%) Statistics

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 5 (3.29%) R Markdown
2 3 (1.97%) Apache Spark
2 3 (1.97%) SAS
3 2 (1.32%) Apache Airflow
3 2 (1.32%) Elasticsearch
3 2 (1.32%) SharePoint
4 1 (0.66%) Apache
4 1 (0.66%) Apache Pig
Applications
1 29 (19.08%) Microsoft Excel
2 1 (0.66%) Microsoft Office
2 1 (0.66%) Microsoft Project
Business Applications
1 8 (5.26%) Salesforce.com CRM
2 4 (2.63%) Dynamics AX
3 3 (1.97%) Cognos TM1
3 3 (1.97%) NetSuite
4 1 (0.66%) Dynamics CRM
4 1 (0.66%) Eagle PACE
4 1 (0.66%) Markit EDM
Cloud Services
1 24 (15.79%) Microsoft Azure
2 14 (9.21%) Amazon AWS
3 7 (4.61%) SaaS
4 4 (2.63%) Data Lake Analytics
5 3 (1.97%) Amazon EMR
5 3 (1.97%) Dynamics 365
6 2 (1.32%) Amazon EC2
6 2 (1.32%) IaaS
7 1 (0.66%) Amazon Glacier
7 1 (0.66%) Amazon S3
7 1 (0.66%) AWS Lambda
7 1 (0.66%) Azure Machine Learning
7 1 (0.66%) Serverless
Communications & Networking
1 5 (3.29%) Network Security
Database & Business Intelligence
1 105 (69.08%) Data Warehouse
2 92 (60.53%) SQL Server
3 69 (45.39%) SQL Server Integration Services
4 46 (30.26%) SQL Server Reporting Services
5 43 (28.29%) SQL Server Analysis Services
6 38 (25.00%) OLAP
7 31 (20.39%) Power BI
8 25 (16.45%) Snowflake Schema
9 24 (15.79%) NoSQL
10 21 (13.82%) MySQL
11 20 (13.16%) MongoDB
11 20 (13.16%) OLAP Cube
12 17 (11.18%) Relational Database
13 15 (9.87%) Microsoft Analysis Services
13 15 (9.87%) Oracle OLAP
14 13 (8.55%) Data Lake
15 12 (7.89%) Data Mart
15 12 (7.89%) SQL Server 2012
16 11 (7.24%) Big Data
17 10 (6.58%) Oracle Database
Development Applications
1 15 (9.87%) ERwin
2 7 (4.61%) JIRA
3 5 (3.29%) RStudio
4 3 (1.97%) ER Studio
General
1 33 (21.71%) Finance
2 29 (19.08%) Marketing
3 10 (6.58%) Games
4 6 (3.95%) Banking
5 3 (1.97%) Retail
6 2 (1.32%) Investment Banking
6 2 (1.32%) Music Industry
7 1 (0.66%) Back Office
7 1 (0.66%) Manufacturing
7 1 (0.66%) Pharmaceutical
Job Titles
1 102 (67.11%) Developer
2 81 (53.29%) Business Intelligence Developer
3 46 (30.26%) SQL Developer
4 43 (28.29%) SQL BI Developer
5 19 (12.50%) Analytics Developer
5 19 (12.50%) Data Visualisation Developer
6 18 (11.84%) Architect
6 18 (11.84%) Data Architect
6 18 (11.84%) Data Warehouse Developer
7 14 (9.21%) Business Developer
8 13 (8.55%) SSIS Developer
9 12 (7.89%) Data Modeller
10 10 (6.58%) Analyst
10 10 (6.58%) ETL Developer
11 8 (5.26%) Data Analyst
11 8 (5.26%) Power BI Developer
11 8 (5.26%) Senior Developer
12 7 (4.61%) Data Warehouse Business Analyst
12 7 (4.61%) SSAS Developer
12 7 (4.61%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 26 (17.11%) MDX
2 15 (9.87%) .NET
3 9 (5.92%) COM
4 8 (5.26%) Kafka
5 6 (3.95%) JSON
5 6 (3.95%) XML
6 4 (2.63%) Oracle GoldenGate
6 4 (2.63%) Web Services
7 2 (1.32%) JMS
7 2 (1.32%) RabbitMQ
8 1 (0.66%) ASP.NET
8 1 (0.66%) Spark Streaming
Miscellaneous
1 31 (20.39%) Analytical Skills
2 29 (19.08%) Computer Science
3 11 (7.24%) Greenfield Project
4 6 (3.95%) Self-Motivation
5 5 (3.29%) Enterprise Software
5 5 (3.29%) Replication
6 1 (0.66%) Algorithms
6 1 (0.66%) Data Centre
6 1 (0.66%) Data Structures
6 1 (0.66%) Fintech
6 1 (0.66%) User Experience
Operating Systems
1 23 (15.13%) Linux
2 19 (12.50%) Windows
3 1 (0.66%) Unix
Processes & Methodologies
1 111 (73.03%) Business Intelligence
2 82 (53.95%) Data Modelling
3 80 (52.63%) Agile Software Development
4 69 (45.39%) ETL
5 65 (42.76%) Kimball Methodology
6 56 (36.84%) Analytics
7 42 (27.63%) Data Governance
8 33 (21.71%) Visualisation
9 32 (21.05%) Data Analytics
10 30 (19.74%) Problem-Solving
11 29 (19.08%) Performance Tuning
12 26 (17.11%) Statistics
13 23 (15.13%) Data Visualisation
14 21 (13.82%) TOGAF
14 21 (13.82%) Zachman Framework
15 19 (12.50%) Marketing Intelligence
16 14 (9.21%) Logical Data Model
17 13 (8.55%) Data Architecture
17 13 (8.55%) Inmon Methodology
17 13 (8.55%) MODAF
Programming Languages
1 119 (78.29%) SQL
2 35 (23.03%) T-SQL
3 23 (15.13%) R
4 20 (13.16%) VBA
5 19 (12.50%) Python
5 19 (12.50%) VB
6 15 (9.87%) C#
6 15 (9.87%) Data Analysis Expressions (DAX)
7 13 (8.55%) PL/SQL
8 4 (2.63%) Clojure
8 4 (2.63%) Java
8 4 (2.63%) VB.NET
9 3 (1.97%) JavaScript
10 2 (1.32%) Scala
11 1 (0.66%) C++
11 1 (0.66%) Microsoft R
11 1 (0.66%) Ruby
Qualifications
1 48 (31.58%) Degree
2 7 (4.61%) Computer Science Degree
3 6 (3.95%) MCSE
3 6 (3.95%) Microsoft Certification
4 1 (0.66%) Master's Degree
Quality Assurance & Compliance
1 23 (15.13%) Data Quality
2 13 (8.55%) QA
3 6 (3.95%) GDPR
System Software
1 1 (0.66%) Apache Flume
1 1 (0.66%) Apache ZooKeeper
1 1 (0.66%) HDFS
Vendors
1 49 (32.24%) Microsoft
2 44 (28.95%) Oracle
3 19 (12.50%) Vertica
4 14 (9.21%) Informatica
5 11 (7.24%) Tableau
6 9 (5.92%) Ab Initio
6 9 (5.92%) Salesforce.com
7 8 (5.26%) Cognos
8 5 (3.29%) Cognizant
8 5 (3.29%) JDA
8 5 (3.29%) SAP
9 3 (1.97%) JD Edwards
10 2 (1.32%) Alteryx
11 1 (0.66%) Cloudera
11 1 (0.66%) EXASOL
11 1 (0.66%) GoldenSource
11 1 (0.66%) Hortonworks
11 1 (0.66%) MapR
11 1 (0.66%) Sybase