Hr Analyst

Job description
• Gather data from HR systems.
• Clean and process data: remove duplicates, handle missing values, ensure accuracy for reliable insights.
• Design dashboards and reports: use Excel pivot tables, advanced formulas (VLOOKUP, INDEX-MATCH), or tools like Tableau/Power BI for visuals on trends.
• Analyze recruitment: track source effectiveness.
• Review compensation: compare salaries to benchmarks, model equity adjustments, analyze benefits uptake (health insurance claims).
• Monitor engagement: score surveys , review exit feedback, correlate with performance ratings from appraisals.
• Detect patterns: use basic stats (averages, correlations) to flag issues like department-specific attrition or skill shortages.
• Support talent strategies: recommend training ROI (e.g., upskill 20% of team), succession plans, or hybrid work policies.
• Check compliance: audit for labor laws (EPF, POSH in India), data privacy (DPDP Act), report discrepancies monthly.
• Predict needs: model headcount for 10-20% growth, forecast skill gaps via scenario planning.
• Communicate results: prepare executive summaries, charts, and recommendations in PowerPoint for HR heads and leadership.
• Automate tasks: build macros in Excel or simple scripts for routine reports, saving 10-15 hours weekly.
• Collaborate: train non-tech HR staff on dashboards, join cross-team meetings for people analytics input.