The table below looks at the statistics for DTS skills in IT jobs advertised for the England region. Included is a guide to the salaries offered in IT jobs that have cited DTS over the 3 months to 23 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
23 Feb 2017
Same period 2016 Same period 2015
Microsoft Data Transformation Services (DTS)
UK / England
Rank 733 845 795
Rank change year-on-year
+112 -50
Permanent jobs citing DTS 91 68 138
As % of all permanent IT jobs located in England 0.12% 0.071% 0.14%
As % of the Database & Business Intelligence category 0.38% 0.23% 0.44%
Number of salaries quoted 73 53 129
Median salary £42,500 £47,000 £42,500
Median salary % change year-on-year
-9.57% +10.58%
90% offered a salary of more than £35,000 £35,000 £33,500
10% offered a salary of more than £68,500 £72,000 £60,000
UK excluding London median salary £42,500 £45,750 £40,000
% change year-on-year
-7.10% +14.37%

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 England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
23769 30114 31050
As % of all permanent IT jobs located in England 30.22% 31.58% 31.20%
Number of salaries quoted 20390 25850 26824
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year
- +11.11%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

DTS
Jobs Demand Trend in England

The demand trend of job ads across the England region citing DTS as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

DTS Jobs Demand Trend in England

DTS
Salary Trend in England

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

DTS Salary Trend in England

DTS
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing DTS across the England region over the 3 months to 23 February 2017.

DTS Salary Histogram in England

DTS
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing DTS within the England region over the 3 months to 23 February 2017. 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 Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London +94 26 £65,000 +36.84%
East of England - 21 £43,000 -
South East +47 14 £37,000 -26.00% 1
East Midlands +23 10 £40,000 +3.22%
West Midlands +32 7 £43,250 +2.36%
South West +16 5 £42,500 -
North West -19 5 £40,000 -13.04% 1
Yorkshire +11 3 £35,000 -12.50% 1
DTS
UK

DTS
Top 30 Related IT Skills in England

For the 6 months to 23 February 2017, IT jobs citing DTS also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the England region with a requirement for DTS.

1 178 (89.00%) SQL Server
2 158 (79.00%) SQL
3 150 (75.00%) SQL Server Integration Services
4 114 (57.00%) T-SQL
5 96 (48.00%) .NET
6 91 (45.50%) Microsoft
7 90 (45.00%) SQL Server Reporting Services
8 86 (43.00%) SQL Server 2008
9 72 (36.00%) C#
10 69 (34.50%) Business Intelligence
11 63 (31.50%) Finance
12 55 (27.50%) SQL Server Analysis Services
13 50 (25.00%) SQL Server 2014
14 44 (22.00%) Oracle
15 41 (20.50%) SQL Server 2005
16 37 (18.50%) SQL Server 2012
17 36 (18.00%) MVC
17 36 (18.00%) ETL
17 36 (18.00%) CSS
17 36 (18.00%) HTML
17 36 (18.00%) Windows
18 35 (17.50%) SQL Server 2000
19 34 (17.00%) Agile Software Development
20 32 (16.00%) Project Management
21 31 (15.50%) IIS
22 30 (15.00%) ASP.NET
23 29 (14.50%) MS Excel
23 29 (14.50%) SQL Server 2016
24 28 (14.00%) Time Management
25 26 (13.00%) Data Warehouse

