Data Engineer

What you will do

• Data Ingestion & Pipeline Reliability: Responsible for ensuring 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.
• Data Mart Delivery & Business Modeling: Responsible for delivering 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.
• Data Contract Validation & Ingestion Quality: Responsible for protecting 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
• Data Quality Frameworks & Precision: Responsible for maintaining 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.
• Data Governance & Asset Discoverability: Responsible for ensuring all data assets are easily discoverable by documenting schemas, applying metadata tags
• Cross-Functional Collaboration & Autonomy: Responsible for serving 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.

Experience you have

What you’ll bring

Compensation

• The base salary range for this position is $130,000 - $150,000, on a full-time schedule.
• Along with base compensation, Trupanion employees are currently 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.

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.
• 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.