Data Analytics Engineer

<h2>Overview</h2> <p><em>Founded in <strong>1898</strong>, Mutual of Enumclaw is a people-first insurer rooted in community, recognized as <strong>Washington’s Best Company to Work For</strong> for the <strong>14th consecutive year</strong>, and proudly serving individuals, families, farms, and businesses through local independent agents across the West.</em></p> <p> </p> <p>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.</p> <p> </p> <p><strong>Location:</strong> 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.)</p> <p> </p> <p><strong>Hiring Range: $140,891 - $157,545</strong></p> <p><strong>Salary Range: $140,891 - $171,631</strong></p> <p> </p> <p>*<em>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 <strong>click here.</strong></em></p> <p> </p> <h2>Responsibilities</h2> <p><strong>Supervisory Responsibilities:</strong></p> <ul> <li>None.</li> </ul> <p><strong>Responsibilities:</strong></p> <p> </p> <p><strong>Business Partnership & Delivery</strong></p> <ul> <li>Partner with stakeholders across Product, Actuarial, Underwriting, Claims, Finance, and Distribution to gather requirements and define KPIs, reporting needs, and data specifications</li> <li>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</li> <li>Translate business needs into scalable data solutions, dashboards, and analyses that support strategic and operational decision-making</li> <li>Support recurring and ad hoc reporting, including financial, operational, and executive reporting</li> </ul> <p><strong>Data Modeling & Engineering</strong></p> <ul> <li>Design, build, and maintain data models, transformations, and semantic layers within a Snowflake-based medallion architecture</li> <li>Develop scalable, testable data pipelines using SQL and dbt (or equivalent tools)</li> <li>Integrate data from internal and external sources (e.g., policy systems, Salesforce, HubSpot)</li> <li>Enable self-service analytics by designing semantic layers and certified data products that allow business users to answer their own questions without engineering intervention</li> </ul> <p><strong>Data Governance & Quality</strong></p> <ul> <li>Define and enforce data governance standards, including data definitions, access controls, and metadata management</li> <li>Validate and test data outputs to ensure accuracy and reliability</li> <li>Monitor data performance and continuously improve data products based on user feedback </li> </ul> <p><strong>Agile Delivery & Support</strong></p> <ul> <li>Collaborate with Product Owners and participate in Agile ceremonies (planning, refinement, sprint reviews)</li> <li>Define acceptance criteria and deliver high-quality data products</li> <li>Provide production support and troubleshoot data/reporting issues as needed</li> </ul> <p> </p> <h2>Qualifications</h2> <p><strong>Required Skills/Abilities: </strong></p> <ul> <li>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.</li> <li>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</li> <li>Strong experience with cloud data warehouses (Snowflake preferred) and transformation tools such as dbt</li> <li>Proficiency in SQL; working knowledge of Python or similar scripting languages preferred</li> <li>Solid understanding of dimensional modeling, ELT processes, and modern data architectures (e.g., medallion/lakehouse)</li> <li>Experience building or migrating to a modern data platform (e.g., legacy data warehouse to Snowflake/medallion architecture) preferred.</li> <li>Knowledge of data integration methods (APIs, flat files, semi-structured data) and cloud platforms (AWS or equivalent)</li> <li>Strong communication skills with the ability to translate technical concepts for business audiences</li> <li>Experience working in Agile environments</li> </ul> <p><strong>Education and Experience:</strong> </p> <ul> <li>Bachelor’s degree in data science, computer science, statistics, or a related field (or equivalent experience)</li> <li>5+ years of experience in data analytics, data engineering, or related roles</li> <li>Experience working with data systems, pipelines, and reporting solutions</li> <li>Experience in P&C insurance and familiarity with insurance data and metrics required (e.g., premium, loss, reserving)</li> <li>Working knowledge of insurance source systems such as Guidewire (PolicyCenter, ClaimCenter, BillingCenter), POINT, Duck Creek, or equivalent policy and claims administration platforms preferred</li> </ul> <p><strong>Physical Requirements:</strong> </p> <ul> <li>Prolonged periods of sitting at a desk and working on a computer, including video conferencing.</li> </ul> <p> </p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...