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 4 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
4 Dec 2016
Same period 2015 Same period 2014
Entity-Relationship Diagram (ER Diagram)
Rank 876 931 944
Rank change year-on-year
+55 +13
Permanent jobs citing ERD 7 35 35
As % of all permanent IT jobs located in the UK 0.008% 0.033% 0.031%
As % of the Processes & Methodologies category 0.009% 0.037% 0.036%
Number of salaries quoted 7 31 27
Median salary £65,000 £46,500 £46,000
Median salary % change year-on-year
+39.78% +1.08%
90% offered a salary of more than £38,500 £40,000 £40,000
10% offered a salary of more than £68,000 £59,500 £55,000
UK excluding London median salary £57,500 £40,000 £46,000
% change year-on-year
+43.75% -13.04%

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
78798 94209 98163
As % of all permanent IT jobs located in the UK 88.10% 87.55% 85.65%
Number of salaries quoted 64965 77834 80660
Median salary £50,000 £50,000 £47,501
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 £77,500 £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 4 December 2016 within the UK.

ERD Salary Histogram in the UK

ERD
Top 5 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 4 December 2016. 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
(Click see detailed
statistics and trends)
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 +68 7 £65,000 +39.78%
London +63 5 £65,000 +13.04%
South East +75 2 £57,500 -
West Sussex - 1 £42,500 -
Berkshire - 1 £72,500 -

ERD
Top 30 Related IT Skills

