Excel Spreadsheet Specialist for Payroll, Benefits, and Human Resources

$49,920 - $54,080/Yr

The Matian Firm Apc - Los Angeles, CA

Part-time - Entry Level

Remote - Los Angeles, CA

Professional, Scientific, and Technical Services

About the position

Our office is actively looking to hire an experienced Excel Spreadsheet Specialist that will be servicing our Payroll, Benefits, and Human Resources departments. This position must be staffed by an individual who is trustworthy, organized, and works well with people. Discretion and integrity are top priorities. The ideal candidate for this role must be able to interpret existing and incoming data using statistical techniques on Excel to provide continual reporting to department leads. The role involves identifying, analyzing, and interpreting trends and patterns in complex data sets on Excel. Experience in the area of Payroll and Benefits is highly preferred. The responsibilities of this position include participating in the auditing and processing of payroll forms, records, and documents. The candidate should have an expertise level of familiarity with computerized charting programs to produce spreadsheet reports. Additionally, the role requires participation in creating reports related to payroll, employee information, time sheets, benefits, salaries, leave, taxes, deductions, payments, and other assigned duties; reviewing, evaluating, and auditing payroll, health benefit changes, and related financial and statistical reports. The specialist will service the departments by creating reports and spreadsheets that allow reconciliation, utilizing Excel to create complex formulas and functions to analyze data, and auditing data to extract valuable insights to support decision-making processes. The individual will be responsible for creating reports and visualizations to communicate findings to departments and participate in the auditing of manual and automated payroll data, information, records, and reports to ensure accuracy and completeness of payroll transactions. The controller must ensure that the company's reported financial results comply with generally accepted accounting principles.

Responsibilities

• Participate in the auditing and processing of payroll forms, records, and documents.
• Create reports related to payroll, employee information, time sheets, benefits, salaries, leave, taxes, deductions, payments, and other assigned duties.
• Review, evaluate, and audit payroll, health benefit changes, and related financial and statistical reports.
• Create reports and spreadsheets that allow reconciliation for the departments.
• Utilize Excel to create complex formulas and functions to analyze data.
• Audit data to extract valuable insights and support decision-making processes.
• Create reports and visualizations to communicate findings to departments.
• Participate in auditing of manual and automated payroll data, information, records, and reports to ensure accuracy and completeness of payroll transactions.

Requirements

• Advanced knowledge of Excel with the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks.
• At least 6 months of experience with Payroll and Benefits.
• Solid written and verbal communication skills.
• Ability to analyze data sets and communicate analytics to interpret data findings.
• Multitasking and time-management skills, with the ability to prioritize tasks.
• Experience in auditing and reporting functions to ensure proper calculation and reporting of payroll data, benefits, and taxes.
• Strongly skilled in data manipulation from multiple databases and integrating information from all accounts.

Nice-to-haves

• Experience in the legal industry is a plus.
• Bilingual in Spanish is preferred.

Benefits

• 401(k)
• Dental insurance
• Health insurance
• Health savings account
• Paid time off
• Parental leave
• Vision insurance