Description:

Ambrook is seeking an experienced Contract Software Engineer to assist in migrating their core production system from Firestore to PostgreSQL.
The role involves working closely with a full-time engineer at Ambrook to implement dual-write systems, data backfills, and parity checks.
This migration is a high-stakes project that requires preserving existing system behavior while incrementally shipping changes in a live production environment.
Responsibilities include implementing a shim for the existing storage layer, contributing to a JSONB-based Postgres schema, building tooling for data validation, and ensuring the correctness and performance of the dual-store system.

Requirements:

Candidates must have experience migrating real-world systems from NoSQL to relational backends, such as Firestore to Postgres or Mongo to SQL.
A deep understanding of SQL, particularly Postgres, including indexing strategies, JSONB, and generated columns, is required.
The ability to write clean, well-tested code, preferably in TypeScript, is essential.
Candidates should be able to work independently while communicating proactively in a collaborative environment.
Comfort with ambiguity and a focus on incremental progress over theoretical perfection are important traits.

Ambrook offers the opportunity to work on impactful projects that contribute to sustainability in family-run businesses.
The position allows for remote work flexibility, accommodating locations such as Denver and San Francisco.
As a Series A startup, Ambrook provides a chance to be part of a growing team that is addressing significant challenges at the intersection of industry and climate.
The company values diversity and inclusion, fostering a culture that encourages straightforward communication and accountability.