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

Dimensional Modelling
England / London
3 months to
25 Jun 2017
Same period 2016 Same period 2015
Rank 492 526 557
Rank change year-on-year +34 +31  
Permanent jobs citing Dimensional Modelling 120 110 124
As % of all permanent IT jobs advertised in London 0.33% 0.28% 0.28%
As % of the Processes & Methodologies category 0.36% 0.31% 0.31%
Number of salaries quoted 68 69 87
Median salary £65,000 £60,000 £57,500
Median salary % change year-on-year +8.33% +4.34%  
90% offered a salary of more than £42,500 £47,000 £42,500
10% offered a salary of more than £72,500 £81,000 £82,000
UK excluding London median salary £43,000 £44,000 £45,000
% change year-on-year -2.27% -2.22%  

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 33074 35742 39837
As % of all permanent IT job vacancies advertised in London 91.08% 90.56% 88.99%
Number of salaries quoted 26355 30960 33460
Median salary £61,500 £60,000 £57,500
Median salary % change year-on-year +2.50% +4.34%  
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £85,000 £82,500 £85,000
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year - +2.27%  

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 25 June 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 25 June 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 +7 9 £42,500 -29.16%
Dimensional Modelling
England

For the 6 months to 25 June 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 158 (86.81%) SQL
2 154 (84.62%) Data Warehouse
3 132 (72.53%) Business Intelligence
4 118 (64.84%) ETL
5 109 (59.89%) SQL Server
6 90 (49.45%) SQL Server Integration Services
7 85 (46.70%) OLAP
8 81 (44.51%) Kimball Methodology
9 72 (39.56%) SQL Server Reporting Services
10 69 (37.91%) SQL Server Analysis Services
11 64 (35.16%) Oracle
12 57 (31.32%) PL/SQL
12 57 (31.32%) Visualisation
13 54 (29.67%) T-SQL
14 50 (27.47%) Agile Software Development
14 50 (27.47%) OLAP Cube
15 49 (26.92%) Data Modelling
16 47 (25.82%) Finance
17 46 (25.27%) Microsoft
18 43 (23.63%) Data Visualisation
19 41 (22.53%) Performance Tuning
20 37 (20.33%) Tableau
21 35 (19.23%) MySQL
22 34 (18.68%) Data Quality
22 34 (18.68%) Oracle OLAP
22 34 (18.68%) Marketing
23 33 (18.13%) Power BI
24 30 (16.48%) Oracle ODI
24 30 (16.48%) SQL Server 2012
25 28 (15.38%) Data Governance

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 11 (6.04%) SharePoint
2 3 (1.65%) JBoss
2 3 (1.65%) Tomcat
2 3 (1.65%) WebLogic
2 3 (1.65%) WebSphere
3 2 (1.10%) Apache Pig
3 2 (1.10%) SAS
4 1 (0.55%) Apache Spark
Applications
1 22 (12.09%) Microsoft Excel
2 2 (1.10%) SPSS
Business Applications
1 3 (1.65%) Dynamics GP
2 1 (0.55%) SAP BPC
Cloud Services
1 21 (11.54%) Amazon AWS
2 7 (3.85%) Microsoft Azure
3 3 (1.65%) Amazon EC2
3 3 (1.65%) Amazon EMR
4 2 (1.10%) Cloud Computing
4 2 (1.10%) Office 365
5 1 (0.55%) AWS Lambda
5 1 (0.55%) IaaS
Communications & Networking
1 3 (1.65%) HTTP
1 3 (1.65%) LDAP
1 3 (1.65%) SSL
2 1 (0.55%) Broadband
Database & Business Intelligence
1 154 (84.62%) Data Warehouse
2 109 (59.89%) SQL Server
3 90 (49.45%) SQL Server Integration Services
4 85 (46.70%) OLAP
5 72 (39.56%) SQL Server Reporting Services
6 69 (37.91%) SQL Server Analysis Services
7 50 (27.47%) OLAP Cube
8 35 (19.23%) MySQL
9 34 (18.68%) Oracle OLAP
10 33 (18.13%) Power BI
11 30 (16.48%) Oracle ODI
11 30 (16.48%) SQL Server 2012
12 27 (14.84%) Relational Database
13 25 (13.74%) SQL Server 2008
14 22 (12.09%) OLTP
14 22 (12.09%) Oracle Database
15 21 (11.54%) DB2
15 21 (11.54%) Hadoop
16 18 (9.89%) SQL Server 2014
17 17 (9.34%) MongoDB
Development Applications
1 11 (6.04%) JIRA
2 4 (2.20%) ERwin
2 4 (2.20%) Talend Open Studio
2 4 (2.20%) Team Foundation Server
3 2 (1.10%) Octopus Deploy
3 2 (1.10%) TeamCity
4 1 (0.55%) MSBuild
General
1 47 (25.82%) Finance
2 34 (18.68%) Marketing
3 20 (10.99%) Banking
4 15 (8.24%) Publishing
5 14 (7.69%) Front Office
6 11 (6.04%) Legal
6 11 (6.04%) Retail
7 3 (1.65%) Back Office
7 3 (1.65%) Games
7 3 (1.65%) Law
7 3 (1.65%) Telecoms
8 2 (1.10%) Retail Banking
Job Titles
1 115 (63.19%) Developer
2 70 (38.46%) Business Intelligence Developer
3 56 (30.77%) SQL Developer
4 31 (17.03%) SQL BI Developer
5 30 (16.48%) Analyst
5 30 (16.48%) Data Warehouse Developer
6 29 (15.93%) Business Developer
7 21 (11.54%) Oracle Developer
8 20 (10.99%) SSAS Developer
8 20 (10.99%) SSRS Developer
9 17 (9.34%) Senior Developer
10 16 (8.79%) Business Analyst
11 14 (7.69%) Data Analyst
11 14 (7.69%) Data Business Analyst
11 14 (7.69%) Oracle Data Warehouse Developer
11 14 (7.69%) SSIS Developer
12 13 (7.14%) Senior Business Intelligence Developer
13 12 (6.59%) Business Intelligence Analyst
13 12 (6.59%) PL/SQL Developer
14 11 (6.04%) Data Warehouse Analyst
Libraries, Frameworks & Software Standards
1 28 (15.38%) MDX
2 22 (12.09%) Oracle GoldenGate
3 17 (9.34%) Web Services
3 17 (9.34%) XML
4 5 (2.75%) .NET
5 3 (1.65%) HTML
5 3 (1.65%) JSP
5 3 (1.65%) Spring
5 3 (1.65%) Spring Security
5 3 (1.65%) XSLT
6 2 (1.10%) JMS
6 2 (1.10%) Kafka
6 2 (1.10%) RabbitMQ
7 1 (0.55%) ODBC
Miscellaneous
1 17 (9.34%) Fintech
2 16 (8.79%) Computer Science
3 14 (7.69%) Replication
4 9 (4.95%) Analytical Skills
5 7 (3.85%) Social Media
6 6 (3.30%) Management Information System
7 5 (2.75%) Data Protection Act
8 2 (1.10%) Derivative
8 2 (1.10%) Hedge funds
9 1 (0.55%) Data Structures
9 1 (0.55%) Enterprise Software
9 1 (0.55%) NHS
Operating Systems
1 15 (8.24%) Windows
2 14 (7.69%) Linux
3 3 (1.65%) Solaris
4 2 (1.10%) Unix
Processes & Methodologies
1 132 (72.53%) Business Intelligence
2 118 (64.84%) ETL
3 81 (44.51%) Kimball Methodology
4 57 (31.32%) Visualisation
5 50 (27.47%) Agile Software Development
6 49 (26.92%) Data Modelling
7 43 (23.63%) Data Visualisation
8 41 (22.53%) Performance Tuning
9 28 (15.38%) Data Governance
9 28 (15.38%) ETL Development
10 26 (14.29%) Analytics
11 21 (11.54%) Data Management
12 20 (10.99%) Scrum
12 20 (10.99%) Statistics
13 18 (9.89%) Kanban
14 17 (9.34%) Mentoring
15 14 (7.69%) Data Analytics
15 14 (7.69%) Data Transformation
16 13 (7.14%) Data Security
16 13 (7.14%) User Stories
Programming Languages
1 158 (86.81%) SQL
2 57 (31.32%) PL/SQL
3 54 (29.67%) T-SQL
4 16 (8.79%) Java
5 11 (6.04%) C#
5 11 (6.04%) VB
5 11 (6.04%) VBA
6 9 (4.95%) R
7 7 (3.85%) Python
8 4 (2.20%) Data Analysis Expressions (DAX)
9 3 (1.65%) JavaScript
9 3 (1.65%) VB.NET
10 2 (1.10%) Clojure
10 2 (1.10%) Ruby
10 2 (1.10%) Scala
Qualifications
1 28 (15.38%) Degree
2 2 (1.10%) Computer Science Degree
2 2 (1.10%) Master's Degree
Quality Assurance & Compliance
1 34 (18.68%) Data Quality
2 25 (13.74%) QA
3 5 (2.75%) GDPR
3 5 (2.75%) ISO/IEC 27001
3 5 (2.75%) PCI DSS
System Software
1 3 (1.65%) Active Directory
2 2 (1.10%) Apache Flume
Vendors
1 64 (35.16%) Oracle
2 46 (25.27%) Microsoft
3 37 (20.33%) Tableau
4 15 (8.24%) Informatica
5 14 (7.69%) Vertica
6 6 (3.30%) Teradata
7 5 (2.75%) Cognizant
7 5 (2.75%) SAP
8 4 (2.20%) Ab Initio
8 4 (2.20%) CA
8 4 (2.20%) IBM
8 4 (2.20%) MapR
8 4 (2.20%) MicroStrategy
8 4 (2.20%) Talend
9 2 (1.10%) Alteryx
9 2 (1.10%) Greenplum
9 2 (1.10%) Netezza
10 1 (0.55%) Infor
10 1 (0.55%) Jaspersoft
10 1 (0.55%) TIBCO
Kingston Upon Thames, Surrey
Austin Fraser
Salary: £45000 - £55000 per annum + Depending on experience
Posted: 2 days ago
Central London / West End
The Workshop
Posted: 2 days ago
West London
Profile 29 Limited
Salary: From £80,000 to £100,000 per annum + benefits
Posted: 5 days ago