Finance Automation Engineer

Coherent Corp.; George Town; Hybrid; MYR 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Coherent Corp. Malaysia is seeking an Automation Analyst to develop and optimize finance workflows. You will build automation solutions using Excel VBA/Macros, Power Automate, Power Apps, and Power BI to automate reporting, data consolidation, and KPI tracking.

You will collaborate with finance and IT stakeholders, gather requirements, and deliver end-to-end automation. A Bachelor's degree and at least 2 years in finance analytics or process automation are required, with hybrid work arrangements

Qualifications

• Bachelor’s degree in IT/Finance/Analytics or related field.
• Minimum 2 years of relevant experience in finance systems, data analytics, automation, or process improvement.
• Experience with both finance operations and IT-enabled solutions is a plus.

Responsibilities

• Develop automation solutions using Excel VBA/Macros and JavaScript to automate financial reporting, data consolidation, transformations, and workflow processes.
• Collect, clean, and analyze data from multiple sources (e.g., CRM, finance, marketing) to generate actionable insights and support business decision-making.
• Develop intuitive dashboards using Power BI, Excel, and Power Platform tools to track KPIs for management reporting.
• Build and maintain workflow automation using Power Automate, including approvals, journal postings, reconciliations, and reporting processes.
• Develop finance-focused applications using Power Apps for expense tracking, data submission, and performance dashboards.
• Redesign and optimize existing workflows to reduce manual effort, bottlenecks, and improve speed, accuracy, and operational efficiency across finance, sales, and support functions.
• Provide post-deployment support for automation and reporting solutions, ensuring stability, issue resolution, and continuous improvement.
• Collaborate with finance and business stakeholders to gather requirements and deliver end-to-end automation.

Skills

Excel VBA

Power Automate

Power Apps

Power BI

SharePoint

Finance processes

Problem solving

Education

Bachelor’s degree

Tools

Oracle APEX

Dataverse

SQL

Job description

Coherent Corp. Malaysia is seeking an Automation Analyst to develop and optimize finance workflows. You will build automation solutions using Excel VBA/Macros, Power Automate, Power Apps, and Power BI to automate reporting, data consolidation, and KPI tracking.

You will collaborate with finance and IT stakeholders, gather requirements, and deliver end-to-end automation. A Bachelor's degree and at least 2 years in finance analytics or process automation are required, with hybrid work arrangements