Data Analyst: Client Reports & Insights

Intellicare Philippines; Philippines; On-site; PHP 257,000 - 268,000; Full time

Job summary

Intellicare Philippines is seeking an entry-level Data Analyst to prepare detailed membership and claims reports for external and internal clients. You will generate reports ranging from standard to complex and provide data to monitor client utilization and payments.

Requirements include a BS in Mathematics, Actuarial Science, Statistics, Computer Science, or IT, with basic programming skills and proficiency in MS SQL, Power BI, and MS Office.

Qualifications

• Graduate of a 4-year course in BS Mathematics, Actuarial Science, Actuarial Mathematics, Statistics, Applied Statistics, Computer Science, or Information Technology.
• Basic programming skills.
• Knowledgeable in database applications such as MS SQL (SQL DBA, Stored Procedure, T-SQL, Scripting); experience with other RDBMS back-end is an advantage.
• Familiarity with Power BI and Reporting Service Tool is an advantage.
• Advanced hands‑on experience with MS Office applications, including Word, Excel (with Power Pivot), and PowerPoint.

Responsibilities

• Prepare reports for external clients such as Brokers and NBAs, and internal clients, including Account Management and Underwriting Departments.
• Generate reports ranging from standard to complex, based on client requests.
• Provide data used to monitor client utilization and payments.
• Support computation of experience refunds, loss ratios, renewal offers, and initial proposals for returning accounts.
• Assist in decision-making regarding renewals with Intellicare or Avega.

Skills

Basic programming

MS Office

Education

BS Mathematics / Actuarial Science / Statistics / Computer Science / IT

Tools

MS SQL

Power BI

Reporting Services

Job description

Intellicare Philippines is seeking an entry-level Data Analyst to prepare detailed membership and claims reports for external and internal clients. You will generate reports ranging from standard to complex and provide data to monitor client utilization and payments.

Requirements include a BS in Mathematics, Actuarial Science, Statistics, Computer Science, or IT, with basic programming skills and proficiency in MS SQL, Power BI, and MS Office.