Collective

Collective

Senior Data Analyst, Strategic Operations

United States · Senior

Sponsorship not specifiedDetected 14 days ago
PythonGitSQLBigQuerydbtData AnalysisData EngineeringLLMsStakeholder ManagementAccountingProcess ImprovementResearchLeadershipCommunicationVariance Analysis

About the role

  • The AI in an AI-native financial services firm is only as good as the operation it learns from, and the operation is only as good as the data that describes it.
  • Architect the Operations Intelligence Warehouse.

Responsibilities

  • Lead the audit, cleanup, and architecture of the Operations data subset within our shared BigQuery warehouse: source-of-truth definitions, schema and dataset design, naming conventions, documentation, and query cost management.
  • Set the data modeling standard. Build and maintain dimensional models in dbt with testing, lineage, and version control, so every operational metric traces to a governed, documented source.
  • Connect operations to revenue. Join operational data to GTM and financial data to answer the questions that matter: how service quality drives retention and NRR, what each workflow costs to run, and where margin is made or lost in the member delivery pipeline.
  • Power statistical rigor. Partner with the team on statistical process control, variance analysis, and root cause analytics, replacing anecdote with evidence in daily operating decisions.
  • Raise the data practice. Partner with our Data Engineering team, who own the company-wide warehouse and pipelines, to establish the SQL, modeling, and analytics engineering standards Strategic Operations scales on.
  • Build and maintain dimensional models in dbt with testing, lineage, and version control, so every operational metric traces to a governed, documented source.

Requirements

  • A track record of leading a data cleanup or warehouse re-architecture: you have untangled inconsistent schemas, established sources of truth, and made a messy warehouse trustworthy.
  • Proven ability to take ambiguous operational questions and turn them into structured, measurable analyses that change decisions.
  • A self-starter mindset with the ability to thrive in a fast-paced environment, pivot when necessary, and comfortably navigate a high-growth startup ecosystem.
  • Warehouse Wrangler: A track record of leading a data cleanup or warehouse re-architecture: you have untangled inconsistent schemas, established sources of truth, and made a messy warehouse trustworthy.
  • Signal from Ambiguity: Proven ability to take ambiguous operational questions and turn them into structured, measurable analyses that change decisions.
  • Startup Agility: A self-starter mindset with the ability to thrive in a fast-paced environment, pivot when necessary, and comfortably navigate a high-growth startup ecosystem.
  • Quality-First: Strong data quality instincts: testing frameworks, lineage, documentation, and git-based workflows are how you work, not an afterthought.

Nice to have

  • Python for analysis and pipeline work.
  • Exposure to statistical process control, six sigma, or industrial engineering methods.
  • Experience instrumenting AI agent or workflow telemetry, or supporting LLM eval programs.
  • AI-assisted, low-code development experience (Claude Code, AppSheet, or similar).
  • Analytical Powerhouse: Expert-level SQL and hands-on experience with dbt (data build tool), or equivalent, in a modern warehouse, BigQuery and Metabase strongly preferred.

Compensation

  • Team Connection: Quarterly virtual events and an annual in-person summit.

Benefits

  • Health & Wellness: $200 quarterly reimbursement to support your well-being.
  • Time Off: Flexible PTO plus 14 company holidays.
  • Comprehensive Coverage: 100% medical, dental, and vision for employees
  • 75% coverage for dependents.
  • Parental Leave: 16 weeks fully paid.
  • Retirement & Ownership: 401k plan plus an equity package.
  • Design and maintain the dashboards and metrics that give leadership real-time visibility into operational health: throughput per workflow, cycle time, first-pass yield, exception rates, and capacity versus demand.
  • Commuter Support: $150 monthly reimbursement for transit expenses for those in a hybrid schedule.

Company info

  • Collective is on a mission to redefine the way businesses-of-one work.
  • Our technology and team of trusted advisors help members achieve financial independence by taking care of everything from business incorporation to accounting, bookkeeping, tax services, and access to a thriving community, all in one integrated platform.
  • We believe in empowering self-employed people to enjoy the same tax savings that big companies get, so they can focus on their passion, not paperwork.
  • Featured in Forbes, Business Insider, Yahoo, Bloomberg, Financial Times, TechCrunch, and more.
  • We are backed by General Catalyst, Sound Ventures (Ashton Kutcher and Guy Oseary), QED Investors, Google's Gradient Ventures, Expa, and other investors who have financed iconic companies like YouTube, Substack, Twitch, Box, Hims, Instacart, and Lyft.
Apply directly at Collective →Create a free account for alerts like thisView Collective immigration profile

This listing is sourced directly from Collective's careers page and normalized into a canonical job model.