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

Star Schema
UK
3 months to
27 Mar 2017
Same period 2016 Same period 2015
Rank 793 841 852
Rank change year-on-year +48 +11  
Permanent jobs citing Star Schema 71 108 99
As % of all permanent IT jobs advertised in the UK 0.084% 0.10% 0.092%
As % of the Database & Business Intelligence category 0.27% 0.34% 0.29%
Number of salaries quoted 60 93 84
Median salary £52,500 £50,000 £47,750
Median salary % change year-on-year +5.00% +4.71%  
90% offered a salary of more than £25,800 £38,661 £35,000
10% offered a salary of more than £55,000 £63,000 £70,000
UK excluding London median salary £45,000 £40,000 £40,750
% change year-on-year +12.50% -1.84%  

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 25997 32001 33814
As % of all permanent IT job vacancies advertised in the UK 30.73% 30.94% 31.31%
Number of salaries quoted 22058 27243 28645
Median salary £47,500 £50,000 £45,000
Median salary % change year-on-year -5.00% +11.11%  
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

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 27 March 2017.

Salary histogram for Star Schema in the UK

Star Schema
Top 30 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 27 March 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 +63 70 £52,500 +5.00% 7
London +50 31 £54,000 -1.81% 2
South East +63 13 £37,000 -10.30%
Oxfordshire - 6 £23,500 -
Yorkshire - 5 £37,500 -
West Yorkshire - 5 £37,500 -
Uxbridge 0 4 £55,000 +10.00%
Leeds - 4 £37,500 -
Suffolk +34 3 £38,000 +1.33% 1
East of England +24 3 £38,000 -10.58% 1
East Midlands +5 3 £43,750 -16.66% 1
Northamptonshire - 3 £43,750 - 1
Northampton - 3 £43,750 -
Berkshire +35 2 £37,000 -7.50%
Reading +34 2 £37,000 -7.50%
West Midlands +27 2 £26,000 -25.71%
North East - 2 £44,500 - 1
West End of London - 2 £45,000 - 1
Tyne and Wear - 2 £44,500 -
Surrey +39 1 £50,000 +11.11%
Hampshire +22 1 £48,500 -30.71%
Buckinghamshire +13 1 £45,000 +44.00%
South Wales +11 1 - -
Cardiff +10 1 - -
Wales +4 1 - -
Redhill +3 1 £50,000 +11.11%
Milton Keynes +1 1 £45,000 +44.00%
Bury St Edmunds 0 1 £36,000 -4.00% 1
Lichfield - 1 £26,000 -
Petersfield - 1 £48,500 -

Star Schema
Top 30 Co-occurring IT Skills

