The table below looks at the statistics for ERD skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited ERD over the 3 months to 19 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
19 Jan 2017
Same period 2016 Same period 2015
Entity-Relationship Diagram (ER Diagram)
UK
Rank 834 922 917
Rank change year-on-year
+88 -5
Permanent jobs citing ERD 11 25 26
As % of all permanent IT jobs located in the UK 0.013% 0.025% 0.025%
As % of the Processes & Methodologies category 0.015% 0.028% 0.029%
Number of salaries quoted 11 23 22
Median salary £50,000 £47,500 £46,000
Median salary % change year-on-year
+5.26% +3.26%
90% offered a salary of more than £39,400 £42,600 £40,000
10% offered a salary of more than £83,000 £64,000 £70,000
UK excluding London median salary £50,000 £39,750 £40,000
% change year-on-year
+25.78% -0.62%

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised across the UK.

Processes & Methodologies Category
UK
Permanent IT job ads with a match in the
Processes & Methodologies category
73988 87832 90309
As % of all permanent IT jobs located in the UK 88.12% 87.69% 86.05%
Number of salaries quoted 60898 73039 74561
Median salary £50,000 £50,000 £47,500
Median salary % change year-on-year
- +5.26%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £76,000 £72,500 £75,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

ERD
Jobs Demand Trend

The demand trend of job ads citing ERD as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ERD Jobs Demand Trend in the UK

ERD
Salary Trend

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

ERD Salary Trend in the UK

ERD
Salary Histogram

This chart provides a salary histogram for IT jobs citing ERD over the 3 months to 19 January 2017 within the UK.

ERD Salary Histogram in the UK

ERD
Top 18 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ERD within the UK over the 3 months to 19 January 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +52 11 £50,000 +5.26% 3
London +35 6 £65,000 +36.84%
Preston - 3 £40,000 -
North West - 3 £40,000 -
Lancashire - 3 £40,000 -
South East - 2 £50,000 - 2
Berkshire - 2 £61,250 -
West Midlands +1 1 £50,000 +25.78%
South West - 1 £50,000 -
Oxfordshire - 1 £50,000 -
Somerset - 1 £50,000 -
Wiltshire - 1 £50,000 -
Worcestershire - 1 £50,000 -
Bath - 1 £50,000 -
Oxford - 1 £50,000 -
Reading - 1 £50,000 -
Swindon - 1 £50,000 -
Worcester - 1 £50,000 -

ERD
Top 30 Related IT Skills

For the 6 months to 19 January 2017, IT jobs citing ERD 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 ERD.

1 27 (84.38%) Data Modelling
2 23 (71.88%) UML
3 19 (59.38%) Oracle
4 18 (56.25%) ETL
5 16 (50.00%) SQL
6 14 (43.75%) SQL Server
6 14 (43.75%) Agile Software Development
7 13 (40.63%) Business Intelligence
8 11 (34.38%) SDLC
9 10 (31.25%) OOP
9 10 (31.25%) OO
9 10 (31.25%) SQL Server Reporting Services
9 10 (31.25%) SQL Server Integration Services
10 9 (28.13%) SQL Server Analysis Services
10 9 (28.13%) Open Source
10 9 (28.13%) High Availability
10 9 (28.13%) Legal
10 9 (28.13%) Performance Tuning
11 8 (25.00%) Database Security
11 8 (25.00%) Database Mirroring
11 8 (25.00%) Failover Clustering
11 8 (25.00%) Replication
11 8 (25.00%) OCP
11 8 (25.00%) Oracle Certification
11 8 (25.00%) Unix
11 8 (25.00%) T-SQL
11 8 (25.00%) Waterfall
11 8 (25.00%) Statistics
12 7 (21.88%) Retail
12 7 (21.88%) Data Warehouse

