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.