actuarial-analyst

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Actuarial Analyst

精算分析师

When to Use

适用场景

Build or refresh loss development triangles and support IBNR / ultimate loss estimates
Prepare pricing support: experience summaries, trend, credibility-weighted indications
Validate, reconcile, and document actuarial data feeds and model inputs/outputs
Produce reporting packs: exhibits, bridges, roll-forwards, and memo-ready tables
Tie statutory or management reporting schedules to actuarial workpapers
Apply approved assumptions in models under actuary direction (not set enterprise policy)
Run reasonability checks and peer-review prep before actuary sign-off
Support pension or group benefit valuation data prep and schedule tie-outs (analyst depth)

构建或更新损失发展三角表，支持IBNR / 最终损失估算
准备定价支持材料：经验汇总、趋势分析、可信度加权费率指示
验证、核对并记录精算数据馈送及模型输入/输出
生成报告包：图表、调节表、滚动更新表及可直接用于备忘录的表格
将法定或管理报告明细表与精算工作底稿进行核对
在精算师指导下在模型中应用已获批假设（不制定企业级政策）
在精算师签字确认前进行合理性检查并准备同行评审材料
为养老金或团体福利估值提供数据准备及明细表核对支持（分析师层面）

When NOT to Use

不适用场景

Appointed actuary opinions, statement of actuarial opinion, or final sign-off →
```
actuary
```
Engagement scoping, SOW, client decks, M&A consulting framing →
```
actuarial-consulting
```
Enterprise assumption governance, assumption papers, and change control →
```
assumption-setting
```
ALM strategy, duration matching, and investment policy →
```
asset-liability-management
```
P&C coverage legal wording, claims handling, or underwriting authority →
```
property-casualty-insurance
```
Life/health product design and reserving sign-off →
```
life-health-insurance
```
(line context); technical judgment →
```
actuary
```
Pension plan design, funding policy, or trustee advice →
```
pension-retirement-funds
```
(strategy); analyst prep stays here
Chart design, dashboards, and visualization craft only →
```
data-visualization
```
Source-system ETL, deduplication pipelines without actuarial judgment →
```
data-scrubbing
```
Capital markets quant research and backtesting →
```
quantitative-researcher
```

指定精算师意见、精算意见书或最终签字确认 →
```
actuary
```
项目范围界定、工作说明书（SOW）、客户演示文稿、并购咨询框架 →
```
actuarial-consulting
```
企业级假设治理、假设文档及变更控制 →
```
assumption-setting
```
资产负债管理（ALM）策略、久期匹配及投资政策 →
```
asset-liability-management
```
财产意外险（P&C）承保条款、理赔处理或核保权限 →
```
property-casualty-insurance
```
人寿/健康产品设计及准备金签字确认 →
```
life-health-insurance
```
（业务线背景）；技术判断 →
```
actuary
```
养老金计划设计、筹资政策或受托人咨询 →
```
pension-retirement-funds
```
（策略层面）；分析师准备工作仍归属于本指南
仅图表设计、仪表盘及可视化制作 →
```
data-visualization
```
无精算判断的源系统ETL、去重流程 →
```
data-scrubbing
```
资本市场量化研究及回测 →
```
quantitative-researcher
```

Related skills

Need	Skill
Actuarial judgment, sign-off, capital overview, governance memos	`actuary`
Consulting engagement, SOW, client communication, DD framing	`actuarial-consulting`
Assumption governance, papers, and enterprise change control	`assumption-setting`
ALM, duration, and asset–liability strategy	`asset-liability-management`
P&C products, claims, and underwriting context	`property-casualty-insurance`
Life/health benefits and product mechanics	`life-health-insurance`
Pension funding policy and plan design (overview)	`pension-retirement-funds`
Data cleaning pipelines and source normalization	`data-scrubbing`
Charts, dashboards, and visual design	`data-visualization`
Statistical/ML modeling beyond standard actuarial methods	`quantitative-researcher`

