Hybrid Payroll Integrations Analyst with SQL

Aegon; United States; Hybrid; USD 60,000 - 68,000; Full time

Benefits offered by this job

Hybrid work environment

Annual bonus eligibility

Job summary

Aegon is seeking an experienced payroll integrations analyst to independently manage standard payroll integrations during client onboarding and early production stabilization. You will configure, test, troubleshoot, and document data feeds while partnering with clients, vendors, and internal teams to ensure accurate system integration.

The role requires a bachelor's degree and 2+ years of payroll integration experience, with strong SQL skills and proficiency in DB2 or SQL Server.

Qualifications

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

Skills

SQL data analysis

Data analysis

Payroll integrations

Vendor collaboration

Education

Bachelor's degree in business or related field

Tools

DB2

Microsoft SQL Server

Microsoft Office

Job description

Aegon is seeking an experienced payroll integrations analyst to independently manage standard payroll integrations during client onboarding and early production stabilization. You will configure, test, troubleshoot, and document data feeds while partnering with clients, vendors, and internal teams to ensure accurate system integration.

The role requires a bachelor's degree and 2+ years of payroll integration experience, with strong SQL skills and proficiency in DB2 or SQL Server.