Roster Analyst

OYO; Gurugram District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

OYO is seeking a data-driven role focused on workforce analytics and roster optimisation. You will analyse workforce, roster, attendance and staffing data to uncover trends, gaps and opportunities for efficiency across multiple sites and shifts.

You will develop and maintain SQL queries and use Python (Pandas/NumPy) for data cleaning, analysis and automated reporting. Close collaboration with Australia-based Operations and India HR/Analytics teams will be essential to deliver accurate insights

Qualifications

• Strong proficiency in SQL for data extraction, joins, aggregations, CTEs and analysis.
• Good working knowledge of Python, particularly Pandas and NumPy.
• Advanced MS Excel skills.

Responsibilities

• Analyse workforce, roster, attendance and staffing data to identify trends, gaps and optimisation opportunities.
• Develop and maintain SQL queries to extract, transform and analyse workforce-related data.
• Use Python for data cleaning, analysis, automation and recurring reporting.
• Analyse employee availability, shift requirements, leave, absenteeism and staffing patterns.
• Support the preparation and optimisation of employee rosters across multiple sites and shifts.
• Identify roster conflicts, understaffing, overstaffing and potential coverage issues.
• Build analytical models to support workforce planning and demand forecasting.
• Develop automated reports, dashboards and MIS for workforce and roster performance.
• Monitor roster adherence, workforce utilisation, overtime and staffing efficiency.
• Coordinate with Australia-based Operations teams to understand requirements and resolve roster-related challenges.
• Work with India-based HR, Operations, Analytics and other internal teams to ensure smooth execution of workforce processes.
• Communicate roster changes, exceptions, insights and recommendations clearly to relevant stakeholders.
• Investigate data discrepancies and ensure accuracy across roster and workforce datasets.
• Automate repetitive data preparation and reporting activities using SQL and Python.
• Track key workforce metrics and provide actionable insights to stakeholders.
• Identify opportunities to improve roster processes, workforce utilisation and operational efficiency.

Skills

SQL

Python

Excel

Pandas

NumPy

Tools

SQL Queries

Pandas

NumPy

Job description

Role & responsibilities

• Analyse workforce, roster, attendance and staffing data to identify trends, gaps and optimisation opportunities.
• Develop and maintain SQL queries to extract, transform and analyse workforce-related data.
• Use Python for data cleaning, analysis, automation and recurring reporting.
• Analyse employee availability, shift requirements, leave, absenteeism, overtime and staffing patterns.
• Support the preparation and optimisation of employee rosters across multiple sites and shifts.
• Identify roster conflicts, understaffing, overstaffing and potential coverage issues.
• Build analytical models to support workforce planning and demand forecasting.
• Develop automated reports, dashboards and MIS for workforce and roster performance.
• Monitor roster adherence, workforce utilisation, overtime and staffing efficiency.
• Coordinate closely with Australia-based Operations teams to understand requirements and resolve roster-related challenges.
• Work with India-based HR, Operations, Analytics and other internal teams to ensure smooth execution of workforce processes.
• Communicate roster changes, exceptions, insights and recommendations clearly to relevant stakeholders.
• Investigate data discrepancies and ensure accuracy across roster and workforce datasets.
• Automate repetitive data preparation and reporting activities using SQL and Python.
• Track key workforce metrics and provide actionable insights to stakeholders.
• Identify opportunities to improve roster processes, workforce utilisation and operational efficiency.

Preferred candidate profile

• Strong proficiency in SQL for data extraction, joins, aggregations, CTEs and analysis.
• Good working knowledge of Python, particularly Pandas and NumPy.
• Advanced MS Excel skills.
• Strong analytical and problem-solving abilities.
• Strong verbal and written communication skills.
• Excellent stakeholder management and interpersonal skills.
• Ability to communicate effectively with both Indian and Australian stakeholders.
• Comfortable participating in calls, discussions and meetings with Australia-based teams.
• Ability to understand business requirements and translate them into analytical solutions.
• Strong attention to detail and data accuracy.
• Ability to manage multiple priorities in a fast-paced environment.
• Strong ownership and ability to proactively identify and resolve issues.
• Ability to work effectively across different cultures, teams and time zones.