Build and maintain production integrations using Prismatic.io, handling complex payload transformations and multi-step workflows
Process and normalize shipment tracking data from 3PL partners (UPS, Kuehne+Nagel, World Courier, DHL, FedEx)
Implement robust error handling and retry logic for unreliable vendor APIs ensuring 100% of data is captured
Design device selection algorithms to optimize telemetry data processing
Create matching logic for automated shipment routing decisions
Build integration deviation detection and alerting workflows
Process device telemetry streams from multiple IoT providers (Sensitech, Tag-n-Trac, Elpro, Tive, Samsara, Controlant, Roambee, etc.)
Calculate packaging thermal life and predict temperature breaches
Implement 3PL/carrier milestone processing for shipment status updates
Design dashboards for real-time integration health visibility for internal and external stakeholders
Debug and resolve geocoding issues with international addresses using Mapbox and other APIs
Implement comprehensive data validation for vendor payloads
Build data quality monitoring and anomaly detection systems
Create reconciliation workflows for mismatched shipment and device data
Handle API (REST, GraphQL, SOAP), EDI (AS2), and legacy (email, SFTP) transmission implementations
Design and optimize Supabase database schemas for high-volume telemetry data
Write complex PostgREST queries for data retrieval and aggregation
Implement efficient upsert patterns for real-time data updates
Build data archival and retention strategies
Create database migration scripts and maintain schema documentation
Debug production issues across multiple client environments
Optimize integration performance for high-volume data streams
Support Linear project management workflows
Document PAXAFE integration workflows, schemas, and other specifications

Requirements

4+ years building production data integrations with complex transformation requirements
Expert-level JavaScript/TypeScript for integration development
Strong experience with iPaaS platforms (Prismatic.io strongly preferred)
Proficiency with PostgreSQL and modern database patterns (Supabase/PostgREST experience a plus)
Experience with geocoding APIs and address normalization challenges
Understanding of webhook patterns, REST APIs, and real-time data streaming
Frontend experience for building integration monitoring dashboards
Critical domain experience in cold chain logistics and temperature-controlled shipments (pharmaceutical strongly preferred)
Experience with 3PL data formats and tracking systems
IoT device integration and telemetry processing
Understanding of GxP compliance and pharmaceutical logistics requirements
Knowledge of thermal packaging and temperature excursion management
EDI/AS2 protocol experience
Proven ability to debug complex data quality issues across multiple systems
Experience handling inconsistent vendor data formats and missing fields
Skills in reverse-engineering undocumented APIs and payload structures
Understanding of retry strategies and error recovery patterns
Experience with high-volume data processing optimization
Obsessive attention to data quality and validation
Ability to context-switch between multiple integration issues
Strong debugging skills with distributed systems
Experience managing vendor relationships and escalations
Clear technical documentation and communication skills

Benefits

Competitive base salary
Equity participation
Five weeks PTO
Full healthcare coverage

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

JavaScriptTypeScriptPostgreSQLPrismatic.ioREST APIsGraphQLSOAPEDIPostgRESTdata integration

Soft Skills

debuggingdata quality attentioncommunicationcontext-switchingproblem-solvingvendor relationship managementdocumentationcritical thinkingcollaborationadaptability