Business Intelligence Intern

The Wellness Pet Company is on a mission to help the next generation of pet parents fulfill a shared life of wellbeing with their pets through a foundation of proven nutrition. We are committed to crafting high-quality pet food, dental chews, treats, and topper recipes that are made with the perfect balance of high-quality natural ingredients paired with the latest scientific research and technologies. As a community of people working together, Wellies are positively obsessed with how to deliver proven health outcomes that pet parents can see and pets can taste. Wellies bring their best to work every day, come ready to collaborate, embrace the hard things, and own their outcomes.

Our Team is based out of our office in Burlington, Massachusetts, where we work in-office Monday through Thursday each week, and remotely on Fridays.

What You’ll Accomplish

As a Business Intelligence Intern, you’ll have the opportunity to gain hands-on experience using data and technology to help drive business decisions across Wellness Pet. You’ll work alongside our Business Intelligence team to turn data into meaningful insights, reports, and tools that help Wellies better understand our business, consumers, and customers.

In this role, you will:

• Support the development, maintenance, and enhancement of Business Intelligence dashboards, reports, and data models used by cross-functional teams.
• Write and optimize SQL queries to extract, analyze, and validate data from various data sources.
• Assist with data collection, cleansing, validation, and transformation activities to ensure accurate and reliable reporting.
• Gain hands-on experience with Data Warehousing concepts, including dimensional modeling, fact and dimension tables, and ETL/ELT processes.
• Analyze business, sales, and operational data to identify trends, opportunities, and areas for improvement, translating findings into actionable insights.
• Partner with stakeholders across functions to understand business requirements and help develop data-driven reporting and analytics solutions.
• Support ad hoc reporting, data analysis, and business intelligence projects, presenting findings and recommendations in a clear and concise manner.
• Assist in building and maintaining data pipelines, automated processes, and reporting solutions using BI and analytics tools.
• Gain exposure to modern analytics technologies such as Power BI (or any other visualization tool), SQL, Data Warehousing platforms, and Python-based data analysis techniques.
• Learn and apply data governance, data quality, and reporting best practices to support enterprise analytics initiatives.

Through this experience, you’ll develop practical skills in data analysis, data visualization, dashboard development, business problem-solving, and cross-functional collaboration while gaining a deeper understanding of how a growing consumer brand uses data to make better decisions.

This internship can serve as a strong foundation for future opportunities in Business Intelligence, Data Analytics, Business Analytics, Revenue Management, Sales Analytics, Marketing Analytics, or other data-focused roles.

Who We’re Looking For

Team Wellie is a group of people who are truly obsessed with all the best ways about winning for the consumer and the pets they love. And so, we are seeking an individual who:

• Brings their best
• Stays on the scent
• Gets hungry and digs deep
• Quick on their paws
• Wins as a pack

In addition, for this specific role, we need someone who is:

• Currently pursuing a bachelor's degree in Business Analytics, Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Finance, or a related field.
• Strong interest in using data to solve business problems and support decision-making.
• Strong SQL skills with the ability to query, analyze, and transform data. (Required)
• Basic understanding of Data Warehousing concepts, including fact and dimension tables, data modeling, ETL/ELT processes, and reporting structures.
• Experience with Microsoft Excel and a strong interest in data analysis and visualization.
• Familiarity with Power BI, SQL, Snowflake, or other BI/data visualization tools.
• Exposure to Python for data analysis, automation, or data processing is a plus.
• Demonstrates strong analytical, organizational, and problem-solving skills.
• Can communicate complex information clearly to both technical and non-technical audiences.
• Comfortable working independently while also collaborating with cross-functional teams.
• Detail-oriented and takes pride in producing accurate, high-quality work.

Why Wellness Pet?

We care about the wellbeing of our people, their families, and their pets. We treat every Wellie to a best-in-class benefits package, a warm and welcoming environment, and a place where you can learn and grow professionally. More information about what makes us special can be found on our website. The Wellness Pet Company is proud to be an equal opportunity workplace. We foster an inclusive work environment and are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, or veteran status.

The annual salary range for this position is $35 an hour, based on a full-time work schedule, anticipated responsibilities, market benchmarks, and organizational equity. Compensation may vary within that pay range depending on the selected candidate’s professional background, experience, operational needs, and other considerations permitted by law. The full compensation details will be communicated upon finalization of the employment offer and may include eligibility for participation in a bonus program.

#LI-RD1