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

Dimensional Modelling
UK / England
3 months to
22 Jun 2017
Same period 2016 Same period 2015
Rank 672 710 748
Rank change year-on-year +38 +38  
Permanent jobs citing Dimensional Modelling 183 197 210
As % of all permanent IT jobs advertised in England 0.22% 0.21% 0.20%
As % of the Processes & Methodologies category 0.24% 0.24% 0.23%
Number of salaries quoted 118 130 155
Median salary £55,000 £53,750 £52,500
Median salary % change year-on-year +2.32% +2.38%  
90% offered a salary of more than £42,050 £36,000 £36,500
10% offered a salary of more than £70,000 £75,000 £80,000
UK excluding London median salary £42,500 £44,000 £45,000
% change year-on-year -3.40% -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 England with a requirement for process and methodology skills.

Process & Methodology Skills
England
Permanent job vacancies with a requirement for process and methodology skills 74870 82511 91444
As % of all permanent IT job vacancies advertised in England 89.69% 89.04% 87.93%
Number of salaries quoted 60781 69796 75582
Median salary £51,500 £50,000 £50,000
Median salary % change year-on-year +3.00% -  
90% offered a salary of more than £32,500 £32,500 £31,888
10% offered a salary of more than £80,000 £75,000 £77,500
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year - +2.27%  

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 22 June 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 22 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
London +45 124 £65,000 +8.33% 3
West Midlands -3 17 £42,500 +6.25% 4
North West -33 11 £42,500 +3.03% 3
East of England +1 10 £41,000 +9.33% 2
East Midlands +31 7 £45,000 -15.88% 2
Midlands - 6 £60,000 - 6
Yorkshire +8 5 £45,000 -5.26%
South East +20 1 £47,500 -26.92% 6
South West 0 1 £100,000 +177.77%
Dimensional Modelling
UK

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

1 241 (84.27%) Data Warehouse
2 235 (82.17%) SQL
3 219 (76.57%) Business Intelligence
4 173 (60.49%) ETL
5 163 (56.99%) SQL Server
6 145 (50.70%) SQL Server Integration Services
7 116 (40.56%) Kimball Methodology
8 111 (38.81%) SQL Server Reporting Services
9 98 (34.27%) OLAP
10 97 (33.92%) SQL Server Analysis Services
11 92 (32.17%) Oracle
12 90 (31.47%) Data Modelling
13 84 (29.37%) T-SQL
14 78 (27.27%) Microsoft
15 74 (25.87%) Finance
16 72 (25.17%) Visualisation
17 68 (23.78%) PL/SQL
17 68 (23.78%) Agile Software Development
18 61 (21.33%) OLAP Cube
19 57 (19.93%) Power BI
20 53 (18.53%) Data Visualisation
21 52 (18.18%) MySQL
22 48 (16.78%) BusinessObjects
22 48 (16.78%) Analytics
22 48 (16.78%) Tableau
23 44 (15.38%) Data Quality
24 42 (14.69%) Performance Tuning
25 41 (14.34%) Relational Database
26 38 (13.29%) Degree
27 35 (12.24%) Marketing