DTS
Top Related IT Skills in England by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 31 (15.50%) IIS
2 23 (11.50%) BizTalk Server
3 20 (10.00%) SharePoint
4 9 (4.50%) Anypoint
4 9 (4.50%) JBoss
5 5 (2.50%) Jetty
5 5 (2.50%) Tomcat
6 4 (2.00%) Apache Spark
6 4 (2.00%) Confluence
6 4 (2.00%) Elasticsearch
7 3 (1.50%) FormScape
8 2 (1.00%) CMS
9 1 (0.50%) MS Exchange
9 1 (0.50%) Oracle Workflow
9 1 (0.50%) SAS
9 1 (0.50%) WebSphere
9 1 (0.50%) WebSphere Application Server
9 1 (0.50%) WordPress
Applications
1 29 (14.50%) MS Excel
2 10 (5.00%) MS Office
3 1 (0.50%) Photoshop
Business Applications
1 5 (2.50%) Sage X3
2 4 (2.00%) Cognos TM1
3 3 (1.50%) Dynamics NAV
4 1 (0.50%) SAP ERP
Cloud Services
1 4 (2.00%) SaaS
Communications & Networking
1 14 (7.00%) Intranet
2 2 (1.00%) SAN
3 1 (0.50%) FTP
3 1 (0.50%) TCP/IP
Database & Business Intelligence
1 178 (89.00%) SQL Server
2 150 (75.00%) SQL Server Integration Services
3 90 (45.00%) SQL Server Reporting Services
4 86 (43.00%) SQL Server 2008
5 55 (27.50%) SQL Server Analysis Services
6 50 (25.00%) SQL Server 2014
7 41 (20.50%) SQL Server 2005
8 37 (18.50%) SQL Server 2012
9 35 (17.50%) SQL Server 2000
10 29 (14.50%) SQL Server 2016
11 26 (13.00%) Data Warehouse
12 23 (11.50%) OLAP
13 22 (11.00%) Relational Database
14 19 (9.50%) Oracle OLAP
15 16 (8.00%) Microsoft Analysis Services
15 16 (8.00%) RDBMS
16 10 (5.00%) DB2
16 10 (5.00%) Oracle Reports
17 9 (4.50%) EDRMS
17 9 (4.50%) Power BI
Development Applications
1 23 (11.50%) SQL Server Management Studio (SSMS)
2 21 (10.50%) Visual Studio
3 14 (7.00%) Jenkins
3 14 (7.00%) Visual Studio Team System
4 9 (4.50%) Octopus Deploy
4 9 (4.50%) TeamCity
5 5 (2.50%) ERwin
5 5 (2.50%) JUnit
5 5 (2.50%) Mockito
5 5 (2.50%) Team Foundation Server
6 4 (2.00%) Git (software)
7 1 (0.50%) Bitbucket
7 1 (0.50%) JIRA
7 1 (0.50%) Oracle Forms
7 1 (0.50%) Toad
General
1 63 (31.50%) Finance
2 20 (10.00%) Legal
3 17 (8.50%) Back Office
4 14 (7.00%) Retail
5 8 (4.00%) Banking
5 8 (4.00%) Marketing
6 5 (2.50%) Front Office
6 5 (2.50%) Music Industry
7 4 (2.00%) Billing
8 2 (1.00%) Law
8 2 (1.00%) Manufacturing
8 2 (1.00%) Publishing
9 1 (0.50%) Advertising
Job Titles
1 94 (47.00%) Developer
2 40 (20.00%) DBA
2 40 (20.00%) SQL DBA
3 38 (19.00%) Analyst
4 31 (15.50%) .NET Developer
5 28 (14.00%) SQL Server DBA
6 26 (13.00%) C# Developer
6 26 (13.00%) Senior Developer
7 25 (12.50%) SQL Developer
8 21 (10.50%) SQL Analyst
9 20 (10.00%) C# .NET Developer
10 17 (8.50%) SSIS Developer
11 16 (8.00%) T-SQL Developer
12 14 (7.00%) Architect
12 14 (7.00%) Senior Systems Developer
12 14 (7.00%) SSIS Analyst
12 14 (7.00%) Systems Developer
13 13 (6.50%) Integration Analyst
13 13 (6.50%) Software Developer
13 13 (6.50%) Support Analyst
Libraries, Frameworks & Software Standards
1 96 (48.00%) .NET
2 36 (18.00%) CSS
2 36 (18.00%) HTML
3 30 (15.00%) ASP.NET
4 25 (12.50%) XML
5 20 (10.00%) WCF
6 13 (6.50%) jQuery
7 12 (6.00%) REST
8 11 (5.50%) Ajax
8 11 (5.50%) AngularJS
9 10 (5.00%) ASP.NET MVC
9 10 (5.00%) Web Services
10 8 (4.00%) WPF
11 7 (3.50%) Classic ASP
11 7 (3.50%) EDI
12 6 (3.00%) ASP.NET MVC 3
12 6 (3.00%) DHTML
13 5 (2.50%) React
13 5 (2.50%) Servlets
13 5 (2.50%) Spring
Miscellaneous
1 25 (12.50%) Replication
2 19 (9.50%) Enterprise Software
3 18 (9.00%) Analytical Skills
3 18 (9.00%) Management Information System
4 16 (8.00%) Clustering
5 10 (5.00%) Data Centre
5 10 (5.00%) Reinsurance
6 9 (4.50%) AS400
7 8 (4.00%) Mobile App
7 8 (4.00%) PMI
8 5 (2.50%) Computer Science
8 5 (2.50%) NHS
9 3 (1.50%) User Experience
10 1 (0.50%) iSeries
10 1 (0.50%) Mainframe
10 1 (0.50%) N-Tier
Operating Systems
1 36 (18.00%) Windows
2 15 (7.50%) Windows Server
3 7 (3.50%) Linux
4 6 (3.00%) Unix
5 5 (2.50%) Windows Server 2003
6 4 (2.00%) Windows Server 2008
6 4 (2.00%) Windows Server 2012
7 1 (0.50%) Windows 2000
Processes & Methodologies
1 69 (34.50%) Business Intelligence
2 36 (18.00%) ETL
2 36 (18.00%) MVC
3 34 (17.00%) Agile Software Development
4 32 (16.00%) Project Management
5 28 (14.00%) Time Management
6 24 (12.00%) Performance Tuning
6 24 (12.00%) SDLC
7 20 (10.00%) Unit Testing
8 18 (9.00%) PRINCE2
9 17 (8.50%) Data Transformation
9 17 (8.50%) TDD
10 16 (8.00%) Workflow
11 15 (7.50%) Case Management
12 14 (7.00%) Software Engineering
13 12 (6.00%) OOA/OOD
14 11 (5.50%) DevOps
14 11 (5.50%) TOGAF
15 10 (5.00%) Front End Development
15 10 (5.00%) Web Development
Programming Languages
1 158 (79.00%) SQL
2 114 (57.00%) T-SQL
3 72 (36.00%) C#
4 25 (12.50%) Java
4 25 (12.50%) JavaScript
4 25 (12.50%) VB
5 17 (8.50%) PL/SQL
6 14 (7.00%) VB.NET
7 9 (4.50%) PHP
8 7 (3.50%) R
8 7 (3.50%) VB6
9 6 (3.00%) PowerShell
9 6 (3.00%) VBA
10 4 (2.00%) Python
11 3 (1.50%) VBScript
12 1 (0.50%) C
12 1 (0.50%) FoxPro (VFP)
12 1 (0.50%) PHP 5
Qualifications
1 25 (12.50%) Degree
2 14 (7.00%) Microsoft Certification
3 8 (4.00%) PMI Certification
4 4 (2.00%) DV Cleared
4 4 (2.00%) PhD
4 4 (2.00%) Security Cleared
5 1 (0.50%) ISEB
5 1 (0.50%) MCDBA
5 1 (0.50%) MCITP
5 1 (0.50%) MCSA
5 1 (0.50%) MCSE
Quality Assurance & Compliance
1 7 (3.50%) SLA
2 5 (2.50%) Data Quality
3 3 (1.50%) QA
System Software
1 2 (1.00%) Active Directory
2 1 (0.50%) Oracle RAC
Systems Management
1 9 (4.50%) Perfmon
1 9 (4.50%) Puppet
2 4 (2.00%) SCOM
3 3 (1.50%) Microsoft Clustering
4 1 (0.50%) Control-M
4 1 (0.50%) Enterprise Manager Cloud Control
4 1 (0.50%) Failover Clustering
4 1 (0.50%) LiteSpeed
4 1 (0.50%) SQL Sentry
Vendors
1 91 (45.50%) Microsoft
2 44 (22.00%) Oracle
3 19 (9.50%) VMware
4 11 (5.50%) SAP
5 9 (4.50%) Cognos
5 9 (4.50%) webMethods
6 8 (4.00%) Tableau
7 5 (2.50%) IBM
7 5 (2.50%) OpenText
7 5 (2.50%) Sage
8 3 (1.50%) JD Edwards
9 2 (1.00%) Netezza
9 2 (1.00%) Pega
9 2 (1.00%) Progress
9 2 (1.00%) Salesforce.com
10 1 (0.50%) Adobe
10 1 (0.50%) Citrix
10 1 (0.50%) MicroStrategy
10 1 (0.50%) Remedy
10 1 (0.50%) Sybase
Manchester, Lancashire
Proactive Appointments
Salary: Competitive Salary + Bonus + Brilliant Benefits
Posted: Yesterday
York, North Yorkshire
Fruition IT Resources Limited
Salary: £30000 - £40000 per annum + bonus + on site gym + free parking
Posted: 3 days ago
Folkestone, Kent
Deerfoot IT Resources Ltd
Salary: £28000 - £42000 per annum
Posted: 6 days ago