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 22 May 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
22 May 2015
Same period 2014 Same period 2013
Microsoft Data Transformation Services (DTS)
Rank 726 600 580
Rank change year-on-year
-126 -20
Permanent jobs citing DTS 157 330 317
As % of all permanent IT jobs located in the UK 0.15% 0.28% 0.29%
As % of the Database & Business Intelligence category 0.47% 0.90% 0.92%
Number of salaries quoted 142 268 257
Average salary £40,000 £42,500 £42,500
Average salary % change year-on-year
-5.88% -
90% offered a salary of more than £25,000 £30,000 £28,500
10% offered a salary of more than £59,750 £61,250 £59,100
UK excluding London average salary £38,500 £40,500 £40,000
% change year-on-year
-4.93% +1.25%

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
33660 36837 34371
As % of all permanent IT jobs located in the UK 31.50% 31.37% 31.59%
Number of salaries quoted 28405 31649 29731
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £31,500 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £41,500 £40,000 £38,500
% change year-on-year
+3.75% +3.89%

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 22 May 2015 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 22 May 2015. 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 -124 141 £40,000 -5.88% 8
London -51 45 £50,000 +11.11% 3
West Midlands 0 24 £25,000 -34.21% 2
North West +6 21 £40,000 - 1
South East -33 20 £39,500 -1.25% 1
Warwickshire - 20 £23,750 -
Manchester +32 17 £40,000 -36.00% 1
East of England -17 14 £45,000 -
City of London +10 12 £54,000 +13.68% 1
Warwick - 11 £22,500 -
Hampshire +2 10 £38,250 -4.37%
Hertfordshire 0 10 £45,000 -
Cardiff - 10 £45,000 -
Wales - 10 £45,000 -
South Wales - 10 £45,000 -
Yorkshire -5 8 £31,472 -33.74%
West Yorkshire +13 6 £30,097 -36.63%
Scotland +14 5 £39,250 +36.52% 1
Glasgow +7 5 £39,250 +12.14% 1
Kent +5 5 £50,000 +11.11%
Southampton 0 4 £39,000 -2.50%
Cheshire -1 4 £38,500 -1.28%
East Midlands -1 4 £47,500 +40.74% 1
South West -14 4 £47,500 +13.09%
Nottinghamshire - 4 £47,500 -
Romford - 4 £52,500 -
Nottingham - 4 £47,500 -
Portsmouth - 4 £37,500 -
Knutsford - 4 £38,500 -
Borehamwood - 4 £37,500 -

DTS
Top 30 Related IT Skills

For the 6 months to 22 May 2015, 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 287 (92.88%) SQL
2 273 (88.35%) SQL Server
3 232 (75.08%) SQL Server Integration Services
4 220 (71.20%) T-SQL
5 158 (51.13%) SQL Server Reporting Services
6 152 (49.19%) SQL Server 2008
7 129 (41.75%) .NET
8 127 (41.10%) Microsoft
9 117 (37.86%) Data Warehouse
10 105 (33.98%) SQL Server 2005
11 99 (32.04%) C#
12 93 (30.10%) Business Intelligence
13 83 (26.86%) ETL
13 83 (26.86%) SQL Server 2012
14 78 (25.24%) Windows
15 72 (23.30%) SQL Server 2000
16 64 (20.71%) SQL Server Analysis Services
17 61 (19.74%) Performance Tuning
17 61 (19.74%) Replication
17 61 (19.74%) Finance
18 55 (17.80%) XML
18 55 (17.80%) ASP.NET
19 49 (15.86%) Migration
19 49 (15.86%) Clustering
19 49 (15.86%) Relational Database
20 47 (15.21%) Cognos
21 41 (13.27%) MS Excel
22 39 (12.62%) Data Transformation
23 38 (12.30%) VBScript
23 38 (12.30%) JavaScript

DTS
Top Related IT Skills by Category

