Assistant Hr Analytics Manager

Lloyds Metals & Energy Limited; Ghugus; On-site; INR 1,300,000 - 1,800,000; Full time

Job summary

Lloyds Metals and Energy Limited (LMEL) at Ghugus, Chandrapur, Maharashtra, is seeking an Assistant Manager HR Analytics to drive data-driven HR decisions from our Ghugus plant. You will develop dashboards, predictive models, and key metrics, collaborating with plant leadership to optimize manpower planning, attrition, and payroll costs.

The role requires 4–7 years in HR analytics or workforce planning, strong Excel and Power BI/Tableau skills, and experience with HRMS systems.

Qualifications

• MBA / PGDM in HR, Data Analytics, Statistics or B.E./B.Tech/B.Sc in Statistics/Mathematics with HR domain expertise.
• 4 to 7 years of relevant HR Analytics or Workforce Planning experience, preferably in Manufacturing, Metals & Mining, Energy, or heavy engineering plant operations.
• Strong MS Excel (VBA/Macros/Power Query), Power BI/Tableau, HRMS systems (SAP/Darwinbox/Workday); SQL or Python/R is an added advantage.

Responsibilities

• HR Dashboarding & Reporting: Build and maintain daily, weekly, and monthly HR dashboards for senior management (Power BI / Excel).
• Workforce Planning & Labor Cost Analytics: Analyze manpower utilization, shift patterns, overtime trends, and contractor usage.
• Predictive Modeling & HR Insights: Develop models for attrition risk, high-performer retention, and hiring cycle timelines.
• HR Technology & System Integration: Serve as the functional expert for HR Systems (HRMS/SAP/Darwinbox/Time & Attendance).
• Strategic Initiatives & Decision Support: Collaborate with Talent Acquisition, L&D, and Employee Relations to provide data-backed insights.

Skills

Advanced Excel

Power BI

Tableau

HRMS systems

SQL

Python/R

Education

MBA / PGDM in HR

Data Analytics

Statistics

B.E./B.Tech

B.Sc in Statistics/Mathematics with HR domain

Tools

Power BI

Excel VBA/Macros

Job description

Job Title: Assistant Manager HR Analytics

Department: Human Resources

Reporting To: Head Human Resources

Location: Unit 1, Ghugus, Chandrapur, Maharashtra.

About Lloyds Metals and Energy Limited (LMEL)

Lloyds Metals and Energy Limited (LMEL) is a leading integrated metals and energy manufacturing company with growing operations in iron ore mining, sponge iron, power generation, and steel production. Located at our manufacturing hub in Ghugus, Chandrapur, LMEL is committed to operational excellence, workforce efficiency, and leveraging data-driven strategies to power its rapid growth.

Role Overview

The Assistant Manager HR Analytics will drive the transformation of HR data into actionable business insights. Reporting directly to the Head of HR, you will be responsible for designing, implementing, and maintaining workforce dashboards, predictive models, and key HR metrics. Operating directly out of our flagship plant site in Ghugus, you will work closely with plant leadership, departmental heads, and operational teams to optimize manpower planning, attrition, productivity, payroll costs, and workforce performance across plant operations.

Key Responsibilities

1. HR Dashboarding & Reporting

• Build, maintain, and automate daily, weekly, and monthly HR dashboards for senior management (Power BI / Excel).
• Track key HR metrics across the plant lifecycle: headcounts, turn-over rates, cost-per-hire, overtime costs, attendance, absenteeism, training hours, and contract labor metrics.
• Prepare executive summaries and monthly presentation decks for the Head of HR and plant leadership.

2. Workforce Planning & Labor Cost Analytics

• Partner with plant operations to analyze manpower utilization, shift patterns, overtime trends, and contractor usage.
• Conduct variance analysis between budgeted headcount vs. actual manpower deployment across plant units.
• Analyze shop-floor productivity trends, labor cost distribution, and statutory compliance metrics related to the plant workforce.

3. Predictive Modeling & HR Insights

• Develop predictive models for attrition risk, high-performer retention, and hiring cycle timelines.
• Perform root-cause analysis on key operational HR challenges (e.g., absenteeism in specific shifts, plant attrition drivers, training efficacy).
• Translate complex statistical findings into clear business strategies for plant management.

4. HR Technology & System Integration

• Serve as the functional expert for HR Systems (HRMS/SAP/Darwinbox/Time & Attendance systems).
• Ensure high data integrity and consistency across all HR databases and employee records.
• Automate manual HR reporting workflows to improve data accuracy and reporting efficiency.

5. Strategic Initiatives & Decision Support

• Collaborate with Talent Acquisition, L& D, and Employee Relations to provide data-backed insights for policy improvements.
• Conduct benchmark studies on industry standards (compensation, plant workforce ratios, benefits) in the metals, mining, and manufacturing sectors.
• Support the HR Head in special strategic projects, annual budgeting, and board/investor reporting materials.

Ideal Candidate Profile

Education: MBA / PGDM in Human Resources, Data Analytics, Statistics, or B.E. / B.Tech / B.Sc in Statistics/Mathematics with HR domain expertise.

Experience: 4 to 7 years of relevant experience in HR Analytics or Workforce Planning, preferably within Manufacturing, Metals & Mining, Energy, or heavy engineering plant operations.

Technical Skills: Advanced MS Excel (VBA/Macros/Power Query), Power BI or Tableau, HRMS systems (SAP/Darwinbox/Workday). Experience with SQL or Python/R is an added advantage.

Functional Knowledge: Strong understanding of plant workforce dynamics, contract labour management, statutory compliance data, and compensation structuring.

Soft Skills: Excellent data storytelling, strong presentation skills, analytical problem-solving, stakeholder management, and cross-functional coordination.

Location & Working Conditions

Location: Ghugus Plant Site, Chandrapur, Maharashtra.

Work Mode: Full-time, On-site (Plant location).

Candidates must be willing to relocate to or commute to Ghugus/Chandrapur.