Power BI FP&A Analyst & Developer: Dashboards & Forecasts

Agilent Technologies, Inc.; Malaysia; Hybrid; MYR 90,000 - 150,000; Full time

Job summary

Agilent Technologies, Inc. seeks a highly motivated Power BI Developer to support financial analytics within the Finance FP&A team.

You will design, develop, and maintain interactive dashboards and reports that empower leaders with data-driven insights across Orders, Revenue, P&L, and operational metrics. The role requires strong Power BI expertise, data modelling, DAX, and experience integrating SAP, Snowflake, Fabric, and SQL sources.

Qualifications

• 5–8 years of experience in Business Intelligence / Analytics role.
• 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.
• Strong analytical mindset with attention to detail and data accuracy.
• Excellent communication skills with ability to interact across global teams.

Responsibilities

• Act as a business analytics partner to Finance and business teams, understanding reporting requirements and translating them into Power BI solutions.
• Design and develop interactive dashboards and reports using Power BI to support Orders, Revenue, Shipments, Backlog, and P&L analytics.
• Build and optimize data models, including relationships, calculated columns, and DAX measures (cumulative, variance, forecast vs actuals).
• Develop automated reporting frameworks ensuring consistency, scalability, and reduced manual effort.
• Integrate data from multiple sources (SAP ECC, SAP HANA, Snowflake, Fabric, Excel, etc.) into Power BI datasets.
• Ensure data accuracy, validation, and reconciliation with source systems.
• Create executive-level dashboards with clear storytelling, KPIs, and drill-down capabilities.
• Collaborate with IT and Data Engineering teams for data pipeline and architecture alignment.
• Improve performance of reports (query optimization, incremental refresh, model tuning).
• Support forecasting and variance analysis through data visualization and insights.
• Drive standardization and automation of reporting across business units.
• Provide user training and documentation for Power BI reports and dashboards.

Skills

Analytical mindset

Attention to detail

Communication skills

Global collaboration

Education

Bachelor’s / Master’s Degree in Engineering / Computer Science

Tools

Power BI

SQL

Excel (Power Query)

DAX Studio

Tabular Editor

Power Query (M language)

Job description

Agilent Technologies, Inc. seeks a highly motivated Power BI Developer to support financial analytics within the Finance FP&A team.

You will design, develop, and maintain interactive dashboards and reports that empower leaders with data-driven insights across Orders, Revenue, P&L, and operational metrics. The role requires strong Power BI expertise, data modelling, DAX, and experience integrating SAP, Snowflake, Fabric, and SQL sources.