Int Payroll Integration Analyst

Transamerica Corporation; Iowa (LA); Hybrid; USD 60,000 - 68,000; Full time

Job summary

Transamerica Corporation seeks an Int Payroll Integration Analyst to independently manage standard payroll integrations during client onboarding and early production stabilization. You will configure, test, troubleshoot, and document payroll data feeds while partnering with clients, vendors, and internal teams to ensure accurate system integration.

The role requires a bachelor’s degree in business or information systems and 2 years’ experience with payroll integrations, SQL analysis, and vendor

Qualifications

• Bachelor’s degree in business, information systems, or a related field is required.
• Two years of experience in payroll integrations, HRIS, or data analysis preferred.
• Experience with payroll vendors and file feed configurations desired.
• Strong SQL data analysis and data reconciliation skills.
• Proficient with database tools and Microsoft Office.

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.

Skills

SQL

DB2

Microsoft SQL Server

Microsoft Office

Education

Bachelor's degree in business, information systems, or related field

Tools

DB2

SQL Server

Job description

## Int Payroll Integration AnalystApplylocations: Cedar Rapids, Iowa: Denver, Coloradotime type: Full timeposted on: Posted Todayjob requisition id: R20062323**Job Family**Customer & Business Documentation**About Us**At Transamerica, hard work, innovative thinking, and personal accountability are qualities we honor and reward. We understand the potential of leveraging the talents of a diverse workforce. We embrace an environment where employees enjoy a balance between their careers, families, communities, and personal interests.Ultimately, we appreciate the uniqueness of a company where talented professionals work collaboratively in a positive environment — one focused on helping people look forward and plan for the best life possible while providing tools and solutions that make it easier to get there.**Who We Are**We believe everyone deserves to live their best life. More than a century ago, we were among the first financial services companies in America to serve everyday people from all walks of life.Today, we’re part of an international holding company, with millions of customers and thousands of employees worldwide. Our insurance, retirement, and investment solutions help people make the most of what’s important to them.We’re empowered by a vast agent network covering North America, with diversity to match. Together with our nonprofit research institute and foundation, we tune in, step up, and are a force for good — for our customers and the communities where we live, work, and play. United in our purpose, we help people create the financial freedom to live life on their terms.**What We Do**Transamerica is organized into three distinct businesses. These include 1) World Financial Group, including Transamerica Financial Advisors, 2) Protection Solutions and Savings & Investments, comprised of life insurance, annuities, employee benefits, retirement plans, and Transamerica Investment Solutions, and 3) Financial Assets, which includes legacy blocks of long term care, universal life, and variable and fixed annuities. These are supported by Transamerica Corporate, which includes Finance, People and Places, General Counsel, Risk, Internal Audit, Strategy and Development, and Corporate Affairs, which covers Communications, Brand, and Government and Policy Affairs.Transamerica employs nearly 7,000 people. It’s part of Aegon, an integrated, diversified, international financial services group serving approximately 23.9 million customers worldwide.\* For more information, visit transamerica.com.**Job Description Summary**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.**Job Description****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.**Disclaimer:** *Beware of fake job offers!*We’ve been alerted to scammers impersonating Transamerica recruiters, particularly for remote positions. Please note:* We will **never** request personal information such as ID or payment for equipment upfront.* Official offers are sent via **DocuSign** following a verbal offer—not through text or email.*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.*