Who We Are Ontic makes software that corporate and government security professionals use to proactively manage threats, mitigate risks, and make businesses stronger. Built by security and software professionals, the Ontic Platform connects and unifies critical data, business processes, and collaborators in one place, consolidating security intelligence and operations. We call this Connected Intelligence. Ontic serves corporate security teams across key functions, including intelligence, investigations, GSOC, executive protection, and security operations. Deeply passionate about Ontics brand vision and values: Do Good Above All, Raise the Bar, Leading with Empathy, Walk the Walk and Keep Moving. You are a strategic thinker with a deep technical background who enjoys diving into data challenges and solving complex problems. You have an eye for detail and take pride in ensuring accuracy and precision in every step of the migration process. Your strong communication skills allow you to break down technical concepts for non-technical stakeholders, making you a trusted partner for clients and teams alike. You are also a natural leader, capable of inspiring and guiding your team through complex data migrations. Your hands-on experience with data manipulation, SQL, and field mapping allows you to approach projects with confidence. When faced with obstacles, you bring creativity and determination to find effective solutions, always striving to improve processes and deliver the best outcomes for clients. We are seeking an experienced and detail-oriented Team Lead, Data Migrations to join our team. In this role, you will lead and manage the end-to-end data migration process for our clients. The ideal candidate will have a strong understanding of various data types, data manipulation techniques, field mapping, SQL formats, and best practices for executing successful data migrations in a SaaS software environment.You will work cross-functionally with clients, implementation teams, and technical teams to ensure smooth and accurate transitions of data, minimizing disruptions and ensuring data integrity. Key Responsibilities:
- Lead and manage data migration projects: Oversee the planning, execution, and delivery of data migration activities, ensuring timelines are met and resources are efficiently allocated
- Data mapping and transformation: Ensure accurate field mapping and data transformation between legacy systems and Ontic, aligning with business rules and client needs
- Collaborate cross-functionally: Partner with internal teams such as engineering, implementation, and client success to develop migration strategies
- Data quality assurance: Establish data validation, reconciliation, and quality assurance processes to ensure data accuracy and integrity throughout the migration lifecycle
- SQL and scripting: Use SQL and other tools for data manipulation, querying, and scripting to ensure smooth transitions between systems
- Process improvement: Continuously refine data migration processes, methodologies, and best practices to improve efficiency and reduce risk
- Client communication and support: Act as the point of contact and escalation for clients during the migration process, providing status updates, addressing concerns, and managing expectations
- Team leadership: Lead a team of data migration specialists, providing mentorship, guidance, and oversight of daily activities
Requirements:
- Bachelor's degree in computer science, Information Systems, or related field.5+ years of experience in data migrations, data management, or related fields, preferably in a SaaS environment
- Strong knowledge of various data types, structures, and formats (e.g., SQL, XML, CSV, JSON)
- Experience with SQL for querying and manipulating data during migrations. Familiarity with ETL (Extract, Transform, Load) processes and tools. Experience with data mapping, field transformations, and integration between systems
- Problem-solving mindset with strong analytical skills and attention to detail. Excellent communication skills with the ability to collaborate effectively with both technical and non-technical stakeholders
- Leadership experience with a proven ability to manage and mentor a team
- Strong organizational skills with the ability to manage multiple projects simultaneously
Preferred Qualifications:
- Experience working in the SaaS industry or with cloud-based platforms
- Familiarity with Agile project management methodologies
- Experience with automation in data migration processes
Ontic Benefits & Perks Competitive Salary Medical Benefits Internet Reimbursement Home Office Stipend Continued Education Stipend Festive & Achievement Celebrations Dynamic Office Environment Ontic is an equal opportunity employer. We are committed to a work environment that celebrates diversity. We do not discriminate against any individual based on race, color, sex, national origin, age, religion, marital status, sexual orientation, gender identity, gender expression, military or veteran status, disability, or any factors protected by applicable law.
