Senior Data Analyst, Strategic Operations

Collective • San Francisco, CA

1d • $127,000 - $190,000 • Remote

About The Position

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.

You will own the architecture and buildout of Collective's Operations Intelligence Warehouse: the BigQuery data layer and Metabase BI that make throughput, quality, variance, and capacity inspectable across an AI-native financial operation. You will also own the analytics on top of it: spotting trends before they become problems, surfacing the signal leadership acts on, and seeing around corners with evidence rather than instinct. 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. That data layer is yours.

You will join Strategic Operations, the applied operations research team that designs how Collective's member delivery engine runs. Reporting to the Head of Strategic Operations, you will lead the design of our operational data, set the modeling and quality standards the team builds on, and turn raw production-line telemetry into the operating metrics and insights the business runs on: cycle time, first-pass yield, utilization, and cost-to-serve.

Requirements

• 5+ years in data analysis or analytics engineering at a B2B SaaS or fintech company, ideally one 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, BigQuery and Metabase strongly preferred.
• 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.
• Strong data quality instincts: testing frameworks, lineage, documentation, and git-based workflows are how you work, not an afterthought.
• 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).
• 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.

Nice To Haves

• 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).

Responsibilities

• Architect the Operations Intelligence Warehouse. 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.
• Instrument the operation. 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.
• 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.

Benefits

• Flexibility to work from home while staying connected to the team. We're open to remote candidates within the U.S. for this role, but Bay Area-based employees follow a hybrid schedule.
• $200 quarterly reimbursement to support your well-being.
• Provided fresh lunch on in-office days for those in a hybrid schedule.
• $150 monthly reimbursement for transit expenses for those in a hybrid schedule.
• Flexible PTO plus 14 company holidays.
• 100% medical, dental, and vision for employees; 75% coverage for dependents.
• 16 weeks fully paid parental leave.
• 401k plan plus an equity package.
• Quarterly virtual events and an annual in-person summit.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed