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

Location
3 months to
29 Aug 2014
Same period 2013 Same period 2012
Extract, Transform and Load (ETL)
Rank 41 52 40
Rank change year-on-year
+11 -12
Permanent jobs citing ETL 38 13 19
As % of all permanent IT jobs located in Staffordshire 5.33% 1.96% 3.82%
As % of the Processes & Methodologies category 7.31% 2.50% 4.95%
Number of salaries quoted 38 11 19
Average salary £39,750 £45,000 £40,000
Average salary % change year-on-year
-11.66% +12.50%
90% offered a salary of more than £32,500 £45,000 £35,000
10% offered a salary of more than £55,000 £46,500 £42,500
UK excluding London average salary £45,000 £45,000 £42,000
% change year-on-year
- +7.14%
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
520 521 384
As % of all permanent IT jobs located in Staffordshire 72.93% 78.58% 77.26%
Number of salaries quoted 411 440 307
Average salary £37,500 £40,000 £40,000
Average salary % change year-on-year
-6.25% -
90% offered a salary of more than £27,500 £25,000 £27,500
10% offered a salary of more than £56,500 £62,500 £57,500
UK excluding London average salary £42,500 £41,000 £40,000
% change year-on-year
+3.65% +2.50%

ETL
Jobs Demand Trend in Staffordshire

This chart provides a 3-month moving total of permanent IT jobs citing ETL across the Staffordshire region as a proportion of the total demand within 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 29 August 2014.

ETL Salary Histogram in Staffordshire

ETL
Job Locations in Staffordshire

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing ETL within the Staffordshire region over the 3 months to 29 August 2014. 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
Burton-upon-Trent +4 15 £40,000 -11.11%
Stoke-on-Trent +7 5 £32,500 -27.77%
Cannock 0 5 £39,500 -15.05%
Stafford - 3 £32,500 -
Lichfield -5 1 £35,000 -12.50%
ETL
West Midlands

ETL
Top 30 Related IT Skills in Staffordshire

For the 6 months to 29 August 2014, IT jobs across the Staffordshire region citing ETL 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 ETL.

1 63 (92.65%) SQL
2 57 (83.82%) SQL Server
3 50 (73.53%) Business Intelligence
4 46 (67.65%) SQL Server Reporting Services
5 43 (63.24%) SQL Server Integration Services
6 41 (60.29%) Microsoft
7 39 (57.35%) Data Warehouse
8 31 (45.59%) SQL Server Analysis Services
9 30 (44.12%) MS Excel
10 26 (38.24%) OLAP
11 22 (32.35%) MS Office
11 22 (32.35%) SharePoint
12 18 (26.47%) Office 365
13 14 (20.59%) ITIL
13 14 (20.59%) Microsoft Analysis Services
14 12 (17.65%) SQL Server 2008
14 12 (17.65%) UNIX
14 12 (17.65%) T-SQL
14 12 (17.65%) Shell Script
15 11 (16.18%) DTS
16 10 (14.71%) Dimensional Modelling
16 10 (14.71%) MDX
17 9 (13.24%) Data Architecture
17 9 (13.24%) Disaster Recovery
17 9 (13.24%) Database Security
18 8 (11.76%) Change Management
18 8 (11.76%) ITIL Certification
18 8 (11.76%) Linux
18 8 (11.76%) Degree
18 8 (11.76%) Data Analysis

ETL
Top Related IT Skills in Staffordshire by Category

For the 6 months to 29 August 2014, IT jobs across the Staffordshire region citing ETL 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 ETL. Up to 20 skills are shown per category.

