Note: The job is a remote job and is open to candidates in USA. Ontic is a company that provides software to help security teams identify threats and respond effectively. They are seeking a motivated intern to support their Data Migration team, where the intern will assist with data migration projects and collaborate with various teams to ensure data accuracy and integrity.
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
Skills
- 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
- 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
- REMOTE
Company Overview