Payroll Data Conversion Specialist: SQL & Excel

Paylocity; Schaumburg (IL); On-site; USD 50,000 - 60,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

401(k) match

Job summary

Paylocity is seeking a Data Conversion Specialist in Schaumburg, IL to support implementation teams with payroll data conversions. The role combines payroll knowledge with technical ability, requiring SQL and advanced MS Excel skills to convert client data onto the Paylocity platform.

The ideal candidate has a Bachelor’s degree and 3–5 years of payroll data experience, with strong attention to detail and communication skills. This is an in-office, five-day-per-week role in Schaumburg, IL.

Qualifications

• Bachelor's degree required.
• 3-5 years’ experience working with payroll data preferred.
• Adept attention to detail.
• Proficiency in MS Office; knowledge of Access and SQL helpful.
• Intermediate to Advanced MS Excel skills.
• Basic SQL skills preferred; experience in SQL Server is a plus.

Responsibilities

• Respond to internal and external requests during implementation.
• Coordinate and schedule electronic data extraction with clients.
• Convert time clocks, history (including check detail, rate and position) and custom data extractions.
• Use MS Excel, SQL Server, and Paylocity data conversion tools to research issues and update customer databases.
• Review and/or format client supplied data for accuracy prior to uploading.
• Take accountability to ensure previous provider data is successfully extracted and formatted for Web Pay.
• Pull data dependent on which of the products the client purchased with a holistic approach.
• Responsible for analyzing and defining mapping rules.
• Assist in data cleanup where necessary.
• All other duties as assigned.

Skills

SQL

MS Excel

Payroll data

Data conversion

Attention to detail

Communication skills

Education

Bachelor’s degree

Tools

SQL Server

MS Access

Job description

Paylocity is seeking a Data Conversion Specialist in Schaumburg, IL to support implementation teams with payroll data conversions. The role combines payroll knowledge with technical ability, requiring SQL and advanced MS Excel skills to convert client data onto the Paylocity platform.

The ideal candidate has a Bachelor’s degree and 3–5 years of payroll data experience, with strong attention to detail and communication skills. This is an in-office, five-day-per-week role in Schaumburg, IL.