The table below looks at the statistics for Dimensional Modelling skills in IT jobs advertised for the London region. Included is a guide to the salaries offered in IT jobs that have cited Dimensional Modelling over the 3 months to 20 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
20 Jan 2017
Same period 2016 Same period 2015
Dimensional Modelling
England / London
Rank 494 505 469
Rank change year-on-year
+11 -36
Permanent jobs citing Dimensional Modelling 80 141 175
As % of all permanent IT jobs located in London 0.24% 0.35% 0.42%
As % of the Processes & Methodologies category 0.27% 0.39% 0.49%
Number of salaries quoted 74 68 161
Median salary £58,500 £60,000 £55,000
Median salary % change year-on-year
-2.50% +9.09%
90% offered a salary of more than £46,500 £50,000 £45,000
10% offered a salary of more than £70,000 £72,500 £75,000
UK excluding London median salary £45,000 £45,000 £45,000

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the London region.

Processes & Methodologies Category
London
Permanent IT job ads with a match in the
Processes & Methodologies category
29815 35851 35661
As % of all permanent IT jobs located in London 89.08% 88.48% 86.35%
Number of salaries quoted 25171 30627 30107
Median salary £60,000 £57,500 £55,000
Median salary % change year-on-year
+4.34% +4.54%
90% offered a salary of more than £39,000 £40,000 £37,500
10% offered a salary of more than £85,000 £80,000 £85,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

Dimensional Modelling
Jobs Demand Trend in London

The demand trend of job ads across the London region citing Dimensional Modelling as a proportion of all IT jobs with a match in the Processes & Methodologies category.

Dimensional Modelling Jobs Demand Trend 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 across the London region.

Dimensional Modelling Salary Trend in London

Dimensional Modelling
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing Dimensional Modelling across the London region over the 3 months to 20 January 2017.

Dimensional Modelling Salary Histogram 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 20 January 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 +34 29 £56,250 -10.00%
Dimensional Modelling
England

Dimensional Modelling
Top 30 Related IT Skills in London

For the 6 months to 20 January 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 126 (78.75%) Business Intelligence
2 109 (68.13%) SQL
3 103 (64.38%) Data Warehouse
4 92 (57.50%) ETL
5 83 (51.88%) SQL Server
6 76 (47.50%) T-SQL
7 67 (41.88%) SQL Server Integration Services
8 66 (41.25%) Kimball Methodology
9 47 (29.38%) Finance
9 47 (29.38%) Agile Software Development
10 42 (26.25%) Analytics
11 40 (25.00%) Visualisation
12 39 (24.38%) SQL Server Reporting Services
13 37 (23.13%) Cognos
13 37 (23.13%) SQL Server Analysis Services
14 33 (20.63%) Oracle
15 31 (19.38%) Cognos Business Intelligence
16 30 (18.75%) OLAP
16 30 (18.75%) Data Modelling
16 30 (18.75%) SQL Server 2012
17 29 (18.13%) Cognos Analysis Studio
17 29 (18.13%) Cognos Report Studio
17 29 (18.13%) Cognos Framework Manager
17 29 (18.13%) Cognos Event Studio
18 28 (17.50%) ETL Development
19 27 (16.88%) Microsoft
19 27 (16.88%) MS Excel
20 26 (16.25%) PL/SQL
21 25 (15.63%) MDX
22 24 (15.00%) Big Data

