This role involves integrating and staging both tabular and spatial GIS datasets into a database environment, developing tools or scripts to automate data processing, and building a program or workflow to execute the defined data model and generate outputs.
JOB DESCRIPTION :
- Design, develop, and maintain a relational database (e.g., PostgreSQL / PostGIS or equivalent) to store, organize, and manage GIS and tabular data
- Develop a data model and associated processing workflows to evaluate parcel-level compliance.
- Collaborate with the Systems team to access, clean, and stage GIS reference data for integration into the project database.
- Develop scripts, tools, or applications (in Python, SQL, or similar languages) to automate data ingestion, transformation, and analysis.
- Ensure data accuracy, integrity, and performance through quality control checks and optimization of spatial queries.
- Produce reproducible data outputs and reports to support policy analysis.
- Document database schema, data model logic, and workflow processes to support long term maintenance and transparency.