Period
to 20 July 2017

The following table provides summary statistics for contract job vacancies with a requirement for ERwin skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited ERwin over the 6 months to 20 July 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

CA ERwin Data Modeler
UK
6 months to
20 Jul 2017
Same period 2016 Same period 2015
Rank 738 742 652
Rank change year-on-year +4 -90 +88
Contract jobs citing ERwin 104 163 237
As % of all contract IT jobs advertised in the UK 0.11% 0.15% 0.21%
As % of the Development Applications category 0.62% 0.97% 1.59%
Number of daily rates quoted 77 131 174
UK median daily rate £475 £478 £473
Median daily rate % change year-on-year -0.52% +1.06% +11.18%
10th Percentile £360 £313 £340
90th Percentile £615 £775 £588
UK excluding London median daily rate £495 £463 £455
% change year-on-year +7.03% +1.59% +13.81%
Number of hourly rates quoted 0 0 0
UK median hourly rate - - -
UK excluding London median hourly rate - - -

ERwin is in the development application skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for development application skills.

Contract Development Application Skills
UK
Contract job vacancies with a requirement for development application skills 16851 16836 14890
As % of all contract IT job vacancies advertised in the UK 17.70% 15.29% 13.20%
Number of daily rates quoted 11497 11449 9670
UK median daily rate £438 £425 £400
Median daily rate % change year-on-year +2.94% +6.25% +6.67%
10th Percentile £306 £297 £270
90th Percentile £588 £575 £550
UK excluding London median daily rate £400 £388 £363
% change year-on-year +3.23% +6.90% +6.62%
Number of hourly rates quoted 328 293 255
UK median hourly rate £42.50 £42.50 £37.45
Median hourly rate % change year-on-year - +13.48% -0.93%
10th Percentile £28.75 £26.30 £22.80
90th Percentile £57.88 £52.45 £49.01
UK excluding London median hourly rate £42.50 £42.50 £37.50
% change year-on-year - +13.33% -0.79%

ERwin
Job Vacancy Trend

Job postings citing ERwin as a percentage of all IT jobs advertised.

Job vacancy trend for ERwin in the UK

ERwin
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ERwin.

Contractor daily rate trend for ERwin in the UK

ERwin
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing ERwin over the 6 months to 20 July 2017.

Contractor daily rate histogram for ERwin in the UK

ERwin
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing ERwin.

Contractor hourly rate trend for ERwin in the UK

ERwin
Top 15 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ERwin within the UK over the 6 months to 20 July 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -3 91 £475 -5.00% 3
London +54 55 £475 -9.52% 1
UK excluding London -13 49 £495 +7.03% 3
North West +23 19 £550 +10.00%
North of England -6 19 £550 +10.00%
South West +4 7 £498 +4.74%
Wales - 7 £500 -
Scotland +46 6 £450 +12.50% 1
South East +33 5 £440 -2.22% 1
Midlands +22 3 £475 +5.56% 1
North East +30 2 £610 +74.29%
East Midlands -5 2 £475 +5.56% 1
Yorkshire -8 2 £610 -12.86%
East of England -10 2 £425 +11.48%
West Midlands - 1 - -

For the 6 months to 20 July 2017, IT contractor jobs citing ERwin also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for ERwin.

1 94 (90.38%) Data Modelling
2 56 (53.85%) Oracle
3 51 (49.04%) ETL
4 50 (48.08%) SQL
5 45 (43.27%) Data Warehouse
6 42 (40.38%) Finance
7 34 (32.69%) Informatica
8 32 (30.77%) Data Management
9 31 (29.81%) Data Architecture
9 31 (29.81%) Data Quality
10 30 (28.85%) Analytics
11 29 (27.88%) Agile Software Development
12 27 (25.96%) Physical Data Model
13 26 (25.00%) Migration
13 26 (25.00%) Business Intelligence
14 25 (24.04%) Banking
14 25 (24.04%) Data Migration
15 24 (23.08%) Logical Data Model
16 23 (22.12%) Data Analysis
16 23 (22.12%) Teradata
17 21 (20.19%) Hadoop
18 20 (19.23%) XML
18 20 (19.23%) Relational Database
19 19 (18.27%) Talend
19 19 (18.27%) SQL Server
19 19 (18.27%) Linux
19 19 (18.27%) Talend Open Studio
19 19 (18.27%) Data Integration
20 18 (17.31%) IBM
21 17 (16.35%) DB2

