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 19 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
19 Jan 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
West Midlands / Staffordshire
Rank 63 38 59
Rank change year-on-year
-25 +21
Permanent jobs citing ETL 8 27 7
As % of all permanent IT jobs located in Staffordshire 1.48% 4.58% 1.22%
As % of the Processes & Methodologies category 1.59% 5.31% 1.45%
Number of salaries quoted 5 24 6
Median salary £37,500 £47,500 £38,750
Median salary % change year-on-year
-21.05% +22.58%
90% offered a salary of more than £36,000 £29,000 £32,500
10% offered a salary of more than £42,000 £75,250 £46,750
UK excluding London median salary £45,000 £45,000 £45,000

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
504 508 482
As % of all permanent IT jobs located in Staffordshire 93.33% 86.25% 83.97%
Number of salaries quoted 411 467 414
Median salary £40,000 £40,000 £40,000
90% offered a salary of more than £30,000 £28,550 £26,500
10% offered a salary of more than £55,000 £55,000 £52,500
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

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
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 19 January 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
Burton-upon-Trent -1 3 £37,500 -16.66%
Stafford -4 3 - -
Stoke-on-Trent -7 1 £45,000 -10.00%
Cannock - 1 £37,500 -
ETL
West Midlands

ETL
Top 30 Related IT Skills in Staffordshire

For the 6 months to 19 January 2017, 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 18 (100.00%) Business Intelligence
2 14 (77.78%) SQL Server Integration Services
3 13 (72.22%) SQL
4 10 (55.56%) SQL Server
5 9 (50.00%) Data Warehouse
5 9 (50.00%) SQL Server Reporting Services
6 8 (44.44%) QlikView
6 8 (44.44%) Retail
6 8 (44.44%) Data Integration
6 8 (44.44%) Analytical Skills
7 7 (38.89%) SQL Server Analysis Services
8 6 (33.33%) Netezza
8 6 (33.33%) T-SQL
9 5 (27.78%) Information Exploitation
9 5 (27.78%) Data Mining
9 5 (27.78%) Star Schema
9 5 (27.78%) Dimensional Modelling
9 5 (27.78%) Data Cleansing
9 5 (27.78%) Visualisation
9 5 (27.78%) Data Visualisation
10 4 (22.22%) Data Quality
10 4 (22.22%) QA
10 4 (22.22%) Data Analysis
10 4 (22.22%) Data Management
10 4 (22.22%) Microsoft
10 4 (22.22%) DataStage
10 4 (22.22%) Disaster Recovery
10 4 (22.22%) Stakeholder Management
10 4 (22.22%) MS Excel
10 4 (22.22%) Target Operating Model

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:

Application Platforms
1 2 (11.11%) SharePoint
1 2 (11.11%) SharePoint Server
2 1 (5.56%) IIS
Applications
1 4 (22.22%) MS Excel
2 2 (11.11%) MS Office
Business Applications
1 1 (5.56%) Dynamics CRM
Cloud Services
1 1 (5.56%) Microsoft Azure
Database & Business Intelligence
1 14 (77.78%) SQL Server Integration Services
2 10 (55.56%) SQL Server
3 9 (50.00%) Data Warehouse
3 9 (50.00%) SQL Server Reporting Services
4 8 (44.44%) QlikView
5 7 (38.89%) SQL Server Analysis Services
6 5 (27.78%) Data Mining
6 5 (27.78%) Star Schema
7 4 (22.22%) DataStage
8 3 (16.67%) SQL Server 2005
9 2 (11.11%) OLAP
9 2 (11.11%) SQL Server 2012
10 1 (5.56%) DB2
10 1 (5.56%) Microsoft Analysis Services
10 1 (5.56%) MySQL
10 1 (5.56%) NoSQL
10 1 (5.56%) Power BI
10 1 (5.56%) SQL Server 2008
Development Applications
1 2 (11.11%) Visual Studio
2 1 (5.56%) Talend Open Studio
2 1 (5.56%) Team Foundation Server
2 1 (5.56%) Visual Studio Team System
General
1 8 (44.44%) Retail
Job Titles
1 17 (94.44%) Business Intelligence Developer
1 17 (94.44%) Developer
2 6 (33.33%) SSIS Developer
3 4 (22.22%) Analyst
3 4 (22.22%) Analyst Developer
3 4 (22.22%) Business Intelligence Analyst
3 4 (22.22%) DataStage Developer
3 4 (22.22%) Developer Analyst
3 4 (22.22%) ETL Developer
4 2 (11.11%) SQL BI Developer
4 2 (11.11%) SQL Developer
4 2 (11.11%) SSRS Developer
5 1 (5.56%) DBA
5 1 (5.56%) Microsoft BI Developer
5 1 (5.56%) QlikView Analyst
5 1 (5.56%) QlikView Developer
5 1 (5.56%) SQL DBA
5 1 (5.56%) SSAS Developer
5 1 (5.56%) SSIS Analyst
5 1 (5.56%) SSRS Analyst
Libraries, Frameworks & Software Standards
1 2 (11.11%) MDX
2 1 (5.56%) .NET
2 1 (5.56%) ASP.NET
2 1 (5.56%) HTML
2 1 (5.56%) XML
Miscellaneous
1 8 (44.44%) Analytical Skills
1 8 (44.44%) Data Integration
2 5 (27.78%) Visualisation
3 1 (5.56%) Clustering
Processes & Methodologies
1 18 (100.00%) Business Intelligence
2 5 (27.78%) Data Cleansing
2 5 (27.78%) Data Visualisation
2 5 (27.78%) Dimensional Modelling
2 5 (27.78%) Information Exploitation
3 4 (22.22%) Data Analysis
3 4 (22.22%) Data Management
3 4 (22.22%) Disaster Recovery
3 4 (22.22%) Master Data Management
3 4 (22.22%) Stakeholder Management
3 4 (22.22%) Target Operating Model
4 2 (11.11%) Multidimensional Analysis
5 1 (5.56%) Capacity Planning
5 1 (5.56%) CRM
5 1 (5.56%) Database Security
5 1 (5.56%) Kimball Methodology
5 1 (5.56%) Performance Monitoring
5 1 (5.56%) Performance Tuning
5 1 (5.56%) Server Monitoring
Programming Languages
1 13 (72.22%) SQL
2 6 (33.33%) T-SQL
3 1 (5.56%) JavaScript
Quality Assurance & Compliance
1 4 (22.22%) Data Quality
1 4 (22.22%) QA
Vendors
1 6 (33.33%) Netezza
2 4 (22.22%) Microsoft
3 2 (11.11%) Logi Analytics
4 1 (5.56%) Cognos
4 1 (5.56%) IBM
4 1 (5.56%) Sage
4 1 (5.56%) Talend