Logo for Legatis

Associate, Reporting Analytics

Role overview

Qualifications

  • 4–7 years in a reporting, analyst, or FPA role
  • Expert Excel: Power Query, complex formulas, structured model-building
  • Functional Power BI
  • BS. in Finance, Accounting, Actuarial Science, Math, or Statistics

Responsibilities

  • Own monthly and quarterly reporting packages — claims, financial, and board exhibits — end to end
  • Build, maintain, and refresh Power BI dashboards
  • Validate and reconcile data: confirm every exhibit ties to source and flag discrepancies clearly
  • Format board and sponsor decks to a professional standard

Key facts

Hard skills

Other skills

  • Microsoft Excel
  • Detail Oriented
  • Time Management
  • Communication

About the company

Legatis logo

Legatis

  • Insurance
  • TPE
  • 2–10
Legatis, LLC provides legacy liability solutions to private and public companies through structured acquisitions, engineered to deliver finality and eliminate legacy risk from their balance sheets.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Senior Reporting Analyst

Legatis a subsidiary of Obra Capital Inc. runs on data: claims metrics, financial results, and portfolio analytics that drive board, investor, and sponsor decisions. We are hiring an Associate, Reporting Analytics to own the production of that reporting turning prepared data into clean, reliable, repeatable exhibits and dashboards.

You will work directly with our Chief Actuary, Controller, and Claims leadership, who own what the numbers mean. The underlying data pipelines and semantic models are maintained by our data-engineering resource. Your job is the reporting and validation layer in between: making sure every exhibit is accurate, on time, and formatted to a professional standard. This is a core production role, not an add-on — it should represent a substantial portion of your day.

Responsibilities 

  • Own monthly and quarterly reporting packages — claims, financial, and board exhibits — end to end
  • Build, maintain, and refresh Power BI dashboards
  • Validate and reconcile data: confirm every exhibit ties to source and flag discrepancies clearly
  • Format board and sponsor decks to a professional standard
  • Automate recurring reports using Power Query, Power BI, and Excel

Requirements

  • 4–7 years in a reporting, analyst, or FP&A role
  • Expert Excel: Power Query, complex formulas, structured model-building
  • Functional Power BI
  • BS. in Finance, Accounting, Actuarial Science, Math, or Statistics
  • Insurance or financial-services domain knowledge
  • Experience with insurance billing, claim data reconciliation, or claims coordination

Compensation

Compensation is competitive and commensurate with experience. Details will be discussed during the interview process.

Related jobs

See all jobs

Other jobs at Legatis