Data Analytics Engineer

Actus Actuarial Search; EE. UU.; A distancia; USD 140.000 - 171.000; Jornada completa

Descripción de la vacante

Actus Actuarial Search represents a well-established P&C insurer seeking a Data Analytics Engineer to turn complex data into business insights. You will design analytics-ready assets across Underwriting, Actuarial, Claims, Product, Distribution, and Finance, supporting Personal, Commercial, and Farm lines, with a Snowflake-based environment.

You’ll build dashboards and data pipelines using SQL, dbt, Sigma/Power BI, and contribute to data governance, modeling, and self-service analytics in a

Formación

• 5+ years in data analytics or data engineering.
• P&C insurance domain knowledge (premium, loss, reserving).
• Dashboards/reports in Sigma or Power BI.
• Snowflake and dbt experience.
• Strong SQL; Python or scripting preferred.
• Dimensional modeling and ELT concepts.
• APIs, flat files, and semi-structured data integration.
• Experience in Agile environments.
• Strong communication with business stakeholders.
• Experience with Guidewire/Duck Creek-like systems.
• Legacy to Snowflake migrations experience.

Responsabilidades

• Define KPIs, reporting requirements, and data specs with cross-functional teams.
• Build dashboards, reports, and visualizations using Sigma or Power BI.
• Design data models, transformations, and pipelines in Snowflake.
• Develop scalable data pipelines using SQL and dbt.
• Integrate data from policy systems and CRM platforms.
• Create certified data products and semantic layers for self-service analytics.
• Establish data governance around definitions, metadata, quality.
• Validate outputs and troubleshoot reporting or production issues.
• Support recurring and ad hoc financial, operational, and executive reporting.
• Collaborate in Agile planning, refinements, and sprints.
• Improve data products based on stakeholder feedback.

Conocimientos

Data analytics

SQL

Python

Agile experience

Communication skills

Educación

Bachelor's degree in Data Science, Computer Science, Statistics, or related field

Herramientas

Power BI

Sigma

dbt

Snowflake

Descripción del empleo

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 of 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