Analyst, IS Business Intelligence

247Hire

Job Location:

Mahwah, NJ - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Application Deadline: April 11 2026
Mahwah
On-site
Hourly salary: $39

Job Description

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.

Required Experience:

Application Deadline: April 11 2026 MahwahOn-siteHourly salary: $39Job DescriptionResponsibilitiesSupport 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 ...