The table below looks at the statistics for ERD skills in IT jobs advertised for the England region. Included is a guide to the salaries offered in IT jobs that have cited ERD over the 3 months to 25 September 2016 with a comparison to the same period over the previous 2 years.

3 months to
25 Sep 2016
Same period 2015 Same period 2014
Entity-Relationship Diagram (ER Diagram)
Rank 847 903 930
Rank change year-on-year
+56 +27
Permanent jobs citing ERD 35 34 36
As % of all permanent IT jobs located in England 0.039% 0.033% 0.034%
As % of the Processes & Methodologies category 0.045% 0.038% 0.040%
Number of salaries quoted 31 26 33
Median salary £50,000 £57,500 £50,000
Median salary % change year-on-year
-13.04% +15.00%
90% offered a salary of more than £40,000 £40,000 £38,000
10% offered a salary of more than £60,000 £77,000 £56,900
UK excluding London median salary £40,000 £41,250 £48,000
% change year-on-year
-3.03% -14.06%
ERD
UK

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

Processes & Methodologies Category
England
Permanent IT job ads with a match in the
Processes & Methodologies category
78344 89548 91059
As % of all permanent IT jobs located in England 88.28% 87.40% 85.35%
Number of salaries quoted 65821 74795 73477
Median salary £50,000 £50,000 £48,500
Median salary % change year-on-year
- +3.09%
90% offered a salary of more than £32,500 £32,500 £30,500
10% offered a salary of more than £80,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 in England

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

ERD Jobs Demand Trend in England

ERD
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ERD across the England region.

ERD Salary Trend in England

ERD
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing ERD across the England region over the 3 months to 25 September 2016.

ERD Salary Histogram in England

ERD
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ERD within the England region over the 3 months to 25 September 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
London +50 29 £52,500 -12.50%
West Midlands -7 5 £40,000 -
South East +47 1 £42,500 -
ERD
UK

ERD
Top 30 Related IT Skills in England

For the 6 months to 25 September 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 across the England region with a requirement for ERD.

1 62 (82.67%) Data Modelling
2 59 (78.67%) UML
3 42 (56.00%) Agile Software Development
4 37 (49.33%) SQL
5 31 (41.33%) Business Intelligence
6 29 (38.67%) SDLC
7 21 (28.00%) Data Warehouse
7 21 (28.00%) Retail
7 21 (28.00%) Waterfall
8 20 (26.67%) Data Architecture
8 20 (26.67%) Microsoft
9 19 (25.33%) ETL
9 19 (25.33%) Oracle
9 19 (25.33%) Finance
10 18 (24.00%) Stakeholder Management
10 18 (24.00%) Tableau
10 18 (24.00%) Analytical Skills
11 17 (22.67%) Data Analysis
12 16 (21.33%) Legal
12 16 (21.33%) SQL Server
12 16 (21.33%) User Acceptance Testing
13 15 (20.00%) SOA
13 15 (20.00%) SQL Server Reporting Services
14 14 (18.67%) QA
14 14 (18.67%) Data Flow Diagram
15 13 (17.33%) Wireframes
15 13 (17.33%) Data Quality
15 13 (17.33%) Kimball Methodology
15 13 (17.33%) User Stories
15 13 (17.33%) Business Analysis

