SM

HR Analyst (MIS/Reporting/Analytics)

Smartworks
Gurgaon3-6 LPA Posted 19 Jun 2025
FULL TIME
Power Bi
Data Visualization
Dashboards
Hr
Sql
+3 more

Job Description

The HR Reporting Dashboard Analyst is responsible for designing, managing, and maintaining HR dashboards, reports, and analytics to drive data-driven decision-making. This role focuses on workforce analytics, HR metrics tracking, and visualization of key HR insights to improve efficiency, compliance, and strategic workforce planning.

Key Responsibilities:

1. HR Data Reporting Visualization:

  • Develop and maintain HR dashboards in Power BI, Excel, or Tableau for leadership insights.
  • Generate weekly, monthly, and quarterly HR reports covering recruitment, attrition, diversity, compensation, and employee engagement.
  • Ensure data accuracy and integrity across all HR reporting systems.

2. HR Metrics KPI Tracking:

  • Track and report HR KPIs such as time-to-hire, attrition, cost-per-hire, offer acceptance rate, employee engagement scores, and diversity ratios.
  • Develop HR scorecards and performance dashboards aligned with Balanced Scorecard methodology.
  • Provide insights on workforce productivity, retention trends, and compensation analytics.

3. HR Dashboarding Automation:

  • Build interactive dashboards to provide real-time insights on workforce analytics.
  • Leverage Excel (Pivot Tables, Macros, Power Query), Power BI, or Tableau for advanced reporting.
  • Automate HR processes using Power Automate, VBA, or Python for improved efficiency.

4. HR Analytics Decision Support:

  • Analyze employee survey results, attrition data, and workforce trends to provide strategic recommendations.
  • Support recruitment analytics by identifying hiring patterns and optimizing sourcing channels.
  • Provide data-driven insights for leadership decisions on headcount planning and workforce optimization.

Qualifications Requirements:

  • Education: Bachelors degree in HR, Business Analytics, Data Science, or a related field.
  • Experience: 3-5 years in HR reporting, dashboarding, HR analytics, or workforce planning.

Technical Skills:

  • Expertise in Excel (Pivot Tables, Power Query, VLOOKUP, Dashboards, Macros).
  • Proficiency in Power BI, Tableau, SQL, or Python for HR analytics is a plus.
  • Strong data visualization and storytelling skills.
  • Attention to detail with a problem-solving mindset.
  • Ability to work cross-functionally with HR, IT, and Finance teams.
  • Excellent communication and presentation skills.

Join WhatsApp Channel