Job Description
Data Analyst Internship
Company Overview
Thank you for applying for the Data Analyst Internship at How to Abroad! To better evaluate your analytical skills, product thinking, and ability to extract insights from user behavior and data, we’ve designed a two-part assessment. This task simulates a real-world product analysis and insight generation challenge.
Job Summary
To better evaluate your analytical skills, product thinking, and ability to extract insights from user behavior and data, we’ve designed a two-part assessment. This task simulates a real-world product analysis and insight generation challenge.
Key Responsibilities
- Part 1: Product Analysis – https://app.howtoabroad.com
We request you to use the platform over at least 3–4 days to generate meaningful feedback. This will help you explore trends, identify usability gaps, and track actual user interactions — which are key for a data analyst.
- Important: Please sign up as a Professional (not Student) to access all job-related features.
- Areas to Explore (500–800 word report):
- Feature Usefulness & Functionality
Which features worked well from a user perspective? Which ones did you find most valuable for your job preparation or applications?
- UX or Data Gaps
Did you find any bugs, missing information, or confusing UI areas? Were there any steps that felt unnecessary or could be improved?
- User Behavior Insights
Which features do you think users will love most and why? Which ones might be ignored or cause friction?
- Suggestions for Improvement
What would you recommend to improve the experience in terms of data display, UI, or workflows?
- Day-wise Usage Summary (REQUIRED):
Please include a day-wise activity log to show how your interaction evolved.
- Additional Questions (Answer All):
What does the Job Tracker feature mean to you personally? Do you find it useful? Why or why not?
What is your username on app.howtoabroad.com?
How many resumes did you create (mention specific days)?
How many jobs did you start tracking (mention specific days)?
Did the AI Assistant help you make a better, job-specific resume? Do you plan to use the AI Resume Assistant in the future? Why or why not?
Did you feel a difference in the job tracking experience from Day 1 to Day 4?
Did you apply for more jobs and are you tracking their status here?
Have you gone back and started tracking old job applications and marking their current status?
What helped you the most in tracking company or job statistics?
- Part 2: SQL Test
Schema: sql Copy Edit -- Job_Applications id | user_id | job_id | application_date | status -- Users user_id | name -- Jobs job_id | title | company_name Task: Write a SQL query that returns the number of job applications submitted by each user, grouped by application status.
Expected Output: lua Copy Edit name | status | total_applications ---------------------------------------- Alice | applied | 1 Alice | interview | 1 Bob | rejected | 1 You may either: Include the SQL query in your main report, or Attach a .sql file with your submission.
Application Process
Email your report to: jobs@howtoabroad.com
Subject Line: DATA ANALYST INTERNSHIP ENTRY TEST
Deadline: Submit within 7 days of receiving this email.