View on Remote OK
Roles
Compensation
USD 85000 - 100000
Base salary range: $85,000-$100,000 plus competitive compensation package including base pay, incentives and benefits. Benefits mentioned: Medical, Dental, Vision plans; Company Paid Long Term Disability; Employee Assistance Programs; 401k with Match; Generous paid time off; gear test/perks.
- Salary period
- yearly
- Location basis
- United States (role base salary range provided)
- Bonus
- incentives
Benefits
- Medical, Dental Vision plans
- Company Paid Long Term Disability
- Employee Assistance Programs
- 401k with Match
- Generous paid time off policies
- Gear test/perks
Tech stack
Required
Nice to have
Location
Denver, Colorado, United States
Work setup
- Employment
- full-time
- Level
- Mid-level
- Remote policy
- Remote role (Source: Remote OK; Work arrangement: Remote). No specific timezone requirements stated.
- Remote scope
- unclear
Role details
Responsibilities
- Partner directly with stakeholders across the business to translate ambiguous questions into well-defined analyses, dashboards, and data products
- Own end-to-end work: scoping, building, validating, and communicating findings
- Build and maintain dbt models that turn raw source-system data into trustworthy, well-documented datasets
- Write tests and documentation so humans and AI agents downstream can rely on the work
- Develop and maintain semantic context, dashboards, and reports used for day-to-day operations
- Own metric definitions and business semantics; drive alignment when stakeholders disagree
- Review and harden AI-generated SQL, dbt models, and Python code to catch issues that pass tests but are semantically wrong
- Investigate ambiguous data questions not answered by the schema by engaging source-system owners and reconciling conflicting definitions
- Help build and maintain Stio's data infrastructure and contribute to decisions about how the stack should evolve
- Improve data governance by creating documentation useful for the team and for AI agents as future context
- Continuously develop skills as the data analytics practice evolves
Requirements
- 3+ years of professional experience as a data analyst, analytics engineer, or similar role
- Advanced SQL (CTEs, window functions); comfortable wrangling messy real-world data; can reason about query plans
- Hands-on experience with dbt (writing models, tests, and documentation)
- Experience with cloud data warehouses (Snowflake, BigQuery, Databricks, Redshift, Microsoft Fabric, or similar)
- Version control with Git/GitHub as part of normal workflow
- Experience as a developer with at least one BI tool (Power BI, Tableau, Looker, Omni, or similar)
- A point of view on AI-assisted development for analytics work
- History building collaborative, trusting relationships with non-technical stakeholders
- Comfort presenting findings to leadership verbally, in writing, and visually
Application
Mention the word DEFEATS and tag RODguMTk4Ljk5LjE0Mw== when applying to show you read the job post completely. (#RODguMTk4Ljk5LjE0Mw==)
- Portfolio
- not required
- GitHub
- preferred
- Cover letter
- unclear
- Apply flow
- external
Company context
Enable access for all people to mountain life; partners with Protect Our Winters and Conservation Alliance; responsible operation and inclusion focus.
- Product
- Omni-channel apparel, footwear, and accessories; product via Stio.com, catalog, B2B, and Mountain Studio retail locations; Mountain brand focused on mountain lifestyle.
- Industry
- apparel, footwear, and outdoor retail (omni-channel mountain brand)
- HQ
- Jackson, Wyoming
Description
About UsStio® 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. With headquarters in Jackson, Wyoming, Stio draws inspiration from the surrounding Teton Range and offers product via Stio.com, catalog, B2B and its Mountain Studio® retail locations. We live and love mountain life, and are partners of Protect Our Winters and the Conservation Alliance. YOUR ROLEThe Data Analyst is a key early member of Stio's Data & Analytics team, working alongside the Director of Data & Analytics to expand how the business uses data to make decisions. This is a full-stack, horizontal role spanning data infrastructure (ingestion, modeling, transformation), analysis, BI development, and stakeholder partnership across Finance, Merchandising, Marketing, Operations, Inventory Planning, and B2B. Stack built around Snowflake, Fivetran, dbt, Power BI, GitHub, and increasingly Python in addition to SQL and R. AI-assisted development is the default, with code written collaboratively with AI agents in tools like Claude Code, then reviewed, tested, and iterated. Responsibilities include partnering with stakeholders to translate ambiguous questions into analyses/dashboards/data products; building and maintaining dbt models with tests and documentation; developing semantic context/dashboards/reports; owning metric definitions and business semantics; reviewing and hardening AI-generated SQL/dbt/Python; investigating ambiguous data questions; building/maintaining data infrastructure; improving data governance through documentation useful for humans and AI agents; continuously developing skills as the practice evolves. This is a remote role part of the Finance department and reports to the Director of Data & Analytics.
Similar jobs
-
Loading similar jobs...