The first table below looks at the demand for Star Schema skills in IT jobs advertised for the City of London region. Included is a guide to the average salaries offered in IT jobs that have cited Star Schema over the 3 months to 24 May 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category for the City of London region.

Location
3 months to
24 May 2013
Same period 2012 Same period 2011
Star Schema
Rank 309 312 318
Rank change year-on-year
+3 +6
Permanent jobs citing Star Schema 12 11 13
As % of all permanent IT jobs located in the City of London 0.103% 0.084% 0.084%
As % of the Database & Business Intelligence category 0.400% 0.317% 0.340%
Number of salaries quoted 12 10 12
Average salary £47,500 £60,000 £60,000
Average salary % change year-on-year
-20.83% -
90% offered a salary of more than £40,000 £54,500 £43,000
10% offered a salary of more than £68,250 £67,750 £65,000
UK excluding London average salary £42,250 £47,500 £45,000
% change year-on-year
-11.05% +5.55%
All Database & Business Intelligence
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
2997 3470 3828
As % of all permanent IT jobs located in the City of London 25.69% 26.56% 24.81%
Number of salaries quoted 2626 3208 3471
Average salary £52,500 £55,000 £52,500
Average salary % change year-on-year
-4.54% +4.76%
90% offered a salary of more than £35,000 £35,000 £35,000
10% offered a salary of more than £72,500 £80,000 £72,500
UK excluding London average salary £38,500 £37,500 £37,500
% change year-on-year
+2.66% -
Star Schema
London

Star Schema
Jobs Demand Trend

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

City of London Star Schema Jobs Demand Trend

Star Schema
Salary Trend

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

City of London Star Schema Salary Trend

Star Schema
Salary Histogram

This chart provides a salary histogram for IT jobs citing Star Schema across the City of London region over the 3 months to 24 May 2013.

City of London Star Schema Salary Histogram

Star Schema
Top 30 Related IT Skills

For the 6 months to 24 May 2013, IT jobs across the City of 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 27 (90.00%) Business Intelligence
2 25 (83.33%) Data Warehouse
3 20 (66.67%) SQL Server Reporting Services
3 20 (66.67%) SQL Server Integration Services
4 19 (63.33%) SQL Server Analysis Services
4 19 (63.33%) SQL
5 17 (56.67%) SQL Server
5 17 (56.67%) ETL
6 16 (53.33%) Microsoft
7 13 (43.33%) Data Modelling
8 11 (36.67%) T-SQL
9 9 (30.00%) OLAP
9 9 (30.00%) Advertising
10 8 (26.67%) Microsoft Certification
10 8 (26.67%) .NET
10 8 (26.67%) Oracle
10 8 (26.67%) C#
10 8 (26.67%) UNIX
11 7 (23.33%) Data Mining
11 7 (23.33%) MDX
11 7 (23.33%) SQL Server 2008
12 6 (20.00%) Computer Science
12 6 (20.00%) SQL Server 2005
12 6 (20.00%) PL/SQL
12 6 (20.00%) Shell Script
13 5 (16.67%) Informatica
13 5 (16.67%) Workflow
13 5 (16.67%) Visual Studio
13 5 (16.67%) MS Excel
13 5 (16.67%) Degree

Star Schema
Top Related IT Skills by Category

