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 3 months to 23 June 2017 with a comparison to the same period in the previous 2 years.

Star Schema
UK
3 months to
23 Jun 2017
Same period 2016 Same period 2015
Rank 804 822 818
Rank change year-on-year +18 -4  
Permanent jobs citing Star Schema 66 91 170
As % of all permanent IT jobs advertised in the UK 0.074% 0.093% 0.15%
As % of the Database & Business Intelligence category 0.24% 0.31% 0.47%
Number of salaries quoted 46 72 91
Median salary £50,000 £52,500 £55,000
Median salary % change year-on-year -4.76% -4.54%  
90% offered a salary of more than £40,000 £42,650 £38,500
10% offered a salary of more than £67,500 £72,250 £85,000
UK excluding London median salary £48,500 £52,500 £43,500
% change year-on-year -7.61% +20.68%  

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

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 27480 29464 36179
As % of all permanent IT job vacancies advertised in the UK 30.84% 29.96% 32.63%
Number of salaries quoted 23172 25102 30538
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,500
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

Star Schema
Job Vacancy Trend

The job posting trend of jobs advertised citing Star Schema as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

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 3 months to 23 June 2017.

Salary histogram for Star Schema in the UK

Star Schema
Top 28 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 3 months to 23 June 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 +27 58 £48,500 -7.61% 9
London -19 26 £54,000 +2.85% 2
South West +16 9 £48,500 -11.81% 2
Somerset - 9 £48,500 - 1
Bath - 9 £48,500 - 1
South East +54 6 £62,500 +5.48% 2
Scotland +13 6 £65,000 +36.84%
Glasgow +10 6 £65,000 +36.84%
East of England - 6 £41,250 -
East Midlands +18 5 £51,500 -1.90% 1
Northampton - 5 £51,500 -
Northamptonshire - 5 £51,500 - 1
West Sussex - 4 £62,500 -
North West -41 3 £55,000 +59.42% 1
Hatfield - 3 £42,500 -
Suffolk - 3 £40,000 -
Bury St Edmunds - 3 £40,000 -
Hertfordshire - 3 £42,500 -
Yorkshire +6 2 £41,250 -2.94%
Cheshire -26 2 £55,000 +89.65%
Warrington - 2 £55,000 -
Surrey +33 1 £47,500 -15.17%
Berkshire +29 1 £40,000 -42.85%
Manchester -17 1 £57,500 -
East Yorkshire - 1 £37,500 -
West Yorkshire - 1 £45,000 -
Leeds - 1 £45,000 -
Hull - 1 £37,500 -

