Senior Data Engineer

Senior Data Engineer - Job Description

Company Overview

Scenthound is the first membership-based franchise providing affordable and accessible wellness-focused dog care, committed to providing every dog with the care necessary to help maintain their health and keep them clean and happy. Franchising since 2019 and on pace to have over 200 locations open by the end of 2026, Scenthound is establishing itself as the preeminent solution for routine and preventive dog care.

Our values…

· Dog First . We advocate for the health and well-being of every dog in our care.

· One Pack . We are one company, one team, with one mission.

· Bring Love . We bring good energy to our work and do our jobs with loving intention.

· Seek Growth . We believe. We learn. We grow.

· Make a Difference . We work with purpose. We are driven by a desire to make a positive impact.

Role overview

Great growth starts with data people can trust. As our Senior Data Engineer, you will build the foundation that shows us how customers find us, what drives growth, and where to invest next.

The pipelines, models, and architecture you design will shape how the entire organization uses data for years to come, and your work will show up in measurable business results.

What you’ll do

Build Data pipelines

• Build and maintain ingestion from Google Ads, Meta Ads, Google Tag Manager/GA4, among many other data and web sources into Snowflake
• Choose the right approach for each source: managed connectors where they fit, custom Python/Airflow where they don’t
• Monitor pipeline health, catch schema and API changes early, and fix issues before the business notices

Data architecture and modeling

• Design and evolve our Snowflake architecture, including layering, naming, and modeling standards
• Build trusted, documented models that support a Customer 360 view
• Make build-vs-buy and tooling recommendations to the CTO, with trade-offs stated

Marketing activation (reverse ETL / CDP)

• Push modeled audiences and customer data from Snowflake back to marketing and operational tools
• Partner with marketing to turn data into usable segments and campaigns

Governance, security, and access

• Manage Snowflake roles, access controls, and handling of sensitive and personal data
• Support privacy and compliance requirements, flagging risks early

BI and analytics support

• Provide clean, well-defined datasets for dashboards and analysts
• Help troubleshoot metric definitions and data discrepancies

Cost and performance

• Monitor Snowflake spend, tune warehouses and queries, and set guardrails to keep costs predictable

What you bring

• 6+ years of data engineering experience, with deep hands-on Snowflake expertise (modeling, performance, security, cost control)
• Strong SQL and Python; experience building production pipelines with Airflow or a similar orchestrator
• Experience with dbt and with managed ingestion tools such as Fivetran, Airbyte, or Stitch
• Proven experience ingesting marketing and advertising data (Google Ads, Meta Ads, GTM/GA4 or similar) via APIs or connectors
• Working knowledge of Customer 360 concepts, identity resolution, and reverse ETL or CDP activation
• Experience with data governance: role-based access, PII handling, and auditability
• Ability to explain technical trade-offs clearly to non-technical stakeholders
• Comfort being the only or primary data engineer, owning work end to end

Nice to have

• Snowflake certification (SnowPro Core or Advanced)
• Experience with a reverse ETL platform, or a CDP
• Familiarity with BI tools such as Tableau, Power BI, or Looker
• Experience with CI/CD and infrastructure as code for data workloads
• Background in a multi-location, franchise, or consumer services business
• Experience with privacy regulations that affect marketing data (CCPA, consent management)

Compensation and Benefits

• Compensation commensurate with experience
• Health/Dental/Vision insurance
• Paid time off
• Company Paid Life and AD&D Insurance
• Short Term Disability
• 401k with company match
• Free Scenthound membership for your dog — because of course
• Applicants must be legally authorized to work in the United States. Employment Sponsorship will not be offered.

This is a remote position.