Period
to 19 November 2017

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 19 November 2017 with a comparison to the same period in the previous 2 years.

CA ERwin Data Modeler
UK
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 1121 1112 1053
Rank change year-on-year -9 -59 +101
Permanent jobs citing ERwin 77 106 256
As % of all permanent IT jobs advertised in the UK 0.043% 0.056% 0.12%
As % of the Development Applications category 0.21% 0.30% 0.67%
Number of salaries quoted 40 71 216
UK median annual salary £65,000 £70,000 £57,500
Median salary % change year-on-year -7.14% +21.74% +4.55%
10th Percentile £35,200 £55,000 £34,750
90th Percentile £87,500 £82,500 £78,750
UK excluding London median annual salary £57,500 £70,000 £55,000
% change year-on-year -17.86% +27.27% +10.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 with a requirement for development application skills.

All Development Application Skills
UK
Permanent vacancies with a requirement for development application skills 36299 35289 38299
As % of all permanent IT jobs advertised in the UK 20.36% 18.71% 17.52%
Number of salaries quoted 29488 30452 32354
UK median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £31,250 £30,000 £30,000
90th Percentile £75,000 £73,750 £70,000
UK excluding London median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -

ERwin
Job Vacancy Trend

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

Job vacancy trend for ERwin in the UK

ERwin
Salary Trend

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

Salary trend for ERwin in the UK

ERwin
Salary Histogram

The salary distribution of IT jobs citing ERwin over the 6 months to 19 November 2017.

Salary histogram for ERwin in the UK

ERwin
Top 12 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 19 November 2017. 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 +36 71 £65,000 -7.14% 4
UK excluding London +53 48 £57,500 -17.86% 1
London -25 26 £85,000 +17.24% 3
South West +45 17 £42,000 - 1
Yorkshire +33 10 £70,000 -
North of England +8 10 £70,000 +24.44%
Midlands - 8 £65,000 -
South East +55 6 £37,500 -38.52%
Scotland -17 6 £70,000 -6.67%
West Midlands - 6 £67,500 -
East Midlands - 2 £55,000 -
East of England +14 1 - -

For the 6 months to 19 November 2017, IT jobs citing ERwin also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for ERwin.

