In-Office MedTech Commercial Data Analyst – Insights & BI

Brett Fisher Group

Lake Forest (CA)

On-site

USD 117,000 - 143,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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 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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Commercial Business Analyst
Commercial Business Analyst

Brett Fisher Group • Lake Forest (CA)

On-site
USD 117,000 - 143,000
MedTech Commercial Analytics Lead
MedTech Commercial Analytics Lead

Distalmotion SA • New Jersey

On-site
USD 90,000 - 130,000
Medical
Dental
Vision
+1
Hybrid Commercial Data Insights Analyst
Hybrid Commercial Data Insights Analyst

Fresenius Kabi USA • Lake Zurich (IL)

Hybrid
USD 65,000 - 85,000
Health insurance
Dental coverage
Vision coverage
+4
Hybrid Commercial Data Insights Analyst
Hybrid Commercial Data Insights Analyst

Fresenius • Lake Zurich (IL)

Hybrid
USD 65,000 - 85,000
Medical, dental & vision coverage
Life insurance
Disability coverage
+2
Commercial Insights & Strategy Analyst
Commercial Insights & Strategy 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
Manager / Senior Manager, Data Analytics
Manager / Senior Manager, Data Analytics

Melinta • Lake Forest (IL)

On-site
USD 100,000 - 188,000
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
Senior BI Developer & Analytics Lead for Supply Chain
Senior BI Developer & Analytics Lead for Supply Chain

Medline • Chicago (IL)

On-site
USD 101,000 - 152,000
Health insurance
401(k) contributions
Paid time off
Data-Driven Commercial Operations Analyst
Data-Driven Commercial Operations Analyst

Akumin® • United States

On-site
USD 75,000 - 105,000
Hybrid Data Analyst: Commercial Insights & Dashboards
Hybrid Data Analyst: Commercial Insights & Dashboards

Fresenius Kabi • Lake Zurich (IL)

Hybrid
USD 65,000 - 85,000
Medical, dental and vision coverage
Life insurance
401K with company contribution
+1