The table below looks at the statistics for Dimensional Modelling skills in IT jobs advertised for the City of London region. Included is a guide to the average salaries offered in IT jobs that have cited Dimensional Modelling over the 3 months to 28 August 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
28 Aug 2015
Same period 2014 Same period 2013
Dimensional Modeling
Rank 252 299 283
Rank change year-on-year
+47 -16
Permanent jobs citing Dimensional Modelling 51 29 41
As % of all permanent IT jobs located in the City of London 0.53% 0.25% 0.35%
As % of the Processes & Methodologies category 0.62% 0.30% 0.42%
Number of salaries quoted 44 24 37
Average salary £57,500 £59,500 £60,000
Average salary % change year-on-year
-3.36% -0.83%
90% offered a salary of more than £47,500 £46,500 £49,000
10% offered a salary of more than £75,000 £63,500 £70,000
UK excluding London average salary £50,000 £48,000 £42,500
% change year-on-year
+4.16% +12.94%
Dimensional Modelling
London

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the City of London region.

Processes & Methodologies Category
City of London
Permanent IT job ads with a match in the
Processes & Methodologies category
8221 9740 9773
As % of all permanent IT jobs located in the City of London 84.98% 83.03% 82.65%
Number of salaries quoted 7041 8088 8617
Average salary £60,000 £55,000 £55,000
Average salary % change year-on-year
+9.09% -
90% offered a salary of more than £39,000 £37,500 £37,500
10% offered a salary of more than £85,000 £80,000 £80,000
UK excluding London average salary £45,000 £42,500 £41,500
% change year-on-year
+5.88% +2.40%

Dimensional Modelling
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of permanent IT jobs citing Dimensional Modelling across the City of London region as a proportion of the total demand within the Processes & Methodologies category.

Dimensional Modelling Jobs Demand Trend in the City of London

Dimensional Modelling
Salary Trend in the City of London

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

Dimensional Modelling Salary Trend in the City of London

Dimensional Modelling
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing Dimensional Modelling across the City of London region over the 3 months to 28 August 2015.

Dimensional Modelling Salary Histogram in the City of London

Dimensional Modelling
Top 30 Related IT Skills in the City of London

For the 6 months to 28 August 2015, IT jobs across the City of London region citing Dimensional Modelling also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Dimensional Modelling.

1 74 (87.06%) Business Intelligence
2 61 (71.76%) SQL Server
3 58 (68.24%) SQL Server Reporting Services
4 57 (67.06%) ETL
5 56 (65.88%) Data Warehouse
6 45 (52.94%) SQL
7 44 (51.76%) SQL Server Analysis Services
8 41 (48.24%) SQL Server Integration Services
9 38 (44.71%) Finance
10 33 (38.82%) T-SQL
11 31 (36.47%) Kimball Methodology
12 30 (35.29%) Analytics
13 28 (32.94%) Informatica
14 27 (31.76%) Oracle
15 26 (30.59%) BusinessObjects
16 24 (28.24%) Microsoft
17 23 (27.06%) Tableau
17 23 (27.06%) Analytical Skills
18 22 (25.88%) Data Management
19 21 (24.71%) Data Quality
19 21 (24.71%) Hadoop
20 20 (23.53%) QlikView
20 20 (23.53%) Big Data
21 19 (22.35%) Continuous Improvement
22 18 (21.18%) Data Extraction
22 18 (21.18%) Mentoring
22 18 (21.18%) Migration
23 17 (20.00%) Ab Initio
23 17 (20.00%) Teradata
23 17 (20.00%) Data Analysis

Dimensional Modelling
Top Related IT Skills in the City of London by Category

For the 6 months to 28 August 2015, IT jobs across the City of London region citing Dimensional Modelling also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Dimensional Modelling. Up to 20 skills are shown per category.

