Note: The job is a remote job and is open to candidates in USA. Collective is on a mission to redefine the way businesses-of-one work. As a Senior Data Analyst in Strategic Operations, you will own the architecture and buildout of Collective's Operations Intelligence Warehouse, focusing on analytics and data quality to drive operational insights.
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
Skills
- 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
- 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. •Please note that we're open to remote candidates within the U.S. for this role, but Bay Area-based employees follow a hybrid schedule.•
- 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.
Company Overview