Payroll Accounting Analyst VIAJP00001145 A leading digital streaming network is seeking a Payroll Accounting Analyst. The candidate will perform moderately complex accounting activities and functions, including developing, preparing, and analyzing Excel-based reports, and preparing and supporting weekly and monthly reports. The ideal candidate will be an advanced user of Excel and ERP systems who has experience with union payroll reporting. The company offers a great work environment! Payroll Accounting Analyst Pay and Benefits: Hourly pay: $45/hr Worksite: Leading digital streaming network. (New York City, NY 10019 - Hybrid) W2 Employment, Group Medical, Dental, Vision, Life, Retirement Savings Program, PSL 40 hours/week, 5 Month Assignment Payroll Accounting Analyst Responsibilities: Develop, prepare, and analyze Excel-based reports from SAP ECP extracts, focusing on enhancing ECP reporting accuracy for union payments, contributions, and payroll GL reconciliations. Prepare and support weekly and monthly reporting for the division accounting departments, utilizing Excel for comprehensive data analysis and report creation. Generate ad hoc reports based on SAP ECP extracts to support the payroll, union, and finance team. Support data verification and troubleshoot errors in payroll earnings and dues for employees and employer contributions. Research and complete external union or union pension/health plan requests for employee information or verification of payments processed. Reconcile weekly union interface files and validate accuracy with completed union payment processes, resolving discrepancies as needed. Provide support for union audit data requests related to pension, health, or 401k employer contributions. Monthly reconciliation of union payroll balance sheet accounts. Support calculation of adjustments for union-related deductions and contributions on an ad hoc basis. Collaborate on special projects and assist with reporting initiatives to improve accuracy. Payroll Accounting Analyst Qualifications: 1-2+ years of experience in payroll reporting and analysis. Strong proficiency in advanced Excel functions, including demonstrated ease of use in pivot tables, formulas, finance formatting, and combining data sheets from multiple sources. Familiar with SAP EC Payroll or with a large-scale ERP desired. Experience in interpreting payroll results is desired. Experience with union payroll reporting. Must be detail-oriented with excellent analytical skills. Comfort with working in Zoom, and Teams, and the ability to train or review work in them. Ability to maintain strict confidentiality. Strong organizational, written, and verbal communication skills. Proactive with excellent follow-up skills. Ability to multi-task and work well under deadlines. Payroll Accounting Analyst Shift: 8:30 am-5:30 pm * Overtime at the end of the month or first week of the month for reporting deadlines
