Data Migration Engineer

Shepherd Veterinary Solutions; United States; On-site; USD 100,000 - 140,000; Full time

Job summary

Shepherd Veterinary Solutions is seeking a Data Migration Engineer to design, build, and optimize end-to-end ETL pipelines for migrating veterinary practice data into Shepherd's platform.

You will extract, transform, and map data from diverse source systems, ensuring data quality through validation, QA, and robust error handling. Collaboration with teams and documentation of processes are key aspects of the role.

Qualifications

• Experience designing scalable ETL workflows for migrating practice data.
• Ability to extract, transform, normalize, and map data from diverse sources.
• Experience with data validation, reconciliation, and QA processes.
• Troubleshooting pipelines and source-specific issues.

Responsibilities

• Design, build, and maintain end-to-end data migration pipelines.
• Migrate data from legacy and modern systems into Shepherd's platform.
• Develop validation, retry, and QA processes to ensure accuracy.
• Troubleshoot failures and support internal end users.
• Create docs on tool usage, data scopes, and best practices.

Skills

SQL

Relational data analysis

Java

Python

Git

Testing practices

Deployment workflows

REST APIs

OAuth2

ETL

Data transformation

Data normalization

Schema mapping

Data validation

Secure data handling

Troubleshooting

Tools

CloverDX

Flatfile

Job description

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 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

What we are looking for:

• 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

What we offer you:

• Competitive salary and 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