Period
to 8 April 2020

The following table provides summary statistics for permanent job vacancies 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 8 April 2020 with a comparison to the same period in the previous 2 years.

CA ERwin Data Modeler
UK
6 months to
8 Apr 2020
Same period 2019 Same period 2018
Rank 923 1020 1101
Rank change year-on-year +97 +81 +18
Permanent jobs citing ERwin 64 90 113
As % of all permanent jobs advertised in the UK 0.055% 0.060% 0.063%
As % of the Development Applications category 0.29% 0.30% 0.31%
Number of salaries quoted 40 73 70
Median annual salary £71,250 £72,500 £62,500
Median salary % change year-on-year -1.72% +16.00% -3.85%
10th Percentile £47,250 £47,500 £51,875
90th Percentile £120,000 £88,750 £84,000
UK excluding London median annual salary £65,000 £60,000 £57,500
% change year-on-year +8.33% +4.35% -4.17%

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 with a requirement for development application skills.

All Development Application Skills
UK
Permanent vacancies with a requirement for development application skills 22,340 29,740 36,862
As % of all permanent IT jobs advertised in the UK 19.30% 19.93% 20.67%
Number of salaries quoted 17,624 23,625 30,223
Median annual salary £55,000 £50,000 £50,000
Median salary % change year-on-year +10.00% - +5.26%
10th Percentile £33,750 £32,000 £31,250
90th Percentile £85,000 £81,250 £76,250
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

ERwin
Job Vacancy Trend

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

Job vacancy trend for ERwin in the UK

ERwin
Salary Trend

3-month moving average salary quoted in jobs citing ERwin.

Salary trend for ERwin in the UK

ERwin
Salary Histogram

Salary distribution for jobs citing ERwin over the 6 months to 8 April 2020.

Salary histogram for ERwin in the UK

ERwin
Top 11 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ERwin within the UK over the 6 months to 8 April 2020. 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
England +118 61 £70,000 -12.50% 4
London +58 31 £100,000 +21.21%
UK excluding London +120 30 £65,000 +8.33% 4
North of England +84 19 £70,000 +40.00%
North East - 13 - -
Midlands +48 9 £45,000 -13.10% 4
East Midlands +34 7 £45,000 - 3
North West - 6 £70,000 -
South East +76 2 £70,000 -4.11%
West Midlands +33 2 £50,500 -2.48% 1
Work from Home +20 2 £70,000 +7.69%

For the 6 months to 8 April 2020, 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 with a requirement for ERwin.

