Period
to 18 November 2017

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 6 months to 18 November 2017 with a comparison to the same period in the previous 2 years.

Dimensional Modelling
UK > England
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 809 863 864
Rank change year-on-year +54 +1 -103
Permanent jobs citing Dimensional Modelling 354 330 420
As % of all permanent IT jobs advertised in England 0.21% 0.18% 0.20%
As % of the Processes & Methodologies category 0.23% 0.21% 0.23%
Number of salaries quoted 222 284 328
England median annual salary £60,000 £52,500 £55,000
Median salary % change year-on-year +14.29% -4.55% +4.76%
10th Percentile £38,750 £37,500 £37,125
90th Percentile £76,250 £81,250 £72,500
UK median annual salary £60,000 £52,500 £55,000
% change year-on-year +14.29% -4.55% +4.76%

Dimensional Modelling is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in England with a requirement for process or methodology skills.

All Process and Methodology Skills
England
Permanent vacancies with a requirement for process or methodology skills 150826 160156 182795
As % of all permanent IT jobs advertised in England 89.93% 89.37% 88.72%
Number of salaries quoted 119888 134356 152138
England median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% +5.56%
10th Percentile £28,750 £28,250 £27,500
90th Percentile £80,000 £80,000 £77,500
UK median annual salary £50,000 £49,000 £47,500
% change year-on-year +2.04% +3.16% +5.56%

Dimensional Modelling
Job Vacancy Trend in England

Job postings citing Dimensional Modelling as a percentage of all IT jobs advertised in England.

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 6 months to 18 November 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 6 months to 18 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London +63 239 £67,500 +12.50% 8
South East +13 34 £52,500 -2.78% 1
Midlands +26 29 £44,500 +11.25% 1
North of England +2 25 £42,500 +6.25% 4
West Midlands +8 17 £42,500 +6.25%
North West -17 11 £42,500 +6.25% 1
South West -25 9 £38,750 -8.82%
East of England +4 8 £50,000 +31.58% 1
Yorkshire +26 6 £46,250 +8.82% 3
East Midlands +42 5 £44,500 -13.17% 1
North East +4 2 £36,750 -2.00%
Dimensional Modelling
UK

