The posting
Company 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.
Job Description
We are seeking a Senior Analytics Engineer, Finance Data to design and build scalable, governed data models that support financial reporting and analytics.
This role sits at the intersection of Analytics, Data Engineering, and Finance. You will work closely with Finance and technical teams to understand complex reporting and operational needs, investigate existing data and business logic, and translate that knowledge into reliable, reusable data products in Databricks.
The immediate focus is redesigning how financial data is structured, governed, and delivered across the organization. This role will help modernize the Finance data environment by building scalable data models, reducing reliance on report-specific logic, and creating new data solutions that enable Finance to take greater advantage of Databricks, automation, and AI-enabled capabilities.
This is a highly hands-on role for someone who can work through ambiguity, reason critically about data, and take solutions from discovery through production implementation.
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.
Key Responsibilities
- Design and build a scalable, governed financial data mart in Databricks that supports reliable financial reporting and analytics.
- Partner with Finance and subject-matter experts to translate complex financial requirements and business logic into reliable data solutions.
- Investigate existing data, reporting logic, and processes to identify inconsistencies, simplify transformations, and establish standardized definitions.
- Centralize shared financial definitions, business rules, and transformations within reusable data models to support consistent reporting across the organization.
- Build reconciliation, validation, and data-quality processes to ensure financial data is accurate, traceable, and audit-ready.
- Partner with Data Engineering and Analytics teams on upstream dependencies, architecture decisions, and adoption of governed financial data products.
- Troubleshoot complex data issues and continuously improve the reliability, maintainability, and scalability of Finance data solutions.
- Identify and develop opportunities to modernize Finance processes and analytics through Databricks, automation, and AI-enabled solutions.
Required Qualifications
- 5 - 8 years of demonstrated experience in analytics engineering, data engineering, or data modeling, with a track record of independently designing and delivering production data solutions.
- Advanced SQL skills and experience working with complex relational and transactional data.
- Strong proficiency in Python and PySpark for data transformation, pipeline development, and analysis.
- Hands-on experience developing production data solutions in Databricks.
- Strong understanding of dimensional modeling, including fact and dimension design.
- Strong understanding of data quality, reconciliation, lineage, and historical data considerations.
- Experience with Git-based source control and modern software development practices.
- Ability to translate ambiguous business requirements into clear technical solutions.
- Strong technical judgment, problem-solving, and communication skills.
Preferred Qualifications
- Experience working with financial, accounting, billing, claims, or other complex transactional data.
- Experience building financial data marts, governed reporting layers, or other reusable analytical data products.
- Experience supporting SOX-controlled or otherwise highly governed reporting environments.
- Experience modernizing Finance or business processes through automation, advanced analytics, or AI-enabled solutions.
- Experience working in insurance, financial services, healthcare, or another regulated industry.
- Familiarity with Databricks governance and platform capabilities such as Unity Catalog, lineage, and access controls.
Ideal Candidate
The ideal candidate is comfortable operating at the intersection of business and technology. They can understand the financial meaning behind the data, investigate complex or inconsistent logic, and translate that understanding into scalable technical solutions.
They are curious, pragmatic, and comfortable working through ambiguity. They can independently investigate existing systems and processes, ask the right questions, challenge assumptions when appropriate, and partner effectively with Finance, Analytics, and Data Engineering.
Compensation:
- The base salary range for this position is $120,000 - $130,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.
#LI-Hybrid
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.
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.
