Insurance Data Analyst — AS400 & Power BI Insights

Morgan McKinley; Hong Kong; On-site; HKD 446,000 - 893,000; Full time

Job summary

Morgan McKinley is seeking a Data Analyst in Hong Kong to extract, validate, and consolidate high-volume insurance data from AS400 and internal systems for EB operations. You will deliver daily operational reports and monthly dashboards covering claims, loss ratios, and underwriting metrics.

You will also automate recurring reports using Excel VBA, SQL, or Python, ensure data quality and governance, and collaborate with EB Operations, Underwriting, and Finance to align on requirements and

Qualifications

• 2+ years of data analysis or reporting experience in insurance or financial services
• Experience with Life operations preferred
• Proficiency with AS400 data extraction
• Strong Excel (Pivot Tables, lookups, formulas) and SQL
• Power BI or Tableau for visual insights
• Knowledge of Python, SAS, or R is a plus

Responsibilities

• Extract, manipulate, and validate high-volume data from AS400 and internal databases to support EB operations
• Deliver accurate daily operational reports and monthly executive dashboards covering medical claims, loss ratio, premium tracking, renewal listings, and underwriting metrics
• Develop and refine queries, macros, and automated data workflows (Excel VBA, SQL, or Python) to streamline reporting cycles
• Perform data reconciliations, maintain audit logs, and enforce PI data protection and compliance standards
• Collaborate with EB Operations, Underwriting, and Finance to elicit reporting requirements and deliver clear insights via Power BI and Excel

Skills

Data analysis

Reporting

Data visualization

Attention to detail

English & Chinese (Cantonese)

Tools

AS400

Advanced Excel

SQL

Power BI

Tableau

Python

SAS

R

VBA

Job description

Morgan McKinley is seeking a Data Analyst in Hong Kong to extract, validate, and consolidate high-volume insurance data from AS400 and internal systems for EB operations. You will deliver daily operational reports and monthly dashboards covering claims, loss ratios, and underwriting metrics.

You will also automate recurring reports using Excel VBA, SQL, or Python, ensure data quality and governance, and collaborate with EB Operations, Underwriting, and Finance to align on requirements and