Business Analyst

Optum; Metro Manila; On-site; PHP 670,000 - 1,228,000; Full time

Job summary

Optum in Manila is seeking a Business Analyst - Operations to deliver high-quality reporting, analytics, and insights supporting Rx Clinical Operations. You will collaborate with clinical program owners, operations leaders, and enterprise analytics teams to turn business needs into meaningful reports and dashboards.

This role supports Optum’s Rx Clinical Operations Globalization Strategy by driving productivity, operational efficiency, and data-driven decision-making through end-to-end data

Qualifications

• Bachelor’s degree or equivalent relevant work experience.
• 5+ years of experience in data analytics, business analytics, reporting, or operations analytics.

Responsibilities

• Partner with internal stakeholders to gather and clarify reporting requirements.
• Develop and deliver ad hoc and recurring operational reports using Excel and Power BI.
• Present and distribute reports, providing ongoing support and insights to stakeholders.
• Follow data governance standards and maintain SOPs for audit readiness and knowledge transfer.

Skills

Advanced Excel

SQL & Azure Databricks

Power BI

Data Integration

Analytical Thinking

Documentation & Data Governance

Version Control & Collaboration Tools

Clear communication

Education

Bachelor's degree or equivalent

Tools

Azure Databricks

Power Query

DAX

Delta Lake

Python

Job description

We are looking for a Business Analyst - Operations to support Rx Clinical Operations through high-quality reporting, analytics, and insights. In this role, you will work closely with clinical program owners, operations leaders, and enterprise analytics teams to turn business needs into meaningful reports and dashboards.

You will play a key role in supporting Optum’s Rx Clinical Operations Globalization Strategy for 2026, helping drive productivity improvements, operational efficiency, and data-driven decision-making.

This is an excellent opportunity for candidates who enjoy end-to-end data analysis, stakeholder collaboration, and building trusted reporting solutions.

Key Responsibilities

Reporting & Business Support

• Partner with internal stakeholders (clinical program owners, operations leaders, call center managers) to gather and clarify reporting requirements
• Develop and deliver ad hoc and recurring operational reports using Excel and Power BI
• Present and distribute reports, providing ongoing support and insights to stakeholders

Data Extraction, Integration & Transformation

• Extract, join, and aggregate data using SQL in Azure Databricks
• Use Python / PySpark as needed for data manipulation and analysis
• Integrate data from multiple sources (databases and Excel files) using SQL joins and Power Query
• Perform data cleansing and validation to ensure accuracy and consistency

Data Quality, Governance & Documentation

• Ensure reports are 100% accurate and on time before release
• Maintain standard operating procedures (SOPs) and documentation for audit readiness and knowledge transfer
• Follow data governance standards, including proper handling of PHI / PII
• Monitor operational performance metrics and proactively flag trends, risks, or anomalies
• Participate in operational calls and training sessions
• Continuously improve reporting processes and analytics based on feedback and evolving business needs

Qualifications

• Bachelor’s degree or equivalent relevant work experience
• 5+ years of experience in data analytics, business analytics, reporting, or operations analytics

Technical Skills

• Advanced Excel: Deep understanding of formulas, chart creation, macros, and VBA code; ability to perform ad hoc and recurring report generation; strong data cleansing skills using functions like TRIM, removing duplicates, and formatting consistency. Also includes advanced use of pivot tables, conditional formatting, INDEX/MATCH, dynamic arrays, and Power Query for ETL within Excel.
• SQL & Azure Databricks: Proficiency in SQL coding within Azure Databricks notebooks; ability to extract, join, and aggregate data from databases; familiarity with Python and PySpark for data manipulation and integration. Includes writing optimized queries, managing notebook workflows, scheduling jobs, and understanding Delta Lake architecture.
• Power BI: Experience in building interactive dashboards for standardized reporting; ability to present data visually and enable end users to slice and analyze information. Includes DAX proficiency, data modeling, row-level security implementation, scheduled refresh configuration, and workspace/access management.
• Data Integration: Capability to merge data from multiple sources (Excel, SQL) into a single source of truth using tools like Power Query or SQL joins. Includes handling schema differences, maintaining data lineage, and managing ETL pipelines across platforms.
• Analytical Thinking & Problem Solving: Translating business requirements into code and actionable outputs; identifying trends, anomalies, and providing insights to stakeholders. Includes the ability to break down ambiguous problems, propose multiple solutions, and prioritize based on business impact.
• Documentation & Data Governance: Maintaining SOPs and procedures for report builds; ensuring data quality, accuracy, and proper access controls. Includes creating data dictionaries, managing security groups, enforcing PHI/PII compliance, and supporting audit readiness.
• Version Control & Collaboration Tools: Familiarity with Databricks notebooks, SharePoint, and Teams for collaborative development, documentation, and knowledge sharing.

Professional Skills

• Strong analytical and problem-solving skills
• High attention to detail and accountability for data quality
• Ability to work independently and manage multiple priorities
• Clear written and verbal communication skills
• Strong documentation and process discipline