View on Remote OK
Roles
Compensation
USD 85000 - 100000
Base salary range is $85,000-$100,000. Includes incentives and benefits; medical, dental, vision, company paid long term disability, employee assistance programs, and 401k with match, generous paid time off, and additional perks.
- Salary period
- yearly
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
Remote
Work setup
- Employment
- full-time
- Level
- Mid-level
- Remote policy
- Remote work arrangement; remote role (part of Finance department).
- 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, communicating findings).
- Build and maintain dbt models to turn raw source-system data into trustworthy, well-documented datasets; write tests and documentation.
- 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; talk to source-system owners, investigate edge cases, reconcile conflicting definitions, improve the model of the business.
- Help build and maintain Stio’s data infrastructure (Snowflake, Fivetran, dbt, GitHub, Power BI, R, Python) and contribute to where the stack evolves.
- Improve data governance by creating useful documentation that AI agents can consume as context for future work.
- Continuously develop skills as the practice of data analytics evolves.
Requirements
- 3+ years of professional experience as a data analyst, analytics engineer, or similar role.
- Advanced SQL: CTEs, window functions; wrangling messy real-world data; read and 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 in normal workflow.
- Experience with at least one BI tool (Power BI, Tableau, Looker, Omni, or similar).
- Point of view on AI-assisted development for analytics work and making output trustworthy.
- History of building collaborative, trusting relationships with non-technical stakeholders.
- Comfort presenting findings to leadership verbally, in writing, and visually.
- Must be able to work in a stationary position 50% - 75% of the work day.
Application
Please mention the word **ABUNDANCE** and tag RMTExLjE3NS41Ny4xMjc= when applying to show you read the job post completely.
- Portfolio
- unclear
- GitHub
- preferred
- Cover letter
- unclear
- Apply flow
- external
Company context
Enable access for all people regardless of race, gender, beliefs, background or ability; inclusion and responsible workplace practices; caretakers of resources that provide mountain life.
- Product
- Omni-channel mountain brand (apparel, footwear, and accessories)
- Industry
- Apparel and footwear retail
- HQ
- Jackson, Wyoming
Description
ABOUT US 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. 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 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 The 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: 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. 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. 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. This is a remote role that is part of the Finance department and reports to the Director of Data & Analytics. YOUR RESPONSIBILITIES Partner directly with stakeholders across the business (Product Development, Marketing, DTC, B2B, Finance, Operations, Inventory Planning) to translate ambiguous questions into well-defined analyses, dashboards, and data products. You’ll own these end-to-end: scoping, building, validating, and communicating findings. 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. 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. 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. Continuously develop your skills as the practice of data analytics evolves. YOUR SKILLS AND EXPERIENCE 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 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 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 History of building collaborative, trusting relationships with non-technical stakeholders Comfort presenting findings to leadership verbally, in writing, and visually PREFERRED ADDITIONAL SKILLS AND EXPERIENCE Though not required, 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 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 Please mention the word **ABUNDANCE** and tag RMTExLjE3NS41Ny4xMjc= when applying to show you read the job post completely.
Similar jobs
-
Loading similar jobs...