Period
to 19 November 2017

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

Dimensional Modelling
England > London
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 607 676 692
Rank change year-on-year +69 +16 -91
Permanent jobs citing Dimensional Modelling 239 175 233
As % of all permanent IT jobs advertised in London 0.32% 0.23% 0.26%
As % of the Processes & Methodologies category 0.35% 0.26% 0.29%
Number of salaries quoted 136 150 186
London median annual salary £67,500 £60,000 £57,500
Median salary % change year-on-year +12.50% +4.35% +4.55%
10th Percentile £46,875 £42,500 £42,500
90th Percentile £76,250 £82,500 £82,500
England median annual salary £60,000 £52,500 £55,000
% change year-on-year +14.29% -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 68400 68410 79775
As % of all permanent IT jobs advertised in London 91.62% 90.62% 89.57%
Number of salaries quoted 52517 58869 67204
London median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% -
10th Percentile £35,000 £33,750 £33,000
90th Percentile £90,000 £88,750 £86,250
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +5.56%

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 November 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 6 months to 19 November 2017. 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 +11 46 £67,500 +12.50% 1
West London +15 5 £27,500 -50.89%
East London - 4 £62,500 -
North London - 1 £42,500 -
South London - 1 £50,000 -
Dimensional Modelling
England

For the 6 months to 19 November 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 207 (86.61%) SQL
2 201 (84.10%) Data Warehouse
3 179 (74.90%) Business Intelligence
4 155 (64.85%) SQL Server
5 145 (60.67%) ETL
6 117 (48.95%) SQL Server Integration Services
7 109 (45.61%) Kimball Methodology
8 106 (44.35%) OLAP
9 94 (39.33%) SQL Server Analysis Services
10 92 (38.49%) SQL Server Reporting Services
10 92 (38.49%) Data Modelling
11 87 (36.40%) Agile Software Development
12 84 (35.15%) Microsoft
13 75 (31.38%) OLAP Cube
14 69 (28.87%) Oracle
15 67 (28.03%) Analytics
16 64 (26.78%) Power BI
17 63 (26.36%) Tableau
18 62 (25.94%) PL/SQL
19 58 (24.27%) T-SQL
20 57 (23.85%) QlikView
21 56 (23.43%) Visualisation
22 55 (23.01%) Finance
23 54 (22.59%) MDX
23 54 (22.59%) Performance Tuning
24 49 (20.50%) MySQL
25 45 (18.83%) Marketing
25 45 (18.83%) Amazon AWS
26 44 (18.41%) Amazon RDS
27 43 (17.99%) Degree

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 28 (11.72%) SharePoint
2 3 (1.26%) SAS
3 2 (0.84%) Apache Spark
4 1 (0.42%) MS Exchange
Applications
1 23 (9.62%) Microsoft Excel
2 1 (0.42%) Microsoft Office
2 1 (0.42%) SPSS
Business Applications
1 2 (0.84%) Dynamics GP
Cloud Services
1 45 (18.83%) Amazon AWS
2 32 (13.39%) Microsoft Azure
3 19 (7.95%) Azure Machine Learning
4 6 (2.51%) Office 365
5 5 (2.09%) Cloud Computing
6 3 (1.26%) Mimecast
6 3 (1.26%) SaaS
7 2 (0.84%) GitHub
7 2 (0.84%) PaaS
8 1 (0.42%) Amazon EC2
8 1 (0.42%) Amazon Glacier
8 1 (0.42%) Amazon S3
8 1 (0.42%) Data Lake Analytics
Communications & Networking
1 2 (0.84%) Internet
Database & Business Intelligence
1 201 (84.10%) Data Warehouse
2 155 (64.85%) SQL Server
3 117 (48.95%) SQL Server Integration Services
4 106 (44.35%) OLAP
5 94 (39.33%) SQL Server Analysis Services
6 92 (38.49%) SQL Server Reporting Services
7 75 (31.38%) OLAP Cube
8 64 (26.78%) Power BI
9 57 (23.85%) QlikView
10 49 (20.50%) MySQL
11 44 (18.41%) Amazon RDS
12 42 (17.57%) Oracle OLAP
13 40 (16.74%) SQL Server 2012
14 38 (15.90%) Oracle Database
14 38 (15.90%) SQL Server 2008
15 36 (15.06%) OLTP
16 33 (13.81%) Amazon Redshift
16 33 (13.81%) Data Mart
16 33 (13.81%) Microsoft Analysis Services
17 31 (12.97%) DB2
Development Applications
1 15 (6.28%) Team Foundation Server
2 12 (5.02%) JIRA
3 7 (2.93%) ERwin
4 4 (1.67%) Talend Open Studio
5 2 (0.84%) Jenkins
5 2 (0.84%) Subversion
6 1 (0.42%) Visual Studio
General
1 55 (23.01%) Finance
2 45 (18.83%) Marketing
3 30 (12.55%) Banking
4 18 (7.53%) Publishing
5 12 (5.02%) Retail
6 11 (4.60%) Front Office
6 11 (4.60%) Retail Banking
7 9 (3.77%) Games
8 7 (2.93%) Advertising
9 4 (1.67%) Telecoms
10 3 (1.26%) Financial Institution
11 2 (0.84%) Back Office
11 2 (0.84%) Legal
Job Titles
1 132 (55.23%) Developer
2 86 (35.98%) Business Intelligence Developer
3 43 (17.99%) SQL Developer
4 39 (16.32%) Data Warehouse Developer
5 30 (12.55%) SQL BI Developer
6 29 (12.13%) Analyst
7 26 (10.88%) Business Developer
8 24 (10.04%) Consultant
9 23 (9.62%) Business Analyst
9 23 (9.62%) Business Intelligence Consultant
9 23 (9.62%) Data Analyst
9 23 (9.62%) Oracle Data Warehouse Developer
9 23 (9.62%) Oracle Developer
10 22 (9.21%) Data Business Analyst
11 20 (8.37%) Data Warehouse Analyst
12 18 (7.53%) Data Warehouse Business Analyst
13 17 (7.11%) Architect
13 17 (7.11%) Data Architect
13 17 (7.11%) SSAS Developer
13 17 (7.11%) SSIS Developer
Libraries, Frameworks & Software Standards
1 54 (22.59%) MDX
2 28 (11.72%) .NET
2 28 (11.72%) Oracle GoldenGate
3 26 (10.88%) XML
4 24 (10.04%) Web Services
5 19 (7.95%) ASP.NET
6 5 (2.09%) JSON
7 2 (0.84%) XSD
8 1 (0.42%) COM
8 1 (0.42%) HTML
8 1 (0.42%) JMS
8 1 (0.42%) JSP
8 1 (0.42%) Kafka
8 1 (0.42%) SAP XI
8 1 (0.42%) XSLT
Miscellaneous
1 29 (12.13%) Analytical Skills
2 23 (9.62%) Replication
3 20 (8.37%) Computer Science
4 7 (2.93%) Fintech
5 6 (2.51%) Reinsurance
6 5 (2.09%) Credit Risk
6 5 (2.09%) Data Protection Act
6 5 (2.09%) Equities
7 4 (1.67%) Management Information System
7 4 (1.67%) Social Media
8 3 (1.26%) Data Structures
8 3 (1.26%) Mashup
9 2 (0.84%) Greenfield Project
9 2 (0.84%) Internet of Things
10 1 (0.42%) NHS
Operating Systems
1 20 (8.37%) Linux
2 13 (5.44%) Windows
3 5 (2.09%) Unix
Processes & Methodologies
1 179 (74.90%) Business Intelligence
2 145 (60.67%) ETL
3 109 (45.61%) Kimball Methodology
4 92 (38.49%) Data Modelling
5 87 (36.40%) Agile Software Development
6 67 (28.03%) Analytics
7 56 (23.43%) Visualisation
8 54 (22.59%) Performance Tuning
9 42 (17.57%) ETL Development
10 41 (17.15%) Data Visualisation
11 40 (16.74%) Scrum
12 29 (12.13%) Data Analytics
13 26 (10.88%) Kanban
14 23 (9.62%) Data Transformation
14 23 (9.62%) Database Tuning
14 23 (9.62%) Statistics
15 21 (8.79%) Data Governance
15 21 (8.79%) Data Management
16 20 (8.37%) Migration
17 19 (7.95%) User Stories
Programming Languages
1 207 (86.61%) SQL
2 62 (25.94%) PL/SQL
3 58 (24.27%) T-SQL
4 29 (12.13%) C#
5 23 (9.62%) R
6 22 (9.21%) Python
7 21 (8.79%) VBA
8 19 (7.95%) VB
9 16 (6.69%) Java
10 3 (1.26%) C
10 3 (1.26%) PowerShell
10 3 (1.26%) VB.NET
11 1 (0.42%) C++
11 1 (0.42%) Data Analysis Expressions (DAX)
11 1 (0.42%) JavaScript
Qualifications
1 43 (17.99%) Degree
2 2 (0.84%) Numerate Degree
3 1 (0.42%) SC Cleared
3 1 (0.42%) Security Cleared
Quality Assurance & Compliance
1 39 (16.32%) Data Quality
1 39 (16.32%) QA
2 5 (2.09%) GDPR
2 5 (2.09%) ISO/IEC 27001
2 5 (2.09%) PCI DSS
Systems Management
1 2 (0.84%) Rundeck
Vendors
1 84 (35.15%) Microsoft
2 69 (28.87%) Oracle
3 63 (26.36%) Tableau
4 19 (7.95%) Alteryx
5 15 (6.28%) Vertica
6 8 (3.35%) Teradata
7 6 (2.51%) Ab Initio
7 6 (2.51%) IBM
7 6 (2.51%) Informatica
8 5 (2.09%) CA
8 5 (2.09%) MapR
9 4 (1.67%) Cognizant
9 4 (1.67%) SAP
9 4 (1.67%) Talend
10 3 (1.26%) EXASOL
11 2 (0.84%) Salesforce.com
11 2 (0.84%) Sybase
12 1 (0.42%) Cognos
12 1 (0.42%) Netezza
12 1 (0.42%) Yardi