Senior Business Analyst

Philtech Inc.; Taguig; Hybrid; PHP 700,000 - 1,000,000; Full time

Job summary

Philtech Inc. is seeking a Senior Business Analyst to optimize operational processes through data analysis, reporting, and stakeholder coordination. You will leverage Excel and Power BI, with SQL basics, to deliver actionable insights and support decision-making.

You will also train team members and help implement continuous improvement initiatives. The role coordinates cross-functional efforts, handles datasets from US stakeholders, and supports data extraction and reporting across ecommerce

Qualifications

• 4+ years in operations, business operations, ecommerce, or related analytics.
• Advanced Excel for reporting, analysis, and dashboard creation.
• 1–2 years hands-on Power BI reporting experience, with dashboards.

Responsibilities

• Lead onboarding and setup of new stores across digital platforms and storefronts.
• Manage online menus, seasonal assortments, pricing, promotions, and launches.
• Coordinate store hours and menu configurations for accurate customer info.
• Execute end-to-end operational requests and initiatives.
• Validate datasets from US stakeholders and internal systems.
• Identify impacted business groups and coordinate required activities.
• Communicate throughout the lifecycle of requests from intake to completion.
• Analyze sales and operational metrics to drive improvements.
• Provide Excel/Power BI driven insights to stakeholders.
• Investigate catalog/pricing discrepancies with cross-functional teams.
• Modify SQL queries in GCP and internal systems.
• Support data extraction, aggregation, and analysis activities.
• Identify process gaps and propose workflow improvements.
• Create and maintain process documentation and SOPs.

Skills

Data analysis

Stakeholder coordination

Advanced Excel

Power BI

Dashboarding

Communication

Training teammates

Tools

Excel

Power BI

SQL

Power Apps

Power Automate

Job description

Work Arrangement: 9 pm to 6am MNL time with four times a week RTO.

Job Summary:

The Senior Business Analyst is responsible for supporting and optimizing operational processes through data analysis, reporting, stakeholder coordination, and continuous improvement initiatives. This role serves as a key liaison between business stakeholders and operational teams, leveraging advanced Excel and Power BI capabilities, along with foundational SQL knowledge, to deliver actionable insights, drive operational excellence, and support strategic decision-making. The position also plays a critical role in training team members, enhancing processes, and ensuring successful execution of business initiatives.

Core Responsibilities:

• Lead new store onboarding and setup across digital commerce platforms, including virtual storefronts for grocery, deli, floral, and other retail categories.
• Maintain and optimize online store menus by implementing seasonal assortments, price updates, promotional changes, and new product launches.
• Manage store operating hours and menu configurations to ensure accurate customer-facing information and seamless shopping experiences.
• Own end-to-end execution of operational requests and initiatives.
• Organize, validate, and maintain datasets received from US stakeholders and internal systems.
• Determine impacted business groups and coordinate activities required for successful implementation.
• Manage communications throughout the lifecycle of requests, from intake through completion and resolution.
• Collect, aggregate, and analyze sales performance data and operational metrics to identify trends, support business decisions, and drive continuous improvement initiatives.
• Provide reporting, analytics, and actionable business insights to stakeholders using Excel and Power BI.
• Investigate and resolve catalog, assortment, and pricing discrepancies, partnering with cross-functional teams to ensure data accuracy and operational efficiency.
• Execute and modify existing SQL queries within GCP and other internal systems.
• Support data extraction, aggregation, and analysis activities.
• Identify process gaps and recommend workflow improvements.
• Create and maintain process documentation and SOPs.

Technical Skills

• Excel (Formatting, Sorting, Filtering, Charting, Extraction, Pivoting, Lookups, Cleansing, Advanced Formulas, Modeling, Reporting, Forecasting, Dashboarding, Data Analysis) – Specialized.
• Power BI (Data Modeling, DAX, Visualization, Dashboard Development, Publishing, Reporting, Business Insights) – Practical
• SQL (Querying, Filtering, Joins, Aggregation, Basic Query Modification, Data Validation) – Basic
• Power Apps – Basic
• Power Automate – Basic

Required Experience

• 4+ years of operations, business operations, eCommerce, marketplace support, order fulfillment, or related analytical experience.
• Advanced Excel experience for reporting, analysis, and dashboard creation.
• 1-2 years hands‑on experience developing and maintaining Power BI reports and dashboards.
• At least 1 year working knowledge of SQL for data extraction, validation, and basic query modification.
• Experience working with large datasets and operational reporting.
• Experience partnering with cross‑functional stakeholders.
• Experience supporting process improvement initiatives and operational excellence programs.
• Experience training, mentoring, or onboarding team members.