Data Analyst II, Data Migration
Job Description
Overview of Role/Job Purpose:
The Data Analyst II, Data Migration is a highly visibility role focused on migrating and onboarding utility customers to VertexOne's CIS platform. Reporting to the Data Migration Manager, this analyst extracts, profiles, maps, transforms, and validates customer data from legacy systems. They ensure data accuracy, conversion stability, and clear exceptions handling through every phase of delivery.
The role combines analytical judgement with practical automation and process improvement. This person will help improve the way we deliver migrations so that each conversion is more repeatable, efficient, and reliable. They will work closely with internal teams and utility clients during discovery, mapping, mock conversions, validation, and go-live.
The successful candidate is deeply data driven, meticulous, and able to communicate complex data issues clearly to both technical and business audiences. They will partner closely with the Data Migration Manager on delivery planning, team direction, and practical AI automation, and act as the manager's delegate when needed. This is a hands-on role for someone who is technology-curious, eager to learn, enjoys solving messy data problems, building practical expertise, and growing into team leadership within the data migration organization.
Essential Duties:
Work with clients to extract, profile, and analyze source data from legacy utility CIS, billing, and metering systems, including relational databases, and flat or fixed width files.
Lead day-to-day technical direction for migration engineers, including reviewing and approving mappings, transformation logic, and validation results before they go to clients.
Create and maintain project and team weekly status reports.
Develop and maintain source to target data mappings and transformation logic in partnership with Implementation, Product, and utility client teams.
Write, optimize, and maintain SQL for data extraction, transformation, reconciliation, and validation.
Execute mock conversions and production cutovers, validating record counts, balances, and business rules at each migration phase.
Own cutover readiness for assigned client migrations, including runbooks, go/no-go recommendations, and post-migration validation sign-off.
Design and implement data quality checks, reconciliation reports, and exception handling that surface issues early and ensure stability through go live.
Identify manual and repetitive migration tasks and build automated, reusable workflows using KNIME, scripting, and other automation tooling.
Contribute to the continuous improvement of migration methodology, templates, and standards to increase accuracy, efficiency, and repeatability.
Perform root cause analysis on data defects and conversion errors, and drive resolution with internal and client stakeholders.
Own one or more client migration streams end to end and