The table below looks at the statistics for ERD skills in IT jobs advertised for the London region. 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 576 639 665
Rank change year-on-year
+63 +26
Permanent jobs citing ERD 5 24 15
As % of all permanent IT jobs located in London 0.014% 0.055% 0.033%
As % of the Processes & Methodologies category 0.016% 0.062% 0.038%
Number of salaries quoted 5 21 10
Median salary £65,000 £57,500 £55,000
Median salary % change year-on-year
+13.04% +4.54%
UK excluding London median salary £57,500 £40,000 £46,000
% change year-on-year
+43.75% -13.04%
ERD
England

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

Processes & Methodologies Category
London
Permanent IT job ads with a match in the
Processes & Methodologies category
31286 38626 39146
As % of all permanent IT jobs located in London 89.08% 88.26% 86.19%
Number of salaries quoted 26557 32590 33047
Median salary £60,000 £57,500 £55,000
Median salary % change year-on-year
+4.34% +4.54%
90% offered a salary of more than £40,000 £38,500 £37,500
10% offered a salary of more than £85,000 £80,000 £85,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

ERD
Jobs Demand Trend in London

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

ERD Jobs Demand Trend in London

ERD
Salary Trend in London

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

ERD Salary Trend in London

ERD
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing ERD across the London region over the 3 months to 4 December 2016.

ERD Salary Histogram in London

ERD
Top 30 Related IT Skills in London

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 across the London region with a requirement for ERD.

1 36 (100.00%) Data Modelling
2 31 (86.11%) UML
3 19 (52.78%) ETL
3 19 (52.78%) Agile Software Development
4 17 (47.22%) Oracle
5 15 (41.67%) Business Intelligence
6 14 (38.89%) SQL
7 13 (36.11%) SQL Server
7 13 (36.11%) SDLC
8 12 (33.33%) OOP
8 12 (33.33%) OO
8 12 (33.33%) Legal
8 12 (33.33%) Retail
8 12 (33.33%) Waterfall
9 11 (30.56%) SOA
10 10 (27.78%) High Availability
10 10 (27.78%) Open Source
10 10 (27.78%) Performance Tuning
10 10 (27.78%) SQL Server Integration Services
11 9 (25.00%) Enterprise Architecture
11 9 (25.00%) Statistics
11 9 (25.00%) SQL Server Reporting Services
11 9 (25.00%) SQL Server Analysis Services
11 9 (25.00%) Database Security
11 9 (25.00%) Unix
11 9 (25.00%) T-SQL
11 9 (25.00%) Replication
11 9 (25.00%) OCP
11 9 (25.00%) Oracle Certification
11 9 (25.00%) Database Mirroring

ERD
Top Related IT Skills in London 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 3 (8.33%) Oracle SOA Suite
Applications
1 4 (11.11%) MS Visio
2 3 (8.33%) MS Excel
3 1 (2.78%) MS Office
Database & Business Intelligence
1 13 (36.11%) SQL Server
2 10 (27.78%) SQL Server Integration Services
3 9 (25.00%) SQL Server Analysis Services
3 9 (25.00%) SQL Server Reporting Services
4 6 (16.67%) Data Warehouse
4 6 (16.67%) SQL Server 2005
4 6 (16.67%) SQL Server 2008
4 6 (16.67%) SQL Server 2012
5 3 (8.33%) MySQL
5 3 (8.33%) NoSQL
5 3 (8.33%) Relational Database
6 2 (5.56%) Star Schema
7 1 (2.78%) Big Data
7 1 (2.78%) BusinessObjects
Development Applications
1 3 (8.33%) ERwin
1 3 (8.33%) Subversion
2 1 (2.78%) PowerDesigner
General
1 12 (33.33%) Legal
1 12 (33.33%) Retail
2 5 (13.89%) Finance
3 2 (5.56%) Banking
4 1 (2.78%) Advertising
4 1 (2.78%) Back Office
4 1 (2.78%) Front Office
4 1 (2.78%) Investment Banking
4 1 (2.78%) Marketing
Job Titles
1 12 (33.33%) Data Modeller
2 9 (25.00%) DBA
2 9 (25.00%) SQL DBA
3 6 (16.67%) Analyst
3 6 (16.67%) Development DBA
3 6 (16.67%) Production DBA
4 5 (13.89%) Developer
5 4 (11.11%) Business Analyst
5 4 (11.11%) Business Intelligence Analyst
5 4 (11.11%) Business Intelligence Business Analyst
5 4 (11.11%) Data Business Analyst
5 4 (11.11%) SQL Analyst
5 4 (11.11%) SQL Data Analyst
5 4 (11.11%) UML Analyst
5 4 (11.11%) UML Business Analyst
6 3 (8.33%) Front End Developer (Client-Side Developer)
6 3 (8.33%) MySQL DBA
7 2 (5.56%) Architect
7 2 (5.56%) Data Architect
8 1 (2.78%) Report Analyst
Libraries, Frameworks & Software Standards
1 8 (22.22%) Middleware
1 8 (22.22%) REST
1 8 (22.22%) SOAP
2 5 (13.89%) Web Services
2 5 (13.89%) XML
3 4 (11.11%) MDX
4 3 (8.33%) CSS
4 3 (8.33%) HTML
5 1 (2.78%) .NET
5 1 (2.78%) ASP.NET
Miscellaneous
1 9 (25.00%) Replication
1 9 (25.00%) Statistics
2 5 (13.89%) Analytical Skills
2 5 (13.89%) Computer Science
3 3 (8.33%) Reference Data
4 2 (5.56%) Data Integration
4 2 (5.56%) Enterprise Software
4 2 (5.56%) Semantic Web
5 1 (2.78%) Data Extraction
5 1 (2.78%) Fixed Income
Operating Systems
1 9 (25.00%) Unix
Processes & Methodologies
1 36 (100.00%) Data Modelling
2 31 (86.11%) UML
3 19 (52.78%) Agile Software Development
3 19 (52.78%) ETL
4 15 (41.67%) Business Intelligence
5 13 (36.11%) SDLC
6 12 (33.33%) OO
6 12 (33.33%) OOP
6 12 (33.33%) Waterfall
7 11 (30.56%) SOA
8 10 (27.78%) High Availability
8 10 (27.78%) Open Source
8 10 (27.78%) Performance Tuning
9 9 (25.00%) Database Mirroring
9 9 (25.00%) Database Security
9 9 (25.00%) Enterprise Architecture
10 8 (22.22%) Data Architecture
10 8 (22.22%) Event-Driven Architecture
10 8 (22.22%) Service Design
11 7 (19.44%) Data Analysis
Programming Languages
1 14 (38.89%) SQL
2 9 (25.00%) T-SQL
3 5 (13.89%) Java
4 3 (8.33%) JavaScript
4 3 (8.33%) PowerShell
5 2 (5.56%) C#
Qualifications
1 9 (25.00%) OCP
1 9 (25.00%) Oracle Certification
2 5 (13.89%) Degree
Quality Assurance & Compliance
1 7 (19.44%) Data Quality
2 4 (11.11%) QA
Systems Management
1 9 (25.00%) Failover Clustering
Vendors
1 17 (47.22%) Oracle
2 7 (19.44%) Microsoft
3 4 (11.11%) Tableau
4 3 (8.33%) IBM
4 3 (8.33%) Pega
4 3 (8.33%) Salesforce.com
5 2 (5.56%) Guidewire
5 2 (5.56%) Informatica
6 1 (2.78%) Sony