Data Engineer

About PetVet365 Vet Owned. Vet Led. Vet Loved. We are creating a new way to practice veterinary medicine. Not only with the design of our hospitals and standard of care, but by prioritizing work-life balance so you can live your best life, too. We believe pets should receive the highest standard of care 365 days a year. At PetVet365, we’re creating a future where pets, clients and veterinary professionals leverage creativity, technology, and heart to pave the way to healthier pets and happier clients. We provide every pet a Fear Free® experience while delivering the highest quality of personalized care. To achieve this, we collaborate with our clients for the health of their pet. The veterinary healthcare industry must be disrupted and revitalized to meet the growing needs of clients, pets, and veterinary professionals. Together, we will pave the way to a healthier future for all. How we Live our Brand People First: We must care for ourselves and each other so we can provide the best care for pets and their families. Innovators: We are committed to continuous improvement, early adoption of new ideas and technologies that enhance the human-animal bond. Value Creation: Through service, we create value for clients, pets, and ourselves. Personalized Care: We partner with the family to provide the same individualized care we want for ourselves. Contract Opportunity: Data Support Specialist for Warehouse Creation & System Migration Project PetVet365 is seeking a short-term contractor to create a comprehensive data warehouse, enable critical data initiatives that support business continuity, and maintain high-quality reporting during a major system migration. We are in the process of transitioning our core Practice Information Management System (PIMS)—which supports patient care and daily hospital operations—due to our current vendor sunsetting their platform. This project involves migrating 30 existing hospitals to a new PIMS vendor. Key Details: Duration: Short-term contract (May to July, with the opportunity for extension) Time Commitment: 5–20 hours per week (flexible based on project phase) Primary Focus: Data warehouse completion, data integrity, operational reporting to support continuity, and support throughout the vendor migration process This is a great opportunity to contribute to a high-impact initiative that ensures operational stability across our veterinary network. Primary Responsibilities Data migration support Collaborate with internal teams and external vendors to support migration of data from the current PIMS to the new PIMS Validate and clean data during migration, as appropriate Document data mappings, logic for transformation, and QA checks on migrated data Data warehouse completion and scaling Assess current state of the data warehouse and fill in gaps to ensure full coverage of PIMS data Build or refine data pipelines via APIs or manual uploads fur current and new system Ensure warehouse if flexible enough to support both legacy and new systems during and after staged migration period Reporting & analytics support Assist in creating or updating reports/dashboards that span both systems Ensure metrics and KPIs remain consistent and meaningful through the transition Supplemental support of ad hoc data analysis needs for internal stakeholders Deliverables Updated and operational data warehouse supporting both old and new systems API/data load connections from PIMS, with additional systems as a value add Documentation for data pipelines and mappings Interim reporting solutions that accurately depict company performance across platforms Weekly status updates Minimum Qualifications Proven experience in data integration, ETL/ELT pipelines, and data warehousing Strong working knowledge of AWS Experience with GraphQL and REST APIs for data extraction and integration Ability to work with structured and semi-structured data Comfortable operating in a partially-defined environment with evolving needs Strong communication and organizational skills to coordinate with technical and non-technical stakeholders Experience with BI/reporting tools (e.g. Looker, Tableau, Power BI) is a plus Physical Requirements Prolonged periods of sitting at a desk and working on a computer. Ability to communicate effectively with others online or telephonically.