The table below looks at the statistics for Star Schema skills in IT jobs advertised for the England region. Included is a guide to the salaries offered in IT jobs that have cited Star Schema over the 3 months to 28 September 2016 with a comparison to the same period over the previous 2 years.

3 months to
28 Sep 2016
Same period 2015 Same period 2014
Star Schema
Rank 773 826 842
Rank change year-on-year
+53 +16
Permanent jobs citing Star Schema 109 105 116
As % of all permanent IT jobs located in England 0.12% 0.10% 0.11%
As % of the Database & Business Intelligence category 0.41% 0.33% 0.35%
Number of salaries quoted 95 87 94
Median salary £54,000 £43,500 £51,250
Median salary % change year-on-year
+24.13% -15.12%
90% offered a salary of more than £36,000 £27,500 £32,238
10% offered a salary of more than £72,500 £67,500 £70,000
UK excluding London median salary £40,000 £41,500 £47,500
% change year-on-year
-3.61% -12.63%
Star Schema
UK

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

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
26422 31665 33260
As % of all permanent IT jobs located in England 29.49% 30.96% 31.51%
Number of salaries quoted 22670 27000 28189
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 £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

Star Schema
Jobs Demand Trend in England

The demand trend of job ads across the England region 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 England

Star Schema
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Star Schema across the England region.

Star Schema Salary Trend in England

Star Schema
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing Star Schema across the England region over the 3 months to 28 September 2016.

Star Schema Salary Histogram in England

Star Schema
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Star Schema within the England region over the 3 months to 28 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
London +81 63 £62,500 +4.16% 1
West Midlands -8 18 £38,000 -8.43%
South East +17 11 £53,250 +46.89% 3
North West 0 6 £36,000 -10.00% 1
North East - 5 £37,000 -
Yorkshire +19 4 £45,000 +5.88%
East Midlands - 2 £31,656 -
Star Schema
UK

Star Schema
Top 30 Related IT Skills in England

For the 6 months to 28 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 across the England region with a requirement for Star Schema.

1 160 (85.11%) Data Warehouse
2 148 (78.72%) Business Intelligence
3 133 (70.74%) SQL
4 118 (62.77%) ETL
5 103 (54.79%) SQL Server
6 85 (45.21%) SQL Server Integration Services
7 84 (44.68%) Data Modelling
8 78 (41.49%) Finance
9 75 (39.89%) Microsoft
10 73 (38.83%) Oracle
11 68 (36.17%) Kimball Methodology
12 59 (31.38%) SQL Server Analysis Services
13 56 (29.79%) SQL Server Reporting Services
14 46 (24.47%) T-SQL
15 41 (21.81%) Data Integration
16 38 (20.21%) Analytics
17 32 (17.02%) Enterprise Data Warehouse
18 31 (16.49%) Relational Database
18 31 (16.49%) Data Architecture
19 30 (15.96%) Informatica
19 30 (15.96%) OLAP
20 29 (15.43%) Snowflake Schema
21 27 (14.36%) Tableau
21 27 (14.36%) Degree
21 27 (14.36%) Oracle Database
22 26 (13.83%) MS Excel
23 25 (13.30%) Management Information System
24 23 (12.23%) Data Management
24 23 (12.23%) PL/SQL
25 22 (11.70%) BusinessObjects

