Data Migration SME

CACI International; Charlottesville (VA); On-site; USD 90,000 - 190,000; Full time

Job summary

Data Migration SME role at CACI International focuses on migrating legacy data into a new government repository and indexing for accessible retrieval. You will migrate data to AWS S3, ensure data quality, and validate integrity in a high-security environment requiring TS/SCI with CI polygraph.

The position emphasizes collaboration with engineers, DBAs, and stakeholders to deliver a robust data migration solution with thorough documentation and training materials.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• Experience as a Database Engineer with data migration, especially from legacy systems to cloud.
• Proficiency with ETL tools and data migration processes.
• Strong knowledge of DBMS (SQL Server, Oracle, MySQL, PostgreSQL) and scripting for automation.
• Experience with AWS S3 and data indexing for accessible data storage.

Responsibilities

• Assess existing legacy data and inventory data sources and quality for migration.
• Develop a comprehensive migration plan with timelines and resource needs.
• Migrate data to AWS S3 with integrity and security.
• Implement indexing to enable fast access and retrieval of migrated data.
• Create validation reports and resolve data discrepancies with stakeholders.
• Collaborate with software engineers and DBAs to ensure architecture alignment.
• Document data migration processes and generate progress/quality reports.
• Provide user guides and training materials for accessing migrated data.

Skills

Data migration

AWS S3

Python

SQL

PowerShell

Education

Bachelor’s degree in Computer Science, Information Technology, Data Science, or related field

Tools

ETL tools (Talend, Informatica, SSIS)

SQL Server

Oracle

MySQL / PostgreSQL

Job description

Job Title: Data Migration SME

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: TS/SCI with Polygraph

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Local

* * *

The Opportunity

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. The role is considered a position requiring a TS/SCI Clearance with CI polygraph.

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

Required

• 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

• 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.

What You Can Expect

A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation’s most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.

Pay Range :

There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$90,300-$189,600

CACI is anEqualOpportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any otherprotectedcharacteristic.