Senior Data Migration / Data Purging Lead

About the role

We are seeking an experienced Senior Data Migration & Purging Lead to guide and execute the technical separation, archiving, and migration of critical R&D applications. In this pivotal role, you will work closely with enterprise application owners, R&D engineering SMEs, and database teams to establish data inventories, define retention and purge rules, and lead seamless data transitions. Your expertise will safeguard system integrity, maintain strict data governance, and ensure operational continuity across our technology ecosystem.

Responsibilities

• Lead data discovery and profiling initiatives across databases, file repositories, and interfaces to identify migration, archival, and purging requirements.
• Translate complex business purge and retention policies into executable technical rules, filters, and SQL scripts.
• Analyze complex parent/child data relationships and referential integrity to prevent data loss or corruption during migration.
• Design, build, and execute robust ETL/ELT processes, stored procedures, APIs, and custom migration utilities.
• Establish comprehensive pre- and post-purge validation, control totals, and data reconciliation frameworks.
• Oversee end-to-end migration execution, mock cutovers, SIT/UAT support, and post-go-live hypercare troubleshooting.

Qualifications

Required Qualifications:

• 12-15 years of enterprise experience in data migration, ETL engineering, database development, and data conversion.
• Proven track record leading data workstreams for large-scale application separations, carve-outs, or divestitures.
• High proficiency in SQL and relational database environments (e.g., SQL Server, Oracle, PostgreSQL).
• Demonstrated experience handling complex data models, referential integrity constraints, and parent/child object dependencies.
• Solid experience designing and executing data validation frameworks, control totals, and reconciliation workflows.

Preferred Qualifications:

• Experience managing both structured database migrations and unstructured document/file repositories.
• Hands-on experience developing specialized data purging tools and automated archival scripts.
• Strong communication skills with a history of translating technical progress and risk metrics to executive stakeholders.

Skills

• APIs
• data cleansing
• Data Conversion
• data discovery
• referential integrity
• data integrity
• data loss
• data migration
• data extraction
• data profiling
• data retention
• Database Development
• databases
• database
• enterprise application
• ETL
• Data Engineering
• SQL Server
• Oracle
• PostgreSQL
• relational database
• relational data models
• SQL scripts
• SQL
• stored procedures
• leadership
• methodical approach
• UAT testing
• live production
• business strategy
• assessments
• carve-out
• advisory
• data quality
• divestitures
• archival
• purging
• executive reporting
• R&D
• risks
• root-cause analysis
• exception handling
• inventories
• system integrity
• traceability

Benefits

• medical
• prescription
• dental
• vision
• AD&D
• life insurance offerings
• short-term disability
• 401K plan

Pay

$80 - 85 per hour

Schedule

8am to 5pm