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

3 months to
29 Jul 2016
Same period 2015 Same period 2014
Star Schema
Rank 825 829 851
Rank change year-on-year
+4 +22
Permanent jobs citing Star Schema 93 146 142
As % of all permanent IT jobs located in the UK 0.095% 0.13% 0.12%
As % of the Database & Business Intelligence category 0.32% 0.42% 0.38%
Number of salaries quoted 79 84 122
Median salary £54,000 £47,000 £49,000
Median salary % change year-on-year
+14.89% -4.08%
90% offered a salary of more than £37,500 £36,500 £35,000
10% offered a salary of more than £73,500 £85,000 £65,000
UK excluding London median salary £40,000 £42,000 £45,000
% change year-on-year
-4.76% -6.66%

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
29124 34912 37414
As % of all permanent IT jobs located in the UK 29.74% 31.81% 31.90%
Number of salaries quoted 24743 29407 31937
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 £31,500 £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

The demand trend of job ads 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 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 29 July 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 median salaries quoted in IT jobs citing Star Schema within the UK over the 3 months to 29 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
England -23 84 £54,000 +14.89% 12
London +27 61 £55,500 -14.61% 6
City of London +54 14 £50,000 -41.17%
Scotland - 7 £47,500 -
Glasgow - 7 £47,500 -
North West +18 6 £37,500 -6.25% 1
Staffordshire -5 6 £39,750 -4.21% 1
West Midlands -13 6 £39,750 -4.21% 2
Yorkshire +38 5 £41,250 -2.94% 2
Cheshire +36 3 £35,000 -12.50% 1
Uxbridge -1 3 £44,000 -8.33%
Tamworth -3 3 £29,500 -28.91% 1
York - 3 £38,750 - 2
Lichfield - 3 £50,000 -
North Yorkshire - 3 £38,750 - 2
West Sussex -1 2 £60,000 +10.09%
South East -20 2 £60,000 +37.93%
South Wales - 2 £38,750 -
Tyne and Wear - 2 £37,000 - 1
Wales - 2 £38,750 -
East Midlands - 2 £52,500 -
North East - 2 £37,000 - 1
Nottinghamshire - 2 £52,500 -
Lancashire - 2 £40,000 -
Gatwick - 2 £60,000 -
Cardiff - 2 £38,750 -
Warrington - 2 £36,250 - 1
Newcastle upon Tyne - 2 £37,000 - 1
Nottingham - 2 £52,500 -
Preston - 2 £40,000 -

Star Schema
Top 30 Related IT Skills

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

1 155 (87.57%) Data Warehouse
2 133 (75.14%) SQL
3 125 (70.62%) Business Intelligence
4 108 (61.02%) ETL
5 104 (58.76%) SQL Server
6 87 (49.15%) SQL Server Integration Services
7 81 (45.76%) Finance
8 75 (42.37%) Microsoft
9 68 (38.42%) Data Modelling
10 61 (34.46%) Oracle
11 53 (29.94%) Kimball Methodology
12 52 (29.38%) SQL Server Analysis Services
13 48 (27.12%) T-SQL
14 47 (26.55%) SQL Server Reporting Services
15 44 (24.86%) Data Integration
16 42 (23.73%) Analytics
17 39 (22.03%) MS Excel
18 29 (16.38%) Relational Database
18 29 (16.38%) Data Architecture
19 26 (14.69%) BusinessObjects
19 26 (14.69%) Tableau
20 25 (14.12%) SQL Server 2014
20 25 (14.12%) SQL Server 2008
20 25 (14.12%) Degree
21 24 (13.56%) OLAP
22 23 (12.99%) Informatica
22 23 (12.99%) Data Quality
23 22 (12.43%) PL/SQL
24 21 (11.86%) RDBMS
24 21 (11.86%) Agile Software Development

