Skip to content
Collective Intelligence ProjectCollective Intelligence ProjectSan Francisco, CA

Senior Data Analyst, Strategic Operations

Own the architecture and buildout of Collective's Operations Intelligence Warehouse in BigQuery and Metabase. Build dimensional models in dbt, instrument operational metrics (cycle time, yield, utilization), connect ops data to revenue outcomes, and drive statistical rigor for an AI-native financial services operation. Requires 5+ years in data analysis/analytics engineering, expert SQL, and warehouse architecture experience.

127k – 190k
Remote5+ YOEData Analytics

About the role

What you'll do

  • Architect the Operations Intelligence Warehouse: Lead the audit, cleanup, and architecture of the Operations data subset within our shared BigQuery warehouse including 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.

What you'll bring

Experience

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

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.

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.

Quality-First

  • Strong data quality instincts: testing frameworks, lineage, documentation, and git-based workflows are how you work, not an afterthought.

Signal from Ambiguity

  • Proven ability to take ambiguous operational questions and turn them into structured, measurable analyses that change decisions.

Cross-Functional Influence

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

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.

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

Skills

SQLdbtBigQueryMetabasePythonData ModelingData WarehousingStatistical AnalysisData QualityAnalytics Engineering

Similar roles

Data Analytics jobs
Apollo

Senior Sales Operations Manager - Analytics & Intelligence

ApolloUnited States

GTM Sales Intelligence Analyst partnering with Sales leadership and RevOps to build pipeline reporting, forecasting models, and dashboards that improve forecast accuracy and sales execution in a B2B SaaS environment.

127k – 182k
Remote3+ YOEData Analytics
Komodo Health

Senior Research Data Analyst

Komodo HealthSan Francisco, CA +2

Senior Research Data Analyst responsible for designing and implementing SQL data pipelines and R statistical analyses on large-scale real-world healthcare data to support HEOR and RWE observational research studies. Requires MS in a quantitative field, 5+ years SQL experience, and proficiency in statistical programming.

128k – 170k
Remote5+ YOEData Analytics
Motive

Senior Analyst, Strategic Analytics

MotiveCalifornia +5

Senior Analyst owning end-to-end COGS, gross margin, and unit economics analysis for hardware/software products. Structure ambiguous executive questions, build models and datasets, deliver recommendations to CPO/CTO, and influence product/finance decisions in a fast-paced remote environment. Requires 7+ years experience, expert SQL, and strong autonomy.

129k – 185k
Remote7+ YOEData Analytics
Brigit

Senior Data Analyst, Credit

BrigitNew York, NY +1

Lead analytics for Brigit's new Line of Credit product, driving product insights, experiments, profitability forecasting, and underwriting optimization in a hybrid fintech environment.

125k – 150k
Hybrid4+ YOEData Analytics
Brigit

Senior Data Analyst, Payments Platform

BrigitNew York, NY +1

Senior Data Analyst embedded in payments platform team analyzing ACH/card transaction costs, success rates, failure patterns, and predictive models to optimize routing and collection strategies.

125k – 155k
Hybrid4+ YOEData Analytics