Job description
About the Role
This is a high-ownership engineering role at a seed-stage AI supply chain startup focused on the CPG sector. You will own the integration layer that connects the platform's AI decision engine to the real-world systems where customer data lives: legacy ERPs, cloud data warehouses, object storage, FTP drops, and custom spreadsheets. Getting this layer right means AI-driven recommendations actually land in systems of record, reliably and at scale.
What You'll Do
Build, extend, and maintain integrations across ERPs, cloud data warehouses, object storage, and custom data sources.
Design and orchestrate near-realtime syncs that handle millions of records per customer without manual intervention.
Go deep into each external API, including its quirks and undocumented behaviors, and build connectors that hold up against real customer data.
Write round-trip integration tests that protect the full read-update-write lifecycle from data loss.
Validate and cross-match data early in the pipeline to catch errors before they cause business harm.
Build monitoring and alerting so failures are caught and triaged before customers notice.
Work directly with CPG operators and their IT teams, owning integrations end to end from scoping through shipping and ongoing operations.
Evolve the integration layer so connecting new, unseen data sources becomes a configuration exercise rather than a rebuild.
What We're Looking For
3 or more years of hands-on production experience building and shipping data pipelines and integrations in Python.
Deep experience integrating third-party systems via REST, SOAP, and query-language APIs, including OAuth, rate limiting, pagination, and undocumented API quirks.
Strong proficiency with the Python backend stack: FastAPI, SQLAlchemy, and Pydantic.
Advanced SQL skills, including high-performance query writing and bulk upsert operations at scale (billions of records).
Experience designing idempotent, re-runnable pipelines with clean fetch, validate, normalize, and upsert patterns.
Experience building write-path integrations with safety rails, dry runs, failure capture, and full auditability.
Experience building for operability: structured logging, sync-run tracking, alerting integrations, and failure attribution.
Experience with cloud data warehouse platforms such as Snowflake, BigQuery, or Databricks.
Experience with background task orchestration frameworks (such as Temporal, Hatchet, or similar) for scheduling reliable syncs.
Bonus: NetSuite API experience, AWS services (S3, FTP), unstructured data ingestion, or legacy ERP integration background.
Comfort working directly with enterprise customers and their IT teams in an end-to-end ownership model.
Compensation & Benefits
Visa sponsorship is available for this role.
Location
On-site in New York, United States.
Originally posted on Himalayas
Who can apply
Eligible countries: United States. Accepted UTC offsets: UTC-10, UTC-9, UTC-8, UTC-7, UTC-6, UTC-5, UTC+14. Review the full description for employer-specific work authorization, residency and schedule requirements.