Junior Data Analyst, Healthcare

Who we are:

Pillai Investment Partners is a fee-only advisory practice with two advisors, a paraplanner and an office manager. Founded in 1973 by an advisor who left a large brokerage to go independent. The office closes early the day before major holidays.

Position summary:

The person in this role is relocating, so we are hiring a replacement. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. Pillai Investment Partners is hiring for the Junior Data Analyst, Healthcare role to answer business questions with data and turn the answers into reports people actually use. This role is remote. You will need a reliable internet connection and a quiet place to work.

Key responsibilities:

• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Define metric logic with stakeholders and document it
• Build and maintain dashboards in Tableau, Power BI or Looker
• Field ad hoc requests through a ticket queue and prioritise them with your manager
• Prepare weekly and monthly KPI reports for department leads
• Track sales, inventory or service levels against targets and flag misses early

About you:

• 0-2 years of experience in a data or reporting analyst role
• Experience with at least one BI tool such as Tableau, Power BI or Looker
• Strong SQL (joins, CTEs, aggregations, window functions)

Desirable:

• Tableau Desktop Specialist or Microsoft PL-300 certification

Why work with us:

Salary: MYR 4,200-MYR 5,000 pcm

• Annual leave
• Flexible benefits
• Medical and dental coverage
• Training budget

Candidates must be eligible to work in Malaysia.

Applications are reviewed on a rolling basis.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Pillai Investment Partners.