Build and maintain dbt models that turn raw source-system data into trustworthy, well-documented datasets.
Write the tests and documentation that let both humans and AI agents downstream rely on the work
Develop and maintain the semantic context, dashboards, and reports that the rest of the business uses to operate day-to-day
Own metric definitions and business semantics. Drive alignment when stakeholders disagree on what a definition or number means
Review and harden AI-generated SQL, dbt models, and Python code with the judgment to catch issues that pass tests but are semantically wrong.
Investigate ambiguous data questions where the answer isn't in the schema: talk to source-system owners, investigate edge cases, reconcile conflicting definitions, and improve our model of the business
Improve data governance for both the Data & Analytics team and the business at large by creating documentation that's actually useful and that AI agents can consume as context for future work
Requirements
You'll work where the highest-leverage problems are and grow the breadth and depth of the analytics function in the process.
You'll work in a stack built around Snowflake, Fivetran, dbt, Power BI, GitHub, and increasingly Python in addition to SQL and R.
AI-assisted development is the default form factor for the team.
Most of the code we ship is written collaboratively with AI agents in tools like Claude Code, then reviewed, tested, and iterated.
The expectation is not that you arrive an expert in AI tooling.
The expectation is that you bring strong fundamentals â the kind of data and modeling intuition that lets you catch silently wrong AI output that runs cleanly and passes tests â and that you're genuinely curious about how this part of the craft is evolving.
The right person doesn't hesitate to sweep the floor (fix a broken Excel link), isn't afraid to question the status quo (does this metric actually measure what it claims to?), and would rather quickly solve a pressing business problem with simple analysis than build a sophisticated model that collects dust.
The majority of your output will be code you've collaborated on with AI agents, and you'll bring the data intuition that makes that work trustworthy
Help build and maintain Stio's data infrastructure â currently Snowflake, Fivetran, dbt, GitHub, Power BI, R, and Python â and contribute to decisions about where the stack should evolve
Continuously develop your skills as the practice of data analytics evolves. This is a real part of the job, not something done on the side Your Skills And Experience
experience as a data analyst, analytics engineer, or similar role
Advanced SQL: CTEs, window functions, comfortable wrangling messy real-world data, can read and reason about query plans well enough to know when something is off Hands-on
experience with dbt, including writing models, tests, and documentation.
You don't need to have built a dbt project from scratch, but you should be comfortable contributing to one and know what good looks like •
Experience with cloud data warehouses (Snowflake, BigQuery, Databricks, Redshift, Microsoft Fabric, or similar)
Version control with Git/GitHub as part of your normal workflow •
Experience as a developer with at least one BI tool (Power BI, Tableau, Looker, Omni, or similar)
A real point of view on AI-assisted development for analytics work â what it's actually good at, where it falls down, what you do to make the output trustworthy
Working knowledge of Python and/or R for analysis •
Experience with the components of our data stack (Snowflake, Fivetran, dbt, GitHub, Power BI, Python, R, Claude Code, Codex) •
Experience with some of the systems we use: NetSuite, Shopify, Google Analytics, Segment, Klaviyo Professional
experience at a DTC or omni-channel retail, apparel, footwear, or outdoor company •
Experience working in a small or solo data team where you owned the work end-to-end THE FINE PRINT
Must be able to work in a stationary position 50% - 75% of the work day
This is a beta feature to avoid spam applicants.
Experience
3+ years of professional
Benefits
Medical, Dental Vision plans
Company Paid Long Term Disability
Employee Assistance Programs 401k with Match
Generous paid time off policies
Gear test, perks and more
We provide competitive compensation packages, inclusive of base pay, incentives and benefits.
The base salary range for this role is $85,000-$100,000.
It would not be typical for someone to be hired at the top end of the range for the role, as actual pay will be determined based on several factors including experience, skills, and qualifications.
Additional details
Stio® is an omni-channel mountain brand that designs, develops and sells beautiful, functional, and innovative apparel, footwear and other accessories infused with the soul of the mountain lifestyle.
We live and love mountain life, and as such see ourselves as caretakers of the resources that provide it.
We are proud partners of Protect Our Winters and the Conservation Alliance among many other organizations.
We have a strong preferred materials platform, use Bluesign® approved textiles wherever possible, audit our supply chains for best practices, and operate our workplaces responsibly.
We think that outside is the best side and that you can't improve on nature.
It's good for mind, body and soul, and it's our responsibility to help enable access for all people, regardless of race, gender, beliefs, background or ability.
We strive for inclusion at Stio and in our local and national communities. YOUR ROLE
This is a full-stack, horizontal role: the work spans data infrastructure (ingestion, modeling, transformation) through analysis, BI development, and direct stakeholder partnership across Finance, Merchandising, Marketing, Operations, Inventory Planning, and B2B.
As an early team member, you'll help shape how we work in this environment, not just execute someone else's playbook.
We're looking for an analyst who connects what they see in the data to the bigger picture and who has a strong bias for tying analysis to action.