Trupanion is a leading provider of medical insurance for cats and dogs in North America. Our mission is to help the pets we all love receive the veterinary care they need. At Trupanion, we offer a collaborative, casual, and pet-friendly environment where everyone is encouraged to be themselves.
The 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 an entirely remote role open to candidates anywhere in Canada.
Qualifications - Please include a cover letter with your application
Education, Registration & Certification:
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 is a plus.
Experience required with software and infrastructure change management, release management, and source code control
Experience with Infrastructure as Code (IaC) and Policy as Code (PaC) is a plus
Skills, Knowledge & Abilities:
Proven experience 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 experience with logging and monitoring solutions
Experience with Microsoft Azure IaaS & PaaS solutions
Experience driving to towards Continuous Delivery while valuing and maintaining strong attention to detail
Experience with Agile software development organizations
An ability to quickly identify and drive to the optimal solution when presented with a series of constraints
Benefits and Perks:
Employer-paid extended health coverage for you and your family
Four weeks paid time off
Five week, paid, sabbatical after five years of employment
Restricted Stock Units
Open, casual, pet-friendly, and fun work environment
Employer-paid medical insurance for one pet (cat or dog)
Paid time off to volunteer at nonprofit organizations
We're all about helping pets. We promote a cohesive and nimble team environment, and we hire, develop and promote team members. We trust each other. We are transparent and honest. We care about one another and want to see our team members succeed, personally and professionally. We strive to promote from within and reduce bureaucracy to allow creative thinking. We're focused on providing continuous training and support to all team members to encourage long-term happiness and success.
Take a look inside our office and see for yourself:
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 with disabilities 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.