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

3 months to
22 Jan 2017
Same period 2016 Same period 2015
Star Schema
UK
Rank 775 843 868
Rank change year-on-year
+68 +25
Permanent jobs citing Star Schema 78 104 81
As % of all permanent IT jobs located in the UK 0.094% 0.10% 0.077%
As % of the Database & Business Intelligence category 0.31% 0.32% 0.25%
Number of salaries quoted 70 99 71
Median salary £53,250 £46,000 £44,000
Median salary % change year-on-year
+15.76% +4.54%
90% offered a salary of more than £30,000 £35,000 £30,000
10% offered a salary of more than £65,000 £67,500 £55,000
UK excluding London median salary £46,000 £40,000 £46,500
% change year-on-year
+15.00% -13.97%

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

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
25139 32234 32433
As % of all permanent IT jobs located in the UK 30.28% 32.11% 30.95%
Number of salaries quoted 21611 27264 27821
Median salary £50,000 £47,850 £45,000
Median salary % change year-on-year
+4.49% +6.33%
90% offered a salary of more than £32,500 £32,500 £30,565
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

Star Schema
Jobs Demand Trend

The demand trend of job ads citing Star Schema as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

Star Schema Jobs Demand Trend 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 within the UK.

Star Schema Salary Trend in the UK

Star Schema
Salary Histogram

This chart provides a salary histogram for IT jobs citing Star Schema over the 3 months to 22 January 2017 within the UK.

Star Schema Salary Histogram 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 22 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 +78 74 £52,500 +9.83% 10
London +48 29 £55,000 - 4
South East +64 21 £45,000 +12.50% 5
Uxbridge - 10 £55,000 - 1
Surrey +50 7 £50,000 -13.04% 1
West Midlands +4 7 £45,500 +30.00%
Redhill - 7 £50,000 -
Berkshire +43 6 £37,000 -7.50%
North West - 6 £43,500 -
Reading +39 5 £37,000 -7.50%
West Yorkshire +34 4 £37,500 +25.00%
Yorkshire +31 4 £37,500 +25.00%
Scotland +22 4 £80,000 +100.00%
Manchester - 4 £53,500 -
Oxfordshire - 4 £24,000 - 2
Glasgow +25 3 - -
Birmingham +1 3 £46,000 +31.42%
Leeds +31 2 £30,000 -
Kent +15 2 £54,000 +54.28%
Cheshire - 2 £36,000 -
Warrington - 2 £36,000 -
Bradford - 2 £45,000 -
City of London +44 1 £80,000 +88.23% 1
Hampshire +16 1 £45,000 -1.09% 1
Staffordshire +3 1 £26,000 -1.04%
Warwickshire - 1 £45,000 -
Walsall - 1 - -
Rugby - 1 £45,000 -
Petersfield - 1 £45,000 - 1
Lichfield - 1 £26,000 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 22 January 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 154 (83.70%) Data Warehouse
2 128 (69.57%) Business Intelligence
3 116 (63.04%) SQL
4 101 (54.89%) SQL Server
4 101 (54.89%) ETL
5 96 (52.17%) SQL Server Integration Services
6 87 (47.28%) Data Modelling
7 83 (45.11%) Oracle
8 78 (42.39%) Finance
9 75 (40.76%) SQL Server Analysis Services
10 72 (39.13%) SQL Server Reporting Services
11 65 (35.33%) Kimball Methodology
12 60 (32.61%) Microsoft
13 51 (27.72%) T-SQL
14 42 (22.83%) Agile Software Development
15 38 (20.65%) Informatica
16 36 (19.57%) Data Management
17 35 (19.02%) Degree
18 33 (17.93%) Snowflake Schema
18 33 (17.93%) MS Excel
19 30 (16.30%) Information Architecture
19 30 (16.30%) Oracle Database
20 28 (15.22%) Data Integration
20 28 (15.22%) Retail
21 27 (14.67%) Oracle BI EE
22 25 (13.59%) Migration
22 25 (13.59%) Performance Tuning
22 25 (13.59%) Mentoring
23 24 (13.04%) Analytical Skills
24 23 (12.50%) Relational Database