For the 6 months to 18 November 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 289 (81.64%) SQL
2 283 (79.94%) Data Warehouse
3 267 (75.42%) Business Intelligence
4 223 (62.99%) ETL
5 212 (59.89%) SQL Server
6 160 (45.20%) SQL Server Integration Services
7 154 (43.50%) Kimball Methodology
8 142 (40.11%) Data Modelling
9 126 (35.59%) SQL Server Analysis Services
10 124 (35.03%) Microsoft
11 123 (34.75%) SQL Server Reporting Services
12 116 (32.77%) OLAP
13 115 (32.49%) Analytics
14 114 (32.20%) Agile Software Development
15 104 (29.38%) Oracle
16 84 (23.73%) Power BI
17 83 (23.45%) OLAP Cube
18 82 (23.16%) Visualisation
19 80 (22.60%) T-SQL
20 78 (22.03%) MDX
20 78 (22.03%) Tableau
21 76 (21.47%) Finance
22 73 (20.62%) Performance Tuning
23 72 (20.34%) PL/SQL
24 68 (19.21%) Data Quality
25 62 (17.51%) MySQL
26 61 (17.23%) Degree
27 59 (16.67%) QlikView
28 58 (16.38%) Big Data
29 54 (15.25%) Data Visualisation

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 35 (9.89%) SharePoint
2 16 (4.52%) SAS
3 12 (3.39%) JBoss
3 12 (3.39%) Tomcat
3 12 (3.39%) WebLogic
3 12 (3.39%) WebSphere
4 3 (0.85%) Confluence
5 2 (0.56%) Apache Spark
6 1 (0.28%) Drupal
6 1 (0.28%) MS Exchange
6 1 (0.28%) SharePoint 2010
6 1 (0.28%) SharePoint 2013
Applications
1 27 (7.63%) Microsoft Excel
2 1 (0.28%) Microsoft Office
2 1 (0.28%) SPSS
Business Applications
1 4 (1.13%) Cognos Business Intelligence
1 4 (1.13%) Dynamics GP
2 2 (0.56%) Dynamics AX
3 1 (0.28%) NetSuite
3 1 (0.28%) Oracle ERP
Cloud Services
1 54 (15.25%) Amazon AWS
2 41 (11.58%) Microsoft Azure
3 19 (5.37%) Azure Machine Learning
4 6 (1.69%) Office 365
5 5 (1.41%) Cloud Computing
5 5 (1.41%) GitHub
6 3 (0.85%) Mimecast
6 3 (0.85%) SaaS
7 2 (0.56%) PaaS
8 1 (0.28%) Amazon EC2
8 1 (0.28%) Amazon Glacier
8 1 (0.28%) Amazon S3
8 1 (0.28%) Azure Data Factory
8 1 (0.28%) Data Lake Analytics
Communications & Networking
1 12 (3.39%) HTTP
1 12 (3.39%) LDAP
1 12 (3.39%) SSL
2 2 (0.56%) Internet
Database & Business Intelligence
1 283 (79.94%) Data Warehouse
2 212 (59.89%) SQL Server
3 160 (45.20%) SQL Server Integration Services
4 126 (35.59%) SQL Server Analysis Services
5 123 (34.75%) SQL Server Reporting Services
6 116 (32.77%) OLAP
7 84 (23.73%) Power BI
8 83 (23.45%) OLAP Cube
9 62 (17.51%) MySQL
10 59 (16.67%) QlikView
11 58 (16.38%) Big Data
12 51 (14.41%) BusinessObjects
13 50 (14.12%) SQL Server 2012
14 48 (13.56%) Relational Database
15 46 (12.99%) Oracle Database
16 45 (12.71%) SQL Server 2008
17 44 (12.43%) Amazon RDS
18 42 (11.86%) Oracle OLAP
19 39 (11.02%) Data Mart
20 38 (10.73%) Microsoft Analysis Services
Development Applications
1 25 (7.06%) Talend Open Studio
2 20 (5.65%) Team Foundation Server
3 16 (4.52%) JIRA
4 11 (3.11%) ERwin
5 5 (1.41%) Subversion
6 4 (1.13%) SQL Server Management Studio (SSMS)
7 3 (0.85%) Bitbucket
7 3 (0.85%) Git (software)
8 2 (0.56%) Jenkins
9 1 (0.28%) Oracle Forms
9 1 (0.28%) Visual Studio
General
1 76 (21.47%) Finance
2 50 (14.12%) Marketing
3 32 (9.04%) Banking
4 18 (5.08%) Publishing
5 14 (3.95%) Retail
6 11 (3.11%) Advertising
6 11 (3.11%) Front Office
6 11 (3.11%) Retail Banking
7 9 (2.54%) Games
8 4 (1.13%) Back Office
8 4 (1.13%) Telecoms
9 3 (0.85%) Financial Institution
9 3 (0.85%) Legal
Job Titles
1 199 (56.21%) Developer
2 122 (34.46%) Business Intelligence Developer
3 64 (18.08%) SQL Developer
4 50 (14.12%) Data Warehouse Developer
5 45 (12.71%) SQL BI Developer
6 44 (12.43%) Consultant
7 39 (11.02%) Business Developer
8 35 (9.89%) Analyst
9 31 (8.76%) Business Intelligence Consultant
9 31 (8.76%) Oracle Developer
10 29 (8.19%) Architect
10 29 (8.19%) Data Architect
11 27 (7.63%) Oracle Data Warehouse Developer
12 26 (7.34%) Data Analyst
13 24 (6.78%) Business Analyst
13 24 (6.78%) Data Consultant
14 23 (6.50%) Data Business Analyst
15 21 (5.93%) Senior Developer
16 20 (5.65%) Data Warehouse Analyst
16 20 (5.65%) SSAS Developer
Libraries, Frameworks & Software Standards
1 78 (22.03%) MDX
2 39 (11.02%) XML
3 37 (10.45%) Web Services
4 33 (9.32%) Oracle GoldenGate
5 30 (8.47%) .NET
6 23 (6.50%) HTML
7 19 (5.37%) ASP.NET
8 14 (3.95%) JSP
8 14 (3.95%) XSLT
9 13 (3.67%) Spring
10 12 (3.39%) Spring Security
11 9 (2.54%) CSS
12 5 (1.41%) JSON
13 3 (0.85%) AngularJS
14 2 (0.56%) XSD
15 1 (0.28%) COM
15 1 (0.28%) Java EE
15 1 (0.28%) JMS
15 1 (0.28%) Kafka
15 1 (0.28%) SAP XI
Miscellaneous
1 42 (11.86%) Analytical Skills
2 25 (7.06%) Replication
3 23 (6.50%) Computer Science
4 12 (3.39%) Enterprise Software
5 9 (2.54%) Fintech
6 7 (1.98%) Management Information System
7 6 (1.69%) Data Protection Act
7 6 (1.69%) Reinsurance
8 5 (1.41%) Credit Risk
8 5 (1.41%) Equities
8 5 (1.41%) Social Media
9 3 (0.85%) Data Structures
9 3 (0.85%) Mashup
10 2 (0.56%) Greenfield Project
10 2 (0.56%) Internet of Things
10 2 (0.56%) N-Tier
11 1 (0.28%) Algorithms
11 1 (0.28%) NHS
Operating Systems
1 41 (11.58%) Linux
2 28 (7.91%) Windows
3 12 (3.39%) Solaris
4 7 (1.98%) Red Hat Enterprise Linux
4 7 (1.98%) Unix
5 2 (0.56%) Windows Server
6 1 (0.28%) Windows Server 2012
Processes & Methodologies
1 267 (75.42%) Business Intelligence
2 223 (62.99%) ETL
3 154 (43.50%) Kimball Methodology
4 142 (40.11%) Data Modelling
5 115 (32.49%) Analytics
6 114 (32.20%) Agile Software Development
7 82 (23.16%) Visualisation
8 73 (20.62%) Performance Tuning
9 54 (15.25%) Data Visualisation
10 49 (13.84%) ETL Development
11 41 (11.58%) Data Analytics
12 40 (11.30%) Scrum
13 36 (10.17%) Data Governance
14 35 (9.89%) Data Integration
15 33 (9.32%) Data Management
16 30 (8.47%) Migration
17 27 (7.63%) Coaching
17 27 (7.63%) Mentoring
18 26 (7.34%) Kanban
19 24 (6.78%) Data Analysis
Programming Languages
1 289 (81.64%) SQL
2 80 (22.60%) T-SQL
3 72 (20.34%) PL/SQL
4 36 (10.17%) C#
5 31 (8.76%) Java
6 25 (7.06%) Python
7 23 (6.50%) R
8 21 (5.93%) VBA
9 19 (5.37%) VB
10 17 (4.80%) JavaScript
11 6 (1.69%) PowerShell
12 5 (1.41%) VB.NET
13 3 (0.85%) C
14 2 (0.56%) C++
14 2 (0.56%) Go
14 2 (0.56%) VBScript
15 1 (0.28%) ANSI SQL
15 1 (0.28%) Data Analysis Expressions (DAX)
15 1 (0.28%) PHP
Qualifications
1 61 (17.23%) Degree
2 4 (1.13%) SC Cleared
2 4 (1.13%) Security Cleared
3 3 (0.85%) Computer Science Degree
3 3 (0.85%) MBA
4 2 (0.56%) Numerate Degree
5 1 (0.28%) MCSA
5 1 (0.28%) MCSE
5 1 (0.28%) Microsoft Certification
Quality Assurance & Compliance
1 68 (19.21%) Data Quality
2 43 (12.15%) QA
3 7 (1.98%) GDPR
4 6 (1.69%) ISO/IEC 27001
4 6 (1.69%) PCI DSS
5 1 (0.28%) SLA
System Software
1 12 (3.39%) Active Directory
2 2 (0.56%) VMware Infrastructure
Systems Management
1 2 (0.56%) Rundeck
Vendors
1 124 (35.03%) Microsoft
2 104 (29.38%) Oracle
3 78 (22.03%) Tableau
4 27 (7.63%) Cognos
4 27 (7.63%) Vertica
5 26 (7.34%) Informatica
6 25 (7.06%) Talend
7 24 (6.78%) IBM
8 19 (5.37%) Alteryx
8 19 (5.37%) Jaspersoft
9 17 (4.80%) Teradata
10 14 (3.95%) SAP
11 12 (3.39%) Intel
11 12 (3.39%) MicroStrategy
11 12 (3.39%) TIBCO
12 9 (2.54%) Ab Initio
13 7 (1.98%) Logi
13 7 (1.98%) Logi Analytics
14 5 (1.41%) Cognizant
14 5 (1.41%) MapR