Finance Automation Analyst (VBA Macro)

The Finance Automation Analyst will be responsible for supporting finance automation initiatives.

• Identify and prioritize - Collaborate with Finance and IT teams to identify automation and process optimization opportunities, and to prioritize the pipeline. Participate in discussions with stakeholders, assist in securing buy-ins / approvals and help in managing stakeholder expectations.
• Implementation and Maintenance – Conceptualize, design, ideate, build, test, implement automations and process automations using tools such as Excel, VBA, Tableau and Microsoft 365 power apps.
• Data Management – accountable for the quality, integrity, and security of Finance data within the automated tools.
• Training and User Support – provide training to Finance team members on how to use the tools effectively. Offer ongoing support to address any issues or questions related to these tools.
• Compliance and Controls – Ensure that finance automated process adhere to regulatory and company's policy requirements.
• Integration – Collaborate with PH BU IT, RO IT and Finance Enablement Team, and Corporate Finance Accelerator Team, and/or service providers for automation solutions which require system enhancements, use of robotic process automation (RPA), etc.

Qualifications:

• At least 2 years relevant experience
• Strong proficiency in Excel (VBA Macros)
• Alteryx experience is a big plus
• No need for programmers; focus is on process automation
• Background: Candidates can come from Finance, Accounting, or Audit backgrounds who transitioned into automation
• Non-accountants with strong finance automation experience also considered