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

3 months to
24 May 2016
Same period 2015 Same period 2014
Entity-Relationship Diagram (ER Diagram)
Rank 880 911 979
Rank change year-on-year
+31 +68
Permanent jobs citing ERD 52 36 25
As % of all permanent IT jobs located in the UK 0.053% 0.034% 0.021%
As % of the Processes & Methodologies category 0.060% 0.039% 0.025%
Number of salaries quoted 26 22 17
Median salary £56,250 £46,000 £37,500
Median salary % change year-on-year
+22.28% +22.66%
90% offered a salary of more than £32,500 £42,000 £20,000
10% offered a salary of more than £81,250 £73,750 £52,000
UK excluding London median salary £42,500 £42,500 £34,800
% change year-on-year
- +22.12%

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
86605 92119 101627
As % of all permanent IT jobs located in the UK 87.86% 86.39% 85.34%
Number of salaries quoted 72063 74807 82623
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 £31,500 £31,000
10% offered a salary of more than £75,000 £72,500 £75,000
UK excluding London median salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

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 24 May 2016 within the UK.

ERD Salary Histogram in the UK

ERD
Top 16 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 24 May 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 +60 52 £56,250 +22.28% 5
London +40 31 £57,500 +21.05% 4
Manchester - 12 £49,500 -
North West - 12 £49,500 -
City of London +43 7 £57,500 +29.21% 3
South East +25 4 £70,000 +40.70%
Yorkshire +14 4 £32,500 +16.07% 1
North Yorkshire +7 3 £32,500 +16.07%
York -3 3 £32,500 +16.07%
Hampshire +6 2 £70,000 +21.73%
Berkshire - 2 £70,000 -
Andover - 2 £70,000 -
Bracknell - 2 £70,000 -
Newcastle upon Tyne - 1 £40,000 -
Tyne and Wear - 1 £40,000 -
North East - 1 £40,000 -

ERD
Top 30 Related IT Skills

