This is a fully remote role. Applicants must be located in Brazil.

AI Data Migration Specialist

About the Role

We are seeking an AI Data Migration Engineer to support a growing technology organization focused on modernizing data migration processes. This role is responsible for transferring data from legacy systems into a modern cloud-based software platform, ensuring accuracy, efficiency, and repeatability across customer implementations.

AI is central to this role. The ideal candidate will leverage AI coding agents and tools such as Claude Code, Cursor, and Copilot to profile legacy databases, develop field mappings, generate transformation and load scripts, and automate data validation. Rather than manually building every solution from scratch, this individual will direct AI-generated work, verify its accuracy, and develop reusable tools and workflows that improve the migration process over time.

Candidates must have the technical expertise to identify errors in AI-generated SQL and scripts, troubleshoot issues, and make necessary corrections. This is a highly autonomous, hands-on position for someone who takes ownership, identifies opportunities for improvement, and proactively automates inefficient processes.

Key Responsibilities

Manage end-to-end data migrations: Handle data migration projects from initial intake through mapping, transformation, loading, validation, and final sign-off. Work with various source formats, including database backups, SQL Server, Access, Oracle exports, CSV files, and Excel spreadsheets.
Leverage AI-driven development: Use AI coding agents to profile source databases, develop source-to-target mappings, and generate data cleansing, deduplication, transformation, and load scripts. Review, test, troubleshoot, and validate all AI-generated output.
Develop reusable migration tools: Build repeatable, AI-assisted import pipelines, scripts, and agent workflows that reduce manual effort and improve efficiency across future migrations.
Automate data validation: Develop automated reconciliation processes using row counts, checksums, and field-level comparisons to verify data integrity, accuracy, and completeness.
Drive process improvement: Identify opportunities to automate manual migration activities, improve existing workflows, and expand the use of AI-assisted solutions across the migration process.
Identify and resolve data issues: Proactively identify data quality concerns, troubleshoot discrepancies, and communicate potential risks or blockers before they impact implementation timelines.
Maintain documentation and auditability: Document mapping logic, transformation scripts, and migration logs to ensure processes are transparent, traceable, and maintainable.
Support production go-lives: Coordinate and support production cutovers, which may occasionally require evening and weekend availability to minimize disruption to customer operations.
Manage multiple projects: Maintain progress across several concurrent data migrations while prioritizing deliverables, communicating status, and escalating blockers as needed.

Performance Expectations

First 15 Days: Complete a migration alongside the existing team and identify opportunities to reduce manual effort within current processes.
First 30 Days: Independently manage data migrations and automate at least one recurring manual activity.
First 45 Days: Deliver a reusable import pipeline for a common legacy system and demonstrate measurable improvements in migration efficiency.

Required Qualifications

3+ years of hands-on experience working with relational databases and data imports, including ETL processes, bulk data loads, data conversions, or migrations.
Strong SQL skills, including the ability to write, debug, and optimize queries and identify errors in AI-generated SQL.
Ability to read, troubleshoot, and modify scripts written in Python, PowerShell, or similar languages, including AI-generated code.
Daily, hands-on experience using AI coding agents (e.g., Claude Code, Cursor, or Copilot agents) to develop data workflows and automate technical processes.
Ability to demonstrate previous work built using AI coding tools and explain how generated output was reviewed, tested, and corrected.
Proven experience automating previously manual processes, workflows, reports, or data imports.
Strong problem-solving skills and the ability to independently manage projects with minimal supervision.
Ability to manage multiple concurrent data migration projects and proactively communicate risks or blockers.
Willingness and availability to support scheduled evening and weekend production cutovers when needed.
Understanding of data privacy and security practices, particularly when handling personally identifiable information (PII) and sensitive customer data.

Preferred Qualifications

Experience working with Microsoft SQL Server.
Experience with ETL platforms, data integration tools, or data pipeline development.
Familiarity with municipal, local government, or other public-sector software platforms.