Period
to 25 September 2018

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

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

PostgreSQL (Postgres)
North West > Lancashire
6 months to
25 Sep 2018
Same period 2017 Same period 2016
Rank 18 45 62
Rank change year-on-year +27 +17 +6
Contract jobs citing PostgreSQL 49 10 5
As % of all contract IT jobs advertised in Lancashire 7.73% 1.74% 0.67%
As % of the Database & Business Intelligence category 33.79% 8.77% 2.53%
Number of daily rates quoted 39 29 3
Lancashire median daily rate £530 £640 £415
Median daily rate % change year-on-year -17.19% +54.22% +18.57%
10th Percentile £421 £605 £370
90th Percentile £563 £755 £477
North West median daily rate £500 £552 £430
% change year-on-year -9.42% +28.37% +22.86%
Number of hourly rates quoted 2 0 0
Lancashire median hourly rate £35.00 - -
North West median hourly rate £35.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 contract job vacancies advertised in Lancashire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Lancashire
Contract vacancies with a requirement for database or business intelligence skills 145 114 198
As % of all contract IT jobs advertised in Lancashire 22.87% 19.79% 26.40%
Number of daily rates quoted 107 74 116
Lancashire median daily rate £470 £400 £375
Median daily rate % change year-on-year +17.50% +6.67% -11.76%
10th Percentile £250 £264 £285
90th Percentile £585 £607 £522
North West median daily rate £400 £400 £375
% change year-on-year - +6.67% -6.25%
Number of hourly rates quoted 5 11 30
Lancashire median hourly rate £35.00 £42.50 £40.00
Median hourly rate % change year-on-year -17.65% +6.25% +3.90%
10th Percentile £8.10 £39.50 £20.50
90th Percentile £113.00 £44.00 £66.98
North West median hourly rate £35.00 £38.00 £29.53
% change year-on-year -7.89% +28.70% -20.74%

PostgreSQL
Job Vacancy Trend in Lancashire

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

Job vacancy trend for PostgreSQL in Lancashire

PostgreSQL
Contractor Daily Rate Trend in Lancashire

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing PostgreSQL in Lancashire.

Contractor daily rate trend for PostgreSQL in Lancashire

PostgreSQL
Contractor Daily Rate Histogram in Lancashire

The daily rate distribution of IT jobs citing PostgreSQL in Lancashire over the 6 months to 25 September 2018.

Contractor daily rate histogram for PostgreSQL in Lancashire

PostgreSQL
Contractor Hourly Rate Trend in Lancashire

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing PostgreSQL in Lancashire.

Contractor hourly rate trend for PostgreSQL in Lancashire

PostgreSQL
Contract Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing PostgreSQL within the Lancashire region over the 6 months to 25 September 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Blackpool 0 37 £500 -21.88% 2
Preston - 6 £538 - 2
Blackburn - 3 £538 -
PostgreSQL
North West

For the 6 months to 25 September 2018, IT contractor 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 contract job ads across the Lancashire region with a requirement for PostgreSQL.

1 32 (65.31%) Git (software)
2 31 (63.27%) Java
3 30 (61.22%) SQL
4 26 (53.06%) Agile Software Development
5 25 (51.02%) Spring Boot
6 24 (48.98%) Java 8
7 21 (42.86%) Spring
7 21 (42.86%) Linux
8 20 (40.82%) Spring Security
9 19 (38.78%) DevOps
9 19 (38.78%) Oracle
9 19 (38.78%) SOA
10 18 (36.73%) Shell Script
10 18 (36.73%) Puppet
11 17 (34.69%) Python
11 17 (34.69%) Perl
11 17 (34.69%) Ruby
11 17 (34.69%) Continuous Integration
12 16 (32.65%) Tuxedo
12 16 (32.65%) Middleware
12 16 (32.65%) Continuous Deployment
13 15 (30.61%) BDD
14 13 (26.53%) Artifactory
14 13 (26.53%) TDD
15 12 (24.49%) Scrum
15 12 (24.49%) VMware
15 12 (24.49%) Kanban
15 12 (24.49%) Windows
15 12 (24.49%) Windows Server
16 10 (20.41%) SC Cleared

