Data Migration Engineer II

Archer; United States; On-site; USD 35,000 - 88,000; Full time

Benefits offered by this job

Medical insurance

401(k) matching

Paid time off

Dental insurance

Job summary

Archer, collaborating with Oracle, seeks a Data Migration Engineer II to design, build, and execute data migration solutions for Oracle Health implementations. You will analyze requirements, map data, and ensure successful healthcare data migration with strong technical and communication skills.

The role requires US citizenship for client contracts and the ability to obtain government security clearance. Travel up to 10% may be needed, with the flexibility to work additional hours as needed.

Qualifications

• 2+ years of experience in a technical role (data migration, system migration, ETL)
• 2+ years of experience in multi-dimensional issue resolution
• A BS in computer science or related field
• Proficiency in SQL and Linux back-end command experience
• Highly organized with the ability to manage multiple projects simultaneously
• Self-starter capable of independently handling tasks and projects
• U.S. citizenship required due to client contracts
• Must be able to obtain the appropriate government security clearance card applicable to your position

Responsibilities

• Design, build, and execute data migration solutions to support Oracle Health implementation and interface activities.
• Develop and manage data migration plans, including data extraction, transformation, normalization, validation, and loading processes.
• Create and maintain data normalization workbooks and oversee completion by clients and project teams.
• Analyze complex business and data requirements and translate them into migration specifications and technical solutions.
• Establish and document data mapping rules, conversion logic, and acceptance testing criteria that support business processes.
• Perform data migration testing, validation, reconciliation, and quality assurance activities to ensure data accuracy and completeness.
• Provide Tier 2 troubleshooting and issue resolution for migration builds, uploads, and production support activities.
• Manage migration-related changes, risks, issues, and project activities while communicating status and impacts to stakeholders.
• Collaborate with implementation consultants, technical teams, and client representatives to ensure successful project delivery.
• Support continuous improvement efforts by identifying opportunities to enhance migration processes, tools, and methodologies.
• Ensure compliance with organizational policies, procedures, data governance standards, and security requirements.

Skills

2+ years technical experience

2+ years multi-dimensional issue res.

Self-starter

Strong communication

Education

BS in computer science or related field

Tools

SQL

Linux

Job description

Archer is collaborating with Oracle to connect them with exceptional professionals for this role.

About The Team

A Data Migration Engineer II is generally a hands-on technical consultant responsible for extracting, transforming, validating, and loading healthcare data from legacy systems into Oracle Health platforms. Due to the nature of the federal customer only US Citizens can be considered.

Description

The Data Migration Engineer II is responsible for designing, building, testing, and executing data migration solutions that support Oracle Health implementation and interface projects.

As part of the Data Management and Migration Delivery Team, this role works with clients and internal stakeholders to analyze business requirements, map and normalize data, establish acceptance testing criteria, and ensure successful migration of healthcare data into Oracle Health solutions. The position requires strong technical, analytical, and communication skills to deliver high-quality projects on time, within budget, and to customer satisfaction.

Qualifications

• 2 + years of experience in a technical role, (data migration, system migration, ETL engagement).
• 2 + years of experience in multi-dimensional issue resolution.
• A BS in computer science or related field.
• Proficiency in SQL and Linux back-end command experience.
• Highly organized with the ability to manage multiple projects simultaneously.
• Self-starter capable of independently handling tasks and projects.
• U.S. citizenship required due to client contracts.
• Must be able to obtain the appropriate government security clearance card applicable to your position.

Preferred Qualifications

• Experience in Python, C# CCL.
• Experience in workflow documentation.
• At least 2+ years of experience working on Data Migration or Interoperability FHIR/HL7
• At least 2+ years of experience and a solid understanding of database technologies
• Experience in Electronic Medical Record workflow documentation.
• Strong presentation skills to effectively communicate complex information to clients and stakeholders.
• Due to specific client contract requirements, this position requires that the successful candidate be a U.S. citizen. The client contract also requires receipt of the appropriate government security clearance card applicable for the position

Expectations

• Perform other responsibilities as assigned.
• Willing to travel up to 10% as needed.
• Willing to work additional or irregular hours as needed and allowed by local regulations.
• Work in accordance with corporate and organizational security policies and procedures, understand personal role in safeguarding corporate and client assets, and take appropriate action to prevent and report any compromises of security within scope of position. Willing to work additional or irregular hours as needed and allowed by local regulations.

Responsibilities

• Design, build, and execute data migration solutions to support Oracle Health implementation and interface activities.
• Develop and manage data migration plans, including data extraction, transformation, normalization, validation, and loading processes.
• Create and maintain data normalization workbooks and oversee completion by clients and project teams.
• Analyze complex business and data requirements and translate them into migration specifications and technical solutions.
• Establish and document data mapping rules, conversion logic, and acceptance testing criteria that support business processes.
• Perform data migration testing, validation, reconciliation, and quality assurance activities to ensure data accuracy and completeness.
• Provide Tier 2 troubleshooting and issue resolution for migration builds, uploads, and production support activities.
• Manage migration-related changes, risks, issues, and project activities while communicating status and impacts to stakeholders.
• Collaborate with implementation consultants, technical teams, and client representatives to ensure successful project delivery.
• Support continuous improvement efforts by identifying opportunities to enhance migration processes, tools, and methodologies.
• Ensure compliance with organizational policies, procedures, data governance standards, and security requirements.

Qualifications

Disclaimer: Certain U.S. based or U.S. customer or client-facing roles may be required to comply with applicable requirements, such as immunization/occupational health mandates, and/or drug testing requirements.

Range and benefit information provided in this posting are specific to the stated locations only

US: Hiring Range in USD from $25.48 to $63.65 per hour; from: $53,000 to $132,400 per annum. May be eligible for bonus and equity.

Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.

Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following:

• Medical, dental, and vision insurance, including expert medical opinion
• Short term disability and long term disability
• Life insurance and AD&D
• Supplemental life insurance (Employee/Spouse/Child)
• Health care and dependent care Flexible Spending Accounts
• Pre-tax commuter and parking benefits
• 401(k) Savings and Investment Plan with company match
• Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
• 11 paid holidays
• Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
• Paid parental leave
• Adoption assistance
• Employee Stock Purchase Plan
• Financial planning and group legal
• Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.

Career Level - IC2