Data Migration Specialist

Koniag Professional Services LLC, a Koniag Government Services company, is seeking a Data Migration Specialist to support KPS and our government customer. This position requires the candidate to be able to obtain a Public Trust. This is a remote opportunity.

We offer competitive compensation and an extraordinary benefits package including health, dental and vision insurance, 401K with company matching, flexible spending accounts, paid holidays, three weeks paid time off, and more.

Koniag Professional Services is seeking an experienced Data Migration Specialist to support our client, the Department of Health and Human Services (DHHS), Office of the Chief Information Officer (OCIO) in sustaining an integrated Human Capital Management solution that consolidates core HR functions into a unified enterprise platform. The Human Resource Information Technology platform will encompass Time and Attendance, Position Description management, Performance Management, Employee/Manager/HR Self-Service, and 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 securing and optimizing HCM applications that support essential administrative and operational functions across the department.

Essential Functions, Responsibilities & Duties may include, but are not limited to:

The Data Migration Specialist will be responsible for planning, executing, and validating data migration activities as part of system implementation, upgrade, and modernization projects. The position involves collaboration with stakeholders, technical teams, and subject matter experts to ensure data is accurately and securely transferred between systems. Principal responsibilities include:

• Design and execute end-to-end data migration strategies tailored to HRIT modules (e.g., Core HR, Payroll, Talent Management, Benefits, Time & Attendance, Position Description Repository, & Employee, Manager, HR Self Service capabilities), ensuring alignment with functional requirements, compliance standards, and overall project goals.
• Design, develop, and execute ETL processes to extract data from source systems and load into target systems
• Create and implement data mapping specifications between source and target systems
• Develop data cleansing and transformation rules to ensure data quality during migration
• Perform data profiling and analysis to identify data quality issues and inconsistencies
• Create and execute data validation procedures to verify migration accuracy and completeness
• Develop scripts and programs to automate data extraction, transformation, and loading processes
• Implement data reconciliation processes to ensure successful migration of all required data
• Document data migration procedures, mappings, and technical specifications
• Collaborate with database administrators and system architects to understand data structures and relationships
• Identify and mitigate risks associated with data migration activities
• Create and maintain test plans and test cases specific to data migration validation
• Work with stakeholders to establish migration timelines, cutover plans, and rollback procedures
• Provide regular status updates on migration activities and escalate issues as appropriate
• Support post-migration activities including troubleshooting and data reconciliation

Education and Experience:Required:

• Bachelor's degree in Computer Science, Information Systems, or related field
• 5+ years of experience in data migration, ETL development, or related roles
• Demonstrated experience leading end-to-end data migration projects
• Strong experience with ETL tools and technologies
• Proficiency with SQL and database technologies

Required Skills and Competencies:

• Extensive knowledge of data migration methodologies and best practices
• Strong expertise in ETL processes, tools, and techniques
• Proficiency in SQL and experience with multiple database platforms (Oracle, SQL Server, PostgreSQL, etc.)
• Experience with ETL tools (Informatica, SSIS, Talend, or similar)
• Strong analytical skills with ability to understand complex data structures and relationships
• Experience developing data mapping specifications and transformation rules
• Knowledge of data quality assessment and improvement techniques
• Strong problem-solving abilities for addressing data migration challenges
• Experience with data profiling and analysis tools
• Understanding of database design principles and data modeling
• Experience with scripting languages for data processing (Python, PowerShell, etc.)
• Strong attention to detail and commitment to data accuracy
• Excellent documentation skills for technical specifications and procedures
• Ability to work effectively under pressure and meet migration deadlines
• Strong communication skills for coordinating with stakeholders and technical teams

Desired Skills and Competencies:

• Experience with data migration for federal government systems
• Experience with cloud data migration (AWS, Azure, GCP)
• Knowledge of data governance principles and practices
• Experience with master data management concepts and tools
• Familiarity with data privacy regulations and secure data handling practices
• Experience migrating data to/from ERP or CRM systems
• Knowledge of big data technologies and platforms
• Experience with data archiving and purging strategies
• Familiarity with Agile project management methodologies
• Knowledge of legacy system data extraction techniques
• Experience with data conversion between different file formats
• Understanding of data lineage tracking and documentation
• Experience with real-time data migration or synchronization
• Certifications relevant to data management or specific technologies

Security Requirement:

• Ability to maintain a Public Trust

Our Equal Employment Opportunity Policy

The company is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race, color, religion, creed, ethnicity, sex, sexual orientation, gender or gender identity (except where gender is a bona fide occupational qualification), national origin or ancestry, age, disability, citizenship, military/veteran status, marital status, genetic information or any other characteristic protected by applicable federal, state, or local law. We are committed to equal employment opportunity in all decisions related to employment, promotion, wages, benefits, and all other privileges, terms, and conditions of employment.

The company is dedicated to seeking all qualified applicants. If you require an accommodation to navigate or apply for a position on our website, please get in touch with Heaven Wood via e-mail at - or by calling to request accommodations.

Koniag Government Services (KGS) is an Alaska Native Owned corporation supporting the values and traditions of our native communities through an agile employee and corporate culture that delivers Enterprise Solutions, Professional Services and Operational Management to Federal Government Agencies. As a wholly owned subsidiary of Koniag, we apply our proven commercial solutions to a deep knowledge of Defense and Civilian missions to provide forward leaning technical, professional, and operational solutions. KGS enables successful mission outcomes for our customers through solution-oriented business partnerships and a commitment to exceptional service delivery. We ensure long-term success with a continuous improvement approach while balancing the collective interests of our customers, employees, and native communities. For more information, please visit

Equal Opportunity Employer/Veterans/Disabled. Shareholder Preference in accordance with Public Law 88-352