About the Role

PetDesk provides an industry-leading app and reminder platform which allows pet care providers to better communicate with pet parents. This platform both utilizes & produces a lot of data. The primary responsibility of this role is to build, organize, and maintain data structures representing this data in our data warehouse system. This person will be responsible for transforming and managing data so that it can be used by analysts or business users. This includes the full life-cycle from back-end development, to data model design, to business/data analyst support.

We’re looking for someone who understands effective approaches to managing, organizing, and optimizing the utilization of the product, partner, and operational data sets. The end goal is to enable our teams to deliver increased insights and better products, improving the lives of both pets and pet care providers.

Apply if you’re excited to:

• Automate regular data processing to consistently provide high quality data for analysis
• Build and maintain a cloud data warehouse (Snowflake), utilizing modern data stack technologies, with a focus on Data Vault modeling
• Develop and manage data workflows, pipelines, and cloud-based ETL design and processes 
• Provide reliable infrastructure for storing, processing, and visualizing large data sets
• Work with leadership, key stakeholders, and a growing team of data lovers, across data from multiple products, to deliver industry-leading data solutions

About You

• At least 3 years of experience in a Data Engineering role 
• Expertise with SQL, both querying and database administration
• Preferred DB systems: Snowflake, PostgreSQL, MS SQL
• In-depth technical experience with both dimensional and transactional data models
• Ability to design, implement, and troubleshoot data pipelines, with many data sources
• Strong programming skills, able to read & write code in modern languages
• Preferred languages: SQL, Python, JavaScript, C#
• Experience with SaaS product development, databases, and data models
• Proven success working with Data Analysts to deliver product & customer insights
• Comfortable with cloud platforms, MPP databases, container-based systems, and a focus on automated data processing
• Preferably have experience with several or more elements of our Data Stack:
• Airflow, AWS, Data Vault, Python, Snowflake, Tableau

Benefits & Perks
PetDesk is a remote organization focused on a culture, infrastructure, and ecosystem that supports team members’ participation in critical decisions and information sharing, regardless of location. Benefits and perks include:

• Medical coverage for employees and dependents (80-90% covered by employer)
• Employer HSA contribution with HDHP
• 401(k) match up to 3.5% 
• Dependent Care Flexible Spending Account (FSA)
• Dental & Vision coverage available 
• Basic Life and AD&D Insurance
• Short and Long Term Disability
• Flexible Time Off & 13 Paid Annual Holidays
• Paid Parental Leave
• Pawternity Leave, Financial Pet Adoption Support & Subsidized Pet Insurance
• $250 Annual Stipend for Learning and Development