Period
to 22 November 2017

The following table provides summary statistics for permanent job vacancies with a requirement for Star Schema skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Star Schema over the 6 months to 22 November 2017 with a comparison to the same period in the previous 2 years.

Star Schema
UK
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 984 1039 1069
Rank change year-on-year +55 +30 +14
Permanent jobs citing Star Schema 199 186 240
As % of all permanent IT jobs advertised in the UK 0.11% 0.098% 0.11%
As % of the Database & Business Intelligence category 0.36% 0.33% 0.35%
Number of salaries quoted 105 155 174
UK median annual salary £50,000 £54,000 £43,500
Median salary % change year-on-year -7.41% +24.14% -9.38%
10th Percentile £32,500 £34,500 £27,350
90th Percentile £67,500 £80,000 £71,250
UK excluding London median annual salary £48,500 £45,000 £41,500
% change year-on-year +7.78% +8.43% -13.54%

Star Schema is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 54610 56430 67973
As % of all permanent IT jobs advertised in the UK 30.24% 29.67% 31.50%
Number of salaries quoted 44953 48258 57223
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

Star Schema
Job Vacancy Trend

Job postings citing Star Schema as a percentage of all IT jobs advertised.

Job vacancy trend for Star Schema in the UK

Star Schema
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Star Schema.

Salary trend for Star Schema in the UK

Star Schema
Salary Histogram

The salary distribution of IT jobs citing Star Schema over the 6 months to 22 November 2017.

Salary histogram for Star Schema in the UK

Star Schema
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Star Schema within the UK over the 6 months to 22 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
England +28 184 £50,000 -7.41% 12
London -2 106 £55,000 -8.33% 6
UK excluding London +53 92 £48,500 +7.78% 7
South East +50 27 £47,500 -12.04%
North of England -5 25 £42,500 +14.86% 2
Yorkshire +29 17 £37,500 -16.67% 1
South West - 17 £42,500 - 2
Scotland -10 12 £62,000 +30.53% 1
North West -22 8 £65,000 +80.56% 1
East of England +19 5 £50,000 +33.33% 2
Midlands +10 3 £51,500 +28.75%
Isle of Man - 3 £50,000 -
East Midlands +39 2 £51,500 +62.69%
West Midlands -17 1 £35,000 -12.50%

For the 6 months to 22 November 2017, IT jobs citing Star Schema 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 Star Schema.

1 163 (81.91%) Business Intelligence
2 125 (62.81%) Data Warehouse
3 113 (56.78%) Microsoft
4 104 (52.26%) SQL
4 104 (52.26%) Finance
5 95 (47.74%) Data Modelling
5 95 (47.74%) Relational Database
6 89 (44.72%) ETL
7 78 (39.20%) SQL Server
8 74 (37.19%) Degree
9 70 (35.18%) Power BI
10 68 (34.17%) Kimball Methodology
11 64 (32.16%) Java
12 58 (29.15%) MicroStrategy
12 58 (29.15%) SQL Server Integration Services
13 53 (26.63%) SQL Server Reporting Services
14 52 (26.13%) Banking
15 51 (25.63%) SQL Server Analysis Services
16 50 (25.13%) Agile Software Development
17 47 (23.62%) Analytics
17 47 (23.62%) Visualisation
17 47 (23.62%) Asset Management
17 47 (23.62%) OO
18 46 (23.12%) Investment Banking
18 46 (23.12%) Wealth Management
18 46 (23.12%) SDLC
19 45 (22.61%) Risk Analysis
19 45 (22.61%) Retail Banking
19 45 (22.61%) OOD
19 45 (22.61%) Front Office

