Senior Data Architect – Schema & Systems-of-Record Design at Dreamable, Inc | Torre

Senior Data Architect – Schema & Systems-of-Record Design

Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Freelance
Recurrent
Compensation
USD4k - 6.5k/month
Non-negotiable
location_on
Remote (specific timezone)
public
GMT-11:00 to GMT-05:00
Posted 10 months ago

Responsibilities


* Own the design, evolution, and governance of the core data schema for a continuously ingested AI ecosystem database. * Define and maintain canonical entities, including tools, companies, creators, newsletters, and communities, and manage their relationships over time. * Design strategies for entity identity resolution, deduplication, merges, rebrands, and historical continuity. * Model relationship lifecycles, confidence states, provenance, and temporal changes. * Review and harden schema changes to prevent data corruption during continuous ingestion. * Collaborate with ingestion workflows such as n8n, crawlers, and APIs, while keeping semantic logic decoupled from ingestion. * Design hybrid relational and graph-style data models using Postgres and knowledge-graph patterns. * Establish invariants, data contracts, and migration-safe schema evolution practices. * Act as the long-term owner of schema correctness and data integrity. * Strong fit for candidates with experience in semantic data modeling, knowledge graphs, master data management, search or data platforms, identity resolution, or large evolving datasets.