Prenetics (NASDAQ:PRE), a leading health sciences company, is dedicated to advancing consumer health. Our consumer initiative is led by IM8, a fast-growing health and wellness brand; Europa, one of the largest sports distribution companies in the USA; and CircleDNA, a leading direct-to-consumer DNA test. As the first healthcare company to establish a Bitcoin treasury with its initial $20 million Bitcoin purchase and board-approved comprehensive Bitcoin strategy, Prenetics is pioneering the intersection of healthcare innovation and digital asset adoption. The company will soon accept cryptocurrency payments across both IM8 Health and CircleDNA platforms, creating a complete Bitcoin ecosystem from treasury to operations. This includes exploring how blockchain technology can further enhance our genomics solutions, such as CircleDNA, by ensuring data integrity, privacy, and secure access to personalized health insights, while establishing new paradigms for corporate treasury management. Each of Prenetics' units synergistically enhances our global impact on health, embodying our commitment to "enhancing life through science". To learn more please visit prenetics.com and IM8health.com.
The role
Be the analytics backbone for Customer Operations across our Shopify commerce stack. From inventory coverage and fulfillment to subscription health and shipping SLAs, you’ll turn multi-source data into crisp, actionable insights and simple dashboards the team can use daily. You’ll also leverage AI tools and automation to speed up analysis, reduce manual work, and power always-on alerts.
What you’ll do
Order fulfillment & inventory analytics
- Build live views and weekly reports on order status, backorders, and exceptions. Forecast demand and inventory coverage (days on hand, safety stock, reorder points), including product transitions (e.g., capsules
- powder).
- Model run-out dates and purchase timing; flag risks early and recommend reorder actions.
Subscription health & retention
- Own core metrics: active/cancelled subs, cohort retention, acquisition rate, churn, M2/M3 conversion, reactivation.
- Analyze cancellation survey data to pinpoint drivers; partner with CS/Growth on fixes and experiments.
- Handle ad-hoc eligibility counts (e.g., Month-2/Month-3 gift qualification) and campaign backtests.
Shipping performance
- Dive into AfterShip to monitor first-scan time, in-transit time, delivery time, on-time %, and exception codes by lane/carrier.
- Identify bottlenecks (carrier, lane, warehouse handoff) and surface clear remediation plans.
AI-assisted analytics & automation
- Use AI copilots (for example, ChatGPT/Claude/Gemini) to draft SQL/Sheet formulas, document pipelines, summarize survey text, and generate weekly highlights.
- Build lightweight automations (Zapier/Make, Apps Script/VBA, Slack bots) for: SLA breach alerts, low-stock warnings, churn spikes, and exception triage.
- Create LLM-powered parsers to normalize reason codes (cancellations, exceptions) and classify free-text at scale.
- Implement QA assistants for reconciliation checks across Shopify, D365, subscription apps, and finance (e.g., variance explanations, anomaly detection).
- Maintain prompt libraries and guardrails; track accuracy and drift over time.
Ad-hoc & rapid response
- Triage urgent data issues; run quick anomaly deep-dives (e.g., sudden carrier delays, payment failures, SKU swaps).
- Spin up one-off cohort/impact analyses for campaigns, promos, bundles, and pricing tests.
- Prototype throwaway dashboards for new initiatives; harden the winners into repeatable views.
- Stand up temporary scripts/notebooks to reconcile edge cases (preorders, partials, split shipments).
- Field leadership questions with clear, time-boxed analyses and recommended actions.
Data plumbing & governance
- Reconcile data between Shopify, Microsoft Dynamics 365 (D365), subscription apps, and finance.
- Build/maintain robust Excel & Google Sheets models with documentation and QA checks.
- Create lightweight SOPs and self-serve dashboards for CS/Ops.
Communication
- Translate insights into simple narratives and action lists for Customer Ops, Growth, and Leadership.
- Present weekly “what changed / why / what’s next” highlights.
You’ll be great at
Top-tier spreadsheet skills
- Excel: dynamic arrays, Power Query, Power Pivot, XLOOKUP/INDEX-MATCH, SUMIFS/COUNTIFS, FILTER, REGEX, pivots/charts, scenario modeling; VBA/macros a plus.
- Google Sheets: ARRAYFORMULA, QUERY, FILTER, REGEX, IMPORTRANGE; Apps Script a plus.
AI tooling & automation
- Comfortable using AI copilots for analysis, documentation, and QC; able to design effective prompts and evaluation checks.
- Experience wiring automations with Zapier/Make, Slack/Teams bots, Apps Script/VBA; bonus for API/LLM integration.
- Commerce stack familiarity: Hands-on with Shopify (and ecosystem apps) and D365 data/objects; confident with ERP reconciliation.
- Comfort using AfterShip (or similar) to extract and analyze delivery/transit metrics.
- Strong business judgment: turn signals into clear operational recommendations.
- Meticulous about data accuracy, reconciliation, and reproducibility; crisp documentation.
Nice to have
- Experience with subscription platforms (e.g., Recharge, Skio) and CS tools (e.g., Gorgias/Zendesk).
- BI/SQL/Python for deeper analysis (cohorts, LTV, forecast diagnostics).
- Familiarity with inventory planning (lead time, EOQ, service levels).
- LLM frameworks (e.g., LangChain) or basic API scripting for custom classifiers/parsers.
KPIs you’ll move
- On-time delivery %, median transit time, exception rate
- Inventory days-on-hand and stockout risk Subscription churn/retention (overall & cohort), M2
- M3 conversion
- Data quality SLAs (reconciliation accuracy, refresh timeliness)
Tools
Excel, Google Sheets, Shopify & ecosystem apps, Microsoft Dynamics 365, AfterShip, AI copilots (ChatGPT/Claude/Gemini), Zapier/Make, Slack/Teams bots, (optional) SQL/Python/BI, Apps Script/VBA.
