Senior Data Analyst
-
IT/Tech
Job Description & How to Apply Below
- 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.
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
- 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.
- 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…
Position Requirements
10+ Years work experience(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction