Period
to 17 January 2018

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 6 months to 17 January 2018 with a comparison to the same period in the previous 2 years.

Dimensional Modelling
UK
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 782 866 819
Rank change year-on-year +84 -47 -41
Permanent jobs citing Dimensional Modelling 387 309 492
As % of all permanent IT jobs advertised in the UK 0.22% 0.17% 0.24%
As % of the Processes & Methodologies category 0.25% 0.19% 0.27%
Number of salaries quoted 257 271 360
UK median annual salary £55,000 £52,500 £55,000
Median salary % change year-on-year +4.76% -4.55% +4.76%
10th Percentile £37,500 £37,500 £36,250
90th Percentile £76,250 £75,000 £72,500
UK excluding London median annual salary £50,000 £45,000 £47,500
% change year-on-year +11.11% -5.26% -

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

All Process and Methodology Skills
UK
Permanent vacancies with a requirement for process or methodology skills 155,665 159,222 182,616
As % of all permanent IT jobs advertised in the UK 89.88% 89.52% 88.87%
Number of salaries quoted 124,813 131,637 151,385
UK median annual salary £50,000 £48,786 £47,500
Median salary % change year-on-year +2.49% +2.71% +5.56%
10th Percentile £28,750 £28,125 £27,500
90th Percentile £80,000 £78,750 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +6.25%

Dimensional Modelling
Job Vacancy Trend

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

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 6 months to 17 January 2018.

Salary histogram for Dimensional Modelling in the UK

Dimensional Modelling
Top 15 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 6 months to 17 January 2018. 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
England +69 375 £55,000 +4.76% 41
London +83 227 £67,500 +15.38% 19
UK excluding London +27 151 £50,000 +11.11% 24
North of England +20 37 £45,500 +13.75% 3
South East +2 36 £52,500 - 6
Midlands +24 34 £45,000 +5.88% 8
West Midlands +9 22 £45,000 +11.80% 4
East of England +21 16 £48,750 +28.29% 1
South West +7 16 £57,500 +35.29% 4
Yorkshire +28 15 £45,000 +12.50%
North West +5 14 £48,750 +21.88% 3
East Midlands +29 10 £37,000 -17.78% 4
Wales +24 8 £60,000 +33.33% 2
Scotland -28 4 £45,000 -
North East -21 2 £36,750 -8.13%

