Data Migration Analyst

Important information: To be immediately considered, please send an updated version of your resume to somp767@kellyservices.com. Title: Analyst, IS Business Intelligence Location: Mahwah, NJ, 07430 (ONSITE) Duration: Until Aug/ 2026 (4 months) W2 Contract (No C2C) Rate: $39 per hour Responsibilities • Support a large-scale ERP data migration validation team, ensuring data integrity as records move from legacy systems into SAP. • Write, troubleshoot, and optimize SQL queries and stored procedures to reconcile source and target record counts, surface discrepancies, and confirm completeness across migration batches. • Perform primary key matching across source, target, and error/reject tables to identify data gaps and mismatches. • Build and maintain stored procedures following a layered staging architecture. • Optimize query performance on large datasets, including data type tuning, indexing strategies, and management of complex transformations. • Materialize validation results into physical tables for consumption by Power BI reporting. • Perform sampling-based validation where full query comparison is not feasible. • Operate as an individual contributor, applying professional judgment and working independently with minimal supervision. • Participate in collaborative working sessions and provide on-call and live troubleshooting support. • Present validation findings and status updates to large audiences. Qualifications • Strong T‑SQL and SQL Server experience, including stored procedures, CTEs, staging patterns, and dynamic SQL. • Demonstrated experience working with large datasets and applying query performance tuning best practices. • ERP data migration experience (SAP, JDE, Oracle) preferred. • Experience with Azure Data Factory preferred. • Awareness of Power BI and downstream reporting consumption preferred. • Bachelor’s degree or equivalent practical experience required.