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

3 months to
22 Feb 2017
Same period 2016 Same period 2015
Star Schema
UK
Rank 781 838 863
Rank change year-on-year
+57 +25
Permanent jobs citing Star Schema 81 114 91
As % of all permanent IT jobs located in the UK 0.096% 0.11% 0.086%
As % of the Database & Business Intelligence category 0.32% 0.35% 0.28%
Number of salaries quoted 72 102 77
Median salary £52,500 £49,750 £44,000
Median salary % change year-on-year
+5.52% +13.06%
90% offered a salary of more than £26,000 £35,000 £35,000
10% offered a salary of more than £57,500 £67,400 £69,000
UK excluding London median salary £45,000 £40,000 £38,500
% change year-on-year
+12.50% +3.89%

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
25501 32364 32840
As % of all permanent IT jobs located in the UK 30.37% 31.60% 31.19%
Number of salaries quoted 21700 27465 28138
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £72,500 £70,000 £71,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +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 February 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 February 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 +60 81 £52,500 -4.54% 11
London +41 35 £54,000 -6.08% 5
South East +79 21 £37,000 -7.50% 2
Uxbridge +6 9 £55,000 +10.00%
Oxfordshire - 7 £23,500 -
Surrey +60 6 £50,000 -13.04%
Redhill - 6 £50,000 -
Berkshire +40 5 £37,000 -7.50%
Reading +37 5 £37,000 -7.50%
North West - 5 £51,000 -
West Midlands +17 4 £26,000 -25.71%
Manchester - 4 £53,500 -
Yorkshire - 3 £30,000 - 1
West Yorkshire - 3 £30,000 - 1
Leeds - 2 £30,000 - 1
Tyne and Wear - 2 £44,500 -
North East - 2 £44,500 -
Buckinghamshire +19 1 £45,000 +32.35%
East Midlands +14 1 - - 1
Milton Keynes +13 1 £45,000 +32.35%
Birmingham +9 1 £47,500 +35.71%
Staffordshire - 1 £26,000 -
Northamptonshire - 1 - - 1
Hampshire - 1 £48,500 - 2
Cheshire - 1 £36,000 -
Warrington - 1 £36,000 -
Walsall - 1 - -
Petersfield - 1 £48,500 -
Northampton - 1 - -
Newcastle upon Tyne - 1 £44,000 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 22 February 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 133 (84.71%) Data Warehouse
2 108 (68.79%) Business Intelligence
3 103 (65.61%) SQL
4 90 (57.32%) SQL Server
5 87 (55.41%) SQL Server Integration Services
6 78 (49.68%) ETL
7 73 (46.50%) Data Modelling
8 72 (45.86%) Oracle
9 71 (45.22%) Finance
10 68 (43.31%) SQL Server Analysis Services
11 66 (42.04%) SQL Server Reporting Services
12 53 (33.76%) Kimball Methodology
13 50 (31.85%) T-SQL
14 48 (30.57%) Microsoft
15 46 (29.30%) Agile Software Development
16 35 (22.29%) Informatica
17 33 (21.02%) Data Management
18 32 (20.38%) MS Excel
19 31 (19.75%) Degree
20 26 (16.56%) Migration
21 25 (15.92%) Information Architecture
22 24 (15.29%) Oracle BI EE
22 24 (15.29%) Data Migration
22 24 (15.29%) Retail
23 23 (14.65%) Banking
24 22 (14.01%) BusinessObjects
24 22 (14.01%) Oracle Database
24 22 (14.01%) Relational Database
24 22 (14.01%) Mentoring
25 21 (13.38%) Data Integration

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 4 (2.55%) Oracle SOA Suite
2 2 (1.27%) WebLogic
3 1 (0.64%) Apache Airflow
3 1 (0.64%) Elasticsearch
3 1 (0.64%) Luigi
3 1 (0.64%) SAS
3 1 (0.64%) SharePoint
Applications
1 32 (20.38%) MS Excel
2 2 (1.27%) MS Office
Business Applications
1 13 (8.28%) Oracle Applications
2 4 (2.55%) Cognos Business Intelligence
3 1 (0.64%) Oracle EBS
Cloud Services
1 8 (5.10%) Amazon AWS
2 7 (4.46%) Microsoft Azure
3 4 (2.55%) Google Cloud Platform
4 2 (1.27%) SaaS
Database & Business Intelligence
1 133 (84.71%) Data Warehouse
2 90 (57.32%) SQL Server
3 87 (55.41%) SQL Server Integration Services
4 68 (43.31%) SQL Server Analysis Services
5 66 (42.04%) SQL Server Reporting Services
6 24 (15.29%) Oracle BI EE
7 22 (14.01%) BusinessObjects
7 22 (14.01%) Oracle Database
7 22 (14.01%) Relational Database
8 19 (12.10%) Oracle Reports
8 19 (12.10%) QlikView
8 19 (12.10%) Snowflake Schema
9 18 (11.46%) Oracle ODI
10 17 (10.83%) MySQL
10 17 (10.83%) OLAP
11 16 (10.19%) Oracle BI Publisher
11 16 (10.19%) SQL Server 2008
12 15 (9.55%) Hadoop
13 14 (8.92%) Oracle Database 11g
13 14 (8.92%) SQL Server 2012
Development Applications
1 18 (11.46%) Talend Open Studio
2 16 (10.19%) ERwin
3 7 (4.46%) Visual Studio
4 4 (2.55%) MagicDraw
5 2 (1.27%) JIRA
General
1 71 (45.22%) Finance
2 24 (15.29%) Retail
3 23 (14.65%) Banking
4 7 (4.46%) Local Government
5 6 (3.82%) Investment Banking
6 4 (2.55%) Back Office
6 4 (2.55%) General Ledger
7 2 (1.27%) Publishing
8 1 (0.64%) Advertising
8 1 (0.64%) Automotive
8 1 (0.64%) German Language
8 1 (0.64%) Legal
8 1 (0.64%) Marketing
Job Titles
1 79 (50.32%) Developer
2 44 (28.03%) Business Intelligence Developer
3 33 (21.02%) SQL Developer
4 30 (19.11%) SSIS Developer
5 27 (17.20%) Data Warehouse Developer
6 26 (16.56%) Analyst
7 25 (15.92%) Consultant
8 22 (14.01%) SQL Analyst
9 20 (12.74%) Analyst Developer
9 20 (12.74%) SQL Data Analyst
10 19 (12.10%) Architect
11 18 (11.46%) Data Warehouse Analyst
12 17 (10.83%) Data Analyst
13 16 (10.19%) Developer Analyst
14 15 (9.55%) ETL Developer
15 14 (8.92%) Business Developer
15 14 (8.92%) Data Architect
15 14 (8.92%) ETL Analyst
15 14 (8.92%) SSIS Analyst
15 14 (8.92%) SSRS Developer
Libraries, Frameworks & Software Standards
1 16 (10.19%) XML
2 8 (5.10%) Web Services
3 4 (2.55%) Middleware
3 4 (2.55%) Oracle GoldenGate
3 4 (2.55%) XML Schema
4 2 (1.27%) CSS
4 2 (1.27%) HTML
4 2 (1.27%) JSON
5 1 (0.64%) jQuery
5 1 (0.64%) Kafka
5 1 (0.64%) MDX
5 1 (0.64%) Twitter Bootstrap
Miscellaneous
1 18 (11.46%) Analytical Skills
2 13 (8.28%) Management Information System
3 11 (7.01%) Credit Risk
3 11 (7.01%) Market Risk
4 10 (6.37%) Data Structures
5 8 (5.10%) Computer Science
6 7 (4.46%) Replication
7 6 (3.82%) NHS
8 4 (2.55%) Reference Data
8 4 (2.55%) Taxonomies
9 3 (1.91%) Semantic Web
10 2 (1.27%) Algorithms
10 2 (1.27%) Enterprise Software
10 2 (1.27%) Fintech
11 1 (0.64%) Client/Server
11 1 (0.64%) Driving Licence
11 1 (0.64%) iSeries
Operating Systems
1 1 (0.64%) AIX
1 1 (0.64%) Android
1 1 (0.64%) Apple iOS
1 1 (0.64%) Linux
1 1 (0.64%) Unix
Processes & Methodologies
1 108 (68.79%) Business Intelligence
2 78 (49.68%) ETL
3 73 (46.50%) Data Modelling
4 53 (33.76%) Kimball Methodology
5 46 (29.30%) Agile Software Development
6 33 (21.02%) Data Management
7 26 (16.56%) Migration
8 25 (15.92%) Information Architecture
9 24 (15.29%) Data Migration
10 22 (14.01%) Mentoring
11 21 (13.38%) Data Integration
12 20 (12.74%) Performance Tuning
13 19 (12.10%) Logical Data Model
14 18 (11.46%) Master Data Management
15 17 (10.83%) Data Analysis
15 17 (10.83%) Data Architecture
16 16 (10.19%) Data Cleansing
16 16 (10.19%) Software Engineering
17 15 (9.55%) Analytics
17 15 (9.55%) CRM
Programming Languages
1 103 (65.61%) SQL
2 50 (31.85%) T-SQL
3 13 (8.28%) PL/SQL
4 2 (1.27%) JavaScript
5 1 (0.64%) Bash Shell
5 1 (0.64%) Java
5 1 (0.64%) Python
5 1 (0.64%) R
Qualifications
1 31 (19.75%) Degree
2 1 (0.64%) MCITP
2 1 (0.64%) Microsoft Certification
Quality Assurance & Compliance
1 16 (10.19%) Data Quality
2 4 (2.55%) ISO20022
3 2 (1.27%) QA
4 1 (0.64%) GDPR
System Software
1 1 (0.64%) Apache Flume
Systems Management
1 1 (0.64%) Hadoop YARN
Vendors
1 72 (45.86%) Oracle
2 48 (30.57%) Microsoft
3 35 (22.29%) Informatica
4 18 (11.46%) Talend
5 16 (10.19%) IBM
6 14 (8.92%) Cognos
7 13 (8.28%) SAP
8 11 (7.01%) Tableau
9 10 (6.37%) Teradata
10 7 (4.46%) Jaspersoft
11 5 (3.18%) Google
12 3 (1.91%) Hyperion
13 2 (1.27%) Netezza
14 1 (0.64%) Pegasus
Northamptonshire
Nigel Frank International
Salary: £45000 - £50000 per annum + unique benefits
Posted: 9 hours ago
Hatfield, Hertfordshire
myBench Ltd
Salary: From £55,000 to £70,000 per annum
Posted: 3 hours ago
Leeds, West Yorkshire
Fruition IT Resources Limited
Salary: £30000 - £45000 per annum
Posted: 2 days ago
Central London / West End
Testing Circle Ltd
Salary: £0.00 - £45000 per annum + Additional benefits
Posted: Yesterday
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 5 days ago
London
Arrows Group Ltd
Salary: £0.00 per annum
Posted: 8 days ago
London
Venturi
Salary: £50000.00 - £55000.00 per annum + 20% bonus & benefits
Posted: 19 days ago