Senior Data Migration Engineer (Postgres / Supabase)
Job description
10EQS is a leading consulting network providing on-demand strategy consulting services and expert insights to our clients, which include Fortune 500 companies, investment, and leading professional services firms, as well as SMEs and start-ups across various industries to support their corporate strategy initiatives.
We’re migrating a business-critical operations application currently built on Knack to a custom stack using Supabase (Postgres). The app is used daily by 100+ users and has a dense, highly relational data model with complex connections.
This is a project-based contract role focused specifically on database design, data migration, and correctness. Frontend and API development are already covered.
What you’ll do
You will own the data side of the migration end-to-end:
- Analyze and understand an existing highly connected Knack data model
- Design a clean, scalable Postgres schema (including join tables, constraints, indexes)
- Create a clear mapping from Knack objects/fields to the new schema
- Build repeatable, idempotent migration scripts (export → transform → load)
- Handle messy real-world data (inconsistencies, edge cases, missing references)
- Run data validation and reconciliation (counts, integrity checks, spot audits)
- Support final migration and cutover planning (including rollback considerations)
- Collaborate closely with the app developer to ensure schema supports real workflows
Items that have already been covered/not included in this scope:
- Frontend development
- UI/UX
- General product management
- Writing business APIs (unless needed to support migration)
Required experience
- 5+ years working with Postgres in production
- Proven experience doing real-world data migrations (not just greenfield apps)
- Deep understanding of relational modeling, normalization, and join tables
- Experience writing safe, re-runnable migration pipelines
- Comfortable reverse-engineering legacy systems and undocumented logic
- Strong attention to data correctness and validation
- Experience with Supabase (helpful, not mandatory)
- Familiarity with row-level security (RLS) or DB-level permission models is a plus
- Past migrations from low-code/no-code tools (Knack, Airtable, Retool, etc.) is a plus
This is a contract/project-based position with an expected duration of 3-6 months. We provide you with the flexibility of working remotely.
We are a dynamic and growing team that is looking for like-minded individuals to join us! If you're interested, please apply directly on LinkedIn.
¿Te interesa este puesto?