Senior Data Engineer

Scenthound

. Build and maintain ingestion pipelines from Google Ads, Meta Ads, Google Tag Manager/GA4, and other data and web sources into Snowflake .

Posted 11/11/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in Snowflake architecture, data ingestion, and pipeline management, with a strong focus on SQL and Python programming. Capable of ensuring data governance and compliance while effectively communicating technical concepts to non-technical stakeholders.

Highest-signal resume keywords

Snowflake ExpertiseSQL ProgrammingPython ProgrammingData Ingestion PipelinesData Governance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data EngineeringSnowflake ModelingAirflow OrchestrationManaged Ingestion ToolsDbtAPI IntegrationCustomer 360 ConceptsReverse ETLData Discrepancy TroubleshootingCost Control

Soft Skills

Clear CommunicationProblem-SolvingProactive MonitoringOwnership

Tools & Technologies

Google AdsMeta AdsGoogle Tag ManagerGA4FivetranAirbyteStitchTableauPower BILooker

Certifications & Qualifications

SnowPro Core CertificationSnowPro Advanced Certification

Industry Keywords

Data GovernancePrivacy RegulationsCCPAConsent ManagementMulti-Location BusinessConsumer Services

Tech Stack

Tools & technologies

AirflowETLPythonSnowflakeSQLTableau

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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

Benefits

Comp & perks

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