Data Organization Intern
About Us
We are a growing wholesale distributor in the pet industry, seeking an organized and detail-oriented intern to help us with a company-wide data cleanup and optimization project. If you are a recent graduate or currently in school and looking for hands-on experience in data management, operations, and process improvement, this internship will offer you valuable exposure to business operations in a fast-paced environment.
What You'll Do
- Database Cleanup:
- Review and correct our customer and product databases, ensuring all information (addresses, contacts, payment terms) is complete and accurate.
- Clean up and organize our sales opportunity and leads database.
- Manage and update data in spreadsheets, ensuring it's formatted properly for re-uploading into our systems.
- Document Organization:
- Assist in organizing and centralizing our company's document repository for easy access and use.
- SOP Review & Migration:
- Audit and reformat existing SOPs in Trainual for clarity and ease of understanding.
- Assist in migrating SOPs to our ERP system, Odoo.
- Collaboration & Improvement:
- Meet with different stakeholders to identify challenges and areas for improvement in data management and documentation processes.
- Gather feedback on existing systems and work with stakeholders to address issues and ensure the new processes meet their needs.
- Develop a project plan outlining tasks, milestones, and timelines for organizing and re-uploading the data.
- Work with various departments to gather missing data, clarify processes, and recommend improvements to data accessibility and workflow.
What We're Looking For
- Recently graduated or currently enrolled in a program in business, operations management, IT, or related fields.
- Fully bilingual in English and French (written and spoken).
- Strong organizational skills and keen attention to detail.
- Excellent proficiency in Excel, including the ability to manage, clean, and re-upload large datasets using spreadsheets (e.g., data analysis, pivot tables, and formula-based tasks).
- Familiarity with Google Workspace (Sheets, Docs), and ERP systems (experience with Odoo is a plus).
- Strong written and verbal communication skills.
- Self-starter with the ability to work independently and take ownership of tasks.
- Bonus: Experience with Trainual, database management, or process documentation.
What We Offer
- Hands-on experience in data management, operations, and process improvement.
- Learning and growth opportunities in various business processes, including data management, ERP systems, and process optimization.
- Mentorship and guidance throughout the internship.
- A full-time, 40-hour-per-week role with the opportunity for growth and valuable work experience.
- A reference or letter of recommendation upon successful completion of the internship.
How to Apply
Please submit your resume and a brief cover letter explaining why you're interested in this internship to d.stopnicki@myfamily.ca. In your cover letter, please include an example of how you've used Excel to manage or organize large datasets, or describe any relevant projects you've worked on.