Talent.com
iMPact Business Group
SQL Data Migration Specialist / SQL Data Analyst/EngineeriMPact Business Group • Mahwah, NJ, US
SQL Data Migration Specialist / SQL Data Analyst/Engineer

SQL Data Migration Specialist / SQL Data Analyst/Engineer

iMPact Business Group • Mahwah, NJ, US
30+ days ago
Job type
  • Full-time
  • Quick Apply
Job description

*** 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.

Required Skills

  • Bachelor's Degree or equivalent practical experience
  • Prior experience supporting ERP data migration projects
  • Strong experience with T-SQL / SQL Server, including stored procedures, CTEs, staging architecture, and dynamic SQL
  • Rock solid SQL Development experience, must be able to write Complex SQL Queries without the use of AI
  • Proven ability to work with large datasets
  • Database and SQL performance tuning experience
  • Expertise in data validation, reconciliation, and ensuring data integrity across systems
  • ERP data migration experience (SAP, JDE, Oracle), experience with SAP Tables is ideal, or other ERP system Tables
  • Familiarity with Azure Data Factory (ADF)
  • Power BI and Data Visualization experience is ideal
  • Medallion Architecture experience is a strong nice to have
Create a job alert for this search

SQL Data Migration Specialist / SQL Data Analyst/Engineer • Mahwah, NJ, US

Similar jobs

Dynamics 365 CRM Data Migration Consultant

AppWorksNew York, NY, United States
Full-time

Data Migration Consultant (Mainframe to Dynamics 365 CRM).We are seeking an experienced Data Migration Consultant with strong expertise in migrating legacy mainframe data to Microsoft Dynamics 365 ... Show more

 • Promoted

Remote Financial Analyst

Micro1Peekskill, New York, US
Remote
Full-time +1

Investment Strategy & Advisory.Predictive Analytics & Visualization.AI data lab for training frontier models and evaluating AI agents.Experts contribute their diverse subject matter knowled... Show more

 • Promoted

Data Entry Product Support - $45 per hour - No Experience

GL Inc.Peekskill, New York
$45.00 hourly
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Hiring Now - Work from Home - No Experience

OCPAHarriman, New York, us
$15.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Entry Level Business Analyst

ba system solutionBronx, NY, United States
Full-time

The Business Analyst role will focus on defining/refining business requirements for a project.The role requires to meet with business and technology teams and acts as a bridge between them to assim... Show more

 • Promoted

Senior BI Developer: Health Data that Delivers Outcomes (Remote)

ArbiterNew York City, NY, United States
Remote
Full-time

A healthcare tech company in New York is seeking a Senior Business Intelligence Developer to design and maintain reports and dashboards.Ideal candidates will have over 8 years of experience, strong... Show more

 • Promoted

Data Scientist (Python, SQL, ETL)

Azaaki LLCNew York City, NY, United States
Temporary

Title:Data Scientist (Python, SQL, ETL)Duration:06 monthsLocation:New York, NY 10011 About the RoleJoin the YouTube Business Impact Measurement team to support high-impact data science initiatives ... Show more

 • Promoted

Management Audit and Data Analyst

New York City | JobsBronx, NY, United States
Full-time

Management Audit And Data Analyst.The Bronx District Attorney's Office is seeking a well-qualified staff whose diverse backgrounds reflect an ability to serve the over 1.Bronx County community and ... Show more

 • Promoted

Data Analytic Consultant

InterSourcesNew York City, NY, United States
Temporary

Title: Data Analytic ConsultantLocation: New York, NY 10004Duration: 12 Months Contract PositionRequirementsThe candidate must have a minimum of:5 years of experience in data analytics.Proof of eli... Show more

 • Promoted

Senior Cloud Data Engineer Modeller- REMOTE

PSRTEKNew York City, NY, United States
Remote
Full-time

Cloud Data Engineer with Data Modelling experience Experience:- 8 Years Location:- Remote (EST) Duration:- C2H Roles and Responsibilities Cloud & Data Engineering Design develop and maintain AW... Show more

 • Promoted

Data Entry Product Support - No Experience

GLOCPACroton-on-Hudson, New York
$15.00 hourly
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Sales Data Entry Specialist

Baco Enterprises Inc.Bronx, NY, United States
Full-time

OverviewWe are seeking a detail-oriented and organized Sales Data Entry Specialist to join our team.This role is essential in maintaining supporting data management processes.The ideal candidate wi... Show more

 • Promoted

Database Specialist

TradeJobsWorkForce10705 Yonkers, NY, US
Full-time

Database Specialist Job Duties: Plans database upgrades by maintaining , evaluating, and improving a... Show more

 • Promoted

Data Migration Analyst

RIT SolutionsNew York, NY, United States
Full-time

Data Migration Analyst Remote (East Coast).Our client is seeking a Data Migration Analyst to support a large-scale SAP migration initiative.This role will focus on migrating data between enterprise... Show more

 • Promoted

(Senior) Data Migration Architect (m/w/d)

Natuvion GmbHNew York, NY, United States

Als Data Migration Architect Public Business bernimmst du die technische Konzeptionierung groer SAP Transformations-Projekte fr Flughfen, Krankenhuser, Verbnde, Lnder, Kommunen & Stdte.Du fungierst... Show more

 • Promoted

Program Manager- Data and Analytics - Power BI

Group Nine LLCAllendale, NJ, United States
Full-time

Program Manager- Data and Analytics - Power BI.Location: REMOTE, Travel may be required to Kalamazoo, MI / Allendale, NJ.Strong Communication & Stakeholder Management Required for Power BI Remediat... Show more

 • Promoted

Data Processor Specialist

Benefit Funds OfficeNew York City, NY, United States
Full-time

IATSE National Benefit Funds is an Employee Benefits Fund for the entertainment industry.We are seeking a Processor Specialist with our Contracts and Contributions department.This role will be resp... Show more

 • Promoted

MDM BA (P&C domain)

E-SolutionsJersey City, NJ, United States
Full-time

Location: Iselin, NJ (Remote is ok).MDM, Business Analysis, P&C insurance domain exp is must.Experienced Business Analyst with over a decade of proven success in the Property and Casualty insurance... Show more