Finance Automation Specialist

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

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

Job Description

Primary Duties & 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.

Education & Experience

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

Skill

Required:

• Strong experience in Excel VBA and financial reporting automation.
• Hands‑on experience with Power Automate in finance‑related workflows.
• Experience building Power Apps for finance or operational processes.
• Knowledge of Power BI for financial dashboards and reporting.
• Experience working with SharePoint for data management and automation integration.
• Solid understanding of finance processes, including general ledger, reconciliations, journal entries, budgeting, and reporting.
• Basic understanding of core finance principles and concepts.
• Strong problem‑solving skills and a process improvement mindset.

Preferred:

• Experience with Oracle APEX for application and workflow development.
• Familiarity with Oracle ERP processes, including FBDI (File‑Based Data Import) and ADFDI (ADF Desktop Integration) templates.
• Familiarity with Dataverse or SQL for financial data management.

Working Conditions

• Hybrid work arrangement.

Culture Commitment

Ensure adherence to company’s values (ICARE) in all aspects of your position at Coherent Corp.:

• Integrity – Create an Environment of Trust
• Collaboration – Innovate Through the Sharing of Ideas
• Accountability – Own the Process and the Outcome
• Respect – Recognize the Value in Everyone
• Enthusiasm – Find a Sense of Purpose in Work

Coherent Corp. is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.

About Us

Coherent is a global leader in lasers, engineered materials and networking components. We are a vertically integrated manufacturing company that develops innovative products for diversified applications in the industrial, optical communications, military, life sciences, semiconductor equipment, and consumer markets. Coherent provides a comprehensive career development platform within an environment that challenges employees to perform at their best, while rewarding excellence and hard‑work through a competitive compensation program. It's an exciting opportunity to work for a company that offers stability, longevity and growth. Come Join Us!

About The Team

Coherent Malaysia (formerly known as II‑VI Incorporated) began operations in 2001 through the incorporation of Finisar Malaysia with 300 headcounts, now employs over 3000 employees. Ipoh’s assembly and test site for optical components, transceivers, and wavelength management equipment, remains committed to the expansion of Coherent Corporation, accelerated by the growth of next generation products to meet the increasing demands for network bandwidth and data storage.

Coherent provides a comprehensive career development platform within an environment that challenges employees to perform at their best, while rewarding excellence and hard‑work through a competitive compensation program. It's an exciting opportunity to work for a company that offers stability, longevity and growth. Come Join Us!