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

CA ERwin Data Modeler
UK > England
6 months to
18 Feb 2018
Same period 2017 Same period 2016
Rank 1060 1093 1010
Rank change year-on-year +33 -83 +173
Permanent jobs citing ERwin 106 63 239
As % of all permanent IT jobs advertised in England 0.065% 0.038% 0.12%
As % of the Development Applications category 0.32% 0.20% 0.68%
Number of salaries quoted 59 41 206
England median annual salary £62,500 £75,000 £57,500
Median salary % change year-on-year -16.67% +30.43% -11.54%
10th Percentile £49,850 £53,750 £34,750
90th Percentile £75,000 £90,000 £77,500
UK median annual salary £62,500 £75,000 £57,500
% change year-on-year -16.67% +30.43% -11.54%

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,434 31,198 35,357
As % of all permanent IT jobs advertised in England 20.51% 18.93% 17.85%
Number of salaries quoted 27,688 26,815 30,411
England median annual salary £50,000 £47,500 £47,000
Median salary % change year-on-year +5.26% +1.06% +4.44%
10th Percentile £31,250 £30,500 £30,000
90th Percentile £75,000 £72,500 £70,000
UK median annual salary £50,000 £47,500 £45,000
% 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 18 February 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 18 February 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 +10 54 £65,000 -13.33% 5
South West - 27 £55,625 - 3
North of England +14 12 £70,000 +75.00% 1
Yorkshire +27 10 £70,000 -
South East +9 6 £65,000 +6.56% 6
West Midlands - 3 £70,000 -
Midlands - 3 £70,000 -
North West -17 2 £67,500 +68.75%
East of England -2 1 - -
ERwin
UK

