The first table below looks at the demand for DTS 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 DTS over the 3 months to 20 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
20 May 2013
Same period 2012 Same period 2011
Microsoft Data Transformation Services (DTS)
Rank 284 264 227
Rank change year-on-year
-20 -37
Permanent jobs citing DTS 33 59 95
As % of all permanent IT jobs located in the City of London 0.284% 0.449% 0.630%
As % of the Database & Business Intelligence category 1.102% 1.703% 2.557%
Number of salaries quoted 26 55 80
Average salary £52,500 £47,000 £45,000
Average salary % change year-on-year
+11.70% +4.44%
90% offered a salary of more than £42,500 £33,500 £35,000
10% offered a salary of more than £64,500 £60,000 £55,250
UK excluding London average salary £40,000 £35,000 £40,000
% change year-on-year
+14.28% -12.50%
All Database & Business Intelligence
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
2995 3464 3716
As % of all permanent IT jobs located in the City of London 25.74% 26.39% 24.63%
Number of salaries quoted 2636 3205 3365
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% -
DTS
London

DTS
Jobs Demand Trend

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

City of London DTS Jobs Demand Trend

DTS
Salary Trend

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

City of London DTS Salary Trend

DTS
Salary Histogram

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

City of London DTS Salary Histogram

DTS
Top 30 Related IT Skills

For the 6 months to 20 May 2013, IT jobs across the City of London region citing DTS 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 DTS.

1 51 (100.00%) SQL
2 49 (96.08%) SQL Server
3 41 (80.39%) SQL Server Integration Services
4 40 (78.43%) T-SQL
5 33 (64.71%) SQL Server 2008
6 23 (45.10%) SQL Server 2005
7 19 (37.25%) MS Excel
8 17 (33.33%) Microsoft
8 17 (33.33%) SQL Server Reporting Services
9 15 (29.41%) E-Commerce
10 14 (27.45%) Degree
11 12 (23.53%) Finance
12 11 (21.57%) Windows
13 9 (17.65%) SQL Server 2012
14 8 (15.69%) ETL
14 8 (15.69%) VB
14 8 (15.69%) OLTP
15 7 (13.73%) Citrix
15 7 (13.73%) Tivoli
15 7 (13.73%) Tivoli Workload Scheduler
15 7 (13.73%) Shell Script
15 7 (13.73%) Sybase
15 7 (13.73%) UNIX
15 7 (13.73%) HPUX
15 7 (13.73%) Asset Management
15 7 (13.73%) SQL Server Analysis Services
16 6 (11.76%) SharePoint
16 6 (11.76%) Data Warehouse
16 6 (11.76%) MS Office
17 5 (9.804%) SQL Server 2000

DTS
Top Related IT Skills by Category

For the 6 months to 20 May 2013, IT jobs across the City of London region citing DTS 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 DTS. Up to 20 skills are shown per category.

