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 30 July 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
30 Jul 2015
Same period 2014 Same period 2013
Star Schema
Rank 769 790 785
Rank change year-on-year
+21 -5
Permanent jobs citing Star Schema 146 142 106
As % of all permanent IT jobs located in the UK 0.13% 0.12% 0.097%
As % of the Database & Business Intelligence category 0.43% 0.39% 0.31%
Number of salaries quoted 84 122 75
Average salary £47,000 £50,000 £41,000
Average salary % change year-on-year
-6.00% +21.95%
90% offered a salary of more than £36,500 £35,000 £35,000
10% offered a salary of more than £85,000 £65,000 £55,000
UK excluding London average salary £42,000 £45,000 £41,000
% change year-on-year
-6.66% +9.75%

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
33974 36468 34162
As % of all permanent IT jobs located in the UK 31.00% 31.14% 31.40%
Number of salaries quoted 28653 31146 29435
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £32,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £42,500 £40,000 £39,000
% change year-on-year
+6.25% +2.56%

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 30 July 2015 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 30 July 2015. 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 +43 142 £47,000 -6.00% 8
London +90 90 £65,000 +8.33% 6
South East -16 37 £43,500 -17.92% 1
Hampshire +2 15 £43,500 -8.42%
West Midlands +8 13 £41,500 +10.66% 1
Berkshire +8 9 £40,000 -33.33% 1
City of London +35 8 £85,000 +21.42% 1
Reading -2 8 £40,000 -33.33%
Uxbridge - 7 £48,000 - 1
Staffordshire - 6 £41,500 - 1
Tamworth - 6 £41,500 - 1
Buckinghamshire - 6 £27,500 -
Milton Keynes - 6 £27,500 -
Worcestershire -7 5 £36,500 -8.75%
Redditch - 5 £36,500 -
Surrey +10 2 £54,000 +20.00%
Havant +2 2 - -
Redhill - 2 £54,000 -
Oxford - 2 £40,000 -
Middlesex - 2 £55,000 -
Oxfordshire - 2 £40,000 -
Birmingham -4 1 £80,000 +106.45%
North West -6 1 £40,000 +26.47%
West Yorkshire -8 1 £42,500 -5.55%
Yorkshire -10 1 £42,500 -5.55%
Crawley -10 1 £54,500 -9.16%
West Sussex -11 1 £54,500 -9.16%
Halifax -14 1 £42,500 -5.55%
Bromley - 1 £45,000 -
Chester - 1 £40,000 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 30 July 2015, 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 184 (73.02%) Business Intelligence
2 172 (68.25%) SQL
2 172 (68.25%) SQL Server
3 166 (65.87%) Data Warehouse
4 157 (62.30%) SQL Server Integration Services
5 148 (58.73%) ETL
6 138 (54.76%) Data Modelling
7 130 (51.59%) Microsoft
8 117 (46.43%) Oracle
9 99 (39.29%) SQL Server Reporting Services
10 97 (38.49%) Finance
11 93 (36.90%) SQL Server Analysis Services
12 87 (34.52%) Agile Software Development
13 81 (32.14%) Kimball Methodology
14 74 (29.37%) Degree
15 73 (28.97%) T-SQL
16 68 (26.98%) Analytics
17 61 (24.21%) SQL Server 2008
18 58 (23.02%) Cognos
19 54 (21.43%) Analytical Skills
20 53 (21.03%) Performance Tuning
20 53 (21.03%) MS Excel
21 47 (18.65%) Computer Science
22 45 (17.86%) Big Data
22 45 (17.86%) BusinessObjects
23 44 (17.46%) Data Analysis
24 43 (17.06%) IBM
25 42 (16.67%) C#
26 41 (16.27%) Project Management
26 41 (16.27%) Data Structures

Star Schema
Top Related IT Skills by Category

