Period
to 23 May 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 23 May 2018 with a comparison to the same period in the previous 2 years.

CA ERwin Data Modeler
UK > England
6 months to
23 May 2018
Same period 2017 Same period 2016
Rank 1040 1093 1112
Rank change year-on-year +53 +19 +22
Permanent jobs citing ERwin 111 57 144
As % of all permanent IT jobs advertised in England 0.069% 0.036% 0.076%
As % of the Development Applications category 0.33% 0.18% 0.42%
Number of salaries quoted 78 35 126
England median annual salary £62,500 £55,000 £60,250
Median salary % change year-on-year +13.64% -8.71% -19.67%
10th Percentile £52,313 £34,000 £45,000
90th Percentile £87,375 £78,750 £82,500
UK median annual salary £62,500 £60,000 £60,000
% change year-on-year +4.17% - -20.00%

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 33,622 31,807 34,116
As % of all permanent IT jobs advertised in England 20.90% 19.95% 18.07%
Number of salaries quoted 27,460 26,964 29,628
England median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £32,500 £31,000 £30,000
90th Percentile £77,500 £75,000 £71,250
UK median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +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 23 May 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 23 May 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
London +30 66 £65,000 -10.34% 8
North of England +4 20 £57,500 +43.75% 1
South West -4 17 £57,500 +36.90% 1
Yorkshire - 11 £55,500 -
North West -2 9 £82,500 +106.25% 1
South East -12 7 £55,000 -15.38% 6
East Midlands - 1 £50,000 - 1
Midlands - 1 £50,000 - 1
ERwin
UK

