[Hiring] Senior Data Engineer @Scenthound Franchising

Role Description

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

Qualifications

• 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

Requirements

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

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