Senior Data Engineer

Job Description

Trupanion is a leading provider of medical insurance for cats and dogs in North America. Our mission is to help loving, responsible pet owners budget and care for their pets. At Trupanion, we offer a collaborative, casual, and pet-friendly environment where everyone is encouraged to be themselves.

Position Summary:

The Senior Data Engineer is responsible for designing and building reliable, scalable and auditable data systems and tools for deploying and monitoring our mission critical data systems and underlying infrastructure in Microsoft Azure. You’ll work with your team, peers, and executives to drive the evolution of Continuous Delivery for continuing growth and easier management. 

This position is open to candidates in the Seattle area. You will have a hybrid remote/in-office schedule where you will work from our casual, pet-friendly office at least 3 days a week.

What you will do:

• Design, implement, and maintain scalable data lakehouse solutions in Microsoft Azure, ensuring data reliability, integrity, and security.
• Develop, optimize, and manage ETL/ELT pipelines for data integration, transformation, and storage using Azure Data Factory, DataBricks, and Delta Lake.
• Collaborate with cross-functional teams to define data architecture strategies that support business goals and analytics requirements.
• Monitor and improve data pipeline performance, addressing bottlenecks and ensuring efficient data flow and processing.
• Implement best practices for data governance, data quality, and metadata management in the data lakehouse environment.
• Manage and optimize large-scale data processing jobs using Apache Spark and SparkSQL within the DataBricks environment.
• Develop and maintain automated data workflows and processes, leveraging Infrastructure as Code (IaC) and Policy as Code (PaC) where applicable.
• Ensure seamless integration of data sources, enabling real-time analytics and business intelligence through streaming and batch processing.
• Conduct regular audits of data infrastructure to ensure compliance with security policies and regulatory requirements.
• Provide technical leadership and mentorship to data engineers and data scientists, fostering a culture of continuous learning and improvement.

Experience you have:

• Bachelor’s level degree in Computer Science, Engineering, or appropriate work experience required 
• Minimum 5+ years of experience designing, building, and enhancing ETL processes for data warehousing, data marts, data integrations, data analysis across the enterprise 
• Minimum 3+ years of technical experience with data warehousing in a Microsoft/Azure environment with the following tools or similar: SQL Server, Azure SQL, Azure Synapse Analytics, Azure Data Lake Storage - ADLS Gen2, Azure Streaming Analytics, DataBricks, DeltaLake, Apache Spark/SparkSQL. Experience with similar tools in a Linux/AWS environment a plus. 
• Experience with software and infrastructure change management, release management and source code control required

What you’ll bring:

• Familiarity with Infrastructure as Code (IaC) and Policy as Code (PaC) is a plus 
• Involvement in designing and implementing data pipelines for a variety of flows (data integrations across systems, ETL/ELT pipelines, streaming analytics, big data analytics) 
• Hands on exposure to logging and monitoring solutions 
• Familiarity with Microsoft Azure IaaS & PaaS solutions 
• Expertise to continuously deliver while valuing and maintaining a strong attention to detail 
• Experience with Agile software development organizations 
• Ability to quickly identify and drive to the optimal solution when presented with a series of constraints 

Compensation:

• The pay range for this position is $135,000 - $147,000, on a full-time schedule.
• Along with base salary, Trupanion employees may be eligible for monthly bonuses.
• We want all employees to be invested in Trupanion’s success, so we grant Restricted Stock Units to all new team members. Our new hire grants vest over 4 years.

Additional Information

Benefits and Perks:

• Full medical, dental, and vision benefits at no cost to the employee
• Four weeks of paid time off and 9 paid float holidays (you can decide which days are most important to you!)
• Five-week sabbatical after five years of employment
• Open, casual, pet-friendly, and fun office environment
• Free medical health insurance for your pet (1 dog or cat)
• Paid time off to volunteer at nonprofit organizations
• Seattle Office Amenities: Free on-site gym, free dog walking services for office pets during business hours, free parking, and paid ORCA cards.

For more information about Trupanion, visit https://trupanion.com/about

Learn more about how Trupanion has revolutionized our industry and the reimbursement model: https://www.youtube.com/watch?v=vdWZ4KHiPTQ

Trupanion is an equal-opportunity employer and embraces diversity. We are committed to building a team that represents a variety of backgrounds, abilities, perspectives, and skills.

We will ensure that individuals are provided reasonable accommodation to participate in the job application or interview process, perform essential job functions, and receive other benefits and privileges of employment. Please contact us to request accommodations.