Hr Analytics Specialist

Policybazaar; Gurugram District; On-site; INR 700,000 - 1,100,000; Full time

Job summary

Policybazaar is seeking an HR Analytics professional in Gurgaon to leverage data and insights for strategic HR decisions. You will build dashboards, track key metrics such as headcount, attrition, and recruitment, and partner with HR and TA to drive workforce planning.

The role requires 2+ years in HR analytics, strong Excel skills, and hands-on Power BI/Tableau experience. You will work with multiple stakeholders in a fast-paced environment, 6 days a week.

Qualifications

• 2+ years of experience in HR Analytics, People Analytics, HR MIS, Workforce Analytics, or a similar role.
• Strong proficiency in Advanced Excel Pivot Tables, XLOOKUP/VLOOKUP, Power Query, dashboards, etc.
• Hands-on experience with Power BI/Tableau and dashboard creation.
• Good understanding of SQL and data extraction/manipulation.
• Strong analytical and problem-solving skills with the ability to convert data into actionable insights.
• Understanding of core HR metrics including attrition, headcount, hiring funnel, productivity, retention, and manpower planning.
• Excellent stakeholder management and communication skills.
• Ability to work in a fast-paced, target-driven environment.
• Comfortable working 6 days a week and collaborating with multiple stakeholders.

Responsibilities

• Develop and maintain HR dashboards, MIS, and analytical reports covering headcount, attrition, hiring, productivity, absenteeism, and employee movement.
• Analyse HR data to identify trends, gaps, and actionable insights for business and leadership teams.
• Partner with HR and TA teams to track KRA/KPI performance, recruitment metrics, TAT, conversion ratios, and manpower planning.
• Build automated and scalable reports using Advanced Excel, SQL, Power BI/Tableau, or other analytics tools.
• Support workforce planning, manpower budgeting, forecasting, and organisational analytics.
• Conduct attrition and retention analysis and identify key drivers impacting employee movement.
• Create periodic management dashboards and leadership reports with clear insights and recommendations.
• Ensure data accuracy, consistency, and integrity across HR reports and dashboards.
• Work with stakeholders to translate business requirements into data-backed HR solutions.
• Identify opportunities to automate repetitive HR reporting and improve data-driven decision-making.

Skills

HR Analytics

Advanced Excel

SQL

Power BI

Tableau

Stakeholder Management

Data-driven decision making

Tools

Power BI

Tableau

SQL

Job description

Experience: 2+ Years
Work Schedule: 6 Days Working
Location: Gurgaon
Department: Human Resources / HR Analytics

About the Role

We are looking for an HR Analytics professional who can leverage data, analytics, and insights to support strategic HR and business decisions. The role will involve working closely with HR, Talent Acquisition, Business, and Leadership teams to build meaningful dashboards, track key people metrics, and identify trends that improve workforce effectiveness.

Key Responsibilities

• Develop and maintain HR dashboards, MIS, and analytical reports covering key people metrics such as headcount, attrition, hiring, productivity, absenteeism, and employee movement.
• Analyse HR data to identify trends, gaps, and actionable insights for business and leadership teams.
• Partner with HR and TA teams to track KRA/KPI performance, recruitment metrics, TAT, conversion ratios, and manpower planning.
• Build automated and scalable reports using Advanced Excel, SQL, Power BI/Tableau, or other analytics tools.
• Support workforce planning, manpower budgeting, forecasting, and organisational analytics.
• Conduct attrition and retention analysis and identify key drivers impacting employee movement.
• Create periodic management dashboards and leadership reports with clear insights and recommendations.
• Ensure data accuracy, consistency, and integrity across HR reports and dashboards.
• Work with stakeholders to understand business requirements and translate them into data-backed HR solutions.
• Identify opportunities to automate repetitive HR reporting and improve overall data-driven decision-making.

Key Skills & Qualifications

• 2+ years of experience in HR Analytics, People Analytics, HR MIS, Workforce Analytics, or a similar role.
• Strong proficiency in Advanced Excel Pivot Tables, XLOOKUP/VLOOKUP, Power Query, dashboards, etc.
• Hands-on experience with Power BI/Tableau and dashboard creation.
• Good understanding of SQL and data extraction/manipulation.
• Strong analytical and problem-solving skills with the ability to convert data into actionable insights.
• Understanding of core HR metrics including attrition, headcount, hiring funnel, productivity, retention, and manpower planning.
• Excellent stakeholder management and communication skills.
• Ability to work in a fast-paced, target-driven environment.
• Comfortable working 6 days a week and collaborating with multiple stakeholders.

Key KRAs / KPIs

• Accuracy and timeliness of HR dashboards and MIS.
• Automation and reduction of manual reporting.
• Quality and relevance of HR insights provided to stakeholders.
• Attrition, manpower, and workforce analytics reporting.
• Recruitment and HR KPI tracking.
• Stakeholder satisfaction and turnaround time.
• Data accuracy and governance.
• Successful implementation of analytics-driven HR initiatives.

Preferred Profile

Candidates with experience in high-volume / fast-paced organisations, strong business partnering skills, and a proven ability to work with large employee datasets will be preferred.