Data Analytics Engineer

Actus Actuarial Search; United States; Remote; USD 140,000 - 171,000; Full time

Benefits offered by this job

Remote work

Salary up to $171K

Job summary

Actus Actuarial Search is seeking a Data Analytics Engineer to bridge complex insurance data and business insights. You’ll build analytics-ready assets across underwriting, actuarial, claims, product, distribution, and finance within a Snowflake-based data environment.

You will design data models, pipelines, and semantic layers, and develop dashboards using Sigma, Power BI, or similar tools. The role emphasizes governance, self-service analytics, and collaboration with cross-functional teams in

Qualifications

• Bachelor’s degree in Data Science, Computer Science, Statistics, or related field, or equivalent experience.
• 5+ years of experience in data analytics or data engineering.
• P&C insurance experience required with understanding of premium, loss, and reserving.
• Strong experience building dashboards/reports in Sigma/Power BI or equivalent BI tools.
• Experience with Snowflake and transformation tools such as dbt.
• Strong SQL skills; Python or similar scripting experience preferred.
• Understanding of dimensional modeling, ELT, and modern data architectures.
• Experience with data integration methods including APIs, flat files, and semi-structured data.
• Experience working in Agile environments.
• Strong communication skills translating technical concepts for business stakeholders.
• Familiarity with Guidewire, POINT, Duck Creek or similar insurance systems.
• Experience migrating from legacy data warehouses to Snowflake or modern platforms.

Responsibilities

• Partner with cross-functional teams to define KPIs, reporting requirements, and data specs.
• Build and maintain dashboards, reports, and visualizations using Sigma, Power BI, or similar BI tools.
• Design and maintain data models, transformations, semantic layers, and pipelines in a Snowflake-based architecture.
• Develop scalable data pipelines using SQL and dbt.
• Integrate data from internal and external sources including policy systems and CRM platforms.
• Build certified data products and semantic layers enabling self-service analytics.
• Establish data governance standards around definitions, access, metadata, and quality.
• Validate data outputs and troubleshoot reporting or production issues.
• Support recurring and ad hoc financial, operational, and executive reporting.
• Collaborate in an Agile environment and participate in planning, refinement, and sprint reviews.
• Continuously improve data products based on stakeholder feedback.

Skills

KPI definition

Dashboards & reporting

Data modeling

Data pipelines

SQL

dbt

Python

Snowflake

Sigma/Power BI

Data integration

Agile

Communication with stakeholders

Education

Bachelor’s degree in Data Science/CS/Statistics

Tools

Snowflake

dbt

Sigma

Power BI

Job description

Our client is a well-established P&C insurer seeking a Data Analytics Engineer to bridge the gap between complex insurance data and actionable business insights.

You’ll design and build analytics-ready data assets across Underwriting, Actuarial, Claims, Product, Distribution, and Finance, supporting Personal, Commercial, and Farm lines of business. This is a hands-on opportunity to work with modern data architecture, build trusted reporting solutions, and help advance a Snowflake-based data environment.

Our Client

Regarded as a people-first insurer company with a strong community focus and a track record of being recognized as one the Best Companies to Work for 10+ years. Their people-first philosophy fosters an environment where your work directly shapes the future of the company while supporting your professional growth and work-life balance.

Location: Remote

What will you be doing?

• Partner with Product, Actuarial, Underwriting, Claims, Finance, and Distribution teams to define KPIs, reporting requirements, and data specifications
• Build and maintain dashboards, reports, and visualizations using Sigma, Power BI, or similar BI platforms
• Design and maintain data models, transformations, semantic layers, and pipelines within a Snowflake-based medallion architecture
• Develop scalable and testable data pipelines using SQL and dbt
• Integrate data from internal and external sources, including policy systems and CRM platforms
• Build certified data products and semantic layers that enable business teams to perform self-service analytics
• Establish data governance standards around definitions, access, metadata, and quality
• Validate data outputs and troubleshoot reporting or production issues
• Support recurring, ad hoc, financial, operational, and executive reporting
• Collaborate within an Agile environment and participate in planning, refinement, and sprint reviews
• Continuously improve data products based on stakeholder feedback

What do you need to succeed?

• Bachelor’s degree in Data Science, Computer Science, Statistics, or a related field, or equivalent experience
• 5+ years of experience in data analytics, data engineering, or a related field
• P&C insurance experience required, with a strong understanding of the insurance value chain and core metrics such as premium, loss, and reserving
• Strong experience building dashboards and reports in Sigma, Power BI, or equivalent BI platforms
• Strong experience with Snowflake and transformation tools such as dbt
• Strong SQL skills; Python or similar scripting experience preferred
• Understanding of dimensional modeling, ELT processes, and modern data architectures
• Experience with data integration methods including APIs, flat files, and semi-structured data
• Experience working in Agile environments
• Strong communication skills and the ability to translate technical concepts for business stakeholders
• Familiarity with insurance systems such as Guidewire, POINT, Duck Creek, or similar platforms preferred
• Experience migrating from legacy data warehouses to modern platforms such as Snowflake preferred

Why Apply?

• Remote opportunity!
• $140K+ hiring range, with salary potential up to $171K
• Work across the full P&C insurance value chain
• Hands-on exposure to Snowflake, dbt, modern data architecture, and BI
• Opportunity to help shape and improve a modern data environment
• Partner directly with actuarial, underwriting, claims, product, finance, and distribution teams
• Build data products that directly support business and strategic decision-making