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

3 months to
1 Jul 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 77 55 57
Rank change year-on-year
-22 +2
Permanent jobs citing ETL 6 16 34
As % of all permanent IT jobs located in Staffordshire 0.87% 2.59% 4.41%
As % of the Processes & Methodologies category 0.98% 2.96% 5.48%
Number of salaries quoted 5 11 34
Median salary £40,000 £41,500 £40,000
Median salary % change year-on-year
-3.61% +3.75%
90% offered a salary of more than £39,100 £25,000 £35,000
10% offered a salary of more than £62,500 £50,000 £58,500
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year
- +2.27%
ETL
West Midlands

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the Staffordshire region.

Processes & Methodologies Category
Staffordshire
Permanent IT job ads with a match in the
Processes & Methodologies category
613 541 621
As % of all permanent IT jobs located in Staffordshire 89.36% 87.68% 80.54%
Number of salaries quoted 548 469 482
Median salary £38,000 £40,000 £37,500
Median salary % change year-on-year
-5.00% +6.66%
90% offered a salary of more than £25,000 £28,550 £24,000
10% offered a salary of more than £55,000 £57,500 £57,500
UK excluding London median salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

ETL
Jobs Demand Trend in Staffordshire

The demand trend of job ads across the Staffordshire region citing ETL as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ETL Jobs Demand Trend in Staffordshire

ETL
Salary Trend in Staffordshire

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

ETL Salary Trend in Staffordshire

ETL
Salary Histogram in Staffordshire

This chart provides a salary histogram for IT jobs citing ETL across the Staffordshire region over the 3 months to 1 July 2016.

ETL Salary Histogram in Staffordshire

ETL
Job Locations in Staffordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Staffordshire region over the 3 months to 1 July 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
Stoke-on-Trent -19 4 £40,000 +35.59%
Cannock - 1 £38,500 -
ETL
West Midlands

ETL
Top 30 Related IT Skills in Staffordshire

For the 6 months to 1 July 2016, IT jobs citing ETL 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 Staffordshire region with a requirement for ETL.

1 13 (76.47%) SQL
2 12 (70.59%) Business Intelligence
2 12 (70.59%) Data Warehouse
3 10 (58.82%) Teradata
3 10 (58.82%) Oracle
3 10 (58.82%) DB2
3 10 (58.82%) Unix
3 10 (58.82%) Linux
3 10 (58.82%) Netezza
3 10 (58.82%) Greenplum
3 10 (58.82%) Dimensional Modelling
3 10 (58.82%) Vertica
3 10 (58.82%) Kimball Methodology
3 10 (58.82%) Parallel Processing
4 7 (41.18%) SQL Server Reporting Services
5 6 (35.29%) SQL Server
6 5 (29.41%) Data Modelling
7 4 (23.53%) Finance
7 4 (23.53%) OLTP
7 4 (23.53%) ETL Development
7 4 (23.53%) SQL Server Integration Services
8 3 (17.65%) SQL Server Analysis Services
8 3 (17.65%) Performance Monitoring
8 3 (17.65%) SQL Server 2008
8 3 (17.65%) Analytical Skills
8 3 (17.65%) People Management
8 3 (17.65%) Microsoft
8 3 (17.65%) Shell Script
8 3 (17.65%) Project Management
8 3 (17.65%) T-SQL

ETL
Top Related IT Skills in Staffordshire 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:

Database & Business Intelligence
1 12 (70.59%) Data Warehouse
2 10 (58.82%) DB2
3 7 (41.18%) SQL Server Reporting Services
4 6 (35.29%) SQL Server
5 4 (23.53%) OLTP
5 4 (23.53%) SQL Server Integration Services
6 3 (17.65%) SQL Server 2008
6 3 (17.65%) SQL Server Analysis Services
7 2 (11.76%) Microsoft Analysis Services
Development Applications
1 2 (11.76%) Team Foundation Server
General
1 4 (23.53%) Finance
2 1 (5.88%) Games
Job Titles
1 10 (58.82%) Developer
2 5 (29.41%) Data Warehouse Developer
3 4 (23.53%) SQL Developer
4 3 (17.65%) Data Warehouse Manager
4 3 (17.65%) SQL Server Developer
5 2 (11.76%) Business Intelligence Developer
5 2 (11.76%) Data Manager
5 2 (11.76%) Junior
5 2 (11.76%) Junior Developer
5 2 (11.76%) Junior SQL Developer
5 2 (11.76%) Junior SQL Server Developer
5 2 (11.76%) Senior Developer
5 2 (11.76%) Senior SQL Developer
5 2 (11.76%) Senior SQL Server Developer
5 2 (11.76%) Team Leader
5 2 (11.76%) Tester
6 1 (5.88%) Business Developer
6 1 (5.88%) Business Manager
6 1 (5.88%) MIS Developer
6 1 (5.88%) SSRS Developer
Libraries, Frameworks & Software Standards
1 2 (11.76%) .NET
Miscellaneous
1 3 (17.65%) Analytical Skills
Operating Systems
1 10 (58.82%) Linux
1 10 (58.82%) Unix
Processes & Methodologies
1 12 (70.59%) Business Intelligence
2 10 (58.82%) Dimensional Modelling
2 10 (58.82%) Kimball Methodology
2 10 (58.82%) Parallel Processing
3 5 (29.41%) Data Modelling
4 4 (23.53%) ETL Development
5 3 (17.65%) People Management
5 3 (17.65%) Performance Monitoring
5 3 (17.65%) Project Management
6 2 (11.76%) Integration Testing
6 2 (11.76%) Test Management
6 2 (11.76%) Test Planning
6 2 (11.76%) Test Scripting
6 2 (11.76%) Test Strategy
7 1 (5.88%) PRINCE2
Programming Languages
1 13 (76.47%) SQL
2 3 (17.65%) Shell Script
2 3 (17.65%) T-SQL
Qualifications
1 2 (11.76%) ISEB
1 2 (11.76%) ISTQB
Vendors
1 10 (58.82%) Greenplum
1 10 (58.82%) Netezza
1 10 (58.82%) Oracle
1 10 (58.82%) Teradata
1 10 (58.82%) Vertica
2 3 (17.65%) Microsoft