Contract Software Engineer, SQL Migration

Ambrook’s mission is to help family-run American businesses become more profitable and resilient.

From record-breaking droughts to rising input costs and unpredictable markets, operators across American agriculture and industry are navigating increasing pressure — much of it driven by a changing climate and economy. Many of the best long-term investments — like water-efficient irrigation or improved grazing rotations — support both the land and the bottom line. But even when the payoff is clear, these changes often require upfront capital and financial clarity that’s hard to come by.

With fragmented records and outdated tools, business owners can’t easily see what’s working — let alone prove viability to a lender, partner, or the next generation.

Ambrook is rebuilding the financial infrastructure that independent operators rely on.

We replace paperwork and legacy systems with modern tools for accounting, banking, invoicing and spending — built for people who spend more time in the field than in the office. Our platform gives producers the financial clarity they need to make confident investments in their land, their operation, and their future.

Our customers are the backbone of the real economy — stewards of land, labor, and legacy. When they can invest in ways that make their businesses stronger and more durable, they become a force for generational resilience across America.

We’re starting with farmers and ranchers across the country — helping them keep the family business in the family and make decisions that stand the test of time.

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, climate, and the economy.

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.