SQL Data Migration Specialist / SQL Data Analyst/Engineer

iMPact Business Group

Mahwah, NJ

JOB DETAILS
SKILLS
Data Analysis, Data Migration, Data Quality, Data Sets, Detail Oriented, ERP (Enterprise Resource Planning), Identify Issues, Medical Equipment, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Query Optimization, Reimbursement, SAP, SQL (Structured Query Language), Stored Procedures, Team Player, Willing to Travel
LOCATION
Mahwah, NJ
POSTED
30+ days ago

*** Please note: This role does NOT allow for Visa sponsorship, now or in the future ***


Our client, a Global Leader in the Medical Device Industry, has an immediate opening for an SQL Data Migration Specialist for an 4-month+ contract.  Our client offers results-driven people a place where they can make a difference - every day!  You will also have the opportunity to work with other like-minded, self-directed, and detail-oriented Top Talent in a highly collaborative and professional environment. 

 

This role will support a large-scale ERP data migration validation team ensuring data integrity as records move from legacy systems into SAP.  


This role can be performed remotely in the Eastern or Central time zone, but does have specific onsite travel requirements later in the program, Candidates unable to travel will NOT be considered.  Travel and Lodging expenses will be reimbursed. 


During the deployment phase, this position will work  onsite in New Jersey just ahead of the 4th of July holiday and will be working through that entire weekend, with overtime hours likely for troubleshooting and last minute problem resolution.


Position Responsibilities


  • Supporting a large-scale ERP data migration validation team to ensure data integrity as records move from legacy systems into SAP.
  • Writing, troubleshooting, and optimizing SQL queries and stored procedures that reconcile source and target record counts, surface discrepancies, and confirm completeness across migration batches.
  • Performing primary key matching across source, target, and error/reject tables to identify gaps and mismatches.
  • Building and maintaining stored procedures following a layered staging architecture.
  • Optimizing query performance on large datasets through data type tuning, indexing strategies, and managing complex transformations.
  • Materializing validation results into physical tables for Power BI consumption.
  • Performing sampling-based validation when full-query comparison isn't feasible.

About the Company

i

iMPact Business Group

Working with iMPact

 

Here at iMPact we have helped connect candidates to opportunities available in Information Technology, Accounting/Finance, Engineering, and Business Process/Administration. We have full-time, part-time and contract positions available in Michigan, Florida as well as nationwide.

 

Our headquarters is located in Grand Rapids, MI and we also have an office in Tampa, FL. When you’re working with us, one of our experienced recruiters will connect you with matching opportunities and they will be there every step of the way to help you through the application, interviewing and onboarding process to ensure success.

 

To connect with one of our recruiters, submit your application for one of our open positions, or visit our website www.impactbusinessgroup.com to submit your resume for general consideration. We look forward to hearing from you!

COMPANY SIZE
100 to 499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
2004
WEBSITE
https://impactbusinessgroup.com