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

Dimensional Modelling
UK
3 months to
23 Apr 2017
Same period 2016 Same period 2015
Rank 708 732 759
Rank change year-on-year +24 +27  
Permanent jobs citing Dimensional Modelling 157 230 227
As % of all permanent IT jobs advertised in the UK 0.18% 0.22% 0.20%
As % of the Processes & Methodologies category 0.20% 0.25% 0.24%
Number of salaries quoted 110 154 184
Median salary £47,500 £53,500 £50,000
Median salary % change year-on-year -11.21% +7.00%  
90% offered a salary of more than £37,500 £37,500 £36,800
10% offered a salary of more than £67,750 £65,000 £70,000
UK excluding London median salary £42,500 £47,500 £45,000
% change year-on-year -10.52% +5.55%  

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 with a requirement for process and methodology skills.

Process & Methodology Skills
UK
Permanent job vacancies with a requirement for process and methodology skills 77598 92546 96554
As % of all permanent IT job vacancies advertised in the UK 89.30% 88.73% 87.12%
Number of salaries quoted 63772 76871 78031
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £32,500 £32,500 £32,000
10% offered a salary of more than £77,500 £75,000 £75,000
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year - +2.27%  

Dimensional Modelling
Job Vacancy Trend

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

Dimensional Modelling
Salary Trend

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

Salary trend for Dimensional Modelling in the UK

Dimensional Modelling
Salary Histogram

The salary distribution of IT jobs citing Dimensional Modelling over the 3 months to 23 April 2017.

Salary histogram for Dimensional Modelling in the UK

Dimensional Modelling
Top 30 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Dimensional Modelling within the UK over the 3 months to 23 April 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
England +24 148 £47,500 -13.63% 24
London +17 85 £60,000 - 12
City of London +39 16 £52,500 -14.28% 1
Yorkshire +35 11 £32,500 - 1
East of England +18 11 £41,000 -23.72% 1
West Midlands +5 9 £42,500 -5.55% 4
North West - 8 £43,500 - 2
East Midlands +12 7 £45,000 -14.28% 1
Northampton +16 6 £45,000 -14.28% 1
South West +8 6 £37,500 -
Northamptonshire +7 6 £45,000 -14.28% 1
Cambridgeshire - 6 £41,000 -
North Yorkshire +15 5 £32,500 -23.52%
York +15 5 £32,500 -31.57%
Cambridge - 4 £41,000 -
Bristol - 4 £37,500 -
Liverpool - 4 £40,000 -
Manchester - 4 £47,500 - 1
Merseyside - 4 £40,000 -
South East +42 3 £50,000 +11.11% 3
West Bromwich - 3 £42,500 - 1
Sheffield - 3 £35,000 -
South Yorkshire - 3 £35,000 -
Berkshire +29 2 £50,000 +53.84% 1
Glasgow +13 2 £40,000 -23.80%
Hertfordshire +8 2 - - 1
Scotland +7 2 £40,000 -23.80%
Wales +3 2 £46,250 +59.48%
Letchworth - 2 - -
Leeds - 2 £43,750 -

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

1 224 (80.58%) Business Intelligence
2 223 (80.22%) Data Warehouse
3 214 (76.98%) SQL
4 168 (60.43%) ETL
5 150 (53.96%) SQL Server
6 137 (49.28%) SQL Server Integration Services
7 106 (38.13%) T-SQL
8 101 (36.33%) SQL Server Reporting Services
9 99 (35.61%) Kimball Methodology
10 86 (30.94%) Data Modelling
11 84 (30.22%) SQL Server Analysis Services
12 83 (29.86%) Oracle
13 78 (28.06%) Agile Software Development
14 76 (27.34%) Microsoft
15 72 (25.90%) OLAP
16 69 (24.82%) Visualisation
17 65 (23.38%) Finance
18 56 (20.14%) PL/SQL
19 51 (18.35%) Analytics
20 49 (17.63%) Data Visualisation
20 49 (17.63%) Power BI
21 47 (16.91%) BusinessObjects
22 41 (14.75%) Cognos
23 38 (13.67%) MySQL
23 38 (13.67%) Hadoop
24 37 (13.31%) Data Quality
25 35 (12.59%) Tableau
26 34 (12.23%) ETL Development
27 33 (11.87%) MDX
27 33 (11.87%) SAP

