Senior Data Engineer
Job Description
Western National Mutual Insurance Company is seeking a Senior Data Engineer to design, build, test, deploy, and support complex data-centric applications. This hybrid role in Edina, MN focuses on improving data quality and automating processes while helping modernize data platforms using Snowflake and dbt alongside cloud data engineering practices.
Role Overview
The Senior Data Engineer will partner with product teams to deliver quality solutions, support production operations, and address urgent data and application incidents. The role also contributes to the transition from legacy data platforms and ETL processes toward cloud-based data engineering approaches.
Key Responsibilities
- 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 document and communicate application designs and changes.
- Prepare and execute unit tests for new and modified code and participate in code reviews per team standards.
- Work 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.
- Develop and maintain technical documentation and share knowledge with colleagues and stakeholders.
- Identify automation and process improvements to enhance application reliability, team efficiency, and resource utilization.
- Support cloud data platform modernization by evaluating and applying Snowflake, dbt, and other cloud data engineering patterns as standards are established.
- Assist with migrating from existing data platforms and ETL processes to cloud-based data engineering methods.
- Analyze dependencies among application components and recommend solutions to complex technical and business process challenges.
- Contribute to team development practices, standards, and policies with attention to 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.
Required Qualifications
- Five to eight 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, including application of these practices in Snowflake and dbt.
- Advanced experience developing ETL solutions using Microsoft SSIS packages and stored procedures.
- Advanced proficiency using version control tools such as Git and GitLab to manage and merge software changes.
- 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 demonstrated interest in data.
- Ability to communicate technical concepts clearly to 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 and 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, and other factors including scope and location.
- Candidates seeking compensation outside the posted range are encouraged to apply and may be considered based on individual qualifications, or considered for other positions.
Benefits
- Medical insurance plan options and other standard employee benefits, including dental, vision, life, disability, and more.
- Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA).
- 401(k) Plan with 100% matching on the first 6% of contributions.
- Wellbeing Program, including 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 a variety of 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. Western National is unable to sponsor or take over sponsorship of an employment Visa at this time.
Position Location
Edina, MN (hybrid)