Business Data Analyst - SQL, Dashboards & Data Lake

Manulife/John Hancock; Manila; Hybrid; PHP 700,000 - 1,000,000; Full time

Job summary

Manulife/John Hancock seeks a business-facing technical Data Analyst to translate GWAM Asia needs into data requirements and support trusted data products. You will work with business, product, architecture, and engineering teams to enable reporting, analytics, decision-making, and AI use cases.

Responsibilities include translating needs into testable data specs, profiling and reconciling data using SQL, delivering dashboards, and ensuring data quality and governance across markets.

Qualifications

• Bachelor’s or Master’s degree in Data Analytics, Computer Science, Statistics, Mathematics, Finance, Business Analysis, or a related discipline.
• 3–5 years in a Data Analyst or BI Analyst role with strong SQL and Excel skills.
• Ability to translate business needs into clear requirements for technical teams.

Responsibilities

• Translate business needs into testable data requirements across GWAM domains (clients, distribution, products, funds, accounts, AUM, transactions, profitability).
• Lead or support discovery sessions and prepare business requirements specifications, mappings, user stories, acceptance criteria, and process flows.
• Profile, investigate, and reconcile data using SQL; identify gaps and anomalies; support solution design.

Skills

SQL

Excel

Requirements gathering

Data mapping

Profiling

Data quality

Testing

English communication

Analytical thinking

Education

Bachelor’s or Master’s degree in Data Analytics, Computer Science, Statistics, Mathematics, Finance, Business Analysis, or related discipline

Tools

Power BI

Python

R

Spark

Databricks

Azure Data Lake Storage

Azure Data Factory

Job description

Manulife/John Hancock seeks a business-facing technical Data Analyst to translate GWAM Asia needs into data requirements and support trusted data products. You will work with business, product, architecture, and engineering teams to enable reporting, analytics, decision-making, and AI use cases.

Responsibilities include translating needs into testable data specs, profiling and reconciling data using SQL, delivering dashboards, and ensuring data quality and governance across markets.