Data Migration Engineer

Who We Are:Shepherd is the fastest-growing veterinary practice management software in the U.S. We're on a mission to simplify running a veterinary practice, empowering vets and their teams so that they can rekindle their joy of practicing veterinary medicine. Our success story is a testament to a powerful combination: a stellar product, exceptional people, and an unwavering commitment to our unique culture.Position:Data Migration Engineer for the world’s greatest veterinary Practice Management Solution (Shepherd).Your Mission:Leverage diverse technologies to design, build, maintain, and continuously improve a best-in-class end-to-end data migration pipeline for veterinary Practice Management Information Systems. This role will support the extraction, transformation, validation, and import of complex customer data from a variety of legacy and modern systems into Shepherd’s platform.What you will do:Strong experience with SQL, relational data analysis, and common database systemsExperience with Java and/or Python, plus familiarity with Git, testing practices, and deployment workflowsFamiliarity with ETL processes, best practices, and data integration platforms (ex. CloverDX, Flatfile) or similar toolsExperience working with REST APIs, OAuth2/token-based authentication, flat files, database exports, backups, and on-premises data sourcesAdvanced understanding of data transformation, normalization, schema mapping, validation, secure data handling, and technical troubleshootingWhat we are looking for:Design, build, and maintain scalable ETL workflows for migrating veterinary practice data into Shepherd’s platformExtract, transform, normalize, and map data from diverse source systems into standardized target data modelsBuild validation, reconciliation, error-handling, retry, and QA processes to ensure migration accuracy and reliabilityTroubleshoot pipeline failures, source-specific issues, and project-level blockers while supporting internal end-usersCreate and maintain documentation covering tool usage, source-system scope and limitations, known omissions, process changes, and evolving best practicesWhat we offer you:Competitive salary and benefitsA multifaceted job with a high degree of responsibility, autonomy, and opportunity.A modern work environment with a dedicated and motivated teamA work environment built on collaboration, flexibility, and respect