O

Ogilvy

Global agency delivering advertising, marketing, PR

Director – Market Access Analytics

Data AnalysisConfirmed live in the last 24 hours
Full-timeParsippany-Troy Hills, NJ, USA$100k - $230kRemote

About the Job

Requirements

  • At least 8 years of analytics experience within pharmaceutical, life sciences, market access, managed markets, or a closely related data environment.
  • At least 5 years of hands-on MySQL experience, including querying, joining, transforming, aggregating, troubleshooting, and validating large datasets.
  • Significant experience with pharmaceutical data, including formulary or coverage, prescription or medical claims, health care professional, payer or plan, and lives data.
  • Advanced Microsoft Excel skills, including analyzing, validating, and presenting complex data.
  • Experience harnessing artificial intelligence to streamline data processes.
  • Experience designing analytical methodologies and translating business needs into detailed data and product requirements.
  • Strong understanding of data quality, integration, attribution, aggregation, and validation methodologies, and experience using a revision control system in a production environment such as SVN, Git, or Perforce.
  • Exceptional client communication and presentation skills, including communicating complex analytical concepts to non-technical audiences.
  • Ability to collaborate cross-functionally and manage multiple complex workstreams.
  • Strong critical-thinking and problem-solving skills, including developing solutions to complex data challenges.
  • Bachelor's degree required.
  • Demonstrated curiosity and proficiency in using generative artificial intelligence and applicable emerging technologies, with the ability to adapt to new tools and integrate artificial intelligence responsibly into day-to-day work.

Responsibilities

  • Lead timely implementation of data solutions supporting proprietary market access products, field-facing tools, and custom client analytics.
  • Integrate and analyze pharmaceutical data sources, including formulary and coverage data, prescription and medical claims, health care professional data, payer and plan hierarchies, lives, geographic alignment, and customer relationship management data.
  • Translate complex business questions into analytical methodologies, business rules, data requirements, and scalable solutions.
  • Use MySQL, advanced Microsoft Excel, Power BI, and other analytical tools to manipulate, integrate, analyze, and validate large datasets and troubleshoot complex data issues.
  • Apply pharmaceutical reimbursement knowledge, including payer channels, formulary coverage, utilization management, payer and pharmacy benefit manager relationships, plan structures, and patient access dynamics.
  • Develop methodologies that translate market access data into actionable health care professional-, account-, payer-, geographic-, and national-level insights and field-facing messages.
  • Own quality control and validation of analytical methodologies and client deliverables, including investigating and reconciling discrepancies across data sources and systems.
  • Serve as the analytics and market access subject matter expert throughout product development, including requirements, development, testing and validation, launch, data migrations, recurring refreshes, and enhancements.
  • Partner with development, user experience, account, strategy, production, and external data-provider teams to ensure solutions are accurate, scalable, actionable, and delivered on time.
  • Serve as a senior analytics subject matter expert in client meetings and pre- and post-sale discussions, communicating methodologies, findings, limitations, and recommendations.
  • Establish efficient, repeatable processes and high standards for analytical rigor and quality.
  • Remain hands-on as needed to investigate data, troubleshoot MySQL queries, perform Excel-based analyses, validate methodologies, and resolve complex data challenges.
  • Manage and develop members of the analytics team.

Desired Qualifications

  • Understanding of pharmaceutical market access and reimbursement, including commercial, Medicare, and Medicaid channels, payer and plan structures, formulary coverage, and utilization management.
  • A STEM degree, an advanced degree, or equivalent experience.
  • Experience with pharmaceutical market access data sources such as IQVIA, MMIT, Symphony Health, or similar platforms.
  • Experience developing health care professional- or account-level market access analytics and field-facing solutions.
  • Familiarity with Veeva or other pharmaceutical customer relationship management and field enablement platforms.
  • Experience with payer hierarchies, pharmacy benefit manager relationships, geographic attribution, health care professional alignment, product launches, or major data migrations.

About the Company

Ogilvy

Global agency delivering advertising, marketing, PR

Ogilvy is a global advertising, marketing, and public relations agency that helps brands create and manage their identity and experiences. It combines brand design, experiential marketing, storytelling, and media execution across campaigns, digital marketing, PR, and consulting, with revenue from creative and strategic fees as well as media placements and performance-based commissions. Compared with competitors, Ogilvy offers a wide, integrated set of capabilities and a long-standing global presence to deliver cohesive brand solutions across channels. Its goal is to help clients grow their business and build lasting brand loyalty through well-crafted brand experiences and narratives.

Company size
10,001+
Company stage
Acquired
Total funding
$864M
Headquarters
New York City, New York
Founded
1948

Recently Posted Jobs

Explore more opportunities at Ogilvy

See more jobs