ERwin
Co-occurring IT Skills 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 11 (10.58%) SAS
2 9 (8.65%) WebLogic
3 8 (7.69%) Oracle SOA Suite
4 3 (2.88%) Confluence
4 3 (2.88%) FileNet
4 3 (2.88%) Oracle Coherence
4 3 (2.88%) Tomcat
5 2 (1.92%) Apache Solr
5 2 (1.92%) IIS
6 1 (0.96%) Apache Spark
Applications
1 8 (7.69%) Microsoft Excel
2 7 (6.73%) Microsoft Office
3 2 (1.92%) S-PLUS
Cloud Services
1 12 (11.54%) Amazon AWS
2 4 (3.85%) AWS Elastic Beanstalk
Communications & Networking
1 1 (0.96%) Internet
Database & Business Intelligence
1 45 (43.27%) Data Warehouse
2 21 (20.19%) Hadoop
3 20 (19.23%) Relational Database
4 19 (18.27%) SQL Server
5 17 (16.35%) DB2
6 12 (11.54%) BusinessObjects
6 12 (11.54%) RDBMS
7 11 (10.58%) SQL Server Integration Services
8 10 (9.62%) DataStage
9 9 (8.65%) Big Data
9 9 (8.65%) IBM InfoSphere
9 9 (8.65%) MarkLogic
9 9 (8.65%) SQL Server Reporting Services
10 8 (7.69%) MS Access
10 8 (7.69%) MySQL
11 7 (6.73%) QlikView
12 6 (5.77%) Data Lake
12 6 (5.77%) NoSQL
13 5 (4.81%) Enterprise Data Warehouse
13 5 (4.81%) Star Schema
Development Applications
1 19 (18.27%) Talend Open Studio
2 10 (9.62%) PowerDesigner
3 7 (6.73%) JIRA
4 6 (5.77%) Ant
5 4 (3.85%) gulp
5 4 (3.85%) Jenkins
5 4 (3.85%) Mocha
5 4 (3.85%) SonarQube
6 3 (2.88%) ClearCase
6 3 (2.88%) Log4Net
6 3 (2.88%) MagicDraw
6 3 (2.88%) NUnit
6 3 (2.88%) PowerBuilder
6 3 (2.88%) Subversion
6 3 (2.88%) Toad
7 1 (0.96%) Eclipse
7 1 (0.96%) SQL Server Management Studio (SSMS)
7 1 (0.96%) Visual Studio
7 1 (0.96%) XMLSpy
General
1 42 (40.38%) Finance
2 25 (24.04%) Banking
3 17 (16.35%) Investment Banking
4 10 (9.62%) Legal
5 9 (8.65%) Back Office
5 9 (8.65%) Retail
6 4 (3.85%) Financial Institution
7 3 (2.88%) Advertising
8 1 (0.96%) Front Office
8 1 (0.96%) Marketing
8 1 (0.96%) Pharmaceutical
8 1 (0.96%) Telecoms
8 1 (0.96%) Wholesale Banking
Job Titles
1 36 (34.62%) Architect
2 33 (31.73%) Data Architect
3 28 (26.92%) Data Modeller
4 27 (25.96%) Analyst
5 22 (21.15%) Data Analyst
6 19 (18.27%) Developer
7 6 (5.77%) Applications Developer
7 6 (5.77%) Java Applications Developer
7 6 (5.77%) Java Developer
8 5 (4.81%) Business Intelligence Architect
8 5 (4.81%) Consultant
8 5 (4.81%) SQL Analyst
9 4 (3.85%) Big Data Analyst
9 4 (3.85%) Business Intelligence Analyst
9 4 (3.85%) Data Consultant
9 4 (3.85%) Financial Analyst
9 4 (3.85%) Information Architect
9 4 (3.85%) Service Analyst
9 4 (3.85%) SQL Data Analyst
9 4 (3.85%) Teradata Architect
Libraries, Frameworks & Software Standards
1 20 (19.23%) XML
2 12 (11.54%) XML Messaging
3 10 (9.62%) CSS
3 10 (9.62%) HTML
3 10 (9.62%) J2EE
3 10 (9.62%) Node.js
3 10 (9.62%) React
3 10 (9.62%) XML Schema
4 9 (8.65%) JSP
5 6 (5.77%) AngularJS
5 6 (5.77%) EJB
5 6 (5.77%) JMS
5 6 (5.77%) JSTL
5 6 (5.77%) Servlets
5 6 (5.77%) SOAP
5 6 (5.77%) Spring
5 6 (5.77%) Spring MVC
6 4 (3.85%) Redux
6 4 (3.85%) Web Services
7 3 (2.88%) XSD
Miscellaneous
1 16 (15.38%) Analytical Skills
2 9 (8.65%) SWIFT
3 5 (4.81%) Data Structures
3 5 (4.81%) Management Information System
4 4 (3.85%) Fixed Income
5 3 (2.88%) Foreign Exchange (FX)
5 3 (2.88%) Reference Data
5 3 (2.88%) Virtual Team
6 2 (1.92%) Enterprise Software
6 2 (1.92%) Mainframe
6 2 (1.92%) Taxonomies
7 1 (0.96%) Derivative
7 1 (0.96%) Equities
7 1 (0.96%) Linked Data
7 1 (0.96%) Social Media
Operating Systems
1 19 (18.27%) Linux
2 12 (11.54%) Unix
3 9 (8.65%) Windows
4 3 (2.88%) Solaris
Processes & Methodologies
1 94 (90.38%) Data Modelling
2 51 (49.04%) ETL
3 32 (30.77%) Data Management
4 31 (29.81%) Data Architecture
5 30 (28.85%) Analytics
6 29 (27.88%) Agile Software Development
7 27 (25.96%) Physical Data Model
8 26 (25.00%) Business Intelligence
8 26 (25.00%) Migration
9 25 (24.04%) Data Migration
10 24 (23.08%) Logical Data Model
11 23 (22.12%) Data Analysis
12 19 (18.27%) Data Integration
13 17 (16.35%) Data Analytics
14 15 (14.42%) Master Data Management
15 13 (12.50%) Metadata Management
15 13 (12.50%) SOA
16 12 (11.54%) Open Source
16 12 (11.54%) TOGAF
16 12 (11.54%) Translating Business Requirements
Programming Languages
1 50 (48.08%) SQL
2 12 (11.54%) Java
3 10 (9.62%) JavaScript
4 8 (7.69%) Python
5 5 (4.81%) C
5 5 (4.81%) PL/SQL
5 5 (4.81%) Shell Script
6 4 (3.85%) ECMAScript
6 4 (3.85%) ES6
7 3 (2.88%) C#
7 3 (2.88%) C++
7 3 (2.88%) Perl
7 3 (2.88%) T-SQL
8 2 (1.92%) MATLAB
8 2 (1.92%) R
9 1 (0.96%) COBOL
9 1 (0.96%) SPARQL
9 1 (0.96%) VB
9 1 (0.96%) VBA
Qualifications
1 10 (9.62%) OCPJP
2 6 (5.77%) Degree
3 1 (0.96%) CTC Cleared
3 1 (0.96%) Oracle Certification
3 1 (0.96%) Security Cleared
Quality Assurance & Compliance
1 31 (29.81%) Data Quality
2 10 (9.62%) ISO 20022
3 3 (2.88%) QA
4 2 (1.92%) GDPR
5 1 (0.96%) Disclosure Scotland
5 1 (0.96%) MiFID
5 1 (0.96%) Solvency II
Vendors
1 56 (53.85%) Oracle
2 34 (32.69%) Informatica
3 23 (22.12%) Teradata
4 19 (18.27%) Talend
5 18 (17.31%) IBM
6 11 (10.58%) Tableau
7 10 (9.62%) MicroStrategy
8 9 (8.65%) Ab Initio
8 9 (8.65%) Netezza
9 8 (7.69%) Bloomberg
9 8 (7.69%) Reuters
10 7 (6.73%) Alteryx
10 7 (6.73%) Microsoft
11 5 (4.81%) Embarcadero
12 4 (3.85%) CA
13 3 (2.88%) Cognos
13 3 (2.88%) Infragistics
13 3 (2.88%) Sun
13 3 (2.88%) Sybase
14 2 (1.92%) Hyperion