Senior Data Analyst, Strategic Operations

About the role

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.

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

Requirements

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.

Qualifications

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

Benefits

Remote-Friendly Environment: Flexibility to work from home while staying connected to the team.

Health & Wellness: $200 quarterly reimbursement to support your well-being.

Fresh Lunch: Provided on in-office days for those in a hybrid schedule.

Commuter Support: $150 monthly reimbursement for transit expenses for those in a hybrid schedule.

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.

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