Data & Analytics Intern (Overland Park, KS, US)

Other Jobs To Apply

No other job posts for this day.

About the position

Responsibilities

  • Data Modeling & Design:
  • Collaborate with cross-functional teams to define and structure data models that support business requirements.
  • Design and implement data models using SQL within Snowflake and BigQuery to facilitate efficient data analysis and reporting.
  • Data Collection & Transformation:
  • Assist in planning and executing data collection and transformation activities using SQL and Google Apps Script, ensuring accuracy and efficiency.
  • Support data validation, cleansing, and transformation processes to maintain data integrity and consistency.
  • Data Documentation:
  • Document data processes, models, and transformation workflows to ensure clarity and reproducibility.
  • Maintain comprehensive records of data sources, transformations, and methodologies.
  • Front-End Visualization:
  • Create and maintain interactive dashboards and reports using CP tools (e.g., DOMO, Looker Studio).
  • Collaborate with stakeholders to understand their visualization needs and deliver actionable insights.
  • Provide training and support to end-users on effectively using the dashboards and reports.
  • Support for Analytics Automation Initiatives:
  • Identify opportunities to automate analytics processes and reporting using JavaScript in Snowflake and Google Apps Script.
  • Develop and implement automation scripts and tools to streamline workflows and improve efficiency.
  • Monitor and maintain automated processes to ensure they operate smoothly.
  • Media Management of Pet Studio:
  • Support the development and maintenance of Pet Studio in DOMO, also focusing on media management of analytics shown on TV in HQ.
  • Presentation and Workshop Contribution:
  • Help standardize and schedule presentations and workshops around Advanced Analytics and AI.
  • Ensure process improvement notes are taken during trainings to allow the iteration and improvement of scheduled events.

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 our Overland Park, KS office location throughout the entire internship
  • This position requires an 8-month commitment (August 2025 - May 2026)
  • Must be available to work at least 15hrs/week during the academic semester
  • Experience with BI tools such as SAP Analytics Cloud, Tableau, or Power BI
  • Proficiency in programming languages such as Python, SQL, or similar
  • Basic understanding of data migration concepts and ETL processes
  • Strong analytical and problem-solving skills
  • Excellent communication and teamwork abilities
  • Ability to work independently and manage multiple tasks simultaneously

Benefits

  • Salaried employees enjoy a comprehensive benefits package, including medical, dental, vision, basic life insurance, paid parental leave, disability coverage, and participation in the 401(k) retirement plan with company matching contributions subject to eligibility requirements.
  • Additional benefits include a minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours) and 13 paid holidays (vacation days are prorated based on the employee's hire date within the calendar year).
  • Paid sick leave is adjusted based on role and location in accordance with local laws. Detailed information regarding paid sick leave entitlements will be provided to employees upon hiring and may be subject to adjustments based on changes in legislation or company policies.
Back to blog

About United Kingdom

The United Kingdom is an island nation located on the northwest coast of Europe. The United Kingdom includes the entire island of Great Britain, which includes England, Wales, and Scotland, as well as the northern part of the island of Ireland. The name Great Britain is sometimes used to refer to the United Kingdom as a whole. The capital is London, which is one of the business, financial, and cultural centers of the world. Other major cities are Birmingham, Liverpool, and Manchester in England, Belfast and Londonderry in Northern Ireland, Edinburgh and Glasgow in Scotland, and Swansea and Cardiff in Wales.

Common Interview Questions

  • Tell me about yourself.
  • Walk me through your resume.
  • How did you hear about this position?
  • Why do you want to work at this company?
  • Why do you want this job?
  • Why should we hire you?
  • What can you bring to the company?
  • What are your greatest strengths?
  • What do you consider to be your weaknesses?
  • What is your greatest professional achievement?
  • Tell me about a challenge or conflict you’ve faced at work, and how you dealt with it.
  • Tell me about a time you demonstrated leadership skills.
  • What’s a time you disagreed with a decision that was made at work?
  • Tell me about a time you made a mistake.
  • Tell me about a time you failed.
  • Why are you leaving your current job?
  • Why were you fired?
  • Why was there a gap in your employment?
  • Can you explain why you changed career paths?
  • What’s your current salary?
  • What do you like least about your job?
  • What are you looking for in a new position?
  • What type of work environment do you prefer?
  • What’s your work style?
  • What’s your management style?
  • How would your boss and coworkers describe you?
  • How do you deal with pressure or stressful situations?
  • What do you like to do outside of work?
  • Are you planning on having children?
  • How do you stay organized?
  • How do you prioritize your work?
  • What are you passionate about?
  • What motivates you?
  • What are your pet peeves?
  • How do you like to be managed?
  • Do you consider yourself successful?
  • Where do you see yourself in five years?
  • How do you plan to achieve your career goals?
  • What are your career aspirations?
  • What’s your dream job?
  • What other companies are you interviewing with?
  • What makes you unique?
  • What should I know that’s not on your resume?
  • What would your first few months look like in this role?
  • What are your salary expectations?
  • What do you think we could do better or differently?
  • When can you start?
  • Are you willing to relocate?
  • How many tennis balls can you fit into a limousine?
  • If you were an animal, which one would you want to be?
  • Sell me this pen.
  • Is there anything else you’d like us to know?
  • Do you have any questions for us?

Educational Qualification

Candidates Who Have Passed Graduate or its Equivalent from a Recognized Board or University Are Eligible For this recruitment. Kindly check the Official Notification for more qualification details. Notification Link Is Given Below.

Document Required

Required Documents for This recruitment: Candidate should have these documents before applying online. Candidates are suggested to read the official notification before applying.

  • Qualification certificate with mark sheets.
  • Passport size photographs.
  • Signature.

How to Apply

All the eligible candidates can apply for this job as mentioned below:

  • Read official notification carefully from the official website.
  • Read notification carefully before applying.
  • Fill the application form (link is given below).
  • Attach required documents and passport size photo with signature.
  • Then submit. Done.