AI-generated summary
RM 1000 - RM 1500
Subang, Selangor
Job Description
Build Power BI dashboards and maintain query scripts to extract, clean, and model data from the company database for reporting and decision-making.
Key responsibilities
- Write and maintain SQL queries (views/stored queries/scripts) to extract data from DB tables safely and efficiently.
- Understand the business questions (ops, sales, warehouse, finance) and translate them into report requirements and metrics.
- Build Power BI datasets: data modelling (star schema), relationships, calculated columns/measures (DAX), and refresh logic.
- Create dashboards and reports with drilldowns, filters, and clear definitions (metric logic, date logic, exclusions).
- Set up scheduled refresh (gateway if needed), monitor failures, and fix breaking changes when the DB schema shifts.
- Validate data accuracy: reconciliation against source tables and spot checks with stakeholders.
- Document everything: data dictionary, query notes, metric definitions, and refresh/runbook steps.
- Support ad hoc analysis requests and small automation tasks (export, parameterised queries, basic ETL improvements).
Job Requirements
Requirements
- Comfortable with SQL (joins, window functions, CTEs, grouping, date handling, performance basics).
- Power BI fundamentals: Power Query, data modelling, DAX measures, visuals, slicers, row-level logic (nice-to-have).
- Understands basic analytics hygiene: grain, duplicates, slowly changing attributes, null handling.
- Good communication: can explain numbers and assumptions, not just build charts.
Right to Work Requirements
- Candidates with an existing right to work in the country are preferred
- Local citizens of this country
- Permanent residents (PR) of this country
- Candidates who already have a work permit for this country
Working Arrangement
- On Site
Skills
Company Benefits
Leadership Growth
You! Yes, you matters to us. Every team member gets a Leadership program, that helps them grow significantly!
Health First
You will enjoy GP, Dental, Optical, TCM, Health Screening benefits.
Hybrid WFA
That's right : Work-From-Anywhere! Our Teams have the flexibility to organise their own WFA 2 days in a week.
Fly High
We're fast expanding our footprints in Asia. Make sure your passports are always ready and bags are packed to fly into one of our key markets.
People Happiness
We're dead serious when it comes to our People. Benefits includes, Unlimited PTO, EPF, SOCSO, Performance Bonus, Medical.
Additional Info
Company Activity
Last active - few minutes ago
Experience Level
#NoExperienceNeeded
Career Level
Internship
Job Specialisation
Company Profile
