Power BI Finance Analytics Lead

agilent; Penang; On-site; MYR 120,000 - 180,000; Full time

Job summary

Agilent seeks a Power BI Developer to strengthen our Finance FP&A analytics. You will design, build, and maintain interactive dashboards and reports that translate business requirements into actionable insights across Orders, Revenue, and P&L.

You will collaborate with IT and Data Engineering to ensure scalable data models and reliable data integrity. The role requires deep Power BI expertise, data modelling, and strong communication skills to partner with global finance teams.

Qualifications

• Bachelor’s/Master’s Degree in Engineering (B-Tech/M-tech in Computer Science) or Master’s in Computer Applications (BCA+MCA).
• 5–8 years of experience in Business Intelligence / Analytics roles.
• Strong hands‑on experience in Power BI (mandatory).
• Data modelling and Power Query (M language).
• Advanced DAX, DAX Studio, Tabular Editor.
• Experience with financial data (Revenue, Orders, P&L) preferred.
• Knowledge of data sources such as SAP ECC, SAP HANA, Snowflake, Fabric, SQL databases.
• Proficiency in SQL and Excel (Power Query).
• Experience in building enterprise dashboards and executive reporting solutions.

Responsibilities

• Act as a business analytics partner to Finance and business teams, translating requirements into Power BI solutions.
• Design and develop dashboards and reports using Power BI for Orders, Revenue, Shipments, Backlog, and P&L analytics.
• Build and optimize data models, relationships, calculated columns, and DAX measures.
• Develop automated reporting frameworks for consistency, scalability, and reduced manual effort.
• Integrate data from SAP ECC, SAP HANA, Snowflake, Fabric, Excel, and more into Power BI datasets.
• Ensure data accuracy, validation, and reconciliation with source systems.
• Create executive dashboards with storytelling, KPIs, and drill-down capabilities.
• Collaborate with IT and Data Engineering for data pipeline and architecture alignment.
• Improve performance via query optimization, incremental refresh, and model tuning.
• Provide user training and documentation for Power BI reports and dashboards.

Skills

Analytical mindset

Communication skills

Team collaboration

Education

Bachelor’s/Master’s in Engineering/CS/MCA

Tools

Power BI

DAX Studio

Tabular Editor

SQL

Excel

SAP ECC

SAP HANA

Snowflake

Fabric

Job description

Agilent seeks a Power BI Developer to strengthen our Finance FP&A analytics. You will design, build, and maintain interactive dashboards and reports that translate business requirements into actionable insights across Orders, Revenue, and P&L.

You will collaborate with IT and Data Engineering to ensure scalable data models and reliable data integrity. The role requires deep Power BI expertise, data modelling, and strong communication skills to partner with global finance teams.