ERD
Top Related 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 1 (3.13%) Oracle SOA Suite
Applications
1 4 (12.50%) MS Visio
2 2 (6.25%) MS Excel
Database & Business Intelligence
1 14 (43.75%) SQL Server
2 10 (31.25%) SQL Server Integration Services
2 10 (31.25%) SQL Server Reporting Services
3 9 (28.13%) SQL Server Analysis Services
4 7 (21.88%) Data Warehouse
5 6 (18.75%) SQL Server 2005
5 6 (18.75%) SQL Server 2008
5 6 (18.75%) SQL Server 2012
6 5 (15.63%) NoSQL
7 4 (12.50%) MySQL
8 3 (9.38%) Oracle Database
8 3 (9.38%) Oracle Database 11g
8 3 (9.38%) Star Schema
9 2 (6.25%) Big Data
9 2 (6.25%) Enterprise Data Warehouse
9 2 (6.25%) Hadoop
9 2 (6.25%) Relational Database
10 1 (3.13%) BusinessObjects XI
10 1 (3.13%) OLTP
10 1 (3.13%) RDBMS
Development Applications
1 3 (9.38%) Oracle APEX
1 3 (9.38%) Oracle Forms
2 2 (6.25%) JIRA
3 1 (3.13%) ERwin
3 1 (3.13%) Subversion
General
1 9 (28.13%) Legal
2 7 (21.88%) Retail
3 4 (12.50%) Finance
4 1 (3.13%) Advertising
4 1 (3.13%) Banking
4 1 (3.13%) Manufacturing
Job Titles
1 9 (28.13%) DBA
2 8 (25.00%) SQL DBA
3 7 (21.88%) Developer
4 6 (18.75%) Data Modeller
4 6 (18.75%) Development DBA
4 6 (18.75%) Production DBA
5 5 (15.63%) Architect
6 3 (9.38%) Analyst
6 3 (9.38%) Business Intelligence Lead
6 3 (9.38%) Data Architect
6 3 (9.38%) Front End Developer (Client-Side Developer)
6 3 (9.38%) Oracle Developer
6 3 (9.38%) PL/SQL Developer
6 3 (9.38%) SQL Developer
7 2 (6.25%) Database Developer
7 2 (6.25%) Lead Architect
7 2 (6.25%) Oracle Database Developer
7 2 (6.25%) Oracle Forms Developer
7 2 (6.25%) Report Analyst
7 2 (6.25%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 6 (18.75%) XML
2 5 (15.63%) HTML
2 5 (15.63%) Middleware
2 5 (15.63%) REST
2 5 (15.63%) SOAP
2 5 (15.63%) Web Services
3 3 (9.38%) CSS
4 2 (6.25%) Classic ASP
4 2 (6.25%) Cocoa
4 2 (6.25%) Cocoa Touch
4 2 (6.25%) jQuery
4 2 (6.25%) JSON
4 2 (6.25%) Kafka
5 1 (3.13%) .NET
5 1 (3.13%) ASP.NET
5 1 (3.13%) MDX
Miscellaneous
1 8 (25.00%) Replication
1 8 (25.00%) Statistics
2 6 (18.75%) Computer Science
3 5 (15.63%) Data Integration
4 4 (12.50%) Analytical Skills
5 3 (9.38%) Semantic Web
6 2 (6.25%) Data Structures
6 2 (6.25%) Enterprise Software
6 2 (6.25%) Management Information System
7 1 (3.13%) Reference Data
Operating Systems
1 8 (25.00%) Unix
2 3 (9.38%) Apple iOS
3 1 (3.13%) Linux
Processes & Methodologies
1 27 (84.38%) Data Modelling
2 23 (71.88%) UML
3 18 (56.25%) ETL
4 14 (43.75%) Agile Software Development
5 13 (40.63%) Business Intelligence
6 11 (34.38%) SDLC
7 10 (31.25%) OO
7 10 (31.25%) OOP
8 9 (28.13%) High Availability
8 9 (28.13%) Open Source
8 9 (28.13%) Performance Tuning
9 8 (25.00%) Database Mirroring
9 8 (25.00%) Database Security
9 8 (25.00%) Waterfall
10 6 (18.75%) Scrum
10 6 (18.75%) SOA
11 5 (15.63%) Data Analysis
11 5 (15.63%) Data Management
11 5 (15.63%) Enterprise Architecture
11 5 (15.63%) Service Design
Programming Languages
1 16 (50.00%) SQL
2 8 (25.00%) T-SQL
3 5 (15.63%) JavaScript
4 4 (12.50%) Java
4 4 (12.50%) PL/SQL
5 3 (9.38%) Objective-C
6 2 (6.25%) PowerShell
7 1 (3.13%) C#
7 1 (3.13%) Python
Qualifications
1 8 (25.00%) OCP
1 8 (25.00%) Oracle Certification
2 4 (12.50%) Degree
Quality Assurance & Compliance
1 6 (18.75%) Data Quality
2 1 (3.13%) QA
Systems Management
1 8 (25.00%) Failover Clustering
Vendors
1 19 (59.38%) Oracle
2 5 (15.63%) Microsoft
3 3 (9.38%) Apple
3 3 (9.38%) IBM
3 3 (9.38%) Pega
3 3 (9.38%) Salesforce.com
4 2 (6.25%) Informatica
5 1 (3.13%) Cognos
5 1 (3.13%) Guidewire
5 1 (3.13%) Tableau
Leeds, West Yorkshire
Calibre Search Ltd
Salary: £50000 - £60000.00 per annum
Posted: 3 days ago