需求	技能
精算判断、签字确认、资本概览、治理备忘录	`actuary`
咨询项目、工作说明书（SOW）、客户沟通、尽职调查框架	`actuarial-consulting`
假设治理、文档及企业级变更控制	`assumption-setting`
资产负债管理（ALM）、久期及资产负债策略	`asset-liability-management`
财产意外险产品、理赔及核保背景	`property-casualty-insurance`
人寿/健康福利及产品机制	`life-health-insurance`
养老金筹资政策及计划设计（概览）	`pension-retirement-funds`
数据清理流程及源数据标准化	`data-scrubbing`
图表、仪表盘及可视化设计	`data-visualization`
超出标准精算方法的统计/机器学习建模	`quantitative-researcher`

Core Workflows

核心工作流程

1. Task intake and scope (analyst)

1. 任务接收与范围界定（分析师）

Before opening triangles or models:

Assignment type — Reserving, pricing support, reporting tie-out, model run, data prep
Basis — Statutory, GAAP, IFRS 17, management; valuation date and cutoff
LOB and segment — Direct vs assumed; reinsurance netting rules
Deliverable — Exhibit list, workpaper IDs, deadline, reviewer (actuary name if known)
Source of truth — Prior memo, approved assumptions version, model build ID
Out of scope — Flag sign-off, legal interpretation, or assumption changes needing
```
actuary
```
/
```
assumption-setting
```

See
references/actuarial_analyst_scope.md
.

在构建三角表或运行模型前：

任务类型 — 准备金核算、定价支持、报告核对、模型运行、数据准备
基准 — 法定、GAAP、IFRS 17、管理口径；估值日期及截止日期
业务线与细分 — 直接业务 vs 分入业务；再保险净额结算规则
交付物 — 图表清单、工作底稿ID、截止日期、审核人（若已知精算师姓名）
可信数据源 — 往期备忘录、已获批假设版本、模型构建ID
超出范围内容 — 标记需要
```
actuary
```
/
```
assumption-setting
```
处理的签字确认、法律解释或假设变更事项

参考
references/actuarial_analyst_scope.md
。

2. Reserving and loss development

2. 准备金核算与损失发展

Pull paid, incurred, case, and count triangles by origin and development age
Run diagnostics (factor stability, calendar-year check, paid/incurred divergence)
Apply selected methods (chain ladder, BF, Cape Cod) per actuary instruction—document picks and alternatives
Build IBNR and ultimate tables; reconcile to prior evaluation
Prepare PYD bridge and reserve roll-forward exhibits
Escalate tail, cat, or large-loss treatment questions to actuary

See
references/reserving_and_loss_development.md
.

提取按起期和发展年划分的已付、已发生、已报案及索赔次数三角表
运行诊断分析（因子稳定性、日历年检查、已付/已发生差异）
根据精算师指示应用选定方法（链梯法、BF法、科德角法）——记录方法选择及替代方案
构建IBNR及最终损失表；与往期评估结果进行核对
准备PYD调节表及准备金滚动更新图表
将尾部损失、巨灾损失或大额损失处理问题上报给精算师

参考
references/reserving_and_loss_development.md
。

3. Pricing and rate indication support

3. 定价与费率指示支持

Aggregate experience by segment (exposure, frequency, severity, pure premium)
Compute trend and on-level adjustments per documented methodology
Apply credibility weights as specified; show gross vs credibility-weighted indications
Summarize indicated rate change vs current; tie to loss ratio targets if provided
Document data cuts, outliers, and one-time events in a support schedule
Outline GLM or multivariate specs for actuary or modeler—do not present as final model without review

See
references/pricing_and_rate_indication.md
.

按细分维度汇总经验数据（风险暴露、出险频率、损失严重程度、纯保费）
根据既定方法计算趋势及水平调整值
按指定要求应用可信度权重；展示原始 vs 可信度加权费率指示
汇总指示费率变化与当前费率的对比；若有提供则与损失率目标挂钩
在支持明细表中记录数据筛选规则、异常值及一次性事件
为精算师或建模人员草拟GLM或多变量模型规范——未经审核不得作为最终模型提交

