Director, Market Access Analytics (Remote)

Ogilvy Health US; Parsippany-Troy Hills (NJ); Remote; USD 100,000 - 230,000; Full time

Job summary

Ogilvy Health US is seeking an experienced Director of Market Access Analytics to lead data strategy, development, and delivery of proprietary market access solutions and client analytics. You will manage an analytics team, work with clients, and translate complex datasets into actionable insights for field teams.

The role combines hands-on data work with strategic leadership, requiring deep knowledge of reimbursement, formulary data, and payer dynamics.

Qualifications

• 8+ years of analytics experience within pharmaceutical, life sciences, market access, managed markets, or a closely related data environment.
• Ideally, understanding of pharmaceutical market access and reimbursement, including commercial, Medicare, and Medicaid channels, payer and plan structures, formulary coverage, and utilization management.
• Significant experience with pharmaceutical data, including formulary/coverage, prescription or medical claims, HCP, payer/plan, and lives data.
• 5+ years hands-on MySQL skills, with demonstrated ability to query, join, transform, aggregate, troubleshoot, and validate large datasets.
• Advanced Microsoft Excel skills and demonstrated ability to analyze, validate, and present complex data.
• Experience harnessing AI 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 (i.e. SVN, Git, Perforce).
• Exceptional client communication and presentation skills, including the ability to translate complex analytical concepts for non-technical audiences.
• Proven ability to collaborate cross‑functionally and manage multiple complex workstreams.
• Strong critical‑thinking and problem‑solving skills with a demonstrated ability to develop innovative solutions to complex data challenges.
• Bachelor's degree required; STEM degree, advanced degree or equivalent experience preferred.

Responsibilities

• Lead the 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, HCP data, payer and plan hierarchies, lives, geographic alignment, and CRM data.
• Translate complex business questions into analytical methodologies, business rules, data requirements, and scalable solutions.
• Use MySQL, advanced Microsoft Excel, Power BI and other analytic tools to manipulate, integrate, analyze, and validate large datasets and troubleshoot complex data issues.
• Apply deep knowledge of pharmaceutical reimbursement, including payer channels, formulary coverage, utilization management, payer/PBM relationships, plan structures, and patient access dynamics.
• Develop methodologies that translate market access data into actionable insights and field-facing messages.
• Own quality control and validation of analytical methodologies and client deliverables, including investigation and reconciliation of discrepancies across data sources and systems.
• Serve as the analytics and market access subject matter expert throughout the product development lifecycle, including requirements, development, testing and validation, launch, data migrations, recurring refreshes, and enhancements.
• Partner with development, UX, 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, clearly communicating complex 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.

Skills

Analytics leadership

MySQL querying

Advanced Excel

Power BI

AI in data processes

Cross-functional collaboration

Client communication

Problem solving

Strategic thinking

Project management

Education

Bachelor's degree in STEM or related field

Tools

MySQL

Excel

Power BI

Git/SVN/Perforce (revision control)

Job description

Director, Market Access Analytics (Remote)

Parsippany, New Jersey

OGILVY HEALTH: WE INSPIRE PEOPLE AND BRANDS TO IMPACT THE WORLD

Guided by this vision, Ogilvy Health, part of WPP, combines borderless creativity, scientific precision, cultural fluency, and AI-enabled capabilities to build healthcare's most influential movements. We believe the future belongs to those who can seamlessly blend human ingenuity with emerging technologies, using AI not simply as a tool, but as a catalyst for deeper insights, faster problem solving, and more impactful work. We drive measurable impact and category-defining growth for brands ready to shape what's next. Our approach is powered by fearless creativity that dares to be different, sparks emotional connections, and inspires action, ensuring cultural resonance. Scientific precision translates complex data into stories that resonate, while our impact‑obsessed mindset focuses on delivering real‑world outcomes.

WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth. For more information, visit WPP.com.

About the Role

Ogilvy Health Market Access brings together market access strategy, analytics, technology, and creative capabilities to help pharmaceutical, biotechnology, and healthcare clients navigate the complexities of reimbursement and patient access. We transform complex access information into actionable solutions that support clients and field organizations throughout the product lifecycle.

