Period
to 19 February 2019

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

Dimensional Modelling
England > London
6 months to
19 Feb 2019
Same period 2018 Same period 2017
Rank 616 613 650
Rank change year-on-year -3 +37 +25
Permanent jobs citing Dimensional Modelling 168 198 155
As % of all permanent IT jobs advertised in London 0.27% 0.28% 0.22%
As % of the Processes & Methodologies category 0.29% 0.30% 0.24%
Number of salaries quoted 139 117 136
London median annual salary £62,500 £67,500 £60,000
Median salary % change year-on-year -7.41% +12.50% +4.35%
10th Percentile £48,750 £42,500 £45,625
90th Percentile £83,750 £79,250 £80,000
England median annual salary £57,500 £55,000 £52,500
% change year-on-year +4.55% +4.76% -

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 57,956 65,015 63,638
As % of all permanent IT jobs advertised in London 92.11% 93.03% 92.08%
Number of salaries quoted 46,795 53,219 53,934
London median annual salary £62,500 £60,000 £60,000
Median salary % change year-on-year +4.17% - +9.09%
10th Percentile £35,000 £35,000 £33,750
90th Percentile £95,000 £92,500 £90,000
England median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.00% - +5.26%

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 19 February 2019.

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 19 February 2019. 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
South London - 17 £60,000 -
Central London +14 15 £60,000 -11.11% 1
West London +23 11 £52,500 +90.91% 3
East London - 3 £60,000 -
North London +16 1 £57,000 +34.12% 1
Dimensional Modelling
England

