Human Resources Analyst (intern)

Role Overview

HR intern

with hands-on talent acquisition

insightful HR dashboards and reports using Excel, Google Sheets, and Google Data

Studio, while simultaneously driving the end-to-end recruitment process to deliver high-

quality talent. The role is ideal for someone who thrives in a fast-paced environment and

enjoys balancing analytical depth with people-centric hiring practices.

Key Responsibilities

HR Analytics & amp; Reporting (40%)

? Collect, validate, and analyze HR and recruitment data to generate actionable insights.

? Develop and maintain interactive dashboards in Google Data Studio and reports in Excel/Google Sheets.

? Track and report on key HR and TA metrics, including:

? Time-to-Fill (TAT)

? Offer-to-Join Ratio

? Cost per Hire

? Source Effectiveness

? Diversity Metrics

? Recruiter Productivity

? Conduct trend analysis to identify hiring bottlenecks, forecast workforce needs, and measure TA effectiveness.

? Provide monthly and quarterly executive reports to leadership for data-driven decision making.

? Partner with HR leadership to design data models for workforce planning, attrition analysis, and recruitment forecasting.

Talent Acquisition (60%)

? Manage the end-to-end recruitment cycle across functions and levels, from requirement gathering to onboarding.

? Source candidates using job portals, LinkedIn, referrals, and direct outreach.

? Screen resumes, conduct preliminary interviews, and coordinate technical/managerial interviews.

? Drive candidate engagement and ensure an excellent candidate experience.

? Collaborate with hiring managers to understand role requirements, workforce gaps, and market insights.

? Build and nurture talent pipelines for critical and recurring roles.

? Maintain compliance with hiring policies and ensure documentation is up to standard.

? Partner with HR team on employer branding initiatives to strengthen market presence.

Key Skills & Competencies

? Analytical & Technical Skills

? Advanced Excel (Pivot Tables, Lookups, Power Query, Macros preferred).

? Proficiency in Google Sheets for collaborative data analysis.

? Experience with Google Data Studio (Looker Studio) for dashboarding.

? Familiarity with ATS/HRIS systems.

? Recruitment Expertise

? Strong knowledge of sourcing strategies, assessment methods, and interview coordination.

? Ability to manage multiple roles simultaneously in a high-pressure environment.

? Understanding of hiring for diverse functions (Tech, Product, Business, etc.).

? Behavioral Skills

? Strong communication and stakeholder management skills.

? High attention to detail with a problem-solving mindset.

? Ability to balance data insights with human judgment.

? Strong project management and multitasking abilitie