Payroll Integration Analyst - SQL & Onboarding Lead

Transamerica; Denver (CO); Hybrid; USD 60,000 - 68,000; Full time

Benefits offered by this job

Health Insurance

401k Match

Employee Stock Purchase Plan

Tuition Reimbursement

Disability Insurance

Medical Insurance

Dental Insurance

Vision Insurance

Career Training & Development Opportun

PTO

Job summary

Transamerica is seeking a Payroll Integrations Specialist to independently manage standard payroll integrations during client onboarding and early production stabilization, configuring, testing, and documenting payroll data feeds with clients, vendors, and internal teams.

You will bring a Bachelor’s degree, 2 years in payroll integrations or HRIS, and SQL experience with DB2 or MS SQL Server; a hybrid work environment and comprehensive benefits are offered.

Qualifications

• Bachelor’s degree in business, info systems, or related field.
• Two years of experience in payroll integrations or HRIS.
• Experience with payroll vendors and file feed configurations.
• Experience using SQL for data analysis.
• Proficient with DB2 or MS 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 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 IT partners and document items in Jira
• Assist with testing system enhancements for usability, performance, and standards adherence

Skills

SQL

DB2

MS SQL Server

Payroll integrations

Education

Bachelor’s degree in business or information systems

Tools

Microsoft Office

Job description

Transamerica is seeking a Payroll Integrations Specialist to independently manage standard payroll integrations during client onboarding and early production stabilization, configuring, testing, and documenting payroll data feeds with clients, vendors, and internal teams.

You will bring a Bachelor’s degree, 2 years in payroll integrations or HRIS, and SQL experience with DB2 or MS SQL Server; a hybrid work environment and comprehensive benefits are offered.