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

Location
3 months to
5 Feb 2016
Same period 2015 Same period 2014
Star Schema
Rank 830 851 864
Rank change year-on-year
+21 +13
Permanent jobs citing Star Schema 121 90 85
As % of all permanent IT jobs located in the UK 0.12% 0.086% 0.082%
As % of the Database & Business Intelligence category 0.37% 0.28% 0.25%
Number of salaries quoted 112 75 60
Average salary £47,922 £44,000 £47,500
Average salary % change year-on-year
+8.91% -7.36%
90% offered a salary of more than £35,000 £31,000 £38,500
10% offered a salary of more than £67,500 £71,000 £65,000
UK excluding London average salary £40,000 £45,250 £45,000
% change year-on-year
-11.60% +0.55%

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
32338 32339 33745
As % of all permanent IT jobs located in the UK 31.86% 30.93% 32.75%
Number of salaries quoted 27451 27751 28547
Average salary £47,500 £45,000 £45,000
Average salary % change year-on-year
+5.55% -
90% offered a salary of more than £32,500 £31,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

Star Schema
Jobs Demand Trend

This chart provides the 3-month moving total of permanent IT jobs citing Star Schema within the UK as a proportion of the total demand within 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 5 February 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 average salaries quoted in IT jobs citing Star Schema within the UK over the 3 months to 5 February 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +26 102 £52,500 +19.31% 9
London +12 60 £57,500 +30.68% 8
South East +3 22 £40,000 -16.66% 1
Scotland - 13 £40,000 - 2
Berkshire - 11 £40,000 -
Edinburgh - 10 £40,000 - 1
Reading - 9 £40,000 -
West Midlands -14 8 £35,000 -10.65%
Birmingham - 7 £35,000 -
East of England - 6 £60,000 -
Milton Keynes - 5 £34,000 -
Buckinghamshire - 5 £34,000 -
Hampshire +8 4 £47,500 -1.04% 1
Hertfordshire - 4 £60,000 -
Glasgow - 3 £25,000 - 1
City of London +44 2 £54,500 +26.74% 4
Wales +1 2 £44,250 +26.42%
South Wales -1 2 £44,250 +26.42%
Uxbridge -1 2 £50,000 +13.63% 1
South West -9 2 £40,000 -38.46%
Midlands - 2 £52,500 -
Bedfordshire - 2 £24,000 -
Cirencester - 2 £40,000 -
Havant - 2 £48,045 - 1
Luton - 2 £24,000 -
Bracknell - 2 £40,000 -
Gloucestershire - 2 £40,000 -
Yorkshire +6 1 £30,000 -
West Yorkshire -3 1 £30,000 -
East Midlands -4 1 - -

Star Schema
Top 30 Related IT Skills

For the 6 months to 5 February 2016, IT jobs within the UK citing Star Schema also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Star Schema.

1 180 (78.26%) Data Warehouse
2 175 (76.09%) Business Intelligence
3 155 (67.39%) ETL
4 150 (65.22%) SQL
5 127 (55.22%) SQL Server Integration Services
6 126 (54.78%) SQL Server
7 115 (50.00%) Data Modelling
8 82 (35.65%) SQL Server Reporting Services
9 80 (34.78%) Finance
10 79 (34.35%) SQL Server Analysis Services
11 77 (33.48%) Oracle
12 74 (32.17%) Microsoft
13 61 (26.52%) Kimball Methodology
14 56 (24.35%) T-SQL
15 55 (23.91%) Data Integration
16 48 (20.87%) Analytics
17 46 (20.00%) MDX
18 44 (19.13%) Agile Software Development
18 44 (19.13%) MS Excel
19 42 (18.26%) SQL Server 2008
20 40 (17.39%) OLAP
21 38 (16.52%) Data Management
22 37 (16.09%) Data Analysis
22 37 (16.09%) Dimensional Modelling
23 35 (15.22%) Degree
23 35 (15.22%) Analytical Skills
24 30 (13.04%) Retail
24 30 (13.04%) Big Data
25 28 (12.17%) C#
26 27 (11.74%) SQL Server 2005

Star Schema
Top Related IT Skills by Category

For the 6 months to 5 February 2016, IT jobs within the UK citing Star Schema also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Star Schema. Up to 20 skills are shown per category.

