Intern- Data Analytics

O’Reilly Auto Parts is looking for a Data Analytics Intern who is passionate about uncovering insights from data and using them to drive business decisions. This role is perfect for someone who enjoys working with SQL, analyzing data from multiple sources, and translating findings into actionable recommendations. If you are detail-oriented, organized, and excited about working with stakeholders in a fast-paced environment, we’d love to hear from you!

Interns will be paired with one department for the summer and will be responsible for assisting their team with special projects and daily tasks that will contribute to the success of the company. Along with a mentor, interns will design their Career Development Plan and complete tasks and projects to gain the experience necessary to achieve their career goals.

What You Will Gain:

Ownership over a meaningful project and/or tasks that will challenge you to leave a lasting impact on O’Reilly

A personalized Career Development Plan with the guidance of your mentor

Intern Cohort: complete the program as part of a tight-knit group of interns supporting & learning from each other

Gain exclusive industry knowledge with site visits to our stores and distribution centers

Professional development curriculum with events hosted by experienced professionals

Build connections with O’Reilly team members and fellow interns through social events and activities

Expert education on translating your internship experience to your future job search

What You'll Do

Work with large datasets to validate, extract, clean, and analyze site search data

Use Google Analytics to track key performance metrics and provide insights on business trends

Investigate and interpret data from a business perspective, aligning findings with stakeholder goals

Collaborate with teams across the company to understand their data needs and deliver relevant insights

Create clear and well-documented reports and dashboards to present data findings

Develop strong analytical frameworks to support decision-making processes

Stay organized, manage multiple tasks efficiently, and ensure accuracy in data reporting

Below is a list of things we’d like to see in candidates for this internship. However, above all else, we are looking for the right PERSON for the job. Our ideal intern is hardworking, enthusiastic to learn and use new skills, dedicated to always doing their best, excited to contribute to a culture of teamwork, and committed to approaching their work with a win-win attitude to help everyone succeed.

Required Skills & Experience:

SQL & NoSQL: Proficiency in writing complex queries, optimizing performance, and working with both relational and NoSQL databases

Google Analytics: Experience navigating GA4, interpreting user behavior metrics, and leveraging event-based data for analysis

Strong Analytical & Problem Solving Skills: Ability to deconstruct complex problems, apply data-driven methodologies, and derive actionable insights

Desired:

Familiarity with BigQuery

Experience with analytics dashboards/data visualization tools (e.g., Looker Studio, Tableau, Power BI)

Basic Python skills (e.g., Pandas, NumPy)

We’d Love to Hear From Students Who:

See themselves in O’Reilly’s 12 Culture Values

Are actively enrolled at an accredited college or university pursuing a Bachelor’s degree in a related field

Are entering their junior or senior year of college (minimum 60 completed credit hours), or be a graduate student

Participate in on or off-campus activities outside of the classroom

Excellent communicators, both verbal and written

Passionate about contributing to and being a part of a positive culture based on win-win attitudes

Contribute to their local community through community outreach, service projects, etc.

Ability to work full-time (40 hours) for 9 weeks during summer

O’Reilly Auto Parts has a proven track record of growth and stability. O’Reilly is full of successful career stories and believes in a strong promote-from-within philosophy, encouraging you to grow your career along with the organization. 

Total Compensation Package:

• Competitive Wages & Paid Time Off

• Stock Purchase Plan & 401k with Employer Contributions Starting Day One

• Medical, Dental, & Vision Insurance with Optional Flexible Spending Account (FSA)

• Team Member Health/Wellbeing Programs

• Tuition Educational Assistance Programs