P&C Insurance Industry – Data Analytics Engineer

Mutual of Enumclaw Insurance Company; Seattle (WA); On-site; USD 141,000 - 172,000; Full time

Job summary

Mutual of Enumclaw Insurance Company seeks an experienced P&C Insurance Industry Data Analytics Engineer to bridge raw data and business insights across underwriting, actuarial, claims, product, distribution, and finance, supporting all lines of business. You will design, build, and govern analytics-ready data assets and collaborate with stakeholders to deliver trusted reporting.

The role emphasizes Snowflake-based medallion architecture, dbt transformations, and modern data models with

Qualifications

• Bachelor’s degree in data science, computer science, statistics, or related field.
• 5+ years of experience in data analytics, data engineering, or related roles within the insurance industry.
• Experience working with data systems, pipelines, and reporting solutions.

Responsibilities

• Define KPIs and reporting requirements with stakeholders.
• Design and maintain dashboards and reports in Sigma and Power BI.
• Build scalable data models and pipelines in Snowflake/dbt.
• Integrate data from internal/external sources.

Skills

P&C insurance experience

Dashboard/reporting

SQL proficiency

Agile experience

Communication skills

Education

Bachelor’s degree in data science, CS, statistics

Tools

Sigma

Power BI

Snowflake

dbt

APIs

Job description

The P&C Insurance Industry Data Analytics Engineer at Mutual of Enumclaw will bridge the gap between raw data and business insights by designing, building, and governing analytics-ready data assets across the P&C (Property & Casualty) insurance value chain - Underwriting, Actuarial, Claims, Product, Distribution, and Finance - and all lines of business (Personal, Commercial, and Farm.)

This role translates insurance business logic into governed, scalable data models, partnering with stakeholders to deliver trusted reporting and analytics solutions and plays a key role in advancing our Snowflake-based medallion architecture and enabling data-driven decision-making across the company.

Location: Preference will be given to those residing in WA, OR, ID, MT, WY, AZ or UT. (Candidates must be able to work during our core Pacific Time Zone business hours.)

Responsibilities:

Business Partnership & Delivery

• Partner with business stakeholders to define KPIs, reporting requirements, and scalable analytics solutions that support strategic and operational decision-making
• Design and maintain dashboards, reports, and visualizations in Sigma, Power BI, or similar BI platforms to deliver trusted business insights
• Design and maintain scalable data models, pipelines, and semantic layers within a modern Snowflake/dbt architecture to support self-service analytics
• Integrate data from internal and external sources (e.g., policy systems, Salesforce, HubSpot)

Data Governance & Quality

• Define and enforce data governance standards, including data definitions, access controls, and metadata management
• Validate and test data outputs to ensure accuracy and reliability
• Monitor data performance and continuously improve data products based on user feedback

Agile Delivery & Support

• Collaborate with Product Owners and Agile teams to deliver high-quality data products
• Provide production support and troubleshoot data/reporting issues as needed

Required Skills and Abilities:

• P&C (Property & Casualty) insurance experience required, including familiarity with Underwriting, Claims, and Insurance reporting metrics
• Strong experience building dashboards and reports in Sigma, Power BI, or similar BI platforms
• Strong experience with cloud data warehouses (Snowflake preferred) and transformation tools such as dbt
• Solid understanding of dimensional modeling, ELT processes, and modern data architectures (e.g., medallion/Lakehouse)
• Knowledge of data integration methods including APIs and semi-structured data
• Strong communication skills with the ability to translate technical concepts for business audiences
• Experience working in Agile environments
• Proficiency in SQL

Education and Experience:

• 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 related roles within the insurance industry
• Experience working with data systems, pipelines, and reporting solutions

Hiring Range: $140,891 - $157,545

Salary Range: $140,891 - $171,631

*The Hiring Range represents Mutual of Enumclaw’s current hiring pay scale for this role. Mutual of Enumclaw reserves the right to modify or update this range any time. Exact compensation may vary based on skills and experience. Compensation is only one part of our entire total rewards package. To see some of the benefits and perks we offer, please.

Physical Requirements:

• Prolonged periods of sitting at a desk and working on a computer, including video conferencing.