For the 6 months to 17 January 2018, 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 309 (79.84%) Data Warehouse
2 296 (76.49%) SQL
3 295 (76.23%) Business Intelligence
4 245 (63.31%) ETL
5 220 (56.85%) SQL Server
6 179 (46.25%) Data Modelling
7 163 (42.12%) SQL Server Integration Services
8 143 (36.95%) Kimball Methodology
9 139 (35.92%) Microsoft
10 138 (35.66%) SQL Server Analysis Services
11 134 (34.63%) SQL Server Reporting Services
12 118 (30.49%) Agile Software Development
12 118 (30.49%) Analytics
13 111 (28.68%) Oracle
14 110 (28.42%) OLAP
15 90 (23.26%) Power BI
16 83 (21.45%) T-SQL
17 79 (20.41%) Finance
17 79 (20.41%) MDX
18 78 (20.16%) Analytical Skills
19 75 (19.38%) OLAP Cube
20 73 (18.86%) Tableau
20 73 (18.86%) Visualisation
21 70 (18.09%) Degree
22 63 (16.28%) Amazon AWS
22 63 (16.28%) Data Quality
22 63 (16.28%) Performance Tuning
23 59 (15.25%) Big Data
24 58 (14.99%) QlikView
25 57 (14.73%) PL/SQL

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 33 (8.53%) SharePoint
2 14 (3.62%) SAS
3 12 (3.10%) JBoss
3 12 (3.10%) Tomcat
3 12 (3.10%) WebLogic
3 12 (3.10%) WebSphere
4 4 (1.03%) SharePoint 2010
5 3 (0.78%) Apache Spark
5 3 (0.78%) Confluence
6 1 (0.26%) Drupal
6 1 (0.26%) SharePoint 2013
Applications
1 40 (10.34%) Microsoft Excel
2 2 (0.52%) Microsoft PowerPoint
3 1 (0.26%) SPSS
Business Applications
1 6 (1.55%) Cognos Business Intelligence
2 5 (1.29%) Dynamics AX
2 5 (1.29%) NetSuite
3 3 (0.78%) Cognos TM1
4 1 (0.26%) Oracle ERP
Cloud Services
1 63 (16.28%) Amazon AWS
2 53 (13.70%) Microsoft Azure
3 19 (4.91%) Azure Machine Learning
4 8 (2.07%) SaaS
5 6 (1.55%) Cloud Computing
5 6 (1.55%) GitHub
6 4 (1.03%) Office 365
7 3 (0.78%) Dynamics 365
7 3 (0.78%) Mimecast
7 3 (0.78%) PaaS
8 1 (0.26%) Azure Data Factory
8 1 (0.26%) Data Lake Analytics
Communications & Networking
1 12 (3.10%) HTTP
1 12 (3.10%) LDAP
1 12 (3.10%) SSL
2 2 (0.52%) Internet
Database & Business Intelligence
1 309 (79.84%) Data Warehouse
2 220 (56.85%) SQL Server
3 163 (42.12%) SQL Server Integration Services
4 138 (35.66%) SQL Server Analysis Services
5 134 (34.63%) SQL Server Reporting Services
6 110 (28.42%) OLAP
7 90 (23.26%) Power BI
8 75 (19.38%) OLAP Cube
9 59 (15.25%) Big Data
10 58 (14.99%) QlikView
11 54 (13.95%) BusinessObjects
12 52 (13.44%) MySQL
13 51 (13.18%) SQL Server 2012
14 50 (12.92%) Relational Database
15 49 (12.66%) Amazon RDS
16 43 (11.11%) Data Mart
17 40 (10.34%) Amazon Redshift
18 39 (10.08%) Microsoft Analysis Services
19 34 (8.79%) Oracle OLAP
19 34 (8.79%) SQL Server 2016
Development Applications
1 26 (6.72%) Team Foundation Server
2 20 (5.17%) ERwin
3 10 (2.58%) JIRA
4 7 (1.81%) SQL Server Management Studio (SSMS)
5 6 (1.55%) Subversion
6 5 (1.29%) Visual Studio
7 3 (0.78%) Bitbucket
7 3 (0.78%) Git (software)
7 3 (0.78%) Jenkins
8 2 (0.52%) Axure RP
9 1 (0.26%) Oracle Forms
9 1 (0.26%) VSS/SourceSafe
General
1 79 (20.41%) Finance
2 45 (11.63%) Marketing
3 14 (3.62%) Banking
4 13 (3.36%) Retail
5 11 (2.84%) Advertising
5 11 (2.84%) Publishing
6 9 (2.33%) Games
7 6 (1.55%) Retail Banking
8 5 (1.29%) Legal
9 3 (0.78%) Financial Institution
9 3 (0.78%) Telecoms
10 2 (0.52%) Front Office
10 2 (0.52%) Law
10 2 (0.52%) Manufacturing
11 1 (0.26%) Automotive
11 1 (0.26%) Pharmaceutical
Job Titles
1 206 (53.23%) Developer
2 127 (32.82%) Business Intelligence Developer
3 61 (15.76%) SQL Developer
4 55 (14.21%) Data Warehouse Developer
5 45 (11.63%) Architect
5 45 (11.63%) Data Architect
6 43 (11.11%) Analyst
7 41 (10.59%) Consultant
7 41 (10.59%) SQL BI Developer
8 35 (9.04%) Business Developer
9 28 (7.24%) Business Intelligence Consultant
10 27 (6.98%) Data Consultant
11 25 (6.46%) Data Analyst
12 23 (5.94%) Oracle Developer
12 23 (5.94%) Senior Developer
13 21 (5.43%) QlikView Developer
13 21 (5.43%) SSIS Developer
14 19 (4.91%) Business Analyst
14 19 (4.91%) Oracle Data Warehouse Developer
14 19 (4.91%) SSAS Developer
Libraries, Frameworks & Software Standards
1 79 (20.41%) MDX
2 33 (8.53%) .NET
3 32 (8.27%) XML
4 29 (7.49%) Web Services
5 23 (5.94%) Oracle GoldenGate
6 20 (5.17%) ASP.NET
7 17 (4.39%) HTML
8 13 (3.36%) JSP
8 13 (3.36%) Spring
8 13 (3.36%) XSLT
9 12 (3.10%) Spring Security
10 7 (1.81%) JSON
11 4 (1.03%) CSS
12 3 (0.78%) XSD
13 2 (0.52%) AngularJS
14 1 (0.26%) ASP.NET MVC
14 1 (0.26%) CGI
14 1 (0.26%) COM
14 1 (0.26%) Java EE
14 1 (0.26%) Spring Boot
Miscellaneous
1 78 (20.16%) Analytical Skills
2 26 (6.72%) Computer Science
3 20 (5.17%) Replication
4 12 (3.10%) Enterprise Software
5 7 (1.81%) Data Structures
6 6 (1.55%) Management Information System
7 5 (1.29%) Credit Risk
7 5 (1.29%) Equities
7 5 (1.29%) Fintech
8 4 (1.03%) Reinsurance
9 3 (0.78%) Clustering
9 3 (0.78%) Mashup
10 2 (0.52%) Algorithms
10 2 (0.52%) Greenfield Project
10 2 (0.52%) Internet of Things
10 2 (0.52%) N-Tier
10 2 (0.52%) Reference Data
11 1 (0.26%) Data Protection Act
11 1 (0.26%) User Experience
Operating Systems
1 45 (11.63%) Linux
2 30 (7.75%) Windows
3 12 (3.10%) Solaris
4 9 (2.33%) Unix
5 2 (0.52%) Red Hat Enterprise Linux
5 2 (0.52%) Windows Server
6 1 (0.26%) Windows Server 2012
Processes & Methodologies
1 295 (76.23%) Business Intelligence
2 245 (63.31%) ETL
3 179 (46.25%) Data Modelling
4 143 (36.95%) Kimball Methodology
5 118 (30.49%) Agile Software Development
5 118 (30.49%) Analytics
6 73 (18.86%) Visualisation
7 63 (16.28%) Performance Tuning
8 46 (11.89%) Data Integration
8 46 (11.89%) Data Visualisation
9 42 (10.85%) Data Governance
10 40 (10.34%) Data Analytics
11 35 (9.04%) ETL Development
12 33 (8.53%) Data Management
12 33 (8.53%) Scrum
13 31 (8.01%) Coaching
14 30 (7.75%) Mentoring
15 27 (6.98%) Migration
16 25 (6.46%) Statistics
17 24 (6.20%) Dashboard Development
Programming Languages
1 296 (76.49%) SQL
2 83 (21.45%) T-SQL
3 57 (14.73%) PL/SQL
4 40 (10.34%) C#
5 29 (7.49%) R
6 25 (6.46%) Java
6 25 (6.46%) Python
7 21 (5.43%) VBA
8 19 (4.91%) VB
9 16 (4.13%) JavaScript
10 11 (2.84%) PowerShell
11 6 (1.55%) Data Analysis Expressions (DAX)
12 4 (1.03%) VB.NET
13 3 (0.78%) C
14 2 (0.52%) C++
14 2 (0.52%) Go
14 2 (0.52%) VBScript
15 1 (0.26%) ANSI SQL
15 1 (0.26%) Perl
15 1 (0.26%) PHP
Qualifications
1 70 (18.09%) Degree
2 8 (2.07%) MBA
3 4 (1.03%) SC Cleared
3 4 (1.03%) Security Cleared
4 2 (0.52%) Computer Science Degree
4 2 (0.52%) MCSA
4 2 (0.52%) MCSE
4 2 (0.52%) Microsoft Certification
4 2 (0.52%) Numerate Degree
5 1 (0.26%) MCP
Quality Assurance & Compliance
1 63 (16.28%) Data Quality
2 40 (10.34%) QA
3 3 (0.78%) SLA
4 2 (0.52%) GDPR
5 1 (0.26%) ISO/IEC 27001
5 1 (0.26%) PCI DSS
System Software
1 12 (3.10%) Active Directory
2 2 (0.52%) VMware Infrastructure
Systems Management
1 3 (0.78%) Rundeck
2 2 (0.52%) Systems Management Server (SMS)
3 1 (0.26%) Failover Clustering
Vendors
1 139 (35.92%) Microsoft
2 111 (28.68%) Oracle
3 73 (18.86%) Tableau
4 35 (9.04%) Vertica
5 31 (8.01%) Cognos
6 28 (7.24%) Informatica
7 22 (5.68%) Talend
8 19 (4.91%) Alteryx
9 18 (4.65%) SAP
9 18 (4.65%) Teradata
10 16 (4.13%) IBM
11 14 (3.62%) Jaspersoft
12 12 (3.10%) Intel
12 12 (3.10%) MicroStrategy
12 12 (3.10%) TIBCO
13 9 (2.33%) Netezza
14 8 (2.07%) Ab Initio
15 5 (1.29%) Greenplum
15 5 (1.29%) JD Edwards
16 4 (1.03%) RedGate