The table below looks at the statistics for Dimensional Modelling skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited Dimensional Modelling over the 3 months to 19 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
19 Jan 2017
Same period 2016 Same period 2015
Dimensional Modelling
UK
Rank 717 673 674
Rank change year-on-year
-44 +1
Permanent jobs citing Dimensional Modelling 128 277 272
As % of all permanent IT jobs located in the UK 0.15% 0.28% 0.26%
As % of the Processes & Methodologies category 0.17% 0.32% 0.30%
Number of salaries quoted 112 180 235
Median salary £52,500 £50,000 £52,500
Median salary % change year-on-year
+5.00% -4.76%
90% offered a salary of more than £40,000 £37,500 £37,500
10% offered a salary of more than £67,500 £66,750 £72,100
UK excluding London median salary £45,000 £45,000 £45,000

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised across the UK.

Processes & Methodologies Category
UK
Permanent IT job ads with a match in the
Processes & Methodologies category
73988 87832 90309
As % of all permanent IT jobs located in the UK 88.12% 87.69% 86.05%
Number of salaries quoted 60898 73039 74561
Median salary £50,000 £50,000 £47,500
Median salary % change year-on-year
- +5.26%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £76,000 £72,500 £75,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

Dimensional Modelling
Jobs Demand Trend

The demand trend of job ads citing Dimensional Modelling as a proportion of all IT jobs with a match in the Processes & Methodologies category.

Dimensional Modelling Jobs Demand Trend 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 within the UK.

Dimensional Modelling Salary Trend in the UK

Dimensional Modelling
Salary Histogram

This chart provides a salary histogram for IT jobs citing Dimensional Modelling over the 3 months to 19 January 2017 within the UK.

Dimensional Modelling Salary Histogram 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 19 January 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 -44 126 £52,500 +2.94% 8
London -5 82 £58,500 -2.50% 3
City of London +46 30 £52,500 -16.00% 1
South East +40 15 £50,000 +11.11%
South West +13 5 £45,000 -19.64%
West Midlands -9 5 £40,000 -15.78% 1
Berkshire +32 4 £50,000 +11.11%
East of England +18 4 £41,250 -8.33%
Northampton +9 4 £45,000 +2.85%
Durham +7 4 £45,000 +13.68%
East Midlands +4 4 £45,000 -5.26% 2
North East +1 4 £45,000 +38.46%
Northamptonshire -1 4 £45,000 -10.00%
Darlington - 4 £45,000 -
Wokingham - 4 £50,000 -
Gloucester - 3 £44,500 -
West Bromwich - 3 £40,000 -
Gloucestershire - 3 £44,500 -
West Sussex - 3 £47,500 -
Oxfordshire +31 2 - -
Yorkshire +15 2 £37,500 -
Hampshire +12 2 £39,750 -11.66%
Hertfordshire +6 2 £45,000 -
Portsmouth +2 2 £39,750 -11.66%
Scotland -4 2 - - 1
Abingdon - 2 - -
Bath - 2 £67,500 -
Borehamwood - 2 £45,000 -
Bedfordshire - 2 £37,250 -
Somerset - 2 £67,500 -

Dimensional Modelling
Top 30 Related IT Skills

For the 6 months to 19 January 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 250 (81.70%) Business Intelligence
2 225 (73.53%) Data Warehouse
3 217 (70.92%) SQL
4 182 (59.48%) ETL
5 159 (51.96%) SQL Server
6 134 (43.79%) SQL Server Integration Services
7 113 (36.93%) T-SQL
8 105 (34.31%) Kimball Methodology
9 97 (31.70%) SQL Server Reporting Services
10 90 (29.41%) SQL Server Analysis Services
11 89 (29.08%) Finance
12 82 (26.80%) Data Modelling
13 80 (26.14%) Oracle
14 78 (25.49%) Agile Software Development
15 71 (23.20%) Microsoft
16 70 (22.88%) Analytics
17 64 (20.92%) OLAP
18 63 (20.59%) Cognos
19 55 (17.97%) Visualisation
20 51 (16.67%) Big Data
21 48 (15.69%) MDX
22 45 (14.71%) Analytical Skills
23 43 (14.05%) PL/SQL
24 42 (13.73%) MS Excel
24 42 (13.73%) Hadoop
25 41 (13.40%) Cognos Business Intelligence
25 41 (13.40%) Retail
26 40 (13.07%) Relational Database
27 37 (12.09%) SQL Server 2012
27 37 (12.09%) Data Quality

