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

3 months to
28 Jun 2016
Same period 2015 Same period 2014
Entity-Relationship Diagram (ER Diagram)
Rank 622 628 692
Rank change year-on-year
+6 +64
Permanent jobs citing ERD 23 33 8
As % of all permanent IT jobs located in London 0.057% 0.075% 0.016%
As % of the Processes & Methodologies category 0.064% 0.085% 0.019%
Number of salaries quoted 10 22 4
Median salary £57,500 £55,000 £63,750
Median salary % change year-on-year
+4.54% -13.72%
90% offered a salary of more than £54,500 £44,500 £48,250
10% offered a salary of more than £74,250 £77,000 £77,500
UK excluding London median salary £40,000 £52,500 £37,500
% change year-on-year
-23.80% +40.00%
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
35855 38775 43151
As % of all permanent IT jobs located in London 89.61% 87.78% 87.37%
Number of salaries quoted 31077 32542 35850
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 £37,500 £37,500
10% offered a salary of more than £85,000 £80,000 £82,500
UK excluding London median salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

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 28 June 2016.

ERD Salary Histogram in London

ERD
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ERD within the London region over the 3 months to 28 June 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
City of London +59 6 £57,500 +29.21%
ERD
England

ERD
Top 30 Related IT Skills in London

For the 6 months to 28 June 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 41 (73.21%) Agile Software Development
2 37 (66.07%) UML
3 34 (60.71%) Data Modelling
4 30 (53.57%) SQL
5 26 (46.43%) Finance
5 26 (46.43%) Analytical Skills
6 25 (44.64%) Business Intelligence
7 24 (42.86%) Stakeholder Management
7 24 (42.86%) Data Flow Diagram
8 23 (41.07%) PRINCE2
9 22 (39.29%) Data Quality
10 21 (37.50%) Data Warehouse
10 21 (37.50%) SDLC
11 20 (35.71%) User Acceptance Testing
11 20 (35.71%) Data Architecture
12 18 (32.14%) Waterfall
12 18 (32.14%) User Stories
13 17 (30.36%) Kimball Methodology
13 17 (30.36%) Data Analysis
14 16 (28.57%) MDX
14 16 (28.57%) Microsoft
14 16 (28.57%) Analytics
14 16 (28.57%) Tableau
14 16 (28.57%) Wireframes
15 15 (26.79%) Software Delivery
16 14 (25.00%) QA
17 13 (23.21%) Business Analysis
17 13 (23.21%) Telecoms
17 13 (23.21%) Relational Database
18 12 (21.43%) RDBMS

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 5 (8.93%) SharePoint
2 3 (5.36%) Oracle Workflow
3 1 (1.79%) Confluence
Applications
1 9 (16.07%) MS Excel
1 9 (16.07%) MS Visio
2 8 (14.29%) MS Office
Business Applications
1 3 (5.36%) Endur
Cloud Services
1 4 (7.14%) GitHub
Communications & Networking
1 2 (3.57%) Internet
Database & Business Intelligence
1 21 (37.50%) Data Warehouse
2 13 (23.21%) Relational Database
3 12 (21.43%) RDBMS
4 6 (10.71%) SQL Server
5 4 (7.14%) Data Mining
6 3 (5.36%) Big Data
7 1 (1.79%) MongoDB
7 1 (1.79%) NoSQL
Development Applications
1 4 (7.14%) Git (software)
1 4 (7.14%) Grunt
1 4 (7.14%) Jenkins
1 4 (7.14%) PowerDesigner
1 4 (7.14%) Selenium
1 4 (7.14%) Subversion
2 1 (1.79%) JIRA
General
1 26 (46.43%) Finance
2 13 (23.21%) Telecoms
3 11 (19.64%) Back Office
3 11 (19.64%) Legal
4 9 (16.07%) Banking
5 8 (14.29%) Marketing
6 6 (10.71%) Law
7 4 (7.14%) Front Office
7 4 (7.14%) Investment Banking
7 4 (7.14%) Retail
8 3 (5.36%) Billing
9 2 (3.57%) Local Government
Job Titles
1 37 (66.07%) Analyst
2 35 (62.50%) Business Analyst
3 22 (39.29%) Business Intelligence Analyst
4 21 (37.50%) Business Intelligence Business Analyst
5 7 (12.50%) Architect
5 7 (12.50%) Business IT Analyst
5 7 (12.50%) IT Analyst
5 7 (12.50%) IT Business Analyst
6 5 (8.93%) Data Architect
6 5 (8.93%) Data Business Analyst
6 5 (8.93%) SQL Analyst
6 5 (8.93%) SQL Data Analyst
6 5 (8.93%) UML Analyst
6 5 (8.93%) UML Business Analyst
7 4 (7.14%) Data Engineer
7 4 (7.14%) Data Modeller
7 4 (7.14%) Developer
8 3 (5.36%) Implementation Analyst
8 3 (5.36%) Senior Analyst
8 3 (5.36%) Senior Business Analyst
Libraries, Frameworks & Software Standards
1 16 (28.57%) MDX
2 5 (8.93%) XML
3 4 (7.14%) AngularJS
3 4 (7.14%) Backbone.js
3 4 (7.14%) CSS
3 4 (7.14%) Dojo
3 4 (7.14%) HTML
3 4 (7.14%) Node.js
3 4 (7.14%) React
3 4 (7.14%) Web Services
Miscellaneous
1 26 (46.43%) Analytical Skills
2 8 (14.29%) Computer Science
3 7 (12.50%) Client/Server
3 7 (12.50%) N-Tier
4 4 (7.14%) Fixed Income
4 4 (7.14%) User Experience
5 3 (5.36%) Swaptions
6 2 (3.57%) Hedge funds
6 2 (3.57%) Internet of Things
7 1 (1.79%) Data Extraction
7 1 (1.79%) Economics
7 1 (1.79%) Spread Betting
7 1 (1.79%) Wiki
Operating Systems
1 6 (10.71%) Windows
1 6 (10.71%) Windows 7
1 6 (10.71%) Windows 8
Processes & Methodologies
1 41 (73.21%) Agile Software Development
2 37 (66.07%) UML
3 34 (60.71%) Data Modelling
4 25 (44.64%) Business Intelligence
5 24 (42.86%) Data Flow Diagram
5 24 (42.86%) Stakeholder Management
6 23 (41.07%) PRINCE2
7 21 (37.50%) SDLC
8 20 (35.71%) Data Architecture
8 20 (35.71%) User Acceptance Testing
9 18 (32.14%) User Stories
9 18 (32.14%) Waterfall
10 17 (30.36%) Data Analysis
10 17 (30.36%) Kimball Methodology
11 16 (28.57%) Analytics
11 16 (28.57%) Wireframes
12 15 (26.79%) Software Delivery
13 13 (23.21%) Business Analysis
14 8 (14.29%) ETL
14 8 (14.29%) Workflow
Programming Languages
1 30 (53.57%) SQL
2 7 (12.50%) Java
3 5 (8.93%) PL/SQL
4 4 (7.14%) JavaScript
Quality Assurance & Compliance
1 22 (39.29%) Data Quality
2 14 (25.00%) QA
Vendors
1 16 (28.57%) Microsoft
1 16 (28.57%) Tableau
2 8 (14.29%) Oracle
3 5 (8.93%) Cognos
4 3 (5.36%) OpenLink
4 3 (5.36%) TIBCO
5 1 (1.79%) Atlassian
5 1 (1.79%) Cloudera