MIS Reports Analyst with exposure in BPO | EXL Service, MOA

EXL Service Philippines, Inc.; Pasay; On-site; PHP 500,000 - 800,000; Full time

Job summary

A leading company in the Philippines is looking for a Report Analyst and a Payroll Specialist to provide data insights and manage payroll processes. Candidates are expected to demonstrate technical proficiency in Excel and Power BI, along with strong analytical skills and attention to detail. This role includes collaborating with stakeholders and ensuring compliance in data management.

Qualifications

• Minimum 1 year of relevant experience in MIS/WFM for external candidates.
• Strong mathematical proficiency and analytical skills required.
• Intermediate to Expert Knowledge in MS Excel is essential.

Responsibilities

• Gather, analyze, and interpret data to provide actionable insights.
• Accurately calculate and process payroll while ensuring compliance.
• Develop and maintain reports and dashboards using Power BI.

Skills

Data Analysis

Excel

Problem Solving

Attention to Detail

Education

Bachelor’s degree in any field

Tools

MS Excel

Power BI

Power Query

Power Pivot

Job description

Basic Function

Report Analyst:

Analyze data and generate reports to provide insights, monitor performance, manage data accuracy, and recommend process improvements while ensuring compliance.

Payroll Specialist:

Accurately calculate and process payroll, maintain records, ensure compliance, and verify payroll data.

Essential Functions

Report Analyst:

• Gather, analyze, and interpret data to derive actionable insights using tools such as Excel, Power BI, Power Query, and Power Pivot

• Develop and maintain various reports, dashboards, and visualizations, including scorecards, KPI dashboards, templates and trackers, using Excel, Power BI, and Power Pivot

• Implement and maintain automated processes for report generation, data analysis, and template creation using tools like Excel macros, Power BI automation features, and Power Query

• Collaborate with stakeholders to understand requirements and deliver effective solutions for performance management and process improvement

• Facilitate monthly operations interaction to calibrate metrics and discuss insights

• Ensure adherence to policies, regulations, and data privacy laws while maintaining data integrity and security in databases and reporting systems

Primary Internal Interactions

• Ops AM, LAMs, Managers, AVP, VP

• Support (QPE, and Training) Leadership

• MIS/FPA/WFM Executives and Leadership

Primary External Interactions

• Client, for monthly KPI/SLA reporting and invoicing

Organizational Relationships

Reports To: MIS AM/LAM

Supervises: NA

Skills

Technical Skills

• Intermediate to Expert Knowledge in MS Excel

• Novice to Intermediate Knowledge in MS VBA, MS Access, PowerQuery, PowerPivot, PowerBI, and other MS Office applications

Soft skills (Desired)
• Ability to analyze data effectively and derive insights

• Thrives in a continually challenging environment

• Proactive with a drive for continuous improvement

Soft Skills (Minimum)
Functional

• Strong mathematical proficiency

• Keen attention to detail

• Excellent time management skills

• Effective written and verbal communication skills

• Strong analytical and problem-solving skills

• Demonstrate adaptability to change

• Adheres to company policies, procedures, and regulations

• Maintains confidentiality and upholds ethical standards

Leadership

• Fosters collaboration and teamwork

General

• Demonstrates creativity and innovation

• Displays resilience in handling challenges

• Good observation and research skills

Education Requirements

• Bachelor’s degree in any field

Work Experience Requirements

• External candidate: Minimum 1 year of relevant experience in MIS/WFM

Annexure:

• Sample Reports and Dashboards:

o Daily Performance Report

o Daily Absenteeism and Productivity Reports

o Monthly Performance Scorecard/

o Weekly and Monthly KPI Reports