For the 6 months to 23 June 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 117 (86.03%) Data Warehouse
2 105 (77.21%) SQL
3 104 (76.47%) Business Intelligence
4 74 (54.41%) SQL Server Integration Services
5 69 (50.74%) SQL Server
6 61 (44.85%) Data Modelling
7 60 (44.12%) ETL
7 60 (44.12%) Kimball Methodology
8 57 (41.91%) SQL Server Reporting Services
9 52 (38.24%) Oracle
9 52 (38.24%) SQL Server Analysis Services
10 48 (35.29%) Microsoft
11 44 (32.35%) Agile Software Development
12 41 (30.15%) Finance
13 38 (27.94%) T-SQL
14 29 (21.32%) Informatica
14 29 (21.32%) Mentoring
15 27 (19.85%) Dimensional Modelling
16 24 (17.65%) Degree
17 23 (16.91%) Data Quality
18 22 (16.18%) SAP
18 22 (16.18%) Oracle Reports
19 21 (15.44%) Performance Tuning
19 21 (15.44%) Visualisation
20 20 (14.71%) Oracle BI EE
20 20 (14.71%) Data Visualisation
20 20 (14.71%) Scrum
21 18 (13.24%) Migration
21 18 (13.24%) Retail
21 18 (13.24%) Oracle Database

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 2 (1.47%) WebLogic
2 1 (0.74%) Oracle SOA Suite
2 1 (0.74%) SAS
2 1 (0.74%) SharePoint
Applications
1 8 (5.88%) Microsoft Excel
2 4 (2.94%) Microsoft Project
Business Applications
1 15 (11.03%) Oracle Applications
2 9 (6.62%) SAP Oil and Gas
3 1 (0.74%) Cognos Business Intelligence
3 1 (0.74%) Dynamics AX
Cloud Services
1 13 (9.56%) Microsoft Azure
2 4 (2.94%) Cloud Computing
3 3 (2.21%) SaaS
4 1 (0.74%) Azure Data Factory
4 1 (0.74%) Google Cloud Platform
Communications & Networking
1 8 (5.88%) Internet
2 4 (2.94%) Extranet
Database & Business Intelligence
1 117 (86.03%) Data Warehouse
2 74 (54.41%) SQL Server Integration Services
3 69 (50.74%) SQL Server
4 57 (41.91%) SQL Server Reporting Services
5 52 (38.24%) SQL Server Analysis Services
6 22 (16.18%) Oracle Reports
7 20 (14.71%) Oracle BI EE
8 18 (13.24%) Oracle Database
8 18 (13.24%) Relational Database
8 18 (13.24%) SQL Server 2008
9 17 (12.50%) Big Data
9 17 (12.50%) Oracle BI Publisher
9 17 (12.50%) Oracle ODI
10 16 (11.76%) BusinessObjects
10 16 (11.76%) Hadoop
11 15 (11.03%) Endeca
11 15 (11.03%) Oracle Database 11g
11 15 (11.03%) Oracle Database 12c
12 13 (9.56%) RDBMS
12 13 (9.56%) SQL Server 2014
Development Applications
1 10 (7.35%) Talend Open Studio
2 8 (5.88%) ERwin
3 4 (2.94%) Visual Studio
4 3 (2.21%) MagicDraw
5 2 (1.47%) JIRA
5 2 (1.47%) Subversion
5 2 (1.47%) Team Foundation Server
General
1 41 (30.15%) Finance
2 18 (13.24%) Retail
3 13 (9.56%) Publishing
4 10 (7.35%) Marketing
4 10 (7.35%) Telecoms
5 9 (6.62%) Electronics
5 9 (6.62%) Local Government
5 9 (6.62%) Manufacturing
6 8 (5.88%) Advertising
7 4 (2.94%) Banking
8 1 (0.74%) Automotive
8 1 (0.74%) German Language
8 1 (0.74%) Legal
Job Titles
1 68 (50.00%) Developer
2 36 (26.47%) Business Intelligence Developer
3 33 (24.26%) Data Warehouse Developer
4 25 (18.38%) Consultant
5 20 (14.71%) SQL Developer
6 17 (12.50%) SSIS Developer
7 15 (11.03%) OBIEE Consultant
7 15 (11.03%) Senior Consultant
7 15 (11.03%) Senior OBIEE Consultant
8 13 (9.56%) Analyst
9 12 (8.82%) Architect
10 11 (8.09%) SQL Analyst
10 11 (8.09%) SQL Server Developer
11 10 (7.35%) Business Consultant
11 10 (7.35%) SAP BusinessObjects (BO) Consultant
11 10 (7.35%) SQL Data Analyst
11 10 (7.35%) SSRS Developer
11 10 (7.35%) Tableau Developer
12 9 (6.62%) Data Analyst
12 9 (6.62%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 7 (5.15%) XML
2 5 (3.68%) .NET
3 3 (2.21%) MDX
3 3 (2.21%) XML Schema
4 1 (0.74%) ASP.NET
4 1 (0.74%) Middleware
4 1 (0.74%) Oracle GoldenGate
Miscellaneous
1 13 (9.56%) Analytical Skills
1 13 (9.56%) Greenfield Project
2 7 (5.15%) Management Information System
3 6 (4.41%) Computer Science
4 5 (3.68%) Data Structures
5 4 (2.94%) Client/Server
5 4 (2.94%) Digital Media
5 4 (2.94%) Internet of Things
6 3 (2.21%) NHS
6 3 (2.21%) Replication
6 3 (2.21%) Taxonomies
7 2 (1.47%) Algorithms
7 2 (1.47%) Equities
7 2 (1.47%) Fintech
7 2 (1.47%) Fixed Income
7 2 (1.47%) Reference Data
Operating Systems
1 3 (2.21%) Unix
Processes & Methodologies
1 104 (76.47%) Business Intelligence
2 61 (44.85%) Data Modelling
3 60 (44.12%) ETL
3 60 (44.12%) Kimball Methodology
4 44 (32.35%) Agile Software Development
5 29 (21.32%) Mentoring
6 27 (19.85%) Dimensional Modelling
7 21 (15.44%) Performance Tuning
7 21 (15.44%) Visualisation
8 20 (14.71%) Data Visualisation
8 20 (14.71%) Scrum
9 18 (13.24%) Data Migration
9 18 (13.24%) Migration
10 16 (11.76%) Data Architecture
10 16 (11.76%) Data Management
11 15 (11.03%) Data Governance
11 15 (11.03%) Data Integration
12 14 (10.29%) Analytics
13 13 (9.56%) Data Security
13 13 (9.56%) Kalman Filter
Programming Languages
1 105 (77.21%) SQL
2 38 (27.94%) T-SQL
3 11 (8.09%) PL/SQL
4 6 (4.41%) C#
5 3 (2.21%) Python
5 3 (2.21%) R
6 2 (1.47%) Data Analysis Expressions (DAX)
6 2 (1.47%) JavaScript
6 2 (1.47%) Perl
6 2 (1.47%) Ruby
Qualifications
1 24 (17.65%) Degree
2 7 (5.15%) Computer Science Degree
3 3 (2.21%) Microsoft Certification
Quality Assurance & Compliance
1 23 (16.91%) Data Quality
2 4 (2.94%) QA
3 2 (1.47%) ISO 20022
4 1 (0.74%) GDPR
Vendors
1 52 (38.24%) Oracle
2 48 (35.29%) Microsoft
3 29 (21.32%) Informatica
4 22 (16.18%) SAP
5 16 (11.76%) Tableau
6 10 (7.35%) Cognos
6 10 (7.35%) Talend
7 7 (5.15%) IBM
8 6 (4.41%) Teradata
9 3 (2.21%) MicroStrategy
9 3 (2.21%) Vertica
10 1 (0.74%) Birst
10 1 (0.74%) Google
10 1 (0.74%) Salesforce.com
Liverpool
Nigel Frank International
Salary: £40000 - £45000 per annum + company benefits
Posted: 18 hours ago
Kent
Client Server
Salary: £40k to £45k + benefits
Posted: Yesterday
Lichfield, Staffordshire
Computer People
Salary: £30000.00 - £40000.00 per annum
Posted: Yesterday
Northamptonshire
Nigel Frank International
Salary: £45000 - £58000 per annum + benefits
Posted: 3 days ago
North London
Understanding Recruitment
Salary: £42000 - £46000 per annum + Benefits
Posted: 5 days ago
Bath
People Source Consulting
Salary: £37000 - £43000 per annum
Posted: 11 days ago
City, London
Charles Taylor plc
Salary: Market related
Posted: 8 days ago
Kent
Client Server
Salary: £40000 - £45000 per annum + benefits
Posted: 16 days ago