Application Platforms
1 7 (3.04%) SharePoint
2 6 (2.61%) BizTalk Server
3 4 (1.74%) SAS
4 3 (1.30%) Apache Spark
4 3 (1.30%) Tomcat
4 3 (1.30%) WebLogic
5 2 (0.87%) Apache Pig
5 2 (0.87%) SharePoint 2013
6 1 (0.43%) Apache
Applications
1 44 (19.13%) MS Excel
2 6 (2.61%) MS Office
3 4 (1.74%) PowerPivot
4 1 (0.43%) SPSS
Business Applications
1 12 (5.22%) Oracle EBS
2 6 (2.61%) Cognos Business Intelligence
3 5 (2.17%) Hyperion Planning
4 3 (1.30%) Oracle Assets
4 3 (1.30%) Oracle EBS R12
4 3 (1.30%) Oracle ERP
4 3 (1.30%) Oracle General Ledger
4 3 (1.30%) Oracle Payables
4 3 (1.30%) Oracle Receivables
5 2 (0.87%) Cognos TM1
5 2 (0.87%) SAP Oil and Gas
6 1 (0.43%) Salesforce.com CRM
6 1 (0.43%) SAP APO
Cloud Services
1 6 (2.61%) Microsoft Azure
2 5 (2.17%) Office 365
3 4 (1.74%) Cloud Computing
4 1 (0.43%) Amazon EMR
4 1 (0.43%) Google Cloud Platform
4 1 (0.43%) IaaS
Communications & Networking
1 2 (0.87%) FTP
Database & Business Intelligence
1 180 (78.26%) Data Warehouse
2 127 (55.22%) SQL Server Integration Services
3 126 (54.78%) SQL Server
4 82 (35.65%) SQL Server Reporting Services
5 79 (34.35%) SQL Server Analysis Services
6 42 (18.26%) SQL Server 2008
7 40 (17.39%) OLAP
8 30 (13.04%) Big Data
9 27 (11.74%) SQL Server 2005
9 27 (11.74%) SQL Server 2012
10 26 (11.30%) Relational Database
11 24 (10.43%) Data Mart
12 23 (10.00%) Oracle Database
13 18 (7.83%) BusinessObjects
13 18 (7.83%) QlikView
14 17 (7.39%) Snowflake Schema
15 16 (6.96%) Power BI
16 15 (6.52%) Cognos Framework Manager
16 15 (6.52%) OLAP Cube
17 14 (6.09%) MySQL
Development Applications
1 12 (5.22%) Visual Studio
2 8 (3.48%) Team Foundation Server
3 6 (2.61%) Subversion
3 6 (2.61%) Talend Open Studio
4 4 (1.74%) SQL Server Management Studio (SSMS)
4 4 (1.74%) VSS/SourceSafe
5 3 (1.30%) ERwin
6 1 (0.43%) Git (software)
6 1 (0.43%) Jenkins
General
1 80 (34.78%) Finance
2 30 (13.04%) Retail
3 19 (8.26%) Banking
4 6 (2.61%) Publishing
5 5 (2.17%) Telecoms
6 4 (1.74%) Marketing
6 4 (1.74%) Pharmaceutical
7 3 (1.30%) Games
7 3 (1.30%) Law
8 2 (0.87%) Electronics
8 2 (0.87%) Manufacturing
9 1 (0.43%) German Language
9 1 (0.43%) Greek Language
9 1 (0.43%) Legal
Job Titles
1 112 (48.70%) Developer
2 62 (26.96%) Business Intelligence Developer
3 34 (14.78%) Analyst
4 28 (12.17%) Business Developer
4 28 (12.17%) Consultant
5 20 (8.70%) ETL Developer
6 18 (7.83%) Architect
6 18 (7.83%) Business Intelligence Analyst
7 17 (7.39%) Analyst Developer
7 17 (7.39%) Business Intelligence Consultant
7 17 (7.39%) SQL Developer
8 16 (6.96%) Developer Analyst
8 16 (6.96%) Oracle Consultant
9 15 (6.52%) Data Architect
9 15 (6.52%) Senior Developer
10 14 (6.09%) Data Warehouse Developer
11 13 (5.65%) Business Consultant
12 12 (5.22%) Junior
13 11 (4.78%) Business Manager
13 11 (4.78%) Junior Developer
Libraries, Frameworks & Software Standards
1 46 (20.00%) MDX
2 22 (9.57%) .NET
3 15 (6.52%) XML
4 14 (6.09%) Web Services
5 10 (4.35%) SOAP
6 8 (3.48%) CSS
6 8 (3.48%) HTML
6 8 (3.48%) jQuery
6 8 (3.48%) Twitter Bootstrap
7 7 (3.04%) ASP.NET
7 7 (3.04%) ASP.NET MVC
8 6 (2.61%) XSL
9 3 (1.30%) DOM
9 3 (1.30%) J2EE
9 3 (1.30%) JavaBeans
9 3 (1.30%) JAXB
9 3 (1.30%) JSP
9 3 (1.30%) SAX
9 3 (1.30%) Struts
9 3 (1.30%) XSLT
Miscellaneous
1 55 (23.91%) Data Integration
2 35 (15.22%) Analytical Skills
3 20 (8.70%) Computer Science
4 15 (6.52%) Data Structures
5 12 (5.22%) Clustering
6 9 (3.91%) Mathematics
7 8 (3.48%) Data Extraction
8 7 (3.04%) Client/Server
8 7 (3.04%) Visualisation
9 4 (1.74%) Enterprise Software
10 3 (1.30%) Statistics
11 2 (0.87%) Management Information System
12 1 (0.43%) Algorithms
12 1 (0.43%) Fintech
12 1 (0.43%) Hedge funds
12 1 (0.43%) Online Games
12 1 (0.43%) Ontologies
12 1 (0.43%) Reference Data
Operating Systems
1 16 (6.96%) Unix
2 9 (3.91%) Linux
3 5 (2.17%) Windows
4 1 (0.43%) Windows Server 2008
Processes & Methodologies
1 175 (76.09%) Business Intelligence
2 155 (67.39%) ETL
3 115 (50.00%) Data Modelling
4 61 (26.52%) Kimball Methodology
5 48 (20.87%) Analytics
6 44 (19.13%) Agile Software Development
7 38 (16.52%) Data Management
8 37 (16.09%) Data Analysis
8 37 (16.09%) Dimensional Modelling
9 23 (10.00%) Migration
10 22 (9.57%) Performance Tuning
11 20 (8.70%) Continuous Improvement
11 20 (8.70%) Data Governance
11 20 (8.70%) Scrum
12 19 (8.26%) ITIL
12 19 (8.26%) Physical Data Model
13 18 (7.83%) Logical Data Model
13 18 (7.83%) Translating Business Requirements
14 16 (6.96%) Data Transformation
15 15 (6.52%) PRINCE2
Programming Languages
1 150 (65.22%) SQL
2 56 (24.35%) T-SQL
3 28 (12.17%) C#
4 26 (11.30%) PL/SQL
5 14 (6.09%) PowerShell
6 12 (5.22%) Java
6 12 (5.22%) Shell Script
7 11 (4.78%) JavaScript
8 9 (3.91%) VB.NET
9 8 (3.48%) VB
10 6 (2.61%) Perl
11 5 (2.17%) Python
12 3 (1.30%) XPath
13 2 (0.87%) Data Analysis Expressions (DAX)
14 1 (0.43%) Bash Shell
14 1 (0.43%) C-shell
14 1 (0.43%) R
14 1 (0.43%) SPARQL
Qualifications
1 35 (15.22%) Degree
2 4 (1.74%) Security Cleared
3 3 (1.30%) MCITP
3 3 (1.30%) Microsoft Certification
Quality Assurance & Compliance
1 23 (10.00%) Data Quality
2 3 (1.30%) QA
System Software
1 5 (2.17%) Oracle RAC
2 4 (1.74%) VMware ESX
3 1 (0.43%) Apache Flume
Systems Management
1 6 (2.61%) OpenView
2 4 (1.74%) Dollar Universe
2 4 (1.74%) SCCM
3 1 (0.43%) Control-M
3 1 (0.43%) Hadoop YARN
3 1 (0.43%) Oozie
Vendors
1 77 (33.48%) Oracle
2 74 (32.17%) Microsoft
3 27 (11.74%) Tableau
4 22 (9.57%) Cognos
5 21 (9.13%) Informatica
6 19 (8.26%) IBM
7 10 (4.35%) SAP
8 7 (3.04%) Vertica
9 6 (2.61%) Hyperion
9 6 (2.61%) MicroStrategy
9 6 (2.61%) Talend
10 4 (1.74%) Capita
11 3 (1.30%) Teradata
12 2 (0.87%) Cloudera
12 2 (0.87%) Greenplum
12 2 (0.87%) Hortonworks
12 2 (0.87%) MapR
12 2 (0.87%) Netezza
13 1 (0.43%) Alteryx
13 1 (0.43%) Anaplan
City, London
Venturi
Salary: £70000 - £75000 per annum + bonus +Full bens
Posted: Yesterday
Edinburgh, Midlothian
Search Consultancy
Salary: DOE
Posted: 5 days ago
Havant, Hampshire
SSE
Salary: £41,404 - 54,685 (SSE9)
Posted: 9 days ago
City, London
Business Decision
Posted: 10 days ago
City, London
Business Decision
Posted: 10 days ago
Uxbridge
Ampersand Consulting
Salary: £50000 per annum + Bonus and Benefits
Posted: 11 days ago
City of London
Venturi
Salary: £63000 - £70000.00 per annum + Full bens
Posted: 17 days ago
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £20,000 to £25,000 per annum
Posted: 24 days ago