Star Schema
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 15 (7.54%) Apache Spark
2 11 (5.53%) Apache Pig
2 11 (5.53%) SAS
3 8 (4.02%) Apache
4 4 (2.01%) SharePoint
5 2 (1.01%) Smallworld
Applications
1 9 (4.52%) Microsoft Excel
1 9 (4.52%) Microsoft Office
2 7 (3.52%) Microsoft PowerPoint
2 7 (3.52%) MS Visio
2 7 (3.52%) SPSS
3 1 (0.50%) Microsoft Project
Business Applications
1 3 (1.51%) Oracle BPM
2 2 (1.01%) SAP PM
3 1 (0.50%) Oracle ERP
Cloud Services
1 6 (3.02%) Amazon AWS
1 6 (3.02%) Microsoft Azure
2 4 (2.01%) Amazon EMR
2 4 (2.01%) Google Cloud Platform
3 1 (0.50%) Azure Data Factory
Communications & Networking
1 1 (0.50%) Extranet
1 1 (0.50%) Internet
Database & Business Intelligence
1 125 (62.81%) Data Warehouse
2 95 (47.74%) Relational Database
3 78 (39.20%) SQL Server
4 70 (35.18%) Power BI
5 58 (29.15%) SQL Server Integration Services
6 53 (26.63%) SQL Server Reporting Services
7 51 (25.63%) SQL Server Analysis Services
8 25 (12.56%) RDBMS
9 24 (12.06%) QlikView
10 23 (11.56%) BusinessObjects
11 22 (11.06%) Snowflake Schema
12 20 (10.05%) Hadoop
13 19 (9.55%) SQL Server 2008
14 18 (9.05%) BusinessObjects Web Intelligence
15 17 (8.54%) NoSQL
16 16 (8.04%) Lumira
16 16 (8.04%) Semantic Layer
17 15 (7.54%) Big Data
17 15 (7.54%) OLAP
18 13 (6.53%) HBase
Development Applications
1 8 (4.02%) Team Foundation Server
2 7 (3.52%) Toad
2 7 (3.52%) Visual Studio
3 5 (2.51%) Oracle APEX
3 5 (2.51%) Oracle Forms
3 5 (2.51%) SQL Server Management Studio (SSMS)
3 5 (2.51%) Talend Open Studio
4 4 (2.01%) JIRA
4 4 (2.01%) Subversion
5 3 (1.51%) ERwin
5 3 (1.51%) MagicDraw
6 1 (0.50%) VSS/SourceSafe
General
1 104 (52.26%) Finance
2 52 (26.13%) Banking
3 46 (23.12%) Investment Banking
4 45 (22.61%) Financial Institution
4 45 (22.61%) Front Office
4 45 (22.61%) Retail Banking
5 29 (14.57%) Marketing
6 16 (8.04%) Retail
6 16 (8.04%) Telecoms
7 13 (6.53%) Electronics
7 13 (6.53%) Manufacturing
8 7 (3.52%) Advertising
8 7 (3.52%) Games
8 7 (3.52%) Publishing
9 5 (2.51%) Back Office
10 3 (1.51%) Retail Finance
11 2 (1.01%) Billing
11 2 (1.01%) Legal
Job Titles
1 79 (39.70%) Developer
2 43 (21.61%) Business Intelligence Developer
3 29 (14.57%) Analyst
4 25 (12.56%) Architect
5 19 (9.55%) Data Architect
5 19 (9.55%) SSRS Developer
6 17 (8.54%) Business Developer
7 16 (8.04%) ETL Developer
8 14 (7.04%) Business Intelligence Lead
8 14 (7.04%) SQL Developer
8 14 (7.04%) SSIS Developer
9 13 (6.53%) Data Warehouse Developer
10 11 (5.53%) Team Leader
11 10 (5.03%) Data Analyst
12 9 (4.52%) Analyst Developer
12 9 (4.52%) Business Intelligence Analyst
12 9 (4.52%) Developer Analyst
12 9 (4.52%) SAP BusinessObjects (BO) Analyst
12 9 (4.52%) SAP BusinessObjects (BO) Developer
13 8 (4.02%) Data Warehouse Analyst
Libraries, Frameworks & Software Standards
1 16 (8.04%) XML
2 7 (3.52%) JSON
3 4 (2.01%) MDX
4 3 (1.51%) Middleware
4 3 (1.51%) XML Schema
5 2 (1.01%) CSS
5 2 (1.01%) D3.js
5 2 (1.01%) HTML
Miscellaneous
1 31 (15.58%) Analytical Skills
2 18 (9.05%) Computer Science
3 15 (7.54%) Data Structures
4 11 (5.53%) Greenfield Project
5 9 (4.52%) Mainframe
6 7 (3.52%) Credit Risk
7 5 (2.51%) Semantic Web
8 4 (2.01%) Fintech
9 3 (1.51%) N-Tier
9 3 (1.51%) Taxonomies
10 2 (1.01%) Enterprise Software
10 2 (1.01%) Equities
10 2 (1.01%) Fixed Income
10 2 (1.01%) Management Information System
10 2 (1.01%) Reference Data
11 1 (0.50%) Client/Server
11 1 (0.50%) Virtual Team
Operating Systems
1 10 (5.03%) Linux
2 9 (4.52%) Unix
3 2 (1.01%) Windows
Processes & Methodologies
1 163 (81.91%) Business Intelligence
2 95 (47.74%) Data Modelling
3 89 (44.72%) ETL
4 68 (34.17%) Kimball Methodology
5 50 (25.13%) Agile Software Development
6 47 (23.62%) Analytics
6 47 (23.62%) Asset Management
6 47 (23.62%) OO
6 47 (23.62%) Visualisation
7 46 (23.12%) SDLC
7 46 (23.12%) Wealth Management
8 45 (22.61%) OOD
8 45 (22.61%) Risk Analysis
8 45 (22.61%) Risk Management
9 37 (18.59%) Data Integration
10 35 (17.59%) Data Management
11 33 (16.58%) Scrum
12 32 (16.08%) Data Architecture
13 31 (15.58%) Performance Tuning
14 30 (15.08%) Data Visualisation
Programming Languages
1 104 (52.26%) SQL
2 64 (32.16%) Java
3 33 (16.58%) T-SQL
4 27 (13.57%) Python
5 15 (7.54%) PL/SQL
6 14 (7.04%) Shell Script
7 9 (4.52%) R
8 7 (3.52%) MATLAB
9 6 (3.02%) JavaScript
10 4 (2.01%) C#
11 3 (1.51%) COBOL
11 3 (1.51%) Data Analysis Expressions (DAX)
11 3 (1.51%) JCL
12 2 (1.01%) Scala
12 2 (1.01%) VB
Qualifications
1 74 (37.19%) Degree
2 8 (4.02%) Computer Science Degree
2 8 (4.02%) MBA
3 6 (3.02%) Postgraduate
4 1 (0.50%) Numerate Degree
Quality Assurance & Compliance
1 41 (20.60%) Data Quality
2 14 (7.04%) QA
3 2 (1.01%) GCP
3 2 (1.01%) ISO 20022
4 1 (0.50%) SLA
System Software
1 4 (2.01%) Apache Flume
1 4 (2.01%) HDFS
Systems Management
1 4 (2.01%) Nagios
1 4 (2.01%) Oozie
Vendors
1 113 (56.78%) Microsoft
2 58 (29.15%) MicroStrategy
3 39 (19.60%) Tableau
4 36 (18.09%) Oracle
5 30 (15.08%) SAP
6 11 (5.53%) Informatica
7 9 (4.52%) Cognos
8 7 (3.52%) Alteryx
8 7 (3.52%) Birst
9 5 (2.51%) Talend
10 4 (2.01%) Cloudera
10 4 (2.01%) Google
11 2 (1.01%) Ab Initio
11 2 (1.01%) Capita
11 2 (1.01%) IBM
12 1 (0.50%) Logi
12 1 (0.50%) Logi Analytics
12 1 (0.50%) TIBCO