ERD
Top Related 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 5 (6.67%) IIS
Applications
1 7 (9.33%) MS Visio
2 6 (8.00%) MS Excel
3 1 (1.33%) MS Office
Business Applications
1 5 (6.67%) Dynamics CRM
2 1 (1.33%) Endur
Cloud Services
1 4 (5.33%) GitHub
Communications & Networking
1 1 (1.33%) Internet
Database & Business Intelligence
1 21 (28.00%) Data Warehouse
2 16 (21.33%) SQL Server
3 15 (20.00%) SQL Server Reporting Services
4 10 (13.33%) SQL Server Integration Services
5 9 (12.00%) SQL Server Analysis Services
6 6 (8.00%) SQL Server 2005
6 6 (8.00%) SQL Server 2008
6 6 (8.00%) SQL Server 2012
7 5 (6.67%) NoSQL
7 5 (6.67%) QlikView
7 5 (6.67%) Relational Database
8 4 (5.33%) MySQL
9 3 (4.00%) Big Data
10 2 (2.67%) BusinessObjects
10 2 (2.67%) RDBMS
10 2 (2.67%) Star Schema
11 1 (1.33%) MongoDB
11 1 (1.33%) OLAP
11 1 (1.33%) OLTP
11 1 (1.33%) PowerPivot
Development Applications
1 7 (9.33%) Subversion
2 5 (6.67%) Visual Studio
3 4 (5.33%) Git (software)
3 4 (5.33%) Grunt
3 4 (5.33%) Jenkins
3 4 (5.33%) PowerDesigner
3 4 (5.33%) Selenium
4 3 (4.00%) ERwin
5 1 (1.33%) JIRA
General
1 21 (28.00%) Retail
2 19 (25.33%) Finance
3 16 (21.33%) Legal
4 8 (10.67%) Banking
5 7 (9.33%) Marketing
6 5 (6.67%) Telecoms
7 4 (5.33%) Back Office
7 4 (5.33%) Front Office
7 4 (5.33%) Investment Banking
8 1 (1.33%) Electronics
Job Titles
1 27 (36.00%) Analyst
2 23 (30.67%) Business Analyst
3 15 (20.00%) Data Modeller
4 14 (18.67%) Developer
5 13 (17.33%) Business Intelligence Analyst
5 13 (17.33%) Business Intelligence Business Analyst
6 10 (13.33%) DBA
7 9 (12.00%) Data Business Analyst
7 9 (12.00%) SQL Analyst
7 9 (12.00%) SQL Data Analyst
7 9 (12.00%) SQL DBA
7 9 (12.00%) UML Analyst
7 9 (12.00%) UML Business Analyst
8 6 (8.00%) Development DBA
8 6 (8.00%) Front End Developer (Client-Side Developer)
8 6 (8.00%) Production DBA
9 5 (6.67%) Business Intelligence Developer
9 5 (6.67%) CRM Developer
9 5 (6.67%) SQL BI Developer
9 5 (6.67%) SQL Developer
Libraries, Frameworks & Software Standards
1 13 (17.33%) MDX
2 12 (16.00%) Web Services
3 9 (12.00%) XML
4 8 (10.67%) Middleware
4 8 (10.67%) REST
4 8 (10.67%) SOAP
5 7 (9.33%) CSS
5 7 (9.33%) HTML
6 5 (6.67%) .NET
6 5 (6.67%) ASP.NET
7 4 (5.33%) AngularJS
7 4 (5.33%) Backbone.js
7 4 (5.33%) Dojo
7 4 (5.33%) Node.js
7 4 (5.33%) React
Miscellaneous
1 18 (24.00%) Analytical Skills
2 13 (17.33%) Computer Science
3 9 (12.00%) Replication
3 9 (12.00%) Statistics
4 4 (5.33%) Fixed Income
4 4 (5.33%) User Experience
5 3 (4.00%) Reference Data
6 2 (2.67%) Data Integration
6 2 (2.67%) Enterprise Software
7 1 (1.33%) Data Extraction
7 1 (1.33%) Data Protection Act
7 1 (1.33%) Economics
7 1 (1.33%) Hedge funds
7 1 (1.33%) Internet of Things
7 1 (1.33%) Management Information System
7 1 (1.33%) Mathematics
7 1 (1.33%) Swaptions
Operating Systems
1 9 (12.00%) Unix
Processes & Methodologies
1 62 (82.67%) Data Modelling
2 59 (78.67%) UML
3 42 (56.00%) Agile Software Development
4 31 (41.33%) Business Intelligence
5 29 (38.67%) SDLC
6 21 (28.00%) Waterfall
7 20 (26.67%) Data Architecture
8 19 (25.33%) ETL
9 18 (24.00%) Stakeholder Management
10 17 (22.67%) Data Analysis
11 16 (21.33%) User Acceptance Testing
12 15 (20.00%) SOA
13 14 (18.67%) Data Flow Diagram
14 13 (17.33%) Business Analysis
14 13 (17.33%) Kimball Methodology
14 13 (17.33%) User Stories
14 13 (17.33%) Wireframes
15 12 (16.00%) Enterprise Architecture
15 12 (16.00%) OO
15 12 (16.00%) PRINCE2
Programming Languages
1 37 (49.33%) SQL
2 10 (13.33%) Java
3 9 (12.00%) T-SQL
4 7 (9.33%) C#
4 7 (9.33%) JavaScript
5 5 (6.67%) VB
5 5 (6.67%) VB.NET
6 3 (4.00%) PowerShell
7 1 (1.33%) PL/SQL
7 1 (1.33%) Python
Qualifications
1 12 (16.00%) Degree
2 9 (12.00%) OCP
2 9 (12.00%) Oracle Certification
3 2 (2.67%) SC Cleared
3 2 (2.67%) Security Cleared
4 1 (1.33%) IBM Certification
4 1 (1.33%) MCSE
4 1 (1.33%) Microsoft Certification
Quality Assurance & Compliance
1 14 (18.67%) QA
2 13 (17.33%) Data Quality
Systems Management
1 9 (12.00%) Failover Clustering
Vendors
1 20 (26.67%) Microsoft
2 19 (25.33%) Oracle
3 18 (24.00%) Tableau
4 4 (5.33%) IBM
5 3 (4.00%) Pega
5 3 (4.00%) Salesforce.com
6 2 (2.67%) Guidewire
7 1 (1.33%) Cloudera
7 1 (1.33%) Cognos
7 1 (1.33%) Kronos
7 1 (1.33%) OpenLink
7 1 (1.33%) Sony
7 1 (1.33%) TIBCO
7 1 (1.33%) webMethods