Data Analytics Engineer

Mutual of Enumclaw is a people-first insurer recognized as Washington’s Best Company to Work For. 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.

Responsibilities:

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

Requirements:

• 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
• Solid understanding of dimensional modeling, ELT processes, and modern data architectures (e.g., medallion/lakehouse)
• Strong communication skills with the ability to translate technical concepts for business audiences
• Experience working in Agile environments
• 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)
• Snowflake preferred
• Working knowledge of Python or similar scripting languages preferred
• 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)
• Working knowledge of insurance source systems such as Guidewire (PolicyCenter, ClaimCenter, BillingCenter), POINT, Duck Creek, or equivalent policy and claims administration platforms preferred