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 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 876 928 928
Rank change year-on-year
+52 0
Permanent jobs citing ERD 35 36 46
As % of all permanent IT jobs located in the UK 0.037% 0.033% 0.040%
As % of the Processes & Methodologies category 0.042% 0.038% 0.047%
Number of salaries quoted 31 28 39
Median salary £50,000 £56,250 £50,000
Median salary % change year-on-year
-11.11% +12.50%
90% offered a salary of more than £40,000 £40,000 £37,000
10% offered a salary of more than £60,000 £77,000 £56,600
UK excluding London median salary £40,000 £41,250 £48,000
% change year-on-year
-3.03% -14.06%

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
83254 95993 97338
As % of all permanent IT jobs located in the UK 88.26% 87.51% 85.29%
Number of salaries quoted 69343 79334 77826
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 £30,500
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 25 September 2016 within the UK.

ERD Salary Histogram in the UK

ERD
Top 9 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 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
England +56 35 £50,000 -13.04%
London +50 29 £52,500 -12.50%
City of London +76 13 £52,500 +16.66%
West Midlands -7 5 £40,000 -
West Bromwich +6 2 £40,000 -
Coventry -2 2 £40,000 +11.11%
Birmingham - 2 £40,000 -
South East +47 1 £42,500 -
West Sussex - 1 £42,500 -

ERD
Top 30 Related IT Skills

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 with a requirement for ERD.

