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

3 months to
27 Mar 2017
Same period 2016 Same period 2015
Dimensional Modelling
UK / England
Rank 732 713 718
Rank change year-on-year -19 +5  
Permanent jobs citing Dimensional Modelling 111 222 217
As % of all permanent IT jobs advertised in England 0.14% 0.23% 0.21%
As % of the Processes & Methodologies category 0.16% 0.26% 0.25%
Number of salaries quoted 86 149 180
Median salary £52,500 £50,000 £52,250
Median salary % change year-on-year +5.00% -4.30%  
90% offered a salary of more than £37,500 £37,500 £40,000
10% offered a salary of more than £68,750 £65,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 England with a requirement for process and methodology skills.

Process & Methodology Skills
England
Permanent job vacancies with a requirement for process and methodology skills 70819 85904 87927
As % of all permanent IT job vacancies advertised in England 89.12% 88.61% 86.98%
Number of salaries quoted 58715 71854 71888
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £32,500 £32,500 £31,500
10% offered a salary of more than £77,500 £75,000 £77,500
UK excluding London median salary £45,000 £45,000 £43,000
% change year-on-year - +4.65%  

Dimensional Modelling
Job Vacancy Trend in England

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

Dimensional Modelling
Salary Trend in England

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

Salary trend for Dimensional Modelling in England

Dimensional Modelling
Salary Histogram in England

The salary distribution of IT jobs citing Dimensional Modelling in England over the 3 months to 27 March 2017.

Salary histogram for Dimensional Modelling in England

Dimensional Modelling
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Dimensional Modelling within the England region over the 3 months to 27 March 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
London +21 62 £61,250 +6.52% 7
Yorkshire +15 8 £32,500 -13.33%
East of England +20 7 £41,000 -21.90% 3
South East +37 6 £50,000 +11.11% 1
South West +28 6 £37,500 - 1
East Midlands +1 5 £45,000 -12.19% 1
North West - 4 £47,500 - 3
West Midlands +16 3 £40,000 -15.78% 2
Dimensional Modelling
UK

Dimensional Modelling
Top 30 Related IT Skills in England

For the 6 months to 27 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 England region with a requirement for Dimensional Modelling.

1 201 (81.38%) Business Intelligence
2 191 (77.33%) Data Warehouse
3 187 (75.71%) SQL
4 149 (60.32%) ETL
5 136 (55.06%) SQL Server
6 128 (51.82%) SQL Server Integration Services
7 111 (44.94%) T-SQL
8 99 (40.08%) SQL Server Reporting Services
9 97 (39.27%) Kimball Methodology
10 83 (33.60%) SQL Server Analysis Services
11 81 (32.79%) Agile Software Development
12 75 (30.36%) Data Modelling
13 70 (28.34%) OLAP
14 69 (27.94%) Microsoft
15 64 (25.91%) Finance
16 62 (25.10%) Oracle
17 53 (21.46%) Visualisation
18 50 (20.24%) Analytics
19 47 (19.03%) Cognos
20 46 (18.62%) Power BI
21 44 (17.81%) PL/SQL
22 41 (16.60%) MDX
23 35 (14.17%) MS Excel
24 32 (12.96%) ETL Development
25 31 (12.55%) BusinessObjects
25 31 (12.55%) Hadoop
26 29 (11.74%) Cognos Business Intelligence
26 29 (11.74%) MySQL
26 29 (11.74%) Big Data
27 27 (10.93%) OLAP Cube

