Senior Power BI Developer - Fintech

OX Human Resources Consultancies; Kuala Lumpur; On-site; MYR 60,000 - 100,000; Full time

Job summary

OX Human Resources Consultancies seeks a skilled Power BI Developer to design, build, and maintain dashboards that translate complex business data into clear visuals. You will work with stakeholders to confirm KPI definitions, data sources, and access controls, delivering scalable reporting solutions.

The role requires expert knowledge of Power BI Desktop/Service, DAX, Power Query, and SQL, with a focus on performance and actionable insights for management and operations.

Qualifications

• Strong data-visualization and dashboard design skills.
• Good stakeholder communication, project execution, and cross-functional collaboration skills.
• Proficiency in Power BI Desktop and Power BI Service.
• Strong working knowledge of DAX and Power Query.
• Proficiency in SQL with the ability to extract, integrate, and validate data.
• Understanding of fact tables, dimension tables, star schemas, and data-modelling principles.

Responsibilities

• Deliver production-ready Power BI dashboards within agreed timelines.
• Translate business requirements into clear data models and dashboard pages.
• Develop KPI definitions, calculations, and time intelligence using DAX.
• Design dashboard layouts, filters, interactions, and role-based access.
• Maintain and optimize dashboards for performance and user experience.
• Coordinate testing, deployment, and stakeholder sign-off.

Skills

Data visualization

Stakeholder communication

Project execution

Cross-functional collaboration

Tools

Power BI Desktop

Power BI Service

DAX

Power Query

SQL

Job description

• Design, develop, and maintain Power BI dashboards based on management and business requirements.
• Translate complex business data into clear, intuitive, and decision-oriented visualizations.
• Design dashboard layouts, KPI displays, filters, interactions, drill-down functionality, and role-based access.
• Develop and maintain standardized dashboard templates, visual guidelines, and development standards.
• Manage dashboard publishing, version control, scheduled refreshes, user access, and ongoing maintenance.
• Optimize dashboard performance, data-loading speed, and overall user experience.
• Continuously improve dashboards based on stakeholder feedback.

2. Data Processing and Data Modelling

• Connect to business systems, relational databases, and other relevant data sources.
• Use SQL to extract, integrate, aggregate, and validate data.
• Use Power Query to clean, transform, merge, and automate data processing.
• Design fact tables, dimension tables, star schemas, and relationships suitable for Power BI.
• Use DAX to develop KPIs, calculation logic, time intelligence, and analytical measures.
• Work with business stakeholders to confirm KPI definitions, calculation methodologies, data scope, and refresh frequency.
• Develop and maintain data dictionaries, metric definitions, and dashboard documentation.
• Identify missing, duplicated, inconsistent, or abnormal data and coordinate resolution with relevant stakeholders.

3. Requirements Management and Delivery

• Develop a clear development, testing, and deployment plan based on confirmed dashboard requirements.
• Work with business stakeholders to confirm business scenarios, user roles, metric logic, and acceptance criteria.
• Translate business requirements into clear data models, dashboard pages, and development tasks.
• Produce dashboard prototypes and complete development, testing, and production deployment based on feedback.
• Manage development progress, testing results, issue logs, and version changes.
• Coordinate user acceptance testing and track issues through to closure.
• Provide dashboard training, operating guidance, and go-live support.
• Monitor dashboard adoption, usage, and delivered business value.

4. Data Analysis and Business Insights

• Conduct trend, variance, conversion, and efficiency analysis using dashboard data.
• Support business teams in identifying operational issues, business changes, and improvement opportunities.
• Perform ad hoc analysis in response to specific management or business questions.
• Present clear and concise analytical findings, risk alerts, and business recommendations.
• Support periodic business reviews, management reporting, and special analytical projects.

Requirements

Essential Qualifications

• At least two years of hands‑on Power BI dashboard development experience.
• Strong proficiency in Power BI Desktop and Power BI Service.
• Strong working knowledge of DAX and Power Query.
• Proficiency in SQL, with the ability to independently extract, integrate, aggregate, and validate data.
• Understanding of fact tables, dimension tables, star schemas, and fundamental data‑modelling principles.
• Ability to independently manage the full dashboard development lifecycle, from requirement understanding and data preparation to deployment.
• Strong data‑visualization and dashboard design skills.
• Experience working with multiple data sources, complex relationships, and role‑based access controls.
• Strong attention to data accuracy, logical validation, and issue investigation.
• Good stakeholder communication, project execution, and cross‑functional collaboration skills.

Preferred Qualifications

• Experience in financial services, securities, foreign exchange, CFD, fintech, or another data‑intensive industry.
• Experience developing executive dashboards or management reporting solutions.
• Knowledge of Power BI Row‑Level Security, Gateway, Workspace, and permission management.
• Experience with large datasets, performance optimization, or incremental refresh.
• Familiarity with Python, advanced Excel, ETL tools, or data warehouses.
• Basic business‑analysis and data‑insight capabilities.
• Ability to read English‑language field definitions, technical documentation, and business materials.

Core Competencies

Dashboard delivery: Ability to deliver production‑ready dashboards within agreed timelines rather than remaining at the discussion or prototype stage.

Business understanding: Ability to understand the business logic behind metrics rather than simply visualizing available fields.

Data validation: Ability to verify data sources, calculation logic, relationships, and displayed results.

Data visualization: Ability to build clear, structured, and decision‑oriented dashboard layouts.

Communication: Ability to communicate effectively with non‑technical stakeholders regarding requirements, KPI definitions, acceptance criteria, and usage.

• Execution: Ability to manage multiple dashboard requirements and drive them through testing, deployment, and stable operation.