Data Migration Engineer

GAIIAS

$90K — $120K *
US-AnywhereRemote in Canada
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3-5+ years of experience in data engineering, migration, or ETL roles.
  • Strong understanding of ETL processes, including staging and validation.
  • Proficiency in querying and manipulating data using SQL, Python, JSON, or similar.
  • Experience with data extraction from various sources like databases and APIs.
  • Ability to clean and structure messy data effectively.
  • Knowledge of data quality and validation techniques.
  • Familiarity with telecom or billing/CRM data models, or the ability to learn quickly.
  • Proficiency in TypeScript/JavaScript (Node) for repeatable transformations.

Responsibilities

  • Explore and understand the structure and quality of legacy source systems.
  • Export data using various access methods like SQL and APIs.
  • Transform data into the standard format using mapping files.
  • Execute migrations on the internal platform from start to finish.
  • Build reusable migration components for efficiency.
  • Improve migration tools by suggesting and implementing small changes.
  • Diagnose and resolve data discrepancies throughout the migration process.
  • Document data mapping and transformation processes for repeatability.

Benefits

  • 25 days of flexible vacation.
  • Stock Options Plan.
  • Group Insurance coverage.
  • Access to Telemedicine services.
  • Life Spending Account.
  • Group Retirement Savings Plan (GRSP).
  • Flexible working hours and fully remote work options.
Full Job Description
Role & Team

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. Within that team, you own the data - exploring source systems, exporting it, transforming it into gaiia's standard format, and driving its execution to a validated, production-ready state.

You'll partner closely with the Data Migration Specialist - who owns the customer relationship and migration design - working from the business context and mapping rules they hand off. You'll also work alongside the Migration Platform team, who build and maintain the internal tooling that runs migrations: you'll live in it daily, improve it where you can, and specify the larger needs for them to build. This is a hands-on engineering role for someone who likes turning messy, real-world data into something clean, repeatable, and trusted.

What You're Going to Do

  • 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.

What Success Looks Like

  • Source data lands in gaiia accurately, completely, and on schedule, with discrepancies caught before go-live.
  • Transformation and validation work is reusable - later migrations build on your templates and rules rather than starting from scratch.
  • Data issues are diagnosed and resolved quickly, keeping migrations on schedule.
  • Tooling gaps are either fixed directly or clearly specified for the Migration Platform team.
  • The data you deliver is trusted - accurate and well-documented enough to present to customers with confidence.

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.

Nice-to-have

  • 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.

Salary

At gaiia, we have a transparent salary philosophy and a robust evaluation and compensation framework. It translates to a fair and impartial model where salaries are published internally, healthy discussions about compensation and performance can exist, and taboos are removed.

Benefits

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


Similar Jobs

More Jobs at GAIIAS

More Information Technology Jobs

Find similar Data Migration Engineer jobs: