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

3 months to
19 Feb 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
West Midlands / Staffordshire
Rank 57 43 64
Rank change year-on-year
-14 +21
Permanent jobs citing ETL 7 24 6
As % of all permanent IT jobs located in Staffordshire 1.49% 3.86% 1.10%
As % of the Processes & Methodologies category 1.61% 4.41% 1.34%
Number of salaries quoted 7 23 4
Median salary £37,500 £47,500 £45,500
Median salary % change year-on-year
-21.05% +4.39%
90% offered a salary of more than £34,000 £35,000 £36,250
10% offered a salary of more than £45,000 £76,500 £47,050
UK excluding London median salary £45,000 £45,000 £44,500
% change year-on-year
- +1.12%

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
436 544 447
As % of all permanent IT jobs located in Staffordshire 92.57% 87.46% 82.32%
Number of salaries quoted 357 496 391
Median salary £40,000 £40,000 £40,000
90% offered a salary of more than £31,000 £28,550 £29,600
10% offered a salary of more than £57,500 £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
Salary Histogram in Staffordshire

This chart provides a salary histogram for IT jobs citing ETL across the Staffordshire region over the 3 months to 19 February 2017.

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 19 February 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 +4 3 £37,500 +7.14%
Stoke-on-Trent -3 2 £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 February 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 15 (93.75%) SQL
1 15 (93.75%) Business Intelligence
2 12 (75.00%) SQL Server Integration Services
3 11 (68.75%) SQL Server Reporting Services
4 9 (56.25%) Data Warehouse
5 8 (50.00%) T-SQL
5 8 (50.00%) SQL Server
5 8 (50.00%) SQL Server Analysis Services
6 6 (37.50%) Analytical Skills
7 5 (31.25%) Data Integration
7 5 (31.25%) QlikView
7 5 (31.25%) Data Analysis
7 5 (31.25%) Retail
7 5 (31.25%) MS Excel
8 4 (25.00%) DataStage
8 4 (25.00%) Microsoft
8 4 (25.00%) SQL Server 2005
8 4 (25.00%) QA
8 4 (25.00%) Target Operating Model
9 3 (18.75%) Data Mining
9 3 (18.75%) Visual Studio
10 2 (12.50%) OLAP
10 2 (12.50%) IIS
10 2 (12.50%) MS Office
10 2 (12.50%) Star Schema
10 2 (12.50%) Multidimensional Analysis
10 2 (12.50%) Netezza
10 2 (12.50%) MDX
10 2 (12.50%) Dimensional Modelling
10 2 (12.50%) Data Cleansing

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 (12.50%) IIS
1 2 (12.50%) SharePoint
1 2 (12.50%) SharePoint Server
Applications
1 5 (31.25%) MS Excel
2 2 (12.50%) MS Office
Business Applications
1 1 (6.25%) Dynamics CRM
Cloud Services
1 2 (12.50%) Microsoft Azure
Database & Business Intelligence
1 12 (75.00%) SQL Server Integration Services
2 11 (68.75%) SQL Server Reporting Services
3 9 (56.25%) Data Warehouse
4 8 (50.00%) SQL Server
4 8 (50.00%) SQL Server Analysis Services
5 5 (31.25%) QlikView
6 4 (25.00%) DataStage
6 4 (25.00%) SQL Server 2005
7 3 (18.75%) Data Mining
8 2 (12.50%) OLAP
8 2 (12.50%) Power BI
8 2 (12.50%) SQL Server 2008
8 2 (12.50%) SQL Server 2012
8 2 (12.50%) Star Schema
9 1 (6.25%) DB2
9 1 (6.25%) Microsoft Analysis Services
9 1 (6.25%) MySQL
9 1 (6.25%) NoSQL
Development Applications
1 3 (18.75%) Visual Studio
2 2 (12.50%) Team Foundation Server
3 1 (6.25%) Visual Studio Team System
General
1 5 (31.25%) Retail
2 1 (6.25%) Billing
2 1 (6.25%) Marketing
Job Titles
1 14 (87.50%) Business Intelligence Developer
1 14 (87.50%) Developer
2 4 (25.00%) Analyst
2 4 (25.00%) Analyst Developer
2 4 (25.00%) Business Intelligence Analyst
2 4 (25.00%) DataStage Developer
2 4 (25.00%) Developer Analyst
2 4 (25.00%) SSIS Developer
3 3 (18.75%) SQL BI Developer
3 3 (18.75%) SQL Developer
3 3 (18.75%) SSRS Developer
4 2 (12.50%) DBA
4 2 (12.50%) SQL DBA
5 1 (6.25%) Business Developer
5 1 (6.25%) ETL Developer
5 1 (6.25%) Microsoft BI Developer
5 1 (6.25%) QlikView Analyst
5 1 (6.25%) QlikView Developer
5 1 (6.25%) SSIS Analyst
5 1 (6.25%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 2 (12.50%) MDX
2 1 (6.25%) .NET
2 1 (6.25%) ASP.NET
2 1 (6.25%) HTML
2 1 (6.25%) XML
Miscellaneous
1 6 (37.50%) Analytical Skills
2 5 (31.25%) Data Integration
3 2 (12.50%) Clustering
3 2 (12.50%) Visualisation
Processes & Methodologies
1 15 (93.75%) Business Intelligence
2 5 (31.25%) Data Analysis
3 4 (25.00%) Target Operating Model
4 2 (12.50%) Capacity Planning
4 2 (12.50%) Data Cleansing
4 2 (12.50%) Data Management
4 2 (12.50%) Data Visualisation
4 2 (12.50%) Database Security
4 2 (12.50%) Dimensional Modelling
4 2 (12.50%) Information Exploitation
4 2 (12.50%) Multidimensional Analysis
4 2 (12.50%) Performance Monitoring
4 2 (12.50%) Performance Tuning
4 2 (12.50%) Server Monitoring
5 1 (6.25%) CRM
5 1 (6.25%) Data Governance
5 1 (6.25%) Disaster Recovery
5 1 (6.25%) Kimball Methodology
5 1 (6.25%) Master Data Management
5 1 (6.25%) Quality Management
Programming Languages
1 15 (93.75%) SQL
2 8 (50.00%) T-SQL
3 1 (6.25%) JavaScript
Quality Assurance & Compliance
1 4 (25.00%) QA
2 2 (12.50%) Data Quality
Vendors
1 4 (25.00%) Microsoft
2 2 (12.50%) GrapeCity
2 2 (12.50%) InetSoft
2 2 (12.50%) Logi Analytics
2 2 (12.50%) Netezza
3 1 (6.25%) IBM
3 1 (6.25%) Sage