Contract Software Engineer, SQL Migration

About Ambrook

Ambrook's mission is to make sustainability profitable for family-run businesses. 

In the face of historic heat waves, drought, flooding, supply chain disruptions, water shortages, and pollution, climate impacts are intensifying across industrial America: from farmers facing crop losses, to truckers navigating fuel volatility, to contractors managing material shortages. Evidence shows sustainable practice upgrades deliver financial returns – from water-efficient irrigation to fuel-efficient fleets – but these changes require significant upfront capital and a clear proof of return-on-investment to owner-operators facing tight cashflows and razor-thin margins already. With data scattered across paper records and outdated systems, operators struggle to forecast whether a practice change will improve their bottom line – let alone prove business health to lenders and other funders. 

Ambrook is solving this chicken-and-egg problem by re-architecting the financial data layer of America's independent businesses. We're replacing unruly paperwork and expensive, archaic tools with an affordable accounting, banking and payments platform that helps operators understand their numbers and access capital for sustainable transitions.

Ambrook customers are our economy’s historic backbone and a manifestation of the American Dream. Done right, both financial and environmental sustainability enables these entities to stay independent and resilient in the face of climate-driven volatility. 

We’re starting by building for farmers and ranchers across America. 

We’re a Series A startup backed by top investors (Thrive Capital, Dylan Field, Homebrew, Designer Fund, BoxGroup, and more) and are looking for early team members who are looking to untangle the knotted intersection between American industry and climate.

Learn more about our mission and what it’s like to work with us.

The Opportunity

We're looking for an experienced engineer to support a high-stakes migration of our core production system from Firestore to PostgreSQL. You'll be working directly with a full-time engineer at Ambrook who is leading this initiative, contributing to taking the implementation of dual-write systems, data backfills, and parity checks from an existing proof of concept to realization.

This is not a theoretical rewrite or a greenfield redesign. We are preserving existing system behavior across a staged, high-reliability migration – shipping incrementally in a live production environment with real customer data.

What You’ll Do:

• Implement a shim of the existing storage layer that enables dual-write paths that keep Firestore and SQL in sync.

• Contribute to a JSONB-based Postgres schema and abstractions that preserve Firestore-like semantics, while paving the way for a fully relational schema

• Build tooling for validating data parity across backfilled orgs (e.g. field-level diffs, snapshot comparisons).

• Work closely with our existing engineer to pair on difficult edge cases and define migration-safe interfaces.

• Help ensure correctness, performance, and observability of the evolving dual-store system.
  

We’re Looking For Someone Who:

• Has experience migrating real-world systems from NoSQL to relational backends (e.g. Firestore to Postgres, Mongo to SQL).

• Knows how to reason about correctness, consistency, and failure modes in production data systems.

• Writes clean, well-tested code, ideally in TypeScript, or willing to ramp quickly.

• Understands SQL deeply (Postgres experience preferred), including indexing strategies, JSONB, and generated columns.

• Can work independently but communicates proactively in a collaborative, paired workflow.

• Is comfortable navigating ambiguity, and values incremental progress over theoretical perfection.
  

Nice to Have:

• Prior experience with Firestore internals and its quirks.

• Has prior experience managing infrastructure on GCP or AWS.

• Exposure to agricultural, financial, or inventory software.

• Familiarity with backfill tooling, data validation pipelines, or operational observability.

• Familiarity with codemod tools such as codeshift

Values

• Real Talk – We create space for ourselves and others to be straightforward, vulnerable, and accountable.

• Reach Understanding – We are driven by curiosity and empathy to learn about our customers, team, and world.

• Be Proactively Resourceful – We are internally motivated and externally empowered to identify opportunities and solve problems.

• Derisk Thoughtfully – We lean into the biggest risks we face as a company and put in the work to address them systematically.

• Find the Positive-Sum – We believe in creating incentive structures that align the needs of our company, our customers, and our planet.

• Ambrook is an equal opportunity employer. We are committed to building diversity and inclusion into our core company culture.