For the 6 months to 30 July 2015, 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 8 (3.17%) SharePoint
2 6 (2.38%) SAS
3 1 (0.40%) BizTalk Server
3 1 (0.40%) Apache Pig
3 1 (0.40%) Apache Spark
Applications
1 53 (21.03%) MS Excel
2 19 (7.54%) MS Office
3 9 (3.57%) MS Visio
4 6 (2.38%) PowerPivot
5 5 (1.98%) Spreadsheet
6 2 (0.79%) SPSS
7 1 (0.40%) MS PowerPoint
Business Applications
1 14 (5.56%) Cognos Business Intelligence
2 4 (1.59%) Dynamics CRM
3 1 (0.40%) Oracle EBS
3 1 (0.40%) SAP Oil and Gas
Cloud Services
1 4 (1.59%) Cloud Computing
2 2 (0.79%) Microsoft Azure
3 1 (0.40%) IaaS
3 1 (0.40%) Amazon EMR
Communications & Networking
1 1 (0.40%) SMTP
1 1 (0.40%) TCP/IP
1 1 (0.40%) Firewall
Database & Business Intelligence
1 172 (68.25%) SQL Server
2 166 (65.87%) Data Warehouse
3 157 (62.30%) SQL Server Integration Services
4 99 (39.29%) SQL Server Reporting Services
5 93 (36.90%) SQL Server Analysis Services
6 61 (24.21%) SQL Server 2008
7 45 (17.86%) Big Data
7 45 (17.86%) BusinessObjects
8 38 (15.08%) OLAP
9 34 (13.49%) Oracle Reports
9 34 (13.49%) Oracle Database
10 30 (11.90%) Relational Database
11 29 (11.51%) Oracle Database 11g
12 28 (11.11%) Microsoft Analysis Services
13 25 (9.92%) OLAP Cube
14 21 (8.33%) Data Mart
15 20 (7.94%) Oracle OLAP
16 19 (7.54%) SQL Server 2005
17 16 (6.35%) QlikView
17 16 (6.35%) Snowflake Schema
Development Applications
1 30 (11.90%) Visual Studio
2 21 (8.33%) SQL Server Management Studio (SSMS)
3 18 (7.14%) ERwin
4 17 (6.75%) Team Foundation Server
5 13 (5.16%) Subversion
6 8 (3.17%) Talend Open Studio
7 5 (1.98%) Toad
8 4 (1.59%) VSS/SourceSafe
9 2 (0.79%) TeamCity
10 1 (0.40%) Git (software)
10 1 (0.40%) SoapUI
10 1 (0.40%) MSBuild
10 1 (0.40%) Jenkins
10 1 (0.40%) HP UFT
10 1 (0.40%) JIRA
10 1 (0.40%) FitNesse
10 1 (0.40%) Visual Studio Team System
General
1 97 (38.49%) Finance
2 25 (9.92%) Retail
3 24 (9.52%) Telecoms
4 16 (6.35%) Banking
5 13 (5.16%) Publishing
6 11 (4.37%) Front Office
7 9 (3.57%) Marketing
8 6 (2.38%) Advertising
9 5 (1.98%) Billing
10 2 (0.79%) Back Office
11 1 (0.40%) Electronics
11 1 (0.40%) Automotive
11 1 (0.40%) Legal
11 1 (0.40%) Manufacturing
Job Titles
1 153 (60.71%) Developer
2 64 (25.40%) Business Intelligence Developer
3 56 (22.22%) Analyst
4 32 (12.70%) Business Developer
5 25 (9.92%) Business Analyst
5 25 (9.92%) Architect
6 21 (8.33%) Data Analyst
7 20 (7.94%) Senior Developer
7 20 (7.94%) .NET Developer
7 20 (7.94%) Data Architect
8 18 (7.14%) SQL Developer
9 17 (6.75%) Business Intelligence Analyst
10 15 (5.95%) Consultant
11 14 (5.56%) Business Intelligence Consultant
12 12 (4.76%) Oracle Developer
12 12 (4.76%) Cognos Developer
12 12 (4.76%) Cognos BI Developer
13 10 (3.97%) ETL Developer
14 9 (3.57%) Data Consultant
14 9 (3.57%) Front-End Developer
Libraries, Frameworks & Software Standards
1 39 (15.48%) .NET
2 27 (10.71%) WCF
3 25 (9.92%) ASP.NET
3 25 (9.92%) Web Services
4 24 (9.52%) XML
5 22 (8.73%) ASP.NET MVC
6 19 (7.54%) .NET Framework
7 18 (7.14%) NHibernate
7 18 (7.14%) DAO
7 18 (7.14%) WF
7 18 (7.14%) ASP.NET MVC 2
7 18 (7.14%) Entity Framework
8 13 (5.16%) Middleware
9 9 (3.57%) HTML
10 8 (3.17%) WinForms
10 8 (3.17%) MDX
11 7 (2.78%) CSS
12 6 (2.38%) jQuery
12 6 (2.38%) Twitter Bootstrap
13 5 (1.98%) ADO.NET
Miscellaneous
1 54 (21.43%) Analytical Skills
2 47 (18.65%) Computer Science
3 41 (16.27%) Data Structures
4 32 (12.70%) Freedom of Information
4 32 (12.70%) Data Protection Act
4 32 (12.70%) Freedom of Information Act
5 31 (12.30%) Data Integration
6 29 (11.51%) Management Information System
7 14 (5.56%) Mathematics
8 6 (2.38%) Visualisation
9 4 (1.59%) Client/Server
9 4 (1.59%) Data Extraction
10 3 (1.19%) Blog
10 3 (1.19%) Replication
10 3 (1.19%) Economics
11 2 (0.79%) Statistics
11 2 (0.79%) Social Media
12 1 (0.40%) Enterprise Software
12 1 (0.40%) Algorithms
12 1 (0.40%) Data Centre
Operating Systems
1 38 (15.08%) UNIX
2 33 (13.10%) Windows
3 11 (4.37%) Linux
Processes & Methodologies
1 184 (73.02%) Business Intelligence
2 148 (58.73%) ETL
3 138 (54.76%) Data Modelling
4 87 (34.52%) Agile Software Development
5 81 (32.14%) Kimball Methodology
6 68 (26.98%) Analytics
7 53 (21.03%) Performance Tuning
8 44 (17.46%) Data Analysis
9 41 (16.27%) Project Management
10 40 (15.87%) Data Management
11 37 (14.68%) Inmon Methodology
12 32 (12.70%) Scrum
12 32 (12.70%) Data Protection
13 28 (11.11%) Dimensional Modelling
14 26 (10.32%) Data Architecture
15 22 (8.73%) Data Security
16 20 (7.94%) MVC
16 20 (7.94%) UML
17 18 (7.14%) DSDM
17 18 (7.14%) Workflow
Programming Languages
1 172 (68.25%) SQL
2 73 (28.97%) T-SQL
3 42 (16.67%) C#
4 36 (14.29%) PL/SQL
5 12 (4.76%) VB.NET
5 12 (4.76%) Shell Script
6 9 (3.57%) JavaScript
7 8 (3.17%) VB
8 7 (2.78%) Python
9 6 (2.38%) R
9 6 (2.38%) Java
10 4 (1.59%) C
11 2 (0.79%) PowerShell
12 1 (0.40%) Data Analysis Expressions (DAX)
12 1 (0.40%) XPath
12 1 (0.40%) Perl
Qualifications
1 74 (29.37%) Degree
2 22 (8.73%) Security Cleared
2 22 (8.73%) Microsoft Certification
3 18 (7.14%) MCP
4 13 (5.16%) DV Cleared
5 3 (1.19%) SC Cleared
5 3 (1.19%) MCITP
6 2 (0.79%) PMI Certification
7 1 (0.40%) MCTS
7 1 (0.40%) ISTQB
7 1 (0.40%) ISEB
7 1 (0.40%) PMP
Quality Assurance & Compliance
1 15 (5.95%) QA
1 15 (5.95%) Data Quality
2 4 (1.59%) Solvency II
System Software
1 4 (1.59%) VMware ESX
Systems Management
1 4 (1.59%) SCCM
1 4 (1.59%) Oracle EDQ
2 1 (0.40%) BMC PATROL
2 1 (0.40%) SCOM
Vendors
1 130 (51.59%) Microsoft
2 117 (46.43%) Oracle
3 58 (23.02%) Cognos
4 43 (17.06%) IBM
5 38 (15.08%) Informatica
6 31 (12.30%) Tableau
7 21 (8.33%) MicroStrategy
8 19 (7.54%) SAP
9 18 (7.14%) Sybase
9 18 (7.14%) Teradata
10 13 (5.16%) Ab Initio
11 12 (4.76%) Trillium
12 9 (3.57%) Capita
13 8 (3.17%) Talend
14 5 (1.98%) Salesforce.com
14 5 (1.98%) Zuora
15 3 (1.19%) Cloudera
16 1 (0.40%) Google
16 1 (0.40%) Netezza
16 1 (0.40%) Red Gate
Tamworth, Staffordshire
Big Red Recruitment
Salary: £41500 per annum + Non contrib Pension
Posted: 20 hours ago
City, London
Eutopia Solutions Ltd
Salary: £60000.00 - £75000.00 per annum + package & bonus
Posted: 2 days ago
Berkshire
Exposed Solutions
Salary: £30000 - £35000 per annum
Posted: 4 days ago
London
Initi8 Recruitment
Salary: £50000 - £60000 Per Annum
Posted: 5 days ago
London
ASOS
Salary: Competitive plus benefits
Posted: 8 days ago
Uxbridge
Ampersand Consulting
Salary: £48000 per annum + Bonus and Benefits
Posted: 10 days ago