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

3 months to
30 Aug 2016
Same period 2015 Same period 2014
Entity-Relationship Diagram (ER Diagram)
Rank 590 627 655
Rank change year-on-year
+37 +28
Permanent jobs citing ERD 28 33 18
As % of all permanent IT jobs located in London 0.071% 0.076% 0.039%
As % of the Processes & Methodologies category 0.080% 0.086% 0.045%
Number of salaries quoted 22 24 17
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 £49,000
10% offered a salary of more than £60,000 £77,000 £77,500
UK excluding London median salary £40,000 £49,000 £41,250
% change year-on-year
-18.36% +18.78%
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
35199 38278 40360
As % of all permanent IT jobs located in London 89.84% 88.26% 87.04%
Number of salaries quoted 30501 32260 33268
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 £37,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 30 August 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 30 August 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 - 10 £52,500 - 1
ERD
England

ERD
Top 30 Related IT Skills in London

For the 6 months to 30 August 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 54 (87.10%) Data Modelling
2 52 (83.87%) UML
3 43 (69.35%) Agile Software Development
4 31 (50.00%) SQL
5 29 (46.77%) Business Intelligence
6 26 (41.94%) SDLC
7 25 (40.32%) Waterfall
7 25 (40.32%) Data Architecture
8 24 (38.71%) Finance
9 22 (35.48%) Stakeholder Management
9 22 (35.48%) Data Flow Diagram
10 21 (33.87%) Data Warehouse
11 20 (32.26%) Analytical Skills
12 19 (30.65%) User Stories
12 19 (30.65%) Kimball Methodology
12 19 (30.65%) PRINCE2
12 19 (30.65%) User Acceptance Testing
13 18 (29.03%) MDX
13 18 (29.03%) Data Analysis
13 18 (29.03%) Microsoft
13 18 (29.03%) Tableau
13 18 (29.03%) Data Quality
13 18 (29.03%) Wireframes
14 16 (25.81%) Software Delivery
14 16 (25.81%) Legal
14 16 (25.81%) QA
15 15 (24.19%) ETL
16 14 (22.58%) Oracle
17 13 (20.97%) SOA
17 13 (20.97%) Retail

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 (1.61%) Confluence
Applications
1 7 (11.29%) MS Visio
2 5 (8.06%) MS Excel
3 3 (4.84%) MS Office
Business Applications
1 3 (4.84%) Endur
Cloud Services
1 4 (6.45%) GitHub
Communications & Networking
1 2 (3.23%) Internet
Database & Business Intelligence
1 21 (33.87%) Data Warehouse
2 9 (14.52%) SQL Server
3 7 (11.29%) SQL Server Analysis Services
3 7 (11.29%) SQL Server Integration Services
3 7 (11.29%) SQL Server Reporting Services
4 5 (8.06%) Relational Database
5 4 (6.45%) NoSQL
5 4 (6.45%) SQL Server 2005
5 4 (6.45%) SQL Server 2008
5 4 (6.45%) SQL Server 2012
6 3 (4.84%) Big Data
6 3 (4.84%) MySQL
7 2 (3.23%) RDBMS
8 1 (1.61%) BusinessObjects
8 1 (1.61%) Data Mining
8 1 (1.61%) MongoDB
Development Applications
1 7 (11.29%) Subversion
2 4 (6.45%) Git (software)
2 4 (6.45%) Grunt
2 4 (6.45%) Jenkins
2 4 (6.45%) PowerDesigner
2 4 (6.45%) Selenium
3 3 (4.84%) ERwin
4 1 (1.61%) JIRA
General
1 24 (38.71%) Finance
2 16 (25.81%) Legal
3 13 (20.97%) Retail
4 10 (16.13%) Telecoms
5 8 (12.90%) Banking
5 8 (12.90%) Marketing
6 6 (9.68%) Back Office
7 4 (6.45%) Front Office
7 4 (6.45%) Investment Banking
8 2 (3.23%) Law
9 1 (1.61%) Local Government
Job Titles
1 28 (45.16%) Analyst
2 27 (43.55%) Business Analyst
3 19 (30.65%) Business Intelligence Analyst
3 19 (30.65%) Business Intelligence Business Analyst
4 13 (20.97%) Data Modeller
5 9 (14.52%) Data Business Analyst
5 9 (14.52%) Developer
5 9 (14.52%) SQL Analyst
5 9 (14.52%) SQL Data Analyst
5 9 (14.52%) UML Analyst
5 9 (14.52%) UML Business Analyst
6 7 (11.29%) DBA
6 7 (11.29%) SQL DBA
7 6 (9.68%) Front End Developer (Client-Side Developer)
8 4 (6.45%) Architect
8 4 (6.45%) Data Architect
8 4 (6.45%) Development DBA
8 4 (6.45%) Production DBA
9 3 (4.84%) Senior Business Analyst
9 3 (4.84%) UI Developer
Libraries, Frameworks & Software Standards
1 18 (29.03%) MDX
2 7 (11.29%) CSS
2 7 (11.29%) HTML
2 7 (11.29%) Web Services
2 7 (11.29%) XML
3 6 (9.68%) Middleware
3 6 (9.68%) REST
3 6 (9.68%) SOAP
4 4 (6.45%) AngularJS
4 4 (6.45%) Backbone.js
4 4 (6.45%) Dojo
4 4 (6.45%) Node.js
4 4 (6.45%) React
Miscellaneous
1 20 (32.26%) Analytical Skills
2 11 (17.74%) Computer Science
3 7 (11.29%) Replication
3 7 (11.29%) Statistics
4 4 (6.45%) Fixed Income
4 4 (6.45%) User Experience
5 3 (4.84%) Reference Data
5 3 (4.84%) Swaptions
6 2 (3.23%) Client/Server
6 2 (3.23%) Hedge funds
6 2 (3.23%) Internet of Things
6 2 (3.23%) N-Tier
7 1 (1.61%) Data Extraction
7 1 (1.61%) Economics
Operating Systems
1 7 (11.29%) Unix
2 2 (3.23%) Windows
2 2 (3.23%) Windows 7
2 2 (3.23%) Windows 8
Processes & Methodologies
1 54 (87.10%) Data Modelling
2 52 (83.87%) UML
3 43 (69.35%) Agile Software Development
4 29 (46.77%) Business Intelligence
5 26 (41.94%) SDLC
6 25 (40.32%) Data Architecture
6 25 (40.32%) Waterfall
7 22 (35.48%) Data Flow Diagram
7 22 (35.48%) Stakeholder Management
8 19 (30.65%) Kimball Methodology
8 19 (30.65%) PRINCE2
8 19 (30.65%) User Acceptance Testing
8 19 (30.65%) User Stories
9 18 (29.03%) Data Analysis
9 18 (29.03%) Wireframes
10 16 (25.81%) Software Delivery
11 15 (24.19%) ETL
12 13 (20.97%) SOA
13 11 (17.74%) Analytics
13 11 (17.74%) Enterprise Architecture
Programming Languages
1 31 (50.00%) SQL
2 12 (19.35%) Java
3 7 (11.29%) JavaScript
3 7 (11.29%) T-SQL
4 3 (4.84%) PowerShell
5 2 (3.23%) C#
6 1 (1.61%) PL/SQL
Qualifications
1 7 (11.29%) OCP
1 7 (11.29%) Oracle Certification
2 3 (4.84%) Degree
Quality Assurance & Compliance
1 18 (29.03%) Data Quality
2 16 (25.81%) QA
Systems Management
1 7 (11.29%) Failover Clustering
Vendors
1 18 (29.03%) Microsoft
1 18 (29.03%) Tableau
2 14 (22.58%) Oracle
3 3 (4.84%) IBM
3 3 (4.84%) OpenLink
3 3 (4.84%) Pega
3 3 (4.84%) Salesforce.com
3 3 (4.84%) TIBCO
4 2 (3.23%) Guidewire
5 1 (1.61%) Atlassian
5 1 (1.61%) Cloudera
5 1 (1.61%) Sony
London
Nigel Frank International Ltd
Salary: £42000 - £50000 per annum
Posted: 4 days ago
City of London
Streamline Connections Ltd
Salary: £45000 - £55000.00 per annum + Bonus + Benefits
Posted: 5 days ago