SNI Companies
Overview
Payroll Year-End Support Specialist (Excel & Power Query Expert) – Remote, Contract. We are seeking a highly detail-oriented candidate with advanced Microsoft Excel, Power Query/SQL, and union reporting experience to assist our payroll shared services during the crucial year-end process. The successful candidate will help reconcile payroll data, prepare reports, support union reporting requirements, and assist with data management. Base pay range $43.00/hr - $46.00/hr Direct message the job poster from SNI Companies About the Role Role involves reconciling payroll data, preparing reports, supporting union reporting requirements, and ensuring compliance and accuracy during year-end activities. Key Responsibilities
Support the payroll department during year-end activities, including data validation, reconciliation, and reporting. Utilize advanced Excel functions such as pivot tables, VLOOKUP, SUMIF, Power Query, and data modeling to consolidate, cleanse, and analyze large data sets. Assist in preparing, reviewing, and validating payroll reports for year-end configuration. Leverage Power Query to manage and support union payroll reporting requirements, ensuring accurate data extraction, transformation, and compliance. Maintain and update wage and fringe rates in the master payroll file to ensure compliance with union requirements. Regularly update union wage rate sheets used by managers for project quoting and planning. Communicate and collaborate with company representatives to distribute updated wage rate sheets and inform relevant parties of changes. Review payroll SOX (Sarbanes-Oxley) controls with companies to ensure compliance, accuracy, and proper documentation of payroll processes. Work closely with payroll, HR, and finance teams to resolve discrepancies and provide data-driven insights. Qualifications/Requirements
Experience in payroll, finance, data analysis, or a related field. Experience with union payroll reporting and compliance requirements. Exceptional proficiency in Microsoft Excel (including pivot tables, complex formulas, data visualization). Proven experience using Power Query/SQL for data extraction and transformation. Strong attention to detail, analytical, and problem-solving skills. Ability to work efficiently under tight deadlines and manage sensitive payroll information securely. Excellent communication skills and ability to collaborate with cross-functional teams. Knowledge of payroll best practices, year-end reporting requirements, and union payroll regulations. Experience with other payroll platforms or HRIS systems is an advantage. Benefits
Medical insurance Vision insurance 401(k) Disability insurance Paid maternity leave Get notified when a new job is posted.
#J-18808-Ljbffr
Payroll Year-End Support Specialist (Excel & Power Query Expert) – Remote, Contract. We are seeking a highly detail-oriented candidate with advanced Microsoft Excel, Power Query/SQL, and union reporting experience to assist our payroll shared services during the crucial year-end process. The successful candidate will help reconcile payroll data, prepare reports, support union reporting requirements, and assist with data management. Base pay range $43.00/hr - $46.00/hr Direct message the job poster from SNI Companies About the Role Role involves reconciling payroll data, preparing reports, supporting union reporting requirements, and ensuring compliance and accuracy during year-end activities. Key Responsibilities
Support the payroll department during year-end activities, including data validation, reconciliation, and reporting. Utilize advanced Excel functions such as pivot tables, VLOOKUP, SUMIF, Power Query, and data modeling to consolidate, cleanse, and analyze large data sets. Assist in preparing, reviewing, and validating payroll reports for year-end configuration. Leverage Power Query to manage and support union payroll reporting requirements, ensuring accurate data extraction, transformation, and compliance. Maintain and update wage and fringe rates in the master payroll file to ensure compliance with union requirements. Regularly update union wage rate sheets used by managers for project quoting and planning. Communicate and collaborate with company representatives to distribute updated wage rate sheets and inform relevant parties of changes. Review payroll SOX (Sarbanes-Oxley) controls with companies to ensure compliance, accuracy, and proper documentation of payroll processes. Work closely with payroll, HR, and finance teams to resolve discrepancies and provide data-driven insights. Qualifications/Requirements
Experience in payroll, finance, data analysis, or a related field. Experience with union payroll reporting and compliance requirements. Exceptional proficiency in Microsoft Excel (including pivot tables, complex formulas, data visualization). Proven experience using Power Query/SQL for data extraction and transformation. Strong attention to detail, analytical, and problem-solving skills. Ability to work efficiently under tight deadlines and manage sensitive payroll information securely. Excellent communication skills and ability to collaborate with cross-functional teams. Knowledge of payroll best practices, year-end reporting requirements, and union payroll regulations. Experience with other payroll platforms or HRIS systems is an advantage. Benefits
Medical insurance Vision insurance 401(k) Disability insurance Paid maternity leave Get notified when a new job is posted.
#J-18808-Ljbffr