1 62 (80.52%) Data Modelling
2 59 (76.62%) UML
3 44 (57.14%) Agile Software Development
4 37 (48.05%) SQL
5 31 (40.26%) Business Intelligence
6 29 (37.66%) SDLC
7 21 (27.27%) Data Warehouse
7 21 (27.27%) Retail
7 21 (27.27%) Waterfall
8 20 (25.97%) Data Architecture
8 20 (25.97%) Microsoft
9 19 (24.68%) ETL
9 19 (24.68%) Oracle
9 19 (24.68%) Finance
10 18 (23.38%) Legal
10 18 (23.38%) Stakeholder Management
10 18 (23.38%) Tableau
10 18 (23.38%) Analytical Skills
11 17 (22.08%) Data Analysis
12 16 (20.78%) SQL Server
12 16 (20.78%) User Acceptance Testing
13 15 (19.48%) SOA
13 15 (19.48%) SQL Server Reporting Services
14 14 (18.18%) PRINCE2
14 14 (18.18%) QA
14 14 (18.18%) Data Flow Diagram
15 13 (16.88%) Wireframes
15 13 (16.88%) Kimball Methodology
15 13 (16.88%) User Stories
15 13 (16.88%) MDX

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.49%) IIS
Applications
1 7 (9.09%) MS Visio
2 6 (7.79%) MS Excel
3 3 (3.90%) MS Office
Business Applications
1 5 (6.49%) Dynamics CRM
2 1 (1.30%) Endur
Cloud Services
1 4 (5.19%) GitHub
Communications & Networking
1 1 (1.30%) Internet
Database & Business Intelligence
1 21 (27.27%) Data Warehouse
2 16 (20.78%) SQL Server
3 15 (19.48%) SQL Server Reporting Services
4 10 (12.99%) SQL Server Integration Services
5 9 (11.69%) SQL Server Analysis Services
6 6 (7.79%) SQL Server 2005
6 6 (7.79%) SQL Server 2008
6 6 (7.79%) SQL Server 2012
7 5 (6.49%) NoSQL
7 5 (6.49%) QlikView
7 5 (6.49%) Relational Database
8 4 (5.19%) MySQL
9 3 (3.90%) Big Data
10 2 (2.60%) BusinessObjects
10 2 (2.60%) RDBMS
10 2 (2.60%) Star Schema
11 1 (1.30%) MongoDB
11 1 (1.30%) OLAP
11 1 (1.30%) OLTP
11 1 (1.30%) PowerPivot
Development Applications
1 7 (9.09%) Subversion
2 5 (6.49%) Visual Studio
3 4 (5.19%) Git (software)
3 4 (5.19%) Grunt
3 4 (5.19%) Jenkins
3 4 (5.19%) PowerDesigner
3 4 (5.19%) Selenium
4 3 (3.90%) ERwin
5 1 (1.30%) JIRA
General
1 21 (27.27%) Retail
2 19 (24.68%) Finance
3 18 (23.38%) Legal
4 8 (10.39%) Banking
5 7 (9.09%) Marketing
6 5 (6.49%) Telecoms
7 4 (5.19%) Back Office
7 4 (5.19%) Front Office
7 4 (5.19%) Investment Banking
8 1 (1.30%) Electronics
Job Titles
1 27 (35.06%) Analyst
2 23 (29.87%) Business Analyst
3 15 (19.48%) Data Modeller
4 14 (18.18%) Developer
5 13 (16.88%) Business Intelligence Analyst
5 13 (16.88%) Business Intelligence Business Analyst
6 10 (12.99%) DBA
7 9 (11.69%) Data Business Analyst
7 9 (11.69%) SQL Analyst
7 9 (11.69%) SQL Data Analyst
7 9 (11.69%) SQL DBA
7 9 (11.69%) UML Analyst
7 9 (11.69%) UML Business Analyst
8 6 (7.79%) Development DBA
8 6 (7.79%) Front End Developer (Client-Side Developer)
8 6 (7.79%) Production DBA
9 5 (6.49%) Business Intelligence Developer
9 5 (6.49%) CRM Developer
9 5 (6.49%) SQL BI Developer
9 5 (6.49%) SQL Developer
Libraries, Frameworks & Software Standards
1 13 (16.88%) MDX
2 12 (15.58%) Web Services
3 9 (11.69%) XML
4 8 (10.39%) Middleware
4 8 (10.39%) REST
4 8 (10.39%) SOAP
5 7 (9.09%) CSS
5 7 (9.09%) HTML
6 5 (6.49%) .NET
6 5 (6.49%) ASP.NET
7 4 (5.19%) AngularJS
7 4 (5.19%) Backbone.js
7 4 (5.19%) Dojo
7 4 (5.19%) Node.js
7 4 (5.19%) React
Miscellaneous
1 18 (23.38%) Analytical Skills
2 13 (16.88%) Computer Science
3 9 (11.69%) Replication
3 9 (11.69%) Statistics
4 4 (5.19%) Fixed Income
4 4 (5.19%) User Experience
5 3 (3.90%) Reference Data
6 2 (2.60%) Data Integration
6 2 (2.60%) Enterprise Software
7 1 (1.30%) Data Extraction
7 1 (1.30%) Data Protection Act
7 1 (1.30%) Economics
7 1 (1.30%) Hedge funds
7 1 (1.30%) Internet of Things
7 1 (1.30%) Management Information System
7 1 (1.30%) Mathematics
7 1 (1.30%) Swaptions
Operating Systems
1 9 (11.69%) Unix
Processes & Methodologies
1 62 (80.52%) Data Modelling
2 59 (76.62%) UML
3 44 (57.14%) Agile Software Development
4 31 (40.26%) Business Intelligence
5 29 (37.66%) SDLC
6 21 (27.27%) Waterfall
7 20 (25.97%) Data Architecture
8 19 (24.68%) ETL
9 18 (23.38%) Stakeholder Management
10 17 (22.08%) Data Analysis
11 16 (20.78%) User Acceptance Testing
12 15 (19.48%) SOA
13 14 (18.18%) Data Flow Diagram
13 14 (18.18%) PRINCE2
14 13 (16.88%) Business Analysis
14 13 (16.88%) Kimball Methodology
14 13 (16.88%) User Stories
14 13 (16.88%) Wireframes
15 12 (15.58%) Enterprise Architecture
15 12 (15.58%) OO
Programming Languages
1 37 (48.05%) SQL
2 10 (12.99%) Java
3 9 (11.69%) T-SQL
4 7 (9.09%) C#
4 7 (9.09%) JavaScript
5 5 (6.49%) VB
5 5 (6.49%) VB.NET
6 3 (3.90%) PowerShell
7 1 (1.30%) PL/SQL
7 1 (1.30%) Python
Qualifications
1 12 (15.58%) Degree
2 9 (11.69%) OCP
2 9 (11.69%) Oracle Certification
3 2 (2.60%) CISM
3 2 (2.60%) CISSP
3 2 (2.60%) CRISC
3 2 (2.60%) SC Cleared
3 2 (2.60%) Security Cleared
4 1 (1.30%) IBM Certification
4 1 (1.30%) MCSE
4 1 (1.30%) Microsoft Certification
Quality Assurance & Compliance
1 14 (18.18%) QA
2 13 (16.88%) Data Quality
3 2 (2.60%) ISO/IEC 27001
Systems Management
1 9 (11.69%) Failover Clustering
Vendors
1 20 (25.97%) Microsoft
2 19 (24.68%) Oracle
3 18 (23.38%) Tableau
4 4 (5.19%) IBM
5 3 (3.90%) Pega
5 3 (3.90%) Salesforce.com
6 2 (2.60%) Guidewire
7 1 (1.30%) Cloudera
7 1 (1.30%) Cognos
7 1 (1.30%) Kronos
7 1 (1.30%) OpenLink
7 1 (1.30%) Sony
7 1 (1.30%) TIBCO
7 1 (1.30%) webMethods