For the 6 months to 23 May 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 106 (95.50%) Data Modelling
2 69 (62.16%) SQL
3 68 (61.26%) Data Warehouse
4 51 (45.95%) Logical Data Model
5 49 (44.14%) Data Architecture
6 48 (43.24%) Business Intelligence
7 47 (42.34%) Finance
8 46 (41.44%) SQL Server
9 44 (39.64%) Data Analysis
10 40 (36.04%) Data Integration
11 39 (35.14%) Physical Data Model
12 38 (34.23%) Data Governance
12 38 (34.23%) Migration
13 34 (30.63%) Data Management
14 33 (29.73%) Oracle
15 32 (28.83%) ETL
15 32 (28.83%) Analytical Skills
16 28 (25.23%) SQL Server Integration Services
17 27 (24.32%) Agile Software Development
17 27 (24.32%) Data Quality
18 26 (23.42%) Metadata Management
19 24 (21.62%) Master Data Management
20 23 (20.72%) OLTP
20 23 (20.72%) Informatica
20 23 (20.72%) OLAP
21 22 (19.82%) Dimensional Modelling
21 22 (19.82%) Analytics
22 21 (18.92%) Relational Database
23 19 (17.12%) Visualisation
23 19 (17.12%) Degree

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 11 (9.91%) Apache Spark
2 4 (3.60%) Apache Solr
3 3 (2.70%) Oracle Application Server
3 3 (2.70%) SharePoint
4 1 (0.90%) SAS
Applications
1 10 (9.01%) MS Visio
2 4 (3.60%) Microsoft Excel
3 1 (0.90%) Microsoft PowerPoint
Cloud Services
1 14 (12.61%) Amazon AWS
2 6 (5.41%) Microsoft Azure
3 4 (3.60%) AWS Lambda
3 4 (3.60%) Serverless
4 1 (0.90%) Google Cloud Platform
Communications & Networking
1 5 (4.50%) SMS
Database & Business Intelligence
1 68 (61.26%) Data Warehouse
2 46 (41.44%) SQL Server
3 28 (25.23%) SQL Server Integration Services
4 23 (20.72%) OLAP
4 23 (20.72%) OLTP
5 21 (18.92%) Relational Database
6 18 (16.22%) Hadoop
7 17 (15.32%) Big Data
7 17 (15.32%) MySQL
8 14 (12.61%) SQL Server Reporting Services
9 12 (10.81%) NoSQL
10 11 (9.91%) RDBMS
11 10 (9.01%) DB2
12 9 (8.11%) Geospatial Data
12 9 (8.11%) Oracle OLAP
13 8 (7.21%) Star Schema
14 7 (6.31%) BusinessObjects
14 7 (6.31%) GIS
14 7 (6.31%) Oracle ODI
14 7 (6.31%) PostgreSQL
Development Applications
1 14 (12.61%) ER Studio
2 7 (6.31%) PowerDesigner
3 3 (2.70%) Eclipse
3 3 (2.70%) MagicDraw
3 3 (2.70%) Visual Studio
3 3 (2.70%) XMLSpy
General
1 47 (42.34%) Finance
2 8 (7.21%) Banking
3 6 (5.41%) Retail
4 4 (3.60%) Front Office
4 4 (3.60%) International Banking
5 3 (2.70%) Financial Institution
6 1 (0.90%) Electronics
6 1 (0.90%) Investment Banking
6 1 (0.90%) Manufacturing
6 1 (0.90%) Marketing
6 1 (0.90%) Telecoms
Job Titles
1 51 (45.95%) Architect
2 49 (44.14%) Data Architect
3 30 (27.03%) Data Modeller
4 29 (26.13%) Analyst
5 16 (14.41%) Data Analyst
6 13 (11.71%) Business Analyst
7 10 (9.01%) Business Intelligence Analyst
8 9 (8.11%) Business Intelligence Business Analyst
9 8 (7.21%) Data Warehouse Analyst
9 8 (7.21%) Data Warehouse Business Analyst
10 6 (5.41%) Data Engineer
11 4 (3.60%) Business Data Analyst
11 4 (3.60%) Data Business Analyst
11 4 (3.60%) Senior Architect
11 4 (3.60%) Senior Data Architect
11 4 (3.60%) Solutions Architect
12 3 (2.70%) Financial Analyst
13 2 (1.80%) Database Engineer
13 2 (1.80%) Developer
13 2 (1.80%) Senior Data Warehouse Architect
Libraries, Frameworks & Software Standards
1 7 (6.31%) Oracle GoldenGate
2 3 (2.70%) FpML
3 2 (1.80%) NumPy
3 2 (1.80%) Pandas
3 2 (1.80%) XML
4 1 (0.90%) MDX
4 1 (0.90%) Web Services
Miscellaneous
1 32 (28.83%) Analytical Skills
2 12 (10.81%) Hybrid Cloud
3 11 (9.91%) Data Structures
4 8 (7.21%) Management Information System
5 6 (5.41%) Taxonomies
6 5 (4.50%) Enterprise Software
7 3 (2.70%) Derivative
7 3 (2.70%) Foreign Exchange (FX)
7 3 (2.70%) Reference Data
8 2 (1.80%) Fintech
9 1 (0.90%) User Experience
Operating Systems
1 3 (2.70%) Unix
2 2 (1.80%) Linux
2 2 (1.80%) Windows
Processes & Methodologies
1 106 (95.50%) Data Modelling
2 51 (45.95%) Logical Data Model
3 49 (44.14%) Data Architecture
4 48 (43.24%) Business Intelligence
5 44 (39.64%) Data Analysis
6 40 (36.04%) Data Integration
7 39 (35.14%) Physical Data Model
8 38 (34.23%) Data Governance
8 38 (34.23%) Migration
9 34 (30.63%) Data Management
10 32 (28.83%) ETL
11 27 (24.32%) Agile Software Development
12 26 (23.42%) Metadata Management
13 24 (21.62%) Master Data Management
14 22 (19.82%) Analytics
14 22 (19.82%) Dimensional Modelling
15 19 (17.12%) Data Security
15 19 (17.12%) Visualisation
16 18 (16.22%) Waterfall
17 15 (13.51%) Data Cleansing
Programming Languages
1 69 (62.16%) SQL
2 12 (10.81%) PL/SQL
3 7 (6.31%) T-SQL
4 6 (5.41%) Java
4 6 (5.41%) Python
5 4 (3.60%) Scala
6 2 (1.80%) Bash Shell
6 2 (1.80%) C
6 2 (1.80%) R
7 1 (0.90%) Shell Script
Qualifications
1 19 (17.12%) Degree
2 2 (1.80%) Numerate Degree
Quality Assurance & Compliance
1 27 (24.32%) Data Quality
2 6 (5.41%) QA
3 4 (3.60%) GDPR
4 2 (1.80%) PMO
System Software
1 5 (4.50%) HDFS
Systems Management
1 4 (3.60%) Oozie
Vendors
1 33 (29.73%) Oracle
2 23 (20.72%) Informatica
3 16 (14.41%) Microsoft
4 15 (13.51%) Tableau
5 12 (10.81%) Trillium
6 11 (9.91%) IBM
7 10 (9.01%) Ab Initio
8 9 (8.11%) Cognizant
9 6 (5.41%) Cloudera
9 6 (5.41%) Teradata
10 5 (4.50%) HP
10 5 (4.50%) Talend
10 5 (4.50%) Vertica
11 4 (3.60%) CA
11 4 (3.60%) Salesforce.com
12 2 (1.80%) Casewise
12 2 (1.80%) Embarcadero
13 1 (0.90%) GoldenSource
13 1 (0.90%) Google
13 1 (0.90%) Hyperion