Actuarial Modeling Analyst

Guggenheim Partners Indianapolis , IN 46218

Posted 1 month ago

Guggenheim Life and Annuity is seeking a Modeling Analyst to join the Actuarial modeling unit. The analyst will join a highly collaborative team supporting a variety of actuarial functions, including valuation, risk management, product management, corporate planning, transaction pricing and financial reporting. In addition to exposure to actuarial modeling software, the ideal candidate will demonstrate an ability to analyze data input/output, work with large sets of data, anticipate questions and identify solutions to data anomalies, and work independently as well as in a team environment. Requirements include BS degree in Actuarial Sciences, Mathematics, Statistics or related discipline, 3 years' experience in a professional Actuarial function plus demonstrated work toward achieving ASA/FSA designations.

This role presents opportunities to apply your Actuarial education and further develop your skills and career goals toward achieving FSA status. The position is located in Indianapolis, Indiana (relocation assistance not available).

Specific responsibilities include:

  • Build, maintain and validate financial models for reinsurance pricing, in-force and new business rate setting, cash flow testing, DAC, reserve valuation, and corporate planning.

  • Produce and summarize projections to support management and regulatory needs.

  • Streamline and automate the input data used in projections and valuation as well as financial reporting processes. Work to streamline and automate the data output into efficient reporting tools.

  • Maintain well-controlled MG-ALFA or ArcVal models and updates all assumptions following the assumption governance process.

  • Collaborate with individuals throughout the organization to optimize financial results, with a particular emphasis on model efficiency and effectiveness along with data integrity in all reports.

  • Continued work toward achieving FSA designation through company supported Actuarial Student program.

Skills & experience required:

  • Bachelor's degree or higher in Actuarial Science, Mathematics, Statistics, or related field

  • 3 years' professional Actuarial experience preferred, including data analysis or modeling background

  • ASA designation preferred, or demonstrated path toward earning ASA/FSA designations

  • Advanced Microsoft Excel skills necessary, as well as competency with other MS Office applications; knowledge of Power BI and Power Pivot (within Excel) a plus

  • Knowledge of actuarial financial projection software, including MG ALFA or ArcVal desirable

  • Able to manage and analyze large data sets using tools such as MS Access, SQL Server or SAS preferred

In addition, the ideal candidate must demonstrate the following skills and attributes:

  • Driven and self-motivated

  • Analytical

  • Able to communicate results effectively

  • Inquisitive and innovative

  • Forward-looking, including the ability to anticipate questions and develop responses in advance

  • Results oriented

About Guggenheim Life and Annuity Company

Guggenheim Life and Annuity Company, a subsidiary of Guggenheim Partners, provides financial services to institutional and retail customers through fixed annuity products distributed through networks of independent marketing organizations and agents nationwide.

To succeed in the Guggenheim culture, candidates must be self-starters and strive for results. We are looking for people, who operate as business owners, adhere to the highest standards and think creatively to realize opportunities, wherever they may be.

Guggenheim Partners is an Equal Opportunity Employer committed to a diversified and inclusive workforce.

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

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
Actuarial Consultant Virtual Opportunity

Marsh & Mclennan Companies, Inc.

Posted 4 days ago

