Period
to 30 October 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 30 October 2020 with a comparison to the same period in the previous 2 years.

CA ERwin Data Modeler
UK
6 months to
30 Oct 2020
Same period 2019 Same period 2018
Rank 663 997 1084
Rank change year-on-year +334 +87 +64
Permanent jobs citing ERwin 28 68 94
As % of all permanent jobs advertised in the UK 0.056% 0.050% 0.057%
As % of the Development Applications category 0.27% 0.26% 0.29%
Number of salaries quoted 27 51 72
Median annual salary £60,500 £70,000 £66,250
Median salary % change year-on-year -13.57% +5.66% +3.92%
10th Percentile £17,250 £37,560 £42,650
90th Percentile £106,500 £85,000 £85,000
UK excluding London median annual salary £60,000 £44,385 £56,750
% change year-on-year +35.18% -21.79% +6.07%

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 10,493 25,950 32,981
As % of all permanent IT jobs advertised in the UK 21.00% 18.93% 20.05%
Number of salaries quoted 8,673 20,621 26,613
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% -
10th Percentile £35,000 £32,500 £32,500
90th Percentile £82,500 £82,500 £80,000
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

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 30 October 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 30 October 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 +330 28 £60,500 +33.22% 3
UK excluding London +305 21 £60,000 +35.18% 1
Midlands +129 17 £60,000 +33.33%
East Midlands +92 10 £44,250 -1.67%
London +264 7 £120,000 +52.38% 3
West Midlands - 7 £60,000 -
North of England +150 2 £39,000 -9.18%
Work from Home +16 2 £39,000 -
South West - 2 £60,000 -
North East +11 1 £39,000 -9.06%
North West - 1 £75,000 -

