Power BI Specialist

Marco Payroll; Kuala Lumpur; On-site; MYR 60,000 - 80,000; Full time

Job summary

A leading payroll solutions provider in Kuala Lumpur seeks a Power BI Specialist to design, develop, and maintain reports and dashboards that inform business decisions. This role requires strong skills in DAX, Power Query, and adequate experience in connecting to databases and cloud services. The ideal candidate will help translate business requirements into actionable insights through visualizations and share data-driven strategies to improve payroll and HR processes.

Qualifications

• Minimum 3 years of experience working with Microsoft Power BI.
• Strong understanding of data warehousing and ETL processes.
• Familiarity with Power BI Service functionalities.

Responsibilities

• Design and maintain interactive Power BI dashboards and reports.
• Connect Power BI to various data sources including SQL and cloud platforms.
• Implement security measures and optimize data performance.

Skills

DAX

Power Query (M)

Data visualization techniques

Data analysis

Education

Bachelor's degree in Computer Science, Data Science, Information Systems, or related field

Tools

SQL Server

MySQL

PostgreSQL

Power BI

Job description

The Power BI Specialist is responsible for designing, developing, and maintaining insightful dashboards and reports that support data-driven business decisions. This role involves close collaboration with stakeholders to translate business requirements into actionable insights through dynamic visualizations. The specialist will connect to various data sources, build efficient data models, and implement security measures and performance optimization strategies to ensure reliable and scalable reporting solutions.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports for internal and client-facing use cases.
• Connect Power BI to diverse data sources, including relational databases (SQL Server, MySQL, PostgreSQL), cloud platforms (Azure, AWS, Google Cloud), REST APIs, and on-prem data gateways.
• Build scalable, high-quality data models using DAX, Power Query (M), and dimensional modeling best practices.
• Perform advanced data preparation and ETL operations—leveraging strong understanding of data structures, relationships, and transformation logic to extract the correct fields, design accurate joins, and ensure reliable modeling.
• Implement row-level security (RLS), dataset governance, and performance optimization techniques for efficient refresh and rendering.
• Work with business stakeholders to understand requirements—particularly around payroll, compensation, and employee datasets—and convert them into BI specifications and solutions.
• Conduct rigorous data validation to ensure calculated metrics and model outputs match source systems and payroll business rules.
• Develop scalable BI templates and reusable components to streamline customer onboarding and reporting consistency.

Required Qualifications

• Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
• Minimum 3 years of experience working with Microsoft Power BI in a professional setting.
• Strong knowledge of DAX, Power Query (M), and advanced visualization techniques.
• Solid understanding of data warehousing, dimensional modeling, and ETL processes.
• Familiarity with Power BI Service (workspaces, gateways, sharing, security settings).

1. Relational Databases (SQL Server, MySQL, PostgreSQL)
2. Web APIs / JSON (via Power BI's Web connector or Power Automate)

Preferred Skills & Experience

• Knowledge of Microsoft Power Platform (Power Apps, Power Automate) integration is a plus.
• Familiarity with scripting languages like Python for data preparation.