Period
to 19 January 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 19 January 2018 with a comparison to the same period in the previous 2 years.

PostgreSQL (Postgres)
Scotland > Edinburgh
6 months to
19 Jan 2018
Same period 2017 Same period 2016
Rank 78 96 104
Rank change year-on-year +18 +8 +47
Permanent jobs citing PostgreSQL 77 39 51
As % of all permanent IT jobs advertised in Edinburgh 2.92% 1.79% 1.82%
As % of the Database & Business Intelligence category 9.08% 6.28% 6.85%
Number of salaries quoted 30 31 29
Edinburgh median annual salary £45,000 £50,000 £38,670
Median salary % change year-on-year -10.00% +29.30% +7.42%
10th Percentile £27,500 £35,000 £32,500
90th Percentile £57,500 £70,000 £55,000
Scotland median annual salary £46,250 £45,000 £40,000
% change year-on-year +2.78% +12.50% +14.29%

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 848 621 745
As % of all permanent IT jobs advertised in Edinburgh 32.12% 28.47% 26.56%
Number of salaries quoted 535 441 534
Edinburgh median annual salary £40,000 £45,000 £42,500
Median salary % change year-on-year -11.11% +5.88% +6.25%
10th Percentile £27,500 £28,750 £27,575
90th Percentile £60,000 £63,750 £60,000
Scotland median annual salary £42,500 £42,500 £41,500
% change year-on-year - +2.41% +3.75%

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 19 January 2018.

Salary histogram for PostgreSQL in Edinburgh

For the 6 months to 19 January 2018, IT jobs citing PostgreSQL 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 Edinburgh region with a requirement for PostgreSQL.

