Software Engineer – Data Engineering Platform (Python _ SQL _ 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

Role Purpose

The Software Engineer will join the team responsible for the core data platform supporting valuation and analytics products. The platform ingests, processes and maintains large-scale geospatial and energy datasets used across oil and gas, renewables, electrical infrastructure, carbon and land intelligence. This is a backend data engineering position focused on Python, PostgreSQL/PostGIS and Linux. The role will design, develop and maintain data pipelines, spatial data processes and data-quality controls that provide reliable information to downstream products and users. It is not primarily an application or front‑end development role.

Main Responsibilities

• Design, develop, test and maintain Python-based ETL pipelines for large geospatial and energy datasets.
• Build and optimise PostgreSQL/PostGIS schemas, SQL queries and spatial data workflows.
• Develop automated processes for data ingestion, validation, transformation and promotion.
• Monitor data quality and investigate issues affecting the accuracy, completeness or 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 colleagues to understand requirements and deliver reliable data products.
• Diagnose pipeline, database and processing issues, implementing maintainable solutions.
• Contribute to documentation, engineering practices and the continuous improvement of data-platform processes.

About You

Essential experience and capabilities

• Practical software development experience using Python.
• Advanced working knowledge of PostgreSQL and SQL, including database design and query-performance optimisation.
• Experience using PostGIS or comparable geospatial database technologies.
• Experience building and maintaining ETL or data-engineering pipelines.
• Experience processing large or complex datasets.
• Experience implementing validation and data-quality controls.
• Working knowledge of Linux administration, scripting and automation.
• Effective analytical, diagnostic and problem-solving skills.
• Ability to communicate technical information clearly and work collaboratively across disciplines.

Desirable experience

• Elasticsearch.
• AWS services, particularly Amazon S3.
• TypeScript, Node.js or REST API development.
• GIS formats such as Shapefile and GeoJSON.
• Spatial indexing or geospatial analytics.
• Data modelling, machine learning or statistical analysis.
• Energy, land, mineral rights, oil and gas, renewables, electrical-grid or carbon/CCUS datasets.

We recognise that experience can be gained in different ways.

Working Arrangements

We are a hybrid working company and the successful applicant will normally be expected to be physically present in the office at least two days per week to foster and contribute to a collaborative environment. Remote working arrangements will also be considered for this role, subject to the applicable approval process. Due to the global nature of the team, a degree of flexible working will be required to accommodate different time zones. Any out-of-hours collaboration should be planned proportionately and shared fairly across the team.

Equal Opportunities

We are an equal opportunities employer. This means we are committed to recruiting the best people regardless of their race, colour, religion, age, sex (including pregnancy, sexual orientation, and gender identity), national origin, disability or protected veteran status. You can find out more about your rights under the law at www.eeoc.gov

If you like wild growth and working with happy, enthusiastic over‑achievers, you'll enjoy your career with us!

Our Work Experience

Our Work Experience is the combination of everything that's unique about us: our culture, our core values, our company meetings, our commitment to sustainability, our recognition programs, but most importantly, it's our people.

Our employees are self‑disciplined, hard working, curious, trustworthy, humble, and truthful. They make choices according to what is best for the team, they live for opportunities to collaborate and make a difference, and they make us the #1 Top Workplace in the area.