Data Engineer

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. We offer a collaborative, casual, and pet-friendly environment where everyone is encouraged to be themselves.

About the role

We are looking for a dynamic, forward-thinking Data Engineer to design, build, and optimize reliable, scalable, and auditable data systems on our modern Databricks Lakehouse platform hosted in Microsoft Azure. This role focuses on the cutting edge of data engineering—thinking, designing, and documenting data marts—with a strong emphasis on data quality and governance. You will work closely with your team and peers to drive the evolution of continuous delivery, automated quality frameworks, and agile data products.

This position is open across the United States with a preference for those in Seattle or the East Coast time zone. Seattle candidates will have a hybrid remote/in-office schedule, working from our casual, pet-friendly office at least 3 days a week.

Responsibilities

• Ensure continuous, accurate data availability by monitoring, troubleshooting, and optimizing batch and real-time streaming pipelines across the Medallion architecture to deliver stable, high-availability data feeds with minimal downtime.
• Deliver query-ready Gold-layer data marts, dimensional models, and aggregate tables by partnering directly with Data Analytics and Data Science teams to map business requirements into high-performance user-facing schemas.
• Protect the integrity of the Lakehouse by configuring automated validation gates and alerts at the ingestion stage to catch and block corrupt or non-compliant source data.
• Maintain flawless data integrity and trust across all data products by writing, deploying, and maintaining automated data quality test suites and expectations for key transformation stages.
• Ensure all data assets are easily discoverable by documenting schemas and applying metadata tags.
• Serve as an autonomous data engineering partner to downstream teams by proactively investigating data discrepancies, resolving support tickets, and aligning business definitions to unblock analysts and data scientists.

Requirements

• Bachelor’s level degree or higher in Computer Science, Engineering, or equivalent practical experience.
• Minimum 2+ years of experience designing, building, and enhancing high-performance pipelines (ETL/ELT) and optimized Data Marts across the enterprise.
• Minimum 2+ years of deep technical experience within a Databricks-centric environment leveraging:
  • Delta Lake & Apache Spark (PySpark / SparkSQL)
  • Unity Catalog for data governance, lineage, and documentation
  • Delta Live Tables (DLT) or similar orchestration tools
• Proven experience implementing robust data quality, testing, and monitoring frameworks (e.g., Great Expectations, Databricks Expectations, or custom data quality gates) to ensure flawless data integrity.
• Experience with software and infrastructure change management, CI/CD pipelines (Azure DevOps/GitHub Actions), and source code control.

Skills

• Passion for modern Lakehouse Architecture, including the Medallion Architecture (Bronze/Silver/Gold), Data Contracts, and decentralized data design.
• Strong conceptual thinker who designs and documents data assets, schemas, and definitions directly within Unity Catalog.
• Hands-on experience implementing data pipelines for batch data integrations, real-time streaming analytics (Structured Streaming), and big data analytics.
• Experience setting up comprehensive logging, alerting, and monitoring solutions for Spark jobs and data pipelines.
• Thrives in a fast-paced, Agile software development environment with a proactive drive to learn and adopt new tools as the Databricks ecosystem evolves.

Pay

The base salary range for this position is $130,000 - $150,000, on a full-time schedule. Along with base compensation, employees are eligible for monthly bonuses and Restricted Stock Units that vest over 4 years.

Benefits

• Full medical, dental, and vision benefits at no cost to the employee.
• Four weeks of paid time off and 9 paid float holidays.
• 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.