Dimensional Modelling
Top Related 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 20 (6.54%) SharePoint
2 14 (4.58%) SAS
3 8 (2.61%) Apache Pig
4 3 (0.98%) Apache Spark
5 1 (0.33%) Apache Airflow
5 1 (0.33%) Luigi
Applications
1 42 (13.73%) MS Excel
2 8 (2.61%) MS Visio
3 4 (1.31%) MS Office
4 1 (0.33%) Spreadsheet
Business Applications
1 41 (13.40%) Cognos Business Intelligence
2 16 (5.23%) Cognos Planning
3 8 (2.61%) Cognos TM1
4 2 (0.65%) Dynamics CRM
4 2 (0.65%) Maximo
4 2 (0.65%) TRIRIGA
5 1 (0.33%) Dynamics AX
Cloud Services
1 25 (8.17%) Amazon AWS
2 21 (6.86%) Amazon S3
3 16 (5.23%) Amazon EMR
4 13 (4.25%) GitHub
5 4 (1.31%) Google Cloud Platform
5 4 (1.31%) Microsoft Azure
5 4 (1.31%) SaaS
6 3 (0.98%) Amazon EC2
Communications & Networking
1 13 (4.25%) Internet
Database & Business Intelligence
1 225 (73.53%) Data Warehouse
2 159 (51.96%) SQL Server
3 134 (43.79%) SQL Server Integration Services
4 97 (31.70%) SQL Server Reporting Services
5 90 (29.41%) SQL Server Analysis Services
6 64 (20.92%) OLAP
7 51 (16.67%) Big Data
8 42 (13.73%) Hadoop
9 40 (13.07%) Relational Database
10 37 (12.09%) Microsoft Analysis Services
10 37 (12.09%) QlikView
10 37 (12.09%) SQL Server 2012
11 36 (11.76%) BusinessObjects
12 35 (11.44%) Power BI
13 31 (10.13%) SQL Server 2008
13 31 (10.13%) SQL Server 2014
14 29 (9.48%) Cognos Analysis Studio
14 29 (9.48%) Cognos Event Studio
14 29 (9.48%) Cognos Framework Manager
14 29 (9.48%) Cognos Report Studio
Development Applications
1 21 (6.86%) JIRA
2 20 (6.54%) SQL Server Management Studio (SSMS)
3 12 (3.92%) Talend Open Studio
4 10 (3.27%) Team Foundation Server
5 9 (2.94%) ERwin
5 9 (2.94%) Jenkins
5 9 (2.94%) Vagrant
6 6 (1.96%) Git (software)
6 6 (1.96%) MSBuild
7 5 (1.63%) Cucumber
8 2 (0.65%) Visual Studio
General
1 89 (29.08%) Finance
2 41 (13.40%) Retail
3 16 (5.23%) Games
4 13 (4.25%) Banking
5 8 (2.61%) Manufacturing
5 8 (2.61%) Marketing
6 7 (2.29%) Retail Banking
7 6 (1.96%) Publishing
8 5 (1.63%) Legal
9 4 (1.31%) Advertising
9 4 (1.31%) Billing
9 4 (1.31%) Local Government
10 3 (0.98%) Law
11 2 (0.65%) Automotive
11 2 (0.65%) Music Industry
11 2 (0.65%) Pharmaceutical
11 2 (0.65%) Telecoms
12 1 (0.33%) Front Office
Job Titles
1 139 (45.42%) Developer
2 74 (24.18%) Business Intelligence Developer
3 65 (21.24%) Analyst
4 50 (16.34%) SQL Developer
5 40 (13.07%) Architect
6 36 (11.76%) Data Architect
7 31 (10.13%) Business Intelligence Analyst
8 25 (8.17%) Business Intelligence Specialist
8 25 (8.17%) Cognos Specialist
9 23 (7.52%) SQL BI Developer
10 22 (7.19%) Consultant
10 22 (7.19%) SSIS Developer
11 20 (6.54%) Data Warehouse Developer
12 19 (6.21%) Business Developer
13 17 (5.56%) Data Warehouse Architect
13 17 (5.56%) ETL Developer
14 16 (5.23%) Analyst Developer
14 16 (5.23%) Oracle Developer
15 15 (4.90%) Big Data Architect
15 15 (4.90%) SSRS Developer
Libraries, Frameworks & Software Standards
1 48 (15.69%) MDX
2 18 (5.88%) .NET
3 15 (4.90%) Kafka
4 11 (3.59%) Oracle GoldenGate
4 11 (3.59%) Web Services
5 8 (2.61%) XML
6 5 (1.63%) .NET Framework
7 3 (0.98%) CSS
8 2 (0.65%) HTML
8 2 (0.65%) SQLAlchemy
9 1 (0.33%) ASP.NET
9 1 (0.33%) jQuery
9 1 (0.33%) XSLT
Miscellaneous
1 55 (17.97%) Visualisation
2 45 (14.71%) Analytical Skills
3 15 (4.90%) Management Information System
3 15 (4.90%) Online Games
4 14 (4.58%) Data Integration
5 11 (3.59%) Fintech
5 11 (3.59%) Replication
6 9 (2.94%) Economics
7 8 (2.61%) Mathematics
8 7 (2.29%) Computer Science
8 7 (2.29%) Data Extraction
9 6 (1.96%) Statistics
10 4 (1.31%) Physics
11 3 (0.98%) Data Structures
11 3 (0.98%) Enterprise Software
12 2 (0.65%) Mobile Computing
12 2 (0.65%) SWIFT
Operating Systems
1 8 (2.61%) Windows
2 7 (2.29%) Windows Server 2012
3 1 (0.33%) Linux
3 1 (0.33%) Unix
Processes & Methodologies
1 250 (81.70%) Business Intelligence
2 182 (59.48%) ETL
3 105 (34.31%) Kimball Methodology
4 82 (26.80%) Data Modelling
5 78 (25.49%) Agile Software Development
6 70 (22.88%) Analytics
7 32 (10.46%) Scrum
8 28 (9.15%) Data Analysis
8 28 (9.15%) ETL Development
9 25 (8.17%) Project Management
10 24 (7.84%) Mentoring
11 22 (7.19%) Data Architecture
12 20 (6.54%) Data Management
13 16 (5.23%) E-Commerce
13 16 (5.23%) Technical Architecture
14 15 (4.90%) Data Analytics
14 15 (4.90%) Data Visualisation
15 14 (4.58%) Translating Business Requirements
16 13 (4.25%) Data Transformation
16 13 (4.25%) Migration
Programming Languages
1 217 (70.92%) SQL
2 113 (36.93%) T-SQL
3 43 (14.05%) PL/SQL
4 21 (6.86%) Java
5 20 (6.54%) R
6 13 (4.25%) VBA
7 12 (3.92%) C#
8 8 (2.61%) Python
9 5 (1.63%) JavaScript
9 5 (1.63%) PowerShell
9 5 (1.63%) Shell Script
9 5 (1.63%) VB.NET
10 4 (1.31%) Data Analysis Expressions (DAX)
11 3 (0.98%) C
11 3 (0.98%) C++
12 1 (0.33%) Scala
12 1 (0.33%) VB
Qualifications
1 31 (10.13%) Degree
2 3 (0.98%) Microsoft Certification
3 2 (0.65%) ISEB
4 1 (0.33%) APMP
4 1 (0.33%) PMP
Quality Assurance & Compliance
1 37 (12.09%) Data Quality
2 14 (4.58%) QA
3 2 (0.65%) SEPA
3 2 (0.65%) TARGET2
4 1 (0.33%) Solvency II
System Software
1 5 (1.63%) HDFS
Systems Management
1 13 (4.25%) Puppet
2 3 (0.98%) Hadoop YARN
Vendors
1 80 (26.14%) Oracle
2 71 (23.20%) Microsoft
3 63 (20.59%) Cognos
4 20 (6.54%) Tableau
5 18 (5.88%) Netezza
5 18 (5.88%) SAP
6 17 (5.56%) Informatica
6 17 (5.56%) MicroStrategy
7 14 (4.58%) IBM
8 12 (3.92%) Talend
9 9 (2.94%) Hyperion
10 8 (2.61%) Anaplan
11 4 (1.31%) Ab Initio
11 4 (1.31%) Google
12 3 (0.98%) Alteryx
12 3 (0.98%) CA
12 3 (0.98%) MapR
12 3 (0.98%) Teradata
13 2 (0.65%) Hortonworks
13 2 (0.65%) Trillium
Glasgow, Lanarkshire
Harvey Nash plc
Salary: £35000 - £45000 per annum
Posted: 21 hours ago
Chester, Cheshire
Asset Resourcing Ltd
Salary: £30000 - £40000 per annum + bonus + benefits
Posted: 3 days ago
Chester, Cheshire
Jagger Talent
Salary: From £35,000 to £35,000 per annum + Strong Benefits Package
Posted: 6 days ago
Nottingham, Nottinghamshire
Rebel Recruitment
Salary: From £50,000 to £78,000 per annum + 15% Bonus + Benefits
Posted: 3 days ago
Birmingham, West Midlands (County)
Maurice Nash
Salary: From £25,000 to £28,000 per annum
Posted: 6 days ago
City, London
ANSON MCCADE
Salary: £75 000 to £95 000 basic (+ superb package!!!)
Posted: 5 days ago
London
TDA Group
Salary: £55000 - £65000 per annum + +Excellent Benefits
Posted: 16 days ago