Assistant Manager & Business Intelligence Analyst

CARiNG Pharmacy; Klang City; On-site; MYR 80,000 - 110,000; Full time

Job summary

A retail pharmacy chain in Klang City is looking for an Assistant Manager, Business Intelligence Analyst. This role requires expertise in SQL, particularly BigQuery, to extract data for business needs and design insights through dashboards using tools like Looker Studio. Ideally, candidates should have at least 4 years of experience in business intelligence and a problem-solving mindset. The position offers the chance to work with complex datasets and provide valuable business insights.

Qualifications

• Strong proficiency in SQL with experience in BigQuery.
• Hands-on experience in data visualization tools like Looker Studio.
• Minimum 4 years of relevant experience in business intelligence.

Responsibilities

• Write efficient SQL queries to extract data for business questions.
• Ensure data accuracy between source systems and final reports.
• Design and maintain dashboards for quick and consistent data access.

Skills

SQL (BigQuery)

Data Visualization (Looker Studio)

Excel

Python (for advanced analytics)

Tools

Looker Studio

Power BI

Tableau

Job description

Assistant Manager, Business Intelligence Analyst

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.

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.

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

Minimum 4 years of experience.

Must demonstrate the ability to solve vague business problems independently and design scallable data solutions.

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