Senior Data Engineer
- Salary
- $104.3K–$143.4K
- Hiring from
- United States
- Work type
- Hybrid
- Posted
625,617 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Description
Who are we?
Western National Insurance Group is a private mutual insurance company with over 120 years of experience serving customers' property-and-casualty insurance needs in the Midwestern, Northwestern, and Southwestern United States. Known as “The Relationship Company®,” we define success as a measure of the relationships we’ve built over time. In everything that we do, we know that delivering a friendly and helpful interaction makes for a better experience for everyone involved. That’s the power of “nice”. At Western National, nice is something we work to bring to every person and organization with whom we partner and serve.
Does this opportunity interest you?
Western National is seeking a Data Engineer III to join our team!
The individual in this role has the opportunity to design, develop, test, deploy, and support complex data-centric applications while improving data quality, automating processes, and contributing to the modernization of data platforms using Snowflake, dbt, and cloud data engineering practices.
What are the responsibilities and opportunities of this role?
- Collaborates with product teams to design, develop, test, and deploy complex data applications and modifications based on defined requirements.
- Develops technical specifications, flowcharts, and data flow diagrams to communicate application designs and changes.
- Prepares and executes unit tests for new and modified code and participates in code reviews according to team standards.
- Partners with product and change control teams to deliver quality solutions, refine work, estimate effort, and communicate project progress and roadblocks.
- Troubleshoots application failures and data quality issues and leads the resolution and communication of urgent production incidents.
- Creates and maintains technical documentation and shares knowledge with colleagues and stakeholders.
- Identifies automation and process improvement opportunities to improve application reliability, team efficiency, and resource utilization.
- Contributes to cloud data platform modernization by evaluating and applying Snowflake, dbt, and other cloud data engineering patterns as standards are established.
- Supports the transition from existing data platforms and ETL processes to cloud-based data engineering approaches.
- Analyzes dependencies among application components and recommends solutions to complex technical and business process challenges.
- Contributes to team development practices, standards, and policies while considering product, architecture, and business priorities.
- Provides timely, responsive support to internal customers and collaborates with teammates, other departments, and vendors.
- Performs special projects and other duties as assigned.
Requirements
What are the must-have qualifications for a candidate?
- Five to eight years of relevant experience.
- Advanced knowledge of data structures, relational databases, and data warehousing concepts.
- Advanced proficiency in Python, SQL, and accessing and managing relational data.
- Experience developing modular SQL transformations, data tests, and pipeline dependencies, with the ability to apply these practices in Snowflake and dbt.
- Advanced experience developing ETL solutions using Microsoft SSIS packages and stored procedures.
- Advanced proficiency in 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 technical and nontechnical audiences.
- Experience contributing to an effective team operating within an agile framework.
- Proficiency with standard office and computer software and equipment.
What will our ideal candidate have?
- 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.
Compensation overview
The targeted hiring range for this role is $104,300 - $143,440 annually. However, the base pay offered may vary depending on the job-related knowledge, skills, credentials, and experience of each candidate as well as other factors such as the scope and location of the role. Candidates looking for compensation outside of the posted range are encouraged to apply and will be considered based on their individual qualifications and/or may be considered for other positions.
Culture and Total Rewards
Western National has long been known as “The Relationship Company®” and caring for our employees is part of that relationship commitment. We value connectiveness, empowerment, and accountability, and we believe that our employees are our biggest asset.
Currently ranked as the 41st largest private company by revenue in Minnesota (Minneapolis/St. Paul Business Journal), Western National has earned accolades year-over-year as an employer of choice and garnered multiple awards for wellness in the workplace. Western National has also been named a Top Workplace by the Star Tribune for consecutive years. In addition, the Group is consistently recognized as a Ward’s 50 property-and-casualty insurance company for its outstanding financial results.
Western National offers full-time employees a significant Total Rewards Package, including:
- Medical insurance plan options and other standard employee benefits, including dental insurance, vision benefits, life insurance, disability insurance, and more!
- Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA)
- 401(k) Plan (participants are eligible for 100% matching on the first 6% of their 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
Western National believes in supporting balance between work and life by providing a flexible work environment, which includes a variety of hybrid and remote work arrangements designed to balance individual, job, department, and company needs.
Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Western National provides employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
