Considers financial impacts and risks to participant and business in all aspects of day to day work.
Responsible for acting with integrity and maintaining complete confidentiality with sensitive participant information.
Responsible for creating and running complex queries using multiple system tables and complex query criteria(unions, exists, etc.) for both resear as well as other system users using Linux and DB2 SQL
Acts as a liaison between the user group and the systems team to correct system issues and/or report issues by creation of production problem tickets.
Performs production table updates, inserts, and deletions using DB2 SQL, maintaining integrity and accuracy of data.
Intuitively researches issues reported by the business units regarding application and process problems to identify the "root" cause, seeing the entire impact of the issue through to completion.
Successfully interprets and communicates complex information to others including end users, upper management, and development/systems staff.
Assists with creating formal documentation and conducts peer training.
Assists in analyzing, researching, and responding to data reporting errors.
Continuously develops expertise in the data within systems database tables as new processes and tables are created.
Provides accurate data to various business units for mass mailings.
Understands and communicates business unit requests and participates in cross-functional project teams for new systems development. Assists with documenting of system and business requirements.
Assists with testing system changes for usability, performance and adherence to standards. Documents and reports results to development team.
Works with peers to ensure all work items are completed within set timing standards
Rotating on call for Nightly Batch systems support, after prerequisite training period.
Systems related Bachelor's degree or equivalent business experience. Up to two years' pension, accounting or technical experience.
Strong PC skills. Knowledge of Mainframe (PARIS), Linux and DB2 SQL, Excel, Word, SharePoint, and Access preferred. Knowledge of Transamerica Retirement Solutions departmental processes preferred. Strong organizational and analytical skills with attention to detail. Working knowledge of system methodology, project management, quality assurance and testing methodologies. Excellent problem solving skills. Good verbal and written communication. Proven problem solving ability and a willingness to think "outside-the-box".
Normal office environment. Standard business hours but must be willing to work some evenings, weekends, and provide on call coverage on a rotational basis. Minimal travel may be required.
Why Work for Us
Total Rewards at Transamerica: It's more than a paycheck. Our comprehensive Total Rewards package is designed to help support you in many ways throughout all stages of your life and career. We provide a competitive, market-driven program that encompasses base compensation, bonus potential, retirement, health and wellness benefits, learning and development opportunities, plus great employee perks. All designed with you in mind to help you live your best life, grow personally and professionally - and feel valued for the work you do.
Learn more about our Total Rewards Package.
Equal Opportunity Employer:
Transamerica Life Insurance Company is an Equal Employment Opportunity employer and does not discriminate against any applicant or employee because of age, religion, sex, gender identity, genetic information, race, color, national origin, pregnancy, sexual orientation, marital status, participation in the uniformed services (e.g. U.S. Armed Forces, National Guard), physical or mental disability, or any other status protected by federal, state, or local equal employment opportunities laws.
AEGON USA Realty Advisors, LLC, is an Equal Employment Opportunity/ Affirmative Action Employer and does not discriminate against any applicant or employee because of age, religion, sex, gender identity, genetic information, race, color, national origin, pregnancy, sexual orientation, marital status, participation in the uniformed services (e.g. U.S. Armed Forces, National Guard), physical or mental disability, or any other status protected by federal, state, or local equal employment opportunities laws.
Applicants with physical or mental disabilities may be entitled to a form of reasonable accommodation under the Americans with Disabilities Act and certain state and local laws. A reasonable accommodation is a change in the way things are normally done which will insure equal employment opportunity without imposing undue hardship on the Transamerica Companies. If you are a job seeker with a disability, or are assisting someone with a disability, and require assistance to apply for one of our jobs, please contact: firstname.lastname@example.org.
If you experience technical problems during the application process, please email email@example.com.
Cashiering Associate Cedar Rapids
Supervisor Executive Administrative Assistants Cedar Rapids
Senior Administrative Assistant - Aegon AM Cedar Rapids
See all vacancies
Transamerica Transamerica careers
Visit the dedicated careers website for more information about working for Transamerica.
Roles Roles at Aegon
Find out more about different roles available at Aegon and Transamerica Globally.