The table below looks at the statistics 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 31 July 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
31 Jul 2015
Same period 2014 Same period 2013
Star Schema
Rank 300 323 323
Rank change year-on-year
+23 0
Permanent jobs citing Star Schema 8 11 6
As % of all permanent IT jobs located in the City of London 0.077% 0.089% 0.050%
As % of the Database & Business Intelligence category 0.27% 0.30% 0.18%
Number of salaries quoted 7 9 6
Average salary £85,000 £70,000 £50,000
Average salary % change year-on-year
+21.42% +40.00%
UK excluding London average salary £42,500 £47,500 £41,000
% change year-on-year
-10.52% +15.85%
Star Schema
London

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

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
2915 3685 3255
As % of all permanent IT jobs located in the City of London 27.98% 29.76% 27.17%
Number of salaries quoted 2501 3171 2898
Average salary £57,500 £55,000 £55,000
Average salary % change year-on-year
+4.54% -
90% offered a salary of more than £40,000 £37,500 £35,000
10% offered a salary of more than £80,000 £72,500 £80,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 in the City of London

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.

Star Schema Jobs Demand Trend in the City of London

Star Schema
Salary Trend in the City of London

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

Star Schema Salary Trend in the City of London

Star Schema
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing Star Schema across the City of London region over the 3 months to 31 July 2015.

Star Schema Salary Histogram in the City of London

Star Schema
Top 30 Related IT Skills in the City of London

For the 6 months to 31 July 2015, 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 11 (91.67%) Data Warehouse
2 9 (75.00%) SQL
3 8 (66.67%) Data Structures
4 7 (58.33%) T-SQL
4 7 (58.33%) MS Excel
4 7 (58.33%) Data Modelling
4 7 (58.33%) Microsoft
4 7 (58.33%) Data Analysis
5 6 (50.00%) Systems Analysis
5 6 (50.00%) Management Information System
5 6 (50.00%) Advertising
5 6 (50.00%) Project Management
5 6 (50.00%) MS Visio
5 6 (50.00%) MS Office
5 6 (50.00%) User Acceptance Testing
5 6 (50.00%) Asset Management
5 6 (50.00%) Investment Management
5 6 (50.00%) Portfolio Management
6 4 (33.33%) SQL Server Reporting Services
6 4 (33.33%) SQL Server
6 4 (33.33%) ETL
7 3 (25.00%) Business Intelligence
7 3 (25.00%) Agile Software Development
7 3 (25.00%) Marketing
7 3 (25.00%) SQL Server Analysis Services
8 2 (16.67%) SQL Server Integration Services
8 2 (16.67%) Enterprise Architecture
8 2 (16.67%) LINQ
8 2 (16.67%) Team Foundation Server
8 2 (16.67%) Analytics

Star Schema
Top Related IT Skills in the City of London by Category

