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

3 months to
24 Feb 2017
Same period 2016 Same period 2015
Entity-Relationship Diagram (ER Diagram)
England / London
Rank 571 627 636
Rank change year-on-year
+56 +9
Permanent jobs citing ERD 3 26 9
As % of all permanent IT jobs located in London 0.009% 0.063% 0.022%
As % of the Processes & Methodologies category 0.010% 0.071% 0.025%
Number of salaries quoted 3 23 8
Median salary £90,000 £47,500 £70,000
Median salary % change year-on-year
+89.47% -32.14%
UK excluding London median salary £50,000 £50,000 £40,000
% change year-on-year
- +25.00%

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
30061 36719 36465
As % of all permanent IT jobs located in London 89.95% 89.25% 87.12%
Number of salaries quoted 25224 31355 30572
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 £39,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 24 February 2017.

ERD Salary Histogram in London

ERD
Top 30 Related IT Skills in London

For the 6 months to 24 February 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 14 (100.00%) Data Modelling
2 10 (71.43%) UML
3 8 (57.14%) ETL
4 6 (42.86%) Business Intelligence
4 6 (42.86%) SQL Server
5 5 (35.71%) Data Warehouse
5 5 (35.71%) SQL
5 5 (35.71%) Oracle
5 5 (35.71%) Data Quality
6 4 (28.57%) Master Data Management
6 4 (28.57%) Data Integration
6 4 (28.57%) Agile Software Development
6 4 (28.57%) Retail
6 4 (28.57%) Data Management
6 4 (28.57%) Microsoft
7 3 (21.43%) Middleware
7 3 (21.43%) SOA
7 3 (21.43%) SOAP
7 3 (21.43%) Web Services
7 3 (21.43%) OOP
7 3 (21.43%) OO
7 3 (21.43%) Legal
7 3 (21.43%) Data Analysis
7 3 (21.43%) SQL Server Integration Services
7 3 (21.43%) Enterprise Architecture
7 3 (21.43%) Computer Science
7 3 (21.43%) Open Source
7 3 (21.43%) REST
7 3 (21.43%) High Availability
7 3 (21.43%) Performance Tuning

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:

Applications
1 2 (14.29%) MS Excel
1 2 (14.29%) MS Visio
Database & Business Intelligence
1 6 (42.86%) SQL Server
2 5 (35.71%) Data Warehouse
3 3 (21.43%) SQL Server Integration Services
4 2 (14.29%) Enterprise Data Warehouse
4 2 (14.29%) Hadoop
4 2 (14.29%) NoSQL
4 2 (14.29%) SQL Server 2005
4 2 (14.29%) SQL Server 2008
4 2 (14.29%) SQL Server 2012
4 2 (14.29%) SQL Server Analysis Services
4 2 (14.29%) SQL Server Reporting Services
4 2 (14.29%) Star Schema
5 1 (7.14%) Big Data
General
1 4 (28.57%) Retail
2 3 (21.43%) Legal
3 2 (14.29%) Finance
4 1 (7.14%) Advertising
4 1 (7.14%) Banking
Job Titles
1 4 (28.57%) Architect
2 3 (21.43%) Business Intelligence Lead
2 3 (21.43%) Data Modeller
3 2 (14.29%) Analyst
3 2 (14.29%) Business Intelligence Architect
3 2 (14.29%) Data Architect
3 2 (14.29%) DBA
3 2 (14.29%) Development DBA
3 2 (14.29%) Lead Architect
3 2 (14.29%) Production DBA
3 2 (14.29%) SQL DBA
4 1 (7.14%) Business Analyst
4 1 (7.14%) Business Intelligence Analyst
4 1 (7.14%) Business Systems Analyst
4 1 (7.14%) Developer
4 1 (7.14%) Development Analyst
4 1 (7.14%) Report Analyst
4 1 (7.14%) Strategy Analyst
4 1 (7.14%) Systems Analyst
4 1 (7.14%) UML Business Analyst
Libraries, Frameworks & Software Standards
1 3 (21.43%) Middleware
1 3 (21.43%) REST
1 3 (21.43%) SOAP
1 3 (21.43%) Web Services
2 2 (14.29%) Kafka
2 2 (14.29%) XML
3 1 (7.14%) .NET
3 1 (7.14%) ASP.NET
3 1 (7.14%) CSS
3 1 (7.14%) HTML
3 1 (7.14%) MDX
Miscellaneous
1 3 (21.43%) Computer Science
2 2 (14.29%) Data Structures
2 2 (14.29%) Enterprise Software
2 2 (14.29%) Replication
2 2 (14.29%) Semantic Web
3 1 (7.14%) Analytical Skills
Operating Systems
1 2 (14.29%) Unix
Processes & Methodologies
1 14 (100.00%) Data Modelling
2 10 (71.43%) UML
3 8 (57.14%) ETL
4 6 (42.86%) Business Intelligence
5 4 (28.57%) Agile Software Development
5 4 (28.57%) Data Integration
5 4 (28.57%) Data Management
5 4 (28.57%) Master Data Management
6 3 (21.43%) Data Analysis
6 3 (21.43%) Enterprise Architecture
6 3 (21.43%) Event-Driven Architecture
6 3 (21.43%) High Availability
6 3 (21.43%) OO
6 3 (21.43%) OOP
6 3 (21.43%) Open Source
6 3 (21.43%) Performance Tuning
6 3 (21.43%) SDLC
6 3 (21.43%) Service Design
6 3 (21.43%) SOA
7 2 (14.29%) EAI
Programming Languages
1 5 (35.71%) SQL
2 2 (14.29%) T-SQL
3 1 (7.14%) Java
3 1 (7.14%) JavaScript
Qualifications
1 2 (14.29%) Degree
1 2 (14.29%) OCP
1 2 (14.29%) Oracle Certification
Quality Assurance & Compliance
1 5 (35.71%) Data Quality
2 1 (7.14%) QA
Systems Management
1 2 (14.29%) Failover Clustering
Vendors
1 5 (35.71%) Oracle
2 4 (28.57%) Microsoft
3 2 (14.29%) Informatica
4 1 (7.14%) IBM
4 1 (7.14%) Pega
4 1 (7.14%) Salesforce.com
4 1 (7.14%) Tableau