ETL Specialist

Description We are seeking an ETL Specialist who will play a key role in ensuring the secure, accurate, and efficient transfer of digital files from various veterinary Practice Information Management Systems (PIMS) to business partners. This role requires strong technical skills, a structured and detail-oriented approach, and the ability to work effectively across multiple file sources, tools, and environments.Success in this role means consistently delivering complete and high-quality attachment sets, maintaining efficient and standardized workflows, identifying data issues proactively, and collaborating closely with cross-functional teams. This is a full-time, remote position ideal for someone who thrives in technical environments and enjoys problem-solving.ResponsibilitiesCollect, extract, and migrate attachment files referenced within veterinary PIMS systems.Retrieve files from various sources, including on-premises PIMS servers, email-delivered download links, and internal applications.Perform file conversions, naming normalization, and file-type modifications as needed.Validate file integrity, identify missing or inaccessible files, and communicate limitations to relevant stakeholders.Use scripting tools (PowerShell or Python) to build or modify custom automation workflows.Apply ELT (Extract, Load, Transform) concepts to streamline file handling and transformation processes.Execute secure file transfers using SFTP, HTTPS, and token-based authentication.Utilize cloud storage platforms, remote-access utilities, and data-management tools to retrieve and deliver files.RequerimentsExperience working with Windows and macOS environments.Proficiency in PowerShell and/or Python for scripting and automation.Understanding of ELT concepts and their practical application.Experience with cloud services such as:Microsoft AzureMicrosoft Storage ExplorerAmazon S3Familiarity with remote-access and data transfer tools including TeamViewer, AnyDesk, Cloudberry, FileZilla, AzCopy, and Remote Desktop.Proficiency with productivity and communication tools: Microsoft Teams, Office, Outlook, Jira.Familiarity with database browsing tools such as DBeaver.Basic understanding of secure data transfer protocols.Nice to HavePrevious experience in veterinary PIMS data handling or data migration.Experience with file-based extraction from legacy systems.Exposure to cloud-based storage workflows or enterprise data migration pipelines.Familiarity with generative AI tools for documentation, automation, or workflow enhancement.Experience working in fast-paced or mid-sized technical environments.What We OfferCompetitive compensation and benefits package.Opportunities for growth and professional development/continuous learning.Flexible work arrangements.Comprehensive leave policies, including PTO & holidays.Monthly connectivity allowance.About Us: At Nybble Group, we are dedicated to transforming businesses with the power of technology. For over 20 years, we have helped clients optimize operations and increase productivity through process automation, smart document processing, and advanced data analytics. We believe in fostering a collaborative and innovative culture where every team member can thrive.