Commercial Business Analyst

Brett Fisher Group

Lake Forest (CA)

On-site

USD 117,000 - 143,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Confidential MedTech company in Lake Forest, CA seeks a Commercial Business Analyst to connect distributor data with commercial leadership. You will work across data integration, financial analysis, sales compensation, and reporting to turn raw data into reliable insights.

Role covers baselines, draws, commissions, and BI tooling with Excel, Power Query, and Power BI. Requires a bachelor’s in a quantitative field and at least three years of relevant experience in a healthcare/distributor

Qualifications

  • Bachelor's degree in business analytics, data science, finance, statistics, information systems, or related quantitative field.
  • At least three years as a business analyst, sales operations analyst, or commercial data analyst; healthcare/MedTech experience preferred.
  • Advanced Excel: formulas, XLOOKUP, INDEX/MATCH, pivot, macros/VBA.
  • Power Query, M code, data transformation pipelines; Power Pivot, DAX, relational data modeling.
  • Comfort with command-line tools and scripting to stage files.
  • Experience integrating external datasets and maintaining master data quality.
  • Ability to present financial/operational insights to senior leadership.
  • Power BI experience preferred: DAX, reports, row-level security, refreshes.

Responsibilities

  • Ingest, clean, and standardize large distributor sales files across formats.
  • Match and normalize customer names, hospitals, and service types for master data.
  • Track distributor adjustments, chargebacks, and rebates.
  • Use command-line scripts and file-staging for imports.
  • Establish baselines and calculate monthly draws and quarterly commissions.
  • Explain findings to sales leadership and aid territory decisions.
  • Build Excel models and Power BI dashboards for trends and pipeline health.

Skills

Advanced Excel
Power Query
Power Pivot
DAX
Data Modeling
Power BI
Batch Scripting
Data Integration
Presentation

Education

Bachelor's degree in business analytics or related quantitative field

Tools

Command Prompt
Batch Files

Job description

Confidential MedTech company | Commercial Business Analyst — working title | Lake Forest, California | In-office

This role connects distributor data with the decisions made by commercial leadership. The analyst will work across data integration, financial analysis, sales compensation, and reporting, bringing together information from multiple sources and making it reliable and useful. For someone who enjoys understanding the data behind the numbers, rather than just presenting a finished dashboard, the breadth of this position may be a strong fit.

What you'll work on
1. Distributor Data Integration & Master Data Management
  • Ingest, clean, and standardize large sales files from multiple independent distributors and across different formats.
  • Match and normalize customer names, addresses, hospital affiliations, and service types to create consistent commercial data.
  • Track and validate distributor adjustments, chargebacks, and product-level rebates.
  • Use command-line scripts, batch files, and file-staging workflows to organize incoming files before import.
2. Compensation, Draws, and Baseline Management
  • Establish and maintain sales performance baselines using prior-year results, historical run rates, and seasonal trends.
  • Calculate, audit, and disburse monthly sales draws in accordance with compensation plans.
  • Calculate quarterly commissions, checking quota attainment, split credits, and policy compliance.
3. Financial Analysis, Variance Reporting & Advisory
  • Compare actual results with baselines and prior-year performance to identify volume shifts, performance drivers, and margin erosion.
  • Identify potential revenue losses and model net-new business by sales territory.
  • Partner with sales leadership to explain findings and inform territory performance and retention decisions.
4. Business Intelligence & Advanced Tooling
  • Build and maintain Excel data models, dynamic pivot tables, and automated Power Query transformations for distributor data.
  • Use Power Pivot to build relational models across multiple tables for deeper analysis.
  • Develop and maintain Power BI dashboards and executive scorecards covering sales trends, commission attainment, and pipeline health.
Experience and skills

The supplied job description calls for:

  • A bachelor's degree in business analytics, data science, finance, statistics, information systems, or a related quantitative field.
  • At least three years of experience as a business analyst, sales operations analyst, commercial data analyst, or in a relevant role. Healthcare, medical device, or distributor-heavy industry experience is preferred in the written description.
  • Advanced Excel skills, including formulas, XLOOKUP, INDEX/MATCH, pivot tables, and macros/VBA.
  • Power Query proficiency, including M code and data transformation pipelines, plus Power Pivot, DAX, and relational data modeling.
  • Comfort using Command Prompt or batch scripting to organize and stage files.
  • Experience combining external datasets, matching customer and hospital records, and maintaining master data quality.
  • Ability to present complex financial and operational insights to executive sales leadership.
  • Power BI skills are preferred, including DAX, report authoring, row-level security, dataset refreshes, and interactive dashboards.
Practical details
  • Location: Lake Forest, California; in-office.
  • Base salary: Up to approximately $130,000, subject to confirmation. Bonus and benefits will be discussed as details are confirmed.
About FSG

Founded in 2010, Fisher Search Group is an independent MedTech commercial talent intelligence and executive recruiting firm. FSG connects recruiting, industry insight, its Leadership Podcast and The Decision Rooms.
Learn more: https://fishersearchgroup.us

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

In-Office MedTech Commercial Data Analyst – Insights & BI
In-Office MedTech Commercial Data Analyst – Insights & BI

Brett Fisher Group • Lake Forest (CA)

On-site
USD 117,000 - 143,000
Business Data Analyst
Business Data Analyst

Fresenius Kabi USA • Lake Zurich (IL)

Hybrid
USD 65,000 - 85,000
Medical, dental, and vision coverage
401(k) with company contribution
Life insurance
+1
Business Data Analyst
Business Data Analyst

Fresenius • Lake Zurich (IL)

Hybrid
USD 65,000 - 85,000
Medical, dental & vision coverage
Life insurance
Disability coverage
+2
Business Data Analyst
Business Data Analyst

Fresenius Kabi • Lake Zurich (IL)

Hybrid
USD 65,000 - 85,000
Medical, dental and vision coverage
Life insurance
401K with company contribution
+1
Commercial Systems Analyst (Central Or Eastern time zone)
Commercial Systems Analyst (Central Or Eastern time zone)

Distalmotion SA • United States

Remote
USD 80,000 - 110,000
Medical
Dental
Vision
+1
Commercial Systems Analyst (Central Or Eastern time zone)
Commercial Systems Analyst (Central Or Eastern time zone)

Distalmotion SA • Tallahassee (FL)

On-site
USD 80,000 - 110,000
Medical
Dental
Vision
+1
Commercial Systems Analyst (Central Or Eastern time zone)
Commercial Systems Analyst (Central Or Eastern time zone)

Distalmotion • Florida

On-site
USD 75,000 - 110,000
Medical
Dental
Vision
+1
Commercial Systems Analyst (Central Or Eastern time zone)
Commercial Systems Analyst (Central Or Eastern time zone)

Distalmotion • Cleveland (OH)

On-site
USD 70,000 - 110,000
Medical
Dental
Vision
+1
Commercial Systems Analyst (Central Or Eastern time zone)
Commercial Systems Analyst (Central Or Eastern time zone)

Distalmotion SA • Florida

On-site
USD 85,000 - 115,000
Medical
Dental
Vision
+1
Commercial Development Analyst
Commercial Development Analyst

Mast-Jägermeister US, Inc. • City of White Plains (NY)

On-site
USD 85,500 - 104,500
Highly competitive compensation packages
Comprehensive medical, dental, and vision insurance
Matching 401(k) plan
+2