Period
to 22 July 2017

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

Dimensional Modelling
UK
6 months to
22 Jul 2017
Same period 2016 Same period 2015
Rank 869 882 859
Rank change year-on-year +13 -23 -80
Permanent jobs citing Dimensional Modelling 326 401 471
As % of all permanent IT jobs advertised in the UK 0.18% 0.20% 0.21%
As % of the Processes & Methodologies category 0.20% 0.22% 0.24%
Number of salaries quoted 224 293 369
UK median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% -
10th Percentile £37,500 £35,000 £34,950
90th Percentile £72,500 £72,500 £77,500
UK excluding London median annual salary £42,500 £45,000 £45,000
% change year-on-year -5.56% - +1.12%

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 160109 179919 194848
As % of all permanent IT job vacancies advertised in the UK 89.73% 88.89% 87.86%
Number of salaries quoted 128522 149744 158446
UK median annual salary £50,000 £48,000 £47,500
Median salary % change year-on-year +4.17% +1.05% +5.56%
10th Percentile £28,500 £27,500 £27,500
90th Percentile £80,000 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £42,500

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 22 July 2017.

Salary histogram for Dimensional Modelling in the UK

Dimensional Modelling
Top 14 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 22 July 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
England +25 307 £52,500 - 20
London +37 196 £65,000 +8.33% 12
UK excluding London +5 111 £42,500 -5.56% 11
Midlands +17 44 £42,500 -3.41% 2
North of England +2 30 £42,500 +6.25%
West Midlands -2 25 £42,500 -3.41% 1
North West -11 17 £42,500 +3.03%
Yorkshire +33 13 £32,500 -23.53%
East of England +12 13 £41,000 -15.90%
East Midlands +18 11 £45,000 -14.29% 1
South East +43 10 £50,000 - 6
South West +3 6 £37,500 -12.79%
Wales +6 5 £47,500 +63.79%
Scotland +5 3 £36,250 -30.95% 3

