Senior Integration Engineer

Clera; New York (NY); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Visa sponsorship

Job summary

Clera in New York, NY is seeking a hands-on data integrations engineer to own the integration layer between the AI platform and enterprise systems. You will connect ERPs, data warehouses, and file stores, shipping reliable, scalable data flows end-to-end.

Ideal candidates have 3+ years building data pipelines in Python, deep API integration experience, and strong SQL skills; you will work directly with CPG operators and their IT teams in an end-to-end ownership model.

Qualifications

• 3+ years of hands-on production experience building 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.

Responsibilities

• 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.

Skills

Python

APIs (REST/SOAP)

SQL

Data pipelines

Cloud data warehouses

Data integration

Back-end frameworks

OAuth & authentication

Logging & observability

Enterprise customers

Tools

FastAPI

SQLAlchemy

Pydantic

Temporal

Databricks

BigQuery

Snowflake

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.