Data Analytics Engineer

Mutual Of Enumclaw Insurance Holding Company; Enumclaw (WA); Presencial; USD 141.000 - 172.000; Jornada completa

Descripción de la vacante

Mutual of Enumclaw Insurance Holding Company is seeking a Data Analytics Engineer to bridge raw data and business insights across the P&C value chain. You will design, build, and govern analytics-ready data assets and participate in Snowflake-based medallion architecture to enable data-driven decisions.

The role emphasizes collaboration with stakeholders, dashboards, data modeling, and scalable data pipelines using SQL and dbt. Remote with preference for WA/OR/ID; core PST hours required.

Formación

• P&C insurance industry knowledge with understanding of the insurance value chain (underwriting through claims).
• Experience designing and publishing dashboards/reports in Sigma/Power BI with data modeling for self-service.
• Proficiency in SQL; Python or similar scripting language preferred.
• Knowledge of cloud data warehouses (Snowflake preferred) and dbt or equivalent tools.

Responsabilidades

• Partner with stakeholders across Product, Actuarial, Underwriting, Claims, Finance, and Distribution to define KPIs and reporting needs.
• Design, build, and maintain dashboards, reports, and visualizations delivering trusted insights to underwriters, actuaries, claims leaders, and executives.
• Translate business needs into scalable data solutions and analyses to support decision-making.
• Provide production support and troubleshoot data/reporting issues as needed.

Conocimientos

P&C insurance domain

SQL

Python

Power BI

Sigma

dbt

Data modeling

Cloud data warehouse

Agile

Communication

Educación

Bachelor’s degree in data science / CS / statistics

Herramientas

Snowflake

Salesforce

HubSpot

Descripción del empleo

Overview

Founded in 1898, Mutual of Enumclaw is a people-first insurer rooted in community, recognized as Washington’s Best Company to Work For for the 14th consecutive year, and proudly serving individuals, families, farms, and businesses through local independent agents across the West.

The Data Analytics Engineer bridges the gap between raw data and business insights by designing, building, and governing analytics-ready data assets across the P&C insurance value chain - Underwriting, Actuarial, Claims, Product, Distribution, and Finance - and all lines of business (Personal, Commercial, and Farm). Translating insurance business logic into governed, scalable data models, the Data Analytics Engineer partners with stakeholders to deliver trusted reporting and analytics solutions and plays a key role in advancing Mutual of Enumclaw's Snowflake-based medallion architecture and enabling data-driven decision-making across the company.

Location: Remote, with preference given to those residing in WA, OR, ID, MT, WY, AZ, or UT. (Candidates must be able to work during our core Pacific Standard Time business hours and have high-speed internet – an internet speed test is required.)

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

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

Responsibilities

Supervisory Responsibilities:

• None.

Responsibilities:

Business Partnership & Delivery

• Partner with stakeholders across Product, Actuarial, Underwriting, Claims, Finance, and Distribution to gather requirements and define KPIs, reporting needs, and data specifications
• Design, build, and maintain dashboards, reports, and visualizations in Sigma, Power BI, or equivalent BI platforms that deliver trusted insights to underwriters, actuaries, claims leaders, distribution partners, and executive leadership
• Translate business needs into scalable data solutions, dashboards, and analyses that support strategic and operational decision-making
• Support recurring and ad hoc reporting, including financial, operational, and executive reporting

Data Modeling & Engineering

• Design, build, and maintain data models, transformations, and semantic layers within a Snowflake-based medallion architecture
• Develop scalable, testable data pipelines using SQL and dbt (or equivalent tools)
• Integrate data from internal and external sources (e.g., policy systems, Salesforce, HubSpot)
• Enable self-service analytics by designing semantic layers and certified data products that allow business users to answer their own questions without engineering intervention

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 participate in Agile ceremonies (planning, refinement, sprint reviews)
• Define acceptance criteria and deliver high-quality data products
• Provide production support and troubleshoot data/reporting issues as needed

Qualifications

Required Skills/Abilities:

• P&C insurance industry experience required, with demonstrated understanding of the insurance value chain from underwriting through claims and fluency in core insurance concepts, terminology, and reporting metrics.
• Strong experience designing, building, and publishing dashboards and reports in Sigma, Power BI, or equivalent BI platforms, including data modeling for self-service consumption required
• Strong experience with cloud data warehouses (Snowflake preferred) and transformation tools such as dbt
• Proficiency in SQL; working knowledge of Python or similar scripting languages preferred
• Solid understanding of dimensional modeling, ELT processes, and modern data architectures (e.g., medallion/lakehouse)
• Experience building or migrating to a modern data platform (e.g., legacy data warehouse to Snowflake/medallion architecture) preferred.
• Knowledge of data integration methods (APIs, flat files, semi-structured data) and cloud platforms (AWS or equivalent)
• Strong communication skills with the ability to translate technical concepts for business audiences
• Experience working in Agile environments

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
• Experience working with data systems, pipelines, and reporting solutions
• Experience in P&C insurance and familiarity with insurance data and metrics required (e.g., premium, loss, reserving)
• Working knowledge of insurance source systems such as Guidewire (PolicyCenter, ClaimCenter, BillingCenter), POINT, Duck Creek, or equivalent policy and claims administration platforms preferred

Physical Requirements:

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