Dimensional Modelling
Co-occurring 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 (6.29%) SAS
2 17 (5.94%) SharePoint
3 3 (1.05%) JBoss
3 3 (1.05%) Tomcat
3 3 (1.05%) WebLogic
3 3 (1.05%) WebSphere
4 2 (0.70%) Apache Pig
5 1 (0.35%) Apache Spark
Applications
1 28 (9.79%) Microsoft Excel
2 3 (1.05%) Microsoft PowerPoint
2 3 (1.05%) Spreadsheet
3 2 (0.70%) MS Visio
3 2 (0.70%) SPSS
4 1 (0.35%) Microsoft Office
Business Applications
1 6 (2.10%) SAP R/3
2 4 (1.40%) Dynamics GP
3 3 (1.05%) Dynamics AX
4 1 (0.35%) Cognos Business Intelligence
4 1 (0.35%) Cognos TM1
4 1 (0.35%) SAP BPC
Cloud Services
1 23 (8.04%) Amazon AWS
2 12 (4.20%) Microsoft Azure
3 3 (1.05%) Amazon EC2
3 3 (1.05%) Amazon EMR
4 2 (0.70%) Cloud Computing
4 2 (0.70%) Office 365
5 1 (0.35%) AWS Lambda
5 1 (0.35%) Azure Data Factory
5 1 (0.35%) Dynamics 365
5 1 (0.35%) IaaS
5 1 (0.35%) SaaS
Communications & Networking
1 3 (1.05%) HTTP
1 3 (1.05%) LDAP
1 3 (1.05%) SSL
2 1 (0.35%) Broadband
Database & Business Intelligence
1 241 (84.27%) Data Warehouse
2 163 (56.99%) SQL Server
3 145 (50.70%) SQL Server Integration Services
4 111 (38.81%) SQL Server Reporting Services
5 98 (34.27%) OLAP
6 97 (33.92%) SQL Server Analysis Services
7 61 (21.33%) OLAP Cube
8 57 (19.93%) Power BI
9 52 (18.18%) MySQL
10 48 (16.78%) BusinessObjects
11 41 (14.34%) Relational Database
12 35 (12.24%) SQL Server 2012
13 33 (11.54%) Hadoop
13 33 (11.54%) Oracle Database
13 33 (11.54%) Oracle OLAP
14 31 (10.84%) SQL Server 2008
15 29 (10.14%) Big Data
15 29 (10.14%) Oracle ODI
16 28 (9.79%) Star Schema
17 25 (8.74%) SQL Server 2014
Development Applications
1 15 (5.24%) Talend Open Studio
2 11 (3.85%) JIRA
3 7 (2.45%) Team Foundation Server
4 3 (1.05%) ERwin
5 2 (0.70%) Octopus Deploy
5 2 (0.70%) SQL Server Management Studio (SSMS)
5 2 (0.70%) TeamCity
6 1 (0.35%) MSBuild
General
1 74 (25.87%) Finance
2 35 (12.24%) Marketing
3 25 (8.74%) Banking
4 23 (8.04%) Retail
5 17 (5.94%) Publishing
6 14 (4.90%) Front Office
7 11 (3.85%) Legal
8 10 (3.50%) Local Government
9 4 (1.40%) Back Office
9 4 (1.40%) Retail Banking
10 3 (1.05%) Financial Institution
10 3 (1.05%) Games
10 3 (1.05%) Law
10 3 (1.05%) Telecoms
11 2 (0.70%) Advertising
12 1 (0.35%) Billing
Job Titles
1 157 (54.90%) Developer
2 81 (28.32%) Business Intelligence Developer
3 65 (22.73%) SQL Developer
4 46 (16.08%) Analyst
5 45 (15.73%) Data Warehouse Developer
6 33 (11.54%) SQL BI Developer
7 31 (10.84%) Business Developer
8 28 (9.79%) Oracle Developer
9 26 (9.09%) Consultant
10 24 (8.39%) Senior Developer
11 23 (8.04%) SSAS Developer
11 23 (8.04%) SSRS Developer
12 21 (7.34%) Business Intelligence Analyst
13 18 (6.29%) Business Analyst
13 18 (6.29%) Oracle Data Warehouse Developer
14 17 (5.94%) Data Analyst
14 17 (5.94%) SSIS Developer
15 16 (5.59%) Business Consultant
15 16 (5.59%) Data Business Analyst
15 16 (5.59%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 35 (12.24%) MDX
2 21 (7.34%) Oracle GoldenGate
3 17 (5.94%) XML
4 16 (5.59%) Web Services
5 10 (3.50%) .NET
6 9 (3.15%) HTML
7 6 (2.10%) CSS
8 3 (1.05%) JSP
8 3 (1.05%) Spring
8 3 (1.05%) Spring Security
8 3 (1.05%) XSLT
9 2 (0.70%) JMS
9 2 (0.70%) Kafka
9 2 (0.70%) RabbitMQ
9 2 (0.70%) SAP XI
10 1 (0.35%) ODBC
Miscellaneous
1 25 (8.74%) Analytical Skills
2 23 (8.04%) Computer Science
3 17 (5.94%) Fintech
4 13 (4.55%) Management Information System
4 13 (4.55%) Replication
5 9 (3.15%) Data Protection Act
5 9 (3.15%) Greenfield Project
5 9 (3.15%) Social Media
6 5 (1.75%) FMCG
7 4 (1.40%) Data Structures
8 3 (1.05%) e-Learning
9 2 (0.70%) Derivative
9 2 (0.70%) Hedge funds
9 2 (0.70%) Linux Command Line
10 1 (0.35%) Clustering
10 1 (0.35%) Enterprise Software
10 1 (0.35%) NHS
10 1 (0.35%) Reinsurance
Operating Systems
1 22 (7.69%) Linux
2 18 (6.29%) Windows
3 7 (2.45%) Unix
4 6 (2.10%) Red Hat Enterprise Linux
5 3 (1.05%) Solaris
Processes & Methodologies
1 219 (76.57%) Business Intelligence
2 173 (60.49%) ETL
3 116 (40.56%) Kimball Methodology
4 90 (31.47%) Data Modelling
5 72 (25.17%) Visualisation
6 68 (23.78%) Agile Software Development
7 53 (18.53%) Data Visualisation
8 48 (16.78%) Analytics
9 42 (14.69%) Performance Tuning
10 34 (11.89%) Data Management
11 30 (10.49%) Data Governance
12 28 (9.79%) ETL Development
13 25 (8.74%) Data Analytics
14 23 (8.04%) Data Integration
15 22 (7.69%) Scrum
16 20 (6.99%) Statistics
17 19 (6.64%) Migration
18 18 (6.29%) Kanban
18 18 (6.29%) Mentoring
19 15 (5.24%) Data Transformation
Programming Languages
1 235 (82.17%) SQL
2 84 (29.37%) T-SQL
3 68 (23.78%) PL/SQL
4 16 (5.59%) Java
5 15 (5.24%) C#
6 14 (4.90%) VBA
7 11 (3.85%) VB
8 10 (3.50%) R
9 7 (2.45%) Python
9 7 (2.45%) VB.NET
10 5 (1.75%) Data Analysis Expressions (DAX)
11 3 (1.05%) JavaScript
12 2 (0.70%) ANSI SQL
12 2 (0.70%) AWK
12 2 (0.70%) Clojure
12 2 (0.70%) Ruby
12 2 (0.70%) Scala
12 2 (0.70%) sed
Qualifications
1 38 (13.29%) Degree
2 6 (2.10%) Computer Science Degree
3 2 (0.70%) CBAP
3 2 (0.70%) ISEB
3 2 (0.70%) Master's Degree
4 1 (0.35%) MCSE
4 1 (0.35%) Microsoft Certification
Quality Assurance & Compliance
1 44 (15.38%) Data Quality
2 25 (8.74%) QA
3 7 (2.45%) GDPR
3 7 (2.45%) ISO/IEC 27001
3 7 (2.45%) PCI DSS
4 3 (1.05%) IFRS
4 3 (1.05%) IFRS 9
System Software
1 3 (1.05%) Active Directory
2 2 (0.70%) Apache Flume
Vendors
1 92 (32.17%) Oracle
2 78 (27.27%) Microsoft
3 48 (16.78%) Tableau
4 32 (11.19%) SAP
5 25 (8.74%) Informatica
6 15 (5.24%) Cognos
6 15 (5.24%) Talend
7 14 (4.90%) Vertica
8 7 (2.45%) Cognizant
8 7 (2.45%) Jaspersoft
9 6 (2.10%) IBM
9 6 (2.10%) Logi
9 6 (2.10%) Logi Analytics
9 6 (2.10%) Teradata
10 5 (1.75%) MicroStrategy
11 3 (1.05%) Ab Initio
11 3 (1.05%) CA
11 3 (1.05%) JD Edwards
11 3 (1.05%) MapR
11 3 (1.05%) Netezza
Kent
Client Server
Salary: £40k to £45k + benefits
Posted: 13 hours ago
Birmingham, West Midlands (County)
Colossus Associates
Salary: £40000 - £60000 per annum, Benefits 0
Posted: 5 hours ago
Lichfield, Staffordshire
Computer People
Salary: £30000.00 - £40000.00 per annum
Posted: 5 hours ago
Manchester, Lancashire
Peninsula
Salary: £30k - 40k per year + Benefits
Posted: Yesterday
Lichfield, Staffordshire
HAYS INFORMATION TECHNOLOGY
Salary: £30000.00 - £40000.00 per annum
Posted: 3 days ago
West London
Profile 29 Limited
Salary: From £80,000 to £100,000 per annum + benefits
Posted: 2 days ago
Northampton, Northamptonshire
St Andrew's Healthcare
Salary: £41098 - £58711 per annum, Benefits 38 days holiday, pension & package
Posted: 6 days ago
Nottingham, Nottinghamshire
Linking Humans Limited
Salary: Up to £49,000 per annum plus 10% bonus, pension, Bupa,25 days holiday
Posted: 3 days ago
Kent
Client Server
Salary: £40000 - £45000 per annum + benefits
Posted: 15 days ago
Coventry, West Midlands (County)
The Coventry Building Society
Salary: £51,220 - 76,830 per year + Benefits
Posted: 17 days ago
Sutton, Surrey
Reed Business Information Ltd
Salary: From £65,000 to £70,000 per annum + bonus & extensive benefits
Posted: 17 days ago
Letchworth Garden City, Hertfordshire
*Willmott Dixon Holdings Limited
Posted: 23 days ago