The following table provides summary statistics for permanent job vacancies advertised in England with a requirement for Star Schema skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Star Schema over the 3 months to 27 March 2017 with a comparison to the same period in the previous 2 years.

3 months to
27 Mar 2017
Same period 2016 Same period 2015
Star Schema
UK / England
Rank 773 836 838
Rank change year-on-year +63 +2  
Permanent jobs citing Star Schema 70 96 93
As % of all permanent IT jobs advertised in England 0.088% 0.099% 0.092%
As % of the Database & Business Intelligence category 0.29% 0.32% 0.29%
Number of salaries quoted 60 83 78
Median salary £52,500 £50,000 £50,000
Median salary % change year-on-year +5.00% -  
90% offered a salary of more than £25,800 £39,443 £37,500
10% offered a salary of more than £55,000 £65,800 £71,500
UK excluding London median salary £45,000 £40,000 £40,750
% change year-on-year +12.50% -1.84%  

Star Schema is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in England with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
England
Permanent job vacancies with a requirement for database and business intelligence skills 24161 30006 31631
As % of all permanent IT job vacancies advertised in England 30.40% 30.95% 31.29%
Number of salaries quoted 20757 25839 27058
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year - +11.11%  
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

Star Schema
Job Vacancy Trend in England

The job posting trend of jobs advertised in England citing Star Schema as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for Star Schema 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 in England.

Salary trend for Star Schema in England

Star Schema
Salary Histogram in England

The salary distribution of IT jobs citing Star Schema in England over the 3 months to 27 March 2017.

Salary histogram for Star Schema 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 27 March 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
London +50 31 £54,000 -1.81% 2
South East +63 13 £37,000 -10.30%
Yorkshire - 5 £37,500 -
East of England +24 3 £38,000 -10.58% 1
East Midlands +5 3 £43,750 -16.66% 1
West Midlands +27 2 £26,000 -25.71%
North East - 2 £44,500 - 1
North West - 1 £56,000 -
Star Schema
UK

Star Schema
Top 30 Related IT Skills in England

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

