Note: The job is a remote job and is open to candidates in USA. GovPilot is seeking an AI Data Migration Engineer to move customer data from legacy systems into its software accurately and efficiently. The role uses AI agents to build and verify migration workflows, automates validation, and creates reusable import tools.
Responsibilities
- Own migrations end-to-end. Take raw client data (database backups, SQL Server/Access/Oracle exports, CSV and Excel files) from intake through mapping, transformation, loading, and sign-off
- Drive the work with AI. Use AI agents to profile source databases, propose source-to-target mappings, and generate cleansing, deduplication, and load scripts. Then review, test, and take ownership of the output
- Build tools, not one-offs. Turn each migration into reusable, AI-assisted import pipelines, prompt and agent workflows, and scripts, so the next customer on the same legacy system takes less time
- Automate validation. Replace manual spot-checks with automated reconciliation: row counts, checksums, and field-level diffs. The bar is zero data loss and field-level accuracy, proven rather than assumed
- Push AI adoption forward. Find the next manual step in the migration process and automate it. Share what works with the team and help set how GovPilot runs migrations
- Catch problems early. Find data quality issues soon enough that they never threaten a go-live date, and explain them clearly to the people who need to act
- Keep it auditable. Keep mapping logic, scripts, and logs clear enough that any teammate can trace how a record was transformed
- Be there for go-lives. Production cutovers often happen in evenings or on weekends to avoid disrupting town operations. You'll plan for these and be available to see them through
Skills
- 3+ years of hands-on experience with relational databases and data imports: you've moved real data between real systems (ETL, bulk loads, data conversions, or migrations)
- Strong SQL: you can write, debug, and optimize queries, and you can quickly spot when SQL an AI generated is wrong
- Ability to read and modify scripts (Python, PowerShell, or similar) that an AI generated
- Daily, hands-on use of AI coding agents (e.g., Claude Code, Cursor, Copilot agents) to build data workflows. You can show us something you built this way and tell us what the AI got wrong
- A track record of automating work that used to be manual, whether a process, a report, or an import
- Self-direction: you've owned projects with little supervision and delivered without being chased
- Care with sensitive government and resident data (PII), using approved tools only
- Ability to run several client migrations at once and raise blockers early
- GovPilot is unable to sponsor or take over sponsorship of an employment visa at this time
- SQL Server experience
- Experience with ETL or data pipeline tools
- Familiarity with local government or municipal software
Benefits
- Unlimited PTO.
- Flexible working hours and remote work options.
- Comprehensive health, dental, and vision insurance.
- Professional development opportunities and learning budget.
- Home office and IT budget.
- Supportive team environment.
- The chance to work on innovative projects with cutting-edge technologies.
- 401(k) with 4% employer match for eligible team members.
- Access to the latest AI tools, plus the time and support to use them well.
- May be considered for a discretionary bonus.
Company Overview