Assistant Manager & Business Intelligence Analyst

Caring Pharmacy Retail Management Sdn Bhd; Klang City; On-site; MYR 80,000 - 100,000; Full time

Job summary

A retail management company in Klang City is seeking an Assistant Manager, Business Intelligence Analyst to develop and implement data solutions that answer business queries. Candidates must have strong SQL skills, experience with Looker Studio, and the ability to produce actionable insights through effective dashboards. The role necessitates a minimum of 4 years’ experience in a similar capacity, emphasizing problem-solving and data accuracy. This position ensures that key business insights are communicated effectively to stakeholders.

Qualifications

• Strong proficiency in SQL and familiar with BigQuery syntax.
• Hands-on experience with Looker Studio or ability to learn similar tools.
• At least 4 years of relevant experience handling data.

Responsibilities

• Write efficient SQL queries in BigQuery to extract necessary data.
• Troubleshoot data discrepancies to ensure report accuracy.
• Manage data views for optimized dashboard performance.

Skills

SQL (BigQuery syntax)

Visualization with Looker Studio

Advanced proficiency in Excel

Problem Solving

Understanding of data discrepancies

Tools

Python

Power BI

Tableau

Job description

Assistant Manager, Business Intelligence Analyst

Responsibilities and required skills for this role include designing and implementing data solutions to answer business questions, ensuring data accuracy, and delivering actionable insights through dashboards and reports.

Responsibilities

• 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.
• 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.

Requirements / Qualifications

• Technical Skills
• SQL (Must Have): Strong proficiency in SQL (BigQuery syntax). Comfortable with Joins, Aggregations, Window Functions, and UNNEST.
• Visualization: Hands-on experience with Looker Studio; experience with Power BI or Tableau is also acceptable if you can adapt.
• Excel: Advanced proficiency in spreadsheet functions.
• Experience & Mindset
• Minimum 4 years of experience.
• 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.

Notes

The original description contained additional, non-essential sections (e.g., company history, extraneous prompts, and unrelated job listings). The refined version focuses on role responsibilities and requirements relevant to the BI Analyst position.