Period
to 25 April 2018

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh with a requirement for PostgreSQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited PostgreSQL over the 6 months to 25 April 2018 with a comparison to the same period in the previous 2 years.

PostgreSQL (Postgres)
Scotland > Edinburgh
6 months to
25 Apr 2018
Same period 2017 Same period 2016
Rank 70 93 126
Rank change year-on-year +23 +33 -11
Permanent jobs citing PostgreSQL 74 45 23
As % of all permanent IT jobs advertised in Edinburgh 2.80% 2.05% 0.88%
As % of the Database & Business Intelligence category 10.32% 6.09% 3.22%
Number of salaries quoted 32 30 12
Edinburgh median annual salary £45,000 £45,000 £40,750
Median salary % change year-on-year - +10.43% +5.16%
10th Percentile £27,625 £37,500 £31,025
90th Percentile £65,450 £70,000 £50,000
Scotland median annual salary £50,000 £45,000 £42,000
% change year-on-year +11.11% +7.14% +5.00%

PostgreSQL is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Edinburgh with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Edinburgh
Permanent vacancies with a requirement for database or business intelligence skills 717 739 714
As % of all permanent IT jobs advertised in Edinburgh 27.11% 33.65% 27.31%
Number of salaries quoted 475 486 494
Edinburgh median annual salary £42,500 £45,000 £45,000
Median salary % change year-on-year -5.56% - +12.50%
10th Percentile £28,000 £28,750 £29,000
90th Percentile £65,300 £70,000 £61,250
Scotland median annual salary £45,000 £43,500 £42,500
% change year-on-year +3.45% +2.35% +6.25%

PostgreSQL
Job Vacancy Trend in Edinburgh

Job postings citing PostgreSQL as a percentage of all IT jobs advertised in Edinburgh.

Job vacancy trend for PostgreSQL in Edinburgh

PostgreSQL
Salary Trend in Edinburgh

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing PostgreSQL in Edinburgh.

Salary trend for PostgreSQL in Edinburgh

PostgreSQL
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing PostgreSQL in Edinburgh over the 6 months to 25 April 2018.

Salary histogram for PostgreSQL in Edinburgh

For the 6 months to 25 April 2018, IT jobs citing PostgreSQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Edinburgh region with a requirement for PostgreSQL.

1 37 (50.00%) Python
2 32 (43.24%) SQL
3 29 (39.19%) Java
3 29 (39.19%) Relational Database
4 28 (37.84%) Machine Learning
5 27 (36.49%) JavaScript
6 24 (32.43%) Agile Software Development
6 24 (32.43%) Data Science
7 22 (29.73%) Statistics
7 22 (29.73%) Windows
7 22 (29.73%) MongoDB
8 21 (28.38%) Amazon Redshift
8 21 (28.38%) Data Warehouse
9 19 (25.68%) MySQL
9 19 (25.68%) Oracle
10 18 (24.32%) Apache Cassandra
10 18 (24.32%) NoSQL
11 17 (22.97%) Linux
12 16 (21.62%) Software Engineering
13 15 (20.27%) Algorithms
14 13 (17.57%) Apache Spark
14 13 (17.57%) HBase
14 13 (17.57%) Unix
15 12 (16.22%) CSS
15 12 (16.22%) C#
16 11 (14.86%) Tomcat
16 11 (14.86%) SaaS
17 10 (13.51%) PaaS
17 10 (13.51%) Git (software)
17 10 (13.51%) DataPower

