Position Summary:
The Senior Market Access Specialist - Data and Analytics, plays a critical role in enabling data-driven and AI-enabled decision-making across the Market Access organization and the Sales Field. This position is responsible for building end-to-end data and AI solutions - from raw data ingestion through analytics, visualization, predictive modeling, and storytelling - that make the organization smarter, more actionable, and better equipped to compete in the pharmaceutical industry.

The role leverages SQL, Power BI, AI/Generative AI (e.g., Microsoft Copilot, Azure OpenAI), and other modern analytics tools to transform fragmented pharma datasets (payer claims, wholesaler EDI, copay, PAP, and specialty pharmacy journey data) into clear, decision-ready insights. The Sr. Specialist partners closely with Market Access leadership, Trade, Payer Strategy, Patient Services, Sales Operations, Finance, IT, and external partners (specialty pharmacies, wholesalers, copay/PAP vendors) to translate business needs into technical and AI-powered solutions that drive revenue growth, protect gross-to-net, and improve the patient experience.

Key Responsibilities:
Data Solution Development:
• Design, build, and maintain SQL-based data models and Power BI dashboards that integrate payer claims, EDI 852/867, copay, PAP, and specialty pharmacy data
• Develop automated, production-grade reporting solutions that replace manual spreadsheets and accelerate decision cycles
• Build self-service analytics products tailored to Market Access leaders, payer account managers, trade managers, and field sales teams
• Apply best-in-class data engineering practices (data validation, version control, documentation) to ensure scalability and reliability
• Embed AI and Generative AI capabilities (e.g., Microsoft Copilot, Azure OpenAI, natural language query) into dashboards and solutions to enable conversational analytics and faster self-service insight discovery
• Prototype and operationalize machine learning models (e.g., abandonment risk, persistence prediction, gross-to-net forecasting) in partnership with IT and data science partners

Market Access Insights & Decision Support:
• Analyze payer patient claims data to surface coverage trends, prior auth/step edit impact, prescription abandonment, and net price dynamics
• Mine wholesaler EDI 852 (inventory) and EDI 867 (sales-out) data to identify channel trends, demand signals, and inventory health across distribution partners
• Translate patient services data (copay utilization, max-out rates, PAP enrollment velocity, specialty pharmacy fill rates and time-to-fill) into actionable insights for patient experience improvement
• Partner with Payer Strategy, Trade, Patient Services, and Field Sales to define KPIs and answer the "so what" behind the data
• Leverage AI-driven anomaly detection and pattern recognition to proactively flag coverage shifts, channel disruptions, and patient access risks before they impact performance

Patient Journey & Specialty Pharmacy Analytics:
• Build prescription journey analytics in partnership with specialty pharmacy partners to track each patient touchpoint - referral, BV/PA, copay adjudication, first fill, refill, persistence, and discontinuation
• Identify drop-off points, friction, and intervention opportunities across the patient journey
• Provide insights that inform copay program design, PAP eligibility expansion, and EMR/e-coupon optimizatio