参考
references/pricing_and_rate_indication.md
。

4. Data validation and model I/O

4. 数据验证与模型输入输出

Reconcile premium, exposure, and claim feeds to control totals
Validate triangle dimensions, accident/valuation dates, and duplicate keys
Compare model inputs to source exhibits; log exceptions with $ impact where possible
Review model outputs for reasonability vs prior run and plan metrics
Archive run logs, parameter files, and data cut manifests for audit trail
Route assumption changes to actuary; do not alter approved assumption tables without approval

See
references/data_validation_and_model_io.md
.

将保费、风险暴露及索赔数据馈送与控制总额进行核对
验证三角表维度、事故/估值日期及重复键值
对比模型输入与源数据图表；尽可能记录带有金额影响的异常情况
审核模型输出与往期运行结果及计划指标的合理性
归档运行日志、参数文件及数据筛选清单以形成审计轨迹
将假设变更提交给精算师；未经批准不得修改已获批假设表

参考
references/data_validation_and_model_io.md
。

5. Reporting and workpapers

5. 报告与工作底稿

Build exhibit index aligned to filing or management pack structure
Produce bridges (reserve change, premium earned, claim counts) with footnoted definitions
Tie external schedules (statutory blanks, management reports) to internal workpapers
Draft memo support tables (facts and exhibits)—not full executive narrative unless asked
Version files:
```
YYYYMMDD_basis_LOB_vNN
```
with change log tab or README row

See
references/reporting_and_workpapers.md
.

构建与申报文件或管理报告包结构一致的图表索引
生成调节表（准备金变动、已赚保费、索赔次数）并附上带脚注的定义
将外部明细表（法定空白表格、管理报告）与内部工作底稿进行核对
草拟备忘录支持表格（事实与图表）——除非要求否则不撰写完整的执行摘要
文件版本命名：
```
YYYYMMDD_basis_LOB_vNN
```
，附带变更日志标签页或README记录

参考
references/reporting_and_workpapers.md
。

6. Quality review and documentation

6. 质量审核与文档记录

Complete analyst checklist before actuary review (below)
Ensure formulas trace and no hard-coded plugs without comment
Cross-foot subtotals and tie to GL or bordereaux where required
List open items with owner and target date
Package review folder: inputs, outputs, diagnostics, reconciliation, change log

See
references/quality_review_and_documentation.md
.

在精算师审核前完成分析师检查清单（如下）
确保公式可追溯，无未加注释的硬编码调整项
交叉核对小计金额，必要时与总账或分保账单核对
列出未解决事项及其负责人与目标日期
打包审核文件夹：输入文件、输出文件、诊断分析、核对结果、变更日志

参考
references/quality_review_and_documentation.md
。

Analyst checklist (before actuary review)

分析师检查清单（精算师审核前）

Analyst QA:
- [ ] Valuation date, basis, and segment definitions match memo / prior period
- [ ] Triangles tie to source data; paid + case = incurred (where applicable)
- [ ] Development factors documented with $ impact of alternative picks (if material)
- [ ] Reserve roll-forward reconciles opening + movement = closing
- [ ] Pricing experience A/E and exposure bases foot to bordereaux
- [ ] Credibility and trend applied per approved assumption memo
- [ ] Model run ID and assumption version recorded
- [ ] Exhibits numbered; cross-references in memo outline updated
- [ ] Open questions listed for actuary (not buried in cells)

Analyst QA:
- [ ] 估值日期、基准及细分定义与备忘录/往期一致
- [ ] 三角表与源数据一致；已付+已报案=已发生（适用时）
- [ ] 记录发展因子及替代方法选择的金额影响（若重大）
- [ ] 准备金滚动更新核对：期初余额+变动=期末余额
- [ ] 定价经验A/E及风险暴露基准与分保账单一致
- [ ] 已按获批假设备忘录应用可信度及趋势调整
- [ ] 已记录模型运行ID及假设版本
- [ ] 图表已编号；备忘录大纲中的交叉引用已更新
- [ ] 已为精算师列出未解决问题（未隐藏在单元格中）

