Data Migration Analyst (Contract)

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 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.co or follow us on LinkedIn.

Who You Are

In this role, you will lead and manage the end-to-end data migration process for Ontic’s 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 while ensuring timelines are also met.

• 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: As needed, act as the point of contact and escalation for clients during the migration process, providing status updates, addressing concerns, and managing expectations

Requirements

• Bachelor's degree in computer science, Information Systems, or related field

• 2+ 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

• Client experience with a proven ability to manage client expectations and build relationships

• 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

This will be a contract position, taking about approximately 30 hours per week

Ontic does not provide sponsorship for employment visas or work authorization for this role. Applicants must be legally authorized to work in the US without requiring sponsorship, now or in the future

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.

All Ontic employees are expected to understand and adhere to all Ontic Security and Privacy related policies in order to protect Ontic data and our clients data

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 [email protected] or call (512) 572-7400