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

3 months to
26 Jul 2016
Same period 2015 Same period 2014
Star Schema
Rank 824 805 840
Rank change year-on-year
-19 +35
Permanent jobs citing Star Schema 79 148 132
As % of all permanent IT jobs located in England 0.086% 0.14% 0.12%
As % of the Database & Business Intelligence category 0.29% 0.45% 0.38%
Number of salaries quoted 70 87 116
Median salary £54,000 £46,500 £50,000
Median salary % change year-on-year
+16.12% -7.00%
90% offered a salary of more than £37,450 £36,500 £39,250
10% offered a salary of more than £77,500 £85,000 £65,000
UK excluding London median salary £40,000 £42,500 £45,000
% change year-on-year
-5.88% -5.55%
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
27214 32872 34987
As % of all permanent IT jobs located in England 29.68% 31.94% 32.16%
Number of salaries quoted 23499 27955 30143
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,000 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 26 July 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 26 July 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 +5 57 £55,500 -14.61% 4
North West +28 6 £37,500 -6.25% 2
Yorkshire +37 5 £41,250 +1.85% 2
West Midlands -13 4 £29,500 -28.91% 2
South East -6 3 £60,000 +37.93%
East Midlands - 2 £52,500 -
North East - 2 £37,000 - 2
Star Schema
UK

Star Schema
Top 30 Related IT Skills in England

