Analyst, IS Business Intelligence

Important information

To be immediately considered, please send an updated version of your resume to somp767@kellyservices.com.

Location

Mahwah, NJ, 07430 (ONSITE)

Duration

Until Aug/ 2026 (4 months)

Employment Type

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.