Star Schema
Top Related IT Skills in England 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.66%) WebLogic
2 4 (2.13%) SharePoint
3 2 (1.06%) Apache Pig
3 2 (1.06%) Apache Spark
3 2 (1.06%) SAS
4 1 (0.53%) Elasticsearch
Applications
1 26 (13.83%) MS Excel
2 1 (0.53%) SPSS
Business Applications
1 18 (9.57%) Oracle Applications
2 1 (0.53%) Cognos TM1
2 1 (0.53%) Dynamics CRM
Cloud Services
1 11 (5.85%) Amazon AWS
2 4 (2.13%) Microsoft Azure
3 2 (1.06%) SaaS
4 1 (0.53%) Amazon Kinesis
4 1 (0.53%) Amazon S3
4 1 (0.53%) AWS Elastic Beanstalk
4 1 (0.53%) Google Cloud Platform
Database & Business Intelligence
1 160 (85.11%) Data Warehouse
2 103 (54.79%) SQL Server
3 85 (45.21%) SQL Server Integration Services
4 59 (31.38%) SQL Server Analysis Services
5 56 (29.79%) SQL Server Reporting Services
6 32 (17.02%) Enterprise Data Warehouse
7 31 (16.49%) Relational Database
8 30 (15.96%) OLAP
9 29 (15.43%) Snowflake Schema
10 27 (14.36%) Oracle Database
11 22 (11.70%) BusinessObjects
11 22 (11.70%) Oracle Database 11g
12 20 (10.64%) Oracle BI EE
12 20 (10.64%) Oracle Database 12c
12 20 (10.64%) SQL Server 2014
13 19 (10.11%) RDBMS
14 18 (9.57%) Oracle Reports
14 18 (9.57%) SQL Server 2008
15 15 (7.98%) Microsoft Analysis Services
15 15 (7.98%) Oracle ODI
Development Applications
1 17 (9.04%) ERwin
2 5 (2.66%) Talend Open Studio
2 5 (2.66%) Visual Studio
3 2 (1.06%) JIRA
General
1 78 (41.49%) Finance
2 18 (9.57%) Retail
3 13 (6.91%) Banking
4 9 (4.79%) Legal
5 5 (2.66%) Law
5 5 (2.66%) Marketing
6 4 (2.13%) Games
7 3 (1.60%) Back Office
7 3 (1.60%) Investment Banking
7 3 (1.60%) Publishing
8 1 (0.53%) Advertising
8 1 (0.53%) Manufacturing
Job Titles
1 98 (52.13%) Developer
2 47 (25.00%) Data Warehouse Developer
3 44 (23.40%) Architect
4 41 (21.81%) SQL Developer
5 40 (21.28%) Business Intelligence Developer
6 39 (20.74%) Data Architect
7 31 (16.49%) SSIS Developer
8 25 (13.30%) Analyst
9 21 (11.17%) Consultant
9 21 (11.17%) ETL Developer
10 19 (10.11%) Analyst Developer
10 19 (10.11%) Report Developer
11 18 (9.57%) SQL Analyst
12 17 (9.04%) Senior Consultant
13 15 (7.98%) Data Warehouse Analyst
13 15 (7.98%) SQL Data Analyst
14 14 (7.45%) OBIEE Consultant
14 14 (7.45%) Senior OBIEE Consultant
15 13 (6.91%) Data Warehouse Architect
15 13 (6.91%) Oracle Developer
Libraries, Frameworks & Software Standards
1 20 (10.64%) MDX
2 7 (3.72%) Web Services
3 6 (3.19%) XML
4 5 (2.66%) .NET
5 4 (2.13%) JSON
6 3 (1.60%) ASP.NET
6 3 (1.60%) CSS
6 3 (1.60%) HTML
6 3 (1.60%) Kafka
7 2 (1.06%) AngularJS
7 2 (1.06%) CSS3
7 2 (1.06%) HTML5
7 2 (1.06%) REST
7 2 (1.06%) Twitter Bootstrap
7 2 (1.06%) WCF
8 1 (0.53%) ASP.NET MVC
8 1 (0.53%) Oracle GoldenGate
Miscellaneous
1 41 (21.81%) Data Integration
2 25 (13.30%) Management Information System
3 19 (10.11%) Visualisation
4 17 (9.04%) Analytical Skills
5 12 (6.38%) Computer Science
6 8 (4.26%) Mathematics
7 6 (3.19%) Credit Risk
7 6 (3.19%) Market Risk
8 5 (2.66%) Data Structures
9 4 (2.13%) Fintech
10 3 (1.60%) Data Extraction
10 3 (1.60%) Online Games
11 2 (1.06%) Enterprise Software
12 1 (0.53%) Client/Server
12 1 (0.53%) Freedom of Information
Operating Systems
1 4 (2.13%) Unix
2 1 (0.53%) Android
2 1 (0.53%) Apple iOS
2 1 (0.53%) Linux
Processes & Methodologies
1 148 (78.72%) Business Intelligence
2 118 (62.77%) ETL
3 84 (44.68%) Data Modelling
4 68 (36.17%) Kimball Methodology
5 38 (20.21%) Analytics
6 31 (16.49%) Data Architecture
7 23 (12.23%) Data Management
8 22 (11.70%) Mentoring
9 20 (10.64%) Data Analysis
9 20 (10.64%) Master Data Management
10 19 (10.11%) Performance Tuning
11 16 (8.51%) CRM
11 16 (8.51%) Data Cleansing
11 16 (8.51%) Dimensional Modelling
12 15 (7.98%) Agile Software Development
12 15 (7.98%) Data Visualisation
12 15 (7.98%) Information Architecture
12 15 (7.98%) Inmon Methodology
13 14 (7.45%) ETL Development
13 14 (7.45%) Migration
Programming Languages
1 133 (70.74%) SQL
2 46 (24.47%) T-SQL
3 23 (12.23%) PL/SQL
4 7 (3.72%) C#
4 7 (3.72%) Data Analysis Expressions (DAX)
4 7 (3.72%) Python
5 5 (2.66%) Java
5 5 (2.66%) R
5 5 (2.66%) VBA
6 3 (1.60%) JavaScript
7 2 (1.06%) C
7 2 (1.06%) Clojure
7 2 (1.06%) Ruby
7 2 (1.06%) Scala
7 2 (1.06%) Shell Script
7 2 (1.06%) TypeScript
7 2 (1.06%) VB.NET
8 1 (0.53%) Bash Shell
Qualifications
1 27 (14.36%) Degree
2 15 (7.98%) Microsoft Certification
3 8 (4.26%) MCITP
4 2 (1.06%) SC Cleared
4 2 (1.06%) Security Cleared
Quality Assurance & Compliance
1 18 (9.57%) Data Quality
2 11 (5.85%) QA
System Software
1 1 (0.53%) Apache Flume
1 1 (0.53%) Docker
Systems Management
1 2 (1.06%) Dollar Universe
2 1 (0.53%) Cisco IPCC
2 1 (0.53%) Hadoop YARN
Vendors
1 75 (39.89%) Microsoft
2 73 (38.83%) Oracle
3 30 (15.96%) Informatica
4 27 (14.36%) Tableau
5 14 (7.45%) Endeca
6 13 (6.91%) IBM
7 10 (5.32%) SAP
7 10 (5.32%) Teradata
8 8 (4.26%) Cognos
9 5 (2.66%) Netezza
9 5 (2.66%) Talend
10 3 (1.60%) Alteryx
10 3 (1.60%) Jaspersoft
11 2 (1.06%) Salesforce.com
12 1 (0.53%) Ab Initio
12 1 (0.53%) Google
12 1 (0.53%) MicroStrategy
12 1 (0.53%) Pega
12 1 (0.53%) webMethods
Petersfield, Hampshire
Rullion IT Plus
Salary: £42000 - £50000 per annum + Pension
Posted: 23 hours ago
Warrington, Cheshire
Harvey Nash plc
Posted: 6 days ago
Kent
Venturi
Salary: £50000 - £58000 per annum + full bens
Posted: 5 days ago
South East London
Recital Consulting
Salary: £50000 - £65000 Per Annum Plus Benefits
Posted: 4 days ago
Milton Keynes, Buckinghamshire
Interact Consulting
Salary: 30-35k
Posted: 5 days ago