DeveloperJobs.io
← Back to all jobs

Job Description

This role supports Western National Mutual Insurance Company as part of the modernization of its data platforms and delivery of reliable, production-ready data solutions. You will design, develop, test, deploy, and support complex data-centric applications, partnering with product teams to improve data quality and automate repeatable processes.

Based in Edina, MN with a hybrid work arrangement, the position involves hands-on work across cloud data engineering, including Snowflake and dbt, along with operational support for production incidents.

What you’ll do

  • Collaborate with product teams to design, develop, test, and deploy complex data applications and modifications aligned to defined requirements.
  • Create technical specifications, flowcharts, and data flow diagrams to communicate application designs and changes.
  • Prepare and execute unit tests for new and modified code and participate in code reviews using team standards.
  • Partner with product and change control teams to deliver quality solutions, refine work, estimate effort, and communicate project progress and roadblocks.
  • Troubleshoot application failures and data quality issues, leading resolution and communication for urgent production incidents.
  • Create and maintain technical documentation and share knowledge with colleagues and stakeholders.
  • Identify opportunities to automate processes and improve application reliability, team efficiency, and resource utilization.
  • Contribute to cloud data platform modernization by evaluating and applying Snowflake, dbt, and other cloud data engineering patterns as standards are established.
  • Support the transition from existing data platforms and ETL processes to cloud-based data engineering approaches.
  • Analyze dependencies among application components and recommend solutions to complex technical and business process challenges.
  • Contribute to team development practices, standards, and policies with consideration of product, architecture, and business priorities.
  • Provide timely, responsive support to internal customers and collaborate with teammates, other departments, and vendors.
  • Perform special projects and other duties as assigned.

What you bring

  • 5 to 8 years of relevant experience.
  • Advanced knowledge of data structures, relational databases, and data warehousing concepts.
  • Advanced proficiency in Python and SQL, including accessing and managing relational data.
  • Experience developing modular SQL transformations, data tests, and pipeline dependencies, applying these practices in Snowflake and dbt.
  • Advanced experience developing ETL solutions using Microsoft SSIS packages and stored procedures.
  • Advanced proficiency managing and merging software changes using version control tools such as Git and GitLab.
  • Working knowledge of software containerization and deployment tools.
  • Strong mathematical, analytical, problem-solving, organizational, and prioritization skills.
  • Ability to work independently, manage multiple complex assignments, and deliver high-quality work within established timelines.
  • Strong attention to detail and a demonstrated interest in data.
  • Ability to communicate technical concepts clearly to both technical and nontechnical audiences.
  • Experience contributing to an effective team operating within an agile framework.
  • Proficiency with standard office and computer software and equipment.
  • Bachelor’s degree in computer science or a related technical field.
  • Experience managing data in Microsoft SQL Server and PostgreSQL.
  • Hands-on experience with Snowflake and dbt (or comparable cloud data platforms), including modernization of legacy ETL or data warehouse workloads through reusable models, automated tests, and deployment workflows.
  • Experience mentoring colleagues and supporting their technical development.

Technologies

  • Snowflake, dbt, Python, SQL
  • Microsoft SSIS
  • Git, GitLab
  • Microsoft SQL Server, PostgreSQL
  • ETL, software containerization, cloud data engineering practices
  • Agile framework

Compensation

  • The targeted hiring range is $104,300 - $143,440 per year.
  • Base pay may vary based on job-related knowledge, skills, credentials, experience, scope, and location.
  • Candidates seeking compensation outside the posted range are encouraged to apply; consideration may be based on individual qualifications and/or other applicable positions.

Benefits and total rewards

  • Medical insurance plan options and other standard employee benefits, including dental, vision, life insurance, disability insurance, and more
  • Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA)
  • 401(k) Plan with participants eligible for 100% matching on the first 6% of contributions
  • Wellbeing Program, including an onsite fitness studio
  • Paid Time Off including holiday, vacation, and volunteer
  • 100% company-paid tuition reimbursement for approved job-relevant coursework and access to The Institutes (Risk and insurance education)
  • Paid parental leave
  • Bonus opportunities
  • Flexible work environment with hybrid and remote work arrangements designed to balance individual, job, department, and company needs

Work authorization

Applicants must be authorized to work for any employer in the U.S. The company is unable to sponsor or take over sponsorship of an employment Visa at this time.

Similar Jobs