Dimensional Modelling
Top Related IT Skills in England 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 18 (7.29%) SharePoint
2 10 (4.05%) SAS
3 1 (0.40%) Apache Spark
Applications
1 35 (14.17%) MS Excel
2 2 (0.81%) MS Office
3 1 (0.40%) MS PowerPoint
3 1 (0.40%) MS Visio
3 1 (0.40%) Spreadsheet
Business Applications
1 29 (11.74%) Cognos Business Intelligence
2 16 (6.48%) Cognos Planning
3 2 (0.81%) Cognos TM1
3 2 (0.81%) Dynamics CRM
4 1 (0.40%) SAP BPC
4 1 (0.40%) SAP R/3
Cloud Services
1 15 (6.07%) Amazon AWS
2 8 (3.24%) Microsoft Azure
3 7 (2.83%) Amazon EMR
4 6 (2.43%) Amazon S3
5 4 (1.62%) GitHub
5 4 (1.62%) Google Cloud Platform
6 3 (1.21%) SaaS
7 1 (0.40%) Amazon EC2
7 1 (0.40%) AWS Lambda
Communications & Networking
1 6 (2.43%) Internet
Database & Business Intelligence
1 191 (77.33%) Data Warehouse
2 136 (55.06%) SQL Server
3 128 (51.82%) SQL Server Integration Services
4 99 (40.08%) SQL Server Reporting Services
5 83 (33.60%) SQL Server Analysis Services
6 70 (28.34%) OLAP
7 46 (18.62%) Power BI
8 31 (12.55%) BusinessObjects
8 31 (12.55%) Hadoop
9 29 (11.74%) Big Data
9 29 (11.74%) MySQL
10 27 (10.93%) OLAP Cube
11 26 (10.53%) Cognos Analysis Studio
11 26 (10.53%) Cognos Event Studio
11 26 (10.53%) Cognos Framework Manager
11 26 (10.53%) Cognos Report Studio
11 26 (10.53%) Microsoft Analysis Services
11 26 (10.53%) Oracle OLAP
12 25 (10.12%) SQL Server 2014
13 23 (9.31%) SQL Server 2012
Development Applications
1 19 (7.69%) SQL Server Management Studio (SSMS)
2 14 (5.67%) JIRA
3 11 (4.45%) Talend Open Studio
4 7 (2.83%) MSBuild
4 7 (2.83%) Team Foundation Server
5 6 (2.43%) Git (software)
6 3 (1.21%) ERwin
General
1 64 (25.91%) Finance
2 26 (10.53%) Retail
3 15 (6.07%) Marketing
4 11 (4.45%) Local Government
5 10 (4.05%) Games
6 9 (3.64%) Banking
7 7 (2.83%) Legal
7 7 (2.83%) Publishing
8 5 (2.02%) Law
9 4 (1.62%) Retail Banking
10 3 (1.21%) Advertising
10 3 (1.21%) Billing
10 3 (1.21%) Financial Institution
11 2 (0.81%) Manufacturing
11 2 (0.81%) Music Industry
11 2 (0.81%) Telecoms
12 1 (0.40%) Front Office
Job Titles
1 117 (47.37%) Developer
2 64 (25.91%) Business Intelligence Developer
3 50 (20.24%) Analyst
4 46 (18.62%) SQL Developer
5 31 (12.55%) Business Intelligence Analyst
6 29 (11.74%) Business Developer
7 24 (9.72%) Business Intelligence Specialist
7 24 (9.72%) Cognos Specialist
7 24 (9.72%) SSRS Developer
8 23 (9.31%) Data Warehouse Developer
9 21 (8.50%) SQL BI Developer
9 21 (8.50%) SSIS Developer
10 20 (8.10%) Architect
11 18 (7.29%) Consultant
11 18 (7.29%) SSAS Developer
12 17 (6.88%) Data Architect
13 16 (6.48%) Business Analyst
14 15 (6.07%) Senior Developer
14 15 (6.07%) SQL Server Developer
15 14 (5.67%) Oracle Developer
Libraries, Frameworks & Software Standards
1 41 (16.60%) MDX
2 15 (6.07%) Oracle GoldenGate
3 12 (4.86%) .NET
4 10 (4.05%) Web Services
4 10 (4.05%) XML
5 7 (2.83%) Kafka
6 2 (0.81%) CSS
6 2 (0.81%) HTML
7 1 (0.40%) JMS
7 1 (0.40%) RabbitMQ
7 1 (0.40%) SAP XI
Miscellaneous
1 21 (8.50%) Analytical Skills
2 18 (7.29%) Fintech
3 13 (5.26%) Management Information System
4 10 (4.05%) Replication
5 9 (3.64%) Computer Science
6 8 (3.24%) Online Games
7 3 (1.21%) Data Structures
7 3 (1.21%) e-Learning
8 2 (0.81%) Data Protection Act
8 2 (0.81%) Enterprise Software
8 2 (0.81%) Social Media
8 2 (0.81%) SWIFT
9 1 (0.40%) Derivative
9 1 (0.40%) FMCG
9 1 (0.40%) Hedge funds
9 1 (0.40%) Reinsurance
Operating Systems
1 11 (4.45%) Windows
2 5 (2.02%) Linux
2 5 (2.02%) Windows Server 2012
3 2 (0.81%) Unix
Processes & Methodologies
1 201 (81.38%) Business Intelligence
2 149 (60.32%) ETL
3 97 (39.27%) Kimball Methodology
4 81 (32.79%) Agile Software Development
5 75 (30.36%) Data Modelling
6 53 (21.46%) Visualisation
7 50 (20.24%) Analytics
8 32 (12.96%) ETL Development
9 27 (10.93%) Scrum
10 24 (9.72%) Mentoring
11 23 (9.31%) Performance Tuning
12 21 (8.50%) Data Analysis
13 16 (6.48%) Technical Architecture
14 15 (6.07%) Data Transformation
14 15 (6.07%) Data Visualisation
15 14 (5.67%) Statistics
16 13 (5.26%) Data Architecture
16 13 (5.26%) E-Commerce
17 12 (4.86%) Kanban
18 11 (4.45%) Data Analytics
Programming Languages
1 187 (75.71%) SQL
2 111 (44.94%) T-SQL
3 44 (17.81%) PL/SQL
4 18 (7.29%) C#
4 18 (7.29%) R
5 9 (3.64%) VB.NET
5 9 (3.64%) VBA
6 8 (3.24%) Java
7 7 (2.83%) Data Analysis Expressions (DAX)
8 5 (2.02%) VB
9 4 (1.62%) JavaScript
9 4 (1.62%) Python
10 2 (0.81%) Scala
11 1 (0.40%) Clojure
11 1 (0.40%) Ruby
Qualifications
1 21 (8.50%) Degree
2 3 (1.21%) Microsoft Certification
3 1 (0.40%) CBAP
3 1 (0.40%) ISEB
3 1 (0.40%) MCSE
Quality Assurance & Compliance
1 24 (9.72%) Data Quality
2 16 (6.48%) QA
3 3 (1.21%) IFRS
3 3 (1.21%) IFRS 9
4 2 (0.81%) SEPA
4 2 (0.81%) TARGET2
5 1 (0.40%) Solvency II
Systems Management
1 4 (1.62%) Puppet
Vendors
1 69 (27.94%) Microsoft
2 62 (25.10%) Oracle
3 47 (19.03%) Cognos
4 25 (10.12%) Tableau
5 24 (9.72%) SAP
6 16 (6.48%) Informatica
7 11 (4.45%) Talend
8 8 (3.24%) Netezza
9 7 (2.83%) MicroStrategy
10 5 (2.02%) IBM
10 5 (2.02%) Vertica
11 4 (1.62%) Google
12 3 (1.21%) Alteryx
13 2 (0.81%) Hortonworks
13 2 (0.81%) Trillium
14 1 (0.40%) Ab Initio
14 1 (0.40%) CA
14 1 (0.40%) Hyperion
14 1 (0.40%) Sybase
14 1 (0.40%) Teradata
West London
Data Idols
Salary: From £50,000 to £55,000 per annum + Bonus & Benefits
Posted: 2 hours ago
Worcester, Worcestershire
Erin Associates
Salary: £40000 per annum + Bonus & excellent benefits
Posted: 5 hours ago
West London
Total Recruitment Specialists Limited / TRG / Total recruitment group
Salary: £50000 Per Annum Plus excellent benefits
Posted: Yesterday
Chester, Cheshire
Asset Resourcing Ltd
Salary: £30000 - £40000 per annum + bonus + benefits
Posted: 4 days ago
Huntingdon, Cambridgeshire
Cambridge DT
Salary: £35000.00 - £41000.00 per annum
Posted: 4 days ago
North West London
Hudson IT
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: 3 days ago
City, London
Venturi
Salary: £40000 - £45000.00 per annum + extensive benefits
Posted: 5 days ago
Central London / West End
The Workshop
Posted: 3 days ago
Birmingham, West Midlands (County)
Erin Associates
Salary: £40000 per annum + Bonus & excellent benefits
Posted: 4 days ago
Central London / West End
The Workshop
Posted: 6 days ago
Sussex
Clearwater People Solutions Ltd
Posted: 12 days ago
Cambridge
Edward Carter Solutions
Salary: £41000 per annum + Bonus and excellent benefits
Posted: 11 days ago
Bristol
BJSS
Salary: £30,000 - £45,000 per year
Posted: 27 days ago
Manchester
Bupa
Posted: 12 days ago
London
CPS Group Limited
Salary: car, pension, bonus
Posted: 20 days ago