We are seeking a Junior Report Writer to support our Shared Services team. This role focuses on data integrity and operational reporting, specifically regarding Accounts Payable (AP) validation and payroll metrics. You will report directly to the Manager of Shared Services.
Key Responsibilities
- AP Validation & Reporting: Generate and maintain reports to validate Accounts Payable data, ensuring accuracy in vendor billing, payment processing, and ledger entries.
- Payroll & Attendance: Produce payroll distribution reports and track timekeeping exceptions, such as missed punches and overtime.
- Data Integrity: Audit system inputs to ensure consistency between AP, payroll, and timekeeping records.
- Process Automation: Leverage advanced Excel skills to streamline manual validation workflows and improve reporting efficiency.
Required Skills & Qualifications
- Advanced Excel: Expertise in Pivot Tables, XLOOKUP/INDEX-MATCH, and creating error-checking formulas for data validation.
- Foundational Accounting: Basic understanding of the AP cycle and payroll processing.
- Analytical Mindset: High attention to detail with the ability to identify anomalies in high-volume data sets.
- Systems: Experience with Microsoft Dynamics or similar ERP environments.
Preferred Experience
- Data Visualization: Proficiency in Power BI for building automated operational dashboards.
- Shared Services: Experience working in a centralized back-office or shared services environment.