1 64 (100.00%) Data Modelling
2 38 (59.38%) Data Warehouse
3 36 (56.25%) Analytics
4 33 (51.56%) Analytical Skills
5 32 (50.00%) Agile Software Development
6 31 (48.44%) Data Management
6 31 (48.44%) Business Intelligence
7 27 (42.19%) Migration
7 27 (42.19%) Data Governance
8 25 (39.06%) Data Migration
9 23 (35.94%) Data Architecture
9 23 (35.94%) Finance
9 23 (35.94%) NoSQL
9 23 (35.94%) Data Quality
9 23 (35.94%) Big Data
9 23 (35.94%) Power BI
9 23 (35.94%) Power Platform
10 19 (29.69%) ETL
11 18 (28.13%) Oracle
11 18 (28.13%) SQL Server
11 18 (28.13%) AWS
11 18 (28.13%) Relational Database
12 17 (26.56%) MongoDB
12 17 (26.56%) Snowflake Schema
12 17 (26.56%) Python
13 16 (25.00%) BusinessObjects
13 16 (25.00%) QlikView
13 16 (25.00%) Kafka
13 16 (25.00%) Data Analytics
13 16 (25.00%) Amazon DynamoDB

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 4 (6.25%) Apache Spark
2 2 (3.13%) Oracle Spatial
3 1 (1.56%) Apache Airflow
3 1 (1.56%) Oracle SOA Suite
Applications
1 2 (3.13%) Microsoft Excel
1 2 (3.13%) Microsoft PowerPoint
2 1 (1.56%) Microsoft Office
2 1 (1.56%) Microsoft Project
Business Applications
1 2 (3.13%) Sparx Enterprise Architect
2 1 (1.56%) SAP IS-U
Cloud Services
1 23 (35.94%) Power Platform
2 18 (28.13%) AWS
3 9 (14.06%) Azure
4 7 (10.94%) Serverless
5 5 (7.81%) Azure Data Factory
6 4 (6.25%) Amazon Kinesis
6 4 (6.25%) Amazon S3
6 4 (6.25%) AWS Lambda
6 4 (6.25%) Dynamics 365
7 3 (4.69%) Office 365
7 3 (4.69%) SaaS
8 1 (1.56%) GCP
Database & Business Intelligence
1 38 (59.38%) Data Warehouse
2 23 (35.94%) Big Data
2 23 (35.94%) NoSQL
2 23 (35.94%) Power BI
3 18 (28.13%) Relational Database
3 18 (28.13%) SQL Server
4 17 (26.56%) MongoDB
4 17 (26.56%) Snowflake Schema
5 16 (25.00%) Amazon DynamoDB
5 16 (25.00%) BusinessObjects
5 16 (25.00%) QlikView
6 14 (21.88%) OLAP
6 14 (21.88%) OLTP
7 12 (18.75%) Apache Cassandra
7 12 (18.75%) CouchDB
7 12 (18.75%) Oracle OLAP
7 12 (18.75%) RDBMS
8 9 (14.06%) SQL Server Integration Services
9 7 (10.94%) Data Lake
10 6 (9.38%) SQL Server Reporting Services
Development Applications
1 12 (18.75%) PowerDesigner
2 3 (4.69%) ER Studio
2 3 (4.69%) GDB
2 3 (4.69%) Git (software)
2 3 (4.69%) Sourcetree
2 3 (4.69%) SQL Server Management Studio (SSMS)
2 3 (4.69%) Visual Studio
2 3 (4.69%) Visual Studio Code
3 1 (1.56%) ProC
General
1 23 (35.94%) Finance
2 6 (9.38%) Retail
3 2 (3.13%) Public Sector
4 1 (1.56%) Local Government
Job Titles
1 29 (45.31%) Architect
2 28 (43.75%) Data Architect
3 12 (18.75%) Data Modeller
4 7 (10.94%) Analyst
4 7 (10.94%) Designer
4 7 (10.94%) Senior Designer
5 6 (9.38%) Business Intelligence Analyst
5 6 (9.38%) Business Intelligence Data Analyst
5 6 (9.38%) Data Analyst
6 5 (7.81%) Data Engineer
7 4 (6.25%) AWS Architect
7 4 (6.25%) NoSQL Architect
8 3 (4.69%) Big Data Architect
9 2 (3.13%) Business Intelligence Developer
9 2 (3.13%) Consultant
9 2 (3.13%) Data Consultant
9 2 (3.13%) Developer
9 2 (3.13%) Head of Architecture
9 2 (3.13%) Head of Data Architecture
10 1 (1.56%) Solutions Architect
Libraries, Frameworks & Software Standards
1 16 (25.00%) Kafka
2 12 (18.75%) FIX Protocol
2 12 (18.75%) JSON
2 12 (18.75%) XML
3 3 (4.69%) .NET
Miscellaneous
1 33 (51.56%) Analytical Skills
2 15 (23.44%) Data Structures
3 12 (18.75%) Management Information System
3 12 (18.75%) Reference Data
4 9 (14.06%) Foreign Exchange (FX)
5 5 (7.81%) Self-Motivation
6 4 (6.25%) Cloud Native
7 3 (4.69%) N-Tier
8 1 (1.56%) Taxonomies
Processes & Methodologies
1 64 (100.00%) Data Modelling
2 36 (56.25%) Analytics
3 32 (50.00%) Agile Software Development
4 31 (48.44%) Business Intelligence
4 31 (48.44%) Data Management
5 27 (42.19%) Data Governance
5 27 (42.19%) Migration
6 25 (39.06%) Data Migration
7 23 (35.94%) Data Architecture
8 19 (29.69%) ETL
9 16 (25.00%) Data Analytics
10 14 (21.88%) Analytical Thinking
10 14 (21.88%) Critical Thinking
10 14 (21.88%) Data Strategy
11 13 (20.31%) Artificial Intelligence
11 13 (20.31%) Data Development
11 13 (20.31%) Problem-Solving
11 13 (20.31%) Stakeholder Management
12 12 (18.75%) Software Engineering
12 12 (18.75%) Statistics
Programming Languages
1 17 (26.56%) Python
2 12 (18.75%) Java
2 12 (18.75%) SQL
3 5 (7.81%) Scala
4 4 (6.25%) T-SQL
5 3 (4.69%) C#
5 3 (4.69%) JavaScript
5 3 (4.69%) PowerShell
5 3 (4.69%) VB.NET
6 1 (1.56%) ABAP
Qualifications
1 15 (23.44%) Degree
2 12 (18.75%) AWS Certification
2 12 (18.75%) Computer Science Degree
2 12 (18.75%) Master's Degree
Quality Assurance & Compliance
1 23 (35.94%) Data Quality
2 12 (18.75%) QA
3 7 (10.94%) GDPR
4 2 (3.13%) COBIT
Vendors
1 18 (28.13%) Oracle
2 13 (20.31%) Sage
3 11 (17.19%) Microsoft
4 5 (7.81%) Databricks
5 4 (6.25%) BiZZdesign
5 4 (6.25%) IBM
5 4 (6.25%) Tableau
5 4 (6.25%) Teradata
6 3 (4.69%) Informatica
6 3 (4.69%) Netezza
6 3 (4.69%) SAP
7 2 (3.13%) Cognos
7 2 (3.13%) ESRI
7 2 (3.13%) OneTrust
7 2 (3.13%) Salesforce.com
7 2 (3.13%) Sparx
8 1 (1.56%) Ab Initio
8 1 (1.56%) Cloudera
8 1 (1.56%) Hortonworks
8 1 (1.56%) Talend