About the role
We are seeking an enthusiastic and capable PostgreSQL / SQL Database Developer, responsible for developing the application and database code to store, manipulate and interact with very large geospatial datasets.
The successful candidate will work with product owners, back-end developers, front-end developers, and data analysts, as needed.
This is a central role in our development team, best described as trailblazing and super rewarding and you would report directly to Climate X’s Engineering Lead.
The impact you’ll own
Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
Work closely with the Engineering Lead to implement effective and maintainable database schema designs, forming an architectural foundation to prepare for the further expansion of data.
Work with Product and Business Development teams to solve spatial data issues for internal and external customers and address spatial data-related challenges.
Ensure the efficiency of database code, and the integrity of data structures.
Work with product managers to ensure database code meets security, scalability, and robustness requirements.
Build, enhance, and support custom applications to automate procedures and processing tasks.
Identify problems associated with GIS programs, scripts, tools, procedures, systems, and applications.
What you bring
Great experience of working as a database developer with PostgreSQL.
Expert-level knowledge of SQL, PL / pgSQL, including stored procedures, functions, triggers, and views.
Knowledge of JSON and PostgreSQL support for JSON.
Ability to efficiently write database code without compromising data quality, privacy, or security.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels.
Ability to quickly learn new technologies, work independently, and quickly turnaround maps, application prototypes or other deliverables.
Demonstrated AWS / Cloud-based application development
Knowledge and use of Git version control with repositories like GitLab
What makes you stand out
Ability to work with ArcGIS and / or QGIS and the GDAL / OGR library.
Proven management of GIS data within at least two of the following : Oracle, SQL Server, and / or PostgreSQL database environments.
Past use of environmental data, and evidence of developing applications for visualization, analysis, and presentation of environmental data.
Experience with NoSQL databases : especially Graph and Columnar-storage.
Hands-on, can-do attitude, great interpersonal skills, and ability to collaborate effectively. This includes the ability to plan projects, meet objectives, develop contingencies, and produce schedules
Passion, energy, and wit especially when handling multiple tasks in a fast-paced environment.
Strong written, verbal, and interpersonal skills and the ability to explain complex concepts to non-technical audience
Net zero (green) pension
25days leave + 8 bank holidays
Training + conference budget
Birthday treats : lay-in and spa
2 days volunteering time