The table below looks at the statistics for Star Schema skills in IT jobs advertised for the London region. Included is a guide to the average salaries offered in IT jobs that have cited Star Schema over the 3 months to 21 November 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
21 Nov 2014
Same period 2013 Same period 2012
Star Schema
Rank 597 555 581
Rank change year-on-year
-42 +26
Permanent jobs citing Star Schema 36 66 45
As % of all permanent IT jobs located in London 0.080% 0.14% 0.097%
As % of the Database & Business Intelligence category 0.27% 0.47% 0.33%
Number of salaries quoted 33 54 41
Average salary £44,000 £55,000 £45,000
Average salary % change year-on-year
-20.00% +22.22%
90% offered a salary of more than £37,500 £46,100 £35,000
10% offered a salary of more than £69,000 £88,500 £90,000
UK excluding London average salary £48,000 £45,000 £43,500
% change year-on-year
+6.66% +3.44%
Star Schema
England

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 London region.

Database & Business Intelligence Category
London
Permanent IT job ads with a match in the
Database & Business Intelligence category
13255 14177 13615
As % of all permanent IT jobs located in London 29.29% 30.78% 29.25%
Number of salaries quoted 11512 12279 11940
Average salary £55,000 £55,000 £50,000
Average salary % change year-on-year
- +10.00%
90% offered a salary of more than £37,500 £37,000 £35,000
10% offered a salary of more than £75,000 £70,000 £75,000
UK excluding London average salary £40,000 £40,000 £40,000

Star Schema
Jobs Demand Trend in London

This chart provides a 3-month moving total of permanent IT jobs citing Star Schema across the London region as a proportion of the total demand within the Database & Business Intelligence category.

Star Schema Jobs Demand Trend in London

Star Schema
Salary Trend in London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Star Schema across the London region.

Star Schema Salary Trend in London

Star Schema
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing Star Schema across the London region over the 3 months to 21 November 2014.

Star Schema Salary Histogram in London

Star Schema
Job Locations in London

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Star Schema within the London region over the 3 months to 21 November 2014. 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
City of London +21 11 £47,000 -18.26% 4
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 21 November 2014, IT jobs across the London region 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 60 (81.08%) SQL
2 56 (75.68%) Data Warehouse
3 55 (74.32%) ETL
4 47 (63.51%) Business Intelligence
5 39 (52.70%) SQL Server
6 37 (50.00%) Finance
7 31 (41.89%) Oracle
8 28 (37.84%) Data Modelling
8 28 (37.84%) SQL Server Integration Services
9 26 (35.14%) SQL Server Analysis Services
9 26 (35.14%) Kimball Methodology
10 21 (28.38%) OLAP
11 20 (27.03%) Microsoft
11 20 (27.03%) Agile Software Development
12 18 (24.32%) T-SQL
12 18 (24.32%) PL/SQL
13 17 (22.97%) Oracle Database 11g
13 17 (22.97%) Oracle Database
14 16 (21.62%) Relational Database
14 16 (21.62%) SQL Server Reporting Services
14 16 (21.62%) Data Analysis
15 14 (18.92%) Dimensional Modelling
15 14 (18.92%) MS Excel
16 13 (17.57%) Oracle OLAP
17 12 (16.22%) Scrum
18 11 (14.86%) Degree
18 11 (14.86%) Data Integration
19 10 (13.51%) Marketing
19 10 (13.51%) Pharmaceutical
19 10 (13.51%) Cognos

Star Schema
Top Related IT Skills in London by Category

