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

3 months to
29 Sep 2016
Same period 2015 Same period 2014
Entity-Relationship Diagram (ER Diagram)
Rank 594 643 650
Rank change year-on-year
+49 +7
Permanent jobs citing ERD 30 25 19
As % of all permanent IT jobs located in London 0.079% 0.057% 0.041%
As % of the Processes & Methodologies category 0.088% 0.064% 0.048%
Number of salaries quoted 26 19 18
Median salary £52,500 £60,000 £56,000
Median salary % change year-on-year
-12.50% +7.14%
90% offered a salary of more than £50,000 £45,000 £45,000
10% offered a salary of more than £60,000 £77,000 £77,500
UK excluding London median salary £42,500 £41,250 £48,000
% change year-on-year
+3.03% -14.06%
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
34035 38880 39816
As % of all permanent IT jobs located in London 89.79% 88.28% 86.75%
Number of salaries quoted 29400 32828 32754
Median salary £60,000 £58,000 £55,000
Median salary % change year-on-year
+3.44% +5.45%
90% offered a salary of more than £40,000 £38,000 £37,500
10% offered a salary of more than £85,000 £80,000 £82,500
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 29 September 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 29 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
City of London +62 13 £52,500 +16.66%
ERD
England

ERD
Top 30 Related IT Skills in London

For the 6 months to 29 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 across the London region with a requirement for ERD.

