Business Intelligence Intern

Wellness Pet Company; Burlington (MA); Híbrido; USD 41.000 - 55.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Bonus program

Descripción de la vacante

The Wellness Pet Company is seeking a Business Intelligence Intern to work in Burlington, MA, four days a week in- person with remote Fridays. You will gain hands-on experience turning data into insights, dashboards, and reports to help the business understand customers and operations.

You will develop skills in data warehousing concepts, ETL/ELT, and modern analytics tools while collaborating with cross-functional teams. This internship can lead to future BI or data analytics roles.

Formación

• Currently pursuing a bachelor's degree in a related field.
• Strong SQL skills with the ability to query, analyze, and transform data.
• 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.
• Detail-oriented and able to communicate complex information clearly to technical and non-technical audiences.

Responsabilidades

• Support development, maintenance, and enhancement of BI dashboards, reports, and data models used by cross-functional teams.
• Write and optimize SQL queries to extract, analyze, and validate data from various sources.
• Assist with data collection, cleansing, validation, and transformation for accurate reporting.
• Gain hands-on experience with Data Warehousing concepts, including dimensional modeling and ETL/ELT processes.
• Analyze business, sales, and operational data to identify trends and translate findings into insights.
• Partner with stakeholders to understand requirements and develop data-driven reporting solutions.
• Assist in ad hoc reporting, data analysis, and BI projects, presenting findings clearly.
• Help build and maintain data pipelines and automated reporting processes.

Conocimientos

SQL

Power BI

Snowflake

Python

Data visualization

Data analysis

Educación

Currently pursuing a bachelor's degree in Business Analytics, Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Finance, or related field

Herramientas

SQL

Power BI

Snowflake

Python

Descripción del empleo

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.

This role requires working in person at our Burlington, Massachusetts office Monday through Thursday, with remote work on Fridays. The position is full-time (40 hours per week); part-time availability will not meet the requirements of the role.

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.

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

• 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.
• This role requires working in person at our Burlington, Massachusetts office Monday through Thursday, with remote work on Fridays. The position is full-time (40 hours per week); part-time availability will not meet the requirements of the role.

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.