Business Analytics Specialist (Pharma Trade Data)

Location: Ridgefield, CT (Hybrid preferred; Remote considered for strong candidates) Schedule: Monday–Friday, 8 am–5 pm (40 hrs/week) Contract Length: 12 Months Overview: This role supports Trade & Distribution Analytics function, providing high-level analytical insights across pharmaceutical trade channels. The focus is on understanding how product flows from manufacturer → wholesaler → trade partner → pharmacy, and identifying where the organization may be losing revenue or facing inefficiencies. The specialist will analyze wholesaler inventory data, shipment trends, pricing adjustments, rebates/chargebacks, and related distribution metrics. They will apply analytical skills (SQL + Python/R) to deliver deep-dive insights, create KPIs, investigate root causes, and recommend actions to optimize trade performance. This position is not a forecasting role—it is hands-on trade data analysis involving operational details such as EDI files, price changes, and inventory movement. Key Responsibilities: • Analyze pharmaceutical trade data to understand product distribution across wholesalers, trade partners, specialty pharmacies, and retail channels. • Work deeply with EDI data sets: 1. 849 – Inventory movement & research report 1. 852 – Inventory activity report 1. 867 – Sales & product transfer report • Evaluate: 1. Shipment trends 1. Wholesaler inventory levels 1. Inventory vs. sales discrepancies 1. Pricing adjustments, debits, chargebacks, returns • Conduct root cause analysis and develop actionable insights on where revenue leakage may be occurring. • Build KPIs and tracking metrics across trade operations. • Support Marketing & Sales with insights on inventory availability, geographic gaps, and trade partner performance. • Evaluate distribution challenges, such as: 1. Backlogs 1. Delayed shipments 1. Price changes impacting rebates • Translate complex trade data into clear, meaningful narratives for cross-functional teams. • Use SQL + Python/R to clean, manipulate, summarize, and visualize large datasets. • Collaborate with Trade Operations, Commercial, Supply Chain, and Marketing Analytics teams. Required Qualifications (Must Have): • Bachelor’s degree in Mathematics, Statistics, Engineering, Business/Data Analytics, or related field. • 5–6+ years of hands-on experience with pharmaceutical trade datasets (must include 849, 852, 867). • Strong knowledge of wholesaler data and distribution systems involving: 1. McKesson 1. Cardinal Health 1. AmerisourceBergen (Cencora) 1. CVS / CVS Specialty Hands-on experience analyzing: 1. Inventory movement 1. Price changes 1. Chargebacks 1. Returns 1. Rebates • Strong skills in SQL and either Python or R. • Ability to perform data cleaning, summarization, KPI creation, and visualization (Power BI or similar). • Experience delivering strategic insights and root-cause analysis. • Ability to work Eastern or Central time zone hours. Preferred (Nice-to-Have): • Experience in medical device trade analytics (manager confirmed acceptable). • Knowledge of marketing mix modeling or promotional analytics. • Experience with Databricks, Power BI, or SAS (tools are flexible). • Experience in commercial operations, GTN, or pharma manufacturer analytics. Why This Role Is Unique: • This a specialized and high-impact role. • You will directly help the company understand where money is lost, how pricing changes affect rebates, and how effectively inventory flows through the channel. • Opportunity to work closely with Trade Operations leadership and influence major business decisions. Interview Process: • Technical interview with SQL/R/Python + data skills reviewer • Second interview with trade subject matter expert • Final conversation with the hiring manager