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

3 months to
24 Sep 2016
Same period 2015 Same period 2014
Star Schema
Rank 805 853 862
Rank change year-on-year
+48 +9
Permanent jobs citing Star Schema 105 110 124
As % of all permanent IT jobs located in the UK 0.11% 0.10% 0.11%
As % of the Database & Business Intelligence category 0.38% 0.33% 0.35%
Number of salaries quoted 92 86 102
Median salary £54,000 £43,500 £48,000
Median salary % change year-on-year
+24.13% -9.37%
90% offered a salary of more than £36,000 £27,500 £32,500
10% offered a salary of more than £72,500 £67,500 £70,000
UK excluding London median salary £38,750 £41,500 £47,500
% change year-on-year
-6.62% -12.63%

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
27899 33705 35855
As % of all permanent IT jobs located in the UK 29.60% 30.81% 31.39%
Number of salaries quoted 23759 28514 30081
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 £67,500 £72,500
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 24 September 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 24 September 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 +56 104 £54,000 +24.13% 7
London +52 60 £60,000 - 2
West Midlands -14 18 £38,000 -8.43% 1
South East +15 10 £52,500 +50.00% 2
Staffordshire +3 9 £35,000 -15.66% 1
West Sussex +19 7 £52,500 -3.66%
Gatwick - 7 £52,500 -
North West +19 6 £36,000 -10.00% 1
Cheshire +35 5 £35,500 -11.25% 1
Tyne and Wear - 5 £37,000 -
Warrington - 5 £35,500 - 1
Lichfield - 5 £50,000 - 1
North East - 5 £37,000 -
Newcastle upon Tyne - 5 £37,000 -
Tamworth 0 4 £29,500 -28.91%
Yorkshire +31 3 £43,750 +2.94% 1
East Midlands - 2 £31,656 -
York - 2 £40,000 -
Nottingham - 2 £31,656 -
Sittingbourne - 2 £57,000 -
Kent - 2 £57,000 - 1
North Yorkshire - 2 £40,000 -
Nottinghamshire - 2 £31,656 -
City of London +40 1 £60,000 -11.11%
West Yorkshire +18 1 £47,500 +11.76% 1
Cardiff +16 1 £37,500 +15.38%
South Wales +10 1 £37,500 +15.38%
Milton Keynes +6 1 - - 1
Wales +4 1 £37,500 +15.38%
Buckinghamshire -2 1 - - 1

Star Schema
Top 30 Related IT Skills

