Senior Data Analyst

Senior Data Analyst - Job Description

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.

We’re looking for a Senior Data Analyst who has built and owned production‑grade data models. You’ll work closely with Marketing, Product, Finance, and Operations to turn messy operational data into reliable, well‑modeled, business‑ready datasets.

This role is ideal for someone who enjoys designing dimensional models, improving data reliability, and partnering with business teams to define metrics and attributes that matter.

Success looks like:

• A stable, governed, high‑trust data environment powering business decisions.
• Gold‑layer models that business functions rely on daily.
• Faster delivery of insights, segmentation, and marketing triggers.
• Reduced data quality issues and improved reliability across pipelines.
• Clear documentation, lineage, and standards adopted across the data team.
• Strong cross‑functional alignment and increased data maturity across the organization

Job Focus:

• Own the creation and maintenance of enterprise data models used across multiple business functions.
• Design and implement ETL/ELT pipelines that move, transform, and enrich data across our stack, ensuring data integrity and consistently.
• Design, develop, and maintain interactive, high-performance dashboards and automated reports in Power, BI, Tableau, or other BI platforms to track company-wide Key performance Indicators (KPIs).
• Build transformations following clear modeling standards.
• Improve data reliability through testing, documentation, and thoughtful design.
• Support activation workflows by delivering trustworthy attributes to downstream tools.
• Contribute to modeling conventions, review processes, and long‑term data strategy.
• Maintain a predictable warehouse environment through thoughtful performance tuning and cost management.
• Partner with business teams to define metrics, segmentation logic, and lifecycle attributes.
• Partner closely with cross-functional business teams to gather reporting requirements, map data structures, and translat raw business questions into actionable visualization metrics.
• Collaborate closely with application engineers, analysts, and ML/AI stakeholders to understand their data needs and deliver purpose-built solutions that serve each use case effectively without comprising others.

Requirements:

• Proven experience in a cloud warehouse environment and an understanding of how to keep it fast and predictable for costs and performance.
• Hands-on experience with relational databases, encompassing schema design, query optimization, indexing, and administration.
• Ownership of production data models that other teams rely on.
• Have built transformations using a version‑controlled workflow.
• Have a deep understanding of dimensional modeling with a strong point of view/rationale on why you modeled something a certain way.
• Experience building and maintaining ETL/ELT pipelines.
• Experience improving data quality through tests, documentation, and thoughtful design.
• Familiarity with data governance frameworks, role-based access controls, and PII/data privacy best practices.
• Experience with identity stitching, consent logic, or historical tracking.
• Experience supporting customer or lifecycle analytics.
• Experience delivering attributes or segments to downstream tools.
• 6+ years of professional experience in an analytics engineering role, with at least 2 years in a senior capacity.
• Experience working in a franchise, multi-location retail, or consumer services business where data spans many operational units is a bonus.
• You do not need to list every tool you’ve used. We are not looking for a laundry list of tools. We care more about how you think than what tools facilitate outcomes.
• This role requires collaboration during U.S. business hours.

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.