Job Overview
CellCore Biosciences sells direct-to-practitioner — our revenue motion runs from Lead to Approved Practitioner to Account to Shopify reorder, not through a traditional deal pipeline. The B2B Sales Analyst owns the analytics layer that makes that motion visible: Gold-layer queries in Microsoft Fabric, Power BI dashboards for SalesOps, and propensity models that tell the inside sales team exactly who to call next. This role sits at the intersection of data engineering and commercial strategy, translating raw Salesforce account data and Shopify transaction history into practitioner health scores, activation funnels, and reorder intelligence. You report to the CTO and partner daily with SalesOps leadership, the Salesforce Admin, and inside sales.
What You'll Do
- Build and maintain Gold-layer SQL/DAX queries in Microsoft Fabric that surface practitioner activation rates (14/30/60-day first-order windows), reorder trends, PDC revenue attribution, and dormant-to-active conversion.
- Own Power BI dashboards consumed by SalesOps leadership — including practitioner health scorecards, account lifecycle stage distribution, and channel-level revenue
- breakdowns across all sales segments.
- Develop and maintain the id_bridge logic that joins Salesforce Account records to Shopify order data, flagging identity gaps and surfacing data-hygiene issues for the Salesforce Admin.
- Run propensity scoring models in Fabric (Python/SQL) for churn/reactivation (Track 7) and cross-sell next-best-offer (Track 4); export ranked practitioner lists to Klaviyo segments and inside sales task queues in Salesforce.
- Support the Practitioner 360 build (Track 3) by defining and delivering the data feeds that populate the SF Lightning page — order recency, PDC balance, lifecycle stage, specialty-to-SKU affinity signals.
- Translate Einstein Lead Scoring activation signals and Pardot engagement data into inside sales prioritization lists; maintain the scoring logic and flag model drift.
- Partner with SalesOps and inside sales to define activation NBA triggers (Track 5) — identifying newly approved practitioners who have not placed a first order at day 14, 30, and 60, and routing Klaviyo plays and SF tasks accordingly.
- Pull and validate financial data from SAP Business One (COGS, margin) to contextualize gross-profit impact of reorder and reactivation campaigns.
What You'll Work With
Tool and how you use it
- Microsoft Fabric : Primary compute layer; Bronze/Silver/Gold medallion; Gold is the analytics- ready layer you query daily
- Power BI: Dashboard and reporting layer; connected to Fabric Gold; primary delivery surface for SalesOps
- Salesforce (Unlimited Edition, USA442): Practitioner account management; Account, Type lifecycle stages; Einstein Lead Scoring; Pardot Flows
- Shopify (GraphQL) : Order and transaction data; bridged to SF via id_ bridge identify table
- Klaviyo : Email/lfecycle engagement; you feed segmentation lists from Fabric propensity model output
- SAP Business One (ERP): COGS and financial data for margin context- not NetSuite
- Python /SQL/DAX : Query and transformation layer across Fabric, Power BI, and ad-hoc analysis
What We're Looking For
Required
- 3+ years in a sales analytics, revenue operations, or data analyst role with direct exposure to B2B or DTC revenue data
- Proficient in SQL for querying multi-layer data warehouses or lakehouses (medallion architecture experience preferred)
- Power BI: building and publishing dashboards, writing DAX measures, managing dataset refresh from a cloud data source
- Salesforce data model literacy — accounts, contacts, leads, custom objects, field mapping between SF and external systems
- Python or R for data wrangling and scoring model development (scikit-learn, pandas)
- Strong communication skills — ability to translate model output into plain-language sales action lists
Preferred
- Experience with Microsoft Fabric or Azure Synapse Analytics
- Familiarity with Shopify order data structures or GraphQL APIs
- Exposure to email marketing data (Klaviyo, Braze, or similar) as an analytics input
- Experience building propensity models (churn, reorder, cross-sell) in a retail or subscription context
Nice to Have
- Working knowledge of Salesforce Einstein Lead Scoring configuration and Pardot engagement scoring
- Experience querying Shopify GraphQL Admin API and reconciling Shopify customer IDs to CRM account records
- Familiarity with SAP Business One financial data structures (sales orders, COGS, item master)
- Prior work in nutraceutical, supplement, or health-and-wellness DTC/B2B commerce
Who You'll Work With
- SalesOps leadership — primary stakeholders for dashboard requirements and practitioner activation reporting
- Salesforce Admin— field mapping, data hygiene, and Salesforce ↔ Shopify identity bridge maintenance
- Data platform — Gold-layer schema governance and Fabric pipeline coordination
- Inside sales team — recipients of scored outreach lists and activation NBA triggers
- CTO — reports to; reviews AI roadmap track progress and analytics architecture decisions
What Success Looks Like — First 90 Days
- Day 30: Practitioner health dashboard live in Power BI — active vs. dormant cohort (8,140 / 13,520 today) by Account.Type stage, reorder rate, and 14/30/60-day activation funnel. SalesOps team using it daily.
- Day 60: Fabric Gold-layer propensity scoring query complete for the dormant reactivation cohort (Track 7) — ranked practitioner list ingested by Klaviyo and inside sales SF task flow; first reactivation campaign launched.
- Day 75: id_bridge audit complete with Salesforce Admin — all Salesforce ↔ Shopify identity mismatches documented and resolved or flagged; PDC revenue attribution reconciled to SAP B1 financial records.
- Day 90: Practitioner 360 data feeds defined and delivering to the SF Lightning page (Track 3) — order recency, PDC balance, cross-sell affinity score, and lifecycle stage visible in a single pane for inside sales reps.
Pay: $95,000.00 - $110,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Employee discount
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid parental leave
- Vision insurance
Work Location: In person
