HCM/HRIS Data Extraction Specialist

Essential Functions

• Utilizing a calendar scheduling tool, book extraction meetings throughout the day.
• Using virtual meeting software, meet with the client with your camera on.
• Start the meeting a minimum of 5 minutes prior to the scheduled start time.
• Introduce yourself and provide a summary of H2R-Solutions and Palm Payroll’s services.
• Request control of the client’s system (if the client refuses, walk the client through step by step how to pull the required fields needed for the report.
• Utilizing the template document, include the required fields in the report.
• Provide instructions to the client on where to download the report and how to securely send it to H2R-Solutions for processing.
• Once the report has been received, manipulate it utilizing MS Excel to get the data in the template format.
• In the second meeting, assist the client in setting up the deduction and earning codes in their HCM/HRIS system.

Requirements

• Advanced MS Excel knowledge, including pivot tables, formulas, and VBA code (Visual Basic for Applications)
• Prior experience writing macros, including macros that take user input
• Strong analytical skills related to working with unstructured data
• Strong problem-solving skills, including the ability to identify solutions for complex data manipulation problems
• Proven experience in data extraction, conversions, migration, and manipulation from discounted data sets
• Excellent attention to detail, time management, organization, and prioritization skills
• Strong interpersonal skills, ability to work with various teams
• Ability to work independently, manage multiple priorities, and meet aggressive deadlines
• Strong sense of ownership and results-oriented
• Troubleshooting and problem-solving experience
• Can work autonomously
• Ability to work fully remote
• Can maintain confidentiality
• Ability to handle multiple competing priorities
• Pleasant and professional demeanor with professional business casual attire

Compensation

$20 - $30 per hour

Supervisory Responsibility

This position does not supervise others.

Work Environment

This job operates in a professional home office environment. This role routinely uses standard office equipment. This role is stationary, with extended hours working on a computer.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

While performing the duties of this job, the employee is regularly required to talk or hear. The employee may be required to sit, use hands and fingers to type on a keyboard, or feel and reach with hands and arms.

Position Type/Expected Hours of Work

This is a full-time position. Days and hours will vary, and evening/weekend work may be required as job duties demand.

Travel

Little to no travel is expected for this position.

Required Education and Experience

High school diploma or equivalent. Five or more years of MS Excel experience is required, as well as proficiency in Microsoft Office. Familiar with a wide variety of HCM/HRIS systems.

Additional Eligibility Qualifications

No Additional Eligibility Qualifications are required.

EEO Statement

The Company provides equal employment opportunities to all individuals regardless of their race, color, creed, religion, gender, age, sexual orientation, national origin, disability, veteran status, or any other characteristic protected by state, federal, or local law. The Company takes affirmative action to ensure that applicants and employees are treated during the application process and post-hiring employment without regard to any of these characteristics. Discrimination of any type is not tolerated.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.