For the 6 months to 18 February 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 104 (98.11%) Data Modelling
2 70 (66.04%) Data Warehouse
3 61 (57.55%) Business Intelligence
4 56 (52.83%) SQL
5 54 (50.94%) Finance
6 46 (43.40%) SQL Server
7 43 (40.57%) Migration
8 42 (39.62%) Data Management
9 36 (33.96%) Logical Data Model
10 34 (32.08%) Data Architecture
11 32 (30.19%) Data Governance
11 32 (30.19%) Tableau
11 32 (30.19%) Agile Software Development
11 32 (30.19%) Data Analysis
12 29 (27.36%) ETL
12 29 (27.36%) Visualisation
13 26 (24.53%) Waterfall
13 26 (24.53%) Kimball Methodology
13 26 (24.53%) Analytical Skills
13 26 (24.53%) Degree
14 24 (22.64%) Dimensional Modelling
15 23 (21.70%) Data Integration
16 22 (20.75%) BusinessObjects
17 21 (19.81%) Data Quality
18 19 (17.92%) Analytics
19 18 (16.98%) Physical Data Model
19 18 (16.98%) Inmon Methodology
20 17 (16.04%) SQL Server Integration Services
20 17 (16.04%) Metadata Management
21 16 (15.09%) Master Data Management

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 6 (5.66%) Tomcat
1 6 (5.66%) WebLogic
1 6 (5.66%) WebSphere
2 4 (3.77%) Apache Spark
3 3 (2.83%) Oracle Application Server
4 2 (1.89%) Apache Solr
4 2 (1.89%) SharePoint
5 1 (0.94%) SAS
Applications
1 12 (11.32%) Microsoft Excel
2 4 (3.77%) MS Visio
3 1 (0.94%) Microsoft PowerPoint
Business Applications
1 1 (0.94%) SAP MDG
1 1 (0.94%) SAP MDM
Cloud Services
1 6 (5.66%) Amazon AWS
2 2 (1.89%) AWS Lambda
2 2 (1.89%) Serverless
3 1 (0.94%) Google Cloud Platform
3 1 (0.94%) Microsoft Azure
Communications & Networking
1 5 (4.72%) SMS
Database & Business Intelligence
1 70 (66.04%) Data Warehouse
2 46 (43.40%) SQL Server
3 22 (20.75%) BusinessObjects
4 17 (16.04%) SQL Server Integration Services
5 14 (13.21%) OLAP
6 11 (10.38%) MySQL
6 11 (10.38%) OLTP
7 10 (9.43%) Big Data
8 9 (8.49%) SQL Server Reporting Services
9 7 (6.60%) Qlik Sense
10 6 (5.66%) Hadoop
10 6 (5.66%) IBM InfoSphere
10 6 (5.66%) NoSQL
10 6 (5.66%) Oracle OLAP
10 6 (5.66%) Power BI
10 6 (5.66%) Relational Database
11 5 (4.72%) Amazon Redshift
12 4 (3.77%) Data Lake
12 4 (3.77%) Geospatial Data
12 4 (3.77%) SQL Server Analysis Services
Development Applications
1 4 (3.77%) SQL Server Management Studio (SSMS)
2 3 (2.83%) Visual Studio
3 2 (1.89%) Eclipse
3 2 (1.89%) Toad
3 2 (1.89%) XMLSpy
4 1 (0.94%) Rational Rose
General
1 54 (50.94%) Finance
2 6 (5.66%) Retail
3 3 (2.83%) Banking
4 1 (0.94%) Electronics
4 1 (0.94%) Front Office
4 1 (0.94%) Investment Banking
4 1 (0.94%) Manufacturing
4 1 (0.94%) Marketing
4 1 (0.94%) Telecoms
Job Titles
1 39 (36.79%) Architect
2 38 (35.85%) Analyst
3 32 (30.19%) Data Architect
4 22 (20.75%) Business Analyst
5 20 (18.87%) Data Modeller
6 18 (16.98%) Business Intelligence Analyst
7 16 (15.09%) Data Analyst
8 15 (14.15%) Business Intelligence Business Analyst
9 14 (13.21%) Data Warehouse Analyst
9 14 (13.21%) Data Warehouse Business Analyst
10 11 (10.38%) Financial Analyst
11 7 (6.60%) Data Business Analyst
12 6 (5.66%) Business Finance Analyst
12 6 (5.66%) Finance Business Analyst
12 6 (5.66%) Java Architect
12 6 (5.66%) Java Solutions Architect
12 6 (5.66%) Senior Analyst
12 6 (5.66%) Senior Data Analyst
12 6 (5.66%) Solutions Architect
12 6 (5.66%) Transformation Analyst
Libraries, Frameworks & Software Standards
1 8 (7.55%) XML
2 6 (5.66%) J2EE
2 6 (5.66%) JMS
2 6 (5.66%) JSP
2 6 (5.66%) RESTful
2 6 (5.66%) Servlets
2 6 (5.66%) SOAP
2 6 (5.66%) XSD
2 6 (5.66%) XSLT
3 2 (1.89%) Web Services
4 1 (0.94%) MDX
Miscellaneous
1 26 (24.53%) Analytical Skills
2 8 (7.55%) Enterprise Software
3 7 (6.60%) Data Structures
3 7 (6.60%) User Experience
4 6 (5.66%) AS400
4 6 (5.66%) Computer Science
4 6 (5.66%) Hybrid Cloud
4 6 (5.66%) Taxonomies
5 3 (2.83%) Management Information System
6 2 (1.89%) Reference Data
7 1 (0.94%) Greenfield Project
7 1 (0.94%) Market Risk
Operating Systems
1 6 (5.66%) AIX
1 6 (5.66%) Linux
1 6 (5.66%) Solaris
1 6 (5.66%) Windows
1 6 (5.66%) Windows Server 2003
Processes & Methodologies
1 104 (98.11%) Data Modelling
2 61 (57.55%) Business Intelligence
3 43 (40.57%) Migration
4 42 (39.62%) Data Management
5 36 (33.96%) Logical Data Model
6 34 (32.08%) Data Architecture
7 32 (30.19%) Agile Software Development
7 32 (30.19%) Data Analysis
7 32 (30.19%) Data Governance
8 29 (27.36%) ETL
8 29 (27.36%) Visualisation
9 26 (24.53%) Kimball Methodology
9 26 (24.53%) Waterfall
10 24 (22.64%) Dimensional Modelling
11 23 (21.70%) Data Integration
12 19 (17.92%) Analytics
13 18 (16.98%) Inmon Methodology
13 18 (16.98%) Physical Data Model
14 17 (16.04%) Metadata Management
15 16 (15.09%) Master Data Management
Programming Languages
1 56 (52.83%) SQL
2 8 (7.55%) Java
3 6 (5.66%) JavaScript
3 6 (5.66%) Shell Script
4 5 (4.72%) PL/SQL
5 4 (3.77%) T-SQL
6 2 (1.89%) Python
6 2 (1.89%) Scala
7 1 (0.94%) PowerShell
7 1 (0.94%) SAS Macro
Qualifications
1 26 (24.53%) Degree
2 12 (11.32%) Numerate Degree
Quality Assurance & Compliance
1 21 (19.81%) Data Quality
2 4 (3.77%) GDPR
3 2 (1.89%) PMO
4 1 (0.94%) QA
System Software
1 3 (2.83%) HDFS
Systems Management
1 2 (1.89%) Oozie
2 1 (0.94%) Systems Management Server (SMS)
Vendors
1 32 (30.19%) Tableau
2 16 (15.09%) Oracle
3 15 (14.15%) Informatica
4 11 (10.38%) Ab Initio
5 10 (9.43%) Microsoft
6 6 (5.66%) IBM
7 5 (4.72%) Cognizant
8 4 (3.77%) Talend
9 3 (2.83%) CA
9 3 (2.83%) Cloudera
9 3 (2.83%) Cognos
9 3 (2.83%) HP
9 3 (2.83%) Teradata
9 3 (2.83%) Vertica
10 2 (1.89%) Salesforce.com
10 2 (1.89%) SAP
10 2 (1.89%) Trillium
11 1 (0.94%) Embarcadero
11 1 (0.94%) Google
11 1 (0.94%) Hyperion