Senior Data Engineer

Scenthound

United States

Remote

USD 140,000 - 180,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

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 yourdog
In-house training
Clear career path
Attainable advancement

Job summary

Scenthound is seeking an experienced Data Engineer to own end-to-end ingestion pipelines and Snowflake architecture. You will work with marketing data, APIs, and ETL tools to deliver reliable data for dashboards and customer analytics, while enforcing governance and privacy.

You will collaborate with stakeholders, optimize costs, and contribute to a robust Customer 360 data fabric across franchise locations. This role requires strong SQL, Python, and Airflow expertise in a US-based environment.

Qualifications

  • 6+ years of data engineering experience.
  • Snowflake expertise: modeling, performance, security, and cost control.
  • Strong SQL and Python.
  • Experience building production pipelines with Airflow or a similar orchestrator.
  • Experience with dbt.
  • Experience with managed ingestion tools such as Fivetran, Airbyte, or Stitch.
  • Proven experience ingesting marketing and advertising data via APIs or connectors.
  • Familiarity with Customer 360 concepts, identity resolution, and reverse ETL or CDP activation.
  • Experience with data governance, including role-based access, PII handling, and auditability.
  • Ability to explain technical trade-offs clearly to non-technical stakeholders.
  • Authorized to work in the United States; employer sponsorship not offered.

Responsibilities

  • Build and maintain ingestion pipelines from ad platforms and data sources into Snowflake.
  • Select connectors or Python/Airflow approaches for each source.
  • Monitor pipeline health and resolve schema/API changes.
  • Design and evolve Snowflake architecture and data models.
  • Provide clean datasets for dashboards and analysts.
  • Push modeled data to marketing/operational tools and support campaigns.
  • Collaborate with marketing on segments and campaigns.
  • Manage Snowflake roles, access controls, and data privacy.

Skills

SQL
Python
Airflow
Data modeling
Data governance
PII handling
Identity resolution
Reverse ETL
CDP activation
Communication with stakeholders

Tools

Snowflake
Airflow
dbt
Fivetran
Airbyte
Stitch
Tableau
Power BI
Looker

Job description

  • Build and maintain ingestion pipelines from Google Ads, Meta Ads, Google Tag Manager/GA4, and other data and web sources into Snowflake
  • Select appropriate managed connectors or custom Python/Airflow approaches for each source
  • Monitor pipeline health, detect schema and API changes, and resolve issues proactively
  • Design and evolve Snowflake architecture, including layering, naming, and modeling standards
  • Build trusted, documented models supporting a Customer 360 view
  • Recommend build-versus-buy decisions and tooling to the CTO, with trade-offs clearly stated
  • Push modeled audiences and customer data from Snowflake to marketing and operational tools
  • Partner with marketing to create usable segments and campaigns
  • Manage Snowflake roles, access controls, and sensitive and personal data
  • Support privacy and compliance requirements and flag risks early
  • Provide clean, well-defined datasets for dashboards and analysts
  • Troubleshoot metric definitions and data discrepancies
  • Monitor Snowflake spend, tune warehouses and queries, and establish cost guardrails
  • 6+ years of data engineering experience
  • Deep hands-on Snowflake expertise, including modeling, performance, security, and cost control
  • Strong SQL and Python
  • Experience building production pipelines with Airflow or a similar orchestrator
  • Experience with dbt
  • Experience with managed ingestion tools such as Fivetran, Airbyte, or Stitch
  • Proven experience ingesting marketing and advertising data via APIs or connectors, including Google Ads, Meta Ads, and GTM/GA4 or similar
  • Working knowledge of Customer 360 concepts, identity resolution, and reverse ETL or CDP activation
  • Experience with data governance, including 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 and owning work end to end
  • Applicants must be legally authorized to work in the United States
  • Employment sponsorship will not be offered
  • Snowflake certification, such as SnowPro Core or Advanced, is nice to have
  • Experience with a reverse ETL platform or CDP is nice to have
  • Familiarity with Tableau, Power BI, or Looker is nice to have
  • Experience with CI/CD and infrastructure as code for data workloads is nice to have
  • Background in a multi-location, franchise, or consumer services business is nice to have
  • Experience with privacy regulations affecting marketing data, including CCPA and consent management, is nice to have
  • 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
  • In-house training
  • Clear career path
  • Attainable advancement
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer – Snowflake
Senior Data Engineer – Snowflake

First Citizens Bank • United States

Remote
USD 120,000 - 160,000
Data Engineer, Marketing Science
Data Engineer, Marketing Science

powerdigitalmarketing • United States

Hybrid
USD 120,000 - 180,000
Unlimited time off
Flexible remote/hybrid/office model
Monthly healthcare stipend
+2
Senior Data Engineer
Senior Data Engineer

Sightly • United States

Remote
USD 140,000 - 210,000
Remote work
Senior Data Engineer
Senior Data Engineer

Agile Engine • United States

Remote
USD 140,000 - 200,000
Growth opportunities
Competitive compensation
100% remote
+4
Data Engineer
Data Engineer

Collectivus Holdings • United States

Remote
USD 100,000 - 150,000
Senior Data Engineer - Snowflake Expert
Senior Data Engineer - Snowflake Expert

The Timberline Group • St. Louis (MO)

On-site
USD 130,000 - 170,000
Medical, Dental & Vision insurance
401(k) with company match
PTO
+5
Senior Snowflake Data Engineer - Talent Pipeline
Senior Snowflake Data Engineer - Talent Pipeline

BlueCloud • United States

On-site
USD 150,000 - 210,000
Manager of Data Engineering
Manager of Data Engineering

Techhuman • Kansas City (MO)

On-site
USD 150,000 - 190,000
Data Engineer
Data Engineer

Snowflake • Menlo Park (CA)

On-site
USD 165,000 - 217,000
Medical insurance
Dental insurance
Vision insurance
+9
Senior Data Engineer
Senior Data Engineer

MISUMI Americas • Schaumburg (IL)

On-site
USD 167,000 - 202,000
Comprehensive medical and dental
401(k) plan
Generous PTO and leave programs