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

3 months to
2 Dec 2016
Same period 2015 Same period 2014
Star Schema
Rank 807 875 864
Rank change year-on-year
+68 -11
Permanent jobs citing Star Schema 71 93 117
As % of all permanent IT jobs located in the UK 0.078% 0.086% 0.10%
As % of the Database & Business Intelligence category 0.26% 0.27% 0.33%
Number of salaries quoted 53 79 104
Median salary £55,000 £47,500 £48,000
Median salary % change year-on-year
+15.78% -1.04%
90% offered a salary of more than £45,000 £30,000 £31,000
10% offered a salary of more than £80,000 £65,000 £66,250
UK excluding London median salary £46,500 £43,250 £48,000
% change year-on-year
+7.51% -9.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
27175 34551 35280
As % of all permanent IT jobs located in the UK 29.85% 31.89% 30.62%
Number of salaries quoted 23281 29092 30122
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 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 2 December 2016 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 2 December 2016. 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
(Click see detailed
statistics and trends)
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 +77 66 £55,000 +15.78% 12
London +70 32 £65,000 +8.33% 4
South East +68 13 £54,000 +24.13% 2
West Midlands -9 10 £46,000 +15.00%
City of London +44 6 £80,000 - 1
Kent - 6 £54,000 -
Uxbridge - 6 £55,000 - 1
Yorkshire +29 5 £45,000 +24.13% 1
Scotland +28 5 £80,000 +113.33%
West Yorkshire +25 5 £45,000 +24.13% 1
North West -10 5 £36,000 -44.61% 3
Glasgow +27 4 - -
Surrey +22 3 £48,500 -11.81% 2
Redhill 0 3 £48,500 -11.81% 2
Birmingham -13 3 £46,000 +15.00%
Bradford - 3 £45,000 -
Warrington - 3 £36,000 - 1
Cheshire - 3 £36,000 - 3
Leeds +21 2 £45,000 +50.00%
Hampshire -1 2 £45,500 +4.59%
Manchester -12 2 £60,500 -6.92%
Petersfield - 2 £45,500 -
Berkshire +44 1 £72,500 +81.25%
Walsall +15 1 - -
Milton Keynes +10 1 £32,500 +20.37%
Buckinghamshire +7 1 £32,500 +11.11%
Tamworth +5 1 - -
Warwickshire +3 1 £45,000 +80.00%
East of England -2 1 £37,500 -37.50% 1
Staffordshire -5 1 - -

Star Schema
Top 30 Related IT Skills

