Analytical Reporting Analyst

The Analytical Reporting Analyst manages and monitors daily cash management transactions, performs cash attributions, ensures liquidity, and prepares cash flow projections.Additional responsibilities include assisting in the development of cash buffer, determination of short-term cash to be invested, and anticipation of management action need to be taken. Responsible for collateral and liquidity management, including perform the asset and liquidity cash flow model run for different scenarios and conduct the weekly and monthly reports

Primary functions and Responsibilities

• Performs daily corporate cash management and forecasting activities.
• Produces the daily cash dashboards to show liquidity risk exposures, monitors and manages company's daily cash position.
• Determines daily excess cash balances available for general account investment and communicates with portfolio management team.
• Forecasts cash and liquidity buffer due to market volatility and operational cash flow volatility.

• Maintains cash analytical systems, performed the cash attribution analysis, and coordinate with other teams and users on those systems.
• Interfaces with accounting for general ledger upload, and cash analytical system reconciliation.
• Recommends and implements improvements to current cash management processes.
• Performs different collateral programs stress testing and prepare the monthly collateral reports.
• Supports liquidity and collateral related analytics, including produce cash flow projections for liability products, derivatives, fixed income, mortgage loans and structured asset based on multiple stress scenarios.

• Provides timely, quality resolution of inquiries and ad hoc requests. Ensure timely, quality resolution of cash, liquidity, and collateral analysis.
• Aggressively embrace new technologies to improve current workflows.
• Ensures compliance with SOX controls, RCSA, internal audit and other rules governing cash transaction, liquidity management, and collateral management.
• Works closely with cross functional partners including Corporate Treasury, Risk management, Portfolio manager, investment reporting,and broader finance organization to ensure collaboration and process efficiencies are maintained.

Required Qualifications

• Requires a graduate degree in mathematics, actuarial science, finance, accounting, or related field OR Bachelor's degree in actuarial science, accounting or finance plus 1-year relevant work experience.

Preferred Qualifications

• Demonstrates high quality judgment, organizational and prioritization skills. Experience with derivatives and overall capital and financial markets.
• Knowledge of office administrator responsibilities, systems and procedures.

• Good understanding of investment and finance concepts and be able to creatively apply them in solving analytical problems in the business setting.
• Good understanding of investment and insurance products, with knowledge of at least one of life insurance, fixed and payout annuities, or long-term care products being most preferable.
• Good understanding of derivatives modeling (Future, Forward, Swap, Option pricing, sensitivity, risk, and Cash flow forecasting)
• Good understanding of liquidity management (understand stress liquidity event, driver of liquidity demand and supply relate to insurance company, and liquidity cost)

• Advanced communication and presentation skills.
• A proactive action taker and doer.
• Works well under pressure and within time constraints to effectively accomplish individual and team objectives. Excellent computer skills.

Specific skills/tools:

• Database management and coding skills: SAS, SQL, R, C, C++ and VBA or equivalent coding languages preferred.

Working Conditions

• Hybrid office environment (2 days a week in office)

Compensation:

The salary for this position generally ranges between $58,000 - $78,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 at a rate of 7.5%.

What You Receive:

• A Comprehensive Wealth + Health package
• Wealth Benefits
• Health and Work/Life Balance Benefits

Our commitment to inclusion & diversity means that we value differences. We encourage the unique perspectives of individuals and are dedicated to creating a respectful and inclusive work environment.

#IND123
Company information

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: [email protected].

Technical Assistance:

If you experience technical problems during the application process, please email [email protected].