PostgreSQL
Co-occurring IT Skills in Edinburgh 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 13 (17.57%) Apache Spark
2 11 (14.86%) Tomcat
3 10 (13.51%) SAS
4 4 (5.41%) Elasticsearch
5 1 (1.35%) Apache
5 1 (1.35%) Jupyter
5 1 (1.35%) nginx
5 1 (1.35%) WordPress
Applications
1 8 (10.81%) Microsoft Excel
Cloud Services
1 11 (14.86%) SaaS
2 10 (13.51%) IaaS
2 10 (13.51%) PaaS
3 6 (8.11%) Amazon AWS
4 2 (2.70%) Amazon EC2
4 2 (2.70%) Amazon EMR
4 2 (2.70%) Amazon S3
4 2 (2.70%) AWS CloudFormation
4 2 (2.70%) AWS Lambda
4 2 (2.70%) Google Cloud Platform
4 2 (2.70%) Microsoft Azure
4 2 (2.70%) Serverless
5 1 (1.35%) Cloud Computing
5 1 (1.35%) Google Analytics
Communications & Networking
1 2 (2.70%) DHCP
1 2 (2.70%) DNS
1 2 (2.70%) SMTP
1 2 (2.70%) SNMP
2 1 (1.35%) Firewall
2 1 (1.35%) Internet
Database & Business Intelligence
1 29 (39.19%) Relational Database
2 22 (29.73%) MongoDB
3 21 (28.38%) Amazon Redshift
3 21 (28.38%) Data Warehouse
4 19 (25.68%) MySQL
5 18 (24.32%) Apache Cassandra
5 18 (24.32%) NoSQL
6 13 (17.57%) HBase
7 10 (13.51%) BusinessObjects
7 10 (13.51%) DB2
7 10 (13.51%) Oracle Database
7 10 (13.51%) Oracle Database 10g
7 10 (13.51%) Oracle Database 11g
7 10 (13.51%) Oracle Database 12c
8 8 (10.81%) RDBMS
8 8 (10.81%) Redis
8 8 (10.81%) SQL Server
9 4 (5.41%) Amazon DynamoDB
9 4 (5.41%) Hadoop
10 3 (4.05%) Big Data
Development Applications
1 10 (13.51%) Git (software)
2 8 (10.81%) Subversion
3 4 (5.41%) Jenkins
4 1 (1.35%) Cucumber
4 1 (1.35%) Jasmine
4 1 (1.35%) Maven
4 1 (1.35%) Mocha
4 1 (1.35%) Protractor
4 1 (1.35%) RSpec
General
1 5 (6.76%) Marketing
2 2 (2.70%) Multimedia
2 2 (2.70%) Retail
3 1 (1.35%) Banking
3 1 (1.35%) Finance
Job Titles
1 24 (32.43%) Developer
2 22 (29.73%) Data Scientist
3 11 (14.86%) Software Engineer
4 10 (13.51%) Architect
4 10 (13.51%) Cloud Architect
4 10 (13.51%) Java Developer
4 10 (13.51%) Technical Architect
5 8 (10.81%) .NET Developer
5 8 (10.81%) VB.NET Developer
6 7 (9.46%) Senior Software Engineer
7 5 (6.76%) Senior Developer
7 5 (6.76%) Senior Java Developer
7 5 (6.76%) Web Developer
8 4 (5.41%) Java Web Developer
9 3 (4.05%) Administrator
9 3 (4.05%) Data Engineer
9 3 (4.05%) Systems Administrator
10 2 (2.70%) Big Data Engineer
10 2 (2.70%) React Developer
10 2 (2.70%) Software Developer
Libraries, Frameworks & Software Standards
1 12 (16.22%) CSS
2 10 (13.51%) HTML
3 9 (12.16%) .NET
4 8 (10.81%) AngularJS
4 8 (10.81%) Node.js
5 7 (9.46%) React
6 6 (8.11%) MLlib
6 6 (8.11%) NumPy
7 5 (6.76%) SciPy
8 4 (5.41%) Hibernate
8 4 (5.41%) HTML5
8 4 (5.41%) Kafka
8 4 (5.41%) Spring
9 3 (4.05%) CSS3
9 3 (4.05%) JSON
9 3 (4.05%) Play Framework
9 3 (4.05%) PostGIS
9 3 (4.05%) RESTful
9 3 (4.05%) Web Services
9 3 (4.05%) XML
Miscellaneous
1 15 (20.27%) Algorithms
2 10 (13.51%) DataPower
3 8 (10.81%) Virtual Team
4 3 (4.05%) Fintech
4 3 (4.05%) Greenfield Project
5 2 (2.70%) Cloud Native
5 2 (2.70%) Data Centre
5 2 (2.70%) User Experience
6 1 (1.35%) Blog
6 1 (1.35%) Management Information System
6 1 (1.35%) Mobile App
6 1 (1.35%) Private Cloud
Operating Systems
1 22 (29.73%) Windows
2 17 (22.97%) Linux
3 13 (17.57%) Unix
4 10 (13.51%) AIX
4 10 (13.51%) HPUX
4 10 (13.51%) Red Hat Enterprise Linux
4 10 (13.51%) Solaris
5 2 (2.70%) CentOS
5 2 (2.70%) Mac OS X
6 1 (1.35%) Debian
Processes & Methodologies
1 28 (37.84%) Machine Learning
2 24 (32.43%) Agile Software Development
2 24 (32.43%) Data Science
3 22 (29.73%) Statistics
4 16 (21.62%) Software Engineering
5 10 (13.51%) Data Management
5 10 (13.51%) DevOps
5 10 (13.51%) Infrastructure Transformation
5 10 (13.51%) Migration
6 9 (12.16%) Analytics
7 8 (10.81%) Task Automation
7 8 (10.81%) Web Development
8 7 (9.46%) ETL
8 7 (9.46%) Mathematics
8 7 (9.46%) Visualisation
9 6 (8.11%) Applied Mathematics
10 5 (6.76%) Artificial Intelligence
10 5 (6.76%) Creative Thinking
10 5 (6.76%) Operations Research
10 5 (6.76%) Statistical Analysis
Programming Languages
1 37 (50.00%) Python
2 32 (43.24%) SQL
3 29 (39.19%) Java
4 27 (36.49%) JavaScript
5 12 (16.22%) C#
6 10 (13.51%) Perl
7 9 (12.16%) Bash Shell
7 9 (12.16%) C++
7 9 (12.16%) PHP
8 8 (10.81%) C
8 8 (10.81%) PowerShell
8 8 (10.81%) VB
8 8 (10.81%) VB.NET
8 8 (10.81%) VBA
9 7 (9.46%) R
10 6 (8.11%) TypeScript
11 4 (5.41%) Scala
12 2 (2.70%) Ruby
12 2 (2.70%) Shell Script
13 1 (1.35%) ES7
Qualifications
1 6 (8.11%) Degree
2 1 (1.35%) PhD
2 1 (1.35%) Postgraduate
Quality Assurance & Compliance
1 2 (2.70%) QA
2 1 (1.35%) BS7666
System Software
1 2 (2.70%) Docker
1 2 (2.70%) NFS
2 1 (1.35%) HDFS
2 1 (1.35%) Postfix
Systems Management
1 10 (13.51%) Tivoli
1 10 (13.51%) Tivoli Monitoring
2 3 (4.05%) Ansible
3 2 (2.70%) Hadoop YARN
3 2 (2.70%) Kibana
3 2 (2.70%) logstash
4 1 (1.35%) HAProxy
4 1 (1.35%) Kubernetes
4 1 (1.35%) Mesos
4 1 (1.35%) Opscode Chef
4 1 (1.35%) Puppet
4 1 (1.35%) Terraform
Vendors
1 19 (25.68%) Oracle
2 10 (13.51%) Hitachi
2 10 (13.51%) Hortonworks
2 10 (13.51%) IBM
2 10 (13.51%) Microsoft
3 4 (5.41%) Vertica
4 3 (4.05%) Google
4 3 (4.05%) Red Hat
5 1 (1.35%) HP