Senior Data Analyst

Scenthound

. Own the creation and maintenance of enterprise data models used across multiple business functions .

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 expertise in designing and implementing ETL/ELT pipelines, maintaining enterprise data models, and developing interactive dashboards using BI tools like Power BI and Tableau. Proven ability to enhance data quality and reliability while collaborating with cross-functional teams to deliver actionable insights.

Highest-signal resume keywords

ETL/ELT Pipeline DevelopmentEnterprise Data ModelingPower BI Dashboard CreationRelational Database ManagementData Governance Frameworks

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

ETL/ELTData ModelingRelational DatabasesSchema DesignQuery OptimizationDimensional ModelingData Quality ImprovementVersion-Controlled WorkflowPerformance TuningData Transformation

Soft Skills

CollaborationCommunicationProblem-Solving

Tools & Technologies

Power BITableauCloud WarehouseData Governance ToolsML/AI Tools

Industry Keywords

Analytics EngineeringCustomer AnalyticsLifecycle AnalyticsMulti-Location RetailConsumer Services

Tech Stack

Tools & technologies

CloudETLTableau

About the role

Key responsibilities & impact

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 the stack
Design, develop, and maintain interactive, high-performance dashboards and automated reports in Power BI, Tableau, or other BI platforms
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 performance tuning and cost management
Partner with business teams to define metrics, segmentation logic, and lifecycle attributes
Gather reporting requirements, map data structures, and translate business questions into actionable visualization metrics
Collaborate with application engineers, analysts, and ML/AI stakeholders to deliver purpose-built data solutions
Turn messy operational data into reliable, well-modeled, business-ready datasets

Requirements

What you’ll need

Proven experience in a cloud warehouse environment
Hands-on experience with relational databases, including schema design, query optimization, indexing, and administration
Ownership of production data models relied upon by other teams
Experience building transformations using a version-controlled workflow
Deep understanding of dimensional modeling, with a strong rationale for modeling decisions
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
At least 2 years in a senior capacity
Experience in a franchise, multi-location retail, or consumer services business is a bonus
Ability to collaborate during U.S. business hours
Must be legally authorized to work in the United States
Employment sponsorship will not be offered

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