Finance Automation Specialist

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.