PostgreSQL
Co-occurring IT Skills in Lancashire 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 16 (32.65%) Tuxedo
2 2 (4.08%) Confluence
2 2 (4.08%) WebSphere
3 1 (2.04%) Apache
3 1 (2.04%) Oracle SOA Suite
3 1 (2.04%) SAS
3 1 (2.04%) Tomcat
Applications
1 1 (2.04%) Microsoft Excel
Business Applications
1 1 (2.04%) Distributed Ledger
1 1 (2.04%) Exstream
Cloud Services
1 2 (4.08%) Slack
2 1 (2.04%) Amazon AWS
2 1 (2.04%) Amazon S3
2 1 (2.04%) OpenShift
Database & Business Intelligence
1 7 (14.29%) MongoDB
1 7 (14.29%) MySQL
2 5 (10.20%) NoSQL
3 3 (6.12%) Big Data
4 2 (4.08%) Apache Hive
4 2 (4.08%) Neo4j
4 2 (4.08%) Power BI
4 2 (4.08%) Relational Database
5 1 (2.04%) Apache Cassandra
5 1 (2.04%) Blockchain
5 1 (2.04%) BusinessObjects
5 1 (2.04%) Data Lake
5 1 (2.04%) Data Warehouse
5 1 (2.04%) Enterprise Data Warehouse
5 1 (2.04%) Hadoop
5 1 (2.04%) HBase
5 1 (2.04%) Pentaho
5 1 (2.04%) SQL Server
Development Applications
1 32 (65.31%) Git (software)
2 13 (26.53%) Artifactory
3 3 (6.12%) Jenkins
3 3 (6.12%) JUnit
4 2 (4.08%) Cucumber
4 2 (4.08%) JIRA
4 2 (4.08%) RStudio
5 1 (2.04%) ERwin
5 1 (2.04%) GitLab
5 1 (2.04%) Jasmine
5 1 (2.04%) SonarQube
5 1 (2.04%) Sonatype Nexus
General
1 1 (2.04%) Finance
Job Titles
1 19 (38.78%) Developer
2 18 (36.73%) Java Developer
3 15 (30.61%) DevOps Engineer
4 7 (14.29%) Senior Developer
4 7 (14.29%) Senior Java Developer
5 5 (10.20%) Linux DevOps Engineer
5 5 (10.20%) Linux Engineer
5 5 (10.20%) Linux/Unix DevOps
6 4 (8.16%) Technical Leader
7 3 (6.12%) Operations Engineer
8 2 (4.08%) Applications Engineer
8 2 (4.08%) Middleware Engineer
8 2 (4.08%) Software Engineer
9 1 (2.04%) Agile Java Developer
9 1 (2.04%) Architect
9 1 (2.04%) Consultant
9 1 (2.04%) Data Architect
9 1 (2.04%) Lead Architect
9 1 (2.04%) Lead Data Architect
9 1 (2.04%) Senior Consultant
Libraries, Frameworks & Software Standards
1 25 (51.02%) Spring Boot
2 21 (42.86%) Spring
3 20 (40.82%) Spring Security
4 16 (32.65%) Middleware
5 3 (6.12%) Kafka
5 3 (6.12%) Node.js
6 2 (4.08%) Apache Camel
6 2 (4.08%) Apache CXF
6 2 (4.08%) REST
6 2 (4.08%) Web Services
7 1 (2.04%) ActiveMQ
7 1 (2.04%) AngularJS
7 1 (2.04%) CSS
7 1 (2.04%) CSS3
7 1 (2.04%) FreeMarker
7 1 (2.04%) HTML
7 1 (2.04%) HTML5
7 1 (2.04%) jQuery
7 1 (2.04%) RabbitMQ
7 1 (2.04%) Twitter Bootstrap
Miscellaneous
1 9 (18.37%) Wiki
2 7 (14.29%) User Experience
3 1 (2.04%) Analytical Skills
3 1 (2.04%) Management Information System
3 1 (2.04%) Self-Motivation
Operating Systems
1 21 (42.86%) Linux
2 12 (24.49%) Windows
2 12 (24.49%) Windows Server
3 1 (2.04%) Red Hat Enterprise Linux
3 1 (2.04%) Unix
Processes & Methodologies
1 26 (53.06%) Agile Software Development
2 19 (38.78%) DevOps
2 19 (38.78%) SOA
3 17 (34.69%) Continuous Integration
4 16 (32.65%) Continuous Deployment
5 15 (30.61%) BDD
6 13 (26.53%) TDD
7 12 (24.49%) Kanban
7 12 (24.49%) Scrum
8 9 (18.37%) Pair Programming
8 9 (18.37%) Refactoring
8 9 (18.37%) Software Engineering
9 6 (12.24%) Open Source
9 6 (12.24%) UX Design
9 6 (12.24%) Web Operations
10 3 (6.12%) SFIA
10 3 (6.12%) Test Automation
11 2 (4.08%) Coaching
11 2 (4.08%) Mentoring
11 2 (4.08%) Microservices
Programming Languages
1 31 (63.27%) Java
2 30 (61.22%) SQL
3 24 (48.98%) Java 8
4 18 (36.73%) Shell Script
5 17 (34.69%) Perl
5 17 (34.69%) Python
5 17 (34.69%) Ruby
6 5 (10.20%) JavaScript
7 1 (2.04%) Groovy
7 1 (2.04%) R
7 1 (2.04%) VB
7 1 (2.04%) VBA
Qualifications
1 10 (20.41%) SC Cleared
1 10 (20.41%) Security Cleared
2 2 (4.08%) BPSS Clearance
2 2 (4.08%) DBS Check
Quality Assurance & Compliance
1 9 (18.37%) QA
2 1 (2.04%) Data Quality
System Software
1 1 (2.04%) Virtual Machines
Systems Management
1 18 (36.73%) Puppet
2 2 (4.08%) Terraform
3 1 (2.04%) Ansible
3 1 (2.04%) Grafana
3 1 (2.04%) Graylog
3 1 (2.04%) Kubernetes
Vendors
1 19 (38.78%) Oracle
2 12 (24.49%) VMware
3 3 (6.12%) Tableau
4 1 (2.04%) CA
4 1 (2.04%) Informatica
4 1 (2.04%) Microsoft
4 1 (2.04%) OpenText
4 1 (2.04%) Red Hat