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