The following table provides summary statistics for permanent job vacancies advertised in the City of 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 24 March 2017 with a comparison to the same period in the previous 2 years.

3 months to
24 Mar 2017
Same period 2016 Same period 2015
Dimensional Modelling
London / City of London
Rank 207 255 281
Rank change year-on-year +48 +26  
Permanent jobs citing Dimensional Modelling 11 14 38
As % of all permanent IT jobs advertised in the City of London 0.22% 0.20% 0.37%
As % of the Processes & Methodologies category 0.24% 0.22% 0.43%
Number of salaries quoted 11 9 38
Median salary £67,500 £62,500 £56,250
Median salary % change year-on-year +8.00% +11.11%  
90% offered a salary of more than £45,000 £52,500 £41,750
10% offered a salary of more than £72,500 £80,000 £71,500
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 the City of London with a requirement for process and methodology skills.

Process & Methodology Skills
City of London
Permanent job vacancies with a requirement for process and methodology skills 4584 6380 8928
As % of all permanent IT job vacancies advertised in the City of London 90.34% 90.23% 87.76%
Number of salaries quoted 4184 5679 7513
Median salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.16% +4.34%  
90% offered a salary of more than £41,500 £42,500 £37,500
10% offered a salary of more than £87,500 £82,500 £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 the City of London

The job posting trend of jobs advertised in the City of 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 the City of London

Dimensional Modelling
Salary Trend in the City of London

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

Salary trend for Dimensional Modelling in the City of London

Dimensional Modelling
Salary Histogram in the City of London

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

Salary histogram for Dimensional Modelling in the City of London

Dimensional Modelling
Top 30 Related IT Skills in the City of London

For the 6 months to 24 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 City of London region with a requirement for Dimensional Modelling.

1 42 (97.67%) Business Intelligence
2 41 (95.35%) SQL
3 38 (88.37%) T-SQL
4 33 (76.74%) SQL Server Integration Services
5 31 (72.09%) SQL Server
6 30 (69.77%) Kimball Methodology
7 26 (60.47%) ETL
7 26 (60.47%) Visualisation
8 23 (53.49%) Cognos Business Intelligence
8 23 (53.49%) Cognos
8 23 (53.49%) Cognos Analysis Studio
8 23 (53.49%) Cognos Report Studio
8 23 (53.49%) Cognos Framework Manager
8 23 (53.49%) Cognos Event Studio
9 19 (44.19%) Agile Software Development
10 17 (39.53%) MDX
10 17 (39.53%) Data Warehouse
10 17 (39.53%) Analytics
11 16 (37.21%) SQL Server Management Studio (SSMS)
11 16 (37.21%) Mentoring
11 16 (37.21%) ETL Development
11 16 (37.21%) Cognos Planning
11 16 (37.21%) Technical Architecture
11 16 (37.21%) SQL Server Reporting Services
12 13 (30.23%) SQL Server Analysis Services
13 10 (23.26%) SQL Server 2008
13 10 (23.26%) SQL Server 2012
14 7 (16.28%) Microsoft Analysis Services
14 7 (16.28%) SQL Server 2005
15 6 (13.95%) Power BI

Dimensional Modelling
Top Related IT Skills in the City of 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 (11.63%) SharePoint
2 1 (2.33%) Apache Spark
Applications
1 6 (13.95%) MS Excel
Business Applications
1 23 (53.49%) Cognos Business Intelligence
2 16 (37.21%) Cognos Planning
Cloud Services
1 1 (2.33%) Amazon AWS
Database & Business Intelligence
1 33 (76.74%) SQL Server Integration Services
2 31 (72.09%) SQL Server
3 23 (53.49%) Cognos Analysis Studio
3 23 (53.49%) Cognos Event Studio
3 23 (53.49%) Cognos Framework Manager
3 23 (53.49%) Cognos Report Studio
4 17 (39.53%) Data Warehouse
5 16 (37.21%) SQL Server Reporting Services
6 13 (30.23%) SQL Server Analysis Services
7 10 (23.26%) SQL Server 2008
7 10 (23.26%) SQL Server 2012
8 7 (16.28%) Microsoft Analysis Services
8 7 (16.28%) SQL Server 2005
9 6 (13.95%) Power BI
10 3 (6.98%) SQL Server 2014
11 2 (4.65%) Big Data
11 2 (4.65%) OLAP
12 1 (2.33%) BusinessObjects
12 1 (2.33%) DataStage
12 1 (2.33%) Hadoop
Development Applications
1 16 (37.21%) SQL Server Management Studio (SSMS)
2 1 (2.33%) ERwin
General
1 5 (11.63%) Finance
2 4 (9.30%) Law
3 1 (2.33%) Legal
Job Titles
1 22 (51.16%) Business Intelligence Specialist
1 22 (51.16%) Cognos Specialist
2 14 (32.56%) Developer
3 8 (18.60%) Business Intelligence Developer
3 8 (18.60%) SSAS Developer
3 8 (18.60%) SSIS Developer
3 8 (18.60%) SSRS Developer
4 7 (16.28%) Report Specialist
5 6 (13.95%) SQL BI Developer
5 6 (13.95%) SQL Developer
5 6 (13.95%) SQL Server BI Developer
5 6 (13.95%) SQL Server Developer
6 5 (11.63%) Analyst
6 5 (11.63%) Business Intelligence Analyst
7 3 (6.98%) Senior Developer
8 2 (4.65%) MicroStrategy Developer
8 2 (4.65%) Power BI Developer
8 2 (4.65%) Senior MicroStrategy Developer
9 1 (2.33%) Business Intelligence Lead
9 1 (2.33%) SSRS Analyst
Libraries, Frameworks & Software Standards
1 17 (39.53%) MDX
Miscellaneous
1 2 (4.65%) Social Media
2 1 (2.33%) Analytical Skills
2 1 (2.33%) Derivative
2 1 (2.33%) Hedge funds
Processes & Methodologies
1 42 (97.67%) Business Intelligence
2 30 (69.77%) Kimball Methodology
3 26 (60.47%) ETL
3 26 (60.47%) Visualisation
4 19 (44.19%) Agile Software Development
5 17 (39.53%) Analytics
6 16 (37.21%) ETL Development
6 16 (37.21%) Mentoring
6 16 (37.21%) Technical Architecture
7 4 (9.30%) Data Modelling
8 3 (6.98%) E-Commerce
9 2 (4.65%) Practice Management
9 2 (4.65%) Stakeholder Management
10 1 (2.33%) Customer Segmentation
10 1 (2.33%) Data Architecture
10 1 (2.33%) Data Management
10 1 (2.33%) Data Stewardship
10 1 (2.33%) Logistics
10 1 (2.33%) TOGAF
10 1 (2.33%) UML
Programming Languages
1 41 (95.35%) SQL
2 38 (88.37%) T-SQL
3 5 (11.63%) R
4 1 (2.33%) Data Analysis Expressions (DAX)
4 1 (2.33%) Python
4 1 (2.33%) Scala
Quality Assurance & Compliance
1 1 (2.33%) Data Quality
Vendors
1 23 (53.49%) Cognos
2 6 (13.95%) Microsoft
3 2 (4.65%) MicroStrategy
4 1 (2.33%) Ab Initio
4 1 (2.33%) CA
4 1 (2.33%) IBM
4 1 (2.33%) Informatica
4 1 (2.33%) MapR
4 1 (2.33%) Oracle
4 1 (2.33%) Tableau
4 1 (2.33%) Teradata
City, London
Venturi
Salary: £40000 - £45000.00 per annum + extensive benefits
Posted: 2 days ago