Int Payroll Integration Analyst

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

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.

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

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

Preferred Qualifications

• Experience supporting retirement plan administration
• Experience with file mapping and data conversion processes

Working Conditions

• Hybrid Environment
• Please note that the compensation information that follows is a good faith estimate for this position only and is provided pursuant to applicable pay transparency and compensation posting laws. It is estimated based on what a successful candidate might be paid in certain Company locations.

Compensation

The salary for this position generally ranges between $60,000-$68,000. This range is an estimate, based on potential employee qualifications, operational needs and other considerations permitted by law. The range may vary above and below the stated amounts, as permitted by Colorado Equal Pay Transparency Rule 4.1.2.

Bonus Eligibility

This position is also typically eligible for an Annual Bonus based on the Company Bonus Plan/Individual Performance and is at Company Discretion.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time.

This job description is not a contract of employment nor for any specific job responsibilities. The Company may change, add to, remove, or revoke the terms of this job description at its discretion. Managers may assign other duties and responsibilities as needed. In the event an employee or applicant requests or requires an accommodation to perform job functions, the applicable HR Business Partner should be contacted to evaluate the accommodation request.