For the 6 months to 2 December 2016, 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 156 (85.71%) Data Warehouse
2 136 (74.73%) Business Intelligence
3 114 (62.64%) SQL
4 105 (57.69%) ETL
5 90 (49.45%) Data Modelling
6 88 (48.35%) SQL Server
7 78 (42.86%) SQL Server Integration Services
8 77 (42.31%) Oracle
9 70 (38.46%) Finance
10 67 (36.81%) Kimball Methodology
11 62 (34.07%) Microsoft
12 61 (33.52%) SQL Server Analysis Services
13 58 (31.87%) SQL Server Reporting Services
14 40 (21.98%) Data Management
14 40 (21.98%) T-SQL
15 39 (21.43%) Data Integration
16 36 (19.78%) Analytics
17 34 (18.68%) Informatica
18 33 (18.13%) Snowflake Schema
19 31 (17.03%) Enterprise Data Warehouse
20 30 (16.48%) Oracle Database
20 30 (16.48%) Information Architecture
20 30 (16.48%) Degree
21 27 (14.84%) Master Data Management
21 27 (14.84%) Data Architecture
22 26 (14.29%) Mentoring
23 25 (13.74%) OLAP
24 24 (13.19%) Oracle BI EE
24 24 (13.19%) Performance Tuning
25 23 (12.64%) 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.75%) WebLogic
2 4 (2.20%) SharePoint
3 3 (1.65%) Oracle SOA Suite
4 1 (0.55%) Apache Airflow
4 1 (0.55%) Elasticsearch
4 1 (0.55%) Luigi
4 1 (0.55%) SAS
Applications
1 20 (10.99%) MS Excel
Business Applications
1 16 (8.79%) Oracle Applications
2 1 (0.55%) Dynamics CRM
2 1 (0.55%) Oracle EBS
Cloud Services
1 10 (5.49%) Amazon AWS
2 3 (1.65%) Google Cloud Platform
3 2 (1.10%) SaaS
4 1 (0.55%) Microsoft Azure
Database & Business Intelligence
1 156 (85.71%) Data Warehouse
2 88 (48.35%) SQL Server
3 78 (42.86%) SQL Server Integration Services
4 61 (33.52%) SQL Server Analysis Services
5 58 (31.87%) SQL Server Reporting Services
6 33 (18.13%) Snowflake Schema
7 31 (17.03%) Enterprise Data Warehouse
8 30 (16.48%) Oracle Database
9 25 (13.74%) OLAP
10 24 (13.19%) Oracle BI EE
11 23 (12.64%) Relational Database
12 22 (12.09%) Oracle Database 11g
13 20 (10.99%) Oracle Database 12c
14 19 (10.44%) QlikView
15 17 (9.34%) Oracle ODI
16 15 (8.24%) BusinessObjects
16 15 (8.24%) Oracle BI Publisher
16 15 (8.24%) Oracle Reports
17 14 (7.69%) MySQL
17 14 (7.69%) SQL Server 2014
Development Applications
1 22 (12.09%) ERwin
2 9 (4.95%) Visual Studio
3 8 (4.40%) Talend Open Studio
4 4 (2.20%) MagicDraw
5 2 (1.10%) JIRA
General
1 70 (38.46%) Finance
2 23 (12.64%) Banking
3 20 (10.99%) Retail
4 6 (3.30%) Investment Banking
5 4 (2.20%) Back Office
5 4 (2.20%) General Ledger
5 4 (2.20%) Legal
5 4 (2.20%) Marketing
6 2 (1.10%) Law
7 1 (0.55%) Advertising
7 1 (0.55%) Games
7 1 (0.55%) Publishing
Job Titles
1 88 (48.35%) Developer
2 40 (21.98%) Business Intelligence Developer
3 39 (21.43%) Architect
4 38 (20.88%) Data Warehouse Developer
4 38 (20.88%) SQL Developer
5 30 (16.48%) Data Architect
6 28 (15.38%) SSIS Developer
7 25 (13.74%) Analyst
8 19 (10.44%) Analyst Developer
8 19 (10.44%) Consultant
9 18 (9.89%) SQL Analyst
9 18 (9.89%) SSRS Developer
10 15 (8.24%) Data Warehouse Analyst
10 15 (8.24%) SSAS Developer
11 14 (7.69%) OBIEE Consultant
11 14 (7.69%) Senior Consultant
11 14 (7.69%) SQL Data Analyst
12 13 (7.14%) Oracle Developer
12 13 (7.14%) Senior OBIEE Consultant
13 12 (6.59%) Data Modeller
Libraries, Frameworks & Software Standards
1 18 (9.89%) MDX
2 12 (6.59%) XML
3 11 (6.04%) Web Services
4 5 (2.75%) .NET
5 4 (2.20%) CSS
5 4 (2.20%) HTML
5 4 (2.20%) JSON
5 4 (2.20%) XML Schema
6 3 (1.65%) ASP.NET
6 3 (1.65%) Middleware
6 3 (1.65%) Oracle GoldenGate
6 3 (1.65%) Twitter Bootstrap
7 2 (1.10%) AngularJS
7 2 (1.10%) CSS3
7 2 (1.10%) HTML5
7 2 (1.10%) REST
7 2 (1.10%) WCF
8 1 (0.55%) ASP.NET MVC
8 1 (0.55%) jQuery
8 1 (0.55%) Kafka
Miscellaneous
1 39 (21.43%) Data Integration
2 22 (12.09%) Management Information System
3 20 (10.99%) Analytical Skills
4 15 (8.24%) Visualisation
5 13 (7.14%) Computer Science
6 11 (6.04%) Credit Risk
6 11 (6.04%) Market Risk
7 7 (3.85%) Mathematics
8 5 (2.75%) Data Structures
9 4 (2.20%) Ontologies
9 4 (2.20%) Reference Data
9 4 (2.20%) Taxonomies
10 3 (1.65%) iSeries
10 3 (1.65%) Semantic Web
11 2 (1.10%) Data Extraction
11 2 (1.10%) Enterprise Software
11 2 (1.10%) Fintech
11 2 (1.10%) Replication
12 1 (0.55%) Client/Server
12 1 (0.55%) Driving Licence
Operating Systems
1 3 (1.65%) Unix
2 1 (0.55%) AIX
2 1 (0.55%) Android
2 1 (0.55%) Apple iOS
2 1 (0.55%) Linux
Processes & Methodologies
1 136 (74.73%) Business Intelligence
2 105 (57.69%) ETL
3 90 (49.45%) Data Modelling
4 67 (36.81%) Kimball Methodology
5 40 (21.98%) Data Management
6 36 (19.78%) Analytics
7 30 (16.48%) Information Architecture
8 27 (14.84%) Data Architecture
8 27 (14.84%) Master Data Management
9 26 (14.29%) Mentoring
10 24 (13.19%) Performance Tuning
11 23 (12.64%) Agile Software Development
12 22 (12.09%) Data Analysis
12 22 (12.09%) Logical Data Model
13 21 (11.54%) Data Cleansing
13 21 (11.54%) Migration
14 19 (10.44%) CRM
14 19 (10.44%) Data Migration
15 17 (9.34%) Metadata Management
15 17 (9.34%) Technical Architecture
Programming Languages
1 114 (62.64%) SQL
2 40 (21.98%) T-SQL
3 23 (12.64%) PL/SQL
4 5 (2.75%) Data Analysis Expressions (DAX)
5 4 (2.20%) C#
5 4 (2.20%) JavaScript
6 3 (1.65%) Python
6 3 (1.65%) R
7 2 (1.10%) C
7 2 (1.10%) Shell Script
7 2 (1.10%) TypeScript
7 2 (1.10%) VB.NET
7 2 (1.10%) VBA
8 1 (0.55%) Bash Shell
8 1 (0.55%) Java
Qualifications
1 30 (16.48%) Degree
2 13 (7.14%) Microsoft Certification
3 7 (3.85%) MCITP
Quality Assurance & Compliance
1 21 (11.54%) Data Quality
2 8 (4.40%) QA
3 4 (2.20%) ISO20022
System Software
1 1 (0.55%) Apache Flume
Systems Management
1 2 (1.10%) Dollar Universe
2 1 (0.55%) Hadoop YARN
Vendors
1 77 (42.31%) Oracle
2 62 (34.07%) Microsoft
3 34 (18.68%) Informatica
4 22 (12.09%) IBM
4 22 (12.09%) Tableau
5 15 (8.24%) Teradata
6 13 (7.14%) Endeca
7 9 (4.95%) SAP
8 8 (4.40%) Talend
9 7 (3.85%) Jaspersoft
10 5 (2.75%) Cognos
10 5 (2.75%) Netezza
11 4 (2.20%) Google
12 3 (1.65%) Hyperion
13 2 (1.10%) Salesforce.com
14 1 (0.55%) Pegasus
14 1 (0.55%) Vertica
West London
Eutopia Solutions Ltd
Salary: £50000.00 - £60000.00 per annum + bonus
Posted: 20 hours ago
Uxbridge
Ampersand Consulting
Salary: £55000 per annum + Benefits
Posted: 2 days ago
Redhill, Surrey
Zorba Consulting Limited
Salary: £50k - 55k per year + bonus + benefits
Posted: 4 days ago
Warrington, Cheshire
Rullion IT Plus
Salary: £30000 - £42000 per annum + Benefits
Posted: 4 days ago
City, London
Charles Taylor plc
Salary: Market related
Posted: 10 days ago
London
Charles Taylor Plc
Salary: Market related
Posted: 10 days ago
Redhill
Venturi
Salary: £45000 - £52000 per annum + bonus +Full bens
Posted: 15 days ago
West Yorkshire
Applicant Services
Salary: Salary up to £30,000 dependent on experience + 3% flexible benefits + on target bonus of 5% + contributory pension
Posted: 11 days ago