Key metrics (analyst must define each time)

关键指标（分析师每次必须明确定义）

Metric	Analyst responsibility
Earned premium	Match earning pattern to loss basis in exhibit footnote
Loss ratio	State numerator (incurred vs paid) and denominator
Development factor	Age-to-age vs cumulative; calendar vs accident year
IBNR	Definition (incurred vs paid basis); split case/IBNR if required
Pure premium	Exposure unit documented (car-year, member month, payroll)
Indicated change	Gross vs credibility-weighted; constraint notes from underwriting
PYD	Bridge to prior quarter/year with volume vs rate vs development split

指标	分析师职责
已赚保费	在图表脚注中匹配损失基准的保费赚取模式
损失率	明确分子（已发生 vs 已付）及分母
发展因子	明确年对年 vs 累计；日历年 vs 事故年
IBNR	明确定义（已发生 vs 已付基准）；必要时拆分已报案/IBNR
纯保费	记录风险暴露单位（车年、会员月、薪资）
指示费率变化	原始 vs 可信度加权；记录核保约束说明
PYD	按业务量 vs 费率 vs 发展拆分与上季度/年度的调节表

Tool patterns (agnostic)

工具使用模式（通用）

Task	Typical approach
Triangles and factors	Spreadsheet triangles; SQL/R aggregation; actuarial reserving tools
Reconciliation	VLOOKUP/XLOOKUP keys; SQL joins; Python pandas groupbys
Version control	Dated folders; change log sheet; avoid "final_final" without version ID
Model runs	Parameter export; diff prior vs current outputs; checksum on input files
Documentation	Exhibit index; definition tab; color only for review flags, not logic

Prefer reproducible steps actuaries can re-run; avoid opaque manual cell edits without audit trail.

任务	典型方法
三角表与因子计算	电子表格三角表；SQL/R聚合；精算准备金工具
核对工作	VLOOKUP/XLOOKUP键值；SQL连接；Python pandas分组
版本控制	带日期的文件夹；变更日志表；避免无版本ID的"final_final"命名
模型运行	参数导出；对比往期与当前输出；输入文件校验和
文档记录	图表索引；定义标签页；仅用颜色标记审核标识，而非逻辑

优先选择精算师可重复运行的可复现步骤；避免无审计轨迹的不透明手动单元格编辑。

Line-of-business notes (analyst)

业务线注意事项（分析师）

LOB	Analyst focus
P&C	Class/territory splits; cat and large-loss flags; long-tail tail factors
Life	In-force census reconciliations; experience study tables—not product filing
Health	Seasonality in monthly data; benefit change flags in A/E
Reinsurance	Ceded vs net triangles; treaty mapping; clash aggregates if instructed
Pension	Census and liability roll-forward data; tie to actuary valuation file

业务线（LOB）	分析师关注点
财产意外险（P&C）	类别/地区拆分；巨灾及大额损失标记；长尾业务尾部因子
人寿险	有效保单人口核对；经验研究表格——不涉及产品申报
健康险	月度数据季节性；经验分析（A/E）中的福利变更标记
再保险	分出 vs 净额三角表；合约映射；按指示汇总冲突损失
养老金	人口数据及负债滚动更新数据；与精算师估值文件核对

Deliverable standards (analyst)

交付物标准（分析师）

Deliverable	Minimum content
Triangle workbook	Data tab, triangle, factors, ultimates, diagnostics, reconciliation
IBNR support	Method, selections, ultimates, PYD bridge, open questions
Pricing support	Segments, experience, trend, credibility, indicated change table
Model run pack	Inputs manifest, parameters, outputs, reasonability vs prior
Reporting tie-out	Schedule line ↔ workpaper cell map; unexplained differences listed
Review package	QA checklist, change log, exhibit index

State limitations (data gaps, one-time events, immature years). Do not present analyst work as opinion, legal advice, or filed regulatory submission without qualified actuary and counsel review.

