Key skills
Distributed SystemsGraphQLIoTJavaScriptPostgresSOAPTypeScriptPostgreSQLSupabaseProject ManagementCommunication
About this role
Role Overview
- 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
Tech Stack
- Distributed Systems
- GraphQL
- IoT
- JavaScript
- Postgres
- SOAP
- TypeScript
Benefits
- Competitive base salary
- Equity participation
- Five weeks PTO
- Full healthcare coverage