Analyst, IS Business Intelligence

The Judge Group

Mahwah, NJ

Apply

JOB DETAILS

SALARY

$35–$37 Per Hour

SKILLS

Analysis Skills, Business Intelligence, Data Migration, Data Quality, Data Sets, ERP (Enterprise Resource Planning), Identify Issues, Java IDE (Integrated Development Environments), Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, On Call, Oracle, Performance Tuning/Optimization, Power BI, Query Optimization, SAP, SQL (Structured Query Language), Short Messaging Service (SMS), Stored Procedures, Team Player

LOCATION

Mahwah, NJ

POSTED

Today

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!

About the Company

The Judge Group

The Judge Group Inc., is a leading professional services firm specializing in talent, technology, and learning solutions. We consult, staff, train, and solve. Through our work we make people and organizations better. Our services are successfully delivered through a network of more than 30 offices across the United States, Canada, and India.

The Judge Group is proud to partner with the best and brightest companies in business today, including over 60 of the Fortune 100. We serve organizations in financial services, healthcare, life sciences, insurance, government (including aerospace and defense), manufacturing, and technology and telecommunications. If you would like to learn more about The Judge Group visit www.judge.com or call toll free (800) 360-4474.

COMPANY SIZE

5,000 to 9,999 employees

INDUSTRY

Computer/IT Services

FOUNDED

1970

WEBSITE

https://www.judge.com

Resume Resources

Free Resume Templates Free Resume Builder