Actuarial BSA (Business Systems Analyst)

Job Title: Actuarial BSA (Business Systems Analyst)

Location: West Des Moines, IA

Employment Type: Full-time

Job Description:

Actuarial BSA (Business Systems Analyst)

Overview

Senior Actuarial Business Systems Analyst responsible for partnering with Actuarial, Finance, Reinsurance, and Technology stakeholders to translate complex actuarial and financial requirements into scalable technical solutions. The role combines deep insurance domain expertise (specifically annuities and reinsurance) with advanced hands-on SQL data analysis, AWS-based data modernization, and Agile delivery leadership.

Must Have Technical/Functional Skills

Experience: 8+ years of relevant BSA/systems analysis experience supporting Actuarial, Finance, Insurance, or complex financial systems.

Domain Knowledge: Strong functional understanding of annuity productsincluding Fixed Annuities (FA), Fixed Indexed Annuities (FIA)as well as reinsurance structures, actuarial liability data, and Pension Group Annuity (PGA) business processes.

Data Analysis & Querying: Advanced SQL proficiency for validating complex actuarial calculations, performing financial reconciliation, and executing data profiling across relational and analytical data stores.

Modern Data & Cloud Platforms: Experience supporting enterprise data platforms and data modernization initiatives, preferably within AWS cloud environments.

Agile & Tooling: Hands-on experience working in Agile delivery models utilizing Jira and Confluence for backlog refinement, user story writing, and requirement traceability.

AI-Assisted Delivery: Practical experience leveraging AI-enabled tools to accelerate requirement documentation, data interpretation, test case generation, and BSA workflows.

Roles & Responsibilities

Requirement Engineering & Stakeholder Alignment:

Partner with Actuarial, Finance, Reinsurance, and IT teams to analyze end-to-end business processes and lead requirements elicitation workshops.

Translate complex mathematical, actuarial, and financial concepts into clear functional specifications, user stories, and acceptance criteria.

Data Validation & Reconciliation:

Perform deep-dive data analysis using SQL to validate business logic, verify actuarial rule implementations, and reconcile ledger/liability balances.

Support data flows powering downstream actuarial valuation models, financial reporting, and operational analytics.

Data Platform Modernization:

Collaborate with data engineering and cloud architects to design and modernize actuarial data pipelines, AWS-based repositories, and system integrations.

Identify data discrepancies and lead initiatives to elevate overall data governance, data accessibility, and data quality.

Agile Delivery & SDLC Execution:

Drive Agile delivery workstreams by maintaining clear backlog items, defining Definition of Ready (DoR) / Definition of Done (DoD), and supporting sprint planning.

Facilitate UAT planning, define functional test scenarios, review test execution results, and assist in production cutover and support activities.

Mentorship & Practice Leadership:

Mentor junior and mid-level BSAs by instituting standardized documentation frameworks, modeling templates, and analysis best practices.

Champion the adoption of AI-driven productivity tools and continuous improvement practices across delivery pods.