Period
to 19 August 2018

The following table provides summary statistics for permanent job vacancies advertised in England with a requirement for ERwin skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ERwin over the 6 months to 19 August 2018 with a comparison to the same period in the previous 2 years.

CA ERwin Data Modeler
UK > England
6 months to
19 Aug 2018
Same period 2017 Same period 2016
Rank 1050 1093 1159
Rank change year-on-year +43 +66 -57
Permanent jobs citing ERwin 96 65 91
As % of all permanent IT jobs advertised in England 0.061% 0.039% 0.049%
As % of the Development Applications category 0.30% 0.19% 0.27%
Number of salaries quoted 72 47 67
England median annual salary £63,750 £52,500 £65,000
Median salary % change year-on-year +21.43% -19.23% -3.70%
10th Percentile £47,500 £34,000 £46,550
90th Percentile £86,250 £87,500 £83,000
UK median annual salary £65,000 £53,500 £65,000
% change year-on-year +21.50% -17.69% -3.70%

ERwin is in the Development Applications category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in England with a requirement for development application skills.

All Development Application Skills
England
Permanent vacancies with a requirement for development application skills 32,300 34,350 33,779
As % of all permanent IT jobs advertised in England 20.47% 20.63% 18.18%
Number of salaries quoted 26,364 28,435 29,611
England median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% +5.56%
10th Percentile £32,500 £31,250 £30,000
90th Percentile £79,500 £75,000 £73,750
UK median annual salary £50,000 £48,625 £47,500
% change year-on-year +2.83% +2.37% +5.56%

ERwin
Job Vacancy Trend in England

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

Job vacancy trend for ERwin in England

ERwin
Salary Trend in England

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

Salary trend for ERwin in England

ERwin
Salary Histogram in England

The salary distribution of IT jobs citing ERwin in England over the 6 months to 19 August 2018.

Salary histogram for ERwin in England

ERwin
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ERwin within the England region over the 6 months to 19 August 2018. 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
North of England +39 39 £56,000 +40.00% 1
London +44 36 £70,750 -5.67% 8
Yorkshire +56 25 £54,250 +3.33% 1
South East +24 14 £70,000 +86.67% 3
North West +19 14 £80,000 +110.53%
South West +13 6 £50,000 +19.05% 1
Midlands +23 1 £50,000 -18.37%
East Midlands +6 1 £50,000 -9.09%
ERwin
UK

For the 6 months to 19 August 2018, IT jobs citing ERwin also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the England region with a requirement for ERwin.

1 90 (93.75%) Data Modelling
2 71 (73.96%) SQL
3 60 (62.50%) Data Warehouse
4 50 (52.08%) Business Intelligence
4 50 (52.08%) Data Architecture
5 42 (43.75%) SQL Server
5 42 (43.75%) Logical Data Model
6 41 (42.71%) Data Analysis
7 40 (41.67%) Data Integration
8 39 (40.63%) Finance
8 39 (40.63%) Data Management
9 38 (39.58%) Oracle
10 37 (38.54%) Physical Data Model
11 36 (37.50%) Data Governance
12 34 (35.42%) Migration
13 30 (31.25%) SQL Server Integration Services
14 29 (30.21%) Agile Software Development
14 29 (30.21%) Metadata Management
15 27 (28.13%) Data Quality
15 27 (28.13%) ETL
16 25 (26.04%) OLTP
17 24 (25.00%) Analytics
17 24 (25.00%) Relational Database
18 23 (23.96%) OLAP
19 21 (21.88%) Data Security
19 21 (21.88%) Analytical Skills
19 21 (21.88%) Master Data Management
19 21 (21.88%) Hadoop
20 20 (20.83%) Trillium
21 19 (19.79%) PowerDesigner