For the 6 months to 22 May 2015, 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 31 (10.03%) SharePoint
2 16 (5.18%) IIS
3 9 (2.91%) BizTalk Server
4 8 (2.59%) CMS
5 4 (1.29%) SharePoint 2010
6 3 (0.97%) GlassFish
7 2 (0.65%) Umbraco
7 2 (0.65%) Sitefinity
8 1 (0.32%) SAS
8 1 (0.32%) SharePoint 2013
Applications
1 41 (13.27%) MS Excel
2 3 (0.97%) MS Office
3 1 (0.32%) MS Project
3 1 (0.32%) MS Visio
3 1 (0.32%) PowerPivot
Business Applications
1 7 (2.27%) Dynamics AX
2 5 (1.62%) Dynamics CRM
3 3 (0.97%) Dynamics NAV
4 2 (0.65%) Cognos Business Intelligence
Cloud Services
1 2 (0.65%) Microsoft Azure
1 2 (0.65%) SaaS
Communications & Networking
1 7 (2.27%) SAN
2 6 (1.94%) Internet
3 5 (1.62%) Intranet
4 3 (0.97%) Extranet
5 2 (0.65%) Firewall
6 1 (0.32%) DAB
6 1 (0.32%) FTP
6 1 (0.32%) NAS
Database & Business Intelligence
1 273 (88.35%) SQL Server
2 232 (75.08%) SQL Server Integration Services
3 158 (51.13%) SQL Server Reporting Services
4 152 (49.19%) SQL Server 2008
5 117 (37.86%) Data Warehouse
6 105 (33.98%) SQL Server 2005
7 83 (26.86%) SQL Server 2012
8 72 (23.30%) SQL Server 2000
9 64 (20.71%) SQL Server Analysis Services
10 49 (15.86%) Relational Database
11 22 (7.12%) Microsoft Analysis Services
11 22 (7.12%) OLTP
12 20 (6.47%) RDBMS
13 13 (4.21%) Crystal Reports
14 12 (3.88%) OLAP
15 11 (3.56%) Cognos Analysis Studio
15 11 (3.56%) Cognos Report Studio
15 11 (3.56%) Cognos Framework Manager
16 8 (2.59%) MySQL
17 7 (2.27%) MS Access
Development Applications
1 32 (10.36%) Visual Studio
2 28 (9.06%) Team Foundation Server
3 12 (3.88%) VSS/SourceSafe
4 10 (3.24%) SQL Server Management Studio (SSMS)
5 3 (0.97%) CruiseControl
5 3 (0.97%) ClearCase
5 3 (0.97%) ClearQuest
5 3 (0.97%) Eclipse
6 2 (0.65%) ERwin
7 1 (0.32%) MSI
7 1 (0.32%) InstallShield
General
1 61 (19.74%) Finance
2 31 (10.03%) Marketing
3 6 (1.94%) Banking
3 6 (1.94%) Financial Institution
3 6 (1.94%) Legal
4 3 (0.97%) Manufacturing
4 3 (0.97%) Advertising
5 2 (0.65%) Law
6 1 (0.32%) Telecoms
6 1 (0.32%) Pharmaceutical
Job Titles
1 126 (40.78%) DBA
2 120 (38.83%) SQL DBA
3 118 (38.19%) Developer
4 69 (22.33%) Administrator
5 65 (21.04%) SQL Developer
6 47 (15.21%) SQL Server DBA
7 40 (12.94%) Analyst
8 31 (10.03%) Applications Support
9 27 (8.74%) Consultant
10 24 (7.77%) Database Developer
11 23 (7.44%) Support Consultant
12 22 (7.12%) Applications Support Consultant
12 22 (7.12%) Applications Consultant
13 21 (6.80%) SQL Database Developer
14 18 (5.83%) Server Administrator
15 15 (4.85%) AWS Developer
16 14 (4.53%) Data Analyst
17 12 (3.88%) .NET Developer
17 12 (3.88%) Database Analyst
18 10 (3.24%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 129 (41.75%) .NET
2 55 (17.80%) XML
2 55 (17.80%) ASP.NET
3 27 (8.74%) HTML
4 23 (7.44%) .NET Framework
5 21 (6.80%) CSS
6 19 (6.15%) Web Services
6 19 (6.15%) jQuery
7 11 (3.56%) SOAP
7 11 (3.56%) Entity Framework
7 11 (3.56%) REST
7 11 (3.56%) ASP.NET MVC
8 10 (3.24%) LINQ
8 10 (3.24%) Ajax
9 9 (2.91%) ASP.NET Web API
10 8 (2.59%) WCF
10 8 (2.59%) CSS3
11 6 (1.94%) ASP.NET Web Forms
11 6 (1.94%) XSL
11 6 (1.94%) Microsoft Enterprise Library
Miscellaneous
1 61 (19.74%) Replication
2 49 (15.86%) Clustering
3 35 (11.33%) Analytical Skills
4 16 (5.18%) Digital Media
4 16 (5.18%) Statistics
5 10 (3.24%) Management Information System
6 9 (2.91%) Visualisation
7 8 (2.59%) Data Extraction
7 8 (2.59%) User Experience
8 7 (2.27%) Data Structures
9 5 (1.62%) Client/Server
10 4 (1.29%) Mobile App
10 4 (1.29%) NHS
11 3 (0.97%) N-Tier
11 3 (0.97%) Enterprise Software
12 2 (0.65%) Computer Science
12 2 (0.65%) Smartphone
12 2 (0.65%) AS400
13 1 (0.32%) CLARiiON
13 1 (0.32%) Symmetrix
Operating Systems
1 78 (25.24%) Windows
2 23 (7.44%) Windows Server 2008
3 18 (5.83%) Windows Server 2012
4 13 (4.21%) UNIX
4 13 (4.21%) Windows Server 2003
5 1 (0.32%) Windows 2000
Processes & Methodologies
1 93 (30.10%) Business Intelligence
2 83 (26.86%) ETL
3 61 (19.74%) Performance Tuning
4 49 (15.86%) Migration
5 39 (12.62%) Data Transformation
6 37 (11.97%) Data Management
7 33 (10.68%) Disaster Recovery
8 30 (9.71%) Web Development
9 29 (9.39%) Data Migration
10 28 (9.06%) Time Management
11 27 (8.74%) Database Mirroring
11 27 (8.74%) Kimball Methodology
12 26 (8.41%) Project Management
13 25 (8.09%) Database Security
13 25 (8.09%) Capacity Planning
14 23 (7.44%) MVC
15 22 (7.12%) Performance Monitoring
15 22 (7.12%) Continuous Improvement
15 22 (7.12%) Change Management
16 21 (6.80%) Data Analysis
Programming Languages
1 287 (92.88%) SQL
2 220 (71.20%) T-SQL
3 99 (32.04%) C#
4 38 (12.30%) VBScript
4 38 (12.30%) JavaScript
5 25 (8.09%) VB
6 18 (5.83%) PowerShell
7 16 (5.18%) VB.NET
8 8 (2.59%) VBA
9 7 (2.27%) Java
10 3 (0.97%) VB6
10 3 (0.97%) C
11 2 (0.65%) Apple Swift
11 2 (0.65%) PHP
11 2 (0.65%) PL/SQL
11 2 (0.65%) XPath
11 2 (0.65%) MapBasic
11 2 (0.65%) Objective-C
12 1 (0.32%) C++
Qualifications
1 33 (10.68%) Degree
2 9 (2.91%) Microsoft Certification
3 5 (1.62%) Security Cleared
4 4 (1.29%) Microsoft Certified Architect
4 4 (1.29%) MCDBA
4 4 (1.29%) MCTS
4 4 (1.29%) MCITP
5 3 (0.97%) ISEB
5 3 (0.97%) SC Cleared
6 2 (0.65%) PMI Certification
6 2 (0.65%) MCP
7 1 (0.32%) HND
7 1 (0.32%) MCSE
7 1 (0.32%) PMP
Quality Assurance & Compliance
1 33 (10.68%) SLA
2 27 (8.74%) QA
3 1 (0.32%) Sarbanes-Oxley
3 1 (0.32%) Data Quality
System Software
1 20 (6.47%) Active Directory
2 5 (1.62%) Hyper-V
3 2 (0.65%) Terminal Server
4 1 (0.32%) LiteSpeed
4 1 (0.32%) Veritas Cluster Server
4 1 (0.32%) SRDF
Systems Management
1 5 (1.62%) SCOM
2 1 (0.32%) Oracle RMAN
2 1 (0.32%) Systems Management Server (SMS)
2 1 (0.32%) EMC NetWorker
Vendors
1 127 (41.10%) Microsoft
2 47 (15.21%) Cognos
3 24 (7.77%) Oracle
4 9 (2.91%) Siebel
4 9 (2.91%) SAP
5 7 (2.27%) VMware
6 6 (1.94%) Salesforce.com
6 6 (1.94%) Business Objects
6 6 (1.94%) Teradata
7 5 (1.62%) HP
8 4 (1.29%) Tableau
9 3 (0.97%) Red Gate
10 2 (0.65%) Ektron
10 2 (0.65%) Xamarin
10 2 (0.65%) Alteryx
10 2 (0.65%) IBM
10 2 (0.65%) MicroStrategy
10 2 (0.65%) Remedy
11 1 (0.32%) Brio
11 1 (0.32%) NetApp
London
Exposed Solutions
Salary: £45000 - £55000 per annum
Posted: 18 hours ago
Birmingham
Nigel Frank International Limited - Newcastle
Salary: £25000 - £35000 per annum + Training & Benefits
Posted: 19 hours ago
City, London
Informatiq Consulting
Salary: £40000 - £45000 per annum + bens
Posted: Yesterday
Reading, Berkshire
Venturi
Salary: £45000.00 - £55000.00 per annum + uncapped bonus and benefits
Posted: Yesterday
Coventry, West Midlands (County)
83Zero
Salary: £45,000 per annum + pension + flexi-time
Posted: 3 days ago
Altrincham
Computer Futures
Salary: £39999 - £50000 per annum + competitive
Posted: 9 days ago
Leicestershire
Computer Futures
Salary: £45000 - £55000 per annum + competitive
Posted: 25 days ago