Director, Market Access Analytics

OGILVY HEALTH: WE INSPIRE PEOPLE AND BRANDS TO IMPACT THE WORLDGuided by this vision, Ogilvy Health, part of WPP, combines borderless creativity, scientific precision and cultural fluency to build healthcare’s most influential movements. 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.For more information on us, visit OgilvyHealth.com, or follow Ogilvy Health on LinkedIn, Instagram, Facebook, X, and Threads.About WPPWPP 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 DoLead 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 Need8+ 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. The base salary range for this position at the time of this posting is indicated below. Individual compensation varies based on job-related factors, including location, business needs, level of responsibility, experience, and qualifications. We offer a competitive benefits package, click here for more details.Pay Range$100,000—$230,000 USDAt 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 View email address on click.appcast.io. 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.