The table below looks at the statistics for ERD skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited ERD over the 3 months to 28 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
28 Jul 2016
Same period 2015 Same period 2014
Entity-Relationship Diagram (ER Diagram)
Rank 875 909 963
Rank change year-on-year
+34 +54
Permanent jobs citing ERD 40 59 30
As % of all permanent IT jobs located in the UK 0.041% 0.054% 0.025%
As % of the Processes & Methodologies category 0.046% 0.062% 0.030%
Number of salaries quoted 26 45 23
Median salary £50,000 £55,000 £50,000
Median salary % change year-on-year
-9.09% +10.00%
90% offered a salary of more than £40,000 £42,200 £37,500
10% offered a salary of more than £60,000 £77,000 £73,300
UK excluding London median salary £40,000 £52,500 £40,000
% change year-on-year
-23.80% +31.25%

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised across the UK.

Processes & Methodologies Category
UK
Permanent IT job ads with a match in the
Processes & Methodologies category
86142 95892 100545
As % of all permanent IT jobs located in the UK 87.84% 87.29% 85.37%
Number of salaries quoted 71917 78502 81138
Median salary £50,000 £50,000 £48,000
Median salary % change year-on-year
- +4.16%
90% offered a salary of more than £32,500 £32,000 £31,000
10% offered a salary of more than £77,500 £72,500 £75,000
UK excluding London median salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

ERD
Jobs Demand Trend

The demand trend of job ads citing ERD as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ERD Jobs Demand Trend in the UK

ERD
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ERD within the UK.

ERD Salary Trend in the UK

ERD
Salary Histogram

This chart provides a salary histogram for IT jobs citing ERD over the 3 months to 28 July 2016 within the UK.

ERD Salary Histogram in the UK

ERD
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ERD within the UK over the 3 months to 28 July 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
England +28 38 £50,000 -9.09% 3
London +32 28 £57,500 +4.54% 3
City of London +68 7 £57,500 +29.21% 1
West Midlands - 6 £40,000 -
York - 3 £32,500 -
North Yorkshire - 3 £32,500 -
Birmingham - 3 £40,000 -
West Bromwich - 3 £40,000 -
Coventry - 3 £40,000 -
Yorkshire - 3 £32,500 -
Glasgow - 2 - -
Scotland - 2 - -
North West - 1 - -
Manchester - 1 - -

ERD
Top 30 Related IT Skills

For the 6 months to 28 July 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 with a requirement for ERD.

1 64 (65.98%) UML
2 63 (64.95%) Data Modelling
3 58 (59.79%) Agile Software Development
4 49 (50.52%) SQL
5 35 (36.08%) SDLC
6 34 (35.05%) Analytical Skills
7 33 (34.02%) Business Intelligence
8 31 (31.96%) Data Warehouse
8 31 (31.96%) Stakeholder Management
9 30 (30.93%) Business Analysis
10 27 (27.84%) Finance
11 25 (25.77%) PRINCE2
12 24 (24.74%) Retail
12 24 (24.74%) User Acceptance Testing
12 24 (24.74%) Data Architecture
12 24 (24.74%) Data Quality
12 24 (24.74%) Data Flow Diagram
13 23 (23.71%) Microsoft
14 22 (22.68%) Tableau
15 20 (20.62%) Waterfall
15 20 (20.62%) Data Analysis
16 19 (19.59%) Analytics
16 19 (19.59%) User Stories
16 19 (19.59%) Use Case
17 18 (18.56%) Kimball Methodology
17 18 (18.56%) Project Management
17 18 (18.56%) MS Excel
17 18 (18.56%) Oracle
18 17 (17.53%) Relational Database
18 17 (17.53%) MDX