For the 6 months to 24 May 2013, IT jobs across the City of 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 Development
1 8 (26.67%) .NET
2 7 (23.33%) MDX
3 4 (13.33%) .NET Framework
3 4 (13.33%) WCF
3 4 (13.33%) WF
3 4 (13.33%) DAO
3 4 (13.33%) ASP.NET MVC
3 4 (13.33%) ASP.NET MVC 2
3 4 (13.33%) ADO.NET Entity Framework
3 4 (13.33%) ADO.NET
3 4 (13.33%) ASP.NET
3 4 (13.33%) Web Services
4 3 (10.00%) XML
Application Platforms
1 4 (13.33%) BizTalk Server
2 3 (10.00%) PowerExchange
3 1 (3.333%) SharePoint
3 1 (3.333%) SharePoint 2013
Applications
1 5 (16.67%) MS Excel
2 1 (3.333%) MS Visio
2 1 (3.333%) PowerPivot
Database & Business Intelligence
1 25 (83.33%) Data Warehouse
2 20 (66.67%) SQL Server Reporting Services
2 20 (66.67%) SQL Server Integration Services
3 19 (63.33%) SQL Server Analysis Services
4 17 (56.67%) SQL Server
5 9 (30.00%) OLAP
6 7 (23.33%) Data Mining
6 7 (23.33%) SQL Server 2008
7 6 (20.00%) SQL Server 2005
8 4 (13.33%) Microsoft Analysis Services
9 3 (10.00%) Oracle 10g
9 3 (10.00%) BusinessObjects
9 3 (10.00%) Oracle OWB
9 3 (10.00%) RDBMS
9 3 (10.00%) Oracle 8/8i
9 3 (10.00%) Oracle 11g
10 2 (6.667%) Oracle BI EE
10 2 (6.667%) OLTP
10 2 (6.667%) Oracle Reports
10 2 (6.667%) SQL Server 2000
Development Applications
1 5 (16.67%) Visual Studio
2 3 (10.00%) ERwin
2 3 (10.00%) PVCS
2 3 (10.00%) Subversion
3 1 (3.333%) Team Foundation Server
General
1 9 (30.00%) Advertising
2 4 (13.33%) Telecoms
3 3 (10.00%) Finance
3 3 (10.00%) Music
3 3 (10.00%) Music Industry
4 2 (6.667%) Financial Institution
4 2 (6.667%) Banking
Job Titles
1 24 (80.00%) Developer
2 13 (43.33%) Business Intelligence Developer
3 10 (33.33%) Microsoft Developer
4 5 (16.67%) Business Developer
5 4 (13.33%) Business Intelligence Architect
5 4 (13.33%) Senior Developer
5 4 (13.33%) .NET Developer
5 4 (13.33%) Architect
6 3 (10.00%) Informatica Developer
6 3 (10.00%) Technical Developer
7 2 (6.667%) OBIEE Architect
8 1 (3.333%) Business Analyst
8 1 (3.333%) Analyst
8 1 (3.333%) Business Systems Analyst
8 1 (3.333%) Systems Analyst
8 1 (3.333%) Technical Architect
8 1 (3.333%) Consultant
8 1 (3.333%) Business Intelligence Consultant
8 1 (3.333%) Microsoft BI Consultant
8 1 (3.333%) Microsoft Consultant
Miscellaneous
1 6 (20.00%) Computer Science
2 4 (13.33%) Mathematics
3 3 (10.00%) SaaS
3 3 (10.00%) Open Source
4 1 (3.333%) Video on Demand
Operating Systems
1 8 (26.67%) UNIX
2 4 (13.33%) Windows
3 3 (10.00%) Linux
Processes & Methodologies
1 27 (90.00%) Business Intelligence
2 17 (56.67%) ETL
3 13 (43.33%) Data Modelling
4 5 (16.67%) Workflow
5 4 (13.33%) Data Analysis
5 4 (13.33%) Kimball Methodology
5 4 (13.33%) MVC
5 4 (13.33%) Scrum
5 4 (13.33%) Agile Software Development
6 3 (10.00%) Configuration Management
6 3 (10.00%) Migration
6 3 (10.00%) Master Data Management
6 3 (10.00%) Data Management
6 3 (10.00%) Regression Testing
6 3 (10.00%) Test Scripting
7 2 (6.667%) Enterprise Architecture
7 2 (6.667%) Systems Analysis
7 2 (6.667%) Information Management
7 2 (6.667%) Project Management
8 1 (3.333%) Process Management
Programming Languages
1 19 (63.33%) SQL
2 11 (36.67%) T-SQL
3 8 (26.67%) C#
4 6 (20.00%) PL/SQL
4 6 (20.00%) Shell Script
Qualifications
1 8 (26.67%) Microsoft Certification
2 5 (16.67%) Degree
3 4 (13.33%) MCP
Quality Assurance & Compliance
1 3 (10.00%) Data Quality
2 1 (3.333%) QA
Vendors
1 16 (53.33%) Microsoft
2 8 (26.67%) Oracle
3 5 (16.67%) Informatica
4 4 (13.33%) Business Objects
5 3 (10.00%) Sage
5 3 (10.00%) SAP
5 3 (10.00%) Sybase
5 3 (10.00%) DataFlux