For the 6 months to 26 July 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 143 (86.14%) Data Warehouse
2 124 (74.70%) SQL
3 119 (71.69%) Business Intelligence
4 103 (62.05%) ETL
5 102 (61.45%) SQL Server
6 84 (50.60%) SQL Server Integration Services
7 76 (45.78%) Finance
8 74 (44.58%) Microsoft
9 66 (39.76%) Data Modelling
10 54 (32.53%) Kimball Methodology
11 53 (31.93%) SQL Server Analysis Services
12 49 (29.52%) Oracle
13 48 (28.92%) T-SQL
13 48 (28.92%) SQL Server Reporting Services
14 40 (24.10%) Data Integration
15 38 (22.89%) MS Excel
16 36 (21.69%) Analytics
17 31 (18.67%) Data Architecture
18 27 (16.27%) Tableau
18 27 (16.27%) Relational Database
19 25 (15.06%) Degree
19 25 (15.06%) BusinessObjects
20 24 (14.46%) OLAP
20 24 (14.46%) SQL Server 2008
20 24 (14.46%) SQL Server 2014
21 21 (12.65%) RDBMS
22 20 (12.05%) Oracle Database
23 19 (11.45%) Data Management
23 19 (11.45%) Data Quality
24 18 (10.84%) Oracle Reports

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 (3.01%) SharePoint
2 2 (1.20%) Apache Pig
2 2 (1.20%) Apache Spark
2 2 (1.20%) SAS
2 2 (1.20%) WebLogic
Applications
1 38 (22.89%) MS Excel
2 2 (1.20%) SPSS
Business Applications
1 10 (6.02%) Oracle Applications
2 1 (0.60%) Cognos Business Intelligence
2 1 (0.60%) Cognos TM1
2 1 (0.60%) Dynamics CRM
Cloud Services
1 7 (4.22%) Amazon AWS
2 4 (2.41%) Microsoft Azure
3 1 (0.60%) Amazon Kinesis
3 1 (0.60%) Amazon S3
3 1 (0.60%) AWS Elastic Beanstalk
3 1 (0.60%) Google Analytics
3 1 (0.60%) SaaS
Database & Business Intelligence
1 143 (86.14%) Data Warehouse
2 102 (61.45%) SQL Server
3 84 (50.60%) SQL Server Integration Services
4 53 (31.93%) SQL Server Analysis Services
5 48 (28.92%) SQL Server Reporting Services
6 27 (16.27%) Relational Database
7 25 (15.06%) BusinessObjects
8 24 (14.46%) OLAP
8 24 (14.46%) SQL Server 2008
8 24 (14.46%) SQL Server 2014
9 21 (12.65%) RDBMS
10 20 (12.05%) Oracle Database
11 18 (10.84%) Oracle Reports
12 17 (10.24%) Oracle Database 11g
12 17 (10.24%) Oracle ODI
13 16 (9.64%) Microsoft Analysis Services
13 16 (9.64%) Oracle Database 12c
14 15 (9.04%) Enterprise Data Warehouse
15 13 (7.83%) Big Data
15 13 (7.83%) Oracle BI EE
Development Applications
1 5 (3.01%) ERwin
2 4 (2.41%) Subversion
3 2 (1.20%) Visual Studio
4 1 (0.60%) Talend Open Studio
General
1 76 (45.78%) Finance
2 15 (9.04%) Retail
3 11 (6.63%) Banking
4 10 (6.02%) Legal
5 8 (4.82%) Law
6 6 (3.61%) Games
6 6 (3.61%) Publishing
7 5 (3.01%) Marketing
8 4 (2.41%) Pharmaceutical
8 4 (2.41%) Telecoms
9 3 (1.81%) Back Office
10 2 (1.20%) Investment Banking
11 1 (0.60%) Advertising
11 1 (0.60%) Manufacturing
Job Titles
1 97 (58.43%) Developer
2 40 (24.10%) Data Warehouse Developer
3 39 (23.49%) ETL Developer
4 38 (22.89%) SQL Developer
5 36 (21.69%) Architect
5 36 (21.69%) Data Architect
6 35 (21.08%) Business Intelligence Developer
7 33 (19.88%) SSIS Developer
8 21 (12.65%) Analyst
9 18 (10.84%) Analyst Developer
9 18 (10.84%) Consultant
10 17 (10.24%) Business Objects Developer
11 16 (9.64%) Senior Consultant
12 15 (9.04%) SQL Analyst
13 14 (8.43%) Data Warehouse Analyst
13 14 (8.43%) Report Developer
13 14 (8.43%) SQL Data Analyst
14 13 (7.83%) Data Analyst
14 13 (7.83%) Data Warehouse Architect
15 12 (7.23%) Lead Developer
Libraries, Frameworks & Software Standards
1 15 (9.04%) MDX
2 13 (7.83%) .NET
3 6 (3.61%) XML
4 5 (3.01%) WCF
5 4 (2.41%) ASP.NET
5 4 (2.41%) Middleware
5 4 (2.41%) WinForms
6 2 (1.20%) ASP.NET MVC
6 2 (1.20%) CSS
6 2 (1.20%) HTML
6 2 (1.20%) JSON
6 2 (1.20%) Kafka
6 2 (1.20%) Twitter Bootstrap
6 2 (1.20%) Web Services
7 1 (0.60%) AngularJS
7 1 (0.60%) CSS3
7 1 (0.60%) HTML5
7 1 (0.60%) jQuery
7 1 (0.60%) REST
Miscellaneous
1 40 (24.10%) Data Integration
2 16 (9.64%) Management Information System
2 16 (9.64%) Visualisation
3 14 (8.43%) Analytical Skills
3 14 (8.43%) Computer Science
4 8 (4.82%) Mathematics
5 5 (3.01%) Online Games
6 4 (2.41%) Statistics
7 3 (1.81%) Clustering
7 3 (1.81%) Enterprise Software
7 3 (1.81%) Fintech
7 3 (1.81%) Virtual Team
8 2 (1.20%) Data Extraction
8 2 (1.20%) Freedom of Information
9 1 (0.60%) Life Science
9 1 (0.60%) Semantic Web
Operating Systems
1 4 (2.41%) Unix
Processes & Methodologies
1 119 (71.69%) Business Intelligence
2 103 (62.05%) ETL
3 66 (39.76%) Data Modelling
4 54 (32.53%) Kimball Methodology
5 36 (21.69%) Analytics
6 31 (18.67%) Data Architecture
7 19 (11.45%) Data Management
8 17 (10.24%) ETL Development
9 16 (9.64%) Agile Software Development
9 16 (9.64%) Performance Tuning
10 15 (9.04%) Mentoring
11 13 (7.83%) Logical Data Model
12 12 (7.23%) Data Governance
12 12 (7.23%) Data Visualisation
12 12 (7.23%) Dimensional Modelling
12 12 (7.23%) Investment Management
13 11 (6.63%) Data Analytics
14 10 (6.02%) Master Data Management
14 10 (6.02%) SDLC
15 8 (4.82%) SOA
Programming Languages
1 124 (74.70%) SQL
2 48 (28.92%) T-SQL
3 17 (10.24%) PL/SQL
4 14 (8.43%) C#
5 9 (5.42%) VB.NET
6 7 (4.22%) C
7 6 (3.61%) Python
8 5 (3.01%) VBA
9 4 (2.41%) Data Analysis Expressions (DAX)
9 4 (2.41%) Java
9 4 (2.41%) PowerShell
9 4 (2.41%) R
9 4 (2.41%) VB
10 2 (1.20%) Clojure
10 2 (1.20%) JavaScript
10 2 (1.20%) Ruby
10 2 (1.20%) Scala
10 2 (1.20%) Shell Script
11 1 (0.60%) TypeScript
Qualifications
1 25 (15.06%) Degree
2 5 (3.01%) Microsoft Certification
3 3 (1.81%) MCITP
4 2 (1.20%) SC Cleared
4 2 (1.20%) Security Cleared
Quality Assurance & Compliance
1 19 (11.45%) Data Quality
2 7 (4.22%) QA
System Software
1 2 (1.20%) Oracle RAC
2 1 (0.60%) Docker
Systems Management
1 2 (1.20%) Cisco IPCC
1 2 (1.20%) Dollar Universe
Vendors
1 74 (44.58%) Microsoft
2 49 (29.52%) Oracle
3 27 (16.27%) Tableau
4 15 (9.04%) Informatica
5 12 (7.23%) SAP
6 11 (6.63%) Endeca
7 8 (4.82%) Cognos
8 4 (2.41%) Embarcadero
9 3 (1.81%) Alteryx
9 3 (1.81%) IBM
9 3 (1.81%) webMethods
10 1 (0.60%) Ab Initio
10 1 (0.60%) MicroStrategy
10 1 (0.60%) Netezza
10 1 (0.60%) Pega
10 1 (0.60%) Salesforce.com
10 1 (0.60%) Talend
10 1 (0.60%) Teradata
Tamworth, Staffordshire
Big Red Recruitment
Salary: £25000 - £34000 per annum
Posted: 13 hours ago
Warrington, Cheshire
Harvey Nash plc
Posted: Yesterday
London
Harvey Nash plc
Salary: £70000 - £75000 per annum + 10% Bonus & Excellent Package
Posted: Yesterday
Newcastle upon Tyne
Lawrence Harvey
Salary: £32000 - £42000 per annum + Benefits, Pension
Posted: 5 days ago
London
Venturi
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: Yesterday
Bishop Auckland, County Durham
Lawrence Harvey IT & Change
Salary: £92184.10 - £105353.26 per annum + Bonus + Benefits
Posted: 6 days ago
York
Computer Futures
Salary: competitive
Posted: 14 days ago
London
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum + car, bonus, flexible working
Posted: 9 days ago
York
Computer Futures
Salary: competitive
Posted: 12 days ago
Preston, Lancashire
BAE Systems
Posted: 12 days ago
London
Venturi
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: 8 days ago