VIEW JOBS 4/3/2020 12:00:00 AM 2020-07-02T00:00 Company: Mercer Description: Mercer has an exciting opportunity available and is actively recruiting an experienced Government Healthcare Actuarial Consultant. What can you expect? The Government Healthcare Actuarial Consultant will project manage the data modeling process for projects for government sponsored health and welfare programs. Also, this role uses expertise to provide the technical review of data, manages tasks and deadlines and is a resource for the client. What's in it for you? Mercer's Government Human Services Consulting (GHSC) practice focuses on the unique and challenging needs of the public health care sector, providing a wide array of consulting services to local, state, and federal government agencies across the country. GHSC helps clients achieve better outcomes, develop and deploy defensible strategies, and reshape the delivery of health care. We deliver an individualized focus, powered by industry-leading experience, integrated capabilities and passionate people. GHSC has been partnering with states and other stakeholder organizations for over 34 years to face the demands and pace of change with data-driven pricing, clinically-informed policy and trusted, reliable strategies to manage and deliver care. To accomplish these challenging and exciting tasks, GHSC brings together a team of highly-skilled and dedicated consultants, clinicians, actuaries, analysts, accountants and pharmacists across four offices in Phoenix, Minneapolis, Atlanta and Washington DC. To learn more about Mercer's GHSC practice, please visit On day one you'll be eligible for medical, dental, and vision care benefits, we also offer employee discounts and other ancillary benefits that are too many to name! * This position also offers 20 vacation days annually. * In addition, Mercer has other benefits such as deals on auto and pet insurance, discounts on products and services, and more In this role you will be responsible for: * Participate in initial meetings with client or project lead to define the scope of the project * Provide insight and expertise on defining the data models, including knowledge of the capabilities and flexibility of different models * Document client calls and capture accurate information to determine project and data scope * Define and design architecture of data model through the following tasks: evaluate project scope to determine if there is a need to create new data model or use/modify an existing data model; define data architecture based on project scope, insight from the project lead and direction for the project's actuarial advisor; ensure data model architecture captures the full scope of the project, adheres to actuarial best practices and is flexible enough to make future adjustments * Delegate model updating and/or model building tasks to junior staff. Provide staff clear direction and defined timelines. Share knowledge with junior staff and provide training as needed to complete project tasks. Acts as resource for support staff, answer questions, provide workarounds for obstacles that arise * Identify data anomalies and exceptions as observed in project deliverables (reports, analysis). Understand the reasons and impacts of data anomalies and exceptions on the analysis in order to explain these issues to senior staff or project lead. Analyze data issues and formulate possible solutions. Communicate data anomalies with project and client team and provide insight, expertise and direction on address issues regarding the data anomalies. * Project manage multiple tasks on different projects simultaneously * Organize project work flow and delegate project tasks to junior staff * Manage the quality and timeliness of project deliverables and ensure client deliverables are client ready What qualifications are necessary to have for the role? * BA/BS degree * 3+ years of industry experience required * Through understanding of government health and welfare field and general health care concepts * Knowledge of MS Office Tools. Intermediate to advanced skills in Excel. Intermediate skills in Access. Intermediate skills in PowerPoint * Must have passed at least one preliminary Society of Actuaries (SOA) exam or a Valuation of Educational Experience (VEE) component, and plan to continue taking exams What makes you ideal for the role? * Strong analytical and mathematical skills. Understanding of Actuarial principals and methodologies * Excellent interpersonal skills; strong oral and written communication skills * Ability to prioritize and handle multiple tasks in a demanding work environment * Ability to partner and lead small teams to deliver project objectives; ability to work independently and on a team At Mercer, we make a difference in the lives of more than 110 million people every day by advancing their health, wealth, and careers. We're in the business of creating more secure and rewarding futures for our clients and their employees - whether we're designing affordable health plans, assuring income for retirement or aligning workers with workforce needs. Using analysis and insights as catalysts for change, we anticipate and understand the individual impact of business decisions, now and in the future. We see people's current and future needs through a lens of innovation, and our holistic view, specialized expertise, and deep analytical rigor underpin each and every idea and solution we offer. For more than 70 years, we've turned our insights into actions, enabling people around the globe to live, work, and retire well. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. At Mercer, we say we Make Tomorrow, Today. Visit for more information and follow us on LinkedIn and Twitter @Mercer Marsh & McLennan Companies offers competitive salaries and comprehensive benefits and programs including: health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. For more information, please visit us at: Mercer LLC and its separately incorporated operating entities around the world are part of Marsh & McLennan Companies, a publicly held company (ticker symbol: MMC). Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers. Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers. Marsh & Mclennan Companies, Inc. Indianapolis IN

Actuarial Modeling Analyst

Guggenheim Partners