Freelance Data Engineer, Postgres, Systems Integration

• Build the layer connecting seven SaaS tools to a central Postgres database in both directions
• Develop multiple inbound pipelines for each system
• Resolve identities and determine which person or company a payload belongs to
• Push database-originated state to the platform that executes it
• Maintain consistency when platforms report back or contradict the database
• Prevent opted-out people from being re-added
• Deliver KPI data to a BI tool
• Make the data lake queryable in natural language
• Document decisions and maintain pipelines in GitHub
• Help evaluate and evolve the data model as new systems are integrated

• Experience integrating third-party APIs and webhooks, including pagination, retries, signature verification, rate limits, undocumented payload shapes, late and out-of-order events, and sources that fire on every change without identifying what changed
• Experience with bidirectional synchronization, including loop prevention, echo suppression, and conflict resolution
• Strong Postgres experience as an application database, including plpgsql functions, triggers, constraints, and row-level security (RLS)
• Idempotent pipeline design and implementation
• Git discipline, including migrations, pull requests, and code review
• Experience working with personal data under GDPR and understanding ingestion constraints
• Written English
• Useful but not required: n8n or another orchestrator
• Useful but not required: Supabase
• Useful but not required: relevance work on a search index such as Elasticsearch, OpenSearch, or Meilisearch
• Useful but not required: experience as the only person on a system
• German is useful but not required

• Remote and mostly async working arrangement
• Freelance engagement
• Three months to begin with, with continuation assessed based on needs