For the 6 months to 27 March 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 129 (86.58%) Data Warehouse
2 104 (69.80%) Business Intelligence
3 100 (67.11%) SQL
4 87 (58.39%) SQL Server
4 87 (58.39%) SQL Server Integration Services
5 70 (46.98%) ETL
6 67 (44.97%) Data Modelling
7 66 (44.30%) Oracle
7 66 (44.30%) SQL Server Reporting Services
8 62 (41.61%) SQL Server Analysis Services
9 60 (40.27%) Finance
10 52 (34.90%) Kimball Methodology
11 49 (32.89%) Agile Software Development
11 49 (32.89%) T-SQL
12 45 (30.20%) Microsoft
13 36 (24.16%) Informatica
14 35 (23.49%) Degree
15 29 (19.46%) MS Excel
16 28 (18.79%) Data Management
17 26 (17.45%) Oracle BI EE
18 25 (16.78%) Oracle Database
18 25 (16.78%) BusinessObjects
19 22 (14.77%) Oracle Reports
19 22 (14.77%) Performance Tuning
19 22 (14.77%) Mentoring
20 20 (13.42%) Relational Database
20 20 (13.42%) Oracle ODI
20 20 (13.42%) Retail
21 19 (12.75%) Data Migration
21 19 (12.75%) Oracle BI Publisher

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 4 (2.68%) Oracle SOA Suite
2 2 (1.34%) WebLogic
3 1 (0.67%) SAS
3 1 (0.67%) SharePoint
Applications
1 29 (19.46%) MS Excel
2 2 (1.34%) MS Office
3 1 (0.67%) MS Project
Business Applications
1 14 (9.40%) Oracle Applications
2 4 (2.68%) Cognos Business Intelligence
3 1 (0.67%) Dynamics AX
3 1 (0.67%) Oracle EBS
Cloud Services
1 11 (7.38%) Microsoft Azure
2 4 (2.68%) Amazon AWS
3 3 (2.01%) Google Cloud Platform
4 2 (1.34%) SaaS
Communications & Networking
1 1 (0.67%) Extranet
1 1 (0.67%) Internet
Database & Business Intelligence
1 129 (86.58%) Data Warehouse
2 87 (58.39%) SQL Server
2 87 (58.39%) SQL Server Integration Services
3 66 (44.30%) SQL Server Reporting Services
4 62 (41.61%) SQL Server Analysis Services
5 26 (17.45%) Oracle BI EE
6 25 (16.78%) BusinessObjects
6 25 (16.78%) Oracle Database
7 22 (14.77%) Oracle Reports
8 20 (13.42%) Oracle ODI
8 20 (13.42%) Relational Database
9 19 (12.75%) Oracle BI Publisher
10 18 (12.08%) Hadoop
10 18 (12.08%) MySQL
10 18 (12.08%) Snowflake Schema
11 17 (11.41%) Oracle Database 11g
12 16 (10.74%) BusinessObjects Business Intelligence
12 16 (10.74%) Oracle Database 12c
13 15 (10.07%) SAP Data Services
13 15 (10.07%) SQL Server 2012
Development Applications
1 18 (12.08%) Talend Open Studio
2 10 (6.71%) ERwin
3 7 (4.70%) Visual Studio
4 4 (2.68%) MagicDraw
General
1 60 (40.27%) Finance
2 20 (13.42%) Retail
3 19 (12.75%) Banking
4 11 (7.38%) Local Government
5 6 (4.03%) Investment Banking
6 4 (2.68%) Back Office
6 4 (2.68%) General Ledger
6 4 (2.68%) Publishing
7 3 (2.01%) Advertising
8 1 (0.67%) Automotive
8 1 (0.67%) German Language
8 1 (0.67%) Legal
Job Titles
1 75 (50.34%) Developer
2 42 (28.19%) Business Intelligence Developer
3 32 (21.48%) Consultant
4 31 (20.81%) SQL Developer
4 31 (20.81%) SSIS Developer
5 24 (16.11%) Data Warehouse Developer
6 21 (14.09%) Analyst
7 17 (11.41%) Data Analyst
7 17 (11.41%) SQL Analyst
8 16 (10.74%) Analyst Developer
8 16 (10.74%) Developer Analyst
8 16 (10.74%) OBIEE Consultant
8 16 (10.74%) Senior Consultant
8 16 (10.74%) SQL Data Analyst
9 15 (10.07%) Senior OBIEE Consultant
10 14 (9.40%) Data Warehouse Analyst
10 14 (9.40%) ETL Analyst
10 14 (9.40%) ETL Developer
10 14 (9.40%) SAP BusinessObjects (BO) Consultant
10 14 (9.40%) SSIS Analyst
Libraries, Frameworks & Software Standards
1 15 (10.07%) XML
2 5 (3.36%) .NET
3 4 (2.68%) Middleware
3 4 (2.68%) Web Services
3 4 (2.68%) XML Schema
4 3 (2.01%) Oracle GoldenGate
5 1 (0.67%) ASP.NET
5 1 (0.67%) CSS
5 1 (0.67%) HTML
5 1 (0.67%) jQuery
5 1 (0.67%) JSON
5 1 (0.67%) MDX
5 1 (0.67%) Twitter Bootstrap
Miscellaneous
1 16 (10.74%) Analytical Skills
2 8 (5.37%) Computer Science
2 8 (5.37%) Management Information System
3 7 (4.70%) Credit Risk
3 7 (4.70%) Market Risk
3 7 (4.70%) Replication
4 6 (4.03%) Data Structures
4 6 (4.03%) NHS
5 4 (2.68%) Reference Data
5 4 (2.68%) Taxonomies
6 3 (2.01%) Semantic Web
7 2 (1.34%) Algorithms
7 2 (1.34%) Enterprise Software
7 2 (1.34%) Fintech
8 1 (0.67%) Client/Server
8 1 (0.67%) Driving Licence
8 1 (0.67%) iSeries
Operating Systems
1 1 (0.67%) AIX
1 1 (0.67%) Unix
Processes & Methodologies
1 104 (69.80%) Business Intelligence
2 70 (46.98%) ETL
3 67 (44.97%) Data Modelling
4 52 (34.90%) Kimball Methodology
5 49 (32.89%) Agile Software Development
6 28 (18.79%) Data Management
7 22 (14.77%) Mentoring
7 22 (14.77%) Performance Tuning
8 19 (12.75%) Data Migration
8 19 (12.75%) Information Architecture
8 19 (12.75%) Migration
9 16 (10.74%) Dimensional Modelling
10 15 (10.07%) Logical Data Model
11 14 (9.40%) Analytics
11 14 (9.40%) Data Integration
11 14 (9.40%) Front End Development
12 12 (8.05%) Security Management
13 11 (7.38%) Data Architecture
13 11 (7.38%) Data Visualisation
13 11 (7.38%) High Availability
Programming Languages
1 100 (67.11%) SQL
2 49 (32.89%) T-SQL
3 10 (6.71%) PL/SQL
4 5 (3.36%) C#
5 1 (0.67%) Data Analysis Expressions (DAX)
5 1 (0.67%) JavaScript
5 1 (0.67%) R
Qualifications
1 35 (23.49%) Degree
Quality Assurance & Compliance
1 17 (11.41%) Data Quality
2 4 (2.68%) ISO20022
3 1 (0.67%) GDPR
3 1 (0.67%) QA
Vendors
1 66 (44.30%) Oracle
2 45 (30.20%) Microsoft
3 36 (24.16%) Informatica
4 18 (12.08%) Talend
5 17 (11.41%) Cognos
6 16 (10.74%) SAP
7 11 (7.38%) Tableau
8 9 (6.04%) IBM
9 4 (2.68%) Google
9 4 (2.68%) Jaspersoft
9 4 (2.68%) Teradata
10 3 (2.01%) Hyperion
11 1 (0.67%) Birst
11 1 (0.67%) Pegasus
Northamptonshire
Nigel Frank International
Salary: £45000 per annum + unique benefits
Posted: 19 hours ago
Glasgow, Lanarkshire
Empiric.com
Salary: From £60,000 to £75,000 per annum Bonus and Benefits package
Posted: 4 days ago
Central London / West End
The Workshop
Posted: 3 days ago
Bury St. Edmunds, Suffolk
TLP Consultancy Ltd.
Salary: £27000 - £45000 per annum + package
Posted: 6 days ago