Data Migration Analyst – Intern

Ontic

Data Migration Analyst Intern supporting Ontic’s data migration projects for corporate and government security teams. Gain hands-on experience in a technical environment while collaborating with cross-functional teams.

Posted 7/8/2026internshipRemote • 🇺🇸 United StatesEntry Level💰 $20 per hourWebsite

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

Assist with data migration projects by supporting data preparation, validation, testing, and execution activities while helping ensure project milestones are met.
Support data mapping and transformation by validating field mappings between legacy systems and Ontic, identifying discrepancies, and ensuring data aligns with business requirements.
Collaborate with Engineering, Implementation, and Client Success teams to support migration activities, troubleshoot data issues, and learn data migration best practices.
Perform data quality checks, reconciliation, and validation to help maintain data accuracy and integrity throughout the migration process.
Use SQL and other data tools to query, analyze, and manipulate datasets while developing technical skills in data migration and data management.
Document migration processes, testing results, and data findings while contributing ideas to improve workflows and operational efficiency.
Assist with client migration activities by preparing data reports, tracking migration progress, and supporting issue resolution under the guidance of senior team members.

Requirements

What you’ll need

Current undergraduate student (rising junior, or senior preferred), pursuing a degree in Computer Science, Information Systems, or related field
Entry-level knowledge of various data types, structures, and formats (e.g., SQL, XML, CSV, JSON)
Familiarity with SQL for querying and manipulating data during migrations.
Strong attention to detail and organizational skills
Problem-solving mindset with strong analytical skills and attention to detail. Ability to collaborate effectively with both technical and non-technical stakeholders
Strong written and verbal communication skills
Ability to manage repetitive tasks with accuracy and consistency
Experience with SQL through coursework, personal projects, or previous internships.
Familiarity with Microsoft Excel, including formulas, pivot tables, and data analysis.
Exposure to databases, data modeling, or ETL concepts through academic coursework or projects.

Benefits

Comp & perks

Hands-on experience supporting enterprise data migration projects for a leading SaaS platform
Mentorship from experienced Data Migration Analysts
Exposure to the full customer onboarding lifecycle, from data discovery and mapping through migration and validation
Practical experience using SQL and data analysis tools to validate, transform, and troubleshoot customer data
Experience working with enterprise customers and understanding how high-quality data contributes to successful software implementations
Development of technical, analytical, and problem-solving skills in a fast-paced SaaS environment

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLData AnalysisData MappingData TransformationData MigrationData StructuresData FormatsETL ConceptsData ModelingData Reconciliation

Soft Skills

Attention to DetailOrganizational SkillsProblem-Solving MindsetWritten CommunicationVerbal Communication