Synthetic GIC Analyst

Transamerica Life Insurance Company Baltimore , MD 21203

Posted 1 week ago

Job FamilySynthetic GIC

Job Description SummaryConducts daily processing of financial transactions, contract maintenance and analysis. Processes requests related to administering contractual terms and plan reviews.Job Description

Responsibilities

  • Process deposit and withdrawal transactions. Analyze deposit and withdrawal trends to ensure the terms of the contract are not breached.

  • Process monthly market value, yield, and duration for each contract for valuation and risk reporting.

  • Process fee receipts. Understand contractual fee structure and payment method to ensure appropriate calculation, billing, reconciliation, and collection of fee income.

  • Maintain and update contacts in the administrative system to ensure that appropriate individuals are receiving month-end statements and fee invoices.

  • Maintain and update plan information in the underwriting administration system.

  • Maintain a strong professional relationship with external clients who provide transactions and monthly reports.

  • Maintain internal business partnerships with Marketing, Legal, and Risk Management.

  • Support new and related Stable Value products and projects.

Qualifications

  • Bachelor's degree in economics, finance, accounting, mathematics, computer science or relevant field.

  • Aptitude for actuarial, financial and investment concepts to conduct root cause analysis and business analysis.

  • Attention to detail to follow procedures and ensure accuracy in documentation and data.

  • Problem-solving skills to analyze processes and apply systems thinking to generate solutions.

  • Proficiency with MS Excel, MS Access, SQL, Tableaux or other tools to extract and analyze data and report results.

Preferred Qualifications

  • Experience working in investment operations or investment accounting/analysis.

  • Knowledge of contract terms, allowable transactions and compliance activities.

  • VBA coding, macro experience.

Behavioral & Leadership Competencies

  • Attention to detail to follow procedures and ensure accuracy in documentation and data.

  • Problem-solving skills to analyze processes and apply systems thinking to generate solutions

  • Ability to work effectively on a team supporting common goals and communicate clearly

Working Conditions

  • Office environment

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. Please contact: applicantsupport@transamerica.com 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.

Ontario Applicants:

Our Company is committed to providing accessibility to those with disabilities in a manner that is consistent with the principles of independence, dignity, integration and equality of opportunity, that is in compliance with the Accessibility for Ontarians with Disabilities Act 2005 ("AODA"). Please contact applicantsupport@transamerica.com 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.

Technical Assistance:

If you experience technical problems during the application process, please email applicantsupport@transamerica.com.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Intelligence Analyst

T. Rowe Price

Posted 2 days ago

VIEW JOBS 3/17/2019 12:00:00 AM 2019-06-15T00:00 Our mission as a leading investment management firm is to help our clients achieve their long-term financial goals. We believe our associates are the key to this mission and we are always looking for talented individuals who share our commitment to our client's success. If you're looking for challenging work experiences and the ability to learn in a collaborative culture, we invite you to explore the opportunities available at T. Rowe Price. PRIMARY PURPOSE OF THE POSITION The BI Analyst proactively consults with business partners to provide business insight, enabling key strategic business decision making processes. The incumbent will work with complex, disparate datasets across multiple database platforms to connect, extract, blend, and cleanse data, preparing it for reporting and analytical modeling. The BI Analyst will develop and evolve sales, marketing and marketing product and finance performance, management, and KPI dashboards utilizing business requests and advanced data visualization and data blending technology. In addition, this role will need to gather and evaluates business requests, develop analytical models and perform exploratory data analysis to proactively provide additional business insight and strategic decision support. The incumbent will work closely with the BI Lead Manager, Head of USI BI, and GBS Partners on analytical and business intelligence projects. PRINCIPAL RESPONSIBILITIES Performance and Management Reporting / Dashboards * Develops standard and custom performance and management reports/dashboards in support of strategic initiatives by utilizing the latest data visualization tools and techniques. * Coordinates requests, gathers documents and business requirements for new reporting or modeling needs. * Leverages knowledge of the business to develop reporting tools which will meet current and future business needs * Proactively identifies opportunities to improve and evolve existing business intelligence solutions * Partners with GBS applications, architecture, Data Scientists and database experts to align deliverable and milestones to standards. * Analyzes information retrieved and assembles presentation quality information with business insight and strategic decision support for use by managers. * Ensures quality and data integrity in all project deliverables Business Analytics * Provide consultative analytical support for business units (Sales, Marketing, Product and Finance business partners as it relates to existing and potentially new deliverables. * Partners with Distribution Intelligence partners and managers to evaluate existing reporting / dashboards and provide more in-depth analytics on existing and new reports * Identify key drivers to reporting outcomes and provide business insight to GMs Lead Team and Sr. Sales and Marketing associates. Data Modeling * Develops analytical models in support of key decision making processes related to forecasting, financial modeling, and/or exploratory data analysis. * Works closely with Lead Manager and Data Scientists on analytical modeling projects. * Partner with Distribution Intelligence team members on the development of analytical models * Partners with GBS and Distribution Intelligence Data Governance SME to ensure data is extracted from most appropriate source and is interpreted properly. Project Management & Deliverables * Provides regular, proactive status updates to the manager on project status * Execute on project priorities and escalate to manager when applicable * Consistently documents all phases of project work * Leverages strong technical skills and training in developing professional grade reports, dashboards, and models * May develop or train others in data, reporting, and/or modeling skills QUALIFICATIONS Required * College degree and 1 year of related work experience, or Associate degree and 3 years related work experience, or High School diploma/equivalent and 5 years related work experience * Self-motivated with strong work ethic * Ability to identify an opportunity or problem and develop a creative solution * Strong analytical skills with the ability to quickly grasp business issues and understand business strategy * Strong oral and written communication skills * Strong interpersonal skills * Ability to prioritize and manage several projects simultaneously * Ability to collect, organize, and effectively distribute significant amounts of detailed information * Experience collaborating with GBS and familiarity with varying database structures * Comfortable working with disparate data * Advanced SQL skills or other related data extraction, blending, cleansing skills such as Alteryx * Experience using Microsoft Office Suite, DB Visualizer * Experience with latest data visualization technology (QlikSense, Tableau, Microstrategy) * Strong knowledge of relational databases and concepts Preferred * Advanced Data Analytics degree with 1 year of business experience preferred * Knowledge of database design models preferred * Advanced knowledge of the latest data visualization technology (QlikSense, Tableau, Microstrategy) * Advanced analytical modeling skills * Statistical analysis skills T. Rowe Price is an Equal Opportunity Employer T. Rowe Price Baltimore MD

Synthetic GIC Analyst

Transamerica Life Insurance Company