Note: The job is a remote job and is open to candidates in USA. Planet Depos ships enterprise software for the legal industry, with certified records as its core product. The Data & Migration Engineer owns the platform's data layer, including target data models, legacy-system migration, synchronization, data quality, data contracts, sanitized datasets, and analytics foundations.
Responsibilities
- Own the target data model in partnership with the Group Architect: the canonical entities the platform is built around, identity and access-bearing structures, and the boundaries with systems that own their own truth (CRM, finance)
- Own the data workstream of the legacy-platform replacement end to end: profiling, mapping, extraction, transformation, load, verification, and a staged, rehearsed cutover
- Build and operate the ongoing synchronization that keeps the new platform current through the transition, engineered for a fragile legacy source: rate limits respected, timeouts and retries handled, silent feed breaks made impossible by monitoring
- Design the data contracts our integrations run on: the supported surfaces and interchange formats that let customer systems and partner tools consume our data without bespoke plumbing
- Give the low-code estate a safe foundation: supported data surfaces for the citizen-developer applications and flows the business runs on, replacing direct database access over time
- Build the reconciliation and data-quality evidence: automated counts and checksums, exception queues, and human-readable verification reports
- Create and maintain sanitized and synthetic datasets from production, and manage dataset promotion across environments, so non-production work never requires production data
- Lay the analytics foundation with the platform team: safe read paths (replicas, sanitized exports) and data structures the business can query without touching production
- Steward database design standards with the platform team: DevOps owns infrastructure operations; this seat owns how data is modeled, accessed, and kept trustworthy
- Document the models, mappings, and pipelines so they are auditable and transferable, readable by both humans and agents
Skills
- You have worked in a fast-moving environment and stayed effective when priorities shifted under you
- You can disagree, and then commit wholeheartedly once a call is made
- You treat access to sensitive data as a responsibility to design around, not a convenience to accumulate
- You have moved production data between live systems without losing any
- You have executed at least one legacy-to-modern migration of a business-critical system, with the discipline that implies: reverse-engineering an undocumented source schema, building the field-level crosswalk from what the data actually contains, staged runs, parallel verification windows, documented reconciliation, and a rollback plan you could actually invoke. You know a migration is done when the evidence says so, not when the script exits zero
- You have designed data models and data contracts that a whole estate runs on
- You have owned an operational data model with many consumers: product applications, low-code and citizen-developer workloads, third-party integrations, and analytics, each pulling in a different direction. You know how to define the canonical entities, decide which system is the source of truth for what, and draw the boundary where another system's model stops being yours. You design the supported surfaces (views, APIs, contracts) that let those consumers build safely instead of reaching into tables directly, and your models outlive the applications that first used them
- You treat data quality as an engineering discipline, with evidence
- 5+ years in data engineering, database engineering, or migration-heavy roles
- Expert SQL (SQL Server and Postgres are both in play here), plus a scripting language for pipeline work (Python or TypeScript)
- Demonstrated operational data modeling: you have designed schemas and data contracts that multiple teams or systems consumed, and can speak to the tradeoffs you made
- At least one completed production migration of a business-critical system, with reconciliation you can speak to in detail
- Experience creating sanitized or synthetic test data from production systems and managing datasets across environments
- Experience running extraction or synchronization against fragile or rate-limited legacy sources
- Experience handling regulated or confidential data; legal-industry experience is a plus, not a requirement
- US-based, as a hard requirement of our client data-protection commitments
- Legal-industry experience
Benefits
- Medical, Dental, and Vision coverage
- Life insurance (Voluntary Term and Whole Life)
- Voluntary Long Term Disability
- Paid time off
- Paid holidays
- 401(k)
- Employee Assistance Program (EAP)
- Maternity Leave
Company Overview