Data Migration SME

About the Role

We are seeking a highly talented, experienced Data Migration Engineer to facilitate the migration of external data into a new key Government repository. This role will focus on transferring legacy data from shared folders and shared drives to AWS S3 buckets. The successful candidate will ensure that this data is properly indexed and accessible, enhancing the platform's overall functionality and user experience. This role is designed for those who seek to make an impact in a high-tech environment, leading the way in innovation and excellence.

This role requires a TS/SCI Clearance with CI polygraph, is full-time, and may require up to 10% local travel.

Responsibilities

• Assess and inventory existing legacy data in 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.
• Migrate legacy data to AWS S3 buckets, ensuring data integrity and security throughout the process.
• Implement indexing strategies for the migrated data, enabling seamless access and retrieval.
• Conduct thorough testing of the migrated data to ensure accuracy, completeness, and successful integration.
• Create validation reports and document any discrepancies, working 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 progress and gather feedback.
• Create and maintain technical documentation related to data migration processes, procedures, and system configurations.
• Generate reports on migration progress, data quality metrics, and issue resolution.
• Provide user guides and training materials to assist end-users with accessing and utilizing the newly migrated data.

Qualifications

• 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, SQL, PowerShell) for data transformation and automation.
• Strong knowledge of AWS, specifically S3, and experience with data storage and retrieval solutions.
• Familiarity with indexing and data accessibility in software applications.
• U.S. Citizen with active TS/SCI clearance (with CI Polygraph).

Desired Skills

• Experience with data governance best practices, data quality standards, and compliance measures.
• Proficiency in scripting languages (e.g., Python, Bash) for data manipulation and automation.
• Strong analytical and problem-solving skills, with an attention to detail.

Benefits

• A culture of integrity, placing character and innovation at the center of everything we do.
• An environment of trust, valuing unique contributions and offering autonomy through flexible time off and robust learning resources.
• A focus on continuous growth, with opportunities to advance your career and contribute to our nation’s critical missions.
• Comprehensive benefits including healthcare, wellness, financial, retirement, family support, continuing education, and time off.

Pay

The proposed salary range for this position is $90,300–$189,600. Final salary will be influenced by factors such as geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education, and certifications.