Star Schema
Top Related IT Skills 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.82%) SharePoint
2 2 (1.13%) Apache Pig
2 2 (1.13%) Apache Spark
2 2 (1.13%) SAS
2 2 (1.13%) WebLogic
Applications
1 39 (22.03%) MS Excel
2 2 (1.13%) SPSS
Business Applications
1 11 (6.21%) Oracle Applications
2 1 (0.56%) Cognos Business Intelligence
2 1 (0.56%) Cognos TM1
2 1 (0.56%) Dynamics CRM
Cloud Services
1 7 (3.95%) Amazon AWS
2 4 (2.26%) Microsoft Azure
3 1 (0.56%) Amazon Kinesis
3 1 (0.56%) Amazon S3
3 1 (0.56%) AWS Elastic Beanstalk
3 1 (0.56%) Google Analytics
3 1 (0.56%) SaaS
Database & Business Intelligence
1 155 (87.57%) Data Warehouse
2 104 (58.76%) SQL Server
3 87 (49.15%) SQL Server Integration Services
4 52 (29.38%) SQL Server Analysis Services
5 47 (26.55%) SQL Server Reporting Services
6 29 (16.38%) Relational Database
7 26 (14.69%) BusinessObjects
8 25 (14.12%) SQL Server 2008
8 25 (14.12%) SQL Server 2014
9 24 (13.56%) OLAP
10 21 (11.86%) Oracle Database
10 21 (11.86%) RDBMS
11 18 (10.17%) Oracle Database 11g
11 18 (10.17%) Oracle Reports
12 17 (9.60%) Enterprise Data Warehouse
12 17 (9.60%) Oracle Database 12c
12 17 (9.60%) Oracle ODI
13 16 (9.04%) Microsoft Analysis Services
14 14 (7.91%) Oracle BI EE
14 14 (7.91%) Snowflake Schema
Development Applications
1 6 (3.39%) ERwin
2 4 (2.26%) Subversion
3 2 (1.13%) Visual Studio
4 1 (0.56%) Talend Open Studio
General
1 81 (45.76%) Finance
2 18 (10.17%) Banking
3 17 (9.60%) Retail
4 9 (5.08%) Legal
5 7 (3.95%) Marketing
6 6 (3.39%) Games
6 6 (3.39%) Publishing
7 5 (2.82%) Law
8 3 (1.69%) Back Office
8 3 (1.69%) Pharmaceutical
8 3 (1.69%) Telecoms
9 2 (1.13%) Investment Banking
10 1 (0.56%) Advertising
10 1 (0.56%) Manufacturing
Job Titles
1 106 (59.89%) Developer
2 48 (27.12%) Data Warehouse Developer
3 41 (23.16%) ETL Developer
4 38 (21.47%) SQL Developer
5 37 (20.90%) Business Intelligence Developer
6 35 (19.77%) Architect
6 35 (19.77%) Data Architect
6 35 (19.77%) SSIS Developer
7 26 (14.69%) Analyst
8 23 (12.99%) Analyst Developer
9 20 (11.30%) Consultant
10 19 (10.73%) Data Warehouse Analyst
11 18 (10.17%) Data Analyst
12 17 (9.60%) Business Objects Developer
12 17 (9.60%) Senior Consultant
13 16 (9.04%) Developer Analyst
14 15 (8.47%) Report Developer
14 15 (8.47%) SQL Analyst
15 14 (7.91%) Data Warehouse Architect
15 14 (7.91%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 15 (8.47%) MDX
2 12 (6.78%) .NET
3 6 (3.39%) XML
4 5 (2.82%) WCF
5 4 (2.26%) ASP.NET
5 4 (2.26%) Middleware
5 4 (2.26%) WinForms
6 2 (1.13%) ASP.NET MVC
6 2 (1.13%) CSS
6 2 (1.13%) HTML
6 2 (1.13%) JSON
6 2 (1.13%) Kafka
6 2 (1.13%) Twitter Bootstrap
6 2 (1.13%) Web Services
7 1 (0.56%) AngularJS
7 1 (0.56%) CSS3
7 1 (0.56%) HTML5
7 1 (0.56%) jQuery
7 1 (0.56%) REST
Miscellaneous
1 44 (24.86%) Data Integration
2 18 (10.17%) Visualisation
3 17 (9.60%) Management Information System
4 14 (7.91%) Analytical Skills
5 13 (7.34%) Computer Science
6 7 (3.95%) Mathematics
7 5 (2.82%) Online Games
8 3 (1.69%) Clustering
8 3 (1.69%) Enterprise Software
8 3 (1.69%) Fintech
8 3 (1.69%) Statistics
9 2 (1.13%) Data Extraction
9 2 (1.13%) Freedom of Information
9 2 (1.13%) iSeries
10 1 (0.56%) Life Science
10 1 (0.56%) Semantic Web
10 1 (0.56%) Virtual Team
Operating Systems
1 4 (2.26%) Unix
Processes & Methodologies
1 125 (70.62%) Business Intelligence
2 108 (61.02%) ETL
3 68 (38.42%) Data Modelling
4 53 (29.94%) Kimball Methodology
5 42 (23.73%) Analytics
6 29 (16.38%) Data Architecture
7 21 (11.86%) Agile Software Development
7 21 (11.86%) Data Management
8 18 (10.17%) ETL Development
9 16 (9.04%) Mentoring
9 16 (9.04%) Performance Tuning
10 15 (8.47%) Dimensional Modelling
10 15 (8.47%) Master Data Management
11 14 (7.91%) Data Visualisation
12 13 (7.34%) Data Governance
12 13 (7.34%) SDLC
13 12 (6.78%) Investment Management
13 12 (6.78%) Logical Data Model
13 12 (6.78%) Scrum
14 10 (5.65%) Data Analytics
Programming Languages
1 133 (75.14%) SQL
2 48 (27.12%) T-SQL
3 22 (12.43%) PL/SQL
4 13 (7.34%) C#
5 8 (4.52%) VB.NET
6 7 (3.95%) C
7 6 (3.39%) Python
8 5 (2.82%) VBA
9 4 (2.26%) Data Analysis Expressions (DAX)
9 4 (2.26%) Java
9 4 (2.26%) PowerShell
9 4 (2.26%) R
9 4 (2.26%) VB
10 2 (1.13%) Clojure
10 2 (1.13%) JavaScript
10 2 (1.13%) Ruby
10 2 (1.13%) Scala
10 2 (1.13%) Shell Script
11 1 (0.56%) TypeScript
Qualifications
1 25 (14.12%) Degree
2 5 (2.82%) Microsoft Certification
3 3 (1.69%) MCITP
4 2 (1.13%) SC Cleared
4 2 (1.13%) Security Cleared
Quality Assurance & Compliance
1 23 (12.99%) Data Quality
2 9 (5.08%) QA
System Software
1 1 (0.56%) Docker
1 1 (0.56%) Oracle RAC
Systems Management
1 2 (1.13%) Cisco IPCC
1 2 (1.13%) Dollar Universe
Vendors
1 75 (42.37%) Microsoft
2 61 (34.46%) Oracle
3 26 (14.69%) Tableau
4 23 (12.99%) Informatica
5 12 (6.78%) Endeca
5 12 (6.78%) SAP
6 8 (4.52%) Cognos
7 6 (3.39%) IBM
8 5 (2.82%) Vertica
9 4 (2.26%) Embarcadero
9 4 (2.26%) Teradata
10 3 (1.69%) Alteryx
10 3 (1.69%) Netezza
10 3 (1.69%) webMethods
11 1 (0.56%) Ab Initio
11 1 (0.56%) MicroStrategy
11 1 (0.56%) Pega
11 1 (0.56%) Salesforce.com
11 1 (0.56%) Talend
South East London
Recital Consulting
Salary: £50000 - £65000 Per Annum Plus Benefits
Posted: 7 hours ago
London
Lawrence Harvey Enterprise
Salary: £70000.00 - £75000.00 per annum + bonus, pension, health care
Posted: Yesterday
West Midlands
Applause IT Innovation
Salary: £40000 - £55000 per annum + Benefits
Posted: Yesterday
Tamworth, Staffordshire
Big Red Recruitment
Salary: £25000 - £34000 per annum
Posted: 3 days ago
Warrington, Cheshire
Harvey Nash plc
Posted: 4 days ago
London
Harvey Nash plc
Salary: £70000 - £75000 per annum + 10% Bonus & Excellent Package
Posted: 4 days ago
Newcastle upon Tyne
Lawrence Harvey
Salary: £32000 - £42000 per annum + Benefits, Pension
Posted: 7 days ago
London
Venturi
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: 4 days ago
York
Computer Futures
Salary: competitive
Posted: 16 days ago
London
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum + car, bonus, flexible working
Posted: 11 days ago
York
Computer Futures
Salary: competitive
Posted: 15 days ago
London
Venturi
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: 11 days ago