1 50 (96.15%) Data Modelling
2 47 (90.38%) UML
3 35 (67.31%) Agile Software Development
4 24 (46.15%) SQL
5 22 (42.31%) Business Intelligence
6 21 (40.38%) SDLC
7 20 (38.46%) Waterfall
8 19 (36.54%) Data Architecture
9 18 (34.62%) ETL
9 18 (34.62%) Finance
10 15 (28.85%) Legal
10 15 (28.85%) Oracle
11 14 (26.92%) Stakeholder Management
12 13 (25.00%) SOA
12 13 (25.00%) Retail
12 13 (25.00%) Data Analysis
12 13 (25.00%) User Acceptance Testing
12 13 (25.00%) Data Flow Diagram
13 12 (23.08%) Wireframes
13 12 (23.08%) Kimball Methodology
13 12 (23.08%) User Stories
13 12 (23.08%) Analytical Skills
13 12 (23.08%) Enterprise Architecture
13 12 (23.08%) MDX
13 12 (23.08%) Tableau
13 12 (23.08%) Data Quality
13 12 (23.08%) Data Warehouse
13 12 (23.08%) Microsoft
13 12 (23.08%) OO
14 11 (21.15%) OOP

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 8 (15.38%) MS Visio
2 2 (3.85%) MS Excel
3 1 (1.92%) MS Office
Business Applications
1 1 (1.92%) Endur
Cloud Services
1 4 (7.69%) GitHub
Database & Business Intelligence
1 12 (23.08%) Data Warehouse
2 9 (17.31%) SQL Server
2 9 (17.31%) SQL Server Analysis Services
2 9 (17.31%) SQL Server Integration Services
2 9 (17.31%) SQL Server Reporting Services
3 6 (11.54%) SQL Server 2005
3 6 (11.54%) SQL Server 2008
3 6 (11.54%) SQL Server 2012
4 4 (7.69%) NoSQL
5 3 (5.77%) MySQL
5 3 (5.77%) Relational Database
6 1 (1.92%) Big Data
6 1 (1.92%) BusinessObjects
6 1 (1.92%) MongoDB
Development Applications
1 7 (13.46%) Subversion
2 4 (7.69%) Git (software)
2 4 (7.69%) Grunt
2 4 (7.69%) Jenkins
2 4 (7.69%) PowerDesigner
2 4 (7.69%) Selenium
3 3 (5.77%) ERwin
General
1 18 (34.62%) Finance
2 15 (28.85%) Legal
3 13 (25.00%) Retail
4 9 (17.31%) Banking
5 6 (11.54%) Marketing
6 4 (7.69%) Back Office
6 4 (7.69%) Front Office
6 4 (7.69%) Investment Banking
6 4 (7.69%) Telecoms
Job Titles
1 16 (30.77%) Analyst
2 15 (28.85%) Business Analyst
2 15 (28.85%) Data Modeller
3 12 (23.08%) Business Intelligence Analyst
3 12 (23.08%) Business Intelligence Business Analyst
4 9 (17.31%) DBA
4 9 (17.31%) Developer
4 9 (17.31%) SQL DBA
5 8 (15.38%) Data Business Analyst
5 8 (15.38%) SQL Analyst
5 8 (15.38%) SQL Data Analyst
5 8 (15.38%) UML Analyst
5 8 (15.38%) UML Business Analyst
6 6 (11.54%) Development DBA
6 6 (11.54%) Front End Developer (Client-Side Developer)
6 6 (11.54%) Production DBA
7 3 (5.77%) MySQL DBA
7 3 (5.77%) UI Developer
8 2 (3.85%) Architect
8 2 (3.85%) Data Architect
Libraries, Frameworks & Software Standards
1 12 (23.08%) MDX
2 8 (15.38%) Middleware
2 8 (15.38%) REST
2 8 (15.38%) SOAP
2 8 (15.38%) Web Services
3 7 (13.46%) CSS
3 7 (13.46%) HTML
3 7 (13.46%) XML
4 4 (7.69%) AngularJS
4 4 (7.69%) Backbone.js
4 4 (7.69%) Dojo
4 4 (7.69%) Node.js
4 4 (7.69%) React
Miscellaneous
1 12 (23.08%) Analytical Skills
2 9 (17.31%) Computer Science
2 9 (17.31%) Replication
2 9 (17.31%) Statistics
3 4 (7.69%) Fixed Income
3 4 (7.69%) User Experience
4 3 (5.77%) Reference Data
5 1 (1.92%) Data Extraction
5 1 (1.92%) Economics
5 1 (1.92%) Hedge funds
5 1 (1.92%) Swaptions
Operating Systems
1 9 (17.31%) Unix
Processes & Methodologies
1 50 (96.15%) Data Modelling
2 47 (90.38%) UML
3 35 (67.31%) Agile Software Development
4 22 (42.31%) Business Intelligence
5 21 (40.38%) SDLC
6 20 (38.46%) Waterfall
7 19 (36.54%) Data Architecture
8 18 (34.62%) ETL
9 14 (26.92%) Stakeholder Management
10 13 (25.00%) Data Analysis
10 13 (25.00%) Data Flow Diagram
10 13 (25.00%) SOA
10 13 (25.00%) User Acceptance Testing
11 12 (23.08%) Enterprise Architecture
11 12 (23.08%) Kimball Methodology
11 12 (23.08%) OO
11 12 (23.08%) User Stories
11 12 (23.08%) Wireframes
12 11 (21.15%) OOP
12 11 (21.15%) PRINCE2
Programming Languages
1 24 (46.15%) SQL
2 10 (19.23%) Java
3 9 (17.31%) T-SQL
4 7 (13.46%) JavaScript
5 3 (5.77%) PowerShell
6 2 (3.85%) C#
Qualifications
1 9 (17.31%) OCP
1 9 (17.31%) Oracle Certification
2 3 (5.77%) Degree
Quality Assurance & Compliance
1 12 (23.08%) Data Quality
2 11 (21.15%) QA
Systems Management
1 9 (17.31%) Failover Clustering
Vendors
1 15 (28.85%) Oracle
2 12 (23.08%) Microsoft
2 12 (23.08%) Tableau
3 3 (5.77%) IBM
3 3 (5.77%) Pega
3 3 (5.77%) Salesforce.com
4 2 (3.85%) Guidewire
5 1 (1.92%) Cloudera
5 1 (1.92%) OpenLink
5 1 (1.92%) Sony
5 1 (1.92%) TIBCO