[Remote] Data Migration Engineer
Note: The job is a remote job and is open to candidates in USA. Shepherd Veterinary Solutions is a fast-growing provider of veterinary practice management software focused on simplifying the operation of veterinary practices. The Data Migration Engineer will design, build, and improve end-to-end data migration pipelines, extracting, transforming, validating, and importing complex customer data from legacy and modern systems into Shepherd’s platform.
Responsibilities
- Design, build, and maintain scalable ETL workflows for migrating veterinary practice data into Shepherd’s platform
- Extract, transform, normalize, and map data from diverse source systems into standardized target data models
- Build validation, reconciliation, error-handling, retry, and QA processes to ensure migration accuracy and reliability
- Troubleshoot pipeline failures, source-specific issues, and project-level blockers while supporting internal end-users
- Create and maintain documentation covering tool usage, source-system scope and limitations, known omissions, process changes, and evolving best practices
Skills
- Strong experience with SQL, relational data analysis, and common database systems
- Experience with Java and/or Python, plus familiarity with Git, testing practices, and deployment workflows
- Familiarity with ETL processes, best practices, and data integration platforms (ex. CloverDX, Flatfile) or similar tools
- Experience working with REST APIs, OAuth2/token-based authentication, flat files, database exports, backups, and on-premises data sources
- Advanced understanding of data transformation, normalization, schema mapping, validation, secure data handling, and technical troubleshooting
Benefits
- A multifaceted job with a high degree of responsibility, autonomy, and opportunity.
- A modern work environment with a dedicated and motivated team
- A work environment built on collaboration, flexibility, and respect
Company Overview