For the 6 months to 22 July 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 270 (82.82%) SQL
2 269 (82.52%) Data Warehouse
3 247 (75.77%) Business Intelligence
4 205 (62.88%) ETL
5 193 (59.20%) SQL Server
6 166 (50.92%) SQL Server Integration Services
7 139 (42.64%) Kimball Methodology
8 124 (38.04%) SQL Server Reporting Services
9 112 (34.36%) OLAP
10 111 (34.05%) SQL Server Analysis Services
11 110 (33.74%) Oracle
12 106 (32.52%) Data Modelling
13 96 (29.45%) T-SQL
14 82 (25.15%) Visualisation
15 80 (24.54%) Microsoft
16 79 (24.23%) Finance
17 77 (23.62%) Agile Software Development
18 73 (22.39%) OLAP Cube
19 72 (22.09%) PL/SQL
20 66 (20.25%) Analytics
21 62 (19.02%) Power BI
21 62 (19.02%) BusinessObjects
22 61 (18.71%) Tableau
23 60 (18.40%) Data Quality
24 59 (18.10%) MySQL
25 58 (17.79%) Relational Database
26 56 (17.18%) Data Visualisation
27 52 (15.95%) Performance Tuning
28 49 (15.03%) Data Management
29 46 (14.11%) Degree

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 29 (8.90%) SAS
2 23 (7.06%) SharePoint
3 3 (0.92%) JBoss
3 3 (0.92%) Tomcat
3 3 (0.92%) WebLogic
3 3 (0.92%) WebSphere
4 2 (0.61%) Apache Pig
5 1 (0.31%) MS Exchange
Applications
1 27 (8.28%) Microsoft Excel
2 3 (0.92%) Microsoft PowerPoint
2 3 (0.92%) Spreadsheet
3 2 (0.61%) Microsoft Office
3 2 (0.61%) MS Visio
3 2 (0.61%) SPSS
Business Applications
1 6 (1.84%) Dynamics GP
1 6 (1.84%) SAP R/3
2 3 (0.92%) Cognos Business Intelligence
2 3 (0.92%) Dynamics AX
3 1 (0.31%) Cognos TM1
3 1 (0.31%) SAP BPC
Cloud Services
1 22 (6.75%) Amazon AWS
2 15 (4.60%) Microsoft Azure
3 5 (1.53%) Amazon EC2
4 4 (1.23%) Office 365
5 3 (0.92%) Amazon EMR
6 2 (0.61%) Amazon Glacier
6 2 (0.61%) Amazon S3
6 2 (0.61%) Cloud Computing
7 1 (0.31%) AWS Lambda
7 1 (0.31%) Azure Data Factory
7 1 (0.31%) Dynamics 365
7 1 (0.31%) IaaS
Communications & Networking
1 3 (0.92%) HTTP
1 3 (0.92%) LDAP
1 3 (0.92%) SSL
2 1 (0.31%) Broadband
Database & Business Intelligence
1 269 (82.52%) Data Warehouse
2 193 (59.20%) SQL Server
3 166 (50.92%) SQL Server Integration Services
4 124 (38.04%) SQL Server Reporting Services
5 112 (34.36%) OLAP
6 111 (34.05%) SQL Server Analysis Services
7 73 (22.39%) OLAP Cube
8 62 (19.02%) BusinessObjects
8 62 (19.02%) Power BI
9 59 (18.10%) MySQL
10 58 (17.79%) Relational Database
11 44 (13.50%) Oracle Database
11 44 (13.50%) SQL Server 2008
12 42 (12.88%) SQL Server 2012
13 41 (12.58%) Oracle OLAP
14 39 (11.96%) Hadoop
15 36 (11.04%) Big Data
16 34 (10.43%) Oracle ODI
17 32 (9.82%) OLTP
18 31 (9.51%) DB2
Development Applications
1 15 (4.60%) JIRA
1 15 (4.60%) Talend Open Studio
2 12 (3.68%) Team Foundation Server
3 6 (1.84%) ERwin
4 2 (0.61%) Octopus Deploy
4 2 (0.61%) TeamCity
5 1 (0.31%) MSBuild
5 1 (0.31%) SQL Server Management Studio (SSMS)
5 1 (0.31%) VSS/SourceSafe
General
1 79 (24.23%) Finance
2 37 (11.35%) Marketing
3 32 (9.82%) Banking
4 26 (7.98%) Retail
5 21 (6.44%) Publishing
6 14 (4.29%) Front Office
7 9 (2.76%) Legal
8 7 (2.15%) Local Government
8 7 (2.15%) Retail Banking
9 6 (1.84%) Back Office
10 4 (1.23%) Advertising
11 3 (0.92%) Financial Institution
11 3 (0.92%) Law
11 3 (0.92%) Telecoms
12 2 (0.61%) Games
Job Titles
1 188 (57.67%) Developer
2 104 (31.90%) Business Intelligence Developer
3 73 (22.39%) SQL Developer
4 49 (15.03%) Data Warehouse Developer
5 45 (13.80%) Analyst
6 39 (11.96%) SQL BI Developer
7 38 (11.66%) Business Developer
8 33 (10.12%) Oracle Developer
9 26 (7.98%) Consultant
9 26 (7.98%) Senior Developer
9 26 (7.98%) SSRS Developer
10 23 (7.06%) Oracle Data Warehouse Developer
10 23 (7.06%) SSAS Developer
11 21 (6.44%) Architect
12 20 (6.13%) Data Architect
12 20 (6.13%) SSIS Developer
13 19 (5.83%) Business Analyst
13 19 (5.83%) Data Analyst
14 18 (5.52%) SQL Server Developer
15 17 (5.21%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 41 (12.58%) MDX
2 31 (9.51%) XML
3 26 (7.98%) Oracle GoldenGate
4 21 (6.44%) Web Services
5 13 (3.99%) HTML
6 12 (3.68%) .NET
7 9 (2.76%) CSS
8 8 (2.45%) EDIFACT
8 8 (2.45%) iXBRL
8 8 (2.45%) JSON
8 8 (2.45%) RESTful
8 8 (2.45%) SOAP
9 4 (1.23%) JMS
9 4 (1.23%) JSP
9 4 (1.23%) Kafka
9 4 (1.23%) XSLT
10 3 (0.92%) Spring
10 3 (0.92%) Spring Security
11 2 (0.61%) RabbitMQ
11 2 (0.61%) SAP XI
Miscellaneous
1 28 (8.59%) Analytical Skills
2 23 (7.06%) Computer Science
3 19 (5.83%) Fintech
4 17 (5.21%) Replication
5 12 (3.68%) Management Information System
6 10 (3.07%) Data Protection Act
7 9 (2.76%) Reference Data
7 9 (2.76%) Social Media
8 7 (2.15%) Greenfield Project
9 5 (1.53%) FMCG
10 4 (1.23%) Data Structures
10 4 (1.23%) Reinsurance
11 3 (0.92%) e-Learning
12 2 (0.61%) Derivative
12 2 (0.61%) Hedge funds
12 2 (0.61%) Linux Command Line
13 1 (0.31%) Clustering
13 1 (0.31%) Enterprise Software
13 1 (0.31%) NHS
Operating Systems
1 24 (7.36%) Linux
2 18 (5.52%) Windows
3 8 (2.45%) Red Hat Enterprise Linux
4 7 (2.15%) Unix
5 3 (0.92%) Solaris
Processes & Methodologies
1 247 (75.77%) Business Intelligence
2 205 (62.88%) ETL
3 139 (42.64%) Kimball Methodology
4 106 (32.52%) Data Modelling
5 82 (25.15%) Visualisation
6 77 (23.62%) Agile Software Development
7 66 (20.25%) Analytics
8 56 (17.18%) Data Visualisation
9 52 (15.95%) Performance Tuning
10 49 (15.03%) Data Management
11 38 (11.66%) Data Analytics
12 35 (10.74%) ETL Development
13 34 (10.43%) Data Governance
14 32 (9.82%) Data Analysis
15 31 (9.51%) Migration
16 28 (8.59%) Data Integration
17 26 (7.98%) Kanban
18 25 (7.67%) Scrum
19 23 (7.06%) Mentoring
20 22 (6.75%) Data Architecture
Programming Languages
1 270 (82.82%) SQL
2 96 (29.45%) T-SQL
3 72 (22.09%) PL/SQL
4 31 (9.51%) Java
5 17 (5.21%) C#
5 17 (5.21%) VBA
6 14 (4.29%) VB
7 13 (3.99%) JavaScript
8 8 (2.45%) ABAP
8 8 (2.45%) Python
8 8 (2.45%) VB.NET
9 6 (1.84%) R
10 5 (1.53%) Data Analysis Expressions (DAX)
11 2 (0.61%) ANSI SQL
11 2 (0.61%) AWK
11 2 (0.61%) C++
11 2 (0.61%) Clojure
11 2 (0.61%) Ruby
11 2 (0.61%) sed
12 1 (0.31%) C
Qualifications
1 46 (14.11%) Degree
2 8 (2.45%) CITP
3 6 (1.84%) Computer Science Degree
4 2 (0.61%) CBAP
4 2 (0.61%) ISEB
4 2 (0.61%) Master's Degree
5 1 (0.31%) MCSE
5 1 (0.31%) Microsoft Certification
5 1 (0.31%) Numerate Degree
Quality Assurance & Compliance
1 60 (18.40%) Data Quality
2 28 (8.59%) QA
3 8 (2.45%) GDPR
3 8 (2.45%) ISO/IEC 27001
3 8 (2.45%) PCI DSS
4 4 (1.23%) SLA
5 3 (0.92%) IFRS
5 3 (0.92%) IFRS 9
System Software
1 3 (0.92%) Active Directory
2 2 (0.61%) Apache Flume
Vendors
1 110 (33.74%) Oracle
2 80 (24.54%) Microsoft
3 61 (18.71%) Tableau
4 35 (10.74%) SAP
5 32 (9.82%) Informatica
6 21 (6.44%) Cognos
7 15 (4.60%) IBM
7 15 (4.60%) Talend
8 14 (4.29%) Vertica
9 9 (2.76%) Jaspersoft
9 9 (2.76%) Teradata
10 8 (2.45%) Cloudera
10 8 (2.45%) Logi
10 8 (2.45%) Logi Analytics
11 7 (2.15%) Cognizant
11 7 (2.15%) MicroStrategy
12 6 (1.84%) Ab Initio
13 5 (1.53%) CA
13 5 (1.53%) MapR
13 5 (1.53%) Netezza
City, London
Red10
Salary: £70000 - £80000 per annum
Posted: Yesterday
London
JM
Salary: £50000 - £55000 per annum
Posted: 23 hours ago
Birmingham, West Midlands (County)
Colossus Associates
Salary: £40000 - £60000 per annum, Benefits Pension+Medical + Lots more
Posted: Yesterday
Kent
Client Server
Salary: £30k to £45k + benefits
Posted: 2 days ago
London
Direct Resource Services Ltd
Salary: £0 - £55,000 per year
Posted: 3 days ago
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: 3 days ago
Kent
Client Server
Salary: £30k to £45k + benefits
Posted: 2 days ago
Berkshire
McGregor Boyall
Salary: £40000 - £50000 per annum + benefits
Posted: 4 days ago
West London
Data Idols
Salary: From £50,000 to £55,000 per annum
Posted: 5 days ago
London
ISL
Salary: £50000.00 - £65000.00 per annum
Posted: 4 days ago
West London
Data Idols
Salary: From £60,000 to £70,000 per annum
Posted: 5 days ago
London
Lawrence Harvey
Salary: £50000.00 - £55000.00 per annum + Excellent Benefits! 10% Bonus
Posted: 5 days ago
Gourock, Renfrewshire
Empiric
Salary: From £38,000 to £45,000 per annum
Posted: 2 days ago
Central London / West End
The Workshop
Posted: 8 days ago
Gourock
Hays Specialist Recruitment Ltd
Salary: £30000.00 - £35000.00 per annum
Posted: 11 days ago
Northampton, Northamptonshire
St Andrew's Healthcare
Salary: £41098 - £58711 per annum, Benefits 38 days holiday, pension & package
Posted: 15 days ago
High Wycombe, Buckinghamshire
GM Financial
Posted: 25 days ago
Sutton, Surrey
Reed Business Information Ltd
Salary: From £65,000 to £70,000 per annum + bonus & extensive benefits
Posted: 19 days ago
London
Mint
Salary: £36000 - £45000 per annum + benefits
Posted: 24 days ago
South East London
TDA Group
Salary: £70000 - £71000 per annum + bonus & extensive benefits
Posted: 19 days ago