Data Migration Analyst - Intern

Who We Are

Ontic provides software that helps corporate and government security teams identify threats, assess risk, and respond faster to keep people and organizations safe. Its AI-powered Connected Intelligence Platform unifies security operations and data into a centralized system of record, enabling organizations to conduct risk assessments, protect against workplace violence, and manage threats and incidents more efficiently. Fortune 500 companies and federal agencies rely on Ontic to support security programs such as executive protection, threat intelligence, and corporate investigations. Learn more at ontic.ai or follow us on LinkedIn.

Who You Are

We’re seeking a motivated and detail-oriented intern to support our Data Migration team. This is an excellent opportunity for a student or early-career professional to gain hands-on experience in a real-world technical environment.

Key Responsibilities

• 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

• 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

Preferred Qualifications

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

What You’ll Gain

• 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

Don’t meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Ontic we are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

Ontic prioritizes the full inclusion of qualified individuals, providing necessary accommodations for those with disabilities to perform essential job functions. If you need assistance during the application or interview process or job tasks, please contact us at recruitment@ontic.co or call (512) 572-7400