Senior Systems & Business Analyst

POSITION SUMMARY

This role is the owner and architect of the entire modern data stack (Snowflake/dbt) from end to end, ensuring our data is clean, standardized, and accessible. Beyond the code, you will partner directly with cross-functional teams to steer the data into informed business strategy, develop insightful Tableau dashboards, and other ad-hoc & financial analysis.

Primary residence must be in the following states: CA, DC, FL, IL, MA, MI, NC, NJ, NY, NV, OH, OR, PA, TN, TX & WA

Data Architecture & Engineering

• Own the Stack:
  Serve as the primary owner of our Snowflake and dbt instances. You will manage data flows, ensuring high availability and performance.
• Pipeline Development:
  Set up and maintain API connections to ingest data from key sources (Marketing platforms, Shopify, Booking systems, etc.).
• Data Modeling:
  Architect and maintain the integrity of our data warehouse. You will build and optimize Intermediate (INT) and Aggregate (AGG) tables to serve downstream reporting.
• Quality Assurance:
  Implement automated testing and data cleaning protocols to ensure "Standardization" across all datasets. If the data breaks, you are the first to know and fix it.

Strategic Business & Financial Analysis

• Revenue Modeling:
  Partner with Finance to build, maintain, and enhance complex revenue and forecast models.
• Advanced Analytics:
  Utilize Python, SQL to run regression and other ad-hoc analyses and case studies to answer critical business questions. Including Real Estate Strategy, Retail/Inventory Strategy, Client Retention, LTV, Behavioral Analysis, etc.
• Leading Indicators:
  Proactively identify trends and "leading indicators" of business health rather than just reporting on lagging metrics.

Visualization & Stakeholder Partnership

• Tableau Development:
  Co-partner on the design and delivery of high-value Tableau dashboards for Support Center and Studio Owners.
• Cross-Functional Collaboration and Support:
  Act as the bridge between business units, ensuring data and reporting is being served promptly and accurately. Partnering closely with Retail, Marketing, Digital, and Operations teams.

• Ensuring all data sources are connected and building a roadmap of future data onboarding.
• Data Quality Score:
  Achieve a