Geospatial Data Platform Engineer (Python/PostGIS)

Woodmac; Boston, Northern (MA, KY); Hybrid; USD 120,000 - 170,000; Full time

Job summary

Woodmac in Boston, MA is seeking a Software Engineer focused on backend data engineering to design, develop and maintain data pipelines and geospatial data processes. The role centers on Python, PostgreSQL/PostGIS and Linux, delivering reliable data products via robust ETL workflows.

You will collaborate with product, GIS and data science teams to meet data requirements, optimize data flows and ensure data quality across large-scale energy and geospatial datasets.

Qualifications

• Proficient software development experience with Python.
• Strong PostgreSQL/SQL skills, including database design and performance tuning.
• Experience with PostGIS or geospatial DB tech.
• Experience building and maintaining ETL pipelines.
• Experience handling large/complex datasets.
• Knowledge of data-quality controls and validation.
• Linux administration, scripting and automation.

Responsibilities

• Design, develop, test and maintain Python-based ETL pipelines for large geospatial/energy datasets.
• Build and optimise PostgreSQL/PostGIS schemas, SQL queries and spatial workflows.
• Develop automated processes for data ingestion, validation, transformation and promotion.
• Monitor data quality and investigate issues affecting accuracy; ensure reliability of data products.
• Maintain Linux-based data-processing environments, scheduled jobs and automation tooling.
• Support data engineering across energy infrastructure, land, oil and gas, renewables and carbon datasets.
• Collaborate with product, GIS and data science teams to understand requirements and deliver reliable data products.
• Diagnose pipeline, database and processing issues and implement maintainable solutions.
• Contribute to documentation and engineering practices; improve data-platform processes.

Skills

Python

PostgreSQL

PostGIS

ETL pipelines

Linux

Data quality

Scripting

Geospatial data

Job description

Woodmac in Boston, MA is seeking a Software Engineer focused on backend data engineering to design, develop and maintain data pipelines and geospatial data processes. The role centers on Python, PostgreSQL/PostGIS and Linux, delivering reliable data products via robust ETL workflows.

You will collaborate with product, GIS and data science teams to meet data requirements, optimize data flows and ensure data quality across large-scale energy and geospatial datasets.