Data Transfer Engineer

Job Description – Data Transfer Engineer (Lotus Notes to PH Connect Migration)

Job Title: Data Transfer Engineer / Data Migration Engineer

Job Location: Ogden, UT

Role Summary:

The Data Transfer Engineer is responsible for planning, executing, validating, and supporting the migration of business data, documents, workflows, and records from Lotus Notes to PH Connect. The role ensures data integrity, accuracy, security, and business continuity throughout the migration lifecycle while coordinating with business stakeholders, IT teams, and application owners.

Key Responsibilities

Data Migration Planning

• Analyze existing Lotus Notes databases, applications, workflows, and document repositories.
• Define migration strategy, data mapping, and transformation requirements.
• Identify dependencies, risks, and migration constraints.
• Develop migration schedules, cutover plans, and validation procedures.

Data Extraction & Transformation

• Extract structured and unstructured data from Lotus Notes databases.
• Cleanse, standardize, and transform data to meet PH Connect requirements.
• Develop and execute data conversion scripts and migration tools.
• Ensure metadata, attachments, permissions, and relationships are preserved.

Data Loading & Validation

• Load migrated data into PH Connect environments.
• Perform reconciliation and validation checks to ensure data completeness and accuracy.
• Conduct user acceptance testing (UAT) support and defect resolution.
• Verify document accessibility, searchability, and workflow functionality post-migration.

Stakeholder Collaboration

• Work closely with business users, IT teams, administrators, and project managers.
• Gather business requirements and migration acceptance criteria.
• Provide migration status reports, issue logs, and risk assessments.
• Coordinate cutover activities and post-go-live support.

Quality & Compliance

• Ensure compliance with data security, privacy, and governance policies.
• Maintain migration documentation, audit trails, and technical procedures.
• Perform root cause analysis for migration issues and implement corrective actions.
• Support data archiving and retention requirements.

Required Qualifications

• Bachelor's degree in Mechanical, Industrial or related field.
• 3-6 years of experience in data migration, system integration, or application support.
• Experience working with Lotus Notes/Domino databases and applications.
• Knowledge of data migration methodologies and ETL (Extract, Transform, Load) processes.
• Excellent communication and stakeholder management abilities.

Preferred Qualifications

• Experience with PH Connect or similar enterprise collaboration platforms.
• Knowledge of scripting and automation tools (Python, PowerShell, SQL).
• Experience with document management and workflow migration projects.
• Understanding of data governance and information security practices.

Key Skills

• Data Migration
• Lotus Notes Administration
• ETL Processes
• Data Mapping & Transformation
• Data Validation & Reconciliation
• SQL & Database Management
• Workflow Migration
• Root Cause Analysis
• Risk Management
• Stakeholder Communication
• Documentation & Reporting