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

3 months to
24 Sep 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 136 147 140
Rank change year-on-year
+11 -7
Permanent jobs citing DTS 2 8 7
As % of all permanent IT jobs located in Hertfordshire 0.10% 0.33% 0.30%
As % of the Database & Business Intelligence category 0.38% 1.07% 0.97%
Number of salaries quoted 2 8 7
Median salary £37,500 £42,500 £27,500
Median salary % change year-on-year
-11.76% +54.54%
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 Hertfordshire region.

Database & Business Intelligence Category
Hertfordshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
532 749 722
As % of all permanent IT jobs located in Hertfordshire 26.63% 31.20% 31.31%
Number of salaries quoted 458 662 598
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £35,000 £30,000 £30,000
10% offered a salary of more than £65,000 £65,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 Hertfordshire

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

DTS Jobs Demand Trend in Hertfordshire

DTS
Salary Trend in Hertfordshire

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

DTS Salary Trend in Hertfordshire

DTS
Salary Histogram in Hertfordshire

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

DTS Salary Histogram in Hertfordshire

DTS
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing DTS within the Hertfordshire region over the 3 months to 24 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
Borehamwood +5 1 £45,000 +5.88%
DTS
East of England

DTS
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 24 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 Hertfordshire region with a requirement for DTS.

1 5 (100.00%) SQL Server
1 5 (100.00%) Business Intelligence
1 5 (100.00%) SQL
1 5 (100.00%) T-SQL
1 5 (100.00%) SQL Server Integration Services
1 5 (100.00%) SQL Server 2014
2 3 (60.00%) SQL Server Reporting Services
2 3 (60.00%) Data Analysis
2 3 (60.00%) SQL Server 2008
2 3 (60.00%) Legal
2 3 (60.00%) Microsoft
2 3 (60.00%) Microsoft Certification
3 2 (40.00%) OLAP
3 2 (40.00%) Data Warehouse
3 2 (40.00%) ETL
3 2 (40.00%) .NET
3 2 (40.00%) SaaS
3 2 (40.00%) R
3 2 (40.00%) Software Engineering
3 2 (40.00%) SQL Server 2005
3 2 (40.00%) Degree
3 2 (40.00%) MDX
3 2 (40.00%) Mathematics
3 2 (40.00%) Physics
3 2 (40.00%) Computer Science
3 2 (40.00%) SQL Server Analysis Services
3 2 (40.00%) Dimensional Modelling
3 2 (40.00%) SQL Server 2016
3 2 (40.00%) Analytics
3 2 (40.00%) Data Transformation

DTS
Top Related IT Skills in Hertfordshire 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:

Cloud Services
1 2 (40.00%) SaaS
Database & Business Intelligence
1 5 (100.00%) SQL Server
1 5 (100.00%) SQL Server 2014
1 5 (100.00%) SQL Server Integration Services
2 3 (60.00%) SQL Server 2008
2 3 (60.00%) SQL Server Reporting Services
3 2 (40.00%) Data Warehouse
3 2 (40.00%) Microsoft Analysis Services
3 2 (40.00%) OLAP
3 2 (40.00%) OLAP Cube
3 2 (40.00%) SQL Server 2005
3 2 (40.00%) SQL Server 2016
3 2 (40.00%) SQL Server Analysis Services
Development Applications
1 2 (40.00%) SQL Server Management Studio (SSMS)
General
1 3 (60.00%) Legal
2 1 (20.00%) Billing
Job Titles
1 3 (60.00%) Developer
1 3 (60.00%) SQL Developer
2 1 (20.00%) Analyst
2 1 (20.00%) Analyst Developer
2 1 (20.00%) Data Manager
2 1 (20.00%) Developer Analyst
2 1 (20.00%) Senior Developer
2 1 (20.00%) Senior SQL Developer
2 1 (20.00%) SQL Analyst
2 1 (20.00%) SQL Server Specialist
2 1 (20.00%) SSIS Analyst
2 1 (20.00%) SSIS Developer
2 1 (20.00%) SSIS Specialist
2 1 (20.00%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 2 (40.00%) .NET
1 2 (40.00%) MDX
Miscellaneous
1 2 (40.00%) Analytical Skills
1 2 (40.00%) Computer Science
1 2 (40.00%) Mathematics
1 2 (40.00%) Physics
2 1 (20.00%) Management Information System
Processes & Methodologies
1 5 (100.00%) Business Intelligence
2 3 (60.00%) Data Analysis
3 2 (40.00%) Analytics
3 2 (40.00%) Data Transformation
3 2 (40.00%) Dimensional Modelling
3 2 (40.00%) ETL
3 2 (40.00%) Performance Optimisation
3 2 (40.00%) SDLC
3 2 (40.00%) Software Engineering
Programming Languages
1 5 (100.00%) SQL
1 5 (100.00%) T-SQL
2 2 (40.00%) R
Qualifications
1 3 (60.00%) Microsoft Certification
2 2 (40.00%) Degree
Vendors
1 3 (60.00%) Microsoft