For the 6 months to 24 May 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 51 (63.75%) Agile Software Development
2 50 (62.50%) UML
3 49 (61.25%) Data Modelling
4 44 (55.00%) SQL
5 34 (42.50%) SDLC
6 31 (38.75%) Analytical Skills
7 29 (36.25%) Stakeholder Management
8 28 (35.00%) Business Analysis
8 28 (35.00%) Data Warehouse
8 28 (35.00%) Business Intelligence
9 24 (30.00%) Finance
10 23 (28.75%) Microsoft
10 23 (28.75%) PRINCE2
10 23 (28.75%) Data Flow Diagram
11 21 (26.25%) Data Quality
12 19 (23.75%) Tableau
12 19 (23.75%) User Acceptance Testing
12 19 (23.75%) Use Case
12 19 (23.75%) Retail
12 19 (23.75%) Project Management
13 18 (22.50%) MS Excel
14 17 (21.25%) SQL Server
14 17 (21.25%) Data Architecture
14 17 (21.25%) Waterfall
14 17 (21.25%) User Stories
15 16 (20.00%) Relational Database
15 16 (20.00%) Kimball Methodology
15 16 (20.00%) RDBMS
16 15 (18.75%) Data Analysis
16 15 (18.75%) Analytics

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 5 (6.25%) SharePoint
2 4 (5.00%) IIS
3 3 (3.75%) Oracle Workflow
4 2 (2.50%) Node.js
5 1 (1.25%) Confluence
Applications
1 18 (22.50%) MS Excel
2 8 (10.00%) MS Visio
3 7 (8.75%) MS Office
Business Applications
1 4 (5.00%) Dynamics CRM
2 3 (3.75%) Endur
Cloud Services
1 2 (2.50%) GitHub
Communications & Networking
1 2 (2.50%) Internet
Database & Business Intelligence
1 28 (35.00%) Data Warehouse
2 17 (21.25%) SQL Server
3 16 (20.00%) RDBMS
3 16 (20.00%) Relational Database
4 4 (5.00%) Data Mining
4 4 (5.00%) QlikView
4 4 (5.00%) SQL Server Reporting Services
4 4 (5.00%) Star Schema
5 3 (3.75%) Big Data
6 1 (1.25%) MongoDB
6 1 (1.25%) NoSQL
6 1 (1.25%) Oracle Database
Development Applications
1 4 (5.00%) Visual Studio
2 2 (2.50%) Git (software)
2 2 (2.50%) Grunt
2 2 (2.50%) Jenkins
2 2 (2.50%) PowerDesigner
2 2 (2.50%) Selenium
2 2 (2.50%) Subversion
3 1 (1.25%) JIRA
General
1 24 (30.00%) Finance
2 19 (23.75%) Retail
3 13 (16.25%) Telecoms
4 11 (13.75%) Legal
5 10 (12.50%) Back Office
6 7 (8.75%) Law
7 6 (7.50%) Banking
7 6 (7.50%) Marketing
8 3 (3.75%) Advertising
8 3 (3.75%) Billing
8 3 (3.75%) Investment Banking
9 2 (2.50%) Front Office
9 2 (2.50%) Local Government
10 1 (1.25%) Electronics
Job Titles
1 51 (63.75%) Analyst
2 46 (57.50%) Business Analyst
3 21 (26.25%) Business Intelligence Analyst
4 20 (25.00%) Business Intelligence Business Analyst
5 7 (8.75%) Architect
5 7 (8.75%) Business IT Analyst
5 7 (8.75%) Developer
5 7 (8.75%) IT Analyst
5 7 (8.75%) IT Business Analyst
5 7 (8.75%) Systems Analyst
6 5 (6.25%) Data Architect
6 5 (6.25%) Data Business Analyst
6 5 (6.25%) Development Analyst
6 5 (6.25%) Lead Business Analyst
6 5 (6.25%) Software Analyst
6 5 (6.25%) Software Development Analyst
7 4 (5.00%) CRM Developer
7 4 (5.00%) SQL BI Developer
7 4 (5.00%) SQL Data Analyst
7 4 (5.00%) UML Analyst
Libraries, Frameworks & Software Standards
1 15 (18.75%) MDX
2 7 (8.75%) XML
3 6 (7.50%) Web Services
4 4 (5.00%) .NET
4 4 (5.00%) ASP.NET
5 3 (3.75%) CSS
5 3 (3.75%) HTML
6 2 (2.50%) AngularJS
6 2 (2.50%) Backbone.js
6 2 (2.50%) Dojo
6 2 (2.50%) React
7 1 (1.25%) XML Schema
Miscellaneous
1 31 (38.75%) Analytical Skills
2 11 (13.75%) Computer Science
3 7 (8.75%) Client/Server
3 7 (8.75%) N-Tier
4 5 (6.25%) Data Integration
5 3 (3.75%) Enterprise Software
5 3 (3.75%) Swaptions
6 2 (2.50%) Fixed Income
6 2 (2.50%) Hedge funds
6 2 (2.50%) Internet of Things
6 2 (2.50%) Management Information System
6 2 (2.50%) User Experience
7 1 (1.25%) Data Protection Act
7 1 (1.25%) Economics
7 1 (1.25%) Life Science
7 1 (1.25%) Mathematics
7 1 (1.25%) Semantic Web
7 1 (1.25%) Spread Betting
7 1 (1.25%) Wiki
Operating Systems
1 6 (7.50%) Windows
1 6 (7.50%) Windows 7
1 6 (7.50%) Windows 8
Processes & Methodologies
1 51 (63.75%) Agile Software Development
2 50 (62.50%) UML
3 49 (61.25%) Data Modelling
4 34 (42.50%) SDLC
5 29 (36.25%) Stakeholder Management
6 28 (35.00%) Business Analysis
6 28 (35.00%) Business Intelligence
7 23 (28.75%) Data Flow Diagram
7 23 (28.75%) PRINCE2
8 19 (23.75%) Project Management
8 19 (23.75%) Use Case
8 19 (23.75%) User Acceptance Testing
9 17 (21.25%) Data Architecture
9 17 (21.25%) User Stories
9 17 (21.25%) Waterfall
10 16 (20.00%) Kimball Methodology
11 15 (18.75%) Analytics
11 15 (18.75%) Data Analysis
11 15 (18.75%) Wireframes
12 14 (17.50%) Software Delivery
Programming Languages
1 44 (55.00%) SQL
2 6 (7.50%) Java
3 5 (6.25%) PL/SQL
4 4 (5.00%) C#
4 4 (5.00%) VB
4 4 (5.00%) VB.NET
5 3 (3.75%) JavaScript
Qualifications
1 10 (12.50%) Degree
2 2 (2.50%) SC Cleared
2 2 (2.50%) Security Cleared
3 1 (1.25%) IBM Certification
3 1 (1.25%) MCSE
3 1 (1.25%) Microsoft Certification
Quality Assurance & Compliance
1 21 (26.25%) Data Quality
2 15 (18.75%) QA
3 1 (1.25%) ISO/IEC 27001
3 1 (1.25%) ISO27002
Vendors
1 23 (28.75%) Microsoft
2 19 (23.75%) Tableau
3 13 (16.25%) Oracle
4 5 (6.25%) Cognos
5 3 (3.75%) OpenLink
5 3 (3.75%) TIBCO
5 3 (3.75%) webMethods
6 1 (1.25%) Atlassian
6 1 (1.25%) Cloudera
6 1 (1.25%) IBM
City, London
Streamline Connections
Salary: £55000 - £60000.00 per annum + Benefits
Posted: 3 days ago
East Riding
Ampersand Consulting
Salary: £30000 - £35000 per annum
Posted: 4 days ago
London
TEKsystems
Salary: £50000 - £60000 per annum + Package
Posted: 6 days ago
City, London
Schroders plc
Posted: 17 days ago