Senior Data Analyst, Strategic Operations at Collective | San Francisco, CA | Rezi

Senior Data Analyst, Strategic Operations at Collective

Senior Data Analyst, Strategic Operations

Collective · San Francisco, CA

3 weeks ago

Senior Data Analyst, Strategic Operations

Collective · San Francisco, CA

21 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

You will own the architecture and buildout of Collective's Operations Intelligence Warehouse, including the BigQuery data layer and Metabase BI. This role is crucial for making operational throughput, quality, variance, and capacity inspectable within an AI-native financial operation. You will also lead analytics, identifying trends, surfacing key insights for leadership, and providing data-driven foresight. The AI's effectiveness relies on the quality of the operational data, which will be your responsibility.

Responsibilities

  • Architect the Operations Intelligence Warehouse, leading the audit, cleanup, and architecture of the Operations data subset within our shared BigQuery warehouse.
  • Define source-of-truth definitions, schema and dataset design, naming conventions, documentation, and query cost management.
  • Set the data modeling standard by building and maintaining dimensional models in dbt with testing, lineage, and version control.
  • Instrument the operation by designing and maintaining dashboards and metrics for real-time visibility into operational health, including throughput per workflow, cycle time, first-pass yield, exception rates, and capacity versus demand.
  • Connect operations to revenue by joining operational data to GTM and financial data to analyze service quality's impact on retention and NRR, workflow costs, and margin in the member delivery pipeline.
  • Power statistical rigor by partnering with the team on statistical process control, variance analysis, and root cause analytics.
  • Raise the data practice by partnering with the Data Engineering team to establish SQL, modeling, and analytics engineering standards for Strategic Operations.

Requirements

  • 5+ years in data analysis or analytics engineering at a B2B SaaS or fintech company, ideally with a human-in-the-loop service delivery operation.
  • Expert-level SQL and hands-on experience with dbt (data build tool), or equivalent, in a modern warehouse.
  • Proven track record of leading a data cleanup or warehouse re-architecture, untangling inconsistent schemas, establishing sources of truth, and making a warehouse trustworthy.
  • Strong data quality instincts, with experience in testing frameworks, lineage, documentation, and git-based workflows.
  • Proven ability to take ambiguous operational questions and turn them into structured, measurable analyses that change decisions.
  • Exceptional communication and stakeholder management skills, with a track record of effectively collaborating between highly technical teams (Product/Eng) and specialized subject matter experts (Tax/Accounting).
  • Self-starter mindset with the ability to thrive in a fast-paced environment, pivot when necessary, and comfortably navigate a high-growth startup ecosystem.

Skills

  • SQL
  • dbt
  • BigQuery
  • Metabase
  • data analysis
  • analytics engineering
  • data modeling
  • testing frameworks
  • data lineage
  • documentation
  • git-based workflows
  • stakeholder management
  • Python for analysis and pipeline work
  • statistical process control
  • six sigma
  • industrial engineering methods
  • AI agent telemetry instrumentation
  • workflow telemetry instrumentation
  • LLM eval programs support
  • AI-assisted low-code development

Location

  • Remote (U.S.)
  • Bay Area (Hybrid)

Work Type

  • Remote
  • Hybrid

Experience Level

  • 5+ years

Benefits

  • Flexibility to work from home
  • $200 quarterly reimbursement for well-being
  • Fresh lunch provided on in-office days
  • $150 monthly reimbursement for transit expenses
  • Flexible PTO
  • 14 company holidays
  • 100% medical, dental, and vision coverage for employees
  • 75% coverage for dependents
  • 16 weeks fully paid parental leave
  • 401k plan
  • Equity package
  • Quarterly virtual events
  • Annual in-person summit

About the Company

  • Collective is redefining the way businesses-of-one work by providing an integrated platform for business incorporation, accounting, bookkeeping, tax services, and community access.
  • Our mission is to empower self-employed individuals to achieve financial independence and access tax savings similar to large corporations.
  • Collective has been featured in Forbes, Business Insider, Yahoo, Bloomberg, Financial Times, TechCrunch, and more.
  • We are backed by prominent investors including General Catalyst, Sound Ventures, QED Investors, Google’s Gradient Ventures, and Expa.