Data Migration Engineer

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

We are an equal-opportunity employer committed to inclusivity and diversity. Our workplace is fully remote and boasts accessible technologies, ensuring all team members can thrive. Should you require accommodations due to a disability during the application process, please contact us at 581-996-9639 or people@gaiia.com as per the Accessible Canada Act and human rights legislation. We're here to support you every step of the way. #LI-DNI