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 20 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
20 Jan 2017
Same period 2016 Same period 2015
Entity-Relationship Diagram (ER Diagram)
England / London
Rank 568 623 630
Rank change year-on-year
+55 +7
Permanent jobs citing ERD 6 23 14
As % of all permanent IT jobs located in London 0.018% 0.057% 0.034%
As % of the Processes & Methodologies category 0.020% 0.064% 0.039%
Number of salaries quoted 6 21 11
Median salary £65,000 £47,500 £70,000
Median salary % change year-on-year
+36.84% -32.14%
UK excluding London median salary £50,000 £39,750 £40,000
% change year-on-year
+25.78% -0.62%

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
29815 35851 35661
As % of all permanent IT jobs located in London 89.08% 88.48% 86.35%
Number of salaries quoted 25171 30627 30107
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 £39,000 £40,000 £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 20 January 2017.

ERD Salary Histogram in London

ERD
Top 30 Related IT Skills in London

For the 6 months to 20 January 2017, 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 26 (100.00%) Data Modelling
2 21 (80.77%) UML
3 16 (61.54%) ETL
4 14 (53.85%) Oracle
5 13 (50.00%) Agile Software Development
6 12 (46.15%) SQL Server
6 12 (46.15%) Business Intelligence
7 11 (42.31%) SQL
8 10 (38.46%) OOP
8 10 (38.46%) OO
9 9 (34.62%) SQL Server Integration Services
9 9 (34.62%) Legal
9 9 (34.62%) Open Source
9 9 (34.62%) High Availability
9 9 (34.62%) Performance Tuning
9 9 (34.62%) SDLC
10 8 (30.77%) Database Mirroring
10 8 (30.77%) Database Security
10 8 (30.77%) Waterfall
10 8 (30.77%) Statistics
10 8 (30.77%) SQL Server Analysis Services
10 8 (30.77%) Replication
10 8 (30.77%) SQL Server Reporting Services
10 8 (30.77%) T-SQL
10 8 (30.77%) Unix
10 8 (30.77%) OCP
10 8 (30.77%) Oracle Certification
10 8 (30.77%) Failover Clustering
11 7 (26.92%) Retail
12 6 (23.08%) SQL Server 2005

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 1 (3.85%) Oracle SOA Suite
Applications
1 4 (15.38%) MS Visio
2 2 (7.69%) MS Excel
Database & Business Intelligence
1 12 (46.15%) SQL Server
2 9 (34.62%) SQL Server Integration Services
3 8 (30.77%) SQL Server Analysis Services
3 8 (30.77%) SQL Server Reporting Services
4 6 (23.08%) SQL Server 2005
4 6 (23.08%) SQL Server 2008
4 6 (23.08%) SQL Server 2012
5 5 (19.23%) Data Warehouse
6 4 (15.38%) NoSQL
7 2 (7.69%) Enterprise Data Warehouse
7 2 (7.69%) Hadoop
7 2 (7.69%) MySQL
7 2 (7.69%) Star Schema
8 1 (3.85%) Big Data
8 1 (3.85%) Relational Database
Development Applications
1 1 (3.85%) ERwin
1 1 (3.85%) Subversion
General
1 9 (34.62%) Legal
2 7 (26.92%) Retail
3 4 (15.38%) Finance
4 1 (3.85%) Advertising
4 1 (3.85%) Banking
Job Titles
1 8 (30.77%) DBA
1 8 (30.77%) SQL DBA
2 6 (23.08%) Data Modeller
2 6 (23.08%) Development DBA
2 6 (23.08%) Production DBA
3 4 (15.38%) Architect
3 4 (15.38%) Developer
4 3 (11.54%) Business Intelligence Lead
4 3 (11.54%) Front End Developer (Client-Side Developer)
5 2 (7.69%) Analyst
5 2 (7.69%) Business Intelligence Architect
5 2 (7.69%) Data Architect
5 2 (7.69%) Lead Architect
5 2 (7.69%) MySQL DBA
6 1 (3.85%) Business Analyst
6 1 (3.85%) Business Intelligence Analyst
6 1 (3.85%) Business Systems Analyst
6 1 (3.85%) Report Analyst
6 1 (3.85%) Systems Analyst
6 1 (3.85%) UML Business Analyst
Libraries, Frameworks & Software Standards
1 5 (19.23%) Middleware
1 5 (19.23%) REST
1 5 (19.23%) SOAP
1 5 (19.23%) Web Services
2 3 (11.54%) CSS
2 3 (11.54%) HTML
2 3 (11.54%) XML
3 2 (7.69%) Kafka
4 1 (3.85%) .NET
4 1 (3.85%) ASP.NET
4 1 (3.85%) MDX
Miscellaneous
1 8 (30.77%) Replication
1 8 (30.77%) Statistics
2 5 (19.23%) Computer Science
3 4 (15.38%) Data Integration
4 2 (7.69%) Data Structures
4 2 (7.69%) Enterprise Software
4 2 (7.69%) Semantic Web
5 1 (3.85%) Analytical Skills
5 1 (3.85%) Reference Data
Operating Systems
1 8 (30.77%) Unix
Processes & Methodologies
1 26 (100.00%) Data Modelling
2 21 (80.77%) UML
3 16 (61.54%) ETL
4 13 (50.00%) Agile Software Development
5 12 (46.15%) Business Intelligence
6 10 (38.46%) OO
6 10 (38.46%) OOP
7 9 (34.62%) High Availability
7 9 (34.62%) Open Source
7 9 (34.62%) Performance Tuning
7 9 (34.62%) SDLC
8 8 (30.77%) Database Mirroring
8 8 (30.77%) Database Security
8 8 (30.77%) Waterfall
9 6 (23.08%) SOA
10 5 (19.23%) Enterprise Architecture
10 5 (19.23%) Event-Driven Architecture
10 5 (19.23%) Service Design
11 4 (15.38%) Master Data Management
11 4 (15.38%) Translating Business Requirements
Programming Languages
1 11 (42.31%) SQL
2 8 (30.77%) T-SQL
3 4 (15.38%) Java
4 3 (11.54%) JavaScript
5 2 (7.69%) PowerShell
6 1 (3.85%) C#
Qualifications
1 8 (30.77%) OCP
1 8 (30.77%) Oracle Certification
2 3 (11.54%) Degree
Quality Assurance & Compliance
1 5 (19.23%) Data Quality
2 1 (3.85%) QA
Systems Management
1 8 (30.77%) Failover Clustering
Vendors
1 14 (53.85%) Oracle
2 4 (15.38%) Microsoft
3 3 (11.54%) IBM
3 3 (11.54%) Pega
3 3 (11.54%) Salesforce.com
4 2 (7.69%) Informatica
5 1 (3.85%) Guidewire
5 1 (3.85%) Tableau