Application Platforms
1 22 (32.35%) SharePoint
2 4 (5.88%) SharePoint Server
3 1 (1.47%) IIS
3 1 (1.47%) SAS
Applications
1 30 (44.12%) MS Excel
2 22 (32.35%) MS Office
Business Applications
1 4 (5.88%) Dynamics CRM
1 4 (5.88%) Line 500
Cloud Services
1 18 (26.47%) Office 365
2 2 (2.94%) SaaS
Communications & Networking
1 2 (2.94%) VLAN
Database & Business Intelligence
1 57 (83.82%) SQL Server
2 46 (67.65%) SQL Server Reporting Services
3 43 (63.24%) SQL Server Integration Services
4 39 (57.35%) Data Warehouse
5 31 (45.59%) SQL Server Analysis Services
6 26 (38.24%) OLAP
7 14 (20.59%) Microsoft Analysis Services
8 12 (17.65%) SQL Server 2008
9 11 (16.18%) DTS
10 7 (10.29%) SQL Server 2005
11 4 (5.88%) QlikView
11 4 (5.88%) Data Mining
12 3 (4.41%) OLTP
12 3 (4.41%) Big Data
13 2 (2.94%) PostgreSQL
13 2 (2.94%) DB2
14 1 (1.47%) Crystal Reports
14 1 (1.47%) Apache Cassandra
14 1 (1.47%) NoSQL
Development Applications
1 4 (5.88%) Visual Studio
1 4 (5.88%) Visual Studio Team System
2 3 (4.41%) SQL Server Management Studio (SSMS)
3 2 (2.94%) Talend Open Studio
General
1 4 (5.88%) Billing
2 1 (1.47%) Finance
2 1 (1.47%) Automotive
2 1 (1.47%) Retail
Job Titles
1 41 (60.29%) Developer
2 30 (44.12%) SQL Developer
3 22 (32.35%) Business Intelligence Developer
4 19 (27.94%) Business Developer
5 12 (17.65%) DBA
6 10 (14.71%) SQL Server DBA
6 10 (14.71%) Analyst
6 10 (14.71%) SQL DBA
7 9 (13.24%) Senior Business Analyst
7 9 (13.24%) Senior Analyst
7 9 (13.24%) Business Intelligence Analyst
7 9 (13.24%) Business Analyst
7 9 (13.24%) Senior Business Intelligence Analyst
8 7 (10.29%) Lead Developer
9 6 (8.82%) Data Manager
9 6 (8.82%) Senior Developer
9 6 (8.82%) Microsoft Developer
9 6 (8.82%) Data Warehouse Manager
10 5 (7.35%) Senior SQL Developer
10 5 (7.35%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 10 (14.71%) MDX
2 6 (8.82%) .NET
2 6 (8.82%) ASP.NET
3 4 (5.88%) XML
3 4 (5.88%) HTML
4 3 (4.41%) Web Services
5 1 (1.47%) Ajax
5 1 (1.47%) .NET Framework
5 1 (1.47%) jQuery
Miscellaneous
1 1 (1.47%) Management Information System
1 1 (1.47%) Artificial Intelligence
1 1 (1.47%) Data Integration
Operating Systems
1 12 (17.65%) UNIX
2 8 (11.76%) Linux
3 2 (2.94%) Debian
3 2 (2.94%) Ubuntu
3 2 (2.94%) Windows Server 2008
3 2 (2.94%) Windows
Processes & Methodologies
1 50 (73.53%) Business Intelligence
2 14 (20.59%) ITIL
3 10 (14.71%) Dimensional Modelling
4 9 (13.24%) Data Architecture
4 9 (13.24%) Database Security
4 9 (13.24%) Disaster Recovery
5 8 (11.76%) Data Analysis
5 8 (11.76%) Change Management
6 7 (10.29%) Parallel Processing
6 7 (10.29%) Data Modelling
7 5 (7.35%) Scrum
7 5 (7.35%) Performance Tuning
8 4 (5.88%) Kimball Methodology
8 4 (5.88%) CRM
8 4 (5.88%) Multidimensional Analysis
8 4 (5.88%) Project Management
9 3 (4.41%) Service Management
10 2 (2.94%) RAD
10 2 (2.94%) Migration
10 2 (2.94%) Problem Management
Programming Languages
1 63 (92.65%) SQL
2 12 (17.65%) T-SQL
2 12 (17.65%) Shell Script
3 4 (5.88%) VBA
3 4 (5.88%) JavaScript
4 3 (4.41%) PL/SQL
5 1 (1.47%) C#
Qualifications
1 8 (11.76%) ITIL Certification
1 8 (11.76%) Degree
System Software
1 2 (2.94%) Active Directory
Vendors
1 41 (60.29%) Microsoft
2 6 (8.82%) Teradata
3 4 (5.88%) Logi Analytics
3 4 (5.88%) Sage
4 3 (4.41%) Oracle
5 2 (2.94%) Business Objects
5 2 (2.94%) Cognos
5 2 (2.94%) Talend
6 1 (1.47%) Informatica
6 1 (1.47%) MicroStrategy
6 1 (1.47%) Vertica
6 1 (1.47%) Netezza
6 1 (1.47%) Greenplum