ERwin
Co-occurring IT Skills in England 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 15 (15.63%) Apache Spark
2 7 (7.29%) Apache Solr
3 4 (4.17%) SharePoint
4 1 (1.04%) SAS
Applications
1 8 (8.33%) MS Visio
2 1 (1.04%) Microsoft Excel
Cloud Services
1 16 (16.67%) Amazon AWS
2 10 (10.42%) Microsoft Azure
3 7 (7.29%) AWS Lambda
3 7 (7.29%) Serverless
4 2 (2.08%) Google Cloud Platform
5 1 (1.04%) Azure Data Factory
Database & Business Intelligence
1 60 (62.50%) Data Warehouse
2 42 (43.75%) SQL Server
3 30 (31.25%) SQL Server Integration Services
4 25 (26.04%) OLTP
5 24 (25.00%) Relational Database
6 23 (23.96%) OLAP
7 21 (21.88%) Hadoop
8 19 (19.79%) Big Data
9 18 (18.75%) MySQL
9 18 (18.75%) SQL Server Reporting Services
10 16 (16.67%) RDBMS
11 14 (14.58%) Oracle ODI
12 13 (13.54%) NoSQL
12 13 (13.54%) SAP Data Services
13 11 (11.46%) Oracle Database
14 10 (10.42%) SQL Server Analysis Services
15 9 (9.38%) DB2
15 9 (9.38%) Enterprise Data Warehouse
16 8 (8.33%) BusinessObjects
16 8 (8.33%) PostgreSQL
Development Applications
1 19 (19.79%) PowerDesigner
2 14 (14.58%) ER Studio
3 4 (4.17%) Eclipse
3 4 (4.17%) RStudio
3 4 (4.17%) Visual Studio
3 4 (4.17%) XMLSpy
4 3 (3.13%) MagicDraw
General
1 39 (40.63%) Finance
2 7 (7.29%) Banking
3 5 (5.21%) Retail
4 4 (4.17%) Financial Institution
4 4 (4.17%) International Banking
5 3 (3.13%) Front Office
6 1 (1.04%) Pharmaceutical
Job Titles
1 40 (41.67%) Architect
2 36 (37.50%) Data Architect
3 30 (31.25%) Analyst
4 29 (30.21%) Data Modeller
5 17 (17.71%) Data Analyst
6 11 (11.46%) Business Analyst
7 10 (10.42%) Business Intelligence Analyst
8 9 (9.38%) Business Intelligence Business Analyst
8 9 (9.38%) Data Engineer
8 9 (9.38%) Data Warehouse Analyst
9 8 (8.33%) Data Warehouse Business Analyst
10 7 (7.29%) Data Business Analyst
11 6 (6.25%) Solutions Architect
12 4 (4.17%) Senior Architect
12 4 (4.17%) Senior Data Architect
13 3 (3.13%) Big Data Engineer
13 3 (3.13%) Business Data Analyst
14 2 (2.08%) Business Requirements Analyst
14 2 (2.08%) Designer
14 2 (2.08%) SQL Analyst
Libraries, Frameworks & Software Standards
1 14 (14.58%) Oracle GoldenGate
2 3 (3.13%) FpML
2 3 (3.13%) Kafka
3 2 (2.08%) NumPy
3 2 (2.08%) Pandas
4 1 (1.04%) RESTful
4 1 (1.04%) SOAP
Miscellaneous
1 21 (21.88%) Analytical Skills
2 13 (13.54%) Hybrid Cloud
3 10 (10.42%) Management Information System
4 8 (8.33%) Enterprise Software
5 6 (6.25%) Data Structures
6 4 (4.17%) Reference Data
7 3 (3.13%) Derivative
7 3 (3.13%) Foreign Exchange (FX)
7 3 (3.13%) Greenfield Project
8 2 (2.08%) Fintech
9 1 (1.04%) Computer Science
Operating Systems
1 3 (3.13%) Unix
1 3 (3.13%) Windows
2 2 (2.08%) Linux
Processes & Methodologies
1 90 (93.75%) Data Modelling
2 50 (52.08%) Business Intelligence
2 50 (52.08%) Data Architecture
3 42 (43.75%) Logical Data Model
4 41 (42.71%) Data Analysis
5 40 (41.67%) Data Integration
6 39 (40.63%) Data Management
7 37 (38.54%) Physical Data Model
8 36 (37.50%) Data Governance
9 34 (35.42%) Migration
10 29 (30.21%) Agile Software Development
10 29 (30.21%) Metadata Management
11 27 (28.13%) ETL
12 24 (25.00%) Analytics
13 21 (21.88%) Data Security
13 21 (21.88%) Master Data Management
14 17 (17.71%) Data Transformation
15 15 (15.63%) Decision-Making
16 14 (14.58%) Data Strategy
17 13 (13.54%) Digital Transformation Programme
Programming Languages
1 71 (73.96%) SQL
2 9 (9.38%) PL/SQL
2 9 (9.38%) Python
3 7 (7.29%) Java
3 7 (7.29%) Scala
4 6 (6.25%) T-SQL
5 3 (3.13%) C
5 3 (3.13%) R
6 2 (2.08%) Bash Shell
7 1 (1.04%) Shell Script
Qualifications
1 8 (8.33%) Degree
2 1 (1.04%) Numerate Degree
Quality Assurance & Compliance
1 27 (28.13%) Data Quality
2 6 (6.25%) QA
3 2 (2.08%) GCP
System Software
1 7 (7.29%) HDFS
Systems Management
1 5 (5.21%) Oozie
Vendors
1 38 (39.58%) Oracle
2 20 (20.83%) Trillium
3 16 (16.67%) IBM
3 16 (16.67%) Informatica
3 16 (16.67%) Microsoft
4 15 (15.63%) Tableau
5 9 (9.38%) Cognizant
5 9 (9.38%) Talend
6 8 (8.33%) Cloudera
7 6 (6.25%) Ab Initio
7 6 (6.25%) Teradata
8 5 (5.21%) Salesforce.com
9 4 (4.17%) MicroStrategy
10 3 (3.13%) Casewise
11 2 (2.08%) HP
11 2 (2.08%) Vertica
12 1 (1.04%) CA
12 1 (1.04%) Embarcadero
12 1 (1.04%) Guidewire