Dimensional Modelling
Top Related 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 10 (6.25%) SharePoint
2 3 (1.88%) Apache Spark
2 3 (1.88%) SAS
3 1 (0.63%) Apache Airflow
3 1 (0.63%) Luigi
Applications
1 27 (16.88%) MS Excel
2 8 (5.00%) MS Visio
3 4 (2.50%) MS Office
Business Applications
1 31 (19.38%) Cognos Business Intelligence
2 16 (10.00%) Cognos Planning
3 8 (5.00%) Cognos TM1
Cloud Services
1 17 (10.63%) Amazon AWS
2 16 (10.00%) Amazon EMR
2 16 (10.00%) Amazon S3
3 4 (2.50%) Google Cloud Platform
4 3 (1.88%) Amazon EC2
5 1 (0.63%) Microsoft Azure
Communications & Networking
1 13 (8.13%) Internet
Database & Business Intelligence
1 103 (64.38%) Data Warehouse
2 83 (51.88%) SQL Server
3 67 (41.88%) SQL Server Integration Services
4 39 (24.38%) SQL Server Reporting Services
5 37 (23.13%) SQL Server Analysis Services
6 30 (18.75%) OLAP
6 30 (18.75%) SQL Server 2012
7 29 (18.13%) Cognos Analysis Studio
7 29 (18.13%) Cognos Event Studio
7 29 (18.13%) Cognos Framework Manager
7 29 (18.13%) Cognos Report Studio
8 24 (15.00%) Big Data
9 22 (13.75%) SQL Server 2005
9 22 (13.75%) SQL Server 2008
10 20 (12.50%) Hadoop
11 18 (11.25%) Microsoft Analysis Services
12 17 (10.63%) Amazon Redshift
12 17 (10.63%) BusinessObjects
13 14 (8.75%) QlikView
14 13 (8.13%) Oracle OLAP
Development Applications
1 16 (10.00%) SQL Server Management Studio (SSMS)
2 8 (5.00%) JIRA
3 6 (3.75%) Git (software)
3 6 (3.75%) MSBuild
4 5 (3.13%) ERwin
5 3 (1.88%) Talend Open Studio
5 3 (1.88%) Team Foundation Server
6 2 (1.25%) Visual Studio
General
1 47 (29.38%) Finance
2 17 (10.63%) Retail
3 16 (10.00%) Games
4 8 (5.00%) Marketing
5 5 (3.13%) Legal
6 3 (1.88%) Banking
6 3 (1.88%) Law
7 2 (1.25%) Music Industry
7 2 (1.25%) Telecoms
8 1 (0.63%) Advertising
8 1 (0.63%) Front Office
8 1 (0.63%) Publishing
Job Titles
1 64 (40.00%) Developer
2 40 (25.00%) Analyst
3 36 (22.50%) Business Intelligence Developer
4 25 (15.63%) Business Intelligence Specialist
4 25 (15.63%) Cognos Specialist
4 25 (15.63%) SQL Developer
5 23 (14.38%) Business Intelligence Analyst
6 19 (11.88%) Architect
7 18 (11.25%) Data Architect
8 17 (10.63%) SQL BI Developer
9 15 (9.38%) Big Data Architect
10 14 (8.75%) Data Warehouse Developer
11 13 (8.13%) Data Warehouse Architect
12 12 (7.50%) Consultant
12 12 (7.50%) MicroStrategy Developer
12 12 (7.50%) SSIS Developer
13 11 (6.88%) Analyst Developer
14 10 (6.25%) Business Developer
14 10 (6.25%) SSAS Developer
14 10 (6.25%) SSRS Developer
Libraries, Frameworks & Software Standards
1 25 (15.63%) MDX
2 15 (9.38%) Kafka
3 11 (6.88%) Oracle GoldenGate
3 11 (6.88%) Web Services
4 8 (5.00%) XML
5 4 (2.50%) .NET
6 1 (0.63%) ASP.NET
6 1 (0.63%) CSS
6 1 (0.63%) jQuery
6 1 (0.63%) XSLT
Miscellaneous
1 40 (25.00%) Visualisation
2 17 (10.63%) Analytical Skills
3 15 (9.38%) Online Games
4 11 (6.88%) Replication
5 9 (5.63%) Fintech
6 7 (4.38%) Data Extraction
7 6 (3.75%) Economics
7 6 (3.75%) Statistics
8 4 (2.50%) Management Information System
9 3 (1.88%) Data Structures
10 2 (1.25%) Enterprise Software
10 2 (1.25%) SWIFT
11 1 (0.63%) Computer Science
11 1 (0.63%) Data Integration
Processes & Methodologies
1 126 (78.75%) Business Intelligence
2 92 (57.50%) ETL
3 66 (41.25%) Kimball Methodology
4 47 (29.38%) Agile Software Development
5 42 (26.25%) Analytics
6 30 (18.75%) Data Modelling
7 28 (17.50%) ETL Development
8 23 (14.38%) Mentoring
9 17 (10.63%) Data Architecture
10 16 (10.00%) E-Commerce
10 16 (10.00%) Project Management
10 16 (10.00%) Technical Architecture
11 14 (8.75%) Translating Business Requirements
12 13 (8.13%) Scrum
13 11 (6.88%) Data Analysis
13 11 (6.88%) Performance Tuning
13 11 (6.88%) Use Case
14 10 (6.25%) Business Analytics
15 9 (5.63%) Data Transformation
15 9 (5.63%) Test Scripting
Programming Languages
1 109 (68.13%) SQL
2 76 (47.50%) T-SQL
3 26 (16.25%) PL/SQL
4 13 (8.13%) R
5 10 (6.25%) C#
6 7 (4.38%) Java
7 6 (3.75%) VBA
8 4 (2.50%) VB.NET
9 3 (1.88%) Data Analysis Expressions (DAX)
9 3 (1.88%) JavaScript
10 2 (1.25%) Python
11 1 (0.63%) Scala
11 1 (0.63%) VB
Qualifications
1 22 (13.75%) Degree
2 2 (1.25%) Microsoft Certification
Quality Assurance & Compliance
1 16 (10.00%) Data Quality
2 11 (6.88%) QA
3 2 (1.25%) SEPA
3 2 (1.25%) TARGET2
4 1 (0.63%) Solvency II
Vendors
1 37 (23.13%) Cognos
2 33 (20.63%) Oracle
3 27 (16.88%) Microsoft
4 13 (8.13%) MicroStrategy
5 12 (7.50%) SAP
6 11 (6.88%) Tableau
7 10 (6.25%) IBM
8 8 (5.00%) Anaplan
8 8 (5.00%) Hyperion
9 6 (3.75%) Informatica
9 6 (3.75%) Netezza
10 4 (2.50%) Google
11 3 (1.88%) Ab Initio
11 3 (1.88%) Alteryx
11 3 (1.88%) CA
11 3 (1.88%) MapR
11 3 (1.88%) Talend
11 3 (1.88%) Teradata
12 2 (1.25%) Trillium
13 1 (0.63%) Sybase
London
TDA Group
Salary: £55000 - £65000 per annum + +Excellent Benefits
Posted: 18 days ago