Data Analyst (SQL)
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
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.