Data Migration Engineer

Role Description

We're looking to hire a Data Migration Engineer to own the technical execution of data migrations that move customers from legacy systems into gaiia. You'll join the Migration Solutions team, which owns the end-to-end delivery of customer migrations.

• Explore legacy source systems (databases, flat files, reports, APIs) to understand their structure, quality, and relationships in the context of gaiia's data model.
• Export source data across a range of access methods — SQL, APIs, manual extracts, and database backups.
• Transform exported data into gaiia's standard format by authoring declarative, version-controlled mapping files that encode the business rules defined with the Data Migration Specialist.
• Execute migrations end-to-end on the internal migration platform: load, validate against target schemas, reconcile, and import to production.
• Build and reuse mappings, templates, and validation rules so each migration is faster and more repeatable than the last.
• Contribute small engineering improvements to the migration tooling — new validation rules, transforms, mapping updates — and raise larger needs to the Migration Platform team.
• Diagnose and resolve data discrepancies during dry runs, UAT, and post-cutover.
• Document mapping specs, transformation logic, and data anomalies so migrations are auditable and repeatable.

Qualifications

• Experience (3-5+ years) in data engineering, data migration, ETL, or a similar hands-on data role.
• Strong command of ETL fundamentals — you treat extract → transform → load as a deliberate methodology: staging, repeatable/idempotent loads, full vs. incremental loads, and validation and reconciliation at each stage.
• Hands-on data-manipulation fluency — comfortable querying, profiling, and reshaping data across languages (SQL, Python, JSON, or similar) and debugging issues in unfamiliar source schemas.
• Experience extracting data from a variety of sources: relational databases, APIs, flat files, and backups.
• Proven ability to transform messy, poorly documented data into clean, structured output.
• Solid grasp of data quality, validation, reconciliation, and cleansing techniques.
• Familiarity with OSS/BSS, telecom, or billing/CRM data models (e.g. subscribers, services, billing accounts) — or the ability to ramp on unfamiliar domain models quickly.
• Proficiency in TypeScript/JavaScript (Node) for data and tooling work, and comfort with version-controlled, repeatable transformations.
• A bias toward reusability and automation over one-off scripts.
• Comfortable operating in fast-paced, ambiguous environments with shifting source systems.
• Bachelor's degree in Computer Science, Information Systems, Data/Software Engineering, or a related field, or equivalent work experience.

Requirements

• Comfort using AI-assisted tooling to accelerate data exploration, mapping, and validation.
• Familiarity with building or extending an internal data platform or migration tooling.
• Exposure to cutover/go-live operations: delta loads, reconciliation, and rollback.
• Experience collaborating with a separate platform or product engineering team.

Benefits

• Flexible 25-days of vacation.
• Stock Options Plan.
• Group Insurance.
• Telemedicine.
• Life Spending Account.
• GRSP.
• Flexible working hours & all-remote work.