Team Lead / WFM

Orcapod Consulting Services; Chennai District, Coimbatore District; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Orcapod Consulting Services in Chennai, Tamil Nadu seeks a Team Lead RA to design, automate, and maintain operational, performance, and client reports. You will build dashboards using Power BI, Looker Studio, and Tableau, ensure data integrity, and deliver timely insights to leaders.

The role requires advanced Excel, SQL, and Python/R for data manipulation, plus collaboration across Ops, Finance, and Client Reporting to meet stakeholder needs and audits.

Qualifications

• Extensive experience in Reporting, MIS, Analytics, or Workforce Management.
• Strong background in building, automating, and maintaining dashboards using Excel, SQL and BI tools.
• Experience with WFM systems such as Verint, Genesys, IEX, Beehive, Aspect.
• Exposure to predictive modelling, statistical analysis, or ML-based analytics.
• Experience supporting client-facing reporting deliverables in multisite or large-scale operations.

Responsibilities

• Design, build, and automate operational, performance, SLA, and business dashboards.
• Develop and maintain reporting packages/presentations for leadership and clients.
• Build interactive dashboards using Looker Studio, Power BI, Tableau, or similar BI platforms.
• Ensure data integrity, accuracy, and timely delivery of reports.
• Analyze large datasets to identify trends and provide actionable insights.

Skills

Advanced Excel

SQL proficiency

Power BI

Tableau

Python/R

Tools

Power BI

Looker Studio

Tableau

Qlik

Job description

Job Description

Job Title: Team Lead RA

Job Summary highlight project details/what is exciting about the role :

The Reporting Analyst is responsible for designing, developing, automating, and maintaining operational, performance, and business intelligence reports. The role requires strong analytical abilities, advanced technical skills, and experience in deriving insights from complex datasets to support business decisionmaking. The analyst will act as an SME for reporting processes, data integrity, visualization standards, and stakeholder reporting requirements.

Key Responsibilities

1. Reporting & Dashboard Development

• Design, build, and automate operational, performance, SLA, and business dashboards.
• Develop and maintain daily/weekly/monthly reporting packages/presentations for leadership, clients, and crossfunctional teams.
• Build interactive dashboards using tools such as Looker Studio, Power BI, Tableau, or similar BI platforms.
• Ensure data integrity, accuracy, and timely delivery of reports.

2. Advanced Data Analysis

• Analyze large and complex datasets to identify trends, patterns, and outliers.
• Provide actionable insights and recommendations to business leaders.
• Build forecasting or scenariobased analysis models when required.

3. Data Management & Quality Control

• Manage data extraction, transformation, validation, consolidation, and publication pipelines.
• Conduct QA checks to ensure data consistency across systems.
• Collaborate with IT/Data Engineering teams to resolve discrepancies.

4. Process Improvement & Automation

• Identify automation opportunities to reduce manual effort.
• Develop macros, scripts, or automated solutions (Google Sheet, Excel VBA, SQL, Python preferred).
• Optimize existing dashboards and reports.

5. Stakeholder Collaboration

• Work with Operations, WFM, Finance, and Client Reporting teams to understand requirements.
• Act as reporting SME in internal and client discussions.
• Support internal and external audits.

Essential Skills

Technical Skills

• Advanced Excel (Pivot Tables, Power Query, macros, VBA).
• Good SQL proficiency (queries, joins, functions, stored procedures).
• Experience with BI tools: Power BI (preferred), Tableau, Qlik, or similar.
• Experience with Python or R for data manipulation is a plus.
• Understanding of relational databases, data schemas, APIs, and reporting systems.

Functional & Analytical Skills

• Strong analytical thinking and problemsolving abilities.
• - Ability to convert raw data into meaningful insights and executivelevel summaries.
• - Experience working in BPO/Shared Services/WFM/CX environments (preferred).

Soft Skills

• Excellent verbal and written communication.
• Strong stakeholder management and collaboration abilities.
• Ability to prioritize and manage multiple deliverables.
• Selfdriven and able to work with minimal supervision.

Qualifications

• Extensive experience in Reporting, MIS, Analytics, or Workforce Management.
• Strong background in building, automating, and maintaining dashboards and reporting models using Excel, SQL, and BI tools (Looker Studio, Power BI, Tableau).
• Experience with WFM systems such as Verint, Genesys, IEX, Beehive, Aspect.
• Exposure to predictive modelling, statistical analysis, or MLbased analytics.
• Experience supporting clientfacing reporting deliverables in multisite or largescale operations.
• Strong understanding of KPIs like SLA, AHT, Shrinkage, Occupancy, FTE, intervallevel metrics, etc.
• Excellent communication and presentation skills.
• Ability to collaborate across Ops, WFM, Finance, and Client teams.
• Strong attention to detail and a datadriven mindset.

Valid PAN Number - _____________________(Why PAN Required > Mandatory to Process Candidature & Find Duplicity in Internal PAN Validation Process and also to initiate a screening call

Please reach out in case of any queries.

Sonali Chattopadhyay I Associate People Success

Orcapod Consulting Services Pvt Ltd.

Email I [e-mail]

www.orcapodservices.com

9548431649