For the 6 months to 24 September 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 167 (85.64%) Data Warehouse
2 147 (75.38%) Business Intelligence
3 140 (71.79%) SQL
4 118 (60.51%) ETL
5 105 (53.85%) SQL Server
6 87 (44.62%) SQL Server Integration Services
7 84 (43.08%) Data Modelling
7 84 (43.08%) Finance
8 79 (40.51%) Oracle
9 75 (38.46%) Microsoft
10 70 (35.90%) Kimball Methodology
11 59 (30.26%) SQL Server Analysis Services
12 55 (28.21%) SQL Server Reporting Services
13 48 (24.62%) T-SQL
14 45 (23.08%) Analytics
15 44 (22.56%) Data Integration
16 36 (18.46%) Informatica
17 34 (17.44%) Enterprise Data Warehouse
18 32 (16.41%) Relational Database
19 30 (15.38%) Data Architecture
20 29 (14.87%) OLAP
21 28 (14.36%) PL/SQL
21 28 (14.36%) Snowflake Schema
22 27 (13.85%) MS Excel
22 27 (13.85%) Degree
22 27 (13.85%) Oracle Database
23 26 (13.33%) Tableau
24 25 (12.82%) Management Information System
25 24 (12.31%) Data Management
26 23 (11.79%) BusinessObjects

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.56%) WebLogic
2 4 (2.05%) SharePoint
3 2 (1.03%) Apache Pig
3 2 (1.03%) Apache Spark
3 2 (1.03%) SAS
4 1 (0.51%) Elasticsearch
Applications
1 27 (13.85%) MS Excel
2 1 (0.51%) SPSS
Business Applications
1 18 (9.23%) Oracle Applications
2 1 (0.51%) Cognos TM1
2 1 (0.51%) Dynamics CRM
Cloud Services
1 10 (5.13%) Amazon AWS
2 4 (2.05%) Microsoft Azure
3 2 (1.03%) SaaS
4 1 (0.51%) Amazon Kinesis
4 1 (0.51%) Amazon S3
4 1 (0.51%) AWS Elastic Beanstalk
Database & Business Intelligence
1 167 (85.64%) Data Warehouse
2 105 (53.85%) SQL Server
3 87 (44.62%) SQL Server Integration Services
4 59 (30.26%) SQL Server Analysis Services
5 55 (28.21%) SQL Server Reporting Services
6 34 (17.44%) Enterprise Data Warehouse
7 32 (16.41%) Relational Database
8 29 (14.87%) OLAP
9 28 (14.36%) Snowflake Schema
10 27 (13.85%) Oracle Database
11 23 (11.79%) BusinessObjects
12 22 (11.28%) Oracle Database 11g
13 21 (10.77%) SQL Server 2014
14 20 (10.26%) Oracle Database 12c
15 19 (9.74%) Oracle BI EE
15 19 (9.74%) RDBMS
15 19 (9.74%) SQL Server 2008
16 18 (9.23%) Oracle Reports
17 15 (7.69%) Microsoft Analysis Services
17 15 (7.69%) MySQL
Development Applications
1 16 (8.21%) ERwin
2 5 (2.56%) Visual Studio
3 4 (2.05%) Talend Open Studio
4 2 (1.03%) JIRA
General
1 84 (43.08%) Finance
2 18 (9.23%) Banking
3 17 (8.72%) Retail
4 9 (4.62%) Legal
5 7 (3.59%) Marketing
6 5 (2.56%) Law
7 4 (2.05%) Games
8 3 (1.54%) Back Office
8 3 (1.54%) Publishing
9 2 (1.03%) Investment Banking
10 1 (0.51%) Advertising
10 1 (0.51%) Manufacturing
Job Titles
1 106 (54.36%) Developer
2 55 (28.21%) Data Warehouse Developer
3 43 (22.05%) Architect
4 41 (21.03%) SQL Developer
5 39 (20.00%) Business Intelligence Developer
6 38 (19.49%) Data Architect
7 32 (16.41%) SSIS Developer
8 31 (15.90%) Analyst
9 25 (12.82%) Analyst Developer
10 23 (11.79%) ETL Developer
11 21 (10.77%) Consultant
11 21 (10.77%) Data Warehouse Analyst
12 19 (9.74%) Report Developer
12 19 (9.74%) SQL Analyst
13 17 (8.72%) Senior Consultant
14 16 (8.21%) Data Analyst
14 16 (8.21%) SQL Data Analyst
15 14 (7.18%) OBIEE Consultant
15 14 (7.18%) Senior OBIEE Consultant
16 13 (6.67%) Data Warehouse Architect
Libraries, Frameworks & Software Standards
1 20 (10.26%) MDX
2 6 (3.08%) .NET
2 6 (3.08%) Web Services
3 5 (2.56%) XML
4 4 (2.05%) ASP.NET
4 4 (2.05%) CSS
4 4 (2.05%) HTML
5 3 (1.54%) JSON
5 3 (1.54%) Kafka
5 3 (1.54%) Twitter Bootstrap
6 2 (1.03%) AngularJS
6 2 (1.03%) ASP.NET MVC
6 2 (1.03%) CSS3
6 2 (1.03%) HTML5
6 2 (1.03%) REST
6 2 (1.03%) WCF
7 1 (0.51%) jQuery
Miscellaneous
1 44 (22.56%) Data Integration
2 25 (12.82%) Management Information System
3 18 (9.23%) Visualisation
4 16 (8.21%) Analytical Skills
5 12 (6.15%) Computer Science
6 8 (4.10%) Mathematics
7 4 (2.05%) Credit Risk
7 4 (2.05%) Data Structures
7 4 (2.05%) Fintech
7 4 (2.05%) Market Risk
8 3 (1.54%) Data Extraction
8 3 (1.54%) Online Games
9 2 (1.03%) Enterprise Software
9 2 (1.03%) iSeries
10 1 (0.51%) Client/Server
10 1 (0.51%) Freedom of Information
Operating Systems
1 4 (2.05%) Unix
2 1 (0.51%) Android
2 1 (0.51%) Apple iOS
2 1 (0.51%) Linux
Processes & Methodologies
1 147 (75.38%) Business Intelligence
2 118 (60.51%) ETL
3 84 (43.08%) Data Modelling
4 70 (35.90%) Kimball Methodology
5 45 (23.08%) Analytics
6 30 (15.38%) Data Architecture
7 24 (12.31%) Data Management
8 21 (10.77%) Master Data Management
9 20 (10.26%) Agile Software Development
9 20 (10.26%) Data Analysis
9 20 (10.26%) Mentoring
10 19 (9.74%) Performance Tuning
11 17 (8.72%) Data Cleansing
12 16 (8.21%) Dimensional Modelling
13 15 (7.69%) CRM
13 15 (7.69%) ETL Development
13 15 (7.69%) Inmon Methodology
13 15 (7.69%) Migration
13 15 (7.69%) SDLC
14 14 (7.18%) Data Visualisation
Programming Languages
1 140 (71.79%) SQL
2 48 (24.62%) T-SQL
3 28 (14.36%) PL/SQL
4 8 (4.10%) C#
5 7 (3.59%) Data Analysis Expressions (DAX)
5 7 (3.59%) Python
6 5 (2.56%) Java
6 5 (2.56%) R
6 5 (2.56%) VBA
7 4 (2.05%) JavaScript
8 2 (1.03%) C
8 2 (1.03%) Clojure
8 2 (1.03%) Ruby
8 2 (1.03%) Scala
8 2 (1.03%) Shell Script
8 2 (1.03%) TypeScript
8 2 (1.03%) VB.NET
9 1 (0.51%) Bash Shell
Qualifications
1 27 (13.85%) Degree
2 15 (7.69%) Microsoft Certification
3 8 (4.10%) MCITP
4 2 (1.03%) SC Cleared
4 2 (1.03%) Security Cleared
Quality Assurance & Compliance
1 20 (10.26%) Data Quality
2 13 (6.67%) QA
System Software
1 1 (0.51%) Apache Flume
1 1 (0.51%) Docker
Systems Management
1 2 (1.03%) Dollar Universe
2 1 (0.51%) Cisco IPCC
2 1 (0.51%) Hadoop YARN
Vendors
1 79 (40.51%) Oracle
2 75 (38.46%) Microsoft
3 36 (18.46%) Informatica
4 26 (13.33%) Tableau
5 14 (7.18%) Endeca
5 14 (7.18%) IBM
6 11 (5.64%) Teradata
7 10 (5.13%) SAP
8 8 (4.10%) Cognos
9 5 (2.56%) Netezza
9 5 (2.56%) Vertica
10 4 (2.05%) Talend
11 3 (1.54%) Alteryx
12 2 (1.03%) Jaspersoft
12 2 (1.03%) Salesforce.com
13 1 (0.51%) Ab Initio
13 1 (0.51%) MicroStrategy
13 1 (0.51%) Pega
13 1 (0.51%) webMethods
Kent
Venturi
Salary: £50000 - £58000 per annum + full bens
Posted: Yesterday
South East London
Recital Consulting
Salary: £50000 - £65000 Per Annum Plus Benefits
Posted: Yesterday
Warrington, Cheshire
Harvey Nash plc
Posted: 2 days ago
Milton Keynes, Buckinghamshire
Interact Consulting
Salary: 30-35k
Posted: Yesterday
Leeds, West Yorkshire
Fruition IT Resources Limited
Salary: £40000.00 - £50000.00 per annum + Benefits + Free Parking
Posted: 5 days ago
London
Salt
Salary: £75000 - £85000 per annum + Benefits
Posted: 4 days ago