The table below looks at the statistics for DTS skills in IT jobs advertised across the UK. Included is a guide to the average salaries offered in IT jobs that have cited DTS over the 3 months to 16 September 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
16 Sep 2014
Same period 2013 Same period 2012
Microsoft Data Transformation Services (DTS)
Rank 699 575 560
Rank change year-on-year
-124 -15
Permanent jobs citing DTS 190 315 369
As % of all permanent IT jobs located in the UK 0.17% 0.30% 0.31%
As % of the Database & Business Intelligence category 0.55% 0.94% 1.01%
Number of salaries quoted 163 276 310
Average salary £40,500 £42,500 £40,000
Average salary % change year-on-year
-4.70% +6.25%
90% offered a salary of more than £30,000 £30,000 £31,250
10% offered a salary of more than £59,500 £60,000 £54,250
UK excluding London average salary £37,250 £38,500 £38,500
% change year-on-year
-3.24% -

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
34795 33610 36584
As % of all permanent IT jobs located in the UK 30.50% 31.61% 31.04%
Number of salaries quoted 29255 29039 32206
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £67,500 £65,000 £65,000
UK excluding London average salary £40,000 £40,000 £40,000

DTS
Jobs Demand Trend

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

DTS Jobs Demand Trend in the UK

DTS
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing DTS within the UK.

DTS Salary Trend in the UK

DTS
Salary Histogram

This chart provides a salary histogram for IT jobs citing DTS over the 3 months to 16 September 2014 within the UK.

DTS Salary Histogram in the UK

DTS
Top 30 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing DTS within the UK over the 3 months to 16 September 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
England -105 181 £41,000 -3.52% 19
London -36 78 £41,500 -24.54% 3
City of London -15 32 £42,500 -22.37% 1
North West -5 26 £32,500 -13.33% 5
South East -53 18 £43,750 -12.50% 1
Yorkshire -34 15 £41,500 +7.79% 4
East Midlands -41 15 £35,000 - 1
East of England -38 14 £41,250 -2.94% 4
Manchester -11 13 £38,500 - 1
Cheshire -5 12 £32,500 +18.18% 2
Devon -12 11 £45,000 +12.50%
South West -28 11 £45,000 +12.50%
Crewe +6 10 £32,500 +18.18% 1
West Yorkshire -26 10 £32,500 -13.33% 3
Kent +9 8 £39,250 -21.50%
Scotland -15 8 £39,750 -1.85%
Nottinghamshire +9 7 £35,000 -22.22%
Nottingham +1 7 £35,000 -22.22%
Glasgow -12 7 £39,125 -5.72%
Hertfordshire -24 7 £27,500 -38.88% 1
Essex - 7 £42,500 - 3
Southend-on-Sea - 6 £42,500 - 3
Exeter -6 5 £35,000 -12.50%
Northamptonshire -59 5 £30,000 -14.28% 1
Chatham +5 4 £47,250 -5.50%
Bradford -8 4 £32,500 -13.33% 2
Surrey -14 4 £45,000 +7.14%
West Midlands -17 4 £32,500 -23.52%
Northampton -34 4 £30,500 -12.85% 1
Folkestone - 4 £33,500 -

DTS
Top 30 Related IT Skills

For the 6 months to 16 September 2014, IT jobs within the UK 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 490 (90.41%) SQL
2 457 (84.32%) SQL Server Integration Services
3 430 (79.34%) SQL Server
4 315 (58.12%) T-SQL
5 300 (55.35%) SQL Server Reporting Services
6 234 (43.17%) SQL Server 2008
7 193 (35.61%) SQL Server 2005
8 184 (33.95%) .NET
9 178 (32.84%) Microsoft
10 177 (32.66%) ETL
11 158 (29.15%) SQL Server Analysis Services
12 144 (26.57%) Performance Tuning
13 140 (25.83%) Windows
14 137 (25.28%) MS Excel
15 134 (24.72%) C#
16 117 (21.59%) Business Intelligence
17 112 (20.66%) SQL Server 2000
18 111 (20.48%) XML
18 111 (20.48%) Finance
19 96 (17.71%) Replication
19 96 (17.71%) Analytical Skills
20 85 (15.68%) ASP.NET
21 75 (13.84%) Data Warehouse
22 69 (12.73%) Oracle
23 68 (12.55%) OLAP
24 64 (11.81%) SharePoint
25 62 (11.44%) Marketing
26 60 (11.07%) VB.NET
27 58 (10.70%) Migration
28 57 (10.52%) Agile Software Development

