Data Migration Analyst II: Lead Data Onboarding & Automation

Vertexone; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

VertexOne is seeking a Data Analyst II, Data Migration to orchestrate data extraction, profiling, mapping, and validation for migrations to our CIS platform. You will lead technical direction with migration engineers, develop robust mappings, and ensure data quality across mock conversions and live cutovers.

The role emphasizes hands-on SQL, KNIME workflows, and collaboration with cross-functional teams to deliver repeatable, reliable migrations, while improving methodologies and automation.

Qualifications

• 4 to 8 years of experience in data analysis, data migration, ETL, or a related technical role.
• Experience leading or reviewing the work of other analysts or engineers on data migration or ETL projects.
• Strong proficiency in SQL, including complex joins, aggregations, and data validation queries.
• Experience with utility CIS or billing platforms (e.g., SAP IS-U, Oracle CC&B, or similar) and utility meter or billing data.
• Demonstrated experience with data mapping, data profiling, and data quality or reconciliation practices.
• Experience with ETL or workflow tools (e.g., KNIME, SSIS, Talend, Alteryx, Airflow, Python).
• Exceptional attention to detail and a data driven approach to problem solving and decision making.
• Ability to manage multiple migration workstreams and deadlines in a fast paced, high visibility environment.
• Excellent written and verbal communication skills, with the ability to explain technical findings to business and client audiences.
• Flexibility to work occasional evenings and weekends during production cutovers and go live events.
• Coordinate with an offshore delivery team, including regular working‑hour overlap.

Responsibilities

• Extract, profile, and analyze source data from legacy CIS, billing, and metering systems.
• Lead day-to-day technical direction for migration engineers, including mappings and validation results.
• Develop and maintain source-to-target data mappings and transformation logic.
• Write, optimize, and maintain SQL for data extraction, transformation, reconciliation, and validation.
• Execute mock conversions and production cutovers with post-migration validation.

Skills

SQL

Data migration

ETL

KNIME

Python

Data profiling

Data quality

SaaS exp

Education

Bachelor's degree

Tools

KNIME Analytics Platform

DB2 for IBM i

Airflow

Git

Job description

VertexOne is seeking a Data Analyst II, Data Migration to orchestrate data extraction, profiling, mapping, and validation for migrations to our CIS platform. You will lead technical direction with migration engineers, develop robust mappings, and ensure data quality across mock conversions and live cutovers.

The role emphasizes hands-on SQL, KNIME workflows, and collaboration with cross-functional teams to deliver repeatable, reliable migrations, while improving methodologies and automation.