For the 6 months to 31 July 2015, 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 Platforms
1 1 (8.33%) BizTalk Server
Applications
1 7 (58.33%) MS Excel
2 6 (50.00%) MS Visio
2 6 (50.00%) MS Office
Business Applications
1 1 (8.33%) SAP Oil and Gas
1 1 (8.33%) Dynamics CRM
Communications & Networking
1 1 (8.33%) SMTP
1 1 (8.33%) Firewall
Database & Business Intelligence
1 11 (91.67%) Data Warehouse
2 4 (33.33%) SQL Server
2 4 (33.33%) SQL Server Reporting Services
3 3 (25.00%) SQL Server Analysis Services
4 2 (16.67%) SQL Server Integration Services
4 2 (16.67%) Relational Database
5 1 (8.33%) NoSQL
5 1 (8.33%) Big Data
5 1 (8.33%) Data Mart
5 1 (8.33%) OLAP
5 1 (8.33%) Snowflake Schema
5 1 (8.33%) BusinessObjects
Development Applications
1 2 (16.67%) Team Foundation Server
2 1 (8.33%) SoapUI
2 1 (8.33%) HP UFT
2 1 (8.33%) JIRA
2 1 (8.33%) FitNesse
2 1 (8.33%) Visual Studio Team System
2 1 (8.33%) TeamCity
General
1 6 (50.00%) Advertising
2 3 (25.00%) Marketing
3 2 (16.67%) Telecoms
3 2 (16.67%) Finance
4 1 (8.33%) Manufacturing
4 1 (8.33%) Banking
4 1 (8.33%) Electronics
Job Titles
1 7 (58.33%) Analyst
2 6 (50.00%) Data Analyst
3 3 (25.00%) Architect
4 2 (16.67%) Data Architect
5 1 (8.33%) Solutions Architect
5 1 (8.33%) Senior Developer
5 1 (8.33%) Consultant
5 1 (8.33%) Business Analyst
5 1 (8.33%) Management Consultant
5 1 (8.33%) Developer
5 1 (8.33%) Test Engineer
5 1 (8.33%) Team Leader
5 1 (8.33%) Enterprise Architect
5 1 (8.33%) Senior Test Engineer
5 1 (8.33%) Data Warehouse Architect
5 1 (8.33%) Business Intelligence Developer
5 1 (8.33%) Data Consultant
5 1 (8.33%) ETL Architect
5 1 (8.33%) Enterprise Solutions Architect
5 1 (8.33%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 2 (16.67%) .NET
1 2 (16.67%) ASP.NET
1 2 (16.67%) XML
1 2 (16.67%) LINQ
2 1 (8.33%) ASP.NET 2.0
2 1 (8.33%) RESTful
2 1 (8.33%) HTML
2 1 (8.33%) XSLT
2 1 (8.33%) XML Schema
2 1 (8.33%) Ajax
2 1 (8.33%) .NET Framework
2 1 (8.33%) JSON
2 1 (8.33%) WCF
2 1 (8.33%) SOAP
2 1 (8.33%) Web Services
Miscellaneous
1 8 (66.67%) Data Structures
2 6 (50.00%) Management Information System
3 1 (8.33%) Economics
3 1 (8.33%) Mathematics
3 1 (8.33%) Computer Science
3 1 (8.33%) Enterprise Software
3 1 (8.33%) Analytical Skills
3 1 (8.33%) Data Centre
3 1 (8.33%) DTV
Processes & Methodologies
1 7 (58.33%) Data Modelling
1 7 (58.33%) Data Analysis
2 6 (50.00%) Systems Analysis
2 6 (50.00%) Project Management
2 6 (50.00%) Asset Management
2 6 (50.00%) User Acceptance Testing
2 6 (50.00%) Investment Management
2 6 (50.00%) Portfolio Management
3 4 (33.33%) ETL
4 3 (25.00%) Business Intelligence
4 3 (25.00%) Agile Software Development
5 2 (16.67%) Analytics
5 2 (16.67%) Data Mapping
5 2 (16.67%) Enterprise Architecture
6 1 (8.33%) Enterprise Data Management
6 1 (8.33%) Wealth Management
6 1 (8.33%) Quantitative Analysis
6 1 (8.33%) Release Management
6 1 (8.33%) Digital Marketing
6 1 (8.33%) Migration
Programming Languages
1 9 (75.00%) SQL
2 7 (58.33%) T-SQL
3 2 (16.67%) C#
4 1 (8.33%) JavaScript
Qualifications
1 1 (8.33%) ISEB
1 1 (8.33%) ISTQB
1 1 (8.33%) Degree
Quality Assurance & Compliance
1 1 (8.33%) Data Quality
Vendors
1 7 (58.33%) Microsoft
2 1 (8.33%) Netezza
2 1 (8.33%) Tableau
2 1 (8.33%) SAP
City, London
Eutopia Solutions Ltd
Salary: £60000.00 - £75000.00 per annum + package & bonus
Posted: 4 days ago