Business Analytics - Data Analyst

eData Services Philippines Inc.; Philippines; On-site; PHP 300,000 - 420,000; Full time

Job summary

eData Services Philippines Inc. seeks a detail-oriented Reporting & Data Analyst to support operational reporting, data management, and ad-hoc business requests. The ideal candidate is an Excel expert who enjoys transforming raw data into accurate, meaningful reports.

The role requires advanced Excel skills, data validation, Pivot Tables, macros/VBA, and the ability to work independently with minimal supervision. On-site at IPC Building, Taguig, with flexible shifts including nights.

Qualifications

• Advanced Excel with complex formulas, Pivot Tables, and Power Query is required.
• Experience cleaning, structuring, and validating data from multiple sources.
• Experience creating automated reports and dashboards for decision-making.
• Strong English communication, both written and verbal.

Responsibilities

• Collaborate with teams to gather requirements and support decision-making with data-driven insights.
• Create, maintain, and optimize Excel-based reports, trackers, and dashboards.
• Clean, validate, and organize large datasets from multiple sources.
• Develop formulas, Pivot Tables, charts, and automated spreadsheets for efficiency.
• Utilize Macros/VBA to automate repetitive tasks and data pipelines.
• Analyze reporting requirements and deliver accurate outputs within timelines.
• Investigate data discrepancies and perform root-cause analysis for quality.
• Generate recurring and ad-hoc reports as needed.
• Document processes to ensure repeatability and transparency.
• Engage in continuous learning to improve Excel skills and reporting techniques.

Skills

Advanced Excel

Data analysis

Data cleaning

Pivot tables

VBA/macros

Data validation

English communication

Analytical thinking

Education

Bachelor's degree in Business/Data Science

Statistics coursework

Tools

Power Query

VBA

Pivot Tables

Job description

Job Description:

We are seeking a highly detail-oriented and analytical Reporting & Data Analyst to support operational reporting, data management, and ad-hoc business requests. The ideal candidate is an Excel expert who enjoys working with data, identifying patterns, solving problems, and transforming raw information into accurate and meaningful reports.

This role requires advanced Excel skills, strong critical thinking abilities, and a proactive mindset when handling reporting challenges. The successful candidate should be comfortable working independently, ensuring data accuracy, and delivering timely reporting solutions with minimal supervision.

The position requires flexibility for shifting schedules and/or night shifts, with the option to work onsite at IPC (Intellectual Property Office) Building, Taguig.

Key Responsibilities:

• Collaborate with teams across departments to gather requirements, identify trends, and support decision-making through data-driven insights.
• Create, maintain, and improve Excel-based reports, trackers, and dashboards.
• Clean, validate, organize, and manage large datasets from multiple sources.
• Develop formulas, Pivot Tables, charts, and automated spreadsheets to improve reporting efficiency.
• Utilize basic to intermediate Macros/VBA to streamline repetitive tasks and automate data pipelines to ensure data integrity through cleaning and validation.
• Analyze reporting requirements and provide accurate, actionable outputs.
• Investigate data discrepancies and perform root-cause analysis to ensure data quality.
• Generate recurring, non-executive, and ad-hoc reports within required timelines.
• Document processes and reporting logic to ensure consistency and repeatability.
• Use idle or low-activity time productively to improve product knowledge, reporting techniques, and analytical skills.
• Manage ETL processes for extracting, transforming, and loading data.
• Monitor data quality and resolve any inconsistencies or errors.
• Collaborate with cross-functional teams, including Influential Stakeholders, Support and Production Group, to ensure efficient integration and process flow.

Qualifications:

1. Experience & Exposure (Preferably 1-2 years of experience)

• Background in Business Management, Data Science and/or a related field.
• Advanced proficiency in Microsoft Excel, including complexformulas and functions, pivot tables and charts, MACRO/VBA, Power Query and Data Validation Techniques.
• Skilled in cleaning, structuring, and validating data from various sources.
• Strong experience in data cleaning, data organization, and data accuracy verification.
• Ability to efficiently manage and analyze large datasets.
• Strong analytical and critical thinking skills.
• Excellent time management and communication skills.
• Intermediate to Advanced English communication skills (written and spoken).

2. Preferred Competencies

• Exceptional Attention to Detail - Focus on ensuring data is precise and reliable across Reports and Dashboards.
• Strong Problem-Solving skills for data issues and reporting optimization.
• Natural Researcher - Who can independently find a reasonable answers from a complex problem with less supervision.
• Find-a-way Attitude: Resourcefulness and always looking for solutions rather than roadblocks.
• Team Player - Ability to work independently and collaboratively within a Team.
• Professional Alignment and Accountability - Demonstrates respect for the established reporting structure and follows reasonable instructions, priorities and directions provided by the immediate Manager/Supervisor. Employee is expected to actively support achieving departmental objectives, communicate concerns or challenges professionally while maintaining alignment with the management decisions and priorities.
• Advantage: Previous experience in a client-facing or with consulting role.

Work Conditions:

• Shift Schedule: Must be flexible in shifting schedules and night shifts.
• Onsite Work: Willingness to work onsite at IPC (Intellectual Property Office) Building, Taguig.
• Must be comfortable working fast-paced, data-driven environment with shifting priorities.
• Expected to manage workload effectively, balance prioritization of task and ability work independently with minimal supervision.
• During periods of lower task volume or idle time, the employee is expected to engage in continuous learning, familiarization and knowledge improvement - such as improving Excel skills (Syntax & Macro), exploring new Reporting and/or Dashboard creation techniques, Automation Techniques, Familiarity in M365 Tools and/or deepening product and business knowledge of eData Services.