gaiia Logo

gaiia

Data Migration Engineer

Posted Yesterday
Be an Early Applicant
Remote
Hiring Remotely in Canada
Mid level
Remote
Hiring Remotely in Canada
Mid level
Own technical execution of customer data migrations: explore source systems, export data, author declarative version-controlled mappings, transform and validate data, run end-to-end migrations on internal platform, build reusable templates/validation, troubleshoot discrepancies, and document mapping and transformation logic for auditable production cutovers.
The summary above was generated by AI
🤙🏼 About gaiia

At gaiia, we're building the leading platform for Communications Service Providers (CSPs) that truly care about their customers. Our core product is an operating system (OS) for telcos that manages billing, operations, automation and everything in between.

We're passionate about taking care of our people, and it's not just lip service. We want you to focus on your job while we care for everything else. We offer competitive pay and benefits, flexible vacations, attractive stock options, unparalleled transparency, and a 100% remote environment. We're excited to have you join us for your next career adventure!

🎭 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 [email protected] as per the Accessible Canada Act and human rights legislation. We're here to support you every step of the way. #LI-DNI

Similar Jobs

4 Hours Ago
Easy Apply
Remote
CAN
Easy Apply
Mid level
Mid level
Artificial Intelligence • Edtech • Machine Learning • Software
Provide Level 1–2 global IT support and manage endpoint lifecycle, identity and access, and workplace SaaS. Troubleshoot macOS/Windows, support MDM/endpoint security, run onboarding/offboarding, use ITSM tools, document processes, and collaborate with security and HR to maintain secure, compliant employee technology experiences.
Top Skills: AtlassianBashCrowdstrikeFreshserviceGoogle WorkspaceItsmJAMFJira Service ManagementJumpcloudKandjimacOSMdmMfaMicrosoft 365Microsoft DefenderMicrosoft Entra IdMicrosoft IntuneOktaPowershellPythonSentineloneServicenowSlackSsoWindowsZendeskZoom
10 Hours Ago
Remote or Hybrid
Canada
Senior level
Senior level
Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Lead and modernize QA strategy across cloud-native insurance connectivity platforms. Drive AI-assisted test generation, automation frameworks, performance and regression testing, release validation, quality metrics, and mentor QA leaders to improve release confidence and reliability.
Top Skills: Ai FrameworksAPIsCloud-Native ApplicationsDevOpsDistributed Messaging SystemsEvent-Driven ArchitecturesGoogle Cloud Platform (Gcp)JavaLookerMessage QueuesPerformance TestingRegression TestingSpringTest Automation Frameworks
11 Hours Ago
Remote or Hybrid
Senior level
Senior level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Manage and optimize procurement processes, supplier relationships, and contracts to drive cost savings and operational efficiency. Perform cost analysis, use procurement systems, lead negotiations, monitor supplier performance, and provide reporting to support sourcing decisions and alignment with organizational goals.

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account