Commercial Intelligence Analyst

Commercial Intelligence Analyst

Position Summary

MedSpa Partners’ Growth team is the analytical backbone of our commercial organization. We work directly with Operations, Sales, Marketing, and Finance leadership to answer the questions that shape how our clinics grow - where the customer funnel is strong, where it's leaking, what's driving and inhibiting growth, and where the next dollar of revenue comes from. This is not a reporting role; this is a seat at the table where our commercial strategy gets made.

The Commercial Intelligence Analyst supports growth and strategic decision-making by analyzing patient, marketing, and clinic performance data across MedSpa Partners’ network of medical aesthetics clinics.

This role focuses on transforming complex operational datasets into clear insights that help identify opportunities to improve new patient acquisition, consultation conversion, patient retention, treatment adoption, and clinic performance. The analyst will partner closely with the VP of Growth to structure datasets, build analytical models, develop dashboards, and manage analytical projects that support data-driven decision-making across the organization.

Key Responsibilities

Data Preparation & Structuring

• Collect, clean, and structure datasets from clinic systems, marketing platforms, and internal reporting tools.

• Build and maintain structured datasets used for commercial analysis.

• Ensure consistency and accuracy of key performance metrics across clinics.

Commercial & Patient Analytics

• Analyze patient behavior, visit frequency, treatment adoption, and revenue trends.

• Support analyses related to patient retention, lifetime value, and treatment pathways.

• Identify drivers of clinic performance and opportunities for revenue growth.

Marketing & Sales Funnel Analytics

• Analyze marketing and sales funnel metrics, including leads, consultations booked, consultation close rates, and new patient conversion.

• Evaluate marketing channel performance and identify opportunities to improve new patient acquisition.

• Partner with marketing and clinic teams to identify operational or marketing drivers of funnel performance.

Dashboards & Reporting

• Develop and maintain dashboards in Power BI to track key performance metrics across clinics.

• Build Excel-based analytical tools and models used to evaluate clinic performance.

• Translate complex data into clear visualizations and summaries for leadership for ad hoc reporting as well as monthly operating reports and quarterly board meetings.

Project Management & Analytical Execution

• Manage multiple analytical projects simultaneously, ensuring analyses are delivered accurately and on schedule.

• Partner closely with the VP of Growth to scope analytical questions, define project timelines, and track progress.

• Translate broad business questions into structured analytical plans and milestones.

• Proactively manage priorities and follow up on data requests or dependencies across teams.

• Ensure analytical work is documented and organized so analyses can be repeated or updated efficiently.

Cross-Functional Collaboration

• Partner with marketing, finance, and operations teams to support analytical initiatives.

• Partner with finance, operations, and IT to access new sources of data.

• Work closely with leadership to investigate trends and test growth hypotheses.

Qualifications

• Bachelor’s degree in Data Science, Statistics, Economics, Mathematics, Computer Science, or a related analytical field.

• 2–4 years of experience in data analysis, business intelligence, or a similar role.

• Strong proficiency in Excel (advanced formulas, pivot tables, data manipulation).

• Experience building dashboards in Power BI or Tableau.

• Familiarity with SQL or Python is an asset.

Skills & Competencies

• Strong analytical and problem-solving skills.

• Ability to structure and analyze complex datasets.

• Comfortable working with imperfect or messy datasets and structuring them to support analysis.

• Intellectual curiosity and a desire to explore business problems using data.

• Ability to translate data into clear insights for non-technical stakeholders.

• Strong attention to detail and data accuracy.

• Strong organizational and project management skills, with the ability to structure analytical workstreams and manage timelines across multiple initiatives.