For the 6 months to 21 November 2014, IT jobs across the London region 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 5 (6.76%) MQSeries
2 4 (5.41%) SharePoint
Applications
1 14 (18.92%) MS Excel
2 3 (4.05%) Spreadsheet
3 2 (2.70%) SPSS
Business Applications
1 3 (4.05%) Cognos TM1
2 1 (1.35%) Cognos Controller
2 1 (1.35%) Oracle EBS
Cloud Services
1 1 (1.35%) Amazon AWS
Database & Business Intelligence
1 56 (75.68%) Data Warehouse
2 39 (52.70%) SQL Server
3 28 (37.84%) SQL Server Integration Services
4 26 (35.14%) SQL Server Analysis Services
5 21 (28.38%) OLAP
6 17 (22.97%) Oracle Database 11g
6 17 (22.97%) Oracle Database
7 16 (21.62%) Relational Database
7 16 (21.62%) SQL Server Reporting Services
8 13 (17.57%) Oracle OLAP
9 10 (13.51%) MySQL
10 9 (12.16%) Oracle Reports
11 8 (10.81%) OLAP Cube
11 8 (10.81%) QlikView
12 5 (6.76%) Oracle BI EE
13 4 (5.41%) SQL Server 2008
13 4 (5.41%) Pentaho
13 4 (5.41%) Microsoft Analysis Services
14 3 (4.05%) Snowflake Schema
14 3 (4.05%) Cognos Query Studio
Development Applications
1 4 (5.41%) Team Foundation Server
2 2 (2.70%) ERwin
General
1 37 (50.00%) Finance
2 10 (13.51%) Marketing
2 10 (13.51%) Pharmaceutical
3 5 (6.76%) Online Betting
4 4 (5.41%) Banking
5 2 (2.70%) Law
5 2 (2.70%) Legal
6 1 (1.35%) Investment Banking
6 1 (1.35%) Retail
Job Titles
1 51 (68.92%) Developer
2 17 (22.97%) Analyst
3 15 (20.27%) Data Warehouse Developer
4 10 (13.51%) SQL Developer
5 8 (10.81%) SQL Server Developer
5 8 (10.81%) Business Intelligence Developer
6 7 (9.46%) Oracle Data Warehouse Developer
6 7 (9.46%) ETL Developer
6 7 (9.46%) Data Warehouse Analyst
6 7 (9.46%) Developer Analyst
6 7 (9.46%) Data Analyst
6 7 (9.46%) Architect
7 6 (8.11%) Business Analyst
7 6 (8.11%) Oracle Developer
8 5 (6.76%) Consultant
8 5 (6.76%) QlikView Consultant
9 4 (5.41%) Business Developer
9 4 (5.41%) Senior Developer
9 4 (5.41%) Programmer
9 4 (5.41%) Data Programmer
Libraries, Frameworks & Software Standards
1 5 (6.76%) MDX
1 5 (6.76%) XML
Miscellaneous
1 11 (14.86%) Data Integration
2 5 (6.76%) Derivative
2 5 (6.76%) Analytical Skills
3 4 (5.41%) Data Structures
3 4 (5.41%) Management Information System
3 4 (5.41%) Hedge funds
3 4 (5.41%) Computer Science
4 2 (2.70%) Data Extraction
4 2 (2.70%) Freedom of Information
5 1 (1.35%) Visualisation
5 1 (1.35%) NHS
5 1 (1.35%) Enterprise Software
Operating Systems
1 8 (10.81%) UNIX
1 8 (10.81%) Linux
Processes & Methodologies
1 55 (74.32%) ETL
2 47 (63.51%) Business Intelligence
3 28 (37.84%) Data Modelling
4 26 (35.14%) Kimball Methodology
5 20 (27.03%) Agile Software Development
6 16 (21.62%) Data Analysis
7 14 (18.92%) Dimensional Modelling
8 12 (16.22%) Scrum
9 9 (12.16%) Performance Tuning
10 7 (9.46%) Migration
10 7 (9.46%) Mentoring
10 7 (9.46%) Kalman Filter
11 5 (6.76%) TDD
11 5 (6.76%) SOA
11 5 (6.76%) Data Reconciliation
12 4 (5.41%) Analytics
12 4 (5.41%) Data Analytics
12 4 (5.41%) Regression Testing
12 4 (5.41%) Data Architecture
12 4 (5.41%) Asset Management
Programming Languages
1 60 (81.08%) SQL
2 18 (24.32%) T-SQL
2 18 (24.32%) PL/SQL
3 7 (9.46%) Shell Script
4 3 (4.05%) VBA
5 2 (2.70%) Data Analysis Expressions (DAX)
6 1 (1.35%) C#
Qualifications
1 11 (14.86%) Degree
2 1 (1.35%) PMP
2 1 (1.35%) PMI Certification
Quality Assurance & Compliance
1 2 (2.70%) Data Quality
Vendors
1 31 (41.89%) Oracle
2 20 (27.03%) Microsoft
3 10 (13.51%) Cognos
4 9 (12.16%) Business Objects
4 9 (12.16%) Informatica
5 6 (8.11%) IBM
6 3 (4.05%) Tableau
7 2 (2.70%) MicroStrategy
7 2 (2.70%) Teradata
8 1 (1.35%) Trillium
8 1 (1.35%) Sybase
8 1 (1.35%) Ab Initio
Central London / West End
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 3 days ago
City, London
Parallel Consulting
Salary: £38000 - £48000 per annum + Bonus
Posted: 4 days ago
London
Real Staffing
Salary: £30000 - £32000 per annum + competitive
Posted: 11 days ago
London
Real Staffing
Salary: £30000 - £32000 per annum + competitive
Posted: 13 days ago
City of London
Interquest - ITQ Financial - London
Salary: £450 - £500 per day
Posted: 24 days ago