Senior Systems & Business Analyst

Job Description

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

KEY JOB RESPONSIBILITIES:

1. 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.

2. 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.

3. 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.

ACCOUNTABILITY AND KPI'S

• Ensuring all data sources are connected and building a roadmap of future data onboarding.
• Data Quality Score: Achieve a <5% error rate in downstream Tableau reporting caused by upstream pipeline failures; and continuous QA/QC on existing SQL database logic.
• Standardization of Retail analytics and assisting inventory management.
• Delivery of cross-functional Tableau dashboards & reports (based on prioritization and business needs).
• Insight-to-Action: Deliver quarterly "Deep Dive" case studies (e.g., Retail Inventory optimization or Client Retention) that result in at least one documented strategic pivot or cost-saving measure.
• SLA on Ad-Hoc Requests: Maintain a 3-day turnaround for high-priority ad-hoc analysis requests while maintaining a centralized, transparent backlog.

Requirements

• Alignment with barre3 Core Values: Practice Authenticity, Stronger Together, Love of Learning, Give Generously, Make It Happen
• Technical Stack: Expert-level SQL and hands-on experience with Snowflake and dbt (data build tool). 
• Programming: Proficiency in Python for data analysis and regression modeling.
• Visualization: Strong experience building interactive dashboards in Tableau.
• Financial Acumen: Experience building financial models and/or working closely with FP&A and Accounting teams. 
• Experience: 3-5 years in data science, business intelligence, etc.
• Education: Bachelor’s degree in Statistics, Data Science, or Economics, etc; 

Benefits

ABOUT BARRE3

Barre3 is a fitness company building communities based on body positivity and inclusivity—and this starts with the workplace.

OUR COMMITMENT TO DIVERSITY, EQUITY, AND INCLUSION

Community is at the core of barre3, and we believe that a culture of well-being can only thrive when we collectively embrace diversity and inclusion across all races, genders, gender identities, sexual orientations, ages, cultures, religions, abilities, bodies, socio-economic statuses, and experiences. We acknowledge there is more we can do to create an environment in which all people are seen, all voices are valued, and all individuals are treated with compassion, respect, and dignity. We commit to do the work.

WHAT YOU GET:

• A flexible, remote working environment
• Generous medical, dental and vision plans
• Paid holidays, sick and vacation time to empower a healthy work-life balance
• A competitive salary with 401k company-matching, because we care about your future
• Free unlimited access to barre3 online and Portland barre3 classes