1 41 (53.25%) Relational Database
2 38 (49.35%) Python
3 35 (45.45%) SQL
4 33 (42.86%) Machine Learning
5 32 (41.56%) Java
6 28 (36.36%) Statistics
7 27 (35.06%) Amazon Redshift
7 27 (35.06%) Data Warehouse
8 24 (31.17%) Agile Software Development
9 21 (27.27%) JavaScript
9 21 (27.27%) Algorithms
10 18 (23.38%) Linux
11 17 (22.08%) Software Engineering
11 17 (22.08%) MongoDB
12 15 (19.48%) Degree
13 14 (18.18%) HTML
14 13 (16.88%) CSS
14 13 (16.88%) Apache Spark
15 12 (15.58%) Mathematics
15 12 (15.58%) RDBMS
16 10 (12.99%) Hibernate
16 10 (12.99%) Windows
16 10 (12.99%) NoSQL
17 9 (11.69%) C++
17 9 (11.69%) MySQL
17 9 (11.69%) ETL
17 9 (11.69%) Spring
17 9 (11.69%) Computer Science
18 8 (10.39%) Web Development
18 8 (10.39%) XML

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 (16.88%) Apache Spark
2 3 (3.90%) Apache
2 3 (3.90%) SAS
3 2 (2.60%) Elasticsearch
3 2 (2.60%) Tomcat
4 1 (1.30%) Jupyter
4 1 (1.30%) WordPress
Applications
1 2 (2.60%) Microsoft Excel
1 2 (2.60%) Microsoft Office
Business Applications
1 1 (1.30%) FastStats
Cloud Services
1 7 (9.09%) Amazon AWS
2 5 (6.49%) SaaS
3 3 (3.90%) Amazon EMR
3 3 (3.90%) Google Analytics
3 3 (3.90%) Google Cloud Platform
3 3 (3.90%) Microsoft Azure
4 2 (2.60%) IaaS
4 2 (2.60%) PaaS
5 1 (1.30%) Amazon EC2
5 1 (1.30%) Amazon S3
5 1 (1.30%) AWS CloudFormation
5 1 (1.30%) AWS Lambda
5 1 (1.30%) Serverless
Communications & Networking
1 4 (5.19%) AMQP
2 2 (2.60%) DHCP
2 2 (2.60%) DNS
2 2 (2.60%) SMTP
2 2 (2.60%) SNMP
2 2 (2.60%) TCP/IP
2 2 (2.60%) Wi-Fi
Database & Business Intelligence
1 41 (53.25%) Relational Database
2 27 (35.06%) Amazon Redshift
2 27 (35.06%) Data Warehouse
3 17 (22.08%) MongoDB
4 12 (15.58%) RDBMS
5 10 (12.99%) NoSQL
6 9 (11.69%) MySQL
7 7 (9.09%) Apache Cassandra
8 5 (6.49%) HBase
9 4 (5.19%) Hadoop
10 3 (3.90%) Aerospike
10 3 (3.90%) Apache Hive
10 3 (3.90%) SQL Server
11 2 (2.60%) Big Data
11 2 (2.60%) BusinessObjects
11 2 (2.60%) Couchbase
11 2 (2.60%) DB2
11 2 (2.60%) GIS
11 2 (2.60%) Oracle Database 10g
11 2 (2.60%) Oracle Database 11g
Development Applications
1 6 (7.79%) Git (software)
2 5 (6.49%) Jenkins
3 2 (2.60%) Subversion
4 1 (1.30%) Ant
4 1 (1.30%) Cucumber
4 1 (1.30%) Jasmine
4 1 (1.30%) Maven
4 1 (1.30%) Mocha
4 1 (1.30%) Protractor
4 1 (1.30%) RSpec
General
1 4 (5.19%) Marketing
2 2 (2.60%) Dutch Language
2 2 (2.60%) French Language
2 2 (2.60%) German Language
2 2 (2.60%) Multimedia
2 2 (2.60%) Retail
2 2 (2.60%) Spanish Language
3 1 (1.30%) Advertising
3 1 (1.30%) Finance
3 1 (1.30%) Local Government
Job Titles
1 28 (36.36%) Data Scientist
2 22 (28.57%) Developer
3 17 (22.08%) Java Developer
4 12 (15.58%) Software Engineer
5 9 (11.69%) Senior Developer
5 9 (11.69%) Senior Java Developer
6 5 (6.49%) Data Engineer
6 5 (6.49%) Java Software Developer
6 5 (6.49%) Software Developer
7 4 (5.19%) C++ Software Engineer
7 4 (5.19%) GUI Software Engineer
7 4 (5.19%) Linux Engineer
7 4 (5.19%) Senior Software Engineer
7 4 (5.19%) Web Developer
8 3 (3.90%) Administrator
8 3 (3.90%) Java Web Developer
9 2 (2.60%) Cloud Architect
9 2 (2.60%) Support Engineer
9 2 (2.60%) Support Technician
9 2 (2.60%) Technical Architect
Libraries, Frameworks & Software Standards
1 14 (18.18%) HTML
2 13 (16.88%) CSS
3 10 (12.99%) Hibernate
4 9 (11.69%) Spring
5 8 (10.39%) XML
6 7 (9.09%) AngularJS
7 6 (7.79%) NumPy
7 6 (7.79%) REST
7 6 (7.79%) SOAP
7 6 (7.79%) Spring Boot
8 5 (6.49%) Node.js
8 5 (6.49%) OpenGL
9 4 (5.19%) CSS3
9 4 (5.19%) HTML5
9 4 (5.19%) MLlib
9 4 (5.19%) Qt
9 4 (5.19%) React
9 4 (5.19%) Web Services
9 4 (5.19%) ZeroMQ
10 3 (3.90%) scikit-learn
Miscellaneous
1 21 (27.27%) Algorithms
2 9 (11.69%) Computer Science
3 7 (9.09%) Fintech
4 4 (5.19%) Greenfield Project
5 2 (2.60%) DataPower
5 2 (2.60%) Mobile App
5 2 (2.60%) User Experience
6 1 (1.30%) Blog
6 1 (1.30%) Management Information System
6 1 (1.30%) Virtual Team
Operating Systems
1 18 (23.38%) Linux
2 10 (12.99%) Windows
3 6 (7.79%) Unix
4 5 (6.49%) Red Hat Enterprise Linux
5 2 (2.60%) AIX
5 2 (2.60%) Android
5 2 (2.60%) CentOS
5 2 (2.60%) HPUX
5 2 (2.60%) Mac OS X
5 2 (2.60%) Solaris
5 2 (2.60%) Windows 2000
5 2 (2.60%) Windows 7
5 2 (2.60%) Windows Vista
5 2 (2.60%) Windows XP
6 1 (1.30%) Apple iOS
Processes & Methodologies
1 33 (42.86%) Machine Learning
2 28 (36.36%) Statistics
3 24 (31.17%) Agile Software Development
4 17 (22.08%) Software Engineering
5 12 (15.58%) Mathematics
6 9 (11.69%) ETL
7 8 (10.39%) Open Source
7 8 (10.39%) Web Development
8 7 (9.09%) Analytics
8 7 (9.09%) Microservices
8 7 (9.09%) OOP
9 6 (7.79%) Applied Mathematics
9 6 (7.79%) CRM
9 6 (7.79%) Scrum
10 5 (6.49%) Requirements Analysis
11 4 (5.19%) OO
11 4 (5.19%) OOD
11 4 (5.19%) Statistical Analysis
11 4 (5.19%) Visualisation
12 3 (3.90%) DevOps
Programming Languages
1 38 (49.35%) Python
2 35 (45.45%) SQL
3 32 (41.56%) Java
4 21 (27.27%) JavaScript
5 9 (11.69%) C++
6 7 (9.09%) R
7 5 (6.49%) C#
8 4 (5.19%) Scala
8 4 (5.19%) TypeScript
9 3 (3.90%) C
9 3 (3.90%) Perl
9 3 (3.90%) PHP
10 2 (2.60%) Bash Shell
10 2 (2.60%) Shell Script
11 1 (1.30%) PowerShell
11 1 (1.30%) Ruby
11 1 (1.30%) VB
11 1 (1.30%) VB.NET
11 1 (1.30%) VBA
Qualifications
1 15 (19.48%) Degree
2 8 (10.39%) Computer Science Degree
3 1 (1.30%) PhD
3 1 (1.30%) Postgraduate
Quality Assurance & Compliance
1 2 (2.60%) QA
2 1 (1.30%) BS7666
2 1 (1.30%) Data Quality
2 1 (1.30%) Disclosure Scotland
System Software
1 2 (2.60%) Docker
1 2 (2.60%) NFS
Systems Management
1 3 (3.90%) Ansible
2 2 (2.60%) Puppet
2 2 (2.60%) Tivoli
2 2 (2.60%) Tivoli Monitoring
3 1 (1.30%) Hadoop YARN
3 1 (1.30%) Kibana
3 1 (1.30%) logstash
3 1 (1.30%) Opscode Chef
Vendors
1 6 (7.79%) Oracle
2 5 (6.49%) Google
2 5 (6.49%) Microsoft
3 4 (5.19%) Red Hat
4 3 (3.90%) Vertica
5 2 (2.60%) Hitachi
5 2 (2.60%) Hortonworks
5 2 (2.60%) IBM
5 2 (2.60%) Salesforce.com
6 1 (1.30%) Cognos
6 1 (1.30%) HP