Period
to 21 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Walsall with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 6 months to 21 November 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
West Midlands > Walsall
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 13 18 22
Rank change year-on-year +5 +4 -7
Permanent jobs citing ETL 5 5 15
As % of all permanent IT jobs advertised in Walsall 6.58% 4.63% 7.81%
As % of the Processes & Methodologies category 8.06% 5.10% 9.04%
Number of salaries quoted 5 3 20
Walsall median annual salary £30,000 £37,000 £62,500
Median salary % change year-on-year -18.92% -40.80% +47.06%
10th Percentile £23,150 £36,000 £50,550
90th Percentile £33,100 £41,600 £80,000
West Midlands median annual salary £45,000 £40,500 £41,500
% change year-on-year +11.11% -2.41% -1.19%

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Walsall with a requirement for process or methodology skills.

All Process and Methodology Skills
Walsall
Permanent vacancies with a requirement for process or methodology skills 62 98 166
As % of all permanent IT jobs advertised in Walsall 81.58% 90.74% 86.46%
Number of salaries quoted 55 86 135
Walsall median annual salary £40,000 £35,000 £42,500
Median salary % change year-on-year +14.29% -17.65% +6.92%
10th Percentile £21,400 £22,750 £31,250
90th Percentile £48,250 £46,125 £79,000
West Midlands median annual salary £40,000 £40,000 £40,000

ETL
Job Vacancy Trend in Walsall

Job postings citing ETL as a percentage of all IT jobs advertised in Walsall.

Job vacancy trend for ETL in Walsall

ETL
Salary Trend in Walsall

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

Salary trend for ETL in Walsall

For the 6 months to 21 November 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 Walsall region with a requirement for ETL.

1 5 (100.00%) Data Management
2 4 (80.00%) Business Intelligence
2 4 (80.00%) SQL Server
2 4 (80.00%) Microsoft Excel
2 4 (80.00%) Mathematics
2 4 (80.00%) Relational Database
2 4 (80.00%) Analytical Skills
3 3 (60.00%) Dashboard Development
3 3 (60.00%) Power BI
3 3 (60.00%) Mentoring
3 3 (60.00%) Coaching
3 3 (60.00%) SQL Server Analysis Services
3 3 (60.00%) SQL Server Reporting Services
3 3 (60.00%) SQL Server Integration Services
3 3 (60.00%) OLAP
3 3 (60.00%) Crystal Reports
3 3 (60.00%) C#
4 1 (20.00%) Java
4 1 (20.00%) SQL
4 1 (20.00%) T-SQL
4 1 (20.00%) VBA
4 1 (20.00%) .NET
4 1 (20.00%) Data Warehouse
4 1 (20.00%) Automotive
4 1 (20.00%) Stakeholder Management
4 1 (20.00%) Data Analysis
4 1 (20.00%) Data Structures

ETL
Co-occurring IT Skills in Walsall 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:

Applications
1 4 (80.00%) Microsoft Excel
Database & Business Intelligence
1 4 (80.00%) Relational Database
1 4 (80.00%) SQL Server
2 3 (60.00%) Crystal Reports
2 3 (60.00%) OLAP
2 3 (60.00%) Power BI
2 3 (60.00%) SQL Server Analysis Services
2 3 (60.00%) SQL Server Integration Services
2 3 (60.00%) SQL Server Reporting Services
3 1 (20.00%) Data Warehouse
General
1 1 (20.00%) Automotive
Job Titles
1 5 (100.00%) Analyst
2 4 (80.00%) Business Intelligence Analyst
3 1 (20.00%) Business Analyst
3 1 (20.00%) Junior
3 1 (20.00%) Junior Analyst
3 1 (20.00%) Technical Analyst
3 1 (20.00%) Technical Business Analyst
Libraries, Frameworks & Software Standards
1 1 (20.00%) .NET
Miscellaneous
1 4 (80.00%) Analytical Skills
2 1 (20.00%) Data Structures
Processes & Methodologies
1 5 (100.00%) Data Management
2 4 (80.00%) Business Intelligence
2 4 (80.00%) Mathematics
3 3 (60.00%) Coaching
3 3 (60.00%) Dashboard Development
3 3 (60.00%) Mentoring
4 1 (20.00%) Data Analysis
4 1 (20.00%) Stakeholder Management
Programming Languages
1 3 (60.00%) C#
2 1 (20.00%) Java
2 1 (20.00%) SQL
2 1 (20.00%) T-SQL
2 1 (20.00%) VBA