For the 6 months to 4 December 2016, 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 38 (84.44%) Data Modelling
2 34 (75.56%) UML
3 20 (44.44%) ETL
3 20 (44.44%) Agile Software Development
4 19 (42.22%) Oracle
5 16 (35.56%) Business Intelligence
6 15 (33.33%) SQL
7 14 (31.11%) SQL Server
8 13 (28.89%) Legal
8 13 (28.89%) Retail
8 13 (28.89%) SDLC
9 12 (26.67%) Waterfall
9 12 (26.67%) SOA
9 12 (26.67%) OOP
9 12 (26.67%) OO
10 11 (24.44%) Data Analysis
10 11 (24.44%) SQL Server Integration Services
11 10 (22.22%) SQL Server Reporting Services
11 10 (22.22%) Open Source
11 10 (22.22%) High Availability
11 10 (22.22%) Performance Tuning
12 9 (20.00%) Database Security
12 9 (20.00%) Database Mirroring
12 9 (20.00%) Failover Clustering
12 9 (20.00%) Enterprise Architecture
12 9 (20.00%) Replication
12 9 (20.00%) Statistics
12 9 (20.00%) SQL Server Analysis Services
12 9 (20.00%) Unix
12 9 (20.00%) T-SQL

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 4 (8.89%) Oracle SOA Suite
Applications
1 4 (8.89%) MS Visio
2 3 (6.67%) MS Excel
3 2 (4.44%) MS Office
Database & Business Intelligence
1 14 (31.11%) SQL Server
2 11 (24.44%) SQL Server Integration Services
3 10 (22.22%) SQL Server Reporting Services
4 9 (20.00%) SQL Server Analysis Services
5 7 (15.56%) Data Warehouse
6 6 (13.33%) SQL Server 2005
6 6 (13.33%) SQL Server 2008
6 6 (13.33%) SQL Server 2012
7 4 (8.89%) MySQL
7 4 (8.89%) NoSQL
7 4 (8.89%) Relational Database
8 3 (6.67%) Star Schema
9 2 (4.44%) Big Data
9 2 (4.44%) BusinessObjects
10 1 (2.22%) BusinessObjects XI
10 1 (2.22%) OLAP
10 1 (2.22%) OLTP
10 1 (2.22%) Power BI
10 1 (2.22%) PowerPivot
10 1 (2.22%) RDBMS
Development Applications
1 3 (6.67%) ERwin
1 3 (6.67%) Subversion
2 1 (2.22%) JIRA
2 1 (2.22%) PowerDesigner
General
1 13 (28.89%) Legal
1 13 (28.89%) Retail
2 5 (11.11%) Finance
3 2 (4.44%) Banking
4 1 (2.22%) Advertising
4 1 (2.22%) Back Office
4 1 (2.22%) Front Office
4 1 (2.22%) Investment Banking
4 1 (2.22%) Marketing
Job Titles
1 12 (26.67%) Analyst
1 12 (26.67%) Data Modeller
2 9 (20.00%) DBA
2 9 (20.00%) SQL DBA
3 7 (15.56%) Business Analyst
4 6 (13.33%) Development DBA
4 6 (13.33%) Production DBA
5 5 (11.11%) Developer
6 4 (8.89%) Architect
6 4 (8.89%) Business Intelligence Analyst
6 4 (8.89%) Business Intelligence Business Analyst
6 4 (8.89%) Data Business Analyst
6 4 (8.89%) SQL Analyst
6 4 (8.89%) SQL Data Analyst
6 4 (8.89%) UML Analyst
6 4 (8.89%) UML Business Analyst
7 3 (6.67%) Data Architect
7 3 (6.67%) Front End Developer (Client-Side Developer)
7 3 (6.67%) MySQL DBA
8 2 (4.44%) Business Change Analyst
Libraries, Frameworks & Software Standards
1 8 (17.78%) Middleware
1 8 (17.78%) REST
1 8 (17.78%) SOAP
2 6 (13.33%) XML
3 5 (11.11%) Web Services
4 4 (8.89%) MDX
5 3 (6.67%) CSS
5 3 (6.67%) HTML
6 1 (2.22%) .NET
6 1 (2.22%) ASP.NET
Miscellaneous
1 9 (20.00%) Replication
1 9 (20.00%) Statistics
2 7 (15.56%) Analytical Skills
3 6 (13.33%) Computer Science
4 3 (6.67%) Data Integration
4 3 (6.67%) Reference Data
4 3 (6.67%) Semantic Web
5 2 (4.44%) Enterprise Software
5 2 (4.44%) Management Information System
6 1 (2.22%) Data Extraction
6 1 (2.22%) Fixed Income
Operating Systems
1 9 (20.00%) Unix
Processes & Methodologies
1 38 (84.44%) Data Modelling
2 34 (75.56%) UML
3 20 (44.44%) Agile Software Development
3 20 (44.44%) ETL
4 16 (35.56%) Business Intelligence
5 13 (28.89%) SDLC
6 12 (26.67%) OO
6 12 (26.67%) OOP
6 12 (26.67%) SOA
6 12 (26.67%) Waterfall
7 11 (24.44%) Data Analysis
8 10 (22.22%) High Availability
8 10 (22.22%) Open Source
8 10 (22.22%) Performance Tuning
9 9 (20.00%) Database Mirroring
9 9 (20.00%) Database Security
9 9 (20.00%) Enterprise Architecture
10 8 (17.78%) Data Architecture
10 8 (17.78%) Service Design
10 8 (17.78%) User Acceptance Testing
Programming Languages
1 15 (33.33%) SQL
2 9 (20.00%) T-SQL
3 5 (11.11%) Java
4 3 (6.67%) JavaScript
4 3 (6.67%) PowerShell
5 2 (4.44%) C#
6 1 (2.22%) PL/SQL
6 1 (2.22%) Python
Qualifications
1 9 (20.00%) OCP
1 9 (20.00%) Oracle Certification
2 6 (13.33%) Degree
3 1 (2.22%) CISM
3 1 (2.22%) CISSP
3 1 (2.22%) CRISC
Quality Assurance & Compliance
1 8 (17.78%) Data Quality
2 4 (8.89%) QA
3 1 (2.22%) ISO/IEC 27001
Systems Management
1 9 (20.00%) Failover Clustering
Vendors
1 19 (42.22%) Oracle
2 8 (17.78%) Microsoft
3 4 (8.89%) Tableau
4 3 (6.67%) IBM
4 3 (6.67%) Pega
4 3 (6.67%) Salesforce.com
5 2 (4.44%) Guidewire
5 2 (4.44%) Informatica
6 1 (2.22%) Cognos
6 1 (2.22%) Kronos
6 1 (2.22%) Sony