Data Migration and Analytics Co-Op
About The Position
As a Data and Analytics Intern, you will contribute to data modeling and design, data collection and transformation, and data documentation. Working with supply chain, data engineering, and analytics teams, you will support the development and maintenance of Pet Studio, a central repository of analytics that includes media management of analytics displayed on televisions at headquarters. You will also work on front-end visualization and analytics automation initiatives. This hybrid co-op is based at the Overland Park, Kansas office and requires availability for 20 hours per week during the academic semester throughout the co-op. The role provides practical experience in a collaborative environment. You will use SQL with Snowflake and BigQuery, Google Apps Script, JavaScript, and visualization tools to support data workflows, dashboards, reporting, and automation. You will also help standardize and schedule presentations and workshops on Advanced Analytics and AI, capturing process-improvement notes to support future iterations.
Requirements
- Currently pursuing a degree in Computer Science, Data Science, Information Systems, Supply Chain Management, or a related field.
- Must be available to work hybrid at the Overland Park, Kansas office throughout the entire co-op.
- Must be available to work 20 hours per week during the academic semester.
- Strong analytical and problem-solving skills.
- Excellent communication and teamwork abilities.
- Ability to work independently and manage multiple tasks simultaneously.
- Basic understanding of data migration concepts and ETL processes.
Nice To Haves
- Experience with BI tools such as SAP Analytics Cloud, Tableau, or Power BI.
- Proficiency in programming languages such as Python, SQL, or similar.
Responsibilities
- Collaborate with cross-functional teams to define and structure data models that support business requirements.
- Design and implement data models using SQL in Snowflake and BigQuery for data analysis and reporting.
- Assist with planning and executing data collection and transformation using SQL and Google Apps Script.
- Support data validation, cleansing, and transformation to maintain data integrity and consistency.
- Document data processes, models, transformation workflows, sources, and methodologies.
- Create and maintain interactive dashboards and reports using CP tools such as DOMO and Looker Studio.
- Work with stakeholders to understand visualization needs and deliver actionable insights.
- Provide training and support to end-users on dashboards and reports.
- Identify opportunities to automate analytics processes and reporting using JavaScript in Snowflake and Google Apps Script.
- Develop, implement, monitor, and maintain automation scripts and tools to streamline workflows.
- Support development and maintenance of Pet Studio in DOMO, including media management of analytics shown on televisions at headquarters.
- Help standardize and schedule presentations and workshops on Advanced Analytics and AI, and record process-improvement notes during training.
- Travel up to 10%.
- Work 20 hours per week during the academic semester and be available to work hybrid at the Overland Park office throughout the entire co-op.
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- Basic life insurance
- Paid parental leave
- Disability coverage
- 401(k) retirement plan with company matching contributions, subject to eligibility requirements
- Minimum of 15 vacation/PTO days for salaried employees; hourly employees receive a minimum of 120 hours, with vacation prorated based on hire date
- 13 paid holidays
- Paid sick leave adjusted by role and location in accordance with local laws
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Part-time
Career Level
Intern
Education Level
No Education Listed
