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

3 months to
25 Sep 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 71 78 79
Rank change year-on-year
+7 +1
Permanent jobs citing DTS 18 19 8
As % of all permanent IT jobs located in Essex 1.78% 1.46% 0.72%
As % of the Database & Business Intelligence category 6.06% 5.31% 2.51%
Number of salaries quoted 18 19 8
Median salary £40,000 £50,000 £41,250
Median salary % change year-on-year
-20.00% +21.21%
90% offered a salary of more than £37,000 £35,000 £38,500
10% offered a salary of more than £65,000 £72,000 £42,500
UK excluding London median salary £46,000 £45,000 £38,250
% change year-on-year
+2.22% +17.64%
DTS
East of England

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

Database & Business Intelligence Category
Essex
Permanent IT job ads with a match in the
Database & Business Intelligence category
297 358 319
As % of all permanent IT jobs located in Essex 29.41% 27.58% 28.71%
Number of salaries quoted 238 263 264
Median salary £45,000 £42,500 £42,500
Median salary % change year-on-year
+5.88% -
90% offered a salary of more than £34,500 £32,500 £32,500
10% offered a salary of more than £65,000 £55,000 £65,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

DTS
Jobs Demand Trend in Essex

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

DTS Jobs Demand Trend in Essex

DTS
Salary Trend in Essex

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

DTS Salary Trend in Essex

DTS
Salary Histogram in Essex

This chart provides a salary histogram for IT jobs citing DTS across the Essex region over the 3 months to 25 September 2016.

DTS Salary Histogram in Essex

DTS
Job Locations in Essex

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing DTS within the Essex region over the 3 months to 25 September 2016. 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
(Click see detailed
statistics and trends)
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
Chelmsford -1 10 £51,000 +26.70%
DTS
East of England

DTS
Top 20 Related IT Skills in Essex

For the 6 months to 25 September 2016, 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 Essex region with a requirement for DTS.

1 23 (100.00%) SQL
1 23 (100.00%) T-SQL
1 23 (100.00%) SQL Server
1 23 (100.00%) Business Intelligence
1 23 (100.00%) SQL Server 2005
1 23 (100.00%) SQL Server Integration Services
1 23 (100.00%) SQL Server 2008
2 17 (73.91%) ProClarity
2 17 (73.91%) SharePoint
2 17 (73.91%) VB
2 17 (73.91%) .NET
2 17 (73.91%) MicroStrategy
2 17 (73.91%) C#
2 17 (73.91%) Finance
3 16 (69.57%) SLA
4 14 (60.87%) Change Management
5 13 (56.52%) Data Warehouse
6 7 (30.43%) Microsoft
6 7 (30.43%) SQL Server 2000
7 4 (17.39%) SQL Server Analysis Services

DTS
Top Related IT Skills in Essex 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 17 (73.91%) SharePoint
Database & Business Intelligence
1 23 (100.00%) SQL Server
1 23 (100.00%) SQL Server 2005
1 23 (100.00%) SQL Server 2008
1 23 (100.00%) SQL Server Integration Services
2 17 (73.91%) ProClarity
3 13 (56.52%) Data Warehouse
4 7 (30.43%) SQL Server 2000
5 4 (17.39%) SQL Server Analysis Services
General
1 17 (73.91%) Finance
Job Titles
1 17 (73.91%) Analyst
1 17 (73.91%) Support Analyst
2 16 (69.57%) SQL Analyst
2 16 (69.57%) SQL Server Analyst
2 16 (69.57%) SQL Support Analyst
2 16 (69.57%) SSIS Analyst
3 14 (60.87%) Business Intelligence Analyst
3 14 (60.87%) Business Intelligence Support Analyst
4 10 (43.48%) Business Support Analyst
5 6 (26.09%) Applications Manager
5 6 (26.09%) Applications Support
5 6 (26.09%) Applications Support Manager
5 6 (26.09%) Business Intelligence Manager
5 6 (26.09%) Data Warehouse Manager
5 6 (26.09%) Support Manager
Libraries, Frameworks & Software Standards
1 17 (73.91%) .NET
Processes & Methodologies
1 23 (100.00%) Business Intelligence
2 14 (60.87%) Change Management
Programming Languages
1 23 (100.00%) SQL
1 23 (100.00%) T-SQL
2 17 (73.91%) C#
2 17 (73.91%) VB
Quality Assurance & Compliance
1 16 (69.57%) SLA
Vendors
1 17 (73.91%) MicroStrategy
2 7 (30.43%) Microsoft