Colorado Staffing
Sr Data Consultant - Large Market Retirement (Hybrid)
Colorado Staffing, Denver, Colorado, United States, 80285
Client Transition Services Team Member
At Transamerica, hard work, innovative thinking, and personal accountability are qualities we honor and reward. We understand the potential unleashed by 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. Transamerica is a part of Aegon, an integrated, diversified, international financial services group. The Aegon companies employ over 21,500 people and have approximately 31.7 million customers. For more information, visit www.transamerica.com. Job Description
As a member of the Client Transition Services (CTS) team, this role handles moderate to complex data and asset transfer processes during new client plan conversions for Mid Market and Large Market conversion projects. Ensures timely and proper notification of cash flows to the Transamerica Retirement Services (TRS) Funding Group, reconciles assets received with internal recordkeeping systems, manages client data and communicates project status to project team members. Responsibilities
Partner with clients, vendors, payroll providers and internal resources to gather data fields required for migration. Establish an ongoing data dialog with internal and external project partners and clients. Analyze and reconcile data received against documented plan rules. Post transferred records from former record systems into company system; maintain auditable records of completed conversion steps. Audit, analyze and perform data quality reviews for each conversion. Maintain applicable internal systems with project status. Lead and/or participate in department projects and data-specific initiatives. Maintain department tools and procedures as assigned. Identify procedural issues/gaps and recommend solutions. Qualifications
Five years of pension/retirement industry experience. Five years of experience using electronic data files. Working knowledge of Paris or related database systems, and SQL (AQT). Experience using Informatica or Alteryx preferred. Excellent organizational skills, attention to detail and written and verbal communication skills. Problem-solving and analytical skills. Proficiency in MS Word/Excel. Preferred Qualifications: Proficiency in MS Access Knowledge of defined contribution plans Working Conditions: Hybrid location in Baltimore/Cedar Rapids/Denver/Philadelphia Position is overtime eligible *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. Compensation
The salary for this position generally ranges between $70,000 - $77,000 annually. Please note that the salary range is a good faith estimate for this position and actual starting pay is determined by several factors including qualifications, experience, geography, work location designation (in-office, hybrid) and operational needs. Salary may vary above and below the stated amounts, as permitted by applicable law. Additionally, this position is typically eligible for an Annual Bonus based on the Company Bonus Plan/Individual Performance and is at the Company's discretion. 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. What We Offer
For eligible employees, we offer a comprehensive benefits package designed to support both the personal and financial well-being of our employees. Compensation Benefits
Competitive Pay Bonus for Eligible Employees Benefits Package
Pension Plan 401k Match Employee Stock Purchase Plan Tuition Reimbursement Disability Insurance Medical Insurance Dental Insurance Vision Insurance Employee Discounts Career Training & Development Opportunities Health and Work/Life Balance Benefits
Paid Time Off starting at 160 hours annually for employees in their first year of service. Ten (10) paid holidays per year (typically mirroring the New York Stock Exchange (NYSE) holidays). Be Well Company holistic wellness program, which includes Wellness Coaching and Reward Dollars. Parental Leave fifteen (15) days of paid parental leave per calendar year to eligible employees with at least one year of service at the time of birth, placement of an adopted child, or placement of a foster care child. Adoption Assistance Employee Assistance Program College Coach Program Back-Up Care Program PTO for Volunteer Hours Employee Matching Gifts Program Employee Resource Groups Inclusion and Diversity Programs Employee Recognition Program Referral Bonus Programs Inclusion & Diversity
We believe our commitment to diversity and inclusion creates a work environment filled with exceptional individuals. We're thrilled to have been recognized for our efforts through the Human Rights Campaign Corporate Equality Index, Dave Thomas Adoption Friendly Advocate, and several Seramount lists, including the Inclusion Index, 100 Best Companies for Working Parents, Best Companies for Dads, and Top 75 Companies for Executive Women. To foster a culture of inclusivity throughout our workforce, workplace, and marketplace, Transamerica offers a wide range of diversity and inclusion programs. This includes our company-sponsored, employee-driven Employee Resource Groups (ERGs), which are formed around a shared interest or a common characteristic of diversity. ERGs are open to all employees. They provide a supportive environment to help us better appreciate our similarities and differences and understand how they benefit us all. We believe our responsibilities extend beyond our corporate walls. That's why we created the Aegon Transamerica Foundation in 1994. Through a mix of financial grants and the volunteer efforts of our employees, the foundation supports nonprofit organizations focused on the things that matter most to our people in the communities where we live and work.
At Transamerica, hard work, innovative thinking, and personal accountability are qualities we honor and reward. We understand the potential unleashed by 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. Transamerica is a part of Aegon, an integrated, diversified, international financial services group. The Aegon companies employ over 21,500 people and have approximately 31.7 million customers. For more information, visit www.transamerica.com. Job Description
As a member of the Client Transition Services (CTS) team, this role handles moderate to complex data and asset transfer processes during new client plan conversions for Mid Market and Large Market conversion projects. Ensures timely and proper notification of cash flows to the Transamerica Retirement Services (TRS) Funding Group, reconciles assets received with internal recordkeeping systems, manages client data and communicates project status to project team members. Responsibilities
Partner with clients, vendors, payroll providers and internal resources to gather data fields required for migration. Establish an ongoing data dialog with internal and external project partners and clients. Analyze and reconcile data received against documented plan rules. Post transferred records from former record systems into company system; maintain auditable records of completed conversion steps. Audit, analyze and perform data quality reviews for each conversion. Maintain applicable internal systems with project status. Lead and/or participate in department projects and data-specific initiatives. Maintain department tools and procedures as assigned. Identify procedural issues/gaps and recommend solutions. Qualifications
Five years of pension/retirement industry experience. Five years of experience using electronic data files. Working knowledge of Paris or related database systems, and SQL (AQT). Experience using Informatica or Alteryx preferred. Excellent organizational skills, attention to detail and written and verbal communication skills. Problem-solving and analytical skills. Proficiency in MS Word/Excel. Preferred Qualifications: Proficiency in MS Access Knowledge of defined contribution plans Working Conditions: Hybrid location in Baltimore/Cedar Rapids/Denver/Philadelphia Position is overtime eligible *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. Compensation
The salary for this position generally ranges between $70,000 - $77,000 annually. Please note that the salary range is a good faith estimate for this position and actual starting pay is determined by several factors including qualifications, experience, geography, work location designation (in-office, hybrid) and operational needs. Salary may vary above and below the stated amounts, as permitted by applicable law. Additionally, this position is typically eligible for an Annual Bonus based on the Company Bonus Plan/Individual Performance and is at the Company's discretion. 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. What We Offer
For eligible employees, we offer a comprehensive benefits package designed to support both the personal and financial well-being of our employees. Compensation Benefits
Competitive Pay Bonus for Eligible Employees Benefits Package
Pension Plan 401k Match Employee Stock Purchase Plan Tuition Reimbursement Disability Insurance Medical Insurance Dental Insurance Vision Insurance Employee Discounts Career Training & Development Opportunities Health and Work/Life Balance Benefits
Paid Time Off starting at 160 hours annually for employees in their first year of service. Ten (10) paid holidays per year (typically mirroring the New York Stock Exchange (NYSE) holidays). Be Well Company holistic wellness program, which includes Wellness Coaching and Reward Dollars. Parental Leave fifteen (15) days of paid parental leave per calendar year to eligible employees with at least one year of service at the time of birth, placement of an adopted child, or placement of a foster care child. Adoption Assistance Employee Assistance Program College Coach Program Back-Up Care Program PTO for Volunteer Hours Employee Matching Gifts Program Employee Resource Groups Inclusion and Diversity Programs Employee Recognition Program Referral Bonus Programs Inclusion & Diversity
We believe our commitment to diversity and inclusion creates a work environment filled with exceptional individuals. We're thrilled to have been recognized for our efforts through the Human Rights Campaign Corporate Equality Index, Dave Thomas Adoption Friendly Advocate, and several Seramount lists, including the Inclusion Index, 100 Best Companies for Working Parents, Best Companies for Dads, and Top 75 Companies for Executive Women. To foster a culture of inclusivity throughout our workforce, workplace, and marketplace, Transamerica offers a wide range of diversity and inclusion programs. This includes our company-sponsored, employee-driven Employee Resource Groups (ERGs), which are formed around a shared interest or a common characteristic of diversity. ERGs are open to all employees. They provide a supportive environment to help us better appreciate our similarities and differences and understand how they benefit us all. We believe our responsibilities extend beyond our corporate walls. That's why we created the Aegon Transamerica Foundation in 1994. Through a mix of financial grants and the volunteer efforts of our employees, the foundation supports nonprofit organizations focused on the things that matter most to our people in the communities where we live and work.