What are the responsibilities and job description for the Analyst, IS Business Intelligence position at Judge Group, Inc.?
Location: Mahwah, NJ
Salary: $35.00 USD Hourly - $37.00 USD Hourly
Description:
Job Title: Analyst, Is Business Intelligence
Location: Mahwah, NJ
Duration:- 3
Supports a large-scale ERP data migration validation team ensuring data integrity as records move from legacy systems into SAP.
Writes, troubleshoot, 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. Typically requires a degree or equivalent practical experience.
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact:
This job and many more are available through The Judge Group. Please apply with us today!
Salary: $35.00 USD Hourly - $37.00 USD Hourly
Description:
Job Title: Analyst, Is Business Intelligence
Location: Mahwah, NJ
Duration:- 3
Supports a large-scale ERP data migration validation team ensuring data integrity as records move from legacy systems into SAP.
Writes, troubleshoot, 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. Typically requires a degree or equivalent practical experience.
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact:
This job and many more are available through The Judge Group. Please apply with us today!
Salary : $35 - $37