Application Development
1 5 (9.804%) .NET
2 3 (5.882%) XML
3 1 (1.961%) ODBC
3 1 (1.961%) Ajax
3 1 (1.961%) jQuery
3 1 (1.961%) HTML5
3 1 (1.961%) ADO
3 1 (1.961%) ASP
3 1 (1.961%) ASP.NET
3 1 (1.961%) CSS
3 1 (1.961%) HTML
Application Platforms
1 6 (11.76%) SharePoint
2 1 (1.961%) BizTalk Server
2 1 (1.961%) LiveLink
2 1 (1.961%) WorkSite
2 1 (1.961%) IIS
Applications
1 19 (37.25%) MS Excel
2 6 (11.76%) MS Office
3 1 (1.961%) Photoshop
Communications & Networking
1 1 (1.961%) Intranet
1 1 (1.961%) Internet
Database & Business Intelligence
1 49 (96.08%) SQL Server
2 41 (80.39%) SQL Server Integration Services
3 33 (64.71%) SQL Server 2008
4 23 (45.10%) SQL Server 2005
5 17 (33.33%) SQL Server Reporting Services
6 9 (17.65%) SQL Server 2012
7 8 (15.69%) OLTP
8 7 (13.73%) SQL Server Analysis Services
9 6 (11.76%) Data Warehouse
10 5 (9.804%) SQL Server 2000
11 3 (5.882%) MySQL
12 2 (3.922%) Data Mining
12 2 (3.922%) RDBMS
13 1 (1.961%) OLAP
13 1 (1.961%) Crystal Reports
13 1 (1.961%) MS Access
13 1 (1.961%) IDOL
13 1 (1.961%) Microsoft Analysis Services
Development Applications
1 1 (1.961%) Visual Studio
1 1 (1.961%) Dreamweaver
General
1 12 (23.53%) Finance
2 4 (7.843%) Legal
3 3 (5.882%) Back Office
4 2 (3.922%) Financial Institution
4 2 (3.922%) Retail
5 1 (1.961%) Telecoms
5 1 (1.961%) Manufacturing
5 1 (1.961%) Advertising
Job Titles
1 25 (49.02%) Developer
2 21 (41.18%) SQL Developer
3 19 (37.25%) DBA
4 14 (27.45%) SQL DBA
5 12 (23.53%) Administrator
6 11 (21.57%) Database Developer
7 8 (15.69%) SQL Server Developer
8 7 (13.73%) SQL Database Developer
8 7 (13.73%) Microsoft Developer
8 7 (13.73%) Teradata DBA
8 7 (13.73%) Applications Support
9 6 (11.76%) Analyst
10 5 (9.804%) Lead Developer
10 5 (9.804%) SQL Server DBA
10 5 (9.804%) Applications Support Analyst
10 5 (9.804%) Support Analyst
11 4 (7.843%) Senior Analyst
11 4 (7.843%) Senior Developer
12 3 (5.882%) Senior Support Analyst
12 3 (5.882%) Senior Applications Support Analyst
Miscellaneous
1 5 (9.804%) Replication
2 2 (3.922%) Fixed Income
2 2 (3.922%) Clustering
3 1 (1.961%) Equities
3 1 (1.961%) Derivative
3 1 (1.961%) Statistics
3 1 (1.961%) Data Extraction
3 1 (1.961%) SaaS
3 1 (1.961%) Client/Server
Operating Systems
1 11 (21.57%) Windows
2 7 (13.73%) HPUX
2 7 (13.73%) UNIX
3 1 (1.961%) Windows Server 2008
3 1 (1.961%) Windows 2000 Server
Processes & Methodologies
1 15 (29.41%) E-Commerce
2 8 (15.69%) ETL
3 7 (13.73%) Asset Management
4 5 (9.804%) Investment Management
4 5 (9.804%) Database Security
5 4 (7.843%) Data Transformation
5 4 (7.843%) Fund Accounting
5 4 (7.843%) Business Intelligence
6 3 (5.882%) ITIL
6 3 (5.882%) CRM
6 3 (5.882%) Service Delivery
6 3 (5.882%) Change Management
6 3 (5.882%) Disaster Recovery
6 3 (5.882%) Migration
6 3 (5.882%) Capacity Planning
6 3 (5.882%) Data Migration
6 3 (5.882%) Problem Management
6 3 (5.882%) User Acceptance Testing
6 3 (5.882%) Continuous Improvement
7 2 (3.922%) High Availability
Programming Languages
1 51 (100.00%) SQL
2 40 (78.43%) T-SQL
3 8 (15.69%) VB
4 7 (13.73%) Shell Script
5 2 (3.922%) VBScript
5 2 (3.922%) JavaScript
5 2 (3.922%) PowerShell
6 1 (1.961%) C#
6 1 (1.961%) XPath
6 1 (1.961%) VB.NET
Qualifications
1 14 (27.45%) Degree
2 3 (5.882%) MCDBA
2 3 (5.882%) Microsoft Certification
3 2 (3.922%) MCTS
System Software
1 7 (13.73%) Tivoli Workload Scheduler
2 3 (5.882%) Active Directory
Systems Management
1 7 (13.73%) Tivoli
Vendors
1 17 (33.33%) Microsoft
2 7 (13.73%) Sybase
2 7 (13.73%) Citrix
3 3 (5.882%) Salesforce.com
3 3 (5.882%) StatPro
3 3 (5.882%) Sun
4 1 (1.961%) HP
4 1 (1.961%) Open Text
4 1 (1.961%) Cadis
4 1 (1.961%) Business Objects
4 1 (1.961%) Adobe
City, London
You will need database development skills, and an in-depth understanding of MSSQL 2005/2008, DTS, T-SQL, SSIS and the confidence to be able to design and...
Mortimer Spinks
Salary: £30000 - £40000 per annum + Excellent Benefits
Posted: 14 May 2013
City of London
A major UK commercial law firm require an experienced SQL Server DBA to join their IT Operations team based in the City of London.Experience Required:-*Proven SQL...
Hudson IT London
Salary: £50000 - £55000 per annum + excellent package
Posted: 9 May 2013