Remote Senior Analytics Engineer — P&C Insurance Data

Rockwoods Inc; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

Rockwoods Inc. is seeking a Senior Analytics Engineer with recent, hands-on P&C insurance experience to build analytics datasets, reporting layers, and business-ready data solutions.

The role requires deep knowledge of Policy, Claims, Billing, and Finance data and involves translating insurance business processes into accurate data models and reporting datasets, then delivering insights to insurance stakeholders.

Qualifications

• 6-10+ years in analytics engineering, data engineering, BI, or related role.
• Recent hands-on P&C insurance experience required, with Policy, Claims, Billing, or Finance exposure.
• Strong understanding of Policy lifecycle, Claims lifecycle, Billing transactions, or Finance fundamentals.
• Strong SQL and data modeling skills.
• Experience building analytics/reporting datasets and dimensional models.
• Hands-on experience with Tableau and/or Power BI.
• Data validation, testing, reconciliation, and data quality.
• Ability to work with business users and insurance terminology.

Responsibilities

• Build analytics datasets and reporting layers for P&C insurance.
• Work with Policy, Claims, Billing, and Finance data.
• Translate business requirements into data models, reporting logic, and insights.
• Analyze and validate data across source systems.
• Build dashboards and reporting using Tableau and/or Power BI.
• Perform data mapping, testing, reconciliation, and validation for accuracy.
• Collaborate with stakeholders across underwriting, policy administration, billing, finance, and ops.
• Identify data gaps and coordinate resolution with technical teams.

Skills

SQL

Data modeling

Tableau

Power BI

ETL

dbt

Snowflake

Data validation

Tools

SSIS

Qlik

Job description

Rockwoods Inc. is seeking a Senior Analytics Engineer with recent, hands-on P&C insurance experience to build analytics datasets, reporting layers, and business-ready data solutions.

The role requires deep knowledge of Policy, Claims, Billing, and Finance data and involves translating insurance business processes into accurate data models and reporting datasets, then delivering insights to insurance stakeholders.