This job is no longer available

Ambrook

Software Engineer, SQL Migration (Contract)

San Francisco, CA, US, Denver, CO, US

RemoteFull time roleEarly Career, Mid Level, Senior Level

3 months ago

About the Job

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.

About the Company

Ambrook Logo

Ambrook

New York, NY, USA

21-50

Ambrook’s mission is to help American family-run businesses become more profitable and resilient. There is a virtuous cycle between profitability and climate resilience in many natural resource industries, especially agriculture. From record-breaking droughts to rising input costs and unpredictable markets, operators across American industry are navigating increasing pressure – much of it driven by a changing climate and economy. Many of the most impactful 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 building a financial management platform that independent operators can trust – starting with American agriculture. We replace paperwork and legacy systems with modern tools for accounting, banking and spending – designed for people who spend more time in the field than in the office. Our platform provides the financial clarity operators need to make confident, climate-smart investments in their land, their business, and their future. When producers can invest in ways that make their businesses stronger, they become a force for generational resilience and prosperity. We’re starting with farmers and ranchers – helping them make decisions that withstand the test of time. Our early team members are pivotal in driving this vision.

Similar Jobs

Paces Logo

Software Engineer (Backend)

Software Engineer (Backend)

  • Paces
  • Brooklyn, NY, US
  • Hybrid
  • Full time role

AI-driven software to optimize and accelerate green infrastructure projects for maximum climate impact.

3 days ago

Paces Logo

Data Engineer

Data Engineer

  • Paces
  • Brooklyn, NY, US
  • Hybrid
  • Full time role
  • $120,000 – $170,000 / Yearly

AI-driven software to optimize and accelerate green infrastructure projects for maximum climate impact.

3 days ago

Ecobee Logo

Staff BI/Analytics Engineer

Staff BI/Analytics Engineer

  • Ecobee
  • Toronto, ON, CA
  • Hybrid, Remote
  • Full time role

Smart home solutions delivering 20 TWh energy savings, reducing carbon footprint significantly.

8 days ago

Grid Edge Logo

Database Engineer (PostgreSQL)

Database Engineer (PostgreSQL)

  • Grid Edge
  • Birmingham, England, GB
  • Hybrid
  • Full time role

AI-driven solutions for energy optimization, transforming buildings into smart, sustainable participants in the energy system.

3 months ago

Glydways Logo

Software Engineer - Data Engineering

Software Engineer - Data Engineering

  • Glydways
  • Hybrid, Remote
  • Full time role

Net-negative GHG autonomous transportation for affordable, efficient, and eco-friendly mobility solutions.

2 months ago

Serve Robotics Logo

Sr. Engineering Manager, Data Infrastructure

Sr. Engineering Manager, Data Infrastructure

  • Serve Robotics
  • United States
  • Hybrid, Remote
  • Full time role

Zero-emissions robots revolutionizing sustainable, self-driving food delivery.

About 1 month ago

Renew Home Logo

Senior Engineer, Data (Remote, US)

Senior Engineer, Data (Remote, US)

  • Renew Home
  • United States
  • Hybrid, Remote
  • Full time role

Building the largest sustainable power plant on the grid

About 1 month ago

Workiva Logo

Senior Manager of Analytics Engineering

Senior Manager of Analytics Engineering

  • Workiva
  • United States
  • Hybrid, Remote
  • Full time role

"Streamlining integrated ESG reporting for transparent climate impact and compliance."

28 days ago

Verdigris Logo

Lead Data Engineer

Lead Data Engineer

  • Verdigris
  • North America
  • Hybrid, Remote
  • Full time role

Revolutionizing energy use with smart sensors and AI for a sustainable future.

27 days ago

Corinex Logo

Senior Backend Software Engineer

Senior Backend Software Engineer

  • Corinex
  • Vancouver, BC, CA
  • Hybrid, Remote
  • Full time role

Optimizing grid flexibility for smarter, low-carbon energy consumption through cutting-edge digital solutions.

9 days ago