Period
to 18 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Crawley 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 18 November 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
West Sussex > Crawley
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 59 39 89
Rank change year-on-year -20 +50 -29
Permanent jobs citing ETL 15 66 13
As % of all permanent IT jobs advertised in Crawley 2.24% 6.48% 1.54%
As % of the Processes & Methodologies category 2.61% 7.14% 1.75%
Number of salaries quoted 15 71 13
Crawley median annual salary £60,000 £55,000 £57,500
Median salary % change year-on-year +9.09% -4.35% +30.68%
10th Percentile £48,500 £45,500 £40,500
90th Percentile £65,000 £66,000 £72,550
West Sussex median annual salary £54,500 £55,000 £50,000
% change year-on-year -0.91% +10.00% -14.53%

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 Crawley with a requirement for process or methodology skills.

All Process and Methodology Skills
Crawley
Permanent vacancies with a requirement for process or methodology skills 575 925 741
As % of all permanent IT jobs advertised in Crawley 85.95% 90.78% 88.00%
Number of salaries quoted 504 883 671
Crawley median annual salary £42,500 £47,500 £45,000
Median salary % change year-on-year -10.53% +5.56% +5.88%
10th Percentile £27,500 £30,000 £28,750
90th Percentile £58,750 £67,500 £60,000
West Sussex median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% +2.41%

ETL
Job Vacancy Trend in Crawley

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

Job vacancy trend for ETL in Crawley

ETL
Salary Trend in Crawley

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

Salary trend for ETL in Crawley

ETL
Salary Histogram in Crawley

The salary distribution of IT jobs citing ETL in Crawley over the 6 months to 18 November 2017.

Salary histogram for ETL in Crawley

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

1 12 (80.00%) Business Intelligence
2 10 (66.67%) SQL
2 10 (66.67%) OLAP
3 8 (53.33%) SQL Server
3 8 (53.33%) Data Warehouse
4 6 (40.00%) Data Modelling
4 6 (40.00%) SQL Server Integration Services
5 5 (33.33%) PRINCE2
5 5 (33.33%) SQL Server 2008
5 5 (33.33%) Information Architecture
5 5 (33.33%) Analytics
5 5 (33.33%) OLAP Cube
5 5 (33.33%) ETL Development
5 5 (33.33%) SQL Server 2014
6 4 (26.67%) Master Data Management
6 4 (26.67%) Data Architecture
6 4 (26.67%) Microsoft Azure
6 4 (26.67%) Microsoft Project
6 4 (26.67%) Microsoft Excel
6 4 (26.67%) PMI
6 4 (26.67%) PMI Certification
6 4 (26.67%) Microsoft PowerPoint
6 4 (26.67%) Data Management
6 4 (26.67%) Document Management
6 4 (26.67%) Project Management
6 4 (26.67%) Finance
7 3 (20.00%) Management Information System
7 3 (20.00%) Data Analysis
7 3 (20.00%) T-SQL
7 3 (20.00%) .NET

ETL
Co-occurring IT Skills in Crawley 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 1 (6.67%) BizTalk Server
Applications
1 4 (26.67%) Microsoft Excel
1 4 (26.67%) Microsoft PowerPoint
1 4 (26.67%) Microsoft Project
Business Applications
1 1 (6.67%) SAP CRM
Cloud Services
1 4 (26.67%) Microsoft Azure
Communications & Networking
1 1 (6.67%) Internet
Database & Business Intelligence
1 10 (66.67%) OLAP
2 8 (53.33%) Data Warehouse
2 8 (53.33%) SQL Server
3 6 (40.00%) SQL Server Integration Services
4 5 (33.33%) OLAP Cube
4 5 (33.33%) SQL Server 2008
4 5 (33.33%) SQL Server 2014
5 3 (20.00%) Power BI
5 3 (20.00%) SQL Server Analysis Services
6 2 (13.33%) Oracle Database
6 2 (13.33%) Oracle Database 10g
6 2 (13.33%) Oracle Reports
6 2 (13.33%) SQL Server 2012
6 2 (13.33%) SQL Server 2016
6 2 (13.33%) Star Schema
7 1 (6.67%) Big Data
7 1 (6.67%) BusinessObjects
7 1 (6.67%) OLTP
7 1 (6.67%) SAP BW
7 1 (6.67%) SQL Server Reporting Services
Development Applications
1 2 (13.33%) Oracle APEX
1 2 (13.33%) Oracle Forms
2 1 (6.67%) SQL Server Management Studio (SSMS)
General
1 4 (26.67%) Finance
2 2 (13.33%) Back Office
2 2 (13.33%) Retail
3 1 (6.67%) Advertising
Job Titles
1 5 (33.33%) Business Intelligence Lead
2 4 (26.67%) Business Intelligence Manager
2 4 (26.67%) Business Intelligence Project Manager
2 4 (26.67%) Developer
2 4 (26.67%) Project Manager
3 3 (20.00%) DBA
3 3 (20.00%) SQL DBA
3 3 (20.00%) Technical Manager
3 3 (20.00%) Technical Project Manager
4 2 (13.33%) Business Intelligence Developer
4 2 (13.33%) Oracle Developer
4 2 (13.33%) SQL BI Developer
4 2 (13.33%) SQL Developer
4 2 (13.33%) SQL Server BI Developer
4 2 (13.33%) SQL Server DBA
4 2 (13.33%) SQL Server Developer
5 1 (6.67%) Administrator
5 1 (6.67%) Database Developer
5 1 (6.67%) Oracle Database Developer
5 1 (6.67%) Solutions Architect
Libraries, Frameworks & Software Standards
1 3 (20.00%) .NET
2 2 (13.33%) AngularJS
2 2 (13.33%) CSS
2 2 (13.33%) HTML
3 1 (6.67%) WPF
Miscellaneous
1 4 (26.67%) PMI
2 3 (20.00%) Analytical Skills
2 3 (20.00%) Management Information System
3 1 (6.67%) Enterprise Software
3 1 (6.67%) Internet of Things
Operating Systems
1 2 (13.33%) Unix
Processes & Methodologies
1 12 (80.00%) Business Intelligence
2 6 (40.00%) Data Modelling
3 5 (33.33%) Analytics
3 5 (33.33%) ETL Development
3 5 (33.33%) Information Architecture
3 5 (33.33%) PRINCE2
4 4 (26.67%) Data Architecture
4 4 (26.67%) Data Management
4 4 (26.67%) Document Management
4 4 (26.67%) Master Data Management
4 4 (26.67%) Project Management
5 3 (20.00%) Data Analysis
5 3 (20.00%) Performance Tuning
5 3 (20.00%) Portfolio Management
6 2 (13.33%) Agile Software Development
6 2 (13.33%) Dimensional Modelling
6 2 (13.33%) Stakeholder Management
7 1 (6.67%) CRM
7 1 (6.67%) Disaster Recovery
7 1 (6.67%) SOA
Programming Languages
1 10 (66.67%) SQL
2 3 (20.00%) C#
2 3 (20.00%) T-SQL
3 2 (13.33%) JavaScript
3 2 (13.33%) PL/SQL
3 2 (13.33%) Shell Script
3 2 (13.33%) VB.NET
4 1 (6.67%) PowerShell
Qualifications
1 4 (26.67%) PMI Certification
Quality Assurance & Compliance
1 1 (6.67%) COBIT
Vendors
1 2 (13.33%) Microsoft
1 2 (13.33%) Oracle
2 1 (6.67%) SAP