Star Schema
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 5 (2.72%) WebLogic
2 4 (2.17%) Oracle SOA Suite
3 1 (0.54%) Apache Airflow
3 1 (0.54%) Elasticsearch
3 1 (0.54%) Luigi
3 1 (0.54%) SAS
3 1 (0.54%) SharePoint
Applications
1 33 (17.93%) MS Excel
2 2 (1.09%) MS Office
Business Applications
1 16 (8.70%) Oracle Applications
2 4 (2.17%) Cognos Business Intelligence
3 1 (0.54%) Oracle EBS
Cloud Services
1 8 (4.35%) Amazon AWS
2 4 (2.17%) Google Cloud Platform
2 4 (2.17%) Microsoft Azure
3 1 (0.54%) SaaS
Database & Business Intelligence
1 154 (83.70%) Data Warehouse
2 101 (54.89%) SQL Server
3 96 (52.17%) SQL Server Integration Services
4 75 (40.76%) SQL Server Analysis Services
5 72 (39.13%) SQL Server Reporting Services
6 33 (17.93%) Snowflake Schema
7 30 (16.30%) Oracle Database
8 27 (14.67%) Oracle BI EE
9 23 (12.50%) Relational Database
10 22 (11.96%) BusinessObjects
10 22 (11.96%) Enterprise Data Warehouse
10 22 (11.96%) OLAP
10 22 (11.96%) QlikView
11 20 (10.87%) Oracle Reports
12 19 (10.33%) Oracle Database 11g
12 19 (10.33%) Oracle ODI
13 18 (9.78%) Oracle Database 12c
14 17 (9.24%) Oracle BI Publisher
14 17 (9.24%) SQL Server 2008
15 15 (8.15%) SQL Server 2005
Development Applications
1 22 (11.96%) ERwin
2 15 (8.15%) Talend Open Studio
3 8 (4.35%) Visual Studio
4 4 (2.17%) MagicDraw
5 2 (1.09%) JIRA
General
1 78 (42.39%) Finance
2 28 (15.22%) Retail
3 23 (12.50%) Banking
4 6 (3.26%) Investment Banking
5 4 (2.17%) Back Office
5 4 (2.17%) General Ledger
5 4 (2.17%) Local Government
6 2 (1.09%) Legal
7 1 (0.54%) Law
7 1 (0.54%) Marketing
Job Titles
1 89 (48.37%) Developer
2 39 (21.20%) Business Intelligence Developer
3 38 (20.65%) SQL Developer
4 37 (20.11%) Data Warehouse Developer
5 33 (17.93%) SSIS Developer
6 31 (16.85%) Architect
7 27 (14.67%) Analyst
8 25 (13.59%) Consultant
9 23 (12.50%) SQL Analyst
10 22 (11.96%) Data Architect
11 20 (10.87%) Analyst Developer
11 20 (10.87%) SQL Data Analyst
12 18 (9.78%) Data Warehouse Analyst
12 18 (9.78%) SSRS Developer
13 15 (8.15%) Data Analyst
13 15 (8.15%) ETL Developer
14 14 (7.61%) Developer Analyst
14 14 (7.61%) Senior Consultant
14 14 (7.61%) Senior Developer
14 14 (7.61%) SSAS Developer
Libraries, Frameworks & Software Standards
1 17 (9.24%) XML
2 11 (5.98%) MDX
3 10 (5.43%) Web Services
4 4 (2.17%) CSS
4 4 (2.17%) HTML
4 4 (2.17%) Middleware
4 4 (2.17%) Oracle GoldenGate
4 4 (2.17%) XML Schema
5 3 (1.63%) JSON
5 3 (1.63%) Twitter Bootstrap
6 2 (1.09%) .NET
6 2 (1.09%) AngularJS
6 2 (1.09%) CSS3
6 2 (1.09%) HTML5
6 2 (1.09%) REST
6 2 (1.09%) WCF
7 1 (0.54%) jQuery
7 1 (0.54%) Kafka
Miscellaneous
1 28 (15.22%) Data Integration
2 24 (13.04%) Analytical Skills
3 16 (8.70%) Management Information System
4 11 (5.98%) Computer Science
4 11 (5.98%) Credit Risk
4 11 (5.98%) Market Risk
5 9 (4.89%) Data Structures
6 8 (4.35%) Mathematics
7 7 (3.80%) Visualisation
8 6 (3.26%) Replication
9 5 (2.72%) NHS
10 4 (2.17%) Ontologies
10 4 (2.17%) Reference Data
10 4 (2.17%) Taxonomies
11 3 (1.63%) Semantic Web
12 2 (1.09%) Algorithms
12 2 (1.09%) Data Extraction
12 2 (1.09%) Economics
12 2 (1.09%) Enterprise Software
12 2 (1.09%) Psychology
Operating Systems
1 1 (0.54%) AIX
1 1 (0.54%) Android
1 1 (0.54%) Apple iOS
1 1 (0.54%) Linux
1 1 (0.54%) Unix
Processes & Methodologies
1 128 (69.57%) Business Intelligence
2 101 (54.89%) ETL
3 87 (47.28%) Data Modelling
4 65 (35.33%) Kimball Methodology
5 42 (22.83%) Agile Software Development
6 36 (19.57%) Data Management
7 30 (16.30%) Information Architecture
8 25 (13.59%) Mentoring
8 25 (13.59%) Migration
8 25 (13.59%) Performance Tuning
9 23 (12.50%) Data Migration
9 23 (12.50%) Master Data Management
10 22 (11.96%) Analytics
11 21 (11.41%) Data Analysis
11 21 (11.41%) Data Cleansing
12 20 (10.87%) Data Architecture
12 20 (10.87%) Logical Data Model
13 18 (9.78%) CRM
13 18 (9.78%) Software Engineering
14 17 (9.24%) Technical Architecture
Programming Languages
1 116 (63.04%) SQL
2 51 (27.72%) T-SQL
3 19 (10.33%) PL/SQL
4 4 (2.17%) JavaScript
5 3 (1.63%) C#
5 3 (1.63%) Data Analysis Expressions (DAX)
6 2 (1.09%) TypeScript
6 2 (1.09%) VB.NET
7 1 (0.54%) Bash Shell
7 1 (0.54%) Java
7 1 (0.54%) Python
7 1 (0.54%) R
Qualifications
1 35 (19.02%) Degree
2 11 (5.98%) Microsoft Certification
3 6 (3.26%) MCITP
Quality Assurance & Compliance
1 18 (9.78%) Data Quality
2 4 (2.17%) ISO20022
2 4 (2.17%) QA
3 1 (0.54%) GDPR
System Software
1 1 (0.54%) Apache Flume
Systems Management
1 1 (0.54%) Hadoop YARN
Vendors
1 83 (45.11%) Oracle
2 60 (32.61%) Microsoft
3 38 (20.65%) Informatica
4 20 (10.87%) IBM
5 15 (8.15%) Talend
6 14 (7.61%) Tableau
7 13 (7.07%) Teradata
8 12 (6.52%) Cognos
9 11 (5.98%) SAP
10 7 (3.80%) Jaspersoft
11 5 (2.72%) Google
12 4 (2.17%) Netezza
13 3 (1.63%) Hyperion
14 2 (1.09%) Salesforce.com
15 1 (0.54%) Pegasus
South East
Lawrence Harvey Enterprise
Salary: £40000.00 - £50000.00 per annum + Pension
Posted: Yesterday
City, London
Charles Taylor plc
Salary: Market related
Posted: 2 days ago
Oxfordshire
Austin Fraser
Salary: £22000 - £25000 per annum + Benefits + Training
Posted: 2 days ago
Godalming
Nigel Frank International
Salary: £65000 - £70000 per annum + Benefits
Posted: 4 days ago
Uxbridge
Ampersand Consulting
Salary: £55000 per annum + Benefits
Posted: 5 days ago
Petersfield, Hampshire
Rullion IT Plus
Salary: £42000 - £55000 per annum + Pension
Posted: 6 days ago
West London
Eutopia Solutions Ltd
Salary: £45000.00 - £60000.00 per annum + bonus
Posted: 5 days ago
Oxfordshire
Austin Fraser
Salary: £22000.00 - £26000.00 per annum + Benefits
Posted: 6 days ago
Leicester, Leicestershire
TriMas Corporation
Posted: 11 days ago