Application Platforms
1 17 (20.00%) SharePoint
1 17 (20.00%) SAS
Applications
1 12 (14.12%) MS Excel
2 4 (4.71%) PowerPivot
3 1 (1.18%) MS Office
Business Applications
1 2 (2.35%) SAP Oil and Gas
Cloud Services
1 2 (2.35%) Microsoft Azure
2 1 (1.18%) Google Analytics
Communications & Networking
1 2 (2.35%) FTP
Database & Business Intelligence
1 61 (71.76%) SQL Server
2 58 (68.24%) SQL Server Reporting Services
3 56 (65.88%) Data Warehouse
4 44 (51.76%) SQL Server Analysis Services
5 41 (48.24%) SQL Server Integration Services
6 26 (30.59%) BusinessObjects
7 21 (24.71%) Hadoop
8 20 (23.53%) QlikView
8 20 (23.53%) Big Data
9 15 (17.65%) PerformancePoint
10 12 (14.12%) Microsoft Analysis Services
11 11 (12.94%) SQL Server 2008
12 10 (11.76%) OLAP
13 9 (10.59%) Oracle Database
14 7 (8.24%) Oracle Database 11g
14 7 (8.24%) Oracle BI EE
15 5 (5.88%) BusinessObjects Web Intelligence
15 5 (5.88%) Relational Database
15 5 (5.88%) Crystal Reports
15 5 (5.88%) Oracle Reports
Development Applications
1 7 (8.24%) JIRA
2 6 (7.06%) Git (software)
3 1 (1.18%) Team Foundation Server
3 1 (1.18%) Octopus Deploy
3 1 (1.18%) Subversion
General
1 38 (44.71%) Finance
2 7 (8.24%) Banking
3 5 (5.88%) Law
3 5 (5.88%) Marketing
4 4 (4.71%) Telecoms
4 4 (4.71%) Investment Banking
5 2 (2.35%) Electronics
5 2 (2.35%) Retail
5 2 (2.35%) Manufacturing
5 2 (2.35%) Advertising
6 1 (1.18%) Billing
6 1 (1.18%) Pharmaceutical
6 1 (1.18%) Legal
Job Titles
1 55 (64.71%) Developer
2 38 (44.71%) Business Intelligence Developer
3 20 (23.53%) Architect
4 16 (18.82%) Senior Developer
5 15 (17.65%) Analyst
5 15 (17.65%) Data Architect
5 15 (17.65%) Senior Business Intelligence Developer
6 14 (16.47%) Analyst Developer
6 14 (16.47%) Business Intelligence Analyst
7 11 (12.94%) Business Developer
7 11 (12.94%) Data Scientist
8 7 (8.24%) Senior Business Intelligence Analyst
8 7 (8.24%) Senior Analyst
8 7 (8.24%) Senior Analyst Developer
9 6 (7.06%) Data Warehouse Developer
10 5 (5.88%) SQL Developer
11 4 (4.71%) Business Consultant
11 4 (4.71%) Business Intelligence Consultant
11 4 (4.71%) Consultant
12 3 (3.53%) Solutions Architect
Libraries, Frameworks & Software Standards
1 10 (11.76%) MDX
2 6 (7.06%) .NET
2 6 (7.06%) ASP.NET
3 4 (4.71%) Web Services
4 3 (3.53%) XML
5 2 (2.35%) Middleware
5 2 (2.35%) JSON
6 1 (1.18%) JMS
Miscellaneous
1 23 (27.06%) Analytical Skills
2 18 (21.18%) Data Extraction
3 6 (7.06%) Data Integration
4 5 (5.88%) Management Information System
5 3 (3.53%) Visualisation
6 2 (2.35%) DTV
7 1 (1.18%) Data Structures
7 1 (1.18%) Replication
7 1 (1.18%) Computer Science
Operating Systems
1 1 (1.18%) UNIX
1 1 (1.18%) Linux
Processes & Methodologies
1 74 (87.06%) Business Intelligence
2 57 (67.06%) ETL
3 31 (36.47%) Kimball Methodology
4 30 (35.29%) Analytics
5 22 (25.88%) Data Management
6 19 (22.35%) Continuous Improvement
7 18 (21.18%) Mentoring
7 18 (21.18%) Migration
8 17 (20.00%) Quality Management
8 17 (20.00%) Data Analysis
8 17 (20.00%) Data Migration
8 17 (20.00%) Data Analytics
8 17 (20.00%) Data Architecture
9 15 (17.65%) Coaching
10 14 (16.47%) Agile Software Development
11 7 (8.24%) CRM
12 6 (7.06%) Data Modelling
13 5 (5.88%) Multidimensional Analysis
14 4 (4.71%) Data Transformation
14 4 (4.71%) Performance Tuning
Programming Languages
1 45 (52.94%) SQL
2 33 (38.82%) T-SQL
3 9 (10.59%) PL/SQL
4 6 (7.06%) C#
5 5 (5.88%) R
6 4 (4.71%) C
7 3 (3.53%) Ruby
7 3 (3.53%) Data Analysis Expressions (DAX)
8 2 (2.35%) PowerShell
8 2 (2.35%) Scala
8 2 (2.35%) Python
8 2 (2.35%) JavaScript
9 1 (1.18%) Java
Qualifications
1 3 (3.53%) MCSE
1 3 (3.53%) Microsoft Certification
2 1 (1.18%) Degree
Quality Assurance & Compliance
1 21 (24.71%) Data Quality
2 1 (1.18%) Sarbanes-Oxley
System Software
1 1 (1.18%) Apache Flume
Systems Management
1 2 (2.35%) MOM
Vendors
1 28 (32.94%) Informatica
2 27 (31.76%) Oracle
3 24 (28.24%) Microsoft
4 23 (27.06%) Tableau
5 17 (20.00%) Netezza
5 17 (20.00%) Ab Initio
5 17 (20.00%) Teradata
6 3 (3.53%) SAP
6 3 (3.53%) Cognos
7 2 (2.35%) Sybase
7 2 (2.35%) MicroStrategy
7 2 (2.35%) Salesforce.com
7 2 (2.35%) Alteryx
8 1 (1.18%) Google
8 1 (1.18%) Hyperion
8 1 (1.18%) TIBCO
8 1 (1.18%) BT
8 1 (1.18%) IBM
City, London
Kyna Associates
Salary: £55000 - £70000 Per Annum Plus £5k car allowance, 10% bonus, home work
Posted: 2 days ago