Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy, and consent to receive emails from Rise
Jobs / Job page
Contract Software Engineer, SQL Migration image - Rise Careers
Job details

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.

Average salary estimate

$85000 / YEARLY (est.)
min
max
$70000K
$100000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

Similar Jobs
Posted 4 days ago

DTCC is looking for Full Stack Developers to work on innovative projects within their Application Development teams in a hybrid work environment.

Photo of the Rise User

Sysdig is searching for a seasoned Staff Software Engineer (Frontend) to architect and enhance high-quality, secure front-end applications in a dynamic cloud security environment.

Photo of the Rise User
Posted 2 days ago

Lead the development of scalable cloud native network management systems as Principal Engineer Software at Palo Alto Networks.

Photo of the Rise User
Posted 13 days ago

An experienced Principal Software Engineer role at Broadcom VMware, focusing on developing and leading the graphics virtualization stack using modern 3D APIs.

Photo of the Rise User

Redhorse Corporation seeks a Senior Software Engineer Subject Matter Expert in digital forensics to architect and lead forensic software projects supporting national security.

DMV IT Service Hybrid No location specified
Posted 5 days ago

Experienced C++ Developer needed to develop software for data extraction from DB2 mainframe databases at an established IT consulting firm.

Photo of the Rise User

Innovate and optimize deep learning models for edge deployment at Field AI, pushing the boundaries of robotics intelligence.

Photo of the Rise User
Posted 5 days ago

Innovate and own projects as an AI Engineer at a fast-growing AI devtool startup based in San Francisco.

Photo of the Rise User

An AI-focused Software Engineer opportunity at Atmosera to lead collaborative developer sprints and mentoring around GitHub Copilot and Amazon Q technologies.

Photo of the Rise User
Posted 8 days ago

Contribute as a Backend Engineer developing scalable cloud infrastructure for a video surveillance platform using Go or Python within a collaborative engineering team.

Photo of the Rise User
PM2CM Hybrid No location specified
Posted 6 days ago

PM2CM, Inc. is looking for a Senior Full Stack Developer to lead the development of impactful web and GIS solutions in the public sector.

Photo of the Rise User

Experience building scalable backend systems and integrations at Supermove, a Series A startup transforming the moving industry through innovative technology.

Photo of the Rise User
Zscaler Hybrid San Jose, California, United States
Posted 7 days ago

Experienced Staff Software Engineer - UI Automation needed at Zscaler to lead automation efforts and improve user experience in a hybrid work setting.

Ambrooks mission is to make sustainability profitable in natural resource industries. The first industry we are tackling is agriculture building financial management tools for farms, starting with helping farmers automatically discover and apply t...

14 jobs
MATCH
Calculating your matching score...
FUNDING
SENIORITY LEVEL REQUIREMENT
TEAM SIZE
EMPLOYMENT TYPE
Contract, remote
DATE POSTED
June 6, 2025

Subscribe to Rise newsletter

Risa star 🔮 Hi, I'm Risa! Your AI
Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!