交付物	最低内容要求
三角表工作簿	数据标签页、三角表、因子、最终值、诊断分析、核对结果
IBNR支持材料	方法、选择依据、最终值、PYD调节表、未解决问题
定价支持材料	细分维度、经验数据、趋势、可信度、指示费率变化表
模型运行包	输入文件清单、参数、输出结果、与往期对比的合理性分析
报告核对材料	明细表行 ↔ 工作底稿单元格映射；列出无法解释的差异
审核包	QA检查清单、变更日志、图表索引

需说明局限性（数据缺口、一次性事件、数据不成熟年份）。未经合格精算师及法律顾问审核，不得将分析师工作成果作为意见、法律建议或已申报的监管提交材料。

Assignment type matrix

任务类型矩阵

Trigger phrase	Primary workflow	Lead reference
triangle analysis / loss development	Reserving support	`reserving_and_loss_development.md`
IBNR / reserve analysis / reserve roll-forward	Ultimates and bridges	`reserving_and_loss_development.md`
rate indication / pricing support	Experience and indication	`pricing_and_rate_indication.md`
experience study (tables)	A/E prep; assumption change → actuary	`pricing_and_rate_indication.md`
actuarial workpaper / actuarial reporting	Exhibits and tie-outs	`reporting_and_workpapers.md`
model run / model output review	I/O validation	`data_validation_and_model_io.md`
credibility (application)	Weighting per memo	`pricing_and_rate_indication.md`

When tasks span reserving and pricing on the same block, separate workpapers and flag independence concerns to the actuary.

触发短语	核心工作流程	主要参考文档
triangle analysis / loss development	准备金支持	`reserving_and_loss_development.md`
IBNR / reserve analysis / reserve roll-forward	最终值与调节表	`reserving_and_loss_development.md`
rate indication / pricing support	经验分析与费率指示	`pricing_and_rate_indication.md`
experience study (tables)	经验分析（A/E）准备；假设变更 → 精算师	`pricing_and_rate_indication.md`
actuarial workpaper / actuarial reporting	图表与核对	`reporting_and_workpapers.md`
model run / model output review	输入输出验证	`data_validation_and_model_io.md`
credibility (application)	按备忘录应用权重	`pricing_and_rate_indication.md`

当同一业务块的任务同时涉及准备金核算与定价时，需分开编制工作底稿，并向精算师标记独立性相关问题。

Ethics and reliance (analyst)

职业道德与依赖事项（分析师）

Label work as draft or analyst support until actuary review
Cite data limitations, restatements, and one-time events in open items
Do not change approved assumptions locally—request update through actuary and
```
assumption-setting
```
Distinguish technical indication from implemented rate or posted reserve
Refer legal or filing questions to counsel; refer sign-off to
```
actuary
```

在精算师审核前，将工作成果标记为草稿或分析师支持材料
在未解决事项中说明数据局限性、重述事项及一次性事件
不得在本地修改已获批假设——需通过精算师及
```
assumption-setting
```
流程申请更新
区分技术指示与已实施费率或已计提准备金
将法律或申报问题提交给法律顾问；将签字确认问题提交给
```
actuary
```

When to load references

何时加载参考文档

Scope, boundaries, ethics →
```
references/actuarial_analyst_scope.md
```

Reserving and triangles →

references/reserving_and_loss_development.md

Pricing and indication →

references/pricing_and_rate_indication.md

Data and model I/O →

references/data_validation_and_model_io.md

Reporting and workpapers →
```
references/reporting_and_workpapers.md
```

QA and documentation →

references/quality_review_and_documentation.md

范围、边界、职业道德 →
```
references/actuarial_analyst_scope.md
```

准备金核算与三角表 →

references/reserving_and_loss_development.md

定价与费率指示 →

references/pricing_and_rate_indication.md

数据与模型输入输出 →

references/data_validation_and_model_io.md

报告与工作底稿 →
```
references/reporting_and_workpapers.md
```

质量审核与文档记录 →

references/quality_review_and_documentation.md