ERD
Top Related IT Skills 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 (5.15%) IIS
1 5 (5.15%) SharePoint
2 3 (3.09%) Oracle Workflow
3 1 (1.03%) Confluence
Applications
1 18 (18.56%) MS Excel
2 9 (9.28%) MS Office
2 9 (9.28%) MS Visio
Business Applications
1 5 (5.15%) Dynamics CRM
2 3 (3.09%) Endur
Cloud Services
1 4 (4.12%) GitHub
Communications & Networking
1 2 (2.06%) Internet
Database & Business Intelligence
1 31 (31.96%) Data Warehouse
2 17 (17.53%) Relational Database
3 15 (15.46%) RDBMS
3 15 (15.46%) SQL Server
4 6 (6.19%) SQL Server Reporting Services
5 5 (5.15%) QlikView
6 4 (4.12%) Data Mining
6 4 (4.12%) Star Schema
7 3 (3.09%) Big Data
8 2 (2.06%) NoSQL
9 1 (1.03%) BusinessObjects
9 1 (1.03%) MongoDB
9 1 (1.03%) MySQL
9 1 (1.03%) Oracle Database
9 1 (1.03%) SQL Server Analysis Services
9 1 (1.03%) SQL Server Integration Services
Development Applications
1 7 (7.22%) Subversion
2 5 (5.15%) Visual Studio
3 4 (4.12%) Git (software)
3 4 (4.12%) Grunt
3 4 (4.12%) Jenkins
3 4 (4.12%) PowerDesigner
3 4 (4.12%) Selenium
4 3 (3.09%) ERwin
5 1 (1.03%) JIRA
General
1 27 (27.84%) Finance
2 24 (24.74%) Retail
3 15 (15.46%) Legal
4 13 (13.40%) Telecoms
5 10 (10.31%) Back Office
6 9 (9.28%) Banking
7 8 (8.25%) Marketing
8 5 (5.15%) Law
9 4 (4.12%) Front Office
9 4 (4.12%) Investment Banking
10 3 (3.09%) Billing
11 2 (2.06%) Local Government
12 1 (1.03%) Electronics
Job Titles
1 53 (54.64%) Analyst
2 49 (50.52%) Business Analyst
3 23 (23.71%) Business Intelligence Analyst
4 22 (22.68%) Business Intelligence Business Analyst
5 11 (11.34%) Data Modeller
6 10 (10.31%) Developer
7 8 (8.25%) Architect
7 8 (8.25%) Data Business Analyst
7 8 (8.25%) SQL Analyst
7 8 (8.25%) SQL Data Analyst
7 8 (8.25%) UML Analyst
7 8 (8.25%) UML Business Analyst
8 6 (6.19%) Business IT Analyst
8 6 (6.19%) IT Analyst
8 6 (6.19%) IT Business Analyst
9 5 (5.15%) .NET Developer
9 5 (5.15%) Business Intelligence Developer
9 5 (5.15%) Lead Business Analyst
9 5 (5.15%) SQL Developer
9 5 (5.15%) Systems Developer
Libraries, Frameworks & Software Standards
1 17 (17.53%) MDX
2 10 (10.31%) XML
3 9 (9.28%) Web Services
4 5 (5.15%) .NET
4 5 (5.15%) ASP.NET
5 4 (4.12%) AngularJS
5 4 (4.12%) Backbone.js
5 4 (4.12%) CSS
5 4 (4.12%) Dojo
5 4 (4.12%) HTML
5 4 (4.12%) Middleware
5 4 (4.12%) Node.js
5 4 (4.12%) React
5 4 (4.12%) REST
5 4 (4.12%) SOAP
Miscellaneous
1 34 (35.05%) Analytical Skills
2 13 (13.40%) Computer Science
3 6 (6.19%) Client/Server
3 6 (6.19%) N-Tier
4 4 (4.12%) Data Integration
4 4 (4.12%) Fixed Income
4 4 (4.12%) User Experience
5 3 (3.09%) Enterprise Software
5 3 (3.09%) Reference Data
5 3 (3.09%) Swaptions
6 2 (2.06%) Hedge funds
6 2 (2.06%) Internet of Things
7 1 (1.03%) Data Extraction
7 1 (1.03%) Data Protection Act
7 1 (1.03%) Economics
7 1 (1.03%) Life Science
7 1 (1.03%) Semantic Web
7 1 (1.03%) Spread Betting
7 1 (1.03%) Statistics
7 1 (1.03%) Wiki
Operating Systems
1 5 (5.15%) Windows
1 5 (5.15%) Windows 7
1 5 (5.15%) Windows 8
2 1 (1.03%) Unix
Processes & Methodologies
1 64 (65.98%) UML
2 63 (64.95%) Data Modelling
3 58 (59.79%) Agile Software Development
4 35 (36.08%) SDLC
5 33 (34.02%) Business Intelligence
6 31 (31.96%) Stakeholder Management
7 30 (30.93%) Business Analysis
8 25 (25.77%) PRINCE2
9 24 (24.74%) Data Architecture
9 24 (24.74%) Data Flow Diagram
9 24 (24.74%) User Acceptance Testing
10 20 (20.62%) Data Analysis
10 20 (20.62%) Waterfall
11 19 (19.59%) Analytics
11 19 (19.59%) Use Case
11 19 (19.59%) User Stories
12 18 (18.56%) Kimball Methodology
12 18 (18.56%) Project Management
13 17 (17.53%) Wireframes
14 16 (16.49%) Software Delivery
Programming Languages
1 49 (50.52%) SQL
2 8 (8.25%) Java
3 6 (6.19%) C#
4 5 (5.15%) PL/SQL
4 5 (5.15%) VB
4 5 (5.15%) VB.NET
5 4 (4.12%) JavaScript
6 1 (1.03%) PowerShell
6 1 (1.03%) T-SQL
Qualifications
1 14 (14.43%) Degree
2 2 (2.06%) CISM
2 2 (2.06%) CISSP
2 2 (2.06%) CRISC
2 2 (2.06%) SC Cleared
2 2 (2.06%) Security Cleared
3 1 (1.03%) IBM Certification
3 1 (1.03%) MCSE
3 1 (1.03%) Microsoft Certification
3 1 (1.03%) OCP
3 1 (1.03%) Oracle Certification
Quality Assurance & Compliance
1 24 (24.74%) Data Quality
2 17 (17.53%) QA
3 2 (2.06%) ISO/IEC 27001
Systems Management
1 1 (1.03%) Failover Clustering
Vendors
1 23 (23.71%) Microsoft
2 22 (22.68%) Tableau
3 18 (18.56%) Oracle
4 5 (5.15%) Cognos
5 3 (3.09%) OpenLink
5 3 (3.09%) TIBCO
5 3 (3.09%) webMethods
6 1 (1.03%) Atlassian
6 1 (1.03%) Cloudera
6 1 (1.03%) Guidewire
6 1 (1.03%) IBM
6 1 (1.03%) Kronos
6 1 (1.03%) Sony
City, London
Streamline Connections
Salary: £45000 - £60000.00 per annum + Benefits
Posted: 21 hours ago