FP&A Power BI Analyst & Dashboard Developer

Agilent; Malaysia; On-site; MYR 180,000 - 300,000; Full time

Job summary

Agilent's Finance team seeks a highly motivated Power BI Developer to design, develop, and maintain dashboards supporting Orders, Revenue, and P&L analytics. You will translate Finance and FP&A requirements into scalable reporting solutions and collaborate with IT and Data Engineering for robust pipelines.

You will build data models, optimize performance, and deliver automated, accurate reporting with executive-ready storytelling across Finance and business units.

Qualifications

• Bachelor's or Master's in Engineering or MCA is required.
• 5-8 years in Business Intelligence / Analytics.
• Strong Power BI experience is mandatory.
• Proficient in data modelling and Power Query (M language).
• Advanced DAX, DAX Studio and Tabular Editor skills.
• Experience with financial data (Revenue, Orders, P&L) preferred.
• Knowledge of SAP ECC, SAP HANA, Snowflake, Fabric and SQL databases.
• Proficient in SQL and Excel (Power Query).
• Experience building enterprise dashboards and executive reporting.

Responsibilities

• Act as a business analytics partner to Finance and business teams, translating requirements into Power BI solutions.
• Design and develop dashboards and reports 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 and scalability.
• 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 pipelines and architecture alignment.
• Improve performance via query optimization and incremental refresh.
• Support forecasting and variance analysis through data visualization.
• Drive standardization and automation of reporting across business units.
• Provide user training and documentation for Power BI reports and dashboards.

Skills

Analytical mindset

Communication skills

Attention to detail

Education

Bachelor's / Master's Degree in Engineering / MCA

Tools

Power BI

SQL

Excel

Power Query (M language)

DAX

DAX Studio

Tabular Editor

SAP ECC

SAP HANA

Snowflake

Fabric

SQL databases

Job description

Agilent's Finance team seeks a highly motivated Power BI Developer to design, develop, and maintain dashboards supporting Orders, Revenue, and P&L analytics. You will translate Finance and FP&A requirements into scalable reporting solutions and collaborate with IT and Data Engineering for robust pipelines.

You will build data models, optimize performance, and deliver automated, accurate reporting with executive-ready storytelling across Finance and business units.