M

Executive/Senior Executive - Data Analyst

MR DIY International Subang Jaya City Council, Selangor, Malaysia

9 h ago
data-analyst Junior (0-2 yrs) Full-time Malaysia
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The role involves extracting, cleaning, and validating data from databases to support operational reporting and decision-making. Additionally, the analyst will develop dashboards, automate workflows, and assist in system implementation and process improvements.

What they look for

SQL Data Analysis Power BI Microsoft Excel VBA JavaScript Google Apps Script Data Validation Reporting Dashboard Development Root Cause Analysis Workflow Automation Process Improvement User Acceptance Testing Analytical Thinking Communication

Requirements

Candidates must hold a Diploma or Bachelor’s degree in a relevant field such as Data Analytics, Computer Science, or IT. Proficiency in SQL, Microsoft Excel, Power BI, and basic JavaScript is required, along with strong analytical and communication skills.

Full description

Key Responsibilities:

  • Extract, query, and validate data from databases using SQL to support operational and management reporting.
  • Prepare, clean, and consolidate data from multiple sources, ensuring accuracy and consistency.
  • Analyze inventory and warehouse capacity data to identify trends, gaps, and operational issues, and perform root cause analysis for ad-hoc problems.
  • Translate complex data into clear, actionable insights to support operational and management decision-making.
  • Develop, maintain, and enhance dashboards and reports using data visualization tools such as Power BI to monitor performance and track key operational metrics.
  • Support system implementation and enhancement initiatives by assisting with requirements clarification, data validation, user acceptance testing (UAT), and documentation.
  • Assist in workflow automation and process improvements to reduce manual effort, automate repetitive tasks, and improve operational efficiency.

Requirements :

  • Diploma or Bachelor’s Degree in Data Analytics, Business Analytics, Computer Science, Information Technology, or related fields.
  • SQL: Basic to intermediate proficiency for data extraction, querying, and reporting.
  • Microsoft Excel: Proficient with advanced formulas and basic VBA for automation.
  • Power BI: Experience in dashboard development, reporting, and performance tracking.
  • JavaScript: Basic knowledge for scripting, automation, and system integration (primarily in Google Apps Script). Soft-skills and Competencies
  • Strong analytical thinking with high attention to detail and commitment to data accuracy.
  • Clear and effective communication, with the ability to adapt and learn quickly in a fast-paced environment.
  • Self-motivated with ability to manage multiple priorities and projects simultaneously
  • Collaborative team player with a proactive problem-solving mindset

Similar roles