For the 6 months to 30 October 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 27 (96.43%) Data Modelling
2 22 (78.57%) Data Warehouse
3 19 (67.86%) Data Architecture
4 16 (57.14%) Logical Data Model
4 16 (57.14%) Physical Data Model
5 15 (53.57%) OLTP
6 14 (50.00%) Big Data
7 13 (46.43%) Degree
8 12 (42.86%) Data Analysis
8 12 (42.86%) Business Intelligence
8 12 (42.86%) OLAP
8 12 (42.86%) Data Governance
8 12 (42.86%) Analytics
9 11 (39.29%) Data Quality
9 11 (39.29%) SQL Server
9 11 (39.29%) Agile Software Development
9 11 (39.29%) Azure
10 10 (35.71%) AWS
10 10 (35.71%) NoSQL
10 10 (35.71%) Data Management
10 10 (35.71%) Oracle
10 10 (35.71%) Analytical Skills
11 9 (32.14%) Metadata Management
11 9 (32.14%) Relational Database
11 9 (32.14%) DevOps
11 9 (32.14%) Data Lake
11 9 (32.14%) ER Studio
11 9 (32.14%) RDBMS
11 9 (32.14%) IBM
12 8 (28.57%) Finance

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 2 (7.14%) Apache Spark
1 2 (7.14%) Oracle SOA Suite
2 1 (3.57%) Apache Pig
2 1 (3.57%) Jupyter
Business Applications
1 6 (21.43%) SAP IS-U
Cloud Services
1 11 (39.29%) Azure
2 10 (35.71%) AWS
3 6 (21.43%) GCP
4 3 (10.71%) Power Platform
4 3 (10.71%) Serverless
5 2 (7.14%) SaaS
6 1 (3.57%) Amazon EMR
6 1 (3.57%) Azure Active Directory
6 1 (3.57%) Azure Data Factory
6 1 (3.57%) Azure Functions
6 1 (3.57%) Azure Machine Learning
6 1 (3.57%) Data Lake Analytics
6 1 (3.57%) IaaS
6 1 (3.57%) Logic Apps
6 1 (3.57%) PaaS
Database & Business Intelligence
1 22 (78.57%) Data Warehouse
2 15 (53.57%) OLTP
3 14 (50.00%) Big Data
4 12 (42.86%) OLAP
5 11 (39.29%) SQL Server
6 10 (35.71%) NoSQL
7 9 (32.14%) Data Lake
7 9 (32.14%) RDBMS
7 9 (32.14%) Relational Database
8 8 (28.57%) IBM InfoSphere
9 7 (25.00%) Hadoop
10 6 (21.43%) Azure SQL Data Warehouse
10 6 (21.43%) MongoDB
10 6 (21.43%) SAP BW
11 4 (14.29%) MySQL
11 4 (14.29%) SQL Server Analysis Services
11 4 (14.29%) SQL Server Reporting Services
12 3 (10.71%) Oracle OLAP
12 3 (10.71%) QlikView
12 3 (10.71%) SQL Server Integration Services
Development Applications
1 9 (32.14%) ER Studio
2 8 (28.57%) PowerDesigner
3 3 (10.71%) Git (software)
4 2 (7.14%) GDB
4 2 (7.14%) Sourcetree
5 1 (3.57%) Jenkins
5 1 (3.57%) SQL Server Management Studio (SSMS)
5 1 (3.57%) Visual Studio
5 1 (3.57%) Visual Studio Code
5 1 (3.57%) Visual Studio Team System
General
1 8 (28.57%) Finance
2 5 (17.86%) Marketing
3 1 (3.57%) Banking
3 1 (3.57%) Manufacturing
3 1 (3.57%) Pharmaceutical
3 1 (3.57%) Retail
Job Titles
1 17 (60.71%) Architect
1 17 (60.71%) Data Architect
2 6 (21.43%) Data Modeller
3 5 (17.86%) Analyst
3 5 (17.86%) Applications Support
3 5 (17.86%) Applications Support Analyst
3 5 (17.86%) Senior Architect
3 5 (17.86%) Senior Data Architect
3 5 (17.86%) Support Analyst
4 4 (14.29%) Trainee
4 4 (14.29%) Trainee Analyst
4 4 (14.29%) Trainee Support Analyst
5 2 (7.14%) Azure Architect
6 1 (3.57%) Analytics Consultant
6 1 (3.57%) Data Engineer
6 1 (3.57%) Digital Architect
6 1 (3.57%) Graduate Analyst
6 1 (3.57%) Graduate Applications Support
6 1 (3.57%) Graduate Applications Support Analyst
6 1 (3.57%) Senior Digital Architect
Libraries, Frameworks & Software Standards
1 4 (14.29%) XML
2 3 (10.71%) FIX Protocol
2 3 (10.71%) JSON
2 3 (10.71%) Kafka
3 2 (7.14%) .NET
4 1 (3.57%) Anaconda
4 1 (3.57%) Apache Tez
4 1 (3.57%) Natural Language Processing
4 1 (3.57%) TensorFlow
Miscellaneous
1 10 (35.71%) Analytical Skills
2 5 (17.86%) Analytical Mindset
3 3 (10.71%) Foreign Exchange (FX)
3 3 (10.71%) Management Information System
3 3 (10.71%) Reference Data
4 2 (7.14%) Hybrid Cloud
4 2 (7.14%) N-Tier
5 1 (3.57%) Data Structures
5 1 (3.57%) Virtual Team
Processes & Methodologies
1 27 (96.43%) Data Modelling
2 19 (67.86%) Data Architecture
3 16 (57.14%) Logical Data Model
3 16 (57.14%) Physical Data Model
4 12 (42.86%) Analytics
4 12 (42.86%) Business Intelligence
4 12 (42.86%) Data Analysis
4 12 (42.86%) Data Governance
5 11 (39.29%) Agile Software Development
6 10 (35.71%) Data Management
7 9 (32.14%) DevOps
7 9 (32.14%) Metadata Management
8 8 (28.57%) Conceptual Models
8 8 (28.57%) Inmon Methodology
8 8 (28.57%) Kimball Methodology
9 7 (25.00%) Test Automation
10 6 (21.43%) Data Integration
10 6 (21.43%) IT Strategy
10 6 (21.43%) RAD
10 6 (21.43%) Waterfall
Programming Languages
1 6 (21.43%) Python
2 5 (17.86%) SQL
3 4 (14.29%) Java
4 2 (7.14%) C#
4 2 (7.14%) JavaScript
4 2 (7.14%) PowerShell
4 2 (7.14%) Scala
4 2 (7.14%) T-SQL
4 2 (7.14%) VB.NET
5 1 (3.57%) C++
5 1 (3.57%) PL/SQL
5 1 (3.57%) R
Qualifications
1 13 (46.43%) Degree
2 8 (28.57%) Master's Degree
3 3 (10.71%) AWS Certification
3 3 (10.71%) Computer Science Degree
Quality Assurance & Compliance
1 11 (39.29%) Data Quality
2 3 (10.71%) GDPR
2 3 (10.71%) QA
3 1 (3.57%) PMO
System Software
1 1 (3.57%) Active Directory
1 1 (3.57%) Docker
Systems Management
1 1 (3.57%) Kubernetes
Vendors
1 10 (35.71%) Oracle
2 9 (32.14%) IBM
3 7 (25.00%) Teradata
4 6 (21.43%) SAP
5 5 (17.86%) Google
6 3 (10.71%) Microsoft
7 2 (7.14%) Actuate
7 2 (7.14%) Cognos
7 2 (7.14%) Databricks
7 2 (7.14%) Netezza
8 1 (3.57%) Informatica
8 1 (3.57%) MuleSoft