Note: The job is a remote job and is open to candidates in USA. Mutual of Enumclaw is a people-first insurer recognized for its commitment to community and service. The Data Analytics Engineer will bridge the gap between raw data and business insights, designing and governing analytics-ready data assets across the P&C insurance value chain. This role involves partnering with stakeholders to deliver trusted reporting and analytics solutions while advancing the company's Snowflake-based architecture.
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
Skills
- 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)
- 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
- 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)
- Experience building or migrating to a modern data platform (e.g., legacy data warehouse to Snowflake/medallion architecture)
- Working knowledge of insurance source systems such as Guidewire (PolicyCenter, ClaimCenter, BillingCenter), POINT, Duck Creek, or equivalent policy and claims administration platforms
Company Overview