Data Migration Specialist

Data EngineerData EngineerFull TimeRemoteMid LevelTeam 11-50

Location

United States

Posted

1 day ago

Salary

$135K - $145K / year

Seniority

Mid Level

SQLPythonETLTalendInformaticaSSISSQL ServerOracleMySQLPostgreSQLPowerShellData MigrationData MappingData QualityData Governance

Job Description

Benefits:
  • 401(k) matching
  • Competitive salary
  • Health insurance
  • Paid time off
About this Role: 

Imagineeer is seeking an experienced Data Architect / Data Analyst to support our client, the Department of Health and Human Services (DHHS), Office of the Chief Information Officer (OCIO) in migrating their core HR IT functions into OPM’s new HR 2.0 government-wide federated HR IT platform. The yet-to-be-announced platform will encompass Time and Attendance, Position Description management, Performance Management, Employee/Manager/HR Self-Service, and an Enterprise Business Intelligence capability.  The solution will be compliant with federal cybersecurity, records management, and accessibility standards, to improve system performance, user satisfaction, and long-term sustainability of HR services.  This role is critical for assisting HHS in the consolidation and migration of their existing data into the new platform and optimizing HCM applications and processes that support essential administrative and operational functions across the department. The ideal candidate combines strong technical development skills with an understanding of federal government systems and requirements. This position requires the ability to obtain and maintain a Public Trust clearance. 

 

Key Responsibilities: 

  • Assess and inventory existing legacy data in application data stores, shared folders and shared drives. 
  • Assess the quality, completeness, and relevance of data to be migrated. 
  • Identify and document data dependencies, redundancies, and inconsistencies. 
  • Collaborate with stakeholders to understand data structures, relationships, and required formats for successful migration. 
  • Develop a comprehensive data migration plan that outlines steps, timelines, and resource requirements for the migration process. 
  • Identify potential challenges and propose solutions to mitigate risks associated with data migration. 
  • Interpret legacy APIs and other system integrations, and define mapping between systems 
  • Plan for thorough testing of the migrated data to ensure accuracy, completeness, and successful integration. 
  • Recommend validation reports and the process to document any discrepancies and work closely with stakeholders to resolve issues. 
  • Collaborate with software engineers, database administrators, and development teams to ensure compatibility and alignment with the overall architecture. 
  • Maintain effective communication with project stakeholders to provide updates on migration planning progress and gather feedback. 
  • Create and maintain technical documentation related to planned data migration processes, procedures, and system configurations. 
  • Specify reports on migration progress, data quality metrics, and issue resolution. 
 

Qualifications and Skills: 

  • Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field. 
  • Previous experience as a Database Engineer and proven experience in data migration, particularly with legacy systems and cloud environments. 
  • Proficiency in data migration tools and ETL processes (e.g., Talend, Informatica, SSIS, or similar). 
  • Strong knowledge of database management systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL). 
  • Experience with scripting languages (e.g., Python, Perl, SQL, PowerShell) for data transformation and automation. 
  • Familiarity with indexing and data accessibility in software applications. 
 

 

Desired Skills and Competencies: 

  • Experience with federal HRIT systems is a huge plus, particularly USA Staffing, USA Performance, DFAS, ITAS, HHS LMS, EHCM, ServiceNow for HR case management. 
  • Experience with federal agency data governance best practices, data quality standards, and compliance measures. 
  • Strong analytical and problem-solving skills, with attention to detail. 
  • Experience with large federal agency data migration planning and execution. 
 

Equal Opportunity Employer: 

We are an Equal Opportunity Employer and do not discriminate in employment decisions on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other status protected by applicable federal, state, or local laws. All employment decisions are based on business needs, job requirements, and individual qualifications. 

This is a remote position.

Job Requirements

  • Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
  • Previous experience as a Database Engineer and proven experience in data migration, particularly with legacy systems and cloud environments.
  • Proficiency in data migration tools and ETL processes (e.g., Talend, Informatica, SSIS, or similar).
  • Strong knowledge of database management systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL).
  • Experience with scripting languages (e.g., Python, Perl, SQL, PowerShell) for data transformation and automation.
  • Familiarity with indexing and data accessibility in software applications.
  • Desired Skills and Competencies
  • Experience with federal HRIT systems is a huge plus, particularly USA Staffing, USA Performance, DFAS, ITAS, HHS LMS, EHCM, ServiceNow for HR case management.
  • Experience with federal agency data governance best practices, data quality standards, and compliance measures.
  • Strong analytical and problem-solving skills, with attention to detail.
  • Experience with large federal agency data migration planning and execution.

Benefits

  • 401(k) matching
  • Competitive salary
  • Health insurance
  • Paid time off
  • Equal Opportunity Employer
  • We are an Equal Opportunity Employer and do not discriminate in employment decisions on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other status protected by applicable federal, state, or local laws. All employment decisions are based on business needs, job requirements, and individual qualifications.
  • This is a remote position.

Related Categories

Related Job Pages

More Data Engineer Jobs

Cushman & Wakefield logo

Data Integrations Lead

Cushman & Wakefield

We will never settle for the world that’s been built, but relentlessly drive it forward. #BetterNeverSettles

Data Engineer1 day ago
Full TimeRemoteTeam 10,001+Since 1917H1B No Sponsor

This role involves being the primary custodian of data platform standards, integration patterns, and engineering best practices, translating high-level strategy into actionable North Star definitions for data engineering teams. The individual will define and enforce standards across ingestion, integration, lakehouse design, and AI/ML enablement while mentoring other engineers.

United States
$103K - $122K / year
Capital One logo

Senior Distinguished Data Engineer

Capital One

At Capital One, we think and work like a tech company, using our digital fluency to transform everything about the customer experience. We’re bending data to our will, and turning a stodgy industry on its head. That’s reflected in our ranking as the number one business technology innovator in the U.S. in the 2016 InformationWeek Elite 100.

Data Engineer1 day ago
Full TimeRemoteTeam 10,001+Since 1994H1B Sponsor

Senior Distinguished Data Engineer driving technology solutions at Capital One

AWSPythonScalaSQL
New York + 1 moreAll locations: New York, Virginia
$286.2K - $392K / year
Zocdoc logo

Staff Software Engineer, Data

Zocdoc

Zocdoc is the beginning of a better healthcare experience for millions of patients every month.

Data Engineer1 day ago
Full TimeRemoteTeam 501-1,000Since 2007H1B Sponsor

The Staff Software Engineer will design, build, and optimize scalable data systems, focusing on leading the Data Infrastructure group to maintain platforms powering analytics, experimentation, and machine learning workflows. Responsibilities include designing data pipelines, curating datasets via data contracts, and managing modern data architectures like lakehouses.

PythonSQLSnowflakeDatabricksDelta LakeApache IcebergdbtDagsterAWSETL
United States
$211K - $285K / year
Data Engineer1 day ago
Full TimeRemoteTeam 201-500Since 1986

Enterprise Data Architect leading modernization program for healthcare data ecosystem

AzureCloudETLSQL
Washington
$150K - $175K / year