Finance Automation Engineer (Hybrid)

COHERENT; Penang; Hybrid; MYR 36,000 - 42,000; Full time

Job summary

Coherent Corp. in Penang, Malaysia, is seeking a Finance Automation Specialist to design and deliver automated finance reporting, data integration, and KPI dashboards.

You will leverage Excel VBA, Power Automate, Power Apps, and Power BI to streamline processes across finance, sales, and support. The role requires a minimum of 2 years in finance systems or data analytics, with strong problem-solving and collaboration with stakeholders.

Qualifications

• Bachelor’s degree in Information Technology, Finance, Accounting, Business Analytics, or a related discipline.
• Minimum 2 years of relevant experience in finance systems, data analytics, process automation, or business process improvement (or equivalent functional/technical experience).
• Exposure to both finance operations and IT-enabled solutions (e.g., automation, reporting systems, or data platforms) is an advantage.

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 key performance indicators (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, eliminate 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 closely with finance and business stakeholders to gather requirements, translate them into technical solutions, and deliver end-to-end automation.

Skills

Excel VBA

Power Automate

Power Apps

Power BI

SharePoint

Finance processes

Journal entries

Budgeting

Data analytics

Education

Bachelor's degree

Tools

Oracle APEX

Oracle ERP (FBDI/ADFDI)

Dataverse/SQL

Job description

Coherent Corp. in Penang, Malaysia, is seeking a Finance Automation Specialist to design and deliver automated finance reporting, data integration, and KPI dashboards.

You will leverage Excel VBA, Power Automate, Power Apps, and Power BI to streamline processes across finance, sales, and support. The role requires a minimum of 2 years in finance systems or data analytics, with strong problem-solving and collaboration with stakeholders.