Int Payroll Integration Analyst

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

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…