Accounting ERP Reporting Analyst

The Accounting ERP Data Analyst plays a dual role in managing ERP master data and supporting various accounting functions. This position ensures the accuracy and integrity of ERP data, collaborates with multiple departments to streamline processes, and provides key insights through data analysis and reporting. Additionally, the role assists with cost accounting, inventory management, and financial analysis to support budgeting, forecasting, and decision-making efforts. The Analyst bridges IT and accounting functions to enhance operational efficiency and ensure compliance with data governance and regulatory standards.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

1. Data Management and Quality Assurance

• Maintain and update ERP master data, including customers, vendors, items, and financial data.
• Conduct data audits to ensure accuracy and completeness.
• Clean and standardize data for improved reporting and analysis.

2. Cross-Functional Collaboration

• Work with accounting, finance, procurement, and IT teams to meet data needs.
• Assist with integrating ERP data into financial and operational systems.
• Train users on ERP tools and data management best practices.

3. Accounting and Financial Analysis

• Support cost accounting by analyzing product costs and variances.
• Assist with inventory reconciliations, valuations, and reporting.
• Contribute to monthly and quarterly financial closings and reports.
• Help manage accounts payable, receivable, and general ledger data.

4. Budgeting, Forecasting, and Reporting

• Provide data for budgeting, forecasting, and financial planning.
• Create dashboards and reports to track performance and trends.
• Analyze financial data to identify insights for decision-making.

5. Data Governance and Compliance

• Ensure data standards and consistency across the ERP system.
• Support compliance with privacy and regulatory requirements.
• Develop and enforce data governance policies.

6. ERP System and Project Support

• Assist with ERP system upgrades, implementations, and migrations.
• Ensure accurate financial data mapping during system transitions.
• Collaborate with IT to improve ERP functionality for accounting needs.

7. Process Improvement

• Identify opportunities to streamline data and accounting workflows.
• Develop tools to simplify financial analysis and reporting.
• Stay updated on accounting and ERP system best practices.

SKILLS AND QUALIFICATIONS:

Bachelor s degree in Accounting, Information Technology, Data Management, Business Administration, or a related field.

5 years of experience in ERP data management and accounting functions, including cost accounting or inventory analysis.

Knowledge of ERP systems (Workday, Oracle, Microsoft Dynamics, etc.) and data structures.

Proficiency in Excel and financial analysis tools (Power BI, SQL, etc.)

Strong analytical, problem-solving, and communication skills.

Ability to balance multiple tasks and projects effectively.