Senior Accounts Payable Specialist

Responsibilities

• Collaborate with the Data Management team to understand data mapping, conversion strategies, and business rules specific to Finance, ensuring alignment with GAAP principles.
• Execute data transformation scripts using tools such as Excel, Access, SQL, and Python to support data migration to the new ERP system.
• Utilize advanced Excel skills to create reconciliations and perform detailed validations between legacy system data and the new ERP for mock data conversions and cutover.
• Cleanse, standardize, and validate financial data to ensure quality, consistency, and regulatory compliance across all relevant datasets.
• Identify, investigate, and resolve data discrepancies and anomalies, working closely with stakeholders to determine root causes and implement corrective actions.
• Translate business requirements into clear, actionable data-related tasks and solutions that support Finance reporting and operational needs.
• Communicate technical data concepts, findings, and recommendations effectively to both technical and non-technical audiences.
• Support system testing and user acceptance testing (UAT) activities related to data migration and data transformations, including test execution and issue tracking.
• Document data transformation, mapping, and conversion processes and procedures to ensure transparency, repeatability, and knowledge sharing.
• Assist in data cleansing activities and design approaches to improve efficiency and scalability of cleansing efforts.
• Contribute to the successful implementation of a Finance SaaS ERP system, particularly within General Ledger and Accounts Payable areas.
• Manage multiple data-related tasks and priorities independently while maintaining high standards of accuracy and timeliness.

Essential Skills

• Strong experience with a Finance SaaS ERP implementation, particularly in data conversion, cleansing, and transformation.
• Fundamental understanding of Finance functions and reporting, including General Ledger and Accounts Payable.
• Experience in data mapping, data analysis, data transformation, or data quality initiatives.
• Proficiency in Microsoft Excel with advanced skills in formulas, functions, and macros.
• Experience with data manipulation tools such as Excel, Access, SQL, and Python.
• Strong analytical and problem-solving skills with attention to detail and data accuracy.
• Excellent communication and collaboration skills, with the ability to explain technical concepts to non-technical stakeholders.
• Ability to work independently and manage multiple priorities effectively in a dynamic project environment.

Additional Skills & Qualifications

• Bachelor's degree in Accounting, Finance, Business Administration, or a related field.
• Experience working with ERP systems in a Finance context.
• Workday experience is a plus.
• Premier and PeopleSoft data extraction experience is a plus.
• Experience supporting UAT testing and implementation activities.
• Familiarity with purchase order data and related finance processes is beneficial.