DTS
Top Related IT Skills by Category

For the 6 months to 16 September 2014, IT jobs within the UK 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 Platforms
1 64 (11.81%) SharePoint
2 33 (6.09%) IIS
3 10 (1.85%) Oracle Application Server
3 10 (1.85%) Lync
4 9 (1.66%) Apache
4 9 (1.66%) Oracle 10gAS
5 5 (0.92%) MS Exchange
5 5 (0.92%) SharePoint 2010
5 5 (0.92%) Exchange Server 2010
5 5 (0.92%) Exchange Server 2013
5 5 (0.92%) SharePoint 2013
6 4 (0.74%) BizTalk Server
7 3 (0.55%) Oracle Workflow
7 3 (0.55%) WebSphere
7 3 (0.55%) Oracle Service Bus
7 3 (0.55%) Oracle SOA Suite
8 2 (0.37%) SharePoint Server
8 2 (0.37%) SAS
9 1 (0.18%) Documentum
9 1 (0.18%) OpenROAD
Applications
1 137 (25.28%) MS Excel
2 44 (8.12%) MS Office
3 2 (0.37%) MS PowerPoint
Business Applications
1 9 (1.66%) Dynamics AX
2 5 (0.92%) SAP Oil and Gas
3 4 (0.74%) Dynamics CRM
3 4 (0.74%) RMDS
4 3 (0.55%) Dynamics NAV
4 3 (0.55%) Oracle BPM
5 1 (0.18%) Oracle ERP
5 1 (0.18%) Sage 1000
5 1 (0.18%) Markit EDM
Cloud Services
1 15 (2.77%) SaaS
Communications & Networking
1 20 (3.69%) Intranet
2 18 (3.32%) SAN
3 6 (1.11%) Wireless
4 4 (0.74%) CTI
4 4 (0.74%) FTP
4 4 (0.74%) DNS
5 2 (0.37%) HTTPS
5 2 (0.37%) LDAP
6 1 (0.18%) HTTP
6 1 (0.18%) Internet
6 1 (0.18%) NAS
Database & Business Intelligence
1 457 (84.32%) SQL Server Integration Services
2 430 (79.34%) SQL Server
3 300 (55.35%) SQL Server Reporting Services
4 234 (43.17%) SQL Server 2008
5 193 (35.61%) SQL Server 2005
6 158 (29.15%) SQL Server Analysis Services
7 112 (20.66%) SQL Server 2000
8 75 (13.84%) Data Warehouse
9 68 (12.55%) OLAP
10 55 (10.15%) Relational Database
10 55 (10.15%) SQL Server 2012
11 40 (7.38%) Microsoft Analysis Services
12 36 (6.64%) RDBMS
13 35 (6.46%) Crystal Reports
14 30 (5.54%) Oracle OLAP
15 29 (5.35%) MS Access
16 25 (4.61%) Oracle Database
17 21 (3.87%) OLTP
18 18 (3.32%) BusinessObjects Web Intelligence
19 17 (3.14%) Oracle Reports
Development Applications
1 42 (7.75%) Visual Studio
2 35 (6.46%) SQL Server Management Studio (SSMS)
3 25 (4.61%) Team Foundation Server
4 11 (2.03%) Jenkins
4 11 (2.03%) TeamCity
5 9 (1.66%) PVCS
5 9 (1.66%) Oracle Forms
5 9 (1.66%) Visual Studio Team System
5 9 (1.66%) MorphX
6 3 (0.55%) VSS/SourceSafe
6 3 (0.55%) Talend Open Studio
7 2 (0.37%) Eclipse
7 2 (0.37%) Subversion
8 1 (0.18%) Toad
General
1 111 (20.48%) Finance
2 62 (11.44%) Marketing
3 20 (3.69%) Retail
4 19 (3.51%) Banking
5 16 (2.95%) Investment Banking
5 16 (2.95%) Telecoms
6 10 (1.85%) Legal
7 9 (1.66%) Financial Institution
8 8 (1.48%) Billing
8 8 (1.48%) Advertising
8 8 (1.48%) Automotive
9 6 (1.11%) Law
10 5 (0.92%) Electronics
10 5 (0.92%) Manufacturing
11 1 (0.18%) Multimedia
11 1 (0.18%) Local Government
11 1 (0.18%) German Language
Job Titles
1 241 (44.46%) Developer
2 198 (36.53%) DBA
3 182 (33.58%) SQL DBA
4 106 (19.56%) SQL Developer
5 94 (17.34%) Administrator
6 80 (14.76%) Analyst
7 75 (13.84%) SQL Server DBA
8 56 (10.33%) .NET Developer
9 35 (6.46%) SQL Server Developer
10 32 (5.90%) Server Administrator
11 28 (5.17%) Senior Developer
12 22 (4.06%) Business Intelligence Developer
12 22 (4.06%) C# Developer
13 19 (3.51%) Senior DBA
14 17 (3.14%) Business Intelligence Analyst
15 16 (2.95%) Senior SQL DBA
15 16 (2.95%) C# .NET Developer
15 16 (2.95%) Database Developer
16 15 (2.77%) Business Analyst
16 15 (2.77%) Microsoft Developer
Libraries, Frameworks & Software Standards
1 184 (33.95%) .NET
2 111 (20.48%) XML
3 85 (15.68%) ASP.NET
4 52 (9.59%) Web Services
5 50 (9.23%) HTML
6 37 (6.83%) CSS
7 34 (6.27%) jQuery
8 32 (5.90%) .NET Framework
9 24 (4.43%) WinForms
10 23 (4.24%) Ajax
11 20 (3.69%) MDX
12 18 (3.32%) ADO.NET Entity Framework
12 18 (3.32%) SOAP
12 18 (3.32%) Middleware
13 17 (3.14%) HTML5
14 13 (2.40%) WPF
15 11 (2.03%) JRules
15 11 (2.03%) WCF
15 11 (2.03%) JSON
16 10 (1.85%) CSS3
Miscellaneous
1 96 (17.71%) Replication
1 96 (17.71%) Analytical Skills
2 45 (8.30%) Clustering
3 21 (3.87%) Data Integration
4 20 (3.69%) Data Extraction
5 19 (3.51%) Computer Science
6 17 (3.14%) Enterprise Software
7 16 (2.95%) Credit Risk
8 9 (1.66%) GIS
9 6 (1.11%) Mathematics
9 6 (1.11%) Open Source
9 6 (1.11%) Management Information System
10 5 (0.92%) DTV
10 5 (0.92%) Physics
11 4 (0.74%) Data Protection Act
11 4 (0.74%) Derivative
12 3 (0.55%) Foreign Exchange (FX)
13 2 (0.37%) Client/Server
14 1 (0.18%) Equities
14 1 (0.18%) e-Health
Operating Systems
1 140 (25.83%) Windows
2 36 (6.64%) Windows Server 2008
3 25 (4.61%) Windows Server 2003
4 15 (2.77%) Windows 2000 Server
5 13 (2.40%) Linux
5 13 (2.40%) Windows Server 2012
6 8 (1.48%) UNIX
7 5 (0.92%) Windows 2000
8 1 (0.18%) Windows NT
8 1 (0.18%) Windows CE
8 1 (0.18%) Android
Processes & Methodologies
1 177 (32.66%) ETL
2 144 (26.57%) Performance Tuning
3 117 (21.59%) Business Intelligence
4 58 (10.70%) Migration
5 57 (10.52%) Agile Software Development
6 54 (9.96%) OO
7 50 (9.23%) Disaster Recovery
8 44 (8.12%) Data Modelling
9 40 (7.38%) ERP
10 38 (7.01%) OOP
11 37 (6.83%) Mentoring
12 36 (6.64%) MVC
13 34 (6.27%) Database Security
13 34 (6.27%) ITIL
14 32 (5.90%) Data Analysis
15 27 (4.98%) Change Management
16 25 (4.61%) Performance Monitoring
17 24 (4.43%) Project Management
17 24 (4.43%) E-Commerce
18 23 (4.24%) Waterfall
Programming Languages
1 490 (90.41%) SQL
2 315 (58.12%) T-SQL
3 134 (24.72%) C#
4 60 (11.07%) VB.NET
5 51 (9.41%) VB
6 38 (7.01%) JavaScript
7 34 (6.27%) Java
8 28 (5.17%) PL/SQL
8 28 (5.17%) VBA
9 21 (3.87%) VBScript
10 18 (3.32%) VB6
11 14 (2.58%) PowerShell
12 10 (1.85%) C++
13 9 (1.66%) PHP
13 9 (1.66%) Data Analysis Expressions (DAX)
13 9 (1.66%) X++
14 8 (1.48%) Shell Script
15 5 (0.92%) C
16 4 (0.74%) R
17 2 (0.37%) Bash Shell
Qualifications
1 51 (9.41%) Degree
2 40 (7.38%) Microsoft Certification
3 17 (3.14%) Security Cleared
4 15 (2.77%) SC Cleared
5 8 (1.48%) MCITP
5 8 (1.48%) MCTS
6 7 (1.29%) MCSE
6 7 (1.29%) ITIL Certification
7 6 (1.11%) DV Cleared
8 5 (0.92%) VMware Certified Professional (VCP)
9 3 (0.55%) MCDBA
10 2 (0.37%) PhD
11 1 (0.18%) MCP
Quality Assurance & Compliance
1 10 (1.85%) SLA
2 6 (1.11%) QA
3 5 (0.92%) ISO 9001
4 1 (0.18%) PCI DSS
System Software
1 10 (1.85%) Active Directory
2 5 (0.92%) VMware ESX
2 5 (0.92%) vSphere
2 5 (0.92%) XenApp
2 5 (0.92%) VMware ESXi
3 3 (0.55%) Oracle RAC
4 2 (0.37%) Oracle RMAN
5 1 (0.18%) VMware Infrastructure
Systems Management
1 11 (2.03%) Opscode Chef
1 11 (2.03%) Puppet
2 4 (0.74%) ITRS Geneos
3 2 (0.37%) Data Guard
4 1 (0.18%) Oracle Enterprise Manager
Vendors
1 178 (32.84%) Microsoft
2 69 (12.73%) Oracle
3 32 (5.90%) Red Gate
4 31 (5.72%) VMware
4 31 (5.72%) Business Objects
5 20 (3.69%) Sybase
6 11 (2.03%) JBoss
6 11 (2.03%) SAP
6 11 (2.03%) webMethods
7 9 (1.66%) Serena
8 8 (1.48%) Citrix
8 8 (1.48%) NetApp
9 6 (1.11%) Cognos
9 6 (1.11%) Siebel
9 6 (1.11%) Teradata
10 5 (0.92%) Salesforce.com
11 4 (0.74%) ServiceNow
11 4 (0.74%) TIBCO
11 4 (0.74%) CQG
11 4 (0.74%) Reuters
Macclesfield, Cheshire
Spring Technology
Salary: £20000.00 - £25000.00 per annum
Posted: 16 hours ago
Manchester, Lancashire
Adria Solutions Ltd
Salary: £35000 - £42000 per annum + Benefits
Posted: 16 hours ago
Liverpool, Merseyside
SYSTEM RECRUITMENT LTD
Salary: £35000 - £45000 per annum
Posted: 17 hours ago
Crewe, Cheshire
Assurant Solutions
Salary: Salary + Benefits
Posted: 3 days ago
Kingston Upon Hull
Progressive Recruitment
Salary: competitive
Posted: 3 days ago
Buckinghamshire
Experis Ltd
Salary: Up to £50k + pkg
Posted: 3 days ago
Northampton, Northamptonshire
X4 Group
Salary: £25k - 37k per year
Posted: 4 days ago
Hertfordshire
Venturi
Salary: £25000.00 - £30000.00 per annum + Benefits
Posted: 4 days ago
Liverpool, Merseyside
Greywood Associates Limited
Salary: £30000 - £40000 per annum + bens
Posted: 5 days ago
Wakefield
Progressive Recruitment
Salary: competitive
Posted: 5 days ago
Southend-On-Sea, Essex
Capita Resourcing - IT Resourcing
Salary: £35000 - £45000 per annum + Bonus + Benefits
Posted: 6 days ago
City of London
Reed Technology - UK Posting Account
Salary: £40000 - £45000 per annum
Posted: 6 days ago
Southend-On-Sea
Hays IT - Uk Posting account
Salary: £40000.00 - £45000.00 per annum
Posted: 12 days ago
Bradford
Progressive Recruitment
Salary: £38000 - £43000 per annum + competitive
Posted: 12 days ago
Bradford
Progressive Recruitment
Salary: £30000 - £35000 per annum + competitive
Posted: 20 days ago