Commercial Business Analyst

Brett Fisher Group•Lake Forest, CA

23h•Onsite

About The Position

The Commercial Business Analyst connects distributor data with commercial leadership decisions, working across data integration, financial analysis, sales compensation, and reporting. The role brings together information from multiple sources and makes it reliable and useful for commercial decision-making. It is an in-office position in Lake Forest, California. The analyst ingests, cleans, and standardizes sales files from independent distributors in different formats; normalizes customer, address, hospital affiliation, and service-type information; and tracks distributor adjustments, chargebacks, and product-level rebates. The role also uses command-line scripts, batch files, and file-staging workflows to prepare data for import. The position establishes and maintains sales performance baselines, calculates and audits monthly sales draws and quarterly commissions, and analyzes actual results against baselines and prior-year performance. The analyst identifies performance drivers, volume shifts, margin erosion, potential revenue losses, and territory-level net-new business, then partners with sales leadership to explain findings and inform territory performance and retention decisions. The role builds and maintains Excel data models, Power Query transformations, Power Pivot relational models, and Power BI dashboards and executive scorecards for sales trends, commission attainment, and pipeline health. Base salary is up to approximately $130,000, subject to confirmation. Bonus and benefits will be discussed as details are confirmed.

Requirements

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

Nice To Haves

Healthcare, medical device, or distributor-heavy industry experience.
Power BI skills, including DAX, report authoring, row-level security, dataset refreshes, and interactive dashboards.

Responsibilities

Ingest, clean, and standardize 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.
Establish and maintain sales performance baselines using prior-year results, historical run rates, and seasonal trends.
Calculate, audit, and disburse monthly sales draws according to compensation plans.
Calculate quarterly commissions and check quota attainment, split credits, and policy compliance.
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.
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.