Business Intelligence Analyst

Job Title: IS Business Intelligence Analyst Duration: 4+ months + possible extension/conversion Location: Mahwah, NJ, 07430 Job Summary: Supports a large-scale ERP data migration validation team ensuring data integrity as records move from legacy systems into SAP. Writes, troubleshoots, and optimizes SQL queries and stored procedures that reconcile source and target record counts, surface discrepancies, and confirm completeness across migration batches. Performs primary key matching across source, target, and error/reject tables to identify gaps and mismatches. Builds and maintains stored procedures following a layered staging architecture. Optimizes query performance on large datasets including data type tuning, indexing strategy, and managing complex transformations. Materializes validation results into physical tables for Power BI consumption. Performs sampling-based validation where full-query comparison isn't feasible. This is an individual contributor role that requires the use of judgement in applying professional expertise and is expected to work independently with minimal supervision. Also expected to participate in collaborative working sessions, provide on-call and live troubleshooting support, and present findings to large audiences. Requires strong T-SQL / SQL Server experience, comfort with stored procedures, CTEs, staging patterns, and dynamic SQL, and experience with large datasets and performance tuning. ERP data migration experience (SAP, JDE, Oracle), Azure Data Factory, and Power BI awareness are preferred.