1 72 (93.51%) Data Modelling
2 52 (67.53%) Business Intelligence
3 43 (55.84%) Data Warehouse
4 38 (49.35%) Data Management
5 35 (45.45%) Finance
5 35 (45.45%) SQL
6 33 (42.86%) BusinessObjects
7 32 (41.56%) SQL Server
8 29 (37.66%) Migration
9 28 (36.36%) ETL
10 27 (35.06%) Data Analysis
11 26 (33.77%) Data Architecture
11 26 (33.77%) Data Quality
12 25 (32.47%) Data Governance
13 22 (28.57%) Logical Data Model
14 21 (27.27%) Tableau
14 21 (27.27%) Agile Software Development
15 20 (25.97%) Analytics
16 18 (23.38%) Oracle
17 17 (22.08%) Visualisation
18 16 (20.78%) Data Migration
19 15 (19.48%) Master Data Management
19 15 (19.48%) SOA
20 14 (18.18%) Kimball Methodology
20 14 (18.18%) Analytical Skills
21 13 (16.88%) Relational Database
21 13 (16.88%) Informatica
21 13 (16.88%) Microsoft Excel
21 13 (16.88%) SQL Server Integration Services
21 13 (16.88%) Enterprise Architecture

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 7 (9.09%) WebSphere
2 6 (7.79%) Tomcat
2 6 (7.79%) WebLogic
3 2 (2.60%) SAS
3 2 (2.60%) SharePoint
4 1 (1.30%) Oracle SOA Suite
4 1 (1.30%) WebSphere Application Server
Applications
1 13 (16.88%) Microsoft Excel
2 1 (1.30%) MS Visio
Business Applications
1 1 (1.30%) SAP Hybris
1 1 (1.30%) SAP MDG
1 1 (1.30%) SAP MDM
Cloud Services
1 1 (1.30%) Amazon AWS
Communications & Networking
1 1 (1.30%) HTTP
1 1 (1.30%) Kerberos
Database & Business Intelligence
1 43 (55.84%) Data Warehouse
2 33 (42.86%) BusinessObjects
3 32 (41.56%) SQL Server
4 13 (16.88%) Relational Database
4 13 (16.88%) SQL Server Integration Services
5 10 (12.99%) NoSQL
5 10 (12.99%) RDBMS
6 9 (11.69%) DataStage
7 8 (10.39%) Big Data
7 8 (10.39%) QlikView
8 7 (9.09%) Hadoop
8 7 (9.09%) Qlik Sense
8 7 (9.09%) SQL Server 2012
9 6 (7.79%) IBM InfoSphere
9 6 (7.79%) MongoDB
10 5 (6.49%) Power BI
10 5 (6.49%) SQL Server 2008
10 5 (6.49%) SQL Server Analysis Services
11 3 (3.90%) Data Mining
11 3 (3.90%) Star Schema
Development Applications
1 9 (11.69%) SQL Server Management Studio (SSMS)
2 4 (5.19%) Toad
2 4 (5.19%) Visual Studio
3 3 (3.90%) MagicDraw
3 3 (3.90%) PowerDesigner
4 2 (2.60%) Eclipse
4 2 (2.60%) Rational Rose
4 2 (2.60%) XMLSpy
5 1 (1.30%) JIRA
5 1 (1.30%) LoadRunner
5 1 (1.30%) Talend Open Studio
General
1 35 (45.45%) Finance
2 6 (7.79%) Retail
3 2 (2.60%) Banking
Job Titles
1 35 (45.45%) Architect
2 24 (31.17%) Analyst
3 23 (29.87%) Data Architect
4 13 (16.88%) Business Intelligence Analyst
5 11 (14.29%) Data Modeller
5 11 (14.29%) Information Architect
6 10 (12.99%) Data Analyst
7 9 (11.69%) Business Analyst
7 9 (11.69%) Enterprise Architect
7 9 (11.69%) Enterprise Data Architect
8 8 (10.39%) Solutions Architect
9 6 (7.79%) Business Intelligence Business Analyst
9 6 (7.79%) Financial Analyst
9 6 (7.79%) Java Architect
9 6 (7.79%) Java Solutions Architect
10 5 (6.49%) Data Warehouse Analyst
10 5 (6.49%) Data Warehouse Business Analyst
10 5 (6.49%) Senior Analyst
10 5 (6.49%) Senior Data Analyst
11 4 (5.19%) Developer
Libraries, Frameworks & Software Standards
1 12 (15.58%) XML
2 7 (9.09%) J2EE
2 7 (9.09%) JMS
2 7 (9.09%) SOAP
3 6 (7.79%) JSP
3 6 (7.79%) RESTful
3 6 (7.79%) Servlets
3 6 (7.79%) XSD
3 6 (7.79%) XSLT
4 3 (3.90%) REST
4 3 (3.90%) XML Schema
5 1 (1.30%) Hibernate
5 1 (1.30%) Java EE
5 1 (1.30%) Middleware
5 1 (1.30%) SAML
5 1 (1.30%) Spring
5 1 (1.30%) Web Services
5 1 (1.30%) WebSphere MQ
5 1 (1.30%) WSDL
5 1 (1.30%) XSL
Miscellaneous
1 14 (18.18%) Analytical Skills
2 9 (11.69%) Management Information System
3 7 (9.09%) Computer Science
3 7 (9.09%) Enterprise Software
4 6 (7.79%) AS400
4 6 (7.79%) User Experience
5 4 (5.19%) Reference Data
5 4 (5.19%) Taxonomies
6 3 (3.90%) Data Structures
7 2 (2.60%) Equities
7 2 (2.60%) Fixed Income
7 2 (2.60%) FMCG
8 1 (1.30%) DataPower
8 1 (1.30%) Greenfield Project
8 1 (1.30%) Market Risk
Operating Systems
1 7 (9.09%) Linux
2 6 (7.79%) AIX
2 6 (7.79%) Solaris
2 6 (7.79%) Windows
2 6 (7.79%) Windows Server 2003
Processes & Methodologies
1 72 (93.51%) Data Modelling
2 52 (67.53%) Business Intelligence
3 38 (49.35%) Data Management
4 29 (37.66%) Migration
5 28 (36.36%) ETL
6 27 (35.06%) Data Analysis
7 26 (33.77%) Data Architecture
8 25 (32.47%) Data Governance
9 22 (28.57%) Logical Data Model
10 21 (27.27%) Agile Software Development
11 20 (25.97%) Analytics
12 17 (22.08%) Visualisation
13 16 (20.78%) Data Migration
14 15 (19.48%) Master Data Management
14 15 (19.48%) SOA
15 14 (18.18%) Kimball Methodology
16 13 (16.88%) Enterprise Architecture
17 11 (14.29%) Dimensional Modelling
17 11 (14.29%) UML
18 10 (12.99%) TOGAF
Programming Languages
1 35 (45.45%) SQL
2 8 (10.39%) Shell Script
3 7 (9.09%) Java
4 6 (7.79%) JavaScript
5 4 (5.19%) PL/SQL
6 3 (3.90%) PowerShell
7 2 (2.60%) T-SQL
8 1 (1.30%) C++
8 1 (1.30%) SAS Macro
Qualifications
1 12 (15.58%) Degree
2 9 (11.69%) Numerate Degree
3 2 (2.60%) MCSA
3 2 (2.60%) Microsoft Certification
4 1 (1.30%) CITP
4 1 (1.30%) ISEB
4 1 (1.30%) Security Cleared
Quality Assurance & Compliance
1 26 (33.77%) Data Quality
2 2 (2.60%) ISO 20022
3 1 (1.30%) QA
Systems Management
1 1 (1.30%) OpenSSO
1 1 (1.30%) Systems Management Server (SMS)
1 1 (1.30%) Tivoli
Vendors
1 21 (27.27%) Tableau
2 18 (23.38%) Oracle
3 13 (16.88%) Informatica
4 11 (14.29%) IBM
5 9 (11.69%) Ab Initio
5 9 (11.69%) Teradata
6 6 (7.79%) Microsoft
7 5 (6.49%) CA
7 5 (6.49%) MapR
8 4 (5.19%) SAP
9 3 (3.90%) Cognos
10 2 (2.60%) Trillium
11 1 (1.30%) ATG
11 1 (1.30%) Birst
11 1 (1.30%) Casewise
11 1 (1.30%) hybris
11 1 (1.30%) Talend