1 123 (86.01%) Data Warehouse
2 102 (71.33%) Business Intelligence
3 98 (68.53%) SQL
4 87 (60.84%) SQL Server
5 86 (60.14%) SQL Server Integration Services
6 69 (48.25%) ETL
7 66 (46.15%) Oracle
8 65 (45.45%) SQL Server Reporting Services
9 63 (44.06%) Data Modelling
10 62 (43.36%) SQL Server Analysis Services
11 58 (40.56%) Finance
12 52 (36.36%) Kimball Methodology
13 49 (34.27%) T-SQL
14 47 (32.87%) Agile Software Development
15 45 (31.47%) Microsoft
16 36 (25.17%) Informatica
17 30 (20.98%) Degree
18 29 (20.28%) MS Excel
19 26 (18.18%) Oracle BI EE
20 25 (17.48%) Oracle Database
20 25 (17.48%) BusinessObjects
21 23 (16.08%) Data Management
22 22 (15.38%) Oracle Reports
22 22 (15.38%) Performance Tuning
23 21 (14.69%) Mentoring
24 20 (13.99%) Retail
24 20 (13.99%) Oracle ODI
25 19 (13.29%) Oracle BI Publisher
25 19 (13.29%) Relational Database
26 18 (12.59%) Talend

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 4 (2.80%) Oracle SOA Suite
2 2 (1.40%) WebLogic
3 1 (0.70%) SharePoint
Applications
1 29 (20.28%) MS Excel
2 2 (1.40%) MS Office
3 1 (0.70%) MS Project
Business Applications
1 14 (9.79%) Oracle Applications
2 4 (2.80%) Cognos Business Intelligence
3 1 (0.70%) Dynamics AX
3 1 (0.70%) Oracle EBS
Cloud Services
1 11 (7.69%) Microsoft Azure
2 4 (2.80%) Amazon AWS
3 3 (2.10%) Google Cloud Platform
4 2 (1.40%) SaaS
Communications & Networking
1 1 (0.70%) Extranet
1 1 (0.70%) Internet
Database & Business Intelligence
1 123 (86.01%) Data Warehouse
2 87 (60.84%) SQL Server
3 86 (60.14%) SQL Server Integration Services
4 65 (45.45%) SQL Server Reporting Services
5 62 (43.36%) SQL Server Analysis Services
6 26 (18.18%) Oracle BI EE
7 25 (17.48%) BusinessObjects
7 25 (17.48%) Oracle Database
8 22 (15.38%) Oracle Reports
9 20 (13.99%) Oracle ODI
10 19 (13.29%) Oracle BI Publisher
10 19 (13.29%) Relational Database
11 18 (12.59%) Hadoop
11 18 (12.59%) MySQL
11 18 (12.59%) Snowflake Schema
12 17 (11.89%) Oracle Database 11g
13 16 (11.19%) BusinessObjects Business Intelligence
13 16 (11.19%) Oracle Database 12c
14 15 (10.49%) SAP Data Services
14 15 (10.49%) SQL Server 2012
Development Applications
1 18 (12.59%) Talend Open Studio
2 7 (4.90%) Visual Studio
3 6 (4.20%) ERwin
General
1 58 (40.56%) Finance
2 20 (13.99%) Retail
3 15 (10.49%) Banking
4 11 (7.69%) Local Government
5 6 (4.20%) Investment Banking
6 4 (2.80%) Publishing
7 3 (2.10%) Advertising
8 1 (0.70%) Automotive
8 1 (0.70%) German Language
8 1 (0.70%) Legal
Job Titles
1 74 (51.75%) Developer
2 41 (28.67%) Business Intelligence Developer
3 31 (21.68%) Consultant
3 31 (21.68%) SQL Developer
3 31 (21.68%) SSIS Developer
4 23 (16.08%) Data Warehouse Developer
5 21 (14.69%) Analyst
6 17 (11.89%) Data Analyst
6 17 (11.89%) SQL Analyst
7 16 (11.19%) Analyst Developer
7 16 (11.19%) Developer Analyst
7 16 (11.19%) OBIEE Consultant
7 16 (11.19%) Senior Consultant
7 16 (11.19%) SQL Data Analyst
8 15 (10.49%) Senior OBIEE Consultant
9 14 (9.79%) Business Consultant
9 14 (9.79%) Data Warehouse Analyst
9 14 (9.79%) ETL Analyst
9 14 (9.79%) ETL Developer
9 14 (9.79%) SSIS Analyst
Libraries, Frameworks & Software Standards
1 11 (7.69%) XML
2 5 (3.50%) .NET
3 4 (2.80%) Middleware
3 4 (2.80%) Web Services
4 3 (2.10%) Oracle GoldenGate
5 1 (0.70%) ASP.NET
5 1 (0.70%) CSS
5 1 (0.70%) HTML
5 1 (0.70%) jQuery
5 1 (0.70%) JSON
5 1 (0.70%) MDX
5 1 (0.70%) Twitter Bootstrap
Miscellaneous
1 12 (8.39%) Analytical Skills
2 8 (5.59%) Computer Science
3 7 (4.90%) Credit Risk
3 7 (4.90%) Management Information System
3 7 (4.90%) Market Risk
3 7 (4.90%) Replication
4 6 (4.20%) Data Structures
4 6 (4.20%) NHS
5 3 (2.10%) Semantic Web
6 2 (1.40%) Algorithms
6 2 (1.40%) Enterprise Software
6 2 (1.40%) Fintech
7 1 (0.70%) Client/Server
7 1 (0.70%) Driving Licence
7 1 (0.70%) iSeries
Operating Systems
1 1 (0.70%) AIX
1 1 (0.70%) Unix
Processes & Methodologies
1 102 (71.33%) Business Intelligence
2 69 (48.25%) ETL
3 63 (44.06%) Data Modelling
4 52 (36.36%) Kimball Methodology
5 47 (32.87%) Agile Software Development
6 23 (16.08%) Data Management
7 22 (15.38%) Performance Tuning
8 21 (14.69%) Mentoring
9 16 (11.19%) Dimensional Modelling
10 15 (10.49%) Data Migration
10 15 (10.49%) Information Architecture
10 15 (10.49%) Migration
11 14 (9.79%) Front End Development
12 12 (8.39%) Analytics
12 12 (8.39%) Security Management
13 11 (7.69%) Data Visualisation
13 11 (7.69%) High Availability
13 11 (7.69%) Logical Data Model
13 11 (7.69%) Master Data Management
13 11 (7.69%) Visualisation
Programming Languages
1 98 (68.53%) SQL
2 49 (34.27%) T-SQL
3 10 (6.99%) PL/SQL
4 5 (3.50%) C#
5 1 (0.70%) Data Analysis Expressions (DAX)
5 1 (0.70%) JavaScript
5 1 (0.70%) R
Qualifications
1 30 (20.98%) Degree
Quality Assurance & Compliance
1 13 (9.09%) Data Quality
2 1 (0.70%) GDPR
2 1 (0.70%) QA
Vendors
1 66 (46.15%) Oracle
2 45 (31.47%) Microsoft
3 36 (25.17%) Informatica
4 18 (12.59%) Talend
5 17 (11.89%) Cognos
6 16 (11.19%) SAP
7 11 (7.69%) Tableau
8 5 (3.50%) IBM
9 4 (2.80%) Google
9 4 (2.80%) Jaspersoft
9 4 (2.80%) Teradata
10 3 (2.10%) Hyperion
11 1 (0.70%) Birst
11 1 (0.70%) Pegasus
Northamptonshire
Nigel Frank International
Salary: £45000 per annum + unique benefits
Posted: 10 hours ago
Central London / West End
The Workshop
Posted: 3 days ago
Bury St. Edmunds, Suffolk
TLP Consultancy Ltd.
Salary: £27000 - £45000 per annum + package
Posted: 6 days ago