Payroll Integrations Analyst | SQL & Onboarding

Transamerica; Cedar Rapids (IA); Hybrid; USD 60,000 - 68,000; Full time

Benefits offered by this job

Pension Plan

401k Match

Employee Stock Purchase Plan

Tuition Reimbursement

Disability Insurance

Medical Insurance

Dental Insurance

Vision Insurance

Employee Discounts

Career Training & Development Opportun

Job summary

Transamerica in Cedar Rapids, IA is seeking a Payroll Integrations Specialist to independently manage standard payroll integrations during client onboarding and early production stabilization by configuring, testing, troubleshooting, and documenting payroll data feeds, while partnering with clients, vendors, and internal teams to ensure accurate system integration.

The ideal candidate will have a bachelor’s degree in business or information systems and at least two years of payroll integrations

Qualifications

• Bachelor’s degree in business, information systems, or a related field.
• Two years of experience in payroll integrations, human resources information systems, or data analysis.
• Experience working with payroll vendors and file feed configurations.
• Experience using SQL for data analysis.
• Experience troubleshooting system or data errors.
• Proficient with database tools such as DB2 or Microsoft SQL Server.
• Proficient with Microsoft Office applications.

Responsibilities

• Lead configuration, testing, and implementation of standard payroll integrations
• Collaborate with clients, payroll vendors, and internal teams to clarify requirements and resolve issues
• Research, analyze, and troubleshoot payroll integration and data load errors
• Perform root-cause analysis and recommend corrective actions
• Create and run Structured Query Language (SQL) queries to analyze and reconcile data
• Document integration requirements, mapping specifications, and test results
• Coordinate user acceptance testing and support early production cycles after go-live
• Communicate system issues to information technology partners and document items in Jira
• Assist with testing system enhancements for usability, performance, and standards adherence

Job description

Transamerica in Cedar Rapids, IA is seeking a Payroll Integrations Specialist to independently manage standard payroll integrations during client onboarding and early production stabilization by configuring, testing, troubleshooting, and documenting payroll data feeds, while partnering with clients, vendors, and internal teams to ensure accurate system integration.

The ideal candidate will have a bachelor’s degree in business or information systems and at least two years of payroll integrations