Power BI Analyst/ 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

Job Description

Agilent inspires and supports discoveries that advance the quality of life. We provide life science, diagnostics and applied market laboratories worldwide with instruments, software, services, consumables and expertise. Agilent enables customers to gain the answers and insights they seek - so they can do what they do best: improve the world around us.

This is an exciting opportunity to join Agilent's Finance team within the Financial Planning and Analysis function. The team plays a critical role that helps leadership make strategic business decisions by evaluating financial data, forecasting future performance, and managing budgets.

About the Role:

We are seeking a highly motivated and detail-oriented Power BI Developer to support financial and business analytics initiatives. The role involves designing, developing, and maintaining interactive dashboards and reports that provide actionable insights to stakeholders across Finance, FP&A, and Business functions. The candidate will work closely with business teams to translate requirements into scalable reporting solutions, enabling data-driven decision-making.

Your key responsibilities will include:

• 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.

Qualifications

• Bachelor's / Master's Degree in Engineering (B-Tech / M-tech in Computer Science), Master's in Computer Applications (BCA+MCA).
• 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.

Preferred Skills

• Experience working in Finance analytics environment.
• Exposure to Fabric / Azure / Lakehouse architectures.
• Understanding of advanced Dax and Tabular Editor.
• Knowledge of other BI tools (Spotfire, Tableau, etc.).

Additional Details

This job has a full time weekly schedule.

Our pay ranges are determined by role, level, and location. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. During the hiring process, a recruiter can share more about the specific pay range for a preferred location. Pay and benefit information by country are available at: https://careers.agilent.com/locations

Agilent Technologies Inc. is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other protected categories under all applicable laws.

Travel Required: No

Shift: Day

Duration: No End Date

Job Function: Finance