Sr. Data Engineer

Mutual of Enumclaw was founded in 1898 by local farmers who wanted to look out for each other. That spirit continues to define our company culture. We are committed to cultivating and preserving a culture of inclusion and connectedness. Our employees are proud of our thoughtful approach to insurance, and it shows. In January 2024, we were recognized as Washington's Best Company to Work For (our twelfth year in a row as one of the top 100) by Seattle Business magazine, based on a survey of our employees.

Mutual of Enumclaw works exclusively with local independent agents to offer insurance products for individuals, families, farms, and businesses. We currently operate in Washington, Oregon, Idaho, Utah, Arizona, Montana and Wyoming.

The Senior Data Engineer reports to the Director of Data Ops and Warehousing who is an experienced technical leader and performs complex tasks including deep data analysis, specification documentation, complex development, advisory on long term data strategies, and project tasks according to established methods, industry, and company standards. This role requires independent resolution of non-routine data issues and provides input for IT policy, processes, and modernization efforts. The Senior Data Engineer serves as an example, mentor, and technical leader across the IT department.

Location: 

The successful candidate will work remotely and/or at our Home Office in Enumclaw, WA. If remote, the candidate must be able to work during our core Pacific Standard Time (PST) business hours and must have high speed internet (internet speed test required).

Hiring Range: $131,000 - 146,000*

Salary Range: $131,000 - $164,000

*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 click here.

• Exemplify behaviors that support our IT vision and beliefs.
• Collaborate with the Agile team to develop, refine, and implement user needs.
• Develop and test data models to meet the organization’s needs.
• Monitor quality and performance of data pipelines through testing and maintenance.
• Integrate data with internal and external systems as needed.
• Troubleshoot, debug and upgrade existing data architecture and models.
• Gather and evaluate user feedback.
• Actively participate in Agile ceremonies to remove blockers, refine stories, plan Sprints, and review functionality with our business stakeholders.
• Provide training and mentorship for team members.
• Provide production support for data services to internal and external customers.
• Provide demos of work in front of large groups of stakeholders and team members.
• Role may include opportunities for specialized and/or temporary assignments.
• May be called on to work outside normal business hours.
• May provide formal leadership and facilitation within the assigned team.

Required Skills:

• Familiarity with Agile development methodologies.
• Advanced knowledge and experience working with property and casualty insurance data.
• Advanced knowledge of cloud data warehousing and security best practices.
• Advanced knowledge of building data pipelines in the cloud.
• Advanced knowledge of Python, SQL, Dbt, ELT, Cloud Data Warehouse (Snowflake, Databricks, etc.).
• Familiarity with Terraform or Infrastructure as Code concepts.
• Expert use of VS Code and extensions.
• Advanced knowledge of data warehouse storage patterns (Star, Snowflake, Data Lake, etc.).
• Hands on experience with SQL Server, SSIS, SSRS, and SSAS a plus.

Required Abilities:

• Ability to learn and mentor new languages and technologies, providing technical leadership to other engineers.
• Having an enhanced level of curiosity and a deep analytical mindset is a must.
• Ability to be effective on large and small projects where detail is key to great outcomes.
• Excellent communication skills requiring a high level of written and visual diagrams.
• Resourcefulness and troubleshooting aptitude.
• Ability to maintain a high level of quality control standards and apply standards in all aspects of testing, research, and throughout the development life cycle.
• Ability to be effective in both remote and corporate settings.
• Demonstrated ability to communicate effectively with teammates, stakeholders, and other partners in both written and verbal formats.

Education and Experience:

• High School Diploma or Equivalent.
• Bachelor’s Degree in Computer Science, Engineering, or a related field preferred.
• Professional education and certifications preferred.
• 10+ years of software/data engineering or similar roles.
• Extensive experience with data systems design and development where automated testing was used.
• Extensive experience with cloud data platforms.
• Mastery of understanding and usage of relational and non-relational databases.
• Job level and salary commensurate with experience.

Physical Requirements:

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