For the 6 months to 19 February 2019, 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 152 (90.48%) Data Warehouse
2 134 (79.76%) Business Intelligence
3 124 (73.81%) SQL
4 120 (71.43%) SQL Server
5 112 (66.67%) ETL
6 103 (61.31%) SQL Server Integration Services
7 91 (54.17%) SQL Server Analysis Services
8 85 (50.60%) Microsoft
9 83 (49.40%) Data Modelling
10 80 (47.62%) T-SQL
11 75 (44.64%) Agile Software Development
12 73 (43.45%) SQL Server Reporting Services
13 72 (42.86%) Power BI
14 65 (38.69%) Kimball Methodology
14 65 (38.69%) Analytics
15 58 (34.52%) Microsoft Azure
16 51 (30.36%) Finance
17 50 (29.76%) Oracle
18 40 (23.81%) Performance Tuning
19 38 (22.62%) OLAP
20 35 (20.83%) Tableau
21 34 (20.24%) Data Management
21 34 (20.24%) GDPR
22 33 (19.64%) SDLC
22 33 (19.64%) Visualisation
22 33 (19.64%) Data Analysis Expressions (DAX)
23 32 (19.05%) Microsoft Analysis Services
23 32 (19.05%) Migration
23 32 (19.05%) Scrum
24 31 (18.45%) Data Migration

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 14 (8.33%) Apache Spark
2 4 (2.38%) Elasticsearch
2 4 (2.38%) SAS
3 3 (1.79%) Apache Pig
4 2 (1.19%) Apache
4 2 (1.19%) Apache Airflow
Applications
1 22 (13.10%) Microsoft Excel
2 21 (12.50%) MS Visio
Business Applications
1 6 (3.57%) Oracle EBS
1 6 (3.57%) Oracle Retail
2 1 (0.60%) SAP BPC
Cloud Services
1 58 (34.52%) Microsoft Azure
2 26 (15.48%) Azure Data Factory
3 10 (5.95%) Amazon AWS
4 3 (1.79%) Data Lake Analytics
5 2 (1.19%) Amazon EMR
5 2 (1.19%) Azure Machine Learning
5 2 (1.19%) SaaS
6 1 (0.60%) Google Cloud Platform
Database & Business Intelligence
1 152 (90.48%) Data Warehouse
2 120 (71.43%) SQL Server
3 103 (61.31%) SQL Server Integration Services
4 91 (54.17%) SQL Server Analysis Services
5 73 (43.45%) SQL Server Reporting Services
6 72 (42.86%) Power BI
7 38 (22.62%) OLAP
8 32 (19.05%) Microsoft Analysis Services
9 26 (15.48%) Data Lake
10 25 (14.88%) Azure SQL Database
10 25 (14.88%) Oracle Database
10 25 (14.88%) Relational Database
11 19 (11.31%) Big Data
11 19 (11.31%) Oracle OLAP
12 18 (10.71%) Hadoop
13 16 (9.52%) NoSQL
14 13 (7.74%) Enterprise Data Warehouse
14 13 (7.74%) OLAP Cube
15 12 (7.14%) Oracle ODI
15 12 (7.14%) PowerPivot
Development Applications
1 26 (15.48%) ERwin
2 24 (14.29%) ER Studio
3 15 (8.93%) Visual Studio
4 10 (5.95%) Git (software)
5 9 (5.36%) Visual Studio Team System
6 6 (3.57%) Oracle APEX
6 6 (3.57%) PVCS
6 6 (3.57%) Toad
7 4 (2.38%) SQL Server Management Studio (SSMS)
8 3 (1.79%) Team Foundation Server
9 2 (1.19%) JIRA
10 1 (0.60%) PowerDesigner
General
1 51 (30.36%) Finance
2 28 (16.67%) Retail
3 20 (11.90%) Banking
4 14 (8.33%) Games
5 13 (7.74%) Investment Banking
6 9 (5.36%) Marketing
7 8 (4.76%) Publishing
8 6 (3.57%) Advertising
9 2 (1.19%) Music Industry
10 1 (0.60%) Manufacturing
Job Titles
1 93 (55.36%) Developer
2 61 (36.31%) Business Intelligence Developer
3 35 (20.83%) Architect
4 31 (18.45%) Data Warehouse Developer
5 27 (16.07%) Data Architect
5 27 (16.07%) SQL Developer
6 19 (11.31%) Business Intelligence Architect
6 19 (11.31%) SQL BI Developer
7 16 (9.52%) Analyst
8 14 (8.33%) SSAS Developer
9 11 (6.55%) Senior Developer
10 10 (5.95%) Oracle Architect
11 9 (5.36%) Oracle Data Warehouse Developer
11 9 (5.36%) Oracle Developer
12 8 (4.76%) SQL Analyst
12 8 (4.76%) SSIS Developer
13 7 (4.17%) Dashboard Developer
13 7 (4.17%) Data Warehouse Business Analyst
13 7 (4.17%) SQL BI Architect
13 7 (4.17%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 20 (11.90%) MDX
2 14 (8.33%) JSON
3 12 (7.14%) Kafka
3 12 (7.14%) Oracle GoldenGate
4 7 (4.17%) .NET
5 6 (3.57%) Web Services
6 3 (1.79%) Spark Streaming
6 3 (1.79%) XML
7 2 (1.19%) Apache NiFi
7 2 (1.19%) RabbitMQ
8 1 (0.60%) ASP.NET
8 1 (0.60%) COM
Miscellaneous
1 29 (17.26%) Analytical Skills
2 12 (7.14%) Replication
3 11 (6.55%) Greenfield Project
4 5 (2.98%) Hedge funds
4 5 (2.98%) Self-Motivation
5 4 (2.38%) Fintech
6 3 (1.79%) Data Centre
6 3 (1.79%) Management Information System
7 2 (1.19%) Online Games
7 2 (1.19%) User Experience
8 1 (0.60%) Data Structures
Operating Systems
1 6 (3.57%) Linux
1 6 (3.57%) Unix
Processes & Methodologies
1 134 (79.76%) Business Intelligence
2 112 (66.67%) ETL
3 83 (49.40%) Data Modelling
4 75 (44.64%) Agile Software Development
5 65 (38.69%) Analytics
5 65 (38.69%) Kimball Methodology
6 40 (23.81%) Performance Tuning
7 34 (20.24%) Data Management
8 33 (19.64%) SDLC
8 33 (19.64%) Visualisation
9 32 (19.05%) Migration
9 32 (19.05%) Scrum
10 31 (18.45%) Data Migration
11 29 (17.26%) Physical Data Model
12 26 (15.48%) Data Architecture
12 26 (15.48%) Logical Data Model
13 17 (10.12%) Data Visualisation
14 16 (9.52%) Machine Learning
14 16 (9.52%) Problem-Solving
15 15 (8.93%) Data Analysis
Programming Languages
1 124 (73.81%) SQL
2 80 (47.62%) T-SQL
3 33 (19.64%) Data Analysis Expressions (DAX)
4 28 (16.67%) C#
5 26 (15.48%) PowerShell
6 17 (10.12%) PL/SQL
7 10 (5.95%) Python
8 6 (3.57%) Shell Script
9 5 (2.98%) R
10 3 (1.79%) Java
10 3 (1.79%) Scala
11 1 (0.60%) Tcl
11 1 (0.60%) VB.NET
Qualifications
1 6 (3.57%) Degree
2 4 (2.38%) Computer Science Degree
3 1 (0.60%) Master's Degree
3 1 (0.60%) MBA
Quality Assurance & Compliance
1 34 (20.24%) GDPR
2 23 (13.69%) Data Quality
2 23 (13.69%) QA
System Software
1 3 (1.79%) Apache Flume
1 3 (1.79%) Apache ZooKeeper
1 3 (1.79%) HDFS
1 3 (1.79%) Hyper-V
1 3 (1.79%) VMware Infrastructure
Vendors
1 85 (50.60%) Microsoft
2 50 (29.76%) Oracle
3 35 (20.83%) Tableau
4 9 (5.36%) SAP
5 5 (2.98%) Talend
6 4 (2.38%) MicroStrategy
6 4 (2.38%) Splunk
7 3 (1.79%) Alteryx
7 3 (1.79%) Cloudera
7 3 (1.79%) Hortonworks
7 3 (1.79%) Informatica
7 3 (1.79%) MapR
7 3 (1.79%) VMware
8 2 (1.19%) Adobe
8 2 (1.19%) Cognos
9 1 (0.60%) Anaplan
9 1 (0.60%) Hyperion
9 1 (0.60%) IBM