We are seeking an experienced Market Access Analytics leader to drive the data strategy, development, and delivery of our proprietary market access solutions and custom analytics offerings. This individual will work closely with clients and internal teams to translate complex pharmaceutical market access data into accurate, actionable solutions for clients and field teams.

The Director will manage and develop members of the analytics team while remaining hands-on with complex data challenges, solution design, validation, and client deliverables.

What You’ll Do

• Lead the 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, HCP data, payer and plan hierarchies, lives, geographic alignment, and CRM data.
• Translate complex business questions into analytical methodologies, business rules, data requirements, and scalable solutions.
• Use MySQL, advanced Microsoft Excel, Power BI and other analytic tools to manipulate, integrate, analyze, and validate large datasets and troubleshoot complex data issues.
• Apply deep knowledge of pharmaceutical reimbursement, including payer channels, formulary coverage, utilization management, payer/PBM relationships, plan structures, and patient access dynamics.
• Develop methodologies that translate market access data into actionable HCP-, account-, payer-, geographic-, and national-level insights and field-facing messages.
• Own quality control and validation of analytical methodologies and client deliverables, including investigation and reconciliation of discrepancies across data sources and systems.
• Serve as the analytics and market access subject matter expert throughout the product development lifecycle, including requirements, development, testing and validation, launch, data migrations, recurring refreshes, and enhancements.
• Partner with development, UX, 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, clearly communicating complex 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.

What You’ll Need

• 8+ years of analytics experience within pharmaceutical, life sciences, market access, managed markets, or a closely related data environment.
• Ideally, understanding of pharmaceutical market access and reimbursement, including commercial, Medicare, and Medicaid channels, payer and plan structures, formulary coverage, and utilization management.
• Significant experience with pharmaceutical data, including formulary/coverage, prescription or medical claims, HCP, payer/plan, and lives data.
• 5+ years hands-on MySQL skills, with demonstrated ability to query, join, transform, aggregate, troubleshoot, and validate large datasets.
• Advanced Microsoft Excel skills and demonstrated ability to analyze, validate, and present complex data.
• Experience harnessing AI 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 (i.e. SVN, Git, Perforce).
• Exceptional client communication and presentation skills, including the ability to translate complex analytical concepts for non-technical audiences.
• Proven ability to collaborate cross‑functionally and manage multiple complex workstreams.
• Strong critical‑thinking and problem‑solving skills with a demonstrated ability to develop innovative solutions to complex data challenges.
• Bachelor's degree required; STEM degree, advanced degree or equivalent experience preferred.

Preferred Experience

• Experience with pharmaceutical market access data sources such as IQVIA, MMIT, Symphony Health, or similar platforms.
• Experience developing HCP- or account-level market access analytics and field-facing solutions.
• Familiarity with Veeva or other pharmaceutical CRM/field enablement platforms.
• Experience with payer hierarchies, PBM relationships, geographic attribution, HCP alignment, product launches, or major data migrations.

How We’ll Support You

Ogilvy celebrates its people. Fully. Enthusiastically. Unhesitatingly. We’ll empower you with the tools you’ll need to succeed. We’ll give you the autonomy to seek out new paths and better ways of doing things. We’ll support you with colleagues who are experts in their disciplines, drawn from across the Ogilvy network. And we’ll provide opportunities for you to do work of which you’ll be proud, with people you’ll be proud to call your teammates.

Pay Range

$100,000 - $230,000 USD

At Ogilvy, our people are at the heart of what we do: a creative agency that sparks game-changing ideas across culture and business through collaboration, integrity, and a celebration of self-expression.

We believe in building powerful teams with purpose – and we relentlessly curate transformative initiatives that make our commitment to fairness, and equity a reality.

Our ultimate mission is to leave a positive impact on the world, creating a better future for all, while supporting and uplifting the global communities we serve. This is central to our mantra of Borderless Creativity.

Ogilvy is an equal opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

If you need any assistance seeking a job opportunity, or if you need reasonable accommodation with the application process, please contact us at [e-mail]. Please note that this contact is only for candidates who are requesting accommodation. Emails for other purposes, including application status requests, will not receive a response.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Ogilvy Health US’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.