Dimensional Modelling
Co-occurring IT Skills 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.47%) SAS
2 16 (5.76%) SharePoint
3 1 (0.36%) Apache Spark
Applications
1 32 (11.51%) Microsoft Excel
2 3 (1.08%) Microsoft PowerPoint
3 2 (0.72%) Microsoft Office
3 2 (0.72%) MS Visio
3 2 (0.72%) Spreadsheet
Business Applications
1 24 (8.63%) Cognos Business Intelligence
2 14 (5.04%) Cognos Planning
3 4 (1.44%) SAP R/3
4 1 (0.36%) Cognos TM1
4 1 (0.36%) Dynamics AX
4 1 (0.36%) SAP BPC
Cloud Services
1 20 (7.19%) Amazon AWS
2 10 (3.60%) Microsoft Azure
3 5 (1.80%) Amazon EMR
4 4 (1.44%) Amazon S3
4 4 (1.44%) Google Cloud Platform
5 2 (0.72%) GitHub
5 2 (0.72%) SaaS
6 1 (0.36%) Amazon EC2
6 1 (0.36%) AWS Lambda
6 1 (0.36%) Dynamics 365
Communications & Networking
1 4 (1.44%) Internet
2 1 (0.36%) Broadband
Database & Business Intelligence
1 223 (80.22%) Data Warehouse
2 150 (53.96%) SQL Server
3 137 (49.28%) SQL Server Integration Services
4 101 (36.33%) SQL Server Reporting Services
5 84 (30.22%) SQL Server Analysis Services
6 72 (25.90%) OLAP
7 49 (17.63%) Power BI
8 47 (16.91%) BusinessObjects
9 38 (13.67%) Hadoop
9 38 (13.67%) MySQL
10 32 (11.51%) Relational Database
11 31 (11.15%) Big Data
11 31 (11.15%) OLAP Cube
12 26 (9.35%) Oracle OLAP
13 23 (8.27%) Oracle ODI
13 23 (8.27%) SQL Server 2012
13 23 (8.27%) Star Schema
14 22 (7.91%) Cognos Analysis Studio
14 22 (7.91%) Cognos Framework Manager
14 22 (7.91%) Cognos Report Studio
Development Applications
1 17 (6.12%) SQL Server Management Studio (SSMS)
2 13 (4.68%) JIRA
2 13 (4.68%) Talend Open Studio
3 8 (2.88%) Team Foundation Server
4 6 (2.16%) MSBuild
5 5 (1.80%) Git (software)
6 4 (1.44%) ERwin
7 1 (0.36%) VSS/SourceSafe
General
1 65 (23.38%) Finance
2 24 (8.63%) Retail
3 17 (6.12%) Marketing
4 11 (3.96%) Banking
4 11 (3.96%) Local Government
4 11 (3.96%) Publishing
5 7 (2.52%) Games
5 7 (2.52%) Legal
6 5 (1.80%) Law
7 4 (1.44%) Retail Banking
8 3 (1.08%) Financial Institution
9 2 (0.72%) Advertising
9 2 (0.72%) Billing
9 2 (0.72%) Music Industry
10 1 (0.36%) Front Office
10 1 (0.36%) Manufacturing
10 1 (0.36%) Telecoms
Job Titles
1 131 (47.12%) Developer
2 67 (24.10%) Business Intelligence Developer
3 55 (19.78%) Analyst
4 45 (16.19%) SQL Developer
5 34 (12.23%) Data Warehouse Developer
6 33 (11.87%) Business Intelligence Analyst
7 26 (9.35%) Business Developer
8 24 (8.63%) SSRS Developer
9 23 (8.27%) Architect
9 23 (8.27%) Oracle Developer
10 21 (7.55%) Business Intelligence Specialist
10 21 (7.55%) Consultant
10 21 (7.55%) SSAS Developer
11 20 (7.19%) Cognos Specialist
11 20 (7.19%) Data Architect
11 20 (7.19%) SQL BI Developer
11 20 (7.19%) SSIS Developer
12 18 (6.47%) Senior Developer
13 17 (6.12%) Business Analyst
14 13 (4.68%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 33 (11.87%) MDX
2 16 (5.76%) Oracle GoldenGate
2 16 (5.76%) XML
3 10 (3.60%) .NET
3 10 (3.60%) Web Services
4 6 (2.16%) Kafka
5 4 (1.44%) EDIFACT
5 4 (1.44%) iXBRL
5 4 (1.44%) JSON
5 4 (1.44%) RESTful
5 4 (1.44%) SOAP
6 2 (0.72%) CSS
6 2 (0.72%) HTML
6 2 (0.72%) JMS
6 2 (0.72%) RabbitMQ
6 2 (0.72%) SAP XI
7 1 (0.36%) ODBC
Miscellaneous
1 23 (8.27%) Analytical Skills
2 17 (6.12%) Fintech
3 15 (5.40%) Computer Science
4 12 (4.32%) Management Information System
5 10 (3.60%) Replication
6 9 (3.24%) Greenfield Project
7 4 (1.44%) FMCG
7 4 (1.44%) Online Games
7 4 (1.44%) Reference Data
8 3 (1.08%) Data Structures
8 3 (1.08%) e-Learning
9 2 (0.72%) Data Protection Act
9 2 (0.72%) Derivative
9 2 (0.72%) Hedge funds
9 2 (0.72%) Linux Command Line
9 2 (0.72%) Social Media
9 2 (0.72%) SWIFT
10 1 (0.36%) Clustering
10 1 (0.36%) Reinsurance
Operating Systems
1 15 (5.40%) Windows
2 11 (3.96%) Linux
3 6 (2.16%) Unix
4 4 (1.44%) Windows Server 2012
Processes & Methodologies
1 224 (80.58%) Business Intelligence
2 168 (60.43%) ETL
3 99 (35.61%) Kimball Methodology
4 86 (30.94%) Data Modelling
5 78 (28.06%) Agile Software Development
6 69 (24.82%) Visualisation
7 51 (18.35%) Analytics
8 49 (17.63%) Data Visualisation
9 34 (12.23%) ETL Development
10 28 (10.07%) Data Management
11 27 (9.71%) Mentoring
11 27 (9.71%) Performance Tuning
12 25 (8.99%) Scrum
13 24 (8.63%) Data Analysis
14 18 (6.47%) Data Architecture
14 18 (6.47%) Statistics
15 17 (6.12%) Data Analytics
15 17 (6.12%) Data Strategy
16 15 (5.40%) Data Governance
16 15 (5.40%) Kanban
Programming Languages
1 214 (76.98%) SQL
2 106 (38.13%) T-SQL
3 56 (20.14%) PL/SQL
4 18 (6.47%) C#
5 17 (6.12%) R
6 13 (4.68%) Java
7 12 (4.32%) VBA
8 9 (3.24%) VB
9 8 (2.88%) VB.NET
10 7 (2.52%) Python
11 6 (2.16%) Data Analysis Expressions (DAX)
11 6 (2.16%) JavaScript
12 4 (1.44%) ABAP
13 2 (0.72%) ANSI SQL
13 2 (0.72%) AWK
13 2 (0.72%) Clojure
13 2 (0.72%) Ruby
13 2 (0.72%) Scala
13 2 (0.72%) sed
14 1 (0.36%) C
Qualifications
1 26 (9.35%) Degree
2 4 (1.44%) CITP
3 3 (1.08%) Microsoft Certification
4 2 (0.72%) CBAP
4 2 (0.72%) ISEB
5 1 (0.36%) MCSE
Quality Assurance & Compliance
1 37 (13.31%) Data Quality
2 18 (6.47%) QA
3 3 (1.08%) IFRS
3 3 (1.08%) IFRS 9
4 2 (0.72%) SEPA
4 2 (0.72%) TARGET2
5 1 (0.36%) SLA
5 1 (0.36%) Solvency II
Systems Management
1 2 (0.72%) Puppet
Vendors
1 83 (29.86%) Oracle
2 76 (27.34%) Microsoft
3 41 (14.75%) Cognos
4 35 (12.59%) Tableau
5 33 (11.87%) SAP
6 27 (9.71%) Informatica
7 13 (4.68%) Talend
8 9 (3.24%) MicroStrategy
8 9 (3.24%) Vertica
9 7 (2.52%) Netezza
10 4 (1.44%) Cloudera
10 4 (1.44%) Google
10 4 (1.44%) IBM
11 3 (1.08%) Alteryx
12 2 (0.72%) Ab Initio
12 2 (0.72%) Hortonworks
12 2 (0.72%) Teradata
12 2 (0.72%) Trillium
13 1 (0.36%) CA
13 1 (0.36%) JD Edwards
London
ComputAppoint
Salary: £45000 - £50000 per annum + Benefits
Posted: 2 days ago
Maidenhead, Berkshire
RBW Consulting
Salary: From £45,000 to £50,000 per annum + VERY GOOD BENEFITS
Posted: 2 days ago
Chester, Cheshire
Asset Resourcing Ltd
Salary: £30000 - £45000 per annum + bonus + benefits
Posted: 3 days ago
Birmingham, West Midlands (County)
Colossus Associates
Salary: £40000 - £55000 per annum, Benefits Excellent
Posted: 2 days ago
London
Networking People
Salary: £65000 - £71000 per annum + bonus, benefits, shares
Posted: 2 days ago
London
Red10
Salary: £65000 - £75000 per annum
Posted: 3 days ago
West Bromwich, West Midlands (County)
Rullion
Salary: £35000 - £50000 per annum + extensive benefits
Posted: 3 days ago
London
Devonshire Hayes Recruitment Specialists Ltd
Salary: From £60,000 to £75,000 per annum
Posted: 3 days ago
London
Joseph Harry Ltd
Salary: £65000 - £80000 per annum + 20-30% Bonus + 10% Pension
Posted: 4 days ago
Northampton, Northamptonshire
St Andrew's Healthcare
Salary: £41098 - £58711 per annum, Benefits 38 days holiday, pension & package
Posted: 4 days ago
United Kingdom
The Bridge Ltd
Salary: Bonus
Posted: 6 days ago
Coventry, West Midlands (County)
Matt Burton Associates Ltd
Salary: £33,495 - 50,242 per year + Benefits
Posted: 5 days ago
Worcester, Worcestershire
Erin Associates
Salary: £40000 per annum + Bonus & excellent benefits
Posted: 6 days ago
Yorkshire
Cloud Computing International
Posted: 5 days ago
London
Venturi
Salary: £0.00 - £55000 per annum + Bonus
Posted: 11 days ago
Greater Manchester
Progressive Recruitment
Salary: £42000 - £47000 per annum
Posted: 11 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 11 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 11 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 11 days ago
Sutton, Surrey
Reed Business Information Ltd
Salary: From £65,000 to £70,000 per annum + bonus & extensive benefits
Posted: 13 days ago
London
CPS Group Limited
Salary: £65000 - £80000 per annum + car, pension, bonus
Posted: 25 days ago
City of London
Venturi
Salary: £40000 - £45000.00 per annum + extensive benefits
Posted: 25 days ago
Hemel Hempstead
Bluetown Online LTD
Salary: £30000 - £40000 per annum
Posted: 17 days ago
UK Wide
HM Revenue and Customs
Salary: £45,000 - £65,000 per year
Posted: 16 days ago