SMSmartworks
HR Analyst (MIS/Reporting/Analytics)
Gurgaon ₹3-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.