Note: The job is a remote job and is open to candidates in USA. Mutual of Enumclaw is a people-first property and casualty insurer serving individuals, families, farms, and businesses through independent agents. The Data Analytics Engineer designs and governs analytics-ready data assets, builds data models and pipelines, and delivers dashboards and reporting solutions across the insurance value chain. The role also supports data governance, Agile delivery, self-service analytics, and production troubleshooting.
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
- 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)
- Prolonged periods of sitting at a desk and working on a computer, including video conferencing
- 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
- Proficiency in SQL; 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
- Working knowledge of insurance source systems such as Guidewire (PolicyCenter, ClaimCenter, BillingCenter), POINT, Duck Creek, or equivalent policy and claims administration platforms preferred
- Location: Remote, with preference given to those residing in WA, OR, ID, MT, WY, AZ, or UT
Benefits
- Remote work
Company Overview
Company H1B Sponsorship