Assistant Manager, Business Intelligence Analyst

CARiNG Pharmacy; Klang City; On-site; MYR 90,000 - 120,000; Full time

Job summary

Jora Malaysia is seeking an Assistant Manager, Business Intelligence Analyst to extract data, manage sources, and create actionable dashboards. You will translate complex datasets into clear visuals for non-technical stakeholders and respond to management requests with timely insights.

The role emphasizes SQL proficiency (BigQuery), dashboarding with Looker Studio, and strong Excel skills, with bonus familiarity in Python for advanced analytics.

Qualifications

• 3+ years of experience in BI analytics or data analysis.
• Strong SQL skills with BigQuery familiarity and data modeling.
• Ability to design dashboards and communicate insights clearly.

Responsibilities

• Extract data and manage data sources using SQL for dashboards.
• Design, build, and maintain interactive dashboards with Looker Studio.
• Respond to ad-hoc data requests and highlight trends or risks.
• Optionally apply Python for advanced analytics or forecasting.

Skills

SQL (BigQuery)

Looker Studio

Excel

Tools

Power BI

Tableau

Job description

Jora Malaysia will close on 16th September 2026. Thank you for being with us, we are cheering you on as you continue your career journey.

Assistant Manager, Business Intelligence Analyst

Duties & Responsibilities:

1. Data Extraction & Management (SQL)

Write efficient, optimized SQL queries in BigQuery to extract the exact data needed for specific business questions.

Troubleshoot data discrepancies between raw source systems and final reports to ensure accuracy.

Manage data tables and views to ensure dashboards load quickly and consistently.

Design, build, and maintain interactive dashboards using Looker Studio.

Transform complex datasets into clear, user-friendly charts and tables that non-technical stakeholders can understand at a glance.

Regularly update and refine existing reports based on business feedback.

3. Business Analysis

Respond to ad-hoc data requests from management (e.g., sales performance, inventory tracking, cost analysis).

Proactively identify trends, anomalies, or risks in the data and highlight them to the relevant teams.

4. Advanced Analytics (Bonus)

If capable: Utilize Python for advanced statistical analysis, forecasting, or automating repetitive data tasks.

Job Requirements:

Technical Skills

SQL (Must Have): Strong proficiency in SQL (specifically BigQuery syntax). You must be comfortable with Joins, Aggregations, Window Functions, and UNNEST.

Visualization: Hands-on experience with Looker Studio is highly preferred. Experience with Power BI or Tableau is also acceptable if you are willing to adapt.

Excel: Advanced proficiency in spreadsheet functions.

Experience & Mindset

Senior Executive: 3+ years of experience. Must demonstrate the ability to solve vague business problems independently and design scalable data solutions.

Problem Solving: A natural curiosity to ask "why" when numbers look wrong, rather than just reporting them.

Be careful - Don't provide your bank or credit card details when applying for jobs. Don't transfer any money or complete suspicious online surveys. If you see something suspicious, report this job ad .