Analyst – Commercial Contract Administrator, Analytics, Automation & AI Innovation

Posted 1hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Commercial contract administrator processing pharmaceutical rebates and detecting revenue leakage. Using SQL, Excel, Power BI, and AI automation to improve Lilly’s payment operations.

Responsibilities:

  • Build technical knowledge of Contract Administration procedures, systems, contracting language, and product knowledge
  • Understand customers including PBMs, HMOs, and Commercial/Part D payers and their requirements
  • Develop understanding of healthcare industry trends affecting contracts and rebates
  • Develop working knowledge of AI/ML tools used in Revenue Defender
  • Build relationships with internal partners across Contract Development, Legal, Government Pricing, Field Account Managers, Gross-to-Net, IT, and Purchase-to-Pay/Treasury
  • Develop customer-peer relationships, proactively resolve issues, and identify mutually beneficial opportunities
  • Review preliminary contracts for Contract Administration issues and collaborate on final contract language
  • Manage contracts in the rebate system, including formulary status, rebate percentages, price groups, exhibits, and unique rebate strategies
  • Process rebate-system data to determine payment amounts and produce reports and Customer Payment Packets
  • Reconcile payment requests against actual payments, analyze variances, and investigate root causes
  • Route full payments for FRAP approval/signature and follow up to meet deadlines
  • Support Revenue Defender by identifying ineligible rebate submissions, compliance exceptions, and revenue leakage through pharmacy- and NDC-level analysis
  • Document findings and partner on recoupment and corrective action
  • Identify anomalies and patterns across large transactional data sets
  • Identify and implement process standardization, automation, and AI-enabled analytics improvements
  • Use AI-enabled analytics and automation for data validation, trend analysis, payment reconciliation, variance detection, and account profiling
  • Generate and review trend reports to support planning, forecasting, and decision-making
  • Maintain Payment Packets for internal and external auditors
  • Participate in initiatives presenting AI-enabled ways of working
  • Support additional Contract Administration areas, including copay, Commercial and Part D rebate payments, and Revenue Defender, as business needs evolve

Requirements:

  • Bachelor's degree
  • 1 year of work experience in pharma rebates, PBM, healthcare finance, or data analytics; recent graduates with internship experience and/or coursework in a quantitative field may be considered
  • Authorized to work in the United States on a full-time basis
  • No work authorization or visa sponsorship provided
  • Preferred degree in Business, Finance, Economics, Data Analytics, Management Information Systems, Information Technology, or another analytical discipline
  • Work experience or coursework demonstrating analytical capabilities
  • Teamwork and customer service skills
  • Experience with data flow, internal controls and processes, and system connectivity
  • Attention to detail
  • Familiarity with AI-enabled analytics and automation tools
  • Knowledge of pharmacy claim data and related systems
  • Working knowledge of SQL for querying and analyzing rebate and claims data in a data warehouse environment
  • Advanced Excel skills, including pivot tables, Power Query, and formula-based reconciliation of large data sets
  • Experience with Power BI or a similar business intelligence/visualization tool
  • Exposure to automation or scripting tools such as Power Automate or Python
  • Experience with a rebate management platform such as ICyte
  • Familiarity with pharmacy claims data structures such as NDC and NCPDP
  • Ability to identify data anomalies or patterns across large transactional data sets

Benefits:

  • Company bonus depending partly on company and individual performance
  • Company-sponsored 401(k)
  • Pension
  • Vacation benefits
  • Medical, dental, vision, and prescription drug benefits
  • Flexible benefits, including healthcare and dependent day care flexible spending accounts
  • Life insurance and death benefits
  